Data Analytics

LIH JING

***********@*.************.*** • 614-***-****

• 4250 N. Marine Drive Apt 602, Chicago, IL 60613

Education

Northwestern University, IL March 2021- Sep 2022

Master of Data Science GPA: 4.0

Coursework: Database Systems and Data Preparation, Applied Statistics with R, Math for Data scientists, Decision Analytics, Practical Machine Learning

The Ohio State University, OH September 2010 – August 2015 Fisher College of Business, Bachelor of Science in Accounting Coursework: Statistical Techniques, Financial data, Calculus and Analytic Geometry, Modeling and Applications, Computer Aided Problem Solving for Business, Decision Sciences: Operations Research Work Experience

Worldbook, Chicago, IL Financial Analyst May 2021 – December 2021

• Prepared forecast reports to estimate future performance using historical data and industry knowledge.

• Maintained accounting database by input new data, update with actual data and revising incorrect data.

• Automated replication for accounting computation process to validate suspicious numbers in Excel. Safer Foundation, Chicago, IL Staff Accountant July 2019 – May 2021

• Tracked project progress and expenses and alerted manager if a project is delayed or over budget.

• Developed templates to automated credit report processing and data input. UPS, Columbus, OH Payroll Associate August 2017 – May 2019 Academic Projects

Loan Default Prediction Model

• Built a model to predict default probability of clients. Applied tree-based models, linear/logistic regression, and neural network models. Further compared different models’ performance.

• Determined gradient boosting as the best fitting model regards to model complexity, shorter run time, and 90% accuracy rate with less variables than random forest model.

• Conducted principal component analysis to identify major PCs and deployed K-means clustering to categorize clients under different groups. Researched for the characteristics within default group. Image Recognition using Neural Network

• Developed neural network model to auto identify handwritten number in images by training with MNIST database containing 60,000 images using TensorFlow in Python with 97.5% accuracy.

• Created a CNN model with 80% accuracy to classify cats/dogs images through convolution and pooling layers to extract and condense information which is sent to feature map and input layers. Data Visualization for Chicago Crime Using Folium Map

• Retrieved data of Chicago crime and police station from City of Chicago website in SQL

• Visualized the dataset of police station location and the frequency of gun related crimes in Chicago districts, provided descriptive statistics using folium map in Python Skills

Programing: Proficient in Python, SQL, Excel. Intermediate knowledge in R/Tableau Model: Linear regression, logistic regression, neural network, tree-based models, PCA, K-means clustering

Contact this candidate