Project Sql Server

Yang Liu

**** ********* ****, ***. ***, San Ramon, CA 94582

Phone: 312-***-**** E-mail:**********@*****.***

SUMMARY OF EXPERTISE

Master’s Degree in Applied Statistics and Bachelor of Science in Chemistry.

Strong programming skills in SAS and R.

Excellent data handling and problem solving skills with the ability to process large volume data.

Proficiency with Minitab, SPSS, Microsoft SQL server and Microsoft Office.

Experience in statistical projects and scientific research.

Solid background in Statistics, including:

Statistical Consulting Modeling and Simulation

Design of Experiment Sampling Methods

Standard Statistical Methods Categorical Data Analysis

Time Series Analysis Nonlinear Regression

Spatial Data Analysis Longitudinal Data Analysis

Survival Data Analysis Multivariate Data Analysis

Bayesian Statistical Methods Nonparametric Methods

EDUCATION

Loyola University Chicago, Chicago, IL

2012-2014

Master of Applied Statistics

GPA:4.0/4.0

University of Illinois at Chicago, Chicago, IL

2009-2011

Graduate coursework in Organic Chemistry

Shandong University, Jinan, China

2005-2009

Bachelor of Science in Chemistry

SKILLS

SAS, Minitab, SPSS, Microsoft SQL Server 2012, Word, Excel and PowerPoint,

UNIX, R, T-SQL and Python

CERTIFICATIONS AND ACTUARIAL EXAMS

SAS Certified Base Programmer for SAS 9.

Passed SOA Exam Probability with a score of ten.

Passed SOA Exam Financial Mathematics with a score of eight.

WORK EXPERIENCE

Research Assistant/Statistical Consultant, Loyola University Chicago

2013-2014

Supervisor: Professor Timothy O’Brien

Work on projects about optimal design.

Provide statistical advice to students and professors.

Teaching Assistant, University of Illinois at Chicago

2009-2011

Lead one Organic Chemistry Lab and three discussion sessions.

Job duties include giving lectures, grading homework and exams and answering

questions from students during office hour.

Volunteer work in World Exposition 2010, Shanghai, China

2010

1

Yang Liu

STATISTICAL PROJECTS

Statistical Consulting Project: Advancing Healthy Homes and Healthy

2013-2014

Communities Initiative

Process large-volume data of Chicago buildings with Minitab, SAS and ArcGIS.

Detect spatial autocorrelations in 24 response variables and draw maps.

Research Project: Optimal Design and Robust Design Strategies for Multi-

2013-2014

Category Response Data

Perform D-optimal design by constructing expected Fisher information matrix.

Calculate a series of second order partial derivatives.

Statistical Consulting Project: Child Language Development: Syntactic Priming

2013-2014

and Semantic Animacy

Build Generalized Linear Mixed model for matched categorical responses in R.

Statistical Consulting Project: Enabling Quantitative Assessment and Interdisci-

2013-2014

plinarity: Fostering Communication and Unifying Statistical Analysis by Using R

The goal of this project is to create a product of comprehensive tutorials and

suggestions for operating R to best benefit Loyola University Chicago.

Provide statistical advice and R programming suggestions.

CDA Class Project: Modeling Correlated, Clustered Responses: GEE Approach

2013

Apply Generalized Estimating Equations approach and Generalized Linear Mixed

model to correlated categorical data using SAS.

Use Quasi-likelihood Information Criterion as a model selection tool for GEE.

SAS Class Final Project: Determinants of Child Health in Philippines in 2008

2012

Establish hierarchical logistic models between 5 categorical responses and 37

explanatory variables using SAS.

Interpret SAS output and write report.

SAS Class Midterm Project: Analysis of Risk Factors that Affect Blood Pressures

2012

and Cause Hypertension

Perform basic statistical analysis and nonparametric methods using SAS.

OTHER EXPERIENCE

Summer Session, University of California at Los Angeles

2008

General English for Academic Program, University of Adelaide, Australia

2007

Chemistry Project: Separation and Recycle of Aluminum-plating Polyvinyl

2006

Chloride Film, Shandong University, China

Lead a group of four members to design and implement the experiment and to

analyze the data.

Class President, Shandong University, China

2005-2009

2

Contact this candidate