Data Analyst

SHUMIN SHI

Seattle, Washington *************@*******.*** 206-***-**** www.linkedin.com/in/shuminshi EDUCATION

University of Washington – Michael G. Foster School of Business Seattle, WA Master of Science in Information Systems GPA: 3.79/4.0 Jun 2019 Nanjing University of Posts and Telecommunications Nanjing, China Bachelor of Engineering in Computer Science GPA: 3.8/4.0 Jun 2018 SKILLS

• Skills: Data Analytics, Data Visualization, Data Mining, Statistical Modeling, Data-driven Decision Making, Business Operation Management, Quantitative Methods, Regression Analysis, Marketing Analysis, Text Mining, Business Intelligence, Excel, Google Suite, Microsoft Suite.

• Programming Language: Python, R, SQL, Google Script, Java, VBA. WORK EXPERIENCE

Geocko, Inc. dba LiveStories Seattle, WA

Data Analyst / Customer Operation Aug 2019- Mar 2020

• Developed python programs to streamline and automate data ingestion for tens of datasets simultaneously, reduced ingestion time by multiple hours per update.

• Created visualized public health data reports and indicators for customers. Collected, cleansed and formatted raw data to fit data model by using advanced Excel.

• Created visualized dashboards by using Google Data Studio platform to improve the data retrieving efficiency for the customer operation team. This mainly included developing Google Scripts to automate Google Analytics data ingestion and using SQL in Big Query platform to prepare data for interactive charts.

• Conducted text mining for marketing team by using R programming. Generalized keywords patterns for datasets with 3,000+ records to help marketing team improve search-engine optimization.

• Served as the bridge between the customer operation team and the engineering team, analyzing the way how raw data should be ingested as our indicators, and identifying software bugs. Implemented quality control, reviewed ingested indicators, datasets, and data reports.

• Familiarized with federal and state public health data, including data from Centers for Disease Control and Prevention (CDC), Census Bureau, Behavioral Risk Factor Surveillance System (BRFSS) and so on. Nanjing Institute of Advanced Laser Technology Nanjing, China Software Development Intern Sep 2017 – Oct 2017

University of Washington Seattle, WA

Student Assistant Sep 2018 – May 2019

Agricultural Bank of China Nantong, China

Customer Operation Intern Jan 2015 – Feb 2015

SCHOOL PROJECTS

Oct 2018 - Nov 2018 Data Analysis in “Vinho Verde” Wine Quality

• Established wine quality predication models with strong predictive power by deploying different machine learning methods by using Python and R. Cleaned and visualized dataset with 10,000+ records. Conducted correlation analysis, and solved overfitting and multicollinearity problems. OTHER EXPERIENCE

NUPT Orchestra Nanjing, China

Violinist Sep 2014 – Jun 2018

Contact this candidate