Data Analyst Assistant

Guanqi Cheng www.linkedin.com/guanqicheng

**** * ******** **, *****, AZ 85282 765-***-**** ********@***.*** Education

W. P. Carey School of Business at Arizona State University, Tempe, AZ May 2018 Master of Science in Business Analytics (MSBA)

Cumulative GPA: 3.76/4.00

Purdue University, West Lafayette, IN May 2017

Bachelor of Science in Computer Science, Statistics Major Concentration: Computer Graphics & Visualization, Applied Statistics Cumulative GPA: 3.42/4.00

Professional Certifications

• SAS Certified Base Programmer for SAS 9

• SAS Certified Advanced Programmer for SAS 9

• SAS Certified Statistical Business Analyst Using SAS 9 Professional Qualifications

Software: Excel, SAS, R, SQL, Tableau, StatTools, @Risk, Azure, minitab, Matlab, SPSS, Julia, GDB, Git, Vim, Eclipse Programming Language: Python, C/C++, Java, JavaCC, ARM Language: Chinese, English, Elementary proficiency of Japanese Working Environment: Windows, Linux, Mac OS

Professional Experience

Computer Science Teaching Assistant Jan 2017 – May 2017 Purdue University, West Lafayette, IN

• Instructing the lab session of CS240 C Programming in C.

• Help students have trouble in coding and debugging. Data Analyst Intern May 2017 – Aug 2017

Qingdao Ever Fortune Industrial Co., Ltd., Qingdao, Shandong, China

• Using Excel to collect and manage current selling data with StatTools and Pivot Table

• Collaborated with a team to effectively analyze historic sale data with Python code to forecast for the next year with Moving Average and Holt’s Model. Technique Assistant Intern May 2016 – Aug 2016

Qingdao Power Rigging Int’l Co., Ltd., Qingdao, Shandong, China

• Designed and implemented relational database using C and Oracle SQL Developer

• Analyzed and visualized data in Excel with Pivot Table and Pivot Chart Professional Project

Kaggle Competition: Homesite Quote Conversion Aug 2017 – Dec 2017 Arizona State University, Tempe, AZ

Led a team of three to develop a comprehensive analyze for machine learning Using MySQL, Python, Excel and visualization tools to clean and format data for preview. Attempt several models like Boosted Decision Tree or Neural Network on Microsoft Azure. Grid Bike Hub Parking Optimization Aug 2017 – Dec 2017 Arizona State University, Tempe, AZ

Collaborate with three team members to grab and discuss data Improved efficiency for number of bike to put at each hub and replace broken bikes using data driven quality tools and Six Sigma methodologies to achieve balance of number at each hub. Forecasted monthly rental and return at hubs to help plan its marketing campaign using optimization modeling and regression.

Contact this candidate