Summary
Overview
Work History
Education
Skills
Certification
Extracurricular Activities
Timeline
Generic

Shivang Nimesh

Delhi

Summary

Business analytics professional working in pharmaceutical consulting with strong analytical and communication skills helping pharmaceutical clients make decisions related to brand planning and marketing strategy through comprehensive data-driven analysis. Expert in Pharma Consulting, Patient Analytics, Product Marketing, and multi-Channel Customer-centric Marketing.

Overview

5
5
years of professional experience
1
1
Certification

Work History

Decision Analytics Associate Consultant

ZS Associates
12.2023 - 05.2024
  • Lead a work-stream with 6 associates, a project portfolio of a million dollars annually, which is aimed at creating a consumption layer that has all the transactional, enrollment, payer, and patient-level information transposed into a single row for each patient on a particular client brand
  • Lead a work-stream to support clients on multiple high visibility marketing reports that address major KPIs relating to the patient's drug intake and therapy
  • Dealing with Patient/Physician level data in the US Healthcare industry and understanding business requirements to design solutions for the clients
  • Actively helped the clients respond proactively to the biggest anticipated LOE for one of the biggest Immunology drugs in the market
  • Lead a work stream with a team of 4 associates, managing an annual project portfolio valued at over one million dollars. The project focuses on evaluating the market impact of multiple US-based drugs and using the findings to strategically allocate budget for the upcoming year
  • Lead a work stream and 4 associates to synthesize and document business rules for various marketing, enterprise, and reporting metrics for various products.

Decision Analytics Associate

ZS Associates
08.2021 - 11.2023
  • Consulting a Fortune 70 retail pharmacy client with more than $55 billion annual adjusted net revenue
  • Developing advanced statistical models that simulate the impact of a client's marketing activities on their real-world results
  • Interfaces used: Hive, Impala, PySpark/Jupyter Notebook, Dataiku, Trino, VSC and Putty, Snowflake, Teradata
  • Led multiple iterations of the Impact Measurement and Investment Allocation Project for the years 2021 and 2022. This project, valued at close to a million dollars, focuses on evaluating the market impact of various US-based drugs to strategically allocate budget for the upcoming year
  • Lead analyses done on multiple migraine, oncology, neurology and immunology drugs to provide insights and address questions that are required to set up the marketing and launch strategies by leading major reports such as measurement plan, program performance assessment, and investment allocation through statistical techniques such as t-tests and F-test, test & control, clustering, etc
  • Driving multiple collaborative ad-hoc reports by tracking crucial KPIs such as patient persistence, market penetration, capacity planning, and investment allocation to address business questions about the loss of exclusivity of a multi-billion dollar drug (currently contributing 40% of revenue)
  • Building multiple SQL-Python & SQL-Excel tools for capacity planning, resource utilization, and patient service program tools that calculate and visualize metrics such as patient-program engagement, program enrollments, patient roll-offs, etc.

Data Science Internship

Internshala
07.2020 - 08.2020
  • Developed proficiency in Python and R for data cleaning, visualization, and analysis
  • Applied machine learning algorithms, including regression and clustering, to real-world datasets
  • Conducted exploratory data analysis and created visualizations using Matplotlib and Tableau
  • Gained exposure to big data technologies like Hadoop and Spark
  • Developed collaboration, communication, and problem-solving skills through team projects.

Python Developer Intern

Webtek solutions
06.2019 - 08.2019
  • Utilized Python programming language for software development, focusing on data manipulation, analysis, and automation tasks
  • Implemented and maintained Python-based applications, adhering to best coding practices and documentation standards
  • Worked with Python libraries such as NumPy, Pandas, and Matplotlib for data processing and visualization
  • Collaborated with team members to develop and deploy Python-based solutions, gaining experience in Agile development methodologies
  • Enhanced problem-solving skills through debugging and optimizing Python code for efficiency.

Web Developer Intern

Webtek solutions
06.2019 - 08.2019
  • Acquired proficiency in front-end technologies such as HTML, CSS, and JavaScript for website development
  • Developed responsive and user-friendly web interfaces using frameworks like Bootstrap or React
  • Implemented back-end functionality using languages like Node.js or PHP, and database management with MySQL or MongoDB
  • Enhanced problem-solving skills through troubleshooting and debugging code
  • Collaborated with team members to deliver high-quality web applications, gaining valuable experience in Agile development methodologies.

Education

B.Tech in Information Technology -

Maharaja Surajmal Institute of Technology
03.2021

Skills

  • Languages and Database: Python (Pandas, Numpy), Spark, PostgreSQL, Hadoop, R, Teradata, Hive, Impala, Oracle
  • Tools/Technologies: Dataiku, MS Excel (Optimizer, Forecast), VSC, Putty, Tableau, Power BI, MS Powerpoint
  • Techniques: Regression, Classification, Optimization, Statistical Modelling, Random Forest, Decision trees, Neural
    Networks, XG Boost

Certification

  • Data science - University of Michigan
  • Intro to Programming Using Python - University of Michigan
  • Web development and PHP - Webtek Labs Pvt. Ltd.
  • Data Structures - Eckovation

Extracurricular Activities

  • An active member of LFT Society of New Delhi in 2017-18. I volunteered at the cleanliness drive and "Adopt-A-Plant" plantation drive in 2018-19.
  • Core member of the Football team
  • An active member of the Rotary Club of New Delhi in 2018-19. I volunteered at the "Mahadaan 2.0"- An International level Blood Donation camp in 2019.
  • Event Staff - International conference of Artificial intelligence and Application 2020

Timeline

Decision Analytics Associate Consultant

ZS Associates
12.2023 - 05.2024

Decision Analytics Associate

ZS Associates
08.2021 - 11.2023

Data Science Internship

Internshala
07.2020 - 08.2020

Python Developer Intern

Webtek solutions
06.2019 - 08.2019

Web Developer Intern

Webtek solutions
06.2019 - 08.2019

B.Tech in Information Technology -

Maharaja Surajmal Institute of Technology
Shivang Nimesh