Data Analyst Assistant

Alan Zhang

**** ****** **., *******, ***** *****

Mobile: 832-***-****, Email: addpxr@r.postjobfree.com Data Analyst

Multifaceted technical abilities with track record of innovation and success Highly analytical and process-oriented data analyst with in-depth knowledge of database types; research methodologies; and big data capture, curation, manipulation and visualization. Furnish insights, analytics and business intelligence used to advance opportunity identification, process reengineering and corporate growth. Fluent in English, Chinese Mandarin, and Cantonese.

TECHNICAL PROFICIENCIES

Programming: Python, SQL, R, HTML VBA

Tools: Tableau, Power BI, Microsoft Office Suite, MS Access, MS Project, Excel, Pivot Tables Skills: Data Mining, Optimization, Big Data Analytics, Machine Learning, Linear Regression Model, Tree Model, Random Forest, Bagging, ANN (Artificial Neural Network), KNN (k-nearest neighbor), PCA (Principal component analysis), SVM (Support Vector Machine), k-mean clustering. PROFESSIONAL EXPERIENCE

Data Mining Academic Project (1/2019 – 5/2019) Pima Health Information with R Major participant in constructing decision tree model and an Artificial Neural network. Strong ability to calculate the accuracy and error rate of predictions that a subject is diabetic. Compared and chose the best model while simultaneously filtering out variables that could be influential factors. Visualization for Historical Analysis Project (1/2019 – 5/2019) Olympic Game Athletic with Tableau Found key differences between athletes’ personal data and the effect on winning Olympic medals. Analyzed data and verified hypothesis using Tableau. Proposed various questions related to main goals with Olympic data and later validated them.

Linear Regression Academic Project (9/2018 – 12/2018) Y Responses of Per Capita Income Efficiently predicted the per capita income if county based on numerous indicators and variables. Built a linear regression model and chose the best fit using R. Narrowed project down to six predictors with the greatest influence and successfully found linear relationships between predictors and income. Internship of Research Assistant (5/2019-7/2019) University of Houston Extracting raw data from blur magazine from year 1977 to 2019. Using VBA and Python to clean and merge data. Applying Ridge and logistics Regression models, Bagging and Random Forest model on cleaned and merged data. Found relationship between several explanatory variables and response variable. Judge Assistant (3/2018– 7/2018) Huizhou City, Guangdong Province, Huicheng District Court Coordinated with the judge on civil information management and efficient organization. Processed data management in data electronic formation and storage. Analyzed data from law materials and filtered out data for transition to other district courts.

Data Analyst (9/2017 – 2/2018) Huizhou Boluo County, Statistical Bureau Praised for extracting 15 months of data from previous statistical research using SQL commands while simultaneously filtering and cleaning 200K+ raw data using R. Applied time series analysis and forecasted the trend of local res. values in the next five years.

EDUCATION AND TRAINING

MS in Statistics & Data Science - University of Houston, Department of Mathematics (2019) GPA:3.76 BBA in Management Information Systems - Midwestern State University (2017) GPA:3.375 Bachelor of Administration in Business Administration - Guangdong Pei Zhang College (2015) GPA:3.0

Contact this candidate