Quality Assurance Years Experience

Guangtao Edward Li

*** ****** ****, **********, ** 45220 ? 631-***-**** ? *********@*****.***

Summary of

Qualification___________ _________

. SAS Certified Advanced Programmer for SAS9 with 7 years experience of sas

programming

. 3 years experience of statistical programming in pharmaceutical and

medical research

. Familiar with multiple data sources, particularly relational databases

such as SQL and Oracle

. Familiar with health care claims data, standard disease coding schema

such as ICD-9(10)

. Experience with sampling strategies for large databases

. Strong knowledge involving all phases(I-III) of clinical trials

. Experience in reviewing and providing advice on Protocol, SAPs, CRFs,

CSRs, and SOPs

. Experience with FDA Regulations, Electronic Records and signatures (21

CFR Part II)

. Experienced with the CDISC(SDTM and AdaM) and transforming raw data into

these standards

. Expertise in data mining and segmentation via SAS Data Steps, PROC IMPORT

and SAS/SQL

. Proficient in generating reports including tables, graphs and listing by

SAS procedures PROC Report, PROC Tabulate, SAS/ODS, SAS/Macro, SAS/Graph

and Data_Null_

. Expertise in statistical analysis and modeling using SAS procedures PROC

MEANS, PROC SORT, PROC FREQ, PROC Npar1way, PROC Logistic, PROC GLM and

PROC MIX

Professional

Experience_ _____ ______________

P&G, Global Statistics Department Cincinnati, Ohio

Feb 2010 - Present

Statistician (Contractor)

. Drivers Analysis using Bayesian Belief Networks to answer key business

questions

. Built Mixed Model to test the effects of special products compared

with others

. Built Response Surface Model(RSM) to decide the optimal allocation of

ingredients

. Computed sample size or replication times for various experiments

. Tested, validated and formalized specifications drafted by senior

statisticians

. Environment: Windows XP, BayesiaLab, SAS 9.2, MS-Office 2003, JMP 7

MBS, Analytical Solution Department Central Islip, New York

Feb 2009 - May 2009

SAS Programmer (Intern)

. Produced Customer Profile Analysis to describe the key characteristics of

valuable customers

. Performed Customer Lifetime Value (CLV) Analysis to enhance the customer

retention

. Revealed affinities between individual products by building cross-sell

models

. Predicted effectively the responses by building and validating predictive

models

. Scored and Deciled High and Medium Value Lapsed customers by creating

reactivation models

. Environment: Windows 2003, SAS 9.1, MS-Excel 2003, Oracle

Laizhou Foreign Trade Stone Co., Ltd. Laizhou, China

Jul 2006 - Jul 2007

Marketing Analyst

. Contributed to generate SAP for driving insight from marketing data

. Perform quality assurance procedures on work performed other analysts

. Environment: Windows 2000, SAS V8, SQL Server 2000

Botai Medical Consulting Services Co. Ltd. Hangzhou, China

Oct 2003 - Jan 2006

Statistical Programmer

Responsibilities:

. Worked in close proximity with biostatisticians in reviewing Protocol,SAP

and CRF

. Developed new or modified SAS programs to load data from the source and

create study specific datasets, which are used as source datasets for

report generating programs

. Developed or validated SAS programs to creat clinical study reports(CSR)

for demography, adverse event, laboratory, medical history, prior and

concomitant medication, etc.

Accomplishments:

. Accessed the effectiveness of a new special diet for Children with

phenylketonuria (PKU)

. Performed multivariate analysis to identify risk factors for influx

esophagitis

. Compared the cumulative probabilities of dying for 3 different treatment

regimens over time using Kaplan-Meier survival estimates

. Performed comparative analysis for Serum Cholesterol levels for children

in different age groups of different provinces

Technical

Skills___ ___ __________ ______ ___

. Languages: SAS, Matlab, Mathematica, R, Minitab, SPSS

. Databases: SQL Server 2000/2005, Oracle, Toad

. Operating Systems: Windows 98/2000/2003/ME/XP,Unix, Mac OS

. Office: MS-Excel, MS-Word, MS-Powerpoint

Education____________ ________ ________

State University of New York at Stony Brook

Sep 2007 - May 2009

M.S. in Applied Math and Statistics

GPA 3.75/4.0

Contact this candidate