Asra Fatima

Power BI Developer/Data Analyst with 9+ years of experience in data analytics, business intelligence, and e-commerce reporting across retail and SaaS domains. Skilled in designing and developing interactive dashboards using Power BI, SQL, and DAX to deliver actionable business insights. Experienced in tracking key KPIs such as sales performance, customer retention, conversion rates, and revenue growth.

Strong expertise in building scalable data models using star schema design (fact and dimension tables). Proficient in automating data workflows using Azure Data Factory, dbt, Power Apps, and Power Automate. Experienced in integrating and transforming complex datasets from multiple sources including CRM, e-commerce platforms, and inventory systems.

Proven ability to collaborate with cross-functional teams across marketing, operations, and merchandising to define metrics and improve reporting efficiency. Adept at optimizing dashboard performance, ensuring data quality, and delivering real-time analytics solutions in fast-paced environments.

Power BI Developer/Data Analyst at BMO Bank of Montreal (2024-03 – Present)

• Developed and maintained interactive Power BI dashboards to track KPIs such as conversion rate, customer retention, and various metrics.
• Designed scalable data models using star schema (fact and dimension tables) to support large retail and marketplace datasets.
• Extracted, transformed, and Analyzed data using SQL from multiple sources, including e-commerce platforms, CRM systems, and inventory databases.
• Built and automated ETL/ELT pipelines using Azure Data Factory and dbt to streamline data ingestion and transformation.
• Implemented advanced DAX measures and calculated columns for KPIs such as revenue growth, CLV, and inventory turnover.
• Developed Power Apps solutions to enable business users to capture and manage operational data efficiently.
• Automated workflows using Power Automate, including data refreshes, alerts, approvals, and report distribution.
• Integrated Power BI, Power Apps, and Power Automate to build end-to-end data-driven applications and reporting solutions.
• Collaborated with cross-functional stakeholders (marketing, merchandising, operations) to define metrics and deliver actionable insights.
• Built real-time and near real-time dashboards to support pricing strategies, promotions, and campaign performance tracking.
• Ensured data quality and governance through validation checks, documentation, and standardized metric definitions.
• Optimized report performance using query folding, aggregations, and incremental refresh, improving dashboard efficiency.

Data Analyst at QNL LLC (2022-01 – 2024-02)

• Supported clients and internal stakeholders by translating business questions into clear analytical requirements and scalable reporting solutions.
• Analyzed structured sales, customer, and inventory datasets to identify trends, patterns, and performance drivers, and assisted in root cause analysis.
• Built and maintained dashboards and recurring reports in Power BI and Tableau to track KPIs.
• Wrote SQL queries to extract, transform, and analyse data from multiple source systems and reporting layers.
• Collaborated with cross-functional teams, including analysts and business stakeholders, to define metrics and ensure data consistency. Assisted in documenting KPIs, metric definitions, and analytics processes.
• Performed data quality validation to ensure accuracy, reliability, and trust in analytics outputs.
• Supported analytics initiatives, including KPI tracking, dashboarding, exploratory analysis, and foundational A/B testing, to inform business decisions.
• Communicated insights through data storytelling, clear data visualizations, written summaries, and stakeholder presentations.
• Proactively identified opportunities to improve reporting efficiency, dashboard usability, and analytical workflows.

Analyst at QNL LLC (2017-02 – 2021-12)

• Supported e-commerce operations through analysis of sales performance, inventory metrics, and customer behaviour data.
• Built and maintained Excel- and BI-based reports to track operational KPIs and business performance indicators.
• Partnered with business stakeholders to identify reporting gaps and evolving analytical requirements.
• Contributed to early analytics initiatives, transitioning from operational reporting to data-driven insights.
• Assisted in documenting analytics processes, metric definitions, and reporting standards to improve consistency and efficiency.

MTech in Computer Science & Engineering – Osmania University (2014 – 2016)

B.E. in Computer Science and Engineering – Osmania University (2010 – 2014)