Weiyi Zhang

214-***-**** adcma1@r.postjobfree.com linkedin.com/in/weiyi-zh

EDUCATION

Southern Methodist University, Cox School of Business Dallas, TX Master of Science in Business Analytics GPA: 3.93/4.0 Aug 2019 - Present Coursework: Programming for Analysis, Data Visualization, Business Intelligence, Data Mining, Big Data Platform Capital University of Economics and Business Beijing, China Bachelor of Economics GPA: 3.5/4.0 Sep 2015 - Jul 2019 Coursework: Advanced Mathematics, Econometrics, Probability and Statistics, Time Series Analysis, Economic Math Method TECHNICAL SKILLS

SQL • R • Tableau • Power BI • Alteryx • Python • Database • Data Warehouse • Machine Learning • Prediction Modeling LICENSES AND CERTIFACATES

Tableau Desktop Specialist Certification • Alteryx Designer Core Certification • Data Manipulation in R • SQL for Data Science PROFESSIONAL EXPERIENCE

PriceWaterhouseCoopers (PwC) Beijing, China

Risk Assurance Intern Jan 2018 - Apr 2018

• Worked with PSBC, a large Chinese bank, to perform risk analysis and build classification models to detect fraudulent credit card transactions in order to increase the efficiency of detection

• Extracted and cleaned raw data from the credit card transaction Data Lake using R (dplyr, tidyr)

• Developed a K-means Cluster model to group PSBC credit card holders into different clusters, and utilized Random Forest to build fraud transaction predictive models to detect fraud transactions; Achieved an 80% detection accuracy rate

• Identified which variables had the highest ranking and presented the classification matrix to supervisor and clients Siemens Beijing, China

Sales Excellence Intern Jan 2019 - Jul 2019

• Analyzed sales data to identify customer churn, evaluate sales performance, implement retention strategies and increase profit

• Extracted customer historical data, customer demographic data and sales data from Siemens Data Warehouse using SQL

• Built charts and interactive dashboards to visualize Key Performance Indicators (KPIs) and Metrics using Tableau

• Generated business insights including core customers, valueless customers and sales order yearly and seasonally changes

• Collaborated across departments to make future sales plan and strategies to maintain customers and increase sales Heng Tai Securities Co., Ltd Beijing, China

IBD Intern Jun 2018 - Aug 2018

• Built ARIMA and GARCH prediction models using R to forecast the rise and fall duration of stock prices

• Predicted and compared daily logarithmic return to demonstrate the disposition effect in the Chinese stock market

• Collected and cleaned 3,024 historical day trading records depicting the closing price of Shanghai stock composite index

• Applied the result of the disposition effect from the model and helped the manager make decisions to buy and sell stocks SELECTED ACADEMIC AND FIELD PROJECTS

Pricing Analytics Capstone with Murphy USA Jan – Apr 2020, Dallas

• Analyzed Murphy’s oil price data and built prediction and demand elasticity models to understand the impact on the company’s demand and pricing strategies, presented the dashboards to the Murphy USA analyst team

• Forecasted gas volume demand of 95 stores in the Fort Worth Area using ARIMA and Neural Network models in R

• Created demand elasticity models applying Log-Log Regression to find out the importance of more than 10 variables

• Built dashboards to display the elasticities at store level and showing the effect of demand on pricing using Power BI Applied Predictive Analytics of NFL Oct – Dec 2019, Dallas

• Processed outliers and missing values of both numeric and category variables of more than 1000 NFL games and performed exploratory data analysis with descriptive statistics and visualizations

• Built classification models including Logistic regression and AdaBoost to predict the winning team for future games

• Evaluated model performance with fitting graph, learning curve, lift curve, ROC and AUC with an overall accuracy of 73% Database Design Oct – Dec 2019, Dallas

• Built a user interface for users to perform movie searches based on recommendation and ranking functions

• Designed an ER-model for the IMDB movie database and create a relational database using SQL

• Developed the user interface using R shiny which included the ability to Create, Read, Update and Delete movie data

• Presented analytical findings and insights about actor performance and trends of different movie types Data Visualization Project with PSAV (Team Leader) Aug – Oct 2019, Dallas

• Worked with PSAV, an event management company, to streamline how users access existing reports

• Cleaned and analyzed data using Alteryx, built and updated queries and dashboards utilizing Tableau, improved system efficiency for different user levels by assessing relevant KPIs and establishing different dashboards for specific user groups

Contact this candidate