Assistant Project

Shiying Zhang ** Fairway Rd, Apt *D

**********@*****.*** Newark, DE, 19711

Cell: 302-***-****

OBJECTIVE

To seek a position where I can apply my skills as an analyst to business

decision-making and analysis

EDUCATION

MS, Statistics University of Delaware, Statistics May. 2010

Program

BA, Law China Foreign Affairs University Jul. 2007

PROFESSIONAL CERTIFICATES

. SAS Certified Advanced Programmer for SAS 9.0

. Microsoft Certified Technology Specialist: SQL Server 2008, Database

Development

SKILLS INVENTORY

. PROGRAMMING LANGUAGE SQL, VBA, C++

. OPERATING SYSTEM Unix, Linux, Windows, Excel(MACRO, VBA, Pivot

Table, Auto Filter) Word,, PPT, Access, Outlook)

. STATISTICAL SAS(MACRO, BASE, STAT, GRAPH), R, SPSS, MINITAB,

JMP

PROFESSIONAL EXPERIENCE

ASTRAZENECA PARMACEUTICAL, Wilmington, DE

Jun.2009-May.2010

Statistical Analyst (Intern)

. Assisted forecasting manager of Quantitative Commercial Insight to design

complex models using regression/logistic regression, time-series models,

clustering analysis, multivariate analysis, etc. for market research and

strategy oriented prediction

. Aligned team efforts by communicating project background, clients'

requirements, analysis direction, and interpreting analysis results to

statisticians and non-statisticians

. Performed ad hoc data analysis with various statistical techniques per

business requests

. Wrote and validated SAS programs to create summary, graphs reports

deliverables and presentations

. Managed and updated large SAS databases weekly (millions of observations)

STATISTICS, UNIVERSTITY OF DELAWARE, Newark, DE

Jan. 2009-May. 2009

Research Assistant

. Assisted research project on Delaware population growth from 1900 to 2000

. Analyzed demographic changes with Excel and SAS, developed research

reports and designed PPT presentation

INTERNATIONAL STUDIES OFFICE, UNIVERSTITY OF DELAWARE, Newark, DE Jan.

2009-Feb.2009

Statistics Student Counseling

. Advised data analysis on the impact of Study Abroad Program on UD

students

. Wrote final report suggesting analytical methods for model building

SOCIOLOGY, UNIVERSTITY OF DELAWARE, Newark, DE

Sep. 2007-May.2008

Teaching Assistant

INSTITUTE OF SOCIOLOGY, CHINA ACADEMY OF SOCIAL SCIENCES

Nov. 2006-Apr. 2007 Research Assistant (Intern)

Assisted research by conducting linear regression analysis and data

management on Social Surveillance and Community Studies with SAS

References will be provided upon request

Shiying Zhang 52 Fairway Rd, Apt 3D

**********@*****.*** Newark, DE, 19711

Cell: 302-***-****

KEY COURSES

Design of Data Management/SAS Regression Mathematical

Experiments Logistic Statistics

Statistical Probability Theory Regression Multivariate

Optimization Analysis

RELEVANT PROJECT EXPERIENCE

Diverse Types of SAS Projects (using SAS and SQL)

. Prepared customized trend graphs for product sales

. Retrieved and prepared data from the data warehouse for analysis

. SAS procedures used: reg, glm, anova, mixed, logistic, genmod, factor,

cluster, tree, sql, sort, import, export, format, discrim, contents,

datasets, compare, ttest, univariate, tabulate, report, freq, means, gplot,

boxplot and etc.

Physician Segmentation Project (using SAS and Excel)

. Retrieved and prepared data from the data warehouse for analysis

. Used cluster procedures for segmentation of physicians for product

adoption

. Evaluated the model by examining the relationship between the adoption

segments and market share growth

Physician Awareness & Uses, a longitudinal survey study (using SAS and

Excel)

. Processed data from a weekly survey that revealed the efficacy of

marketing strategies and sales efforts

. Visualized data in Excel using graphs and tables

. Performed additional analysis using logistic regression and factor

analysis

Wrote/Developed Excel Statistical Analysis Tools (using Excel VBA and SAS)

. Created Macros for generating pivot table and report the Word file

. Found and fixed algorithm error in the software

. Validated the results through SAS

Developing Teaching Materials for Logistic Regression and Multivariate

Analysis in JMP

. Explored JMP software by for logistic regression and multivariate

techniques on sample datasets

. Compared results with similar analyses in SAS

. Developed Fact Sheets on using JMP with various techniques

Study Abroad Survey Study Consulting Project

. Assisted professor and graduate assistant on developing methodology of

survey design and study

. Tutored data analysis with SPSS software

Blue Nile Diamond Price Modeling (using SAS and JMP)

. Stratified sampling method was used to collect the data sample of diamond

price

. Coded the key price determinants (Carat, Clarity, Color, Cut) into dummy

variables

. Build both log-linear and nonlinear model to predict the diamond price

HyTex Company Direct Marketing Catalog Data Analysis (using SAS and Excel)

. Used stepwise method to select key variables and build multiple

regression linear model

. Proposed proper marketing strategies for the company

Contact this candidate