Data science and analytics professional with 7+ years of career experience in pharmaceutical commercialization realm. Excellent knowledge and hands-on programming experience with IMS, Symphony and other health data. Familiar with full cycle sales operations analyses especially for mid to large-sized pharma.
Capability to coordinate various resources from different teams and work on multiple projects at the same time. Enjoy working as a team member as well as independently. Well-developed skills in prioritizing, organization, decision making and verbal/written communication skills. Excellent ability to identify, track and solve issues in a timely manner. Expertise in conducting appropriate business analytics to support various projects and address business questions.
Industry and Project Experience
Commercial Forecast & Performance Consultant (Jan 2021 – Present)
Client: Pharmaceutical Firm
⦿ Support Forecast Center of Excellence team, utilize both medical claims and Electronic Health Records (EHR) data to implement national-level analytics and best practices in forecasting for US Hematology business. Use deep analytical capabilities to transform data into actionable insights and effectively present business findings to senior management of the HEM portfolio to identify areas for improvement:
o 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:
o Conducted patient journey analytics by leveraging Anonymous longitudinal patient data (APLD) to track patient treatments over time and answer business questions about the market
o Performed promotion response analyses for ROI measurements and assessments to support client marketing strategy decision
o Developed and implemented Key Performance Indicators or dashboards to measure brand and market 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.
Commercial Analytics Consultant Jul 2018 – Dec 2020
Client: Pharmaceutical Firm
⦿ 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:
o Conducted patient journey analytics by leveraging Anonymous Longitudinal Patient Data (APLD) to track patient treatments over time and answer business questions about the market
o Performed promotion response analyses for ROI measurements and assessments to support client marketing strategy decision
o Developed and implemented Key Performance Indicators or dashboards to measure brand and market 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
o 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 (Feb 2015 – Jun 2018)
Client: Pharmaceutical Firm
⦿ Clean and process large pharmaceutical sales datasets, identify and discover target patient populations, design quarterly marketing plans and incentive plans along with client stakeholders:
o Developed and maintained Analytical Data Mart including working with large-scale pharmaceutical retail and non-retail data; Familiar with ETL processes and automation
o Integrated data from multiple sources/data providers for downstream users; created centralized data warehouses hosting feeds from CRM and IMS/Symphony data
o Designed and created account base targeting methodologies to improve promotion efficiency
o Created Incentive Compensation payout workbooks on quarterly basis according to rule-based algorithm
o Developed an online Call Plan Management Tool to provide users with business actionable insights and the ability to perform self-service analytics
Technical Skills
Microsoft Office: Word, Excel, Access, PowerPoint
Others: SQL, Tableau, Power B
Education
Lehigh University, Bethlehem, PA
B.S. Mechanical Design, Manufacturing and Automation (Jun 2012)
Tongji University, Shanghai, China
