Data Analyst Sales

Mingwei (Show) Wu

***********@*****.*** 510-***-**** San Lorenzo, California

http://www.linkedin.com/in/mingww https://github.com/Wu-Mingwei EDUCATION

California State University, East Bay, Hayward, CA Mar 2018-May 2020 M.S. in Applied Statistics GPA: 3.76

Huali University, Guangdong, CN Sep 2010–June 2015 B.A. in Business Marketing, customer data analytics GPA:3.32 Skills: MySQL, R, Tableau, NoSQL, SAS, Microsoft Office, Python, Power BI, SPSS, Minitab. Relevant Courses: Model Optimization, Bootstrap, A/B testing, Hypothesis testing, Statistical Inference, ANOVA, Modeling Selection, Data Mining. Academic Project

HR Analysis on Employee Turnover (RStudio) Jul 2020–Oct 2020

• Conducted data manipulation to ensure data completeness, consistency, accuracy and extract data for future analysis for understanding the reasons of employees’ turnover by connecting MySQL database to RStudio.

• Provided turnover insights by using logistic, linear regression and generating data visualization via histogram table, Boxplot with packages ggplot2, tidyverse etc.

• Calculated accuracy and precision by split values into ML (Machine Leaning) for using Bayesian theory to demonstrating model Sensitivity and Specificity.

• Increased 73% ROI for employee turnover by model calculates. A/B testing with website clicked (RStudio) Sep 2020–Oct 2020

• Manipulated the data to test the conversion rate of number of clicks on the website by using A/B testing with RStudio.

• Extracted and rewritten the data frame from online with MySQL, and connected with RStudio to calculate the rate of different variables.

• Analyzed the change factor of click amount, as well as change amplitude and change reason via sequential analysis by scatter point.

• Visualized the data and used T-test to analyze the difference of two groups. Industries salary analysis (RStudio and SAS) Sep 2019 – Nov 2019

• Analyzed the distributions of industries salary to provide the hire strategy by using SAS and RStudio.

• Generate the data visualization to demonstrate the relationships of variables by scatter point, Boxplot, histogram table, and K-means by heatmap etc. improved accuracy by using Lasso and Ridge regularization.

Experience

Associated Data Analyst

Jiayile, Guangdong, China May 2014 – Feb 2015

• Saved 20% time for data exporting and analysis by optimizing the scheme of the database to store retail sales and inventory information.

• Built real-time dashboards for inventory management and demanding plan by executing ETL process in SQL database and creating pivot table, VLOOKUP function, charts, etc. in excel.

• Collaborated with the product team to increase promotion sales on holiday by 10% and sufficient stocks via predictive analytics on KPIs for different products.

Contact this candidate