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
Certifications
SAS Base & Advanced Certified Programmer
SAS Enterprise Miner
SAS Enterprise Guide
Technical Skill
Microsoft Office: Word, Excel, Access, PowerPoint
Others: SQL, Tableau, Power BI
Education
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
