Sql Server Data

CHAO "CHARLIE" HUANG

Apt **, *** N Monroe --- Stillwater, OK 74075 --- 405-***-**** ---

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

Master graduate majored in statistics with excellent internship at Howard Hughes

Medical Institute

Proficient in programming, statistical analysis and data mining

Well versed in customer segmentation and predictive modeling

Certified SAS modeler and programmer with experience in data integration, management,

cleansing, analytics and report

Profound knowledge in using SQL Server and other relational database management

systems

Education

OKLAHOMA STATE UNIVERSITY - Stillwater, OK

Master of Science in Statistics, Jul 2010 --- The honor society of Phi Kappa Phi

-- Programming courses SAS programming, Statistical method I, Statistical

method II, Data mining and CRM, Advanced data mining,

-- Statistics courses Nonparametric data analysis, Multivariate data

analysis, Categorical data analysis, Design of experiments

Vector calculus, Probability, Inference, Linear model

I, Linear model II, Stochastic process, Statistical research

Master of Science in Botany, 2009

HUAZHONG AGRICULTURAL UNIVERSITY- China

Bachelor of Science in Agriculture, 2002

Technology Summary

Certification SAS Certified Predictive Modeler 5, SAS/OSU Data Mining Certificate,

SAS Certified Advanced Programmer 9,

Sun Certified JAVA Programmer 6.0, Microsoft Certified Technology

Specialist: SQL 2008 Database Development

SAS tools SAS 8/9, SAS/BASE, SAS/STAT, SAS/SQL, SAS/GRAPH, SAS/MACRO, SAS/ACCESS,

SAS/ETS, SAS/IML, SAS/ODS, SAS Enterprise

Miner 5/6, SAS Enterprise Guide 4

Database MS Access 2007, MS SQL Server 2005/2008

Experience

Teaching & Research Assistant Oklahoma State University Aug 2006 to

May 2010

Engaged in predictive modeling project by Medicaid with Oklahoma State Department of

Health

-- Designed relational database including 285,881 enrollments, 352,662 claims and

coding tables in SQL Server

-- Automated database maintenance by SQL agent and synchronized SAS via ODBC

-- Cleaned data by SAS functions (COMPRESS/INDEX/SUBSTR/VERIFY) and PROC

UNIVARIATE/RANK

-- Constructed data mart to discover factors affecting denial rate by SAS PROC SQL

-- Trained model by Enterprise Miner modules ( Decision tree/Regression/Neural

network/Ensemble)

-- Assessed model by ROC chart, lift chart, profit chart, misclassification rate

and fit statistics

-- Implemented model to score new data sets and exported SAS scoring codes

Segmented and clustered 18,000 customers using 2G/3G service of an Asian telecom

company

-- Clustered customers by hierarchical clustering, k-Means clustering and Product

affinity clustering

-- Segmented customers by RFM priori segmentation, SOM/Kohonen segmentation and

predictive segmentation by decision tree

-- Proposed specialized marketing strategies for potential 3G customers

Accomplished bovine respiratory disease project of 632 cows treated by antibiotics

with OSU Veterinary Hospital

-- Imported data by SAS/ACCESS SQL pass-through facility via ODBC

-- Generated Kaplan-Meier and Cox proportion hazards regression survival estimates

by PROC LIFETEST/PHREG

-- Obtained descriptive testing statistics by PROC FREQ/UNIVARIATE and inferential

testing statistics by PROC MIXED

-- Created change -from-baseline survival proportion tables by PROC SQL/REPORT

-- Built comparative graphs by PROC SGPLOT/SGPANEL and rendered 3D graphs by SAS

Graph Template language

Taught 200+ undergraduate and graduate students of Oklahoma State University

-- Lectured STAT2013(Elementary Statistics) in Spring 2009; STAT2023(Business

Statistics) in Summer 2009

-- Lectured STAT4033(Engineering Statistics) in Fall 2009 and Spring 2010

-- Established distant learning center for 5 classes by online classroom system

-- Taught labs of BOT3013(Biological Microtechnique)and BOT3233(Plant Anatomy)

Participated in SAS Shootout 2009 data mining competition

Mentor in Critical Thinking of Biological Sciences Howard Hughes Medical

Institute May2007 to Aug2007

-- Trained advisee's quantitative skills. Managed $3000 funding account

-- Designed biomedical research and analyzed data of 30,575 records by PROC

ANOVA/TTEST/MEANS

Research Assistant National Key Lab of Crop

Improvement, China Aug 2002 to May 2005

-- Provided statistical consulting to various projects resulted as co-author of 7

journal papers

[pic]

Contact this candidate