Shahab Ali

Data Analyst and Business Intelligence professional with 13+ years of experience across government and enterprise environments, specializing in Power BI, Tableau, SQL, SAP BI, data modeling, ETL, Microsoft Fabric(OneLake, Lakehouse, Data Pipeline, Dataflow Gen2, Warehousing), dashboard development, reporting, and performance optimization. Experienced in translating business requirements into scalable BI solutions, integrating data from databases, data warehouses, APIs and flat files, and communicating actionable insights to technical and non-technical stakeholders. Strong background in SAP SD/MM, data governance, data quality, reporting lifecycle, and end-user enablement.

Business Intelligence Specialist - ST & IT Department, Government of Khyber Pakhtunkhwa

(2020-12)

• Design and develop BI solutions, interactive dashboards, reports, visualizations and metadata/data models using Power BI, Tableau, Google Data Studio and Foris BI.
• Translate business requirements into technical specifications and deliver BI solutions through the full lifecycle from discovery and development to deployment and support.
• Extract, cleanse, transform and integrate data from databases, data warehouses, APIs and flat files while maintaining data quality, integrity and consistency.
• Write and optimize complex SQL queries and stored procedures for robust analysis, reporting and operational decision support.
• Design analytical data models, including dimensional structures such as star and snowflake schemas, and define relationships for meaningful reporting.
• Troubleshoot BI solutions and optimize report/dashboard performance; respond to ad-hoc reporting and analytics requirements.
• Communicate analytical findings and insights effectively to technical and non-technical stakeholders.

Assistant Manager – SAP/MIS - Herbion Natural Pakistan - Karachi

(2020-10 - 2020-12)

• Developed and maintained Power BI, SAP BI and SQL-based reports and dashboards for business performance monitoring.
• Implemented Secondary Sales reporting and Primary Sales reporting using SAP BI and Power BI.
• Extracted and transformed business data for BI reporting while maintaining data integrity and reliability.
• Monitored KPIs and business metrics and supported performance analysis and decision-making.
• Supported BI platform configuration, optimization and reliability; collaborated with developers/designers and stakeholders.

SAP ERP & BI Analyst - FrieslandCampina Engro Pakistan - Karachi

(2013-04 - 2020-10)

• Delivered Business Intelligence solutions using Tableau, Power BI and SAP BI, including data modeling, reporting and dashboard development.
• Designed and implemented data models and supported extraction, transformation and loading of data into BI environments.
• Created customized reports and dashboards providing actionable insights to decision-makers.
• Supported data warehousing, BI application performance monitoring and optimization.
• Implemented data governance practices to support data quality, integrity and security.
• Worked extensively with SAP SD and SAP MM processes, including order-to-cash, procurement, inventory, vendor management, billing, reporting and supply-chain integration.
• Provided SAP Basis operational support including transport management, user/role administration, authorization support, backup monitoring, system-log review and troubleshooting.

MS - Information Security - NED University of Engineering & Technology (2014-08 - 2016-12) Karachi

BS - Computer Engineering - Sir Syed University of Engineering & Technology (2008-01 - 2012-03) Karachi