Consultant, Commercial Analytics C00101

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

KMK Consulting Inc. (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 franchises 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

Education