Cathy Liu Lexington, KY, *****

408-***-****

ac1lav@r.postjobfree.com

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