Pavan S.
Senior Power BI Developer
Open to offersNew to PlatformAbout
Pavan S is a Senior Power BI Developer with a robust track record spanning over 8 years in delivering comprehensive Business Intelligence and Analytics solutions across diverse sectors such as sales, healthcare, insurance, and supply chain. Equipped with expertise in Power BI, DAX, and Azure Databricks, he excels at designing scalable semantic models and optimizing large datasets for enhanced performance. His strategic implementations have consistently enabled data-driven decision-making for global stakeholders. At McKinsey & Company, he led the design and development of scalable data models and executive dashboards. His tenure at GSK & Haleon saw him manage cross-functional teams and deliver enterprise analytics solutions. Pavan also contributed significantly to Cognizant and Dell Technologies, where he focused on transforming business requirements into actionable analytical solutions, utilizing his skills in SQL, data modeling, and report performance tuning to meet business-critical needs. Pavan S holds a Bachelor of Technology in Electronics & Communication Engineering from the National Institute of Technology, Puducherry.
Experience
Senior Power BI Developer
McKinsey & Company · 2024 — 2026Designed and implemented scalable enterprise data models utilizing Star Schema and Snowflake Schema methodologies to enhance data consistency and reporting efficiency. Developed executive dashboards, KPI scorecards, and interactive analytical reports to support strategic business decision-making. Built advanced DAX measures, calculated columns, and calculation logic for effective business insights. Established standardized Power BI development practices focusing on data modeling, DAX optimization, query folding, and report design to improve project quality and maintainability. Enhanced report performance through DAX tuning, aggregation strategies, and efficient connectivity models, achieving significant improvements in report load times and dataset refresh duration. Evaluated Power BI connectivity architectures aligned with performance and business requirements. Implemented Static and Dynamic Row-Level Security frameworks for data privacy and compliance. Managed the BI solution lifecycle, including stakeholder requirement gathering, solution design, development, deployment, governance, and post-production support.Assistant Manager | Power BI Developer | Project Manager | Scrum Master
GSK & Haleon · 2022 — 2024Led cross-functional teams in delivering analytics solutions across various business units, ensuring adherence to timelines and stakeholder expectations. Oversaw project planning, resource allocation, and stakeholder communication, while also managing risk mitigation and delivery governance. Facilitated Agile ceremonies such as Sprint Planning, Daily Standups, and Retrospectives. Mentored team members and established best practices to enhance productivity and team performance. Developed enterprise dashboards, KPI scorecards, and executive reporting solutions using Power BI and designed data models with complex DAX calculations for critical business reporting. Built secure reporting solutions with Row-Level Security and managed report deployments, subscriptions, and production support.Power BI Developer
Cognizant (Client: AXA XL) · 2021 — 2021Gathered business requirements and translated them into analytical solutions. Developed Power BI dashboards, reports, and KPI scorecards, while designing data models and transforming source data using Power Query. Delivered interactive visualizations and performance analytics to provide business insights.Power BI Developer
Dell Technologies – GSC Self Service · 2018 — 2021Created operational and executive dashboards for order management and supply chain analytics. Designed data models and executed data transformations via Power Query. Implemented Row-Level Security and role-based access control. Developed interactive visualizations and analytical reports while managing report deployment and refresh schedules.Power BI Developer
Dell Technologies – Customs Analytics · 2016 — 2018Developed calculated columns, measures, and KPIs using DAX. Created analytical reports with Power BI, Power View, and Power Map, publishing these to Power BI Service and mobile applications. Managed report deployments, refresh schedules, and production support for logistics and customs operations.
Skills & Expertise
Education
- Bachelor of Technology (B.Tech) – Electronics & Communication Engineering (ECE)National Institute of Technology, Puducherry (NIT-Py)
Interested in this professional?
Sign in as an employer to save this profile or invite Pavan S. to a job.
Sign in as an employer