Data Analyst

Guofen Dai (Green Card Holder) 248-***-****

***** ******* **., ****, **, 48374

************@*****.***

EDUCATION

Walsh College (Troy, MI)

M.S. Information Technology (Data Science)

GPA 3.77/4

09/2017-06/2019

Key Courses: Business Analytics, Data Science, SQL and Dimensional Data Analytics, Data Visualization & Predictive Modeling, Big Data Analytics, Enterprise Architecture, Project Management, Cybersecurity, Financial & Intermediate Accounting

Ningbo University (Ningbo, China)

M.A. Economic Management

GPA 94/100

09/2009-03/2012

B.A. Administrative Management

GPA 80/100

09/2005-06/2009

EXPERIENCE

IT Related Course Projects 09/2017 – 06/2019

Big Data Report of the Film Market: Conducted data analysis with Python, analyzed the Douban Movie datasets and completed the "Big Data Report of the Film Market ".

Top 5000 YouTube Channels Data Analysis Project: Performed exploratory data analysis and visualizations with python to reveal possible correlations and insights.

Census Income Dataset Analysis: Analyzed Census Income Dataset in Python, used random forests model and decision tree model to predict the income class of US population.

Application of Big Data in Marketing: Studied application of big data in CRM, precision marketing and data-driven decision-making in the Auto Industry.

Block Trading Market Analysis: Analyzed the Block Trading Market datasets with Stata; performed data visualization operations and regression analysis.

Predicting Customer Churn: Analyzed the Telcom datasets with R and Excel; built statistical models with R to infer and predict customer churn.

Cable Television vs. Streaming Services Analysis: Analyzed Business Models, Financial Statements, Revenue and Growth Strategy for Cable TV and Streaming Service providers; conducted SWOT analysis of each provider for investors.

Served as Project Manager for a Telecommunications Overhaul Project: Developed the project plan; managed all project tasks, schedule, and communication regarding the project.

System Modeling for WeChat Growth: Developed the WeChat Growth Model with the application of system dynamic modeling method; conducted the Stakeholder Analysis on WeChat.

Undergraduate Advisor and Instructor in Shaoxing University (Shaoxing, China) 06/2012-04/2016

Led the student team for National College Student Business Plan Competition named “Challenge Champion”.

Taught Courses of “Consumer Psychology and Behavior”, “Intro to Psychology”, and etc.

Organized student events and volunteer activities for orientation, festivals, and sport games (including events reported by NetEase, newspapers and TV channels).

SKILLS

IT & Data Analysis: Python, Hadoop, R, SQL, Tableau, Stata, Excel, Visio, PowerBI

Language: English, Chinese

Contact this candidate