Suraj Shukla

Summary

Senior BI Developer and Project Lead with 8+ years designing and delivering enterprise Power BI solutions for global pharmaceutical clients including Sanofi, GSK, AstraZeneca, Gilead, CSL and ViiV Healthcare, with a primary focus on US commercial analytics. Leads a 12-member BI team that has delivered 100+ production dashboards serving up to 1,000 business users each on data models exceeding 500 million rows. Expert in DAX, semantic modelling and performance optimisation, with strong Snowflake, Azure and Power Platform experience and hands-on Gen AI integration with Microsoft Copilot. Microsoft Certified: Power BI Data Analyst (PL-300).

Experience

1. Dec 2019 – present

   Project Lead

   Axtria India Pvt Ltd · Delhi

   Global pharma commercial analytics for Sanofi, GSK, AstraZeneca, Gilead, CSL and ViiV Healthcare (US market focus).

   • Lead a 12-member BI team delivering 100+ production Power BI dashboards across omnichannel marketing, patient analytics, sales and revenue, NBRx/TRx, HCP reach, payer analytics and rebate management, each serving up to 1,000 business users.
   • Designed and optimised semantic models on 500M+ row datasets (Snowflake, SQL Server, SSAS Tabular) with star schemas, aggregation tables and incremental refresh, cutting refresh windows from hours to minutes and keeping report loads in seconds.
   • Tuned model and query performance with DAX Studio and Tabular Editor: measures over calculated columns, high-cardinality columns removed, bidirectional relationships eliminated, query folding enforced, variable-based DAX patterns.
   • Integrated Microsoft Copilot and Gen AI into the Power BI ecosystem for natural-language querying and automated narratives; delivered enablement sessions as an Axtria-certified trainer.
   • Own end-to-end Power BI architecture and governance: workspaces, deployment pipelines, RBAC and row-level security meeting pharma compliance and audit requirements.
   • Built Power Apps solutions on Dataverse, including a milestone tracker and write-back tools with Power Automate, and embedded Power BI into enterprise applications via embedded analytics and API automation.
   • Served in a dual consultant / senior-developer role on Sanofi's DIVE programme (sales growth, competitor performance, market trends, net sales, budget forecasting); received formal client appreciation.
   • Collaborated with US and EU stakeholders on requirements and agile delivery; mentored developers and ran internal Power BI training.

2. May 2018 – Nov 2019

   BI Developer

   IndiaMART InterMESH Ltd · Delhi

   • Designed interactive Power BI dashboards including customer cohort analysis, top-5 analysis and supplier performance for India's largest B2B marketplace.
   • Built a comprehensive profit-and-loss dashboard, independently resolving complex multi-key join and data-duplication challenges.
   • Delivered monthly margin reports with actionable, data-driven recommendations.

3. Aug 2016 – Apr 2018

   Business Associate

   Australian Premium Solar · Delhi

   • Developed and published profit-and-loss reports in Power BI and maintained market-research dashboards; market-trend analysis that shaped marketing strategy.

Core skills

Power BI

Semantic modellingDAXPower Query (M)Incremental refreshAggregation tablesComposite modelsRow-level securityDeployment pipelinesDataflowsDAX StudioTabular EditorPower BI EmbeddedCopilot for Power BI

Power Platform

Power Apps (canvas + model-driven)DataversePower AutomateWrite-backEmbedded analyticsREST API automation

Data & cloud

SQL ServerSnowflakeAzure SynapseAzure Data FactoryAWS RedshiftBigQuerySSAS TabularMDX

Languages & tools

SQLPython (pandas)Excel (Power Pivot, VBA)TableauQlikSenseGitJIRAConfluence

Pharma domain

Omnichannel analyticsPatient analyticsPayer & rebate analyticsNBRx / TRxHCP reach & engagementMarket accessSales & revenue KPIs

Leadership

12 direct reportsUS/EU stakeholder managementRequirementsAgile / ScrumTraining & mentoring