Profile

Advanced Analytics

Associate Data Analytics 589

Published On

Skilled in commercial data analytics, specifically through supporting sales operations, business planning and promotion strategy evaluation in the pharmaceutical industry. Experienced with IMS National Prescription Audit data, IMS National Sales Perspective Dollar data, IMS Xponent, aPlantrak data and patient-level data (APLD). SAS advanced programming skills in Alteryx Designer Core and machine learning with Python.

Industry and Project Experience

This image has an empty alt attribute; its file name is Divider-1.jpg
KMK Consulting Inc. Jul 2017 – Present

Patient Data Analytics using SAS/Python

⦿ Conduct Real-World Evidence (RWE) analysis on Marketscan and Symphony APLD databases, including patient profile, treatment adherence and persistence, and healthcare resource utilization
⦿ Develop machine learning models upon Symphony APLD data to help patient identification. Reduce the noise of raw data through unsupervised auto-encoder, leverage deep neural network, and assemble random forests to predict potential patients from a rare oncologic disease
⦿ Design matrix to inform business plan by leveraging Symphony APLD data. Visualize uptake/share/distribution of patients and HCPs upon various KP ls, and compare pre-post changes to uncover market potential

Brand Analytics for Marketing and Sales Force Effectiveness

⦿ Conducted sales review and targeting using IQVIA Rx data plus call & sample data.
⦿ Clustered physicians based on prescription behavioral traits to target high-value potential writers and built promotion response curve by segments to recommend optimal call/sample allocations.

Email Marketing Effectiveness T&C Model Analysis

⦿ Built an ROI model of an email promotion campaign for promotional impact evaluation.
⦿ Placed physicians into test & control groups and assessed physicians’ prescribing performance, such as speed of adoption and growth, and verified the promotion efficacy by conducting a 2-sample t-test.

Physician Payment Data Mining for Competitive Analysis

⦿ Mapped N Pl for 93% of HCPs within CMS database (500+ GB) from fuzzy approaches, and 80% of the mapped HCPs were at a high confidence level.
⦿ Categorized payment records to reveal targeting strategies of key players in the market and provided references for executive decisions.

Technical Skills

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

Microsoft Office: Word, Excel, Access, PowerPoint Others: SQL, Tableau, Power Bl

Education

This image has an empty alt attribute; its file name is Divider-1.jpg
Master of Statistics
Lehigh University, Bethlehem, PA (2017)
Bachelor in Mathematics
South China University of Technology, Guangzhou, China (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