Headline

Data Scientist | Commercial Analytics | Python, SQL | Software Engineer | Data & Backend Systems

About

Data Scientist with ~2 years of experience in commercial analytics and predictive modeling for pharma clients. Skilled in Python and SQL, with hands-on experience in building machine learning models and marketing mix modeling (MMM) to drive data-driven decision-making. At ZS Associates, I have worked on multiple analytics projects focused on optimizing promotional strategy and resource allocation, contributing to revenue uplift of up to $25M. My work includes predictive modeling, exploratory data analysis (EDA), and solving real-world data challenges such as extracting insights from unstructured data sources. I also bring a strong data engineering foundation, having built real-time data pipelines using Apache Kafka and Druid, enabling scalable analytics and downstream machine learning use cases. I am particularly interested in applying data science in healthcare and pharma domains to drive meaningful business and patient impact. Skills: Python, SQL, Machine Learning, Marketing Mix Modeling (MMM), Data Analysis, Apache Kafka, AWS

Location

Pune District

Work experience

Decision Analytics Associate at ZS, Jan 2025 - Present · 1 yr 4 mos, Pune, Maharashtra, India, - Worked on commercial analytics projects for pharma clients, performing data preparation, EDA, and feature engineering to enable predictive modeling and data-driven decision-making - Built and validated predictive models (OLS Regression, Random Forest, Bayesian) and contributed to MMM to assess channel effectiveness and optimize resource allocation, supporting revenue uplift of up to $25M - Owned key components of analytics workflows, ensuring high-quality delivery while collaborating with senior stakeholders to translate business problems into analytical solutions - Automated extraction of geospatial and HCP data from unstructured web sources, reducing reliance on paid tools and improving data availability

Associate Software Developer at Finvolv, Dec 2023 - Jan 2025 · 1 yr 2 mos, Bengaluru, Karnataka, India, - Developed a real-time data pipeline (Spring Boot, Apache Kafka) to ingest LOS data into Apache Druid, enabling analytics on 100K+ daily records. - Integrated data systems with Tableau and Superset to deliver business intelligence dashboards. - Built an authentication microservice with secure token generation, validation, and expiration, improving system security and user experience.

Product Engineering Intern at TE Connectivity, Nov 2022 - Jul 2023 · 9 mos, Bengaluru, Karnataka, India, -Designed and implemented a custom deep learning model using MLP regressor. -Contributed to model development, robustness analysis, and critical dimension identification. -Achieved an impressive MAE of 0.5240 and an outstanding pass rate of 97.07% with our model.

Education

Bachelor of Technology - BTech, Information Technology, Vellore Institute of Technology

Public links

github: https://github.com/KetanAgrawal2002