Manager - Business Intelligence

RSH (Malaysia) Sdn Bhd

1. Reporting directly to the senior management, I am doing various projects to derive business growth by providing critical insights for timely and informed decision-making. I am supporting various functions including Accounting, Treasury, FP&A, Procurement, Supply Chain, Merchandizing, Admin and Operations.
2. • Extensive use of DAX, effective visualizations, and Power Query in Power BI
3. • Super user of the Premium Workspace, managing RLS rules, and controlling user access rights
4. Key Accomplishments:
5. • Automated daily bank balance monitoring, fixed deposits, credit facilities, and vendor payments for multiple accounts in Asia region through Power BI dashboard, streamlining Treasury operations.
6. • Improved Procurement department efficiency with budget vs. actual review and procurement dashboard implementation.
7. • Created multiple comprehensive dashboards, including annual fiscal budget review dashboard for next three years, Sales and Inventory & Travel Desk dashboards, to provide critical insights for stakeholders and optimize business operations

Consultant - Business Intelligence

Bahrain Telecommunication Company (via Blutech)

1. I was deployed by my Pakistani employer as external consultant at Batelco. My primary responsibility was to utilize my expertise in data visualization to assist in the development of an analytical layer in the Enterprise Data Warehouse that was being designed in PostgreSQL. I also designed advanced
2. dashboards in Power BI to measure numerous KPIs, enabling various stakeholders to make data-driven decisions.
3. • Extensive use of DAX, data modeling and advanced visualizations techniques.
4. • RLS rules and user access controls and setting up of incremental refresh policies.
5. • Created “Semantic Layer” in Power BI to support self-service BI for business users.
6. • Development under Agile approach and project delivery in Sprints.
7. Key contributions:
8. • Developed and designed BI solutions in Power BI that addressed business questions and measured performance.
9. • Reviewed the existing BI structure and identified areas of improvement.
10. • Created effective models in Power BI and used DAX to derive insights.
11. • Organized discussions and collaborated with stakeholders for requirement gathering and brainstorming.
12. • Converted business requirements for data analytics into real-time solutions.
13. • Conducted System Integration Testing (SIT) and User Acceptance Testing (UAT)
14. • Conducted UAT and client demos to ensure project deliverables were executed.
15. • Worked with the analytical layer development team from a BI perspective.
16. • Conducted Target vs. Actual analysis and set up KPI scorecard, goals, and alerts in the cloud.

Business Intelligence Developer

Swipbox, Pakistan

1. SwipBox is a Danish company with an innovative parcel locker solution for logistics providers, retailers, and consumers. It’s more than a software company with a hardware solution and has offices across the Europe. Developed BI solutions in Power BI and Amazon QuickSight, following agile principles and scrum approach for SDLC.
2. Key responsibilities:
3. • Managed BI function, including capacity planning, sprint participation, and task finalization.
4. • Developed sprint tasks in Power BI with MySQL databases hosted on AWS.
5. • Utilized advanced DAX development for analytics with both Pro and Premium Per User Licenses.
6. • Managed existing BI environment for different clients in Europe.
7. • Conducted unit testing, provided QA support, and resolved queries.
8. • Delivered internal and external demos and deployed solutions to the live environment.
9. • Collaborated with internal teams and clients to convert data analysis needs into actual solutions.
10. • Troubleshot existing dashboards, conducted RCA, and implemented solutions.
11. • Conversion of existing BI dashboards on Amazon QuickSight.

Manager Business Intelligence

Global Pharmaceuticals (Pvt.) Ltd. Pakistan

1. Led the digital transformation of the company's supply chain by implementing efficient inventory management, cost reduction, production excellence, effective planning, and efficient distribution of over 400 SKUs, while providing complete visibility of SCM KPIs. Reviewed current SAP reports and converted them into smart dashboards in Power BI.
2. Overall, my contributions led to a significant improvement in the efficiency of the supply chain and helped the organization achieve its corporate objectives.
3. Major achievements and contributions:
4. • Built a data culture in the organization by consolidating group-level dashboards and reports from the data in the SAP HANA database.
5. • Developed Power BI dashboards to create complete visibility of the supply chain, providing real-time visibility to different stakeholders.
6. • Created a comprehensive inventory analysis dashboard for the CEO, resulting in inventory optimization, loss reduction, and effective planning.
7. • Developed a model for sales and stock visibility at the national level, enabling smart distribution of around 400 commercial SKUs.
8. • Designed a comprehensive monthly performance review system for the top management.
9. • Developed dashboards on inventory, production, sales, imports, planning, warehousing, and inventory management.
10. • Developed smart data models, utilized SQL for querying, applied Power Query transformations, and utilized DAX for analytics.
11. • Conducted change management and provided training to business users.

Manage Business Intelligence

Highnoon Laboratories Limited, Pakistan

1. Under the leadership of Chief Operating Officer, the digital transformation I brought resulted in a complete revamp of the Group’s Supply Chain, increased production by 20% with better planning, reduced inventory cost, and supported efficient distribution of over 350 SKUs.
2. Key accomplishments and projects.
3. • Led end-to-end BI implementation and fostered a data-driven culture within the organization.
4. • Developed Power BI dashboards for production, sales, procurement, inventory, employee costs, and financials by integrating data from IBM Db2 and SQL Server databases.
5. • Acted as the main point of contact for all business users' data and reporting needs.
6. • Developed “Decision Support System” which resulted in savings in millions.
7. • Developed “Smart Distribution Management System” for efficient distribution and complete visibility of over 350 SKUs' primary and secondary sales.
8. • Invented “New Products Development Dashboard”, which speeded up new products launch.
9. • “Sales vs Forecast Dashboard” for review of team-wise target vs achievement.
10. • Data analysis with DAX, Power Query transformations, RLS and incremental refresh.
11. • Developed a "Daily Production Report" for visibility on production as per plan, monthly “Operations Division performance review”, and created an employee overtime cost analysis dashboard for cost control purposes. Additionally, published, shared, and scheduled refreshes for Power BI dashboards.

Bahauddin Zakariya University Multan, Pakistan

Business and Management

Bahauddin Zakariya University Multan, Pakistan

Accounting and Commerce