BI Lead (Apr, 2024
–Present) at MNC
Drove performance optimization initiatives, reducing report processing times by up to 94% through strategic data model redesigns and DAX optimization.
Owned data modeling standards, guiding the implementation of Star and Snowflake schemas to ensure scalable, maintainable, and business-aligned analytics solutions.
Oversaw the stability and quality of BI environments, resolving high-impact reporting issues and preventing downtime across multiple client-facing dashboards.
Guided the adoption of Microsoft Fabric capabilities, including OneLake-based reporting, PySpark-driven data ingestion, and automated refresh orchestration using Data Pipelines.
Established controlled deployment practices by implementing Power BI Deployment Pipelines, enabling structured promotions across Dev, Test, and Production environments.
Led report-level modernization efforts, transitioning Power BI reports from on-premises data sources to Fabric Lakehouse connections using DirectQuery to improve freshness and performance.
Implemented data quality monitoring frameworks, defining threshold-based checks and configuring alerts via Data Activator to proactively identify and address data issues.
Ensured end-to-end data accuracy by backtracking KPIs to the lowest data grain and reconciling results across OneLake Lakehouse and SQL Server sources.
Directed the development of stakeholder-facing dashboards, translating business requirements into actionable insights across domains such as Supply Chain, Finance, Device History, Utilities, and R&D.
Reviewed and guided LookML development and SQL validation practices, ensuring consistency, correctness, and alignment with analytical best practices.
Mentored and onboarded BI team members, enabling independent dashboard delivery and improving overall team productivity.
Partnered cross-functionally with AI/ML teams, Data Engineers, Product Owners, and UX teams to align analytics initiatives with broader business objectives.
Operated within an Agile delivery model, prioritizing BI initiatives, managing parallel workstreams