-
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
-
Projects
Academic Experiences
The University of Connecticut, Stamford, CT
Graduate Teaching Assistant: Business Decision Modeling using Excel Class Spring 2020
• Research how to run a macro from another macro and how to use Windows Task Scheduler to run a macro and make tutorials for students by writing step by step instructions in a word doc and recording videos in Microsoft PowerPoint
• Provide guidance for students about how to use pivot table and functions like VLOOKUP, SUMIF, MATCH, INDEX, etc
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 KMeans 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