Profile

Advanced Analytics

Manager, Commercial Analytics 1

Published On

Experienced Senior Consultant with a demonstrated history of success within the analytics, consulting, and management fields of the healthcare industry. Well-versed in patient-level data analytics, marketing analytics, and advanced analytics including hands-on expertise with core programming languages such as Python PySpark, Big Data Analytics, SQL, SAS, and Alteryx.

Industry and Project Experience

This image has an empty alt attribute; its file name is Divider-1.jpg

Pharma Consulting Jun 2016 – Present

Consultant May 2018 – Present

⦿ Big Data M&E: Guiding a team of 5-6 analysts/developers on any maintenance & enhancements to existing Big Data analytics processes set up in the PySpark pipeline tracking various KPIs for sales and marketing teams.

⦿ Market Segmentation of US Pharma Health Systems: To understand the role and influence of Health Systems over HCPs in US Pharma. The client wants to strategize their approach for Sales Reps and KAMs to have maximum impact and growth during the launch of their product.

⦿ SalesForce Sizing: Worked with SHA claims data to analyze different sales force strategies and determine optimal sales force size for various business scenarios in the rare disease market before the product launch.

⦿ Organization Wide PySpark Setup for KPI Trackers: The client wanted to move from the existing SAS process to Big Data technology for the KPI trackers across various franchise in the Organization. Operationalized and optimized Claims Tracker in PySpark for Line of Therapy Calculation and various KPI Trackers

Associate Consultant Jan 2018 – Apr 2018

⦿ Copay effectiveness: Assess utilization and effectiveness of Copay card programs for various GNE products using SHA claims data and TMG copay data.

⦿ Patient Journey: Worked with SHA patient claims data to identify patterns of how patients progress to different stages of the disease and how they switch or move to various drugs in the process.

Analytics Associate Jun 2016 – Dec 2017

⦿ Adhoc Analytics Support: Setup various ad-hoc processes for Sales, Calls, etc. tracking in SQL, Python, SAS, etc. Also developed an internal PySpark based product.

⦿ PySpark Product Development: Developed an advanced and scalable product for Claims data-based metric calculation in PySpark. Set up Qubole connection to Amazon AWS clusters and used Airflow to automate the process. Data was stored in Amazon S3. Used Alteryx to create a parallel for the process for final QC.

⦿ IC Plan Design: Designed an IC plan based on the performance of reps, market share, and other relevant metrics and tested for effectiveness based on historical data.

Automotive Client Aug 2015 – May 2016

Assistant Manager

⦿ Customer Quality: Worked in the Customer Quality department involving various tasks like quality assurance, warranty settlement, and customer relationship improvement

Technical Skills

This image has an empty alt attribute; its file name is Divider-1.jpg
4 years: PySpark, Python & SMV
3 years: SQL, Alteryx:                          
2 years: MS Excel & MS PowerPoint, SAS        
4 years: US Healthcare data

Education

This image has an empty alt attribute; its file name is Divider-1.jpg
B. Tech,
IIT, Hyderabad (2011 – 2015)
Get The Latest Updates

Subscribe To Our Monthly Newsletter

No spam, only the content you’ll want to read.

Details about how we process your Information is available in our 

Privacy Policy

Upcoming Webinar

Strategic Planning for Medical Affairs

Adding Value Efficiently

Featured Speakers

More Profiles

TO LEARN MORE ABOUT THIS OR OTHER AVAILABLE RESOURCES, PLEASE CONTACT

melissa

Melissa ArchuIeta

Director of Accounts and Resource Management