Sales Data

Chaojun Cao **** Montair Way, Union City, CA, ****7 347-***-**** *******@*****.***

EDUCATION

California State University at East Bay, Hayward, CA Master’s Degree in Applied Statistics Sept. 2015 – Dec. 2017 Certifications & Coursework

• SAS Certified Advanced & Base Programmer for SAS 9

• Probability Theory Advanced Statistical Inference Analysis of Variance Models

• Linear Regression Model Analysis Mathematical Statistics Time Series Analysis

• Advanced SAS Programming Machine Learning, Data Visualization with Tableau (Coursera) Huaihua University, Hunan, China

Bachelor’s Degree in Education Sept. 2007 – June 2011

• League Branch Secretary - organized weekly class meeting, monthly outdoor activities, and prepared semester reports to school

• Dormitory Management Leader - managed student dormitory harmony, built diverse dormitory culture

• Member of Sports Fans Association - ping-pong, badminton, billiards etc. PROFESSIONAL SKILLS

• SAS SQL R Tableau Python Photoshop

• MS Office Suite: Excel, Word, PowerPoint, Outlook

• Bilingual: English and Chinese(Mandarin)

SELECTED PROJECTS

Logistic Analysis of Polypharmacy Data

• Processed data merge and clean on the 500 ID numbers with 3500 observations, 14 variables by PROC SQL queries and PROC LOGISTIC statements on Logistic Regression Model

• Performed interactions selection and identified 5 covariates are significant at p<0.001 in the final model Macro Language Application on Aids Clinical Trials Group Nested Case-control Data

• Created Macro variables and programs based on the 576 observations, 7 variables dataset in SAS

• Applied survival analysis on the fitted regression model to describe survival time on AIDS diagnosis progression or death

Building Linear Regression Model Based On the “House Price” Dataset

• Used forward, backward selection methods in SAS and checked normality of error by hypothesis test to build the best model for house price based on the 523 observations and 11 variables dataset

• Concluded the significant level of each variable to the price of the house on alpha=0.05 Time Series Analysis of Monthly Sales of New One-family House

• Stationary processed the data from 1973 to 1995, fitted and checked the data by auto. arima {} function

• Plotted and forecasted on the number of monthly sales of new one-family house in the next 60 months after 1995 based on ARIMA (1, 0, 0) approaching in R WORKING EXPERIENCES

Sparkle Jewelry Inc.

Product Analyst Fremont, CA Dec. 2017 – Present

Inventory Associate Fremont, CA May 2016 – Nov. 2017

• Managed and matched the attributes information of existing products listed on eBay, Amazon and Wish

• Created and edited new attributes, photos for new products in photoshop, maintained the products data information in Channel Advisor and different selling accounts in sync

• Analyzed product selling history in recent months and reported to manager

• Prepared FBA shipments, V-looked up the inventory in Rakuten and local warehouse to arrange the shipments based on the order address, kept track of the import products information

Contact this candidate