Extensive experience in analytical solutions for commercial pharma projects including patient journey, persistency/adherence, behavioral segmentation, ROI analysis, promotional response modeling, KPI design and dashboards and deep-dive analytics.
Hands-on experience with commercial pharma data sets and EMR data – IQVIA, Symphony Health, MarketScan(Truven), Flatiron EMR, COTA EHR, McKesson, Komodo, APLD, DDD, HCOS, HPD, MMIT formulary data, Specialty Pharmacy
Industry and Project Experience
Pharmaceutical Firm, NJ
US Hematology-Commercial Forecasting and Performance (Jul 2020– Present)
⦿ Develop patient persistency and compliance analysis for 4 in-line products by leveraging multiple data sources, including Symphony PTD claims, MarketScan closed claims and specialty pharmacy patient level data
⦿ Establish patient journey analysis with Flatiron/COTA EMR data to refine forecasting model assumptions and improve model accuracy
⦿ Work closely with forecasting leads and brand teams to identify market trend and perform deep-dive analysis in order to improve net sales
⦿ Conduct Risk & Opportunity analysis under different market event scenarios by leveraging patient-base incidence model
⦿ Develop algorithms to estimate national NBRx and TRx for new launch products
Conduct COIVD19 impact analysis and monitor market trend in support of forecasting model build-in assumptions
Pharmaceutical Company, NJ
Commercial Insights & Analytical Operation (Feb 2018 – Jun 2020)
⦿ Conducted HCP behavior-based segmentation analysis based on clustering model that was executed in both call plan and non-personal promotion campaign resulted in +10% QoQ TRx growth
⦿ Recommended optimal promotion strategy including call frequency and sample drops at HCP office level to maximize ROI subject to constrains by using a response model and linear regression
⦿ Partnered with brand teams on quarterly deep-dive analytics, including assessing promotion campaigns and key initiatives, providing data driven insights and subject matter expertise to identify product growth opportunities
⦿ Defined directional and sustainable product trackers having 50+ KPIs from subject areas including sales, promotion activity and managed markets to provide accurate insights on brand performance over time and in line with brand team strategy
⦿ Selected test HCPs for NPP campaigns, evaluated effectiveness (Rx lift and ROI) of NPP campaigns using test/control methodology
⦿ Identified high-value decliners and recommended to sales team resulted in turning brand decline to growth within one quarter
Pharmaceutical Corporation, NJ
Brand Analytics – US Oncology (May 2017 – Feb 2018)
⦿ Developed HCP level segmentation rules for non-personal promotion (NPP) campaign marketingf purpose using APLD
⦿ Designed and implemented NPP performance tracker and identified key metrics to evaluate NPP campaign impact and conversion
⦿ Proposed account base targeting methodology to improve promotion efficacy
⦿ Facilitated account base targeting by affiliating DDD accounts to chargeback accounts
⦿ Developed KPIs to offer key business insights based on APLD to track patient NRx to shipment
⦿ Built forecasting model to estimate direct-to-patient (DTC) campaign conversions
⦿ Created monthly and bi-weekly dashboard to track DTC performance and presented summary of key findings to the brand team
⦿ Reinforced patient model to support brand team budget plan
KMK Consulting Inc. (Jun 2015 – May 2017)
⦿ Developed online Business Intelligence Tool (BIT) to provide users with business actionable insights and ability of performing self-service analytics
⦿ Performed sales representative call response analysis for ROI measurements and assessments to support client marketing strategy decision
⦿ Enhanced and automated process of sales reps request through SFA/CRM by reducing the turnover time from 5 business days to 2 business days
⦿ Integrated secondary (IQVIA and Symphony Health) and third-party data into an analytical data mart to provide analytics to client
Technical Skills
Microsoft Office: Word, Excel, Access, PowerPoint
Others: IBM SPSS, Python, SQL
Education
Lehigh University, Bethlehem, PA
B.S. Industrial Engineering & Operation Research (Jun 2011)
Tongji University, Shanghai, China
