Poonam Gupta

Microsoft Certified Power BI Data Analyst with 3+ years of corporate Business Intelligence experience across Finance, Sales, Procurement, and Supply Chain. Proficient in Power BI, DAX, SQL, ETL Pipeline Development, Data Modeling, and KPI Reporting across Snowflake, SAP HANA, Azure and SQL. Proven ability to interpret business user requirements and translate complex data into actionable Reports and Dashboards that drive informed decision-making.

Actively leveraging AI Agents, Microsoft Copilot, and Generative AI to enhance analytics, automate workflows, and improve data-driven decision-making.

Power BI Developer & Data Analyst - Saint-Gobain INDEC - Mumbai, India

(2023-07)

• Led end-to-end Power BI dashboard delivery across Finance, Sales, Procurement, and Supply Chain, engaging senior stakeholders for requirement gathering, data modelling, and governed deployment in Power BI Service.
• Integrated Snowflake, SQL Server, Azure SQL Database, SAP HANA, SharePoint & Excel via Power Query, enforcing Row Level Security (RLS), Workspace Governance, and Incremental Refresh for secure and scalable BI reporting.
• Developed and optimized ETL pipelines using Power Query (M Language) across Power BI Desktop and Dataflows covering data extraction, cleansing, transformation, and validation.
• Designed and deployed scalable Star & Snowflake Schema data models in Power BI with Fact & Dimension tables, ensuring high performance, data accuracy, and long-term scalability.
• Good understanding of data warehousing concepts, performance optimization, and scalable BI best practices
• Authored advanced DAX measures, calculated columns, and tables with Time Intelligence (MTD, QTD, YTD) and core DAX functions for financial and operational KPI reporting.
• Familiar with SDLC and Agile/Scrum methodologies.
• Led Power BI training and knowledge-sharing sessions for Sales, Finance, and Plant teams to drive self-service reporting adoption and analytics usage.
• Leveraged Microsoft Copilot in Power BI for AI-assisted report narratives and intelligent Q&A reducing insight turnaround time for business stakeholders and improving self-service analytics adoption.

Head of CS Department & Faculty - Academic Institution - Mumbai, India

(2014-03 - 2023-06)

Delivered Python, SQL, and database training across undergraduate programs. Transitioned to corporate BI in 2023.

M.Sc. - Information Technology - Sikkim Manipal University (2016)

B.Sc. - Information Technology - Western College of Commerce and Business Management (2012)