Tableau, SAS, R, Matlab, SPSS, Python (Pandas, Numpy), SQL, VBA

JUSTIN HUANG

Tel: 909-***-**** Email: *************@*****.***

EDUCATION

Aug 2016 B.S. Mathematics University of Southern California Minor: Statistics

SUMMARY

Certificates SAS Certified Advanced Programmer, SAS Certified Base Programmer Skills Tableau, SAS, R, Matlab, SPSS, Python (Pandas, Numpy), SQL Sumo Logic, RedShift, Advanced Excel, VBA, Visio

Course/Training Statistics, Mathematical Modeling, Machine Learning Work Eligibility U.S. Citizen

EXPERIENCES

PennyMac Corp. Business Analyst I May 2016 - NOW

Designed Tableau visualization models to uncover myth behind raw data, transferred raw data into stories using combination of data joints, pleasant colors, graphs, charts, and tables, and presented the stories to customers

Developed report automation with combination of API call, Python, PSGSuite, Google Sheet, RedShift, and Tableau, such as live analyzing and monitoring website outages and cloud cost of the company

Designed customized Key Performance Indicator (KPI) calculation model for eleven departments within IT Infrastructure to analyze their workload, created a metric for head of departments to present their efficiency

Developed data validation model using R Studio to cross-validate the accuracy of raw data for Information Security models

Used SQL to perform data mining in Sumo Logic to extract log file information of company hosts, compared them against company events, and analyzed the cause of these events PROJECTS

OTHER ACCOMPLISHMENTS

2016 Honorable Mention in 2016 Mathematical Contest in Modeling 2015 3st Place, NCTTA Nationals, Co-ed Varsity (Represented USC) 2013 1st Place, NCTTA Nationals, Men’s Double (National Collegiate Table Tennis Association) 2013 3st Place, NCTTA Nationals, Co-ed Varsity (Represented USC) Mathematical Contest of Modeling Educational Performance Analysis Feb 2016

Investigated and cleaned the large data set with MS Excel

Formed a performance index based on Principal Component Analysis with Matlab

Implemented Multi-Linear Regression model with SAS to find the relationship between educational cost and performance

Cooperate with teammates to complete a thorough research report USC Statistics Course Project Data Analysis Project in SAS Dec 2015

Conducted Stepwise Selection Method for selecting appropriate variables

Conducted eliminate test, data sorting, influential points checking in large data set

Predicted the future outcome with Multi-Linear Regression model

Generated report to analyze the process and outcome

Contact this candidate