top of page

Sandilya

I am

Venkata Sandilya Bagavathula

Logistics Data Analyst at Johnson and Johnson. Graduated in December 2023 from Stevens Institute of Technology with a Masters degree in Business Intelligence & Analytics.

My Projects

Take a look at my recent work

DALL·E 2024-01-04 23.32.12 - A professional cover picture for a Pharmaceutical Sales in An

Analysis of Pharmaceutical Sales Dynamics in the Anesthesia Market

In this project, I performed an in-depth analysis of the injectable anesthesia market using Python, focusing on market dynamics between 2016 and 2018. Utilizing Pandas and NumPy, I analyzed Medicare CCLF claims data to understand trends in market share, growth rates, and HCP prescribing patterns. My work led to actionable insights and strategic recommendations to enhance the market share of a newly launched pharmaceutical variant, amidst competitive challenges from existing products.

Cardiac Claims Analysis using Syntegra Data

Cardiovascular Metabolic (CVM) Claims Analysis is a data-driven project aimed at providing insights into the Cardiac disease treatment landscape. By analyzing the Syntegra Medicare CCLF Claims dataset from 2016-2018, the project identifies trends in Cardiac claims, evaluates HCP claim behaviors, and investigates patient age demographics. The findings inform strategic decisions on sales force deployment and marketing budget allocation in the pharmaceutical sector, highlighting the importance of targeted strategies for different healthcare provider segments and patient age groups.

NYC Subway Terminal On-Time Performance Analysis

In this project, I undertook a comprehensive analysis of the on-time performance of the New York MTA subway system over a five-year period, from 2015 to 2019. My primary objective was to explore essential business questions and gain insights into the efficiency and reliability of the subway system.

Technical Skills

Python
SQL
Excel
Tableau
Statistical Methods
Quantitative Analysis

Areas of Interest

Take a look at some of the things I love working on

Database Management

I have a strong expertise in designing, developing and managing database systems

Data Visualisation

I transform data into insightful visuals to aid decision making

Business Intelligence

I use data to identify business opportunities

Customer Analytics

I uncover valuable patterns and preferences in customer behavior using data

Collaboration

Healthcare

I enjoy working with my team to create winning strategies

I am passionate about using data improve patient care

I also love to run!

Finished the 2024 TCS New York City Marathon on 11/03/2024! 💥 This was my first marathon and I can't wait for the next one! 🏃‍♀️🏃‍♂️

bottom of page