Advanced Analytics

Associate, Advanced Analytics (C00229)

This consultant has a wealth of experience in leveraging data as a strategic asset within the pharmaceutical industry, and a robust background in data preparation, predictive analysis, and data visualization. Their expertise lies in extracting meaningful insights from diverse datasets, particularly in the realms of patient data and payer insights. They have a strong track record of utilizing tools such as SAS and Power BI to transform raw data into clear, compelling visualizations that illuminate patterns and trends, enabling you to make informed decisions.

Professional Experience

KMK Consulting Inc. – Morristown, NJ  (June 2018 – Present)
⦿ Analyze product source of business and patient journey by leveraging APLD data to establish regimen database, design adherence and persistence tracking report.
⦿ Assess impact of experimental promotion on sales using statistical and descriptive methods to identify physicians with matching promotion and prescription behavior to create effective Test and Control groups, provide insights for executives’ decision making.
⦿ Conduct quantitative analyses on 10+ IMS datasets, design and develop weekly KPI dashboard using SAS and Power BI to monitor performance across multiple areas of interest, extract actionable business insights, QC lead for PRISM reporting platform launch.
⦿ Provided payer analytics/insights and adhoc support to the Market Access team, and the Brand team at Large Pharma Company.

Investment Bank and Securities Firm – Shanghai, China (June 2017 – Aug 2017)
FICC Structuring Intern
⦿ Predicted the trajectory of 10-year marketing growth of 12 asset-backed securities with regression modeling and provided recommendations in investment strategy to stakeholders.
⦿ Designed structured products with various option strategies in multiple markets and generated corresponding contracts for customers.
⦿ Developed VBA and automatically prepared contents for a daily client-facing newsletter that covers global markets as well as relevant news stories and earnings reports, sped up the process by 50%.


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

Applied Data Mining, Lehigh ISE465 Bethlehem, PA (Oct 2017 – Dec 2017)
Wine Quality Classification

SAS Programming, Lehigh STAT450 Bethlehem, PA (Oct 2017 – Dec 2017)
Stock Trading Framework

E-Bay and Amazon – Bethlehem, PA (Feb 2014 – Apr 2014)
Individual project

Technical Skills

Data: IQVIA & Symphony Plantrak data, APLD, and MMIT formulary data
Programming: SAS, SQL, Power BI, R, SPSS, EViews, Advanced Microsoft Office pack, VBA, C/C++, Java
Statistical: ANOVA, ARIMA, GARCH, Neural Network, Random Forest Tree, Support Vector Machine, Bootstrapping Method
Certificate: CFA Level II Candidate, SAS Base Certification, Thomson One Certification
Languages: Mandarin, Proficient English, Basic Spanish


Master of Science in Statistics (Aug 2017 – May 2018)
Lehigh University – Bethlehem, PA           

Bachelor of Science in Business & Economics (Aug 2013 – May 2017)
Lehigh University – Bethlehem, PA

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


Come see KMK at PMRC

February 7-8, 2024

Newark Liberty International Airport Marriott Hotel, New Jersey
Dale Choi

Director, Strategy and Research

Andrew Pilecki

Director, Strategy & Research