Samya Dasgupta
Hyderabad
Summary
Sales Incentive Compensation, Analytics & Visualization Consultant with 7+ years of experience in Pharma and FMCG sectors across US, EU, and APAC markets. Expertise in sales force effectiveness, incentive compensation strategy, payout administration, plan design, resource planning, and data-driven analytics. Proven ability to deliver accurate incentive compensation execution, financial alignment, and actionable insights for leadership.
Overview
8
8
years of professional experience
1
1
Certification
Work History
Senior Analyst
Novartis
Hyderabad
12.2024 - Current
- Implement incentive compensation plans across therapeutic areas ensuring accurate payout processing in Zaidyn / Javelin.
- Produced quarterly goal cards, monthly incentive reports, and weekly territory-level achievement reports.
- Conducted model simulations (Monte Carlo Regression) for pay curve optimization; implemented health checks improving budget utilization by 2–5%.
- Designed Excel-based QC tools for validation of Zaidyn reports, reducing 10–12 hours monthly.
- Partnered with finance for IC vs. Finance reports to align payouts with financial outcomes; conducted captured rate analysis and adoption rate analysis. Finance accruals report for finance team.
- Supported territory alignment and quota validation processes in collaboration with sales leadership.
- Responded to field inquiries on compensation metrics, payouts, and plan interpretation, providing data-backed justifications and insights.
- Prepared IC plan documents, FAQs, and communication decks to improve field understanding and adoption. Facilitate attestation and docusign workflow for plan documents.
- Prepare MBO feeds tool on Ngage
Associate Consultant
IQVIA
Bangalore
06.2022 - 11.2024
- Implement incentive plans in IC 360 to generate incentive reports. Calculate Reps payout using parallel tool which in turn helped in QCing the system generated reports.
- Develop excel based tool for the ABLs and RSDs to input MBO feedback of the field force and then incorporate it into the system to calculate final payout.
- Conducted customer profiling through DoT factor analysis and sales metrics to segment HCPs.
- Developed concentration curves to achieve Pareto optimality in enhanced segmentation strategies.
- Prepared Excel templates (MCCP) for monitoring assigned versus actual calls by representatives.
- Utilized TAP Tool for segmentation and targeting processes for GSK and Novartis projects.
- Analyzed market mix models to assess ROI on advertising expenditures across multiple channels.
- Forecasted future sales leveraging statistical regression techniques for accurate predictions.
- Created PBI dashboards to analyze field-force activities' impact on sales performance.
- Designed capacity utilization and commercial data dashboards for KPI comparisons across markets.
Research Associate
NielsenIQ
06.2019 - 06.2022
- Extracted and wrangled RMS data from client specific DBs through an SQL based analytical tool called Nielsen Answers Desktop.
- Created automated excel / power BI / PPT based reports for fortune clients to enable faster decision making. Market share analysis, insight generation, product launch analysis, sales compensation.
- Performed RCA (Root Cause Analysis) to stabilize faulty reports in terms of accuracy and run time.
- Worked closely with the onshore team (RL) to ensure timely delivery of reports.
- Also worked as a QC lead to enable 100% accuracy across the region.
Business Analyst Trainee
Value Momentum
01.2018 - 01.2019
- Created Functionality Requirement Specifications / Documents (FRS/ FRD).
- Modeling Product Catalog and writing visibility rules on coverage and their attributes.
- Implemented excel books in iFoundry to rate insurance products and derive premiums.
- Analyses of excel sheet in case of premium mismatch.
- Thorough theoretical understanding of the insurance domain viz Life, Reinsurance, P&C.
Intern
Srei Infrastrure
01.2018 - 12.2018
- Analyse Balance Sheets, P/L etc and construct various reports based on them.
- Analyze parameters to ensure credit worthiness and mitigate NPAs.
Education
Post Graduate Diploma - Business Analytics
Institute of Insurance & Risk Management
Hyderabad01.2020
Bachelor - Economics (H), Statistics & Mathematics
University of Calcutta
Kolkata01.2016
Skills
- Incentive / Sales Compensation IC Plan Design & Execution Payout Modeling & Administration Goal Designing z score Model Cost to Revenue Analysis Attainment Analysis
- Advanced Excel PPT Power BI SQL Azure Databricks Snowflake
- Patient & Pharma Data (IQVIA MIDAS, LRX, LPD) RWD Data Veeva CRM RMS Data
- Alignment Segmentation & Targeting Goal Design EDA Insight Analysis
- Tools: Zaidyn, IC360, JIRA, Smart Sheet, CaptivateIQ
Accomplishments
- Implemented monthly Health Check to statistically analyze the plan performance and optimality of the payout curve.
Certification
- L1 Power BI Certification (OJT)
- NCFM NSE Certification
Languages
Bengali
First Language
English
Proficient (C2)
C2
Languages
- English
- Bengali
- Hindi
Timeline
Senior Analyst
Novartis
12.2024 - Current
Associate Consultant
IQVIA
06.2022 - 11.2024
Research Associate
NielsenIQ
06.2019 - 06.2022
Business Analyst Trainee
Value Momentum
01.2018 - 01.2019
Intern
Srei Infrastrure
01.2018 - 12.2018
Post Graduate Diploma - Business Analytics
Institute of Insurance & Risk Management
Bachelor - Economics (H), Statistics & Mathematics
University of Calcutta
Similar Profiles
Katarzyna RzymkowskaKatarzyna Rzymkowska
Manager, Anti-Bribery and Conflict of Interest at NovartisManager, Anti-Bribery and Conflict of Interest at Novartis
Waqas MunawarWaqas Munawar
Service Desk/Desktop Support at NovartisService Desk/Desktop Support at Novartis
ALEX UDOVČALEX UDOVČ
Supply Point Evaluation Lead at NovartisSupply Point Evaluation Lead at Novartis
Kritika SoniKritika Soni
Senior Analyst - US Oncology Data Enablement at NovartisSenior Analyst - US Oncology Data Enablement at Novartis
V V V SATYA NAVEENV V V SATYA NAVEEN
SAP Basis Consultant at Tata Consultancy ServicesSAP Basis Consultant at Tata Consultancy Services