Headline

Data Analyst | 4.5 yrs in pharma & analytics consulting sector with focus on data analytics | Future Senior Data Analyst

About

Data analyst with 4.5 years track record in the pharma, healthcare and analytics consulting industry. Adept at solving complex analytics challenges across cost optimisation, resource utilisation & marketing analytics. Generated potential 18% reduction in sales force attrition, in nine months, by optimizing pay-for-performance and fairness analysis using statistical methods, custom visualizations, and data extraction and transformation, using data analytical tools like SQL and Excel. Saved $280K in six months, for IC payout per plan period across 20+markets, by leading a landscape assessment and rolling out aligned, archetype-appropriate standards. Extracted and transformed data from SQL server, and visualised it on excel. Generated actionable insights by translating analytical drivers into actionable field behaviour, building stakeholder confidence through experimentation-based validation, and driving four incentive-plan enhancements that strengthened sales outcomes and field engagement. Specialities : data Analytics, data analysis, SQL, Python, Excel, Power BI, Co-Pilot Studio, targeting, segmentation, cost optimisation, incentive analytics, marketing analytics, pharma analytics, healthcare analytics, analytics consulting, business intelligence. Looking for an amazing senior data analyst ? Contact me at gshrey2102@gmail.com.

Location

India

AI stack

claude

Work experience

Analytics Analyst at Syneos Health, Jan 2025 - Present · 1 yr 9 mos, Remote, - Incentive Archetype Analytics Saved $280K in six months, for IC payout per plan period across 20+markets, by leading a landscape assessment and rolling out aligned, archetype-appropriate standards. Extracted and transformed data from cloud and visualised it using data analytics and data visualization tools like Power BI and SQL. Improved metric alignment by 85% in six months, for markets across the region, by standardising key sales metrics across more than twenty European markets onto a common definition set by ideating the problem and collecting data from stakeholders by effective communication and problem structuring using data analytics and data visualization tools like Excel, Power BI and SQL. Reduced reporting TAT by 45%, by re-engineering cross-market reporting to remove the manual reconciliation that fragmented local data had required. Deploying interactive dashboards in Power BI. - Sales Incentive Analytics Generated potential 18% reduction in sales force attrition, in nine months, by optimizing pay-for-performance and fairness analysis using statistical methods, custom visualizations, and data extraction and transformation, using data analytics and data visualization tools like Power BI and SQL. Implemented hypothesis testing across multiple incentive plans to create data-driven validation so as to enhance sales outcomes and field engagement that also led to a higher stakeholder confidence. - Brand & Marketing Analytics Increased correlation from 0.31 to 0.72 for pay-for-performance in six months by designing a matrix plan that rewarded volume and market share jointly rather than volume alone. Extracted and transformed raw data and scenario modelling in data analytics and visualization tools like Excel, Power BI and SQL. Achieved 81% field engagement in six months, up from 62%, by rewarding reps on both sales volume and market-share growth instead of volume alone modeled scenarios and kept the plan within budget.

Analyst at Sandoz, Jan 2024 - Jan 2025 · 1 yr 1 mo, Hyderabad, Telangana, India, Managed $4.1M in payouts in six months across 200+ reps by delivering localised incentive plans for a new spin-off brand, by partnering with country commercial excellence teams to align plan mechanics with global sales strategy, using what-if scenario modelling and visualisations in Excel and SQL. Drove $2.1M in incremental sales on $750k of incentive spend that impacted 1,000+ field members for a major product release, designing incentive programs that helped brand managers by owning end-to-end logic development, testing, and full deployment using data analytics tools like Excel and SQL. Saved $82k per year by reducing manual IC processing effort by 230 hours per cycle. Established a fully automated system for monthly IC processing and KPI monitoring, building real-time dashboards with country stakeholders and automating incentive programs in Javelin using SQL and PowerBI

Decision Analytics Associate at ZS, Jan 2022 - Dec 2023 · 2 yrs, Pune District, Maharashtra, India, Reduced time by 85% of process execution by consolidated four operational units into a single cohesive system and eliminated cross-team dependencies by restructuring and rebuilding workflows in SQL. Implemented and designed end-to-end SPIFF programs across $100K to $700K budgets for field forces, by authoring configuration logic, building performance-tracking systems, and delivering weekly and monthly reports on market share growth, volume growth, and % of target achieved using modeling in Excel and SQL.

Education

Bachelor of Engineering - BE, Electronics and Instrumentation, Institute of Engineering & Technology DAVV, Indore