Summary
Overview
Work History
Education
Skills
References
Timeline
Generic

Meldon Dsouza

Pune,

Summary

Results-oriented Associate Consultant with deep expertise in marketing mix modeling, statistical analysis, and healthcare data integration. Adept at leveraging SQL, machine learning and cloud tools to deliver actionable insights, and optimize marketing ROI. Proven track record in automating complex workflows, leading and mentoring teams, and translating data-driven findings into strategic business recommendations. Experienced in collaborating with cross-functional stakeholders to drive impactful marketing and product decisions in competitive, data-rich environments.

Overview

3
3
years of professional experience

Work History

Decision Analytics Associate Consultant

ZS Associates
Pune
01.2025 - Current
  • Patient level analytics:
  • Mentored four associates and one intern on patient-level data metrics, including therapy and episodes.
  • Leading a sub-team in analyzing Optum and Verana Health data using PostgreSQL to map patient treatment patterns.
  • Delivering actionable insights to clients, enabling informed decision-making for research publication on patient treatment patterns.
  • Identified limitations in Verana Health data, saving clients approximately ~$750,000 by avoiding data purchases.
  • Investigating other potential data sources by analyzing relevant research papers and publications.

Decision Analytics Associate

ZS Associates
Pune
08.2022 - 12.2024
  • Marketing Mix:
  • Developed and executed promotional response models for various emerging and established pharma clients using logistic regression and K-means clustering, enabling precise physician segmentation.
  • Integrated and processed diverse data sources (IQVIA, Beghou, Merkley and Partners, Real Chemistry, etc.), and mentored a new joiner.
  • Delivered insights that optimized client investments, reducing spending on certain tactics.
  • Targeting and call plan automation:
  • Generated automated call frequency and target lists to enhance data-driven physician targeting.
  • Automated targeting and call plan processes with AWS SageMaker and S3, cutting workflow time by 50%.

Decision Analytics Associate - Intern

ZS Associates
Pune
02.2022 - 07.2022
  • Launch analytics:
  • Collaborated on the launch of a client’s first-ever product in the competitive US insomnia market, supporting cross-functional teams throughout the process.
  • Optimized SQL code to efficiently process IQVIA PlanTrak data at the physician level, enhancing data analysis speed.
  • Used XGBoost models to identify drivers and barriers influencing physician and patient adoption or discontinuation.
  • Conducted ad-hoc analyses to rigorously test hypotheses and deliver actionable insights for client strategy.
  • Contributed to project success, resulting in additional client engagements and expanding project portfolio.

Education

B.Tech - Biotechnology

M.S. Ramaiah Institute of Technology
07.2022

Skills

  • SQL programming
  • Amazon SageMaker
  • Machine learning
  • Data analysis and visualization
  • Data Integration & Management
  • Project management
  • Analytical thinking
  • Team leadership

References

Available upon request

Timeline

Decision Analytics Associate Consultant

ZS Associates
01.2025 - Current

Decision Analytics Associate

ZS Associates
08.2022 - 12.2024

Decision Analytics Associate - Intern

ZS Associates
02.2022 - 07.2022

B.Tech - Biotechnology

M.S. Ramaiah Institute of Technology

Similar Profiles

CREATE PROFILE
Meldon Dsouza