Zihao Zhao

Project Client: King's Hawaiian • Analyzed marketing data from over 50 properties and 70000+ observations using Python and SQL in a team of 6 • Identified key variables driving sales, and utilized hypothesis-testing to determine the significance of digital marketing campaigns • Built a linear regression model capable of explaining 81.9% of the variation in ROI of marketing tactics • Created a dashboard that visualized the volume sales boosted by each of 9 marketing activations across all the products

• Led team to be one of top 50 teams with a high model f1-score of 0.85 • Explored, cleaned, and transformed Humana's longitudinal data with 800+ features and 60,000+ observations • Built a binary classification model to predict possible transportation issue of 16000+ members • Utilizing predictive modeling to proposed targeted recommendations and future considerations for providing Humana members with transportation support

• Analyzed consumption patterns of consumers in the Bay area and optimized development plans for 4 cities • Negotiated with more than 50 small business owners and established cooperation relationships with over 20 of negotiated owners • Monitored sales data and coordinated with businesses to implement promotion plans that boosted overall sales by 15% • Reported price and policy changes weekly and predicted market growth based on seasonal data

• Led initiation and establishment of Ohlone Chinese student association serving over 300 students • Raised initial fund of 2500 dollars and publicized association via multiple media channels • Designed advertising posters and flyers that attracted more than 40 students to join in 3 weeks • Coordinated leader team to plan and operate 4 college-level events to enhance the association's influence

• Processed payments by check, cash debit, and credit, maintained accurate drawers. • Engaged customers warmly and provided immediate and dedicated assistance. • Reviewed and resolved differences between accounting information and cash drawer. • Reviewed weekly sales circulars and monitored price changes.

Top 10 Global Ranking (QS World University Rankings 2021 - Masters in Business Analytics) Department of Data Science and Operations - Coursework: ∙ The Analytics Edge: Data, Models, and Effective Decisions ∙ Business Analytics ∙ Data Driven Decision Making ∙ SQL Databases for Business Analysts ∙ Statistical Computing and Data Visualization

Top 20 Global Ranking (QS World University Rankings 2021 - BS in Economics) Department of Economics - Coursework: ∙ Operation Research ∙ Corporate Finance ∙ Financial Accounting ∙ Marketing ∙ Business Forecasting ∙ Financial Markets ∙ Decisions Under Uncertainty ∙ Microeconomics ∙ Macroeconomics ∙ Econometrics ∙ International Trade