Muhammad Rohail

Dynamic Data Analyst, Full-Stack Developer, and Co-Founder of the One HRM web application holding an MBA in Supply Chain Management. I offer extensive expertise in Power BI, advanced data modeling, data analytics, workflow automation and supply chain operations and creating software solutions. Proven expert in architecting scalable automation solutions and delivering data-driven insights that optimize business performance and saves time.

Recognized with Gold, Silver, and Bronze Awards at GSK for excellence in process automation and continuous improvement within Global Demand Planning.

Demand CCC Analyst & Project Analyst at GSK - GlaxoSmithKline (2024-06 – Present)

• Support data governance initiatives across global markets to elevate data quality for Core Commercial Cycle (CCC) Pre and Post Demand Review tools and reports, improving forecasting accuracy and decision-making.
• Provide analytical support to Demand Forecasting Managers to run Core Commercial Cycle.
• Create automation of manual and lengthy task to save business time.
• Manage SAP APO data uploads, ensuring accuracy and consistency.
• Enabled cross-functional decision-making by providing reports and real time KPI tracking.
• Monitor milestones of provided strategic support to ensure timely delivery, while maintaining and enhancing dynamic dashboards for real-time performance tracking.
• Enhance operational resilience by implementing process improvements that reduced reporting errors.
• Developed an automated Process Management tool that reduced daily calls durations by 15 minutes saves 30+ man hours.
• Engineered WD1 file automation which eliminates significant manual intervention and boosting team operational efficiency by 70%.

Co-Founder & Technical Lead at OneHRM.pk (2026-03 – Present)

• Architected and deployed a full-scale Human Resource Management (HRM) (Desktop / Mobile) web application using Vite, React, and PHP/SQL.
• Managed the end-to-end product lifecycle, including domain acquisition, hosting configuration, and database schema design.
• Automated internal HR workflows including attendance, payroll, leave management, appraisals, and Provident Fund (PF), significantly improving data accuracy and operational efficiency.

Data Analyst / Power BI Developer / Supply Chain Analyst / MIS Expert at Musaji Adam & Sons (Importer & Distributor of Medical Devices) (2021-01 – 2024-12)

• Designed & deployed Data Warehousing System (online/offline).
• Developed advanced analytical models and Power BI dashboards (Imports/Cost/Sales/Forecasting/Admin) providing predictive insights for optimized inventory and cost reduction.
• Developed Power Apps for CRM and operational tracking.
• Managed SQL Server and integrated platforms (websites, reports, dashboards).
• Automated reporting processes and implemented cloud-based document management.
• Manage and Update Price list Portal with user controls and push security updates.

Supply Chain and Imports Executive at Musaji Adam & Sons (Importer & Distributor of Medical Devices) (2020-01 – 2021-12)

• Managed import documentation and bank clearance.
• Coordinated with freight forwarders and suppliers.
• Ensured timely clearance, avoiding detention/demurrage costs.
• Verified clearing bills and processed EIF transactions.

Operations In charge at Musaji Adam & Sons (Importer & Distributor of Medical Devices) (2017-01 – 2020-12)

• Managed inbound operations, local deliveries, and 2PL logistics.
• Validate Stock Transfer and Purchase Vouchers.
• Implemented cost-saving initiatives through forecasting.
• Designed specialized training programs to increase compliance.
• Maintain records of delivery time and sales to mitigate risk.
• Provide analysis tools for imports based on lead time.

Master of Business Administration in Supply Chain Management – Iqra University (2024)

Bachelors of Business Administration – Iqra University (2022)

Bachelors of Commerce – University of Karachi (2018)

Intermediate in Commerce – Govt. Premier College (2015)