Data Design

Xiaowan Chen

*** * **** **., *** Jose, CA, ***** 870-***-**** *******.********@*****.***

Objective Fulltime data analysis

Education

Arkansas State University

MS Mathematics GPA: 4.0/4.0 August 2018

Coursework: Complex Analysis; Time Series; Abstract Algebra; Data Analysis; Design of Experiment BS Business Management GPA: 3.6/4.0 August 2016

Skillset and Certification

Languages:

SQL Queries and script, data import/export

R Expertise in sampling methods, modeling, regression, analysis of variance, time series analysis and forecasting, PCA in RStudio

SAS Intermediate programming in statistical modeling, experimental design, multiple comparisons SPSS Applied probability, statistical computation, simulation and modeling selection Others: Minitab; Python; Power BI

Certification: SAS Certified Base Programmer for SAS 9 Projects

Predict if a flight would be on-time

The project is about using the machine learning workflow to process and transform DOT data to create a prediction model. This model must predict whether a flight would arrive 15+ minutes after the scheduled arrival time with 70+% accuracy.

• Molded the data in R by transforming the data types of columns into data types that work best for machine learning such as eliminated rows that could not use and changing the data types in columns that needed. Also verified the data for prediction and discussed data rules.

• Selected an algorithm based on machine learning types, ensuring the result type, reviewing the complexity of the implementation, and choosing basic over enhanced versions of the algorithm

• Utilized the Caret package in R (this package contains functions that made easy to split the data into training and test sets, and then train the model), used this package to split the data, then passed training data to the algorithm to create a trained model

• Evaluated the performance of logistic regression trained model against test data, by using the predict function to generate a prediction of how well the model predicts and using the confusion matrix function to review the prediction performance of the model Ease of doing business overseas

The project is about data study and tries to help businessperson better understand foreign countries, and more useful for decision-making.

• Cleaned and analyzed difficult datasets in R, and Selected statistical designs for project based on studies; Performed analyses such as descriptive statistics, regression modeling, ANOVA, multi-factor ANOVA, experimental design analysis, multivariate analysis, survey analysis, variable selection recommended applicable statistical techniques and communicated the results through the generation of summary reports of findings Work experiences

FengXun Network Co. May, 2017 - August, 2017

Location: Nanchang, China Summer intern: SQL Developer

• Used MySQL to design a database for all users, wrote SQL queries using all kinds of joins, subqueries to retrieve data from the database

• Implemented the design with different useful objects such as views, functions and stored procedures

Arkansas State University January, 2017- August, 2018 Location: Jonesboro, AR

Graduate Teaching Assistant

• Taught and held office hours which were available to all students with college algebra

Contact this candidate