Sql Server Project

Guang (Blair) Sun

*** *. ******* ***. *** ***, Akron, OH, 44304 330-***-****

***********@*****.***

EDUCATION

> 08/2007- 05/2010 M.S. in Statistics GPA 3.9/4.0

University of Akron Akron, Ohio

> 09/2003-06/2006 M.S. in Polymer Science and Engineering Sichuan

University Chengdu, China

> 09/1999-06/2003 B.S. in Polymer Science and Engineering Sichuan

University Chengdu, China

CREDENTIALS

> SAS Base Programming for SAS 9

> SAS Advanced Programming for SAS 9

> Society of Actuaries (SOA) Exam Probability (P/1)

> Society of Actuaries (SOA) Exam Financial Mathematics (FM/2)

> Society of Actuaries (SOA) VEE* Applied Statistics

> National Computer Rank 2 Exam Certificate (C programming)

> National Computer Rank 3 Exam Certificate (Software Engineering)

> Microsoft Office Product Proficient User (Word, Excel, PowerPoint,

Access)

COMPUTER SKILLS

> SAS Product: SAS BASE, SAS/STAT, SAS/SQL, SAS/MACRO, SAS/GRAPH

> Languages: C, Fortran, HTML, JavaScript

> Statistical software: SAS (3+ years), SPSS (2+ years), Minitab (2+

years), R (2+ years),

JMP (2+ years)

> Databases: Microsoft SQL Server, My SQL server

> Windows softwares: Microsoft Excel, Word, PowerPoint

STATISTICAL ANALYSIS KNOWLEDGE

Sampling, Hypothesis Testing, Linear Model, linear Regression, Logistic

Regression, Time Series Analysis, Experimental Design, Survival Analysis,

Nonparametric Analysis, Financial Mathematics ( Time value of money,

Annuities, Loans, Bonds, Cash Flows and Portfolios), Financial Economics

(General Derivatives, Options, Hedging and Investment Strategies, Forwards

and Futures, Swaps), Actuarial Model (Survival Model, Life table, Life

insurances and annuities)

EXPERIENCE

Graduate Assistant in University of Akron

. Train undergraduate students to use statistical computer software, such

as Minitab, grade homework and exams for undergraduate students.

. Work with professors to do Statistical Consulting, such as regression

model building, experimental design, clinical data analysis, Logistic

regression analysis and Time series analysis.

Guang (Blair) Sun

634 E. Buchtel Ave. Apt 206, Akron, OH, 44304 330-***-****

***********@*****.***

SELECTED TERM PROJECTS

Regression Model building Term Project

. Build up best model to predict Profits of the insurance company and

check model assumptions to see if the model is valid

. Use logistic regression to predict whether the person will live or die in

a particular treatment

. Build up best model to find trend along time using Time Series ARIMA

model

Statistical Database Management Term Project

. Given nursing school sample data, use two sample T-test to decide if

there's difference between two study methods.

. Import raw data into SAS and do data cleaning; analyze data using both

descriptive statistic including mean, variance, range, distribution and

influential statistic; generate report in specific format.

. Use SAS data step and Proc SQL to combine data sets, retrieve and

manipulate data.

. Use SAS procedure such as GLM, REG, LOGISTICS to find best model.

. In SAS and SPSS, Given leather resistant to abrasion data, use 2-

factorial design or Latin Square experiment to decide which grade of

leather is most resistant to abrasion.

. Using Proc IML to do Bank simulation: The program is to simulate the

arrival of 50 customers at the bank 10000 times, then calculate mean and

standard deviation of time each customer spends in the bank and time each

customer has to wait in line for service.

Actuary Science Course Project

. Use density function of a lifetime to find survival function, force of

mortality and mean future lifetime

. Given life table and interest rate, compute the mean of the present value

for an insurance policy

. Compute the monthly payments made at the end of each month for a new

house

Database Management Term Project

The project is to build an online book store. Customers can log into our

store. Their activities such as searching for books, placing orders are

processed through operating a database created on a Microsoft SQL server.

The store manager who has an administrative account can add items into the

database on the server.

AWARDS RECEIVED

> 2006 Excellent Graduate Student of Sichuan University

> 2002 Excellent Student Scholarship of Sichuan University

> 2001 P&G Scholarship

> 2001 Excellent Student Cadre of Sichuan University

> 2000 Excellent Student of Sichuan University

Contact this candidate