Tableau Sales Team Reporting• Collaborated with different sales planning client stakeholders to transform 20+ Excel field reports into actionable, and dynamic Tableau dashboards catering to 600+ field sales representatives• Launched 15+ Tableau dashboards to track a variety of metrics like – sales rep activity (calls, samples, virtual engagements/emails), market sales/share trend, geographic sales/share comparison, payer level sales tracking, etc.• Supported sales representative’s… Show more Tableau Sales Team Reporting• Collaborated with different sales planning client stakeholders to transform 20+ Excel field reports into actionable, and dynamic Tableau dashboards catering to 600+ field sales representatives• Launched 15+ Tableau dashboards to track a variety of metrics like – sales rep activity (calls, samples, virtual engagements/emails), market sales/share trend, geographic sales/share comparison, payer level sales tracking, etc.• Supported sales representative’s daily targeting and pull-through initiatives by providing pre-built Tableau dashboards summarizing key performance indicators in a single, downloadable view for each customer/payer• Maintained ongoing client’s Tableau server operations – updating user list, providing user permissions, setting dashboard refresh schedules, and validating user-level securityManaged Care Reporting and Analytics• Collaborated with market access senior management to build 7+ Excel/Powerpoint reports and Tableau dashboards to track several metrics like formulary status trend, sales/share trend, coverage across different formulary baskets, claims dispense/reversal/rejection rates, claim rejection reasons, etc.• Collaborated with clients to create a custom payer mapping to track different key performance indicators at a higher and more relevant level from 3k+ distinct formularies• Created Tableau dashboard to enable efficient tracking and communication between market access and sales team to support pull-through initiatives post formulary wins Show less

HCP Valuation and Targeting• Analyzed different hypotheses like impact of managed care status on HCP’s writing behavior, “prospect customers” writing behavior, the impact of different types of activity, etc. to identify relevant valuation metrics• Created HCP level deciles for several brands based on a combination of metrics like managed care status, client’s product sales/share, competitor’s sales/share, market potential, etc.Data Layer Setup and Operations• Collaborated… Show more HCP Valuation and Targeting• Analyzed different hypotheses like impact of managed care status on HCP’s writing behavior, “prospect customers” writing behavior, the impact of different types of activity, etc. to identify relevant valuation metrics• Created HCP level deciles for several brands based on a combination of metrics like managed care status, client’s product sales/share, competitor’s sales/share, market potential, etc.Data Layer Setup and Operations• Collaborated with client stakeholders to streamline data delivery (to ZS) process of 40+ data sources across 7+ teams• Evaluated data sources to capture the latest information (data structure, business rules, etc.) and streamlined data structure across brands to set up a standardized process to measure performance metrics• Attained efficiencies by reducing data ingestion/validation to 1 business day, saving ~$200k-$300k across projects Show less

Field Quota Setting and Reporting • Collaborated with senior leadership to access different metrics to utilize while evaluating the field’s quarterly brand level quotas for brands in different life cycles (new, growth, and stable)• Evaluated different quota setting methodologies (goal-based, commission-based, rank-based, etc.) to set field quotas in line with the brand’s strategies and expected formulary wins