Zhenhao Yan

517-***-**** adyvx7@r.postjobfree.com www.linkedin.com/in/zhenhao97

Education

University of Pittsburgh, Joseph M. Katz Graduate School of Business April 2022 Master of Science in Marketing Science + Business Analytics Pittsburgh, PA Michigan State University, Broad College of Business December 2019 Bachelor of Art in Hospitality Business East Lansing, MI Professional Experience

CorePower Magnetics May 2022-July 2022

Marketing Research Specialist Pittsburgh, PA

• Evaluated current electric vehicles market and predicted EV market, including forecasting sales and market share, in the next 5-10 years

• Assessed electric vehicles’ supply chain and CorePower Magnetics’ main competitors by analyzing the existing supply chain to identify main competitors

• Leveraged secondary research reports to find potential partner companies for CorePower Magnetics

• Developed promotion plan and strategies, such as attending expos and implementing traditional advertising methods, for CorePower Magnetics’ product

Mega Cat Labs/Mega Cat Studio June 2021-July 2021

Digital Marketing Internship Pittsburgh, PA

• Discovered current market of blockchain games and its users/player

• Pioneered gaming industry event and obtained potential speakers

• Boosted sales in Steam by click funnel, customer journey, personas, A/B testing strategies and Steam pages optimization

Pediatric Palliative Care Coalition (PPCC) June 2021-July 2021 Consultant, PPCC Mobile App Pittsburgh, PA

• Analyzed current healthcare apps market across different platforms, including android and IOS by referencing Top 5 Healthcare Apps as measured by downloads

• Proposed possible business/Financial models for PPCC’s future operation; referred to other NGO operation models to make recommendations

• Built a list of potential Grantmakers by researching similar NGOs where PPCC may meet donation requirements Graduate Projects

Business analysis: CarMax analytics Showcase October 2021

• Data Validation: Ensured input data’s correctness, meaningfulness, and security

• Evaluation: Tested data set to identify significant variables that may affect the company’s goal

• Interpretation: Analyzed current market and data set, composed feasible proposals for future operations Machine Learning & Forecasting: Preventing food deserts in United States January 2021

• Data Cleaning: Transformed data into readable input in Excel by Python

• Develop Indicator: Analyzed food desert data variance to perform a sample significance difference test in SPSS modeler

• Machine Learning: Applied linear and logistics regressions to establish model and predict best treatment scheme

Market Research: Heineken 0.0 September 2020

• Questionnaire Design: Established targeted questions to collect critical information, including consumer demographics, drinking habits, favorite beer brand, etc.

• Correlation Analysis: Determined significant variables that can potentially affect consumers’ beer brand selection and collected data sets by SPSS

• Reporting: Explained the significant relationship among interaction variables; presented results with appropriate interpretation

Data Analysis & Visualization: Adobe Analytics Challenge October 2020

• Data Visualization: Visualized and filtered required sales and history data from provided data set

• Data Analysis: Explored relationship between numerical and categorical data

• Prediction: Utilized existing data to analyze and forecast; created suggestions to increase future sales Skills

• Tools: Python, SQL, R, Tableau, IBM SPSS, and SPSS Modeler, Statgraphics, Microsoft Excel (Proficient in most functions: VLOOKUP, pivot table), Google Ads & Analytics

• Professional Skills: Data Mining, Database Management, Data Visualization, Statistical Modeling, Forecasting, Machine Learning, Project Management, A/B Test, Regressions

Contact this candidate