Data Analyst
Resume:
Cathy Liu Lexington, KY, *****
***************@*****.***
OBJECTIVE: Seeking a qualified data analyst position
SUMMARY
More than three years’ experiences in quantitative and qualitative data analysis
Ability to Identify, analyze, and interpret trends or patterns in complex data sets
Advanced skills in Excel (Excel Data Mode, Vlookup, PivotTable, PivotChart, Macro)
Advanced SQL skills to communicate with databases and retrieve data from tables and view
Skills using MS Access 2016 to create databases (design tables, enter data using forms, and create queries and reports)
Excellent written, interpersonal communication skills, and presentation skills, including ability to present technical concepts in a clear, concise manner to audiences with varying levels of technical understanding
Other statistics packages skills: Word, PowerPoint, SAS, Tableau, Minitab, SPSS, R
Bilingual in English and Mandarin
Green Card holder
WORK EXPERIENCE
Consultant 04/2017 – 06/2017
Epiphany Biosciences, San Francisco, CA
Created database by using MS Access
Retrieved data from databases by using SQL
Descriptive Statistics & Hypothesis Testing by using Excel
Translated research documents into Chinese
Internship 09/2016 – 03/2017
Epiphany Biosciences, San Francisco, CA
Calculated sample sizes for clinical trials
Created database by using MS Access
Retrieved data from tables and view in a database by using SQL
Created Pivot Tables, Pivot Charts, and Slicers in Excel to analyze data
SAS and SQL Program Internship 06/2016 – 07/2016
TMC Software, San Francisco, CA
Cleaned, Extracted, transformed, and loaded data from structured and unstructured datasets
Created tables and charts to represent ad-hoc requests by using Excel, SQL and SAS
Provided insights and findings from data
Principal assistant
O-Mei Kung Fu and Learning Center, Milpitas, CA 06/2012 – 09/2012
Preparing materials, helping students with assignments, teaching Chinese
Instructor of TaiChi 09/2009 – 05/2011
Mipitas Adult Education, Milpitas, CA
Teaching TaiChi
Marketing Department Manager 01/2005 – 05/2008
ZhongBei Import-Export, Beijing, China
Performed statistical analyses by using Excel
Managed team of 12 salespeople to drive annual increase of automobile, television and small home appliance sales of 25%
Marketing Department Associate
ZhongBei Import-Export, Beijing, China 09/2000 – 12/2004
Conducted market research for marketing and sales forecasts
Created tables and charts to make data analyses by using Excel
Presented reports by using PowerPoint
EDUCATION
MS Biostatistics, CSU East Bay, Hayward, CA Graduated 2016
Relevant Coursework: SAS, Statistical Inference, Linear Regression, Categorical Data, Survival Analysis, Clinical Trials
BS Statistics, CSU East Bay, Hayward, CA (Summa Cum Laude) Graduated 2014
Relevant Coursework: Data Analysis Using Statistical Packages, Regression, Statistical Inference, Sampling Survey
SELECTED DATA ANALYSIS PROJECTS
Course: Analysis of Categorical Data in Biostatistics
Project: Breast Cancer - Logistic models [SAS]
•Built a logistic model and determined predictive variables for breast cancer by using classification
analysis
•Displayed the relationship between response variable and explanatory variables
•Diagnosed new patients by using computer with machine learning method
Course: Theory and Application of Regression
Project: Wage - Regression analysis [SAS]
•Performed correlation, assumption, and residual analysis to confirm validity of statistical analysis
•Applied simple linear regression to build a regression model
•Discovered predictors for employee wages in US by using regression analysis
•Developed a regression model to demonstrate the association between wages and predictors
Course: Data Analysis Using Statistical Packages
Project: Analyzing weather with descriptive statistics, scatter plots, matrix plots [Minitab]
•Predicted temperature across 56 US cities by analyzing latitude, longitude, elevation, population size, and geographic region
•Used multiple regression analysis to develop regression model
•Demonstrated association between temperature and predictors
Project: CO2 Emissions [Tableau]
•Determined the world carbon dioxide emissions
•Analyzed the evolution of CO2 emissions over time by region
•Visualized the evolution of CO2 per capita over time country by country
Project: Marketing Analysis [Excel]
•Created dashboard to display the information of sales
•Explored sales composition by using pivot tables, pivot charts, slicers, filters
•Created treemap charts based on the data in cross tabular report
CERTIFICATION
SAS Certified Base Programmer for SAS 9
Certificate No: BP061968v9
Contact this candidate