Associate Consultant

• Jul 2023 - Present

Data Engineer Intern

• Aug 2022 - Dec 2022

1. Demonstrated proficiency in using EC2 to launch and manage virtual servers on AWS and integrated these instances with other AWS services such as RDS, S3, and Lambda 2. Configured databases using RDS, Redshift and S3, utilized Glue and Athena in defining and executing data schemas and ETL processes 3. Utilized Lambda functions to automatically trigger data ETL jobs using Glue and to run custom code in response to events 4. Employed DynamoDB to manage and query NoSQL data, integrated it with EC2 and RDS for seamless data access and management Show less

Data Analytics Intern

• May 2022 - Aug 2022

1. Implemented time series forecasting techniques (ARIMA, SARIMA, Holt-Winter's) using R for forecasting oncology product sales 2. Conducted in-depth analysis of sales data to identify key drivers of seasonality and incorporated them into forecasting models 3. Implemented strategy to improve accuracy of time series forecasts through regular evaluations and targeted enhancements, resulting in a 20% improvement in accuracy 4. Demonstrated comprehensive knowledge of a wide range of forecasting models and input data sources, including Specialty Pharma, Specialty Distribution, Claim data, NBRx, and SMART data Show less

Data Analytics Associate

• Dec 2019 - Jul 2021

1. Provided data-driven insights and strategic recommendations to pharmaceutical clients through analytics projects, including new product launches, competitor threat assessments, market opportunity assessments, and forecasting 2. Analyzed physician level data to track patient journeys and developed key performance indicators, such as persistency, compliance, drug penetration, and market share to inform strategy and decision-making 3. Conducted analysis using SQL, Python, Tableau, and Excel to ETL large datasets from various sources, applied statistical analysis (regression, t-test) and visualization techniques to identify trends and presented findings to clients in the form of reports/dashboards 4. Created interactive dashboards and visualizations in Tableau to communicate insights to pharma clients, using data sources like IQVIA sales and claims data, Symphony sales and claims data, CareSet data, specialty pharmacy data, and promotional and marketing data Show less

Maintenance Engineer

• Jul 2018 - Dec 2019

1. Optimized consumable material procurement process through the analysis of previous 4 years consumables data using SQL and Excel 2. Built maintenance dashboards in Tableau and Excel to track process failures/equipment maintenance 1. Optimized consumable material procurement process through the analysis of previous 4 years consumables data using SQL and Excel 2. Built maintenance dashboards in Tableau and Excel to track process failures/equipment maintenance