Statistical Analyst/ Data Analyst/ SAS Programmer

Liyuan (Lily) Niu

ADD: **** N Lamar Blvd, Austin, TX 78752

TEL: 573-***-****

Email: **************@*****.***

OBJECTIVE

To obtain a statistical analyst or SAS programmer position

EDUCATION

University of Missouri-Columbia, Columbia, MO, USA

Master of Art in Statistics Dec.2008

GPA:3.6

Shanghai University of Finance and Economics (SUFE), Shanghai, China

Bachelor of Science Jun.2006

Major: Applied Mathematical Statistics

Major GPA:3.7 Overall GPA:3.4

COMPUTER SKILLS

* SAS Certified Advance Programmer for SAS9 (SQL, Macro)

* SAS Certified Base Programmer for SAS9

* Proficient in statistical software R, SPSS, S-Plus and data management tools Excel and Access.

* Experienced in Microsoft Office (Word, Outlook, PowerPoint)

WORK EXPERIENCE

Department of Statistics, University of Missouri-Columbia

Graduate Teaching Assistant Aug.2007~May2008

*Gave the solution to the homework and exams and graded them

*Used excel to record and calculate grades

*Provide assistance to students

Department of Statistics, University of Missouri-Columbia

Graduate Research Assistant Jan.2007~May2007

*Used SAS to recreate the entire data analysis system which resulted in highly improved efficiency

*Prepared reports with Word and presentation materials with PowerPoint

Shanghai Horizon Research Company

Intern, Data analyst Mar.2006~Jul.2006

*Responsible for developing standardized SAS Graph reports

*Provided SAS programming support and conducted statistical analysis on marketing survey data

Academic Association for Statistics of SUFE

Part-time Job, Data analyst Feb.2003~Jan.2006

*Utilized SAS functionality to extract and clean up the survey data

*Managed projects with dataset created and maintained by SQL

*Analyzed collected data using SAS and SPSS

CONSULTING AND PROJECT EXPERIENCE

2007 Alcohol and Smoke Project

Dept of Statistics and Dept of Psychological Sciences, UMC Aug.2008~Nov.2008

*Cleaned up the data in the form of Excel and developed SAS programming codes

*Built binary logistic regression model to show how the number of drink determine the hangover

*Employed populated average generalized linear model to examine whether the time and the number of drinking account for some of the variation in reported hangover

Creamy Pesto Alfredo Pasta Sauce Data

Elmore Consulting Company, Columbia, MO Mar.2008~May,2008

*Consulted with the client about how she designed the experiment and what her survey goals were

*Build logistic regression model using SAS to analyze how product effect and serving order affect the consumer’s response

*Performed one-way ANOVA analysis using SPSS to compare the difference among products within each box and get subgroups for each box

*Produced the research report

2007 Student Life Survey

Dept. of Student Life, University of Missouri-Columbia Jan.2008~May.2008

*Listened up the clients’ description of the dataset, and what the research questions and goals were

*Examined the data for threats to validity, ranging from missing data to questionable outliers to confounders. Also, made data transformation and created several new variables to describe the involvement in activities and the use of the service

*Performed Chi-square test and two sample t test to determine if students who live on campus are more likely to be involved and use the service

*Produced the research report and presented the results to the clients

2005 Family Income and Consumption Project

Bureau of Statistics, Huguan, China Dec.2005~Feb.2006

*Designed statistical analysis dataset modules and created efficient excel analysis dataset

*Employed factor analysis and principal component analysis using SAS to generate accurate and validated statistical results of family income survey

*Assisted in producing the annual report about the average family income in 2005 for Huguan

LEADERSHIP

Youth League of Dep. of Statistics, SUFE

Vice President 2004~2005

*Organized application, appraisal and summary for undergraduate practical activities in the department of statistics

HONORS

Graduate Scholarship, UMC 2007~2008

Graduate Scholarship, UMC Jan.2007~Aug.2007

People’s Awards, SUFE 2005~2006

QUALIFICATIONS

*Effective in communication (oral and written) and able to quickly adapt to new situations

*Ability to work independently under tight deadlines

*Strong quantitative, qualitative data analysis and problem solving skills

*Detail oriented, organized, and able to manage multiple projects simultaneously

Contact this candidate