Business Analyst Data

WE*YuDMU************

EDUCATION

Washington University in St. Louis, St. Louis, MO

Master of Science in Business Analytics

Aug 2022 - Dec 2023

GPA: 3.85/4.0

This degree is qualified for a STEM designation and eligible for 36 months of OPT without sponsorship University of Queensland, Brisbane, Australia

Bachelor of Commerce, Major in Finance

Feb 2018 - Jun 2022

GPA: 3.71/4.0

Honors: Dean's Commendation for Academic Excellence PROFESSIONAL SKILLS

Technical Skills: Stata, Python (Pandas, NumPy, Scikit Learn, TensorFlow, PySpark), SQL (MySql, PostgreSql, Hive, Hadoop), R (dplyr), Tableau, Power BI, QlikView

Language Skills: English (Proficient), Chinese Mandarin (Native) WORK EXPERIENCE

Club Med

Business Intelligence Intern

Feb 2022 - May 2022

Shanghai, China

Applied technical skills using Excel Pivot Table to visualize customer relationship management reports Extracted over 1,000,000 sales data using QlikView, transformed, and visualized sales data using Power BI and Tableau Analyzed sales data, completed sales reports, and assisted the line manager in presenting sales reports at weekly sales meetings

Collected the market occupancy data and visualized data into graphs in Excel Xiangtan Honghua Commercial and Trading Co., Ltd

Business Analyst

Jul 2020 - Jun 2022

Xiangtan, China

Market Research: Organized and carried out regional Chinese traditional liquor market share research, analyzed company’s competition situation by monitoring KPIs and applying SWOT, PEST, and Porter’s five forces methods Financial Analysis: Evaluated company’s performance by visualizing sales data with Tableau PROJECT

Facial Expression Recognition System Development (Python) Advisor: Dr. Salih Tutun, Washington University in St. Louis Oct 2022 - Dec 2022

Project Planning: Project Co-drafted project proposal to show the potential financial benefits of implementations of the facial expression recognition system for business firms Data Collection: Generated over 40,000 facial expression images in Kaggle for facial expression recognition system development

Data Prediction: Preprocessed the database and applied CNN, and LSTM to develop facial expression recognition system and achieved 80% of accuracy

Big Data & Cloud Computing Class Project (Python) Oct 2022 - Dec 2022 Data Collection & Cleaning: Collected 1.4 GB U.S. used vehicle data from Kaggle, preprocessed the database with Pandas and NumPy

Data Analysis: Deployed multiple methods (Linear Regression, Logistics Regression, Decision Tree, Random Forest, Boosted Tree) in PySpark to analyze the major factors that influenced the prices of used vehicles in the U.S market and built used vehicles pricing prediction model

Data Visualization: Built a model to find feature importance and visualized the feature importance with ggplot Database Management System Development (MySQL Workbench) Advisor: Ms. Jennifer Grant, University of Queensland Mar 2022 - May 2022

Project Planning: Co-drafted project proposal to show the potential benefits of the implementation of the database management system and narrative of the functions of the database management system Database Design: Drafted entity-relationship diagrams and organized data dictionary by tables and SQL scripts SQL Queries: Created data for database function detection and wrote SQL queries to detect database usage functions Yuanxin Zhao

585-***-**** 丨yuanxin.******@*****.***

www.linkedin.com/in/yuanxin-elv-zhao

Contact this candidate