Muhammad Sohail Akram

● Collaborated extensively with the P4 Consultants Team to extract, discover, and analyze critical business data, resulting in significant enhancements to the overall business model. Demonstrated expert-level proficiency in analyzing extensive datasets, effectively identifying trends, patterns, and insights, and deriving valuable conclusions from the data. Through fostering strong partnerships with stakeholders, I gained a deep understanding of their data analysis objectives, empowering me to design SQL queries that precisely meet their requirements and deliver impactful results on Tableau dashboards.
● Engaged closely with the sales and commercial management team to study and document business requirements for a robust BI solution. Designed and constructed dashboards in Tableau to analyze product sales, promotion, and customer data, effectively tracking and improving sales KPIs. Provided 24/7 technical support to business users, ensuring continuous system functionality and user satisfaction.
● Actively participated in the implementation of Salesforce CRM in the commercial and marketing departments, driving seamless adoption and process optimization.
● Participated in end-to-end implementation of InVan Mobile Sales system in 29 branches, & conducting a comprehensive study of business user requirements, evaluating software vendors, POC, UAT, and overseeing the successful installation and implementation of the software. The implemented modules included pre-sales, direct store delivery (DSD), and merchandising, optimizing sales order collection from super chain markets, direct product sales to shops, and efficient product display in super stores, ultimately streamlining commercial operations and enhancing customer service.
● Took on the responsibility of performing additional tasks as an App Admin, including setting up territory and route configurations, optimizing daily, weekly, and monthly journey plans, managing customers, validating credit, overseeing simple and seasonal promotions, managing discounts, and executing warehouse stock visibility.

Collaborated extensively with the P4 Consultants Team to extract, discover, and analyze critical business data, resulting in significant enhancements to the overall business model.
Demonstrated expert-level proficiency in analyzing extensive datasets, effectively identifying trends, patterns, and insights, and deriving valuable conclusions from the data.
Through fostering strong partnerships with stakeholders, I gained a deep understanding of their data analysis objectives, empowering me to design SQL queries that precisely meet their requirements and deliver impactful results on Tableau dashboards.
Engaged closely with the sales and commercial management team to study and document business requirements for a robust BI solution.
Designed and constructed dashboards in Tableau to analyze product sales, promotion, and customer data, effectively tracking and improving sales KPIs.
Provided 24/7 technical support to business users, ensuring continuous system functionality and user satisfaction.
Actively participated in the implementation of Salesforce CRM in the commercial and marketing departments, driving seamless adoption and process optimization.
Participated in end-to-end implementation of InVan Mobile Sales system in 29 branches, conducting a comprehensive study of business user requirements, evaluating software vendors, POC, UAT, and overseeing the successful installation and implementation of the software.
The implemented modules included pre-sales, direct store delivery (DSD), and merchandising, optimizing sales order collection from super chain markets, direct product sales to shops, and efficient product display in super stores, ultimately streamlining commercial operations and enhancing customer service.
Took on the responsibility of performing additional tasks as an App Admin, including setting up territory and route configurations, optimizing daily, weekly, and monthly journey plans, managing customers, validating credit, overseeing simple and seasonal promotions, managing discounts, and executing warehouse stock visibility.

As a seasoned Data Analyst and BI Developer, executed end-to-end project, with full life cycle of data analysis and business intelligence.
This includes requirements gathering, ETL processes, data modeling, and the development of impactful reports and interactive dashboards.
Leveraging advanced analytics techniques, such as data mining and predictive modeling, I uncover valuable insights and patterns, with expertise in SAP BO & QlikView, created visually appealing and user-friendly visualizations.
Collaborating with cross-functional teams, & ensure seamless integration and provide ongoing support for optimized decision-making.
In the second phase, Data Warehouse solution was designed and developed using Oracle Goldengate replication successfully, to address the BI & reporting performance issue.
By enabling real-time data synchronization and implementing performance optimizations, it ensured accurate and timely insights, empowering decision-makers with the information they needed.
As a team leader, successfully led the migration of 23 in-house apps from Forms 6i to Oracle Forms 11g, deploying them on Oracle WebLogic Server and Fusion Middleware 11g.
Consolidated eight DB/Apps servers into centralized database and application servers.
Integrated time attendance machines with Easy System and Oracle SSHR.
Additionally, developed the Smartdesk IT portal for logging user requests and complaints to the IT department.
Contributed as a team member in the implementation of Oracle SSHR in five business units.

MaxPro ERP Software development & implementation.
As a Senior Application Developer, I have accumulated extensive experience in the development of Oracle-based ERP software, specifically MaxPro, tailored for the real estate leasing business.
I actively participated in the design and development of modules such as Leasing, Finance, HRMS, Utility & Eclectic Billing, and Maintenance.
This involved studying and analyzing customer business requirements, documenting and customizing the software to optimize business operations and adhere to best practices.
Successfully installed Oracle DB 8i with Arabic language settings (AR8MSWIN1256) and uploaded Arabic master data, enabling the development of an Arabic version of the Tenant Leasing, AR, and CM modules.
I have also contributed to Oracle database administration, including tuning, backup, and restore operations.
This involved managing user privileges, table space, and refreshing development and test instances with production data on a regular basis.
I have been involved in Oracle DB upgrade projects, migrating from Oracle DB 8i to 9i, 10g R1, 10g R2, and 11g R1, R2.
We successfully migrated MaxPro App Ver. 6i to Oracle Developer Suite 10g, optimizing the user interface and streamlining application processes, resolved bugs and configured Arabic language support for reports.
Additionally, integrated customer payment and tenant maintenance request functionalities with the Khaldia Towers web portal.
In this project, we developed MaxPro reports & dashboard using Oracle Business Intelligence Enterprise Edition (OBIEE), and Oracle BI Publisher leveraging its capabilities to create robust and interactive reports and Dashboard that provided valuable insights into the MaxPro ERP system.
I collaborated with stakeholders to understand reporting requirements and designed interactive dashboards with drill-down and filter features.
By implementing data validation checks and optimizing report performance, I ensured data accuracy and enhanced the efficiency of the reports.
Through user acceptance testing and feedback, I refined the reports to meet evolving needs, ultimately enabling data-driven decision-making.
Additionally, I have been responsible for project planning, software design, testing, and deployment, ensuring successful implementation and integration on the client side.