Abhey Mittal

Power BI Developer & Data Analyst

Hyderabad, India 2+ yrs exp 86 · Excellent

About

Power BI Developer and Data Analyst with 3+ years of experience delivering enterprise business intelligence and analytics solutions for global pharmaceutical stakeholders. Converts complex business requirements into scalable dashboards, standardized KPIs, validated semantic models, and actionable insights. Supported reporting across 45 markets and 800+ users, with demonstrated impact in automation, performance optimization, data quality, and stakeholder delivery.

Skills & Expertise (27)

Power BI Service Advanced

8.5/10

Years Exp

Power BI Desktop Advanced

8.5/10

Years Exp

Data Modeling Advanced

8.0/10

Years Exp

Data Visualization Advanced

8.0/10

Years Exp

DAX Advanced

8.0/10

Years Exp

SQL Intermediate

7.5/10

Years Exp

Agile delivery Intermediate

7.0/10

Years Exp

ETL Intermediate

7.0/10

Years Exp

Business Analysis Intermediate

7.0/10

Years Exp

Python Intermediate

6.5/10

Years Exp

Data Validation Documentation Stakeholder Management Jira UAT Requirements Gathering Excel Data Reconciliation Row-Level Security Semantic Modeling Power Query Data Transformation Alteryx Snowflake Performance Tuning Dashboard Development KPI development

Work Experience

Analyst

Novartis Healthcare

May 2026 - Present

Manage and enhance 3 enterprise Power BI dashboards across 45 markets and 800+ users through feature delivery, validation, onboarding, and production support. Reduced dashboard refresh and load time by 30% by optimizing DAX measures, model relationships, and Power Query transformations. Completed 90% of enhancements within agreed delivery timelines through Jira-based tracking, prioritization, and stakeholder alignment. Reduced recurring manual reporting effort by 30 person-days per market annually through dashboard automation and standardized reporting processes. Develop and validate DAX measures, KPI definitions, semantic-model rules, and reconciliation checks to improve consistency and reliability across enterprise reporting. Delivered analytical capabilities covering CVA cohorts, HCP distribution, opportunity growth, RTE compliance, period-over-period trends, and Performance 360 KPIs. Standardized ALPER operations through KPI documentation, technical transition, model cleanup, and a monthly refresh standard operating procedure (SOP).

Data Analyst, Deputed to Novartis Healthcare

Randstad India Pvt. Ltd.

Jul 2025 - Apr 2026

Built approximately 40 interactive Power BI visuals across 35+ European markets for KPI and executive reporting. Developed DAX and KPI logic, optimized data models, implemented RLS, and processed Snowflake datasets containing more than one million rows. Delivered validated reporting used by 200+ stakeholders, including country leads.

Data Analyst, Deputed to Novartis Healthcare

PharmaScroll Research

Jul 2024 - Jun 2025

Delivered multi-country brand-launch analytics using survey, market, and performance data. Converted analytical findings into KPI reporting and leadership-ready commercial insights.