Data Analyst Assistant

JACK (ZIDU) YIN

Email: ****.***@*****.*** Tel: 860-***-****

LinkedIn: https://www.linkedin.com/in/jack-zidu-yin/ Technical Skills

Programming languages: Python (Pandas, NumPy, Sklearn, Seaborn, Keras, Re, etc.), R, SQL (Join, Case When, etc.), Access, VBA Tools: Tableau, Microsoft Excel (Pivot Table, VLOOKUP, SUMIF, MATCH, etc.), SAS, JMP, STATA, MS Visio, MATLAB Analysis Techniques:

• Classical & Penalized Regression Methods (Lasso, Ridge), K-Means, Random Forests, Neural Network, Naïve Bayes, Ensemble Modeling, Discriminant Analysis, K Nearest Neighbors, Principle Component Analysis (PCA)

• Text Mining, Natural Language Processing, Exploratory Data Analysis, A/B Testing, Time Series Analysis Capstone Project

Potoo Solutions, Norwalk, CT

Graduate Analyst Consultant (Python) Jan-May 2020

• Aggregated seller and source data with 10M records, visualized all the sellers across the US in a map, encoded text variables into dummy variables, and applied feature engineering to generate useful variables from previous ones

• Developed Random Forest, Decision Tree, Neural Network and Multi-label logistic regression (best model)

• Selected the Multi-label Logistic regression with almost 80% accuracy to predict which source sellers get their product from.

• Analyzed p-values and coefficients of variables and provided further recommendations Academic Experiences

The University of Connecticut, Stamford, CT

Graduate Teaching Assistant: Business Decision Modeling Class (Excel) Jan-May 2020

• Researched how to run a macro from another macro and how to use Windows Task Scheduler to run a macro and made tutorials for students by writing step by step instructions in a word doc and recording videos in Microsoft PowerPoint

• Provided guidance for students about how to use pivot table and functions like VLOOKUP, SUMIF, MATCH, INDEX, etc.

• Scored assignments and exams about network problems, linear optimization, Monte Carlo Simulation, and sensitive analysis. Nighttime light and population dynamics Project (Python) Aug-Sept 2019

• Inspected data, shuffled data randomly, performed normalization on explanatory variables, performed PCA on entire dataset, set random seed and partitioned data into training, validation and test dataset

• Fitted a baseline model, a random forest with hyperparameter tuning and a neural network with dropout method

• Performed 10-fold cross validation on the training dataset and applied models to the test dataset

• Evaluated models by comparing MAE of each model on three datasets, scatterplots of actual and predicted values and boxplots of errors and chose the best model for future decision making and recommendations Reducing Traffic Mortality in the USA (R Programming Language) Oct-Nov 2018

• Imported data from CSV files and created a textual and a graphical summary of the data

• Fitted a linear regression to find relationship between target and features and split features by performing PCA

• Applied K-Means to visualize clusters in the PCA scatter plot, computed the number of accidents within each cluster and decided to use one cluster to focus on for policy intervention and further investigation Fashion Company Project (Oracle SQL, MS Visio) Oct-Nov 2018

• Gathered data from several fashion companies and designed ER diagram using MS Visio

• Created 18 data tables in Oracle database and inserted records into the tables

• Wrote complex SQL queries to extract information about the highest revenue and quantity grouped by products Professional Experience

Capital Environment Holdings Ltd (HKEX: 03989), Beijing, China Data Analyst– Intern (MS Excel) July-Sept 2016

• Used Pivot Table to show total sales and profit from 2012 to 2015 and adopted VLOOKUP function to pinpoint the value of price, simplifying table structure

• Applied VBA and Macro to import data in 20 workbooks and to combine four-week department data into one monthly report, improving work efficiency by almost half an hour

Educations

University of Connecticut School of Business

Master of Science in Business Analytics and Project Management (S.T.E.M) GPA: 3.8/4.0 May 2020 Jiangxi University of Finance and Economics

Bachelor of Economics, Finance GPA: 3.5/4.0 June 2018

Contact this candidate