Profile

Advanced Analytics

Analytics Lead C00296

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

This image has an empty alt attribute; its file name is Divider-1.jpg
KMK Consulting Inc., Morristown NJ (Jun 2015 – Present)

BMS, Summit, 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      

Bausch Health, Bridgewater, 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

Novartis Pharmaceuticals Corporation, Florham park, NJ
Brand Analytics – US Oncology (May 2017 – Feb 2018)

⦿ Developed HCP level segmentation rules for non-personal promotion (NPP) campaign marketing 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 Home Office (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

This image has an empty alt attribute; its file name is Divider-1.jpg
SAS: Macro, Graph, SAS Enterprise Miner, SAS Enterprise Guide
Microsoft Office: Word, Excel, Access, PowerPoint
Others: IBM SPSS, Python, SQL

Education

This image has an empty alt attribute; its file name is Divider-1.jpg
M.E. Healthcare System Engineering (Aug 2014)
Lehigh University, Bethlehem, PA

B.S. Industrial Engineering & Operation Research (Jun 2011)
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

Strategic Planning for Medical Affairs

Featured Speakers

More Profiles

TO LEARN MORE ABOUT THIS OR OTHER AVAILABLE RESOURCES, PLEASE CONTACT

melissa

Melissa ArchuIeta

Director of Accounts and Resource Management