Ziheng He
WASHINGTON
Summary
Results-driven Market Research Analyst with expertise in SQL and predictive modeling, previously at Management Science Associates, Inc. Spearheaded analytics programs that enhanced market share for Coca-Cola and developed tools that boosted casino revenue by up to 15%. Adept at translating complex data into strategic insights, fostering collaboration across teams.
Overview
12
12
years of professional experience
Work History
Market Research Analyst II
Management Science Associates, Inc.
Pittsburgh
04.2020 - Current
- Led cross-industry analytics programs for Kellanova, PepsiCo, and Oscar Health, integrating de-identified EHR data with NielsenIQ consumer panels and retail datasets to evaluate GLP-1 therapy’s impact on purchasing, nutrition trends, and brand performance.
- Partnered with product, sales, analytics, and engineering teams to translate market behavior data into product opportunity assessments, including brand fair share, package size preference shifts, and emerging health-forward segments.
- Delivered strategic recommendations that informed product roadmaps, portfolio optimization, and market entry strategies for multiple clients.
- Designed integrated data frameworks combining retail, healthcare, and promotional data, enabling predictive modeling and performance tracking across product lines.
- Achieved measurable market share growth for Coca-Cola by identifying regional product gaps and refining distribution strategy.
- Produced dashboards and actionable reports for executives using SAS, SQL, Excel, and Tableau.
Market Research Analyst I
Management Science Associates, Inc.
Pittsburgh
11.2013 - 04.2020
- Built a real-time 'Chance of Leaving' tool using decision trees and Python, improving player retention for casino clients.
- Designed slot payout optimization models that increased casino floor revenue by 10–15%.
- Conducted clustering and behavioral segmentation analyses to refine promotional strategies across retail and gaming products.
Education
Master of Business Administration -
Johns Hopkins Carey Business School
Washington, DC12.2025
Bachelor of Arts - Mathematics & Economics
Oberlin College
Oberlin, OHSkills
- SQL proficiency
- Predictive modeling techniques
- Analytical problem resolution
- Programming languages: R, SAS, Python
- Excel and Tableau skills
- Business intelligence tools
Selected Projects
- GLP-1 Consumer Impact & Product Opportunity Analysis (Kellanova, PepsiCo, Oscar Health), 2023–Present, Directed an end-to-end analytics program integrating EHR, NielsenIQ, and retail sales data to assess therapy-driven changes in purchasing behavior across five CPG categories. Delivered product-level insights on category volume shifts, attribute preferences, and brand positioning, enabling portfolio strategy and channel optimization for CPG and healthcare products., SAS, SQL, Excel, Tableau
- Coca-Cola Market Share Expansion, 2024, Developed an analytics-driven targeting strategy for underperforming regions, identifying product distribution gaps and optimizing promotional focus, resulting in measurable share growth., Excel, SAS
- E-Cigarette Competitive Analysis for JUUL Labs, 2021–2023, Analyzed regional promotional efficiency and trial/repeat purchase behavior, recommending segmentation-based campaign adjustments to improve product uptake.
- Cross-Platform Analytics Framework, 2020–2023, Created an integrated analytics environment for combining healthcare, retail, and promotional data, supporting predictive modeling and market simulation for multiple product portfolios.
- Casino Behavior Modeling & Optimization, 2016–2020, Developed churn prediction and slot machine optimization models, increasing customer retention and floor revenue.
Timeline
Market Research Analyst II
Management Science Associates, Inc.
04.2020 - Current
Market Research Analyst I
Management Science Associates, Inc.
11.2013 - 04.2020
Master of Business Administration -
Johns Hopkins Carey Business School
Bachelor of Arts - Mathematics & Economics
Oberlin College
Similar Profiles
Evelyn FosterEvelyn Foster
Senior Accountant at Management Science AssociatesSenior Accountant at Management Science Associates
Grayson WatsonGrayson Watson
Quality Assurance Documentation Specialist at North American Science Associates (NAMSA)Quality Assurance Documentation Specialist at North American Science Associates (NAMSA)
Catherine PaulCatherine Paul
Site Security Contract Administrator at Jefferson Science Associates (Thomas Jefferson National Accelerator Facility)Site Security Contract Administrator at Jefferson Science Associates (Thomas Jefferson National Accelerator Facility)
Victoria HawkinsVictoria Hawkins
Records Management Specialist at Blackfish FederalRecords Management Specialist at Blackfish Federal
Trenton SmeltzerTrenton Smeltzer
Water Restoration Technician at 1-800WaterDamageWater Restoration Technician at 1-800WaterDamage