Sql Server Data

JANEY WAN

**** ****** ***** **, ***** Land, TX 77479

Cell: 832-***-**** • Home: 281-***-**** • Email: ********@*****.***

Permanent Resident (Green Card Holder)

QUALIFICATIONS

• Master degree in Statistics, Ph.D in Engineering

• Skilled in data analysis, predictive modeling, multivariate statistical analysis, sampling theory, data mining and problem solving

• Ability to establish and meet deadlines and to quickly develop clear priorities

• Highly proficient in SAS, Base, Macro, Graph, SQL, Matlab and Microsoft Office programs

• Excellent communication and fast learning skills

SKILLS and EXPERIENCE in STATISTICS

SAS Training for Pharmaceutical Industry

• Completed SAS training for pharmaceutical industry (e.g. how to QC SAS programs and develop macros; clinical trial and FDA standards)

• Generated tables (e.g. Demog tables, AE tables), figures, macros and CDISC standard data/report submission to FDA standards

Application in Statistics Simulation

• Completed Master’s Project using SAS: Compared 4 different tests of heteroskedasticity in simulation study with SAS/IML

• Developed SAS macro to perform multivariate regression with multiple independent variables and multiple dependent variables including categorical variables

Application in Time Series

• Analyzed currently available company stock data and applied ARCH-GARCH model in predicting stock trend

• Analyzed currently available company sell pricing data and applied seasonal ARIMA regression model in predicting sell pricing trend

Application in Other Fields as a Consultant

• Analyzed data for clients utilizing SAS

• Introduced SAS to clients and provided general training in addition to teaching particular modules (e.g. multivariate regression, non-linear regression, etc.)

SELECTED ACHEVEMENTS on SQL Server Database

• Configured SQL Server parameter files to adjust the memory usage and file size.

• Created many database tables with many constraints including primary key, foreign key, etc.

• Implemented SQL query using SQL Server single row and group functions, multi table joins, sub-queries and set operations.

• Loaded data from flat data files into SQL Server database tables using bcp, bulk insert, or table export, import.

• Extracted data from SQL Server database tables into flat data files and excel sheet

• Generated all sorts Reports using advanced SQL with multi-table joins, group functions, sub-queries and set operations.

• Employed SSIS Designer to create Microsoft SQL Server Integration Services package to extracted data from a flat file, reformat the data, and insert the reformatted data into a fact table.

• Generated business reports using SQL Server 2008.

WORKING EXPERIENCE

Research Assistant Department of Biomedical Engineering

(2006-2011) Texas A&M University

College Station, Texas

• Developed and implemented models based on different research aims

• Performed data analysis

• Published 8 journal articles and conference proceedings and presented 5 talks in conferences

• Supervised undergraduates and junior graduate students on research work

Statistical Consultant Department of Statistics

(2008 - 2009) Texas A&M University

College Station, Texas

• Assisted clients in utilizing SAS to apply field-specific statistical concepts, models and methods in analyzing data and interpreting results.

EDUCATION

Ph.D., Biomedical Engineering M.S., Statistics

(January 2006 - December 2011) (August 2007 - August 2009)

Texas A&M University Texas A&M University

Department of Biomedical Engineering Department of Statistics

College Station TX College Station

GPA: 3.8/4.0 GPA: 3.8/4.0

HONORS

• Alpha Eta Mu Beta honor society 2010 (GPA>3.75)

• Regent’s Fellowship TAMU 2008 and 2007

• International Education Scholarship TAMU 2007

Contact this candidate