Advanced Analytics

Consultant, Commercial Analytics C00295

Published On

Full career experience in an analytical role within the pharmaceutical commercialization realm. Hands-on programming experience with IMS and Symphony data. Familiar with full cycle sales operations analyses especially for mid to large-sized pharma.

Professional Experience

KMK Consulting Inc. (Feb 2015 – Present)
Commercial Analytics Consultant

⦿ Perform descriptive and predictive analytics using various data sources (e.g. Xponent, APLD, DDD, HCOS, Calls & Samples, Claims, etc.) to communicate project findings to cross functional teams or stakeholders. Provide data-driven business insights for brand teams to improve marketing and sales activities and to promote growth:
⦿ Conducted patient journey analytics by leveraging Anonymous longitudinal patient data (APLD) to track patient treatments over time and answer business questions about the market
⦿ Performed promotion response analyses for ROI measurements and assessments to support client marketing strategy decision
⦿ Developed and implemented Key Performance Indicators or dashboards to measure brand and market’s performance and sales force execution. Also worked with sales activity and event data for reach and frequency analyses for better sales force promotion effectiveness and efficiency
⦿ Generated analytic reports, tables, graphics, and slides to evaluate brand performance (e.g. track DTC performance, non- retail business, etc.) and presented summary of key findings to brand teams

Data Analyst

⦿ Clean and process large pharmaceutical sales datasets, identify and discover target patient populations, design quarterly marketing plans and incentive plans along with client stakeholders:
⦿ Developed and maintained Analytical Data Mart including working with large scale pharmaceutical retail and non-retail data, Familiar with ETL processes and automation
⦿ Integrated data from multiple sources / data providers for downstream users; created centralized data warehouses hosting feeds from CRM and IMS/Symphony data
⦿ Designed and created account base targeting methodologies to improve promotion efficiency
⦿ Created Incentive Compensation payout workbooks on quarterly basis according to rule-based algorithm
⦿ Developed online Call Plan Management Tool to provide users with business actionable insights and ability of performing self-service analytics


SAS Base & Advanced Certified Programmer
SAS Enterprise Miner
SAS Enterprise Guide

Technical Skill

Microsoft Office: Word, Excel, Access, PowerPoint

Others: SQL, Tableau, Power BI


M.E. Industrial and Systems Engineering (Jan 2015)
Lehigh University, Bethlehem, PA  

B.S. Mechanical Design, Manufacturing and Automation (Jun 2012)
Tongji University, Shanghai, China

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

Watch our Latest Webinar On-demand

The Art of Leadership in the Emerging Biopharmaceutical Industry

Trends, Challenges, and Approaches

Featured Speakers