Asad Ali

Hands-on Data Analyst / BI professional with practical experience across advanced Excel, Power BI and SQL, covering data transformation, modeling, ETL, data warehousing, DAX, reporting and dashboard development. Builds end-to-end solutions from raw data to actionable business findings through real project work, with Machine Learning knowledge in Python as a supporting analytical skill.

Data Science & Engineering Intern at Next-Bridge (CM IT Program) (2026-07 – Present)

• Commodity Market Analysis — Excel · Excel, Power Query, Power Pivot
• Combined multi-commodity historical data, transformed and standardized datasets in Power Query, and built a Power Pivot analytical model.
• Developed DAX measures and KPI reporting for annual performance, best/worst years and OHLC trends.
• Built an interactive dashboard to compare commodity performance over time and surface market trends and year-over-year findings.
• Airline Disruption & Loss Analysis — SQL · SQL Server, ETL, Data Warehouse, Azure
• Designed and populated an analytics database using bulk-load/insert scripts and data-layer concepts.
• Applied advanced SQL including joins, CTEs, views, and stored procedures to analyze disruptions & losses.
• Produced analytical outputs on operational impact, country-level disruption patterns and estimated vs actual financial losses.
• SPI Inflation Analysis, Pakistan — Power BI · Power BI, Fabric
• Collected data from different sources including the Pakistan Bureau of Statistics; parsed PDF files in Power Query and performed transformations with M-Code.
• Modeled complex tables into a star schema for efficient and accurate reporting and wrote DAX for analysis.
• Designed a 5-page dashboard for reporting and a detailed paginated report for management.

Data Management Officer at Daewoo Waste Management Company (DWMC) (2025-04 – 2026-04)

• Analyzed and validated operational and financial data, achieving 100% invoice accuracy across all billing cycles.
• Automated reporting workflows in MS Excel, reducing invoice processing delays by 60% and eliminating manual data entry bottlenecks.
• Performed cross-system data reconciliation ensuring consistency between payroll and financial records, significantly improving data reliability.

BS in Data Science – Islamia University Bahawalpur (2022-02 – 2026-02)