Aravind Madhamsetty

Experience

• 

  ZS

  Apr 2017 - Jan 2021

  As an associate consultant at ZS within the advanced analytics team, I led a team of 4 to deliver a variety of commercial analytical solutions for major US-based healthcare clients.• Created behavioral and attitudinal customer segmentation methodologies to drive the adoption of the newly launched drug by integrating target opportunities and marketing synergies • Streamlined and automated existing reporting pipelines and processes resulting in ~50% increased efficiency with enhanced quality• Designed and ran multiple A/B testing analyses to measure the impact of patient education and promotional campaign. Recommended restructuring to strategically target customers resulting in sizeable gains• Developed deep expertise in SF analytics, Targeting and Alignment, and brand analytics• Onboarded new members into the team Show less As an associate at ZS within Strategic Planning and Forecasting team, I worked on developing Long term financial forecasts for early-stage and next get assets.• Conceptualized and developed novel forecasting model enabling the client to identify risk/ops of the drug by imbibing impact of dynamic patients on total patient pool; model leveraged for identifying a $100M risk on brand facing recent softness• Engineered comprehensive tool for US-based client for forecasting revenue of pipeline drugs; incorporated attribute and order of entry analysis, Dynamic drug re-treatment protocol for modeling• Assessed revenue impact due to launch of competitors, biosimilars & others on $5B Oncology biologic drug of US-based pharma client for Melanoma and Bladder Cancer Portfolio, forecasted ongoing revenue, conducted time series and analog analysis and secondary research• Worked as an individual contributor and managed stakeholders Show less

  • Associate Consultant

    Jul 2019 - Jan 2021

  • Associate

    Apr 2017 - Jun 2019
• 

  Minds + assembly

  Jun 2021 - May 2022

  Data Science Intern

  • Developed an agent-based simulation model to emulate real world interactions among the different stakeholder and help inform marketing strategy for an upcoming Rx launch• Designed and built a python-based data pipeline to ingest incoming NPP data from 10 different data sources, further developed tableau dashboards to churn out monthly analytics reports. Resulting in a savings of 40 hours each cycle

• 

  Microsoft

  Jun 2022 - now

  Product Manager 2