SAS SQL

Weihong Yin

Winston Salem, NC . 336-***-**** . *************@*****.***

[pic]

Highly motivated and result-oriented professional with extensive Data

Warehousing and Business Intelligence experience and excellent statistical

analysis skills

. PhD level scientist with 8+ years' experience of SQL Server (SSIS, SSAS &

SSRS),

BIDS,SSDT Data Tools 2012, Oracle 10g/11g, Data Warehouse, and Crystal

Report.

. Certified SAS Programmer with expertise in SAS/BASE, SAS/STAT, SAS/ODS,

SAS/GRAPH, SAS/SQL, SAS/MACRO and SAS/EDI/DI in UNIX/Windows.

. Expertise in data analysis, data mining, algorithm design, and

mathematical modeling

. Advanced skills with Microsoft (Word, Excel, Access and PowerPoint)

. Strong team player with great verbal, written communication skills.

[pic]

PROFESSIONAL EXPERIENCE

Senior Data Scientist

Wake Forest Univ Baptist Med Center - Winston Salem, NC 02/

2007 - Present

. Created SSIS Packages to extract, transform, and load data from various

data sources

(Flat/Excel/XML data files, and relational data sources) to data

warehouse.

. Created/Updated Stored Procedures, Triggers, Functions, Cursor, Views,

and Indexes

with extensive use of T-SQL and PL/SQL.

. Managed /coordinated database migration from SQL Server 2008 to SQL

Server 2012

. Created/Deployed complex SSIS package for cube deployment automation that

included variables, expressions and multiple complex conditional tasks.

. Built cubes in SSAS and MDX expressions/queries for accessing cubes

. Designed complex SSAS solutions using multiple dimensions, perspectives,

hierarchies,

measures and groups.

. Diagnosed and tuned the server performance by creating indexes, using

execution plan,

altering primary key columns and modifying queries and stored

procedures.

. Created /implemented a variety of SSRS reports such as Matrix, Tabular,

Parameterized,

Drilldown, and Sub-reports using Report Designer and Report Builder.

. Generated ad hoc reports using Microsoft Excel and Crystal Report.

. Created reports in SSRS with different type of properties like chart

controls, filters,

Interactive Sorting, SQL parameters etc.

. Designed SAS DI packages migrate data from various RDBMS & third-party

software

packages to SAS environment.

. Conducted various statistical analyses such as correlation, regression

and established

predictive/forecasting models using SAS/BASE, SAS/STAT, SAS/SQL,

SAS/GRAPH.

Senior Data Analyst

Lousiana State Univ Health Sci Center - Shreveport, LA

05/2003 - 01/2007

. Created new datasets using Set, Merge, Sort and Update, Formats,

Functions and

conditional statements

. Converted large ASCII, CSV, Excel, and other data files into SAS

datasets.

. Used Excel skills like pivot table, vlookup, grouping and filtering of

data regularly.

. Checked data quality, removed inaccuracies, standardized on common

values, sparse

values and cleaned dirty data to create strategic and trustworthy data

sets for analysis.

. Developed SAS & R programs for data mining and statistical analysis (t-

test, Chi-

Square test, ANOVA, and logistic regression) to improve existing

strategies.

. Performed statistical data analysis, generated reports, listings and

graphs using

SAS/Base, SAS/Macros, SAS/SQL and SAS/Access

. Used SAS procedures (univariate, sort, freq, means, summary, report, and

tabulate).

. Conducted modeling/regression analysis of mouse skin carcinogenesis data.

. Created reports in RTF, HTML and PDF formats using SAS/ODS.

Research Scientist

St. Marianna Univ School of Medicine - Kawasaki, Japan 04/1996

- 02/1999

. Developed experimental design according to statistical analysis plan

. Collect research data from various sources and conducted quality review,

accuracy

assessment, error correction, and data format conversion

. Developed R functions for complex analyses and data mining

. Collaborated with biomedical scientist to develop mouse models for the

study of

Rheumatoid Arthritis

. Conducted probabilistic risk assessment using Bayesian methods.

. Performed statistical data analysis, generated reports, listings and

graphs using R[pic]

TECHENICAL SKILLS

MS SQL server, SSIS, SSAS, SSRS, Microsoft Visual Studio, T-SQL, PL/SQL,

Toad, Business Intelligence Development Studio (BIDS), Data Transformation

Services (DTS), OLAP, OLTP, SDLC, Netezza, PowerShell, SAS/BASE, SAS/STAT,

SAS/GRAPH, SAS/SQL, SAS/MACRO, SAS/ACCESS, SAS/ODS and SAS/EDI/DI, R,

Crystal Report 2008, SharePoint, Microsoft (Word, Excel, Access and

PowerPoint), PowerPivot, etc.

[pic]

EDUCATION

Ph.D. in Bioinformatics, Louis Pasteur University (France)

M.Sc. in Genetics, Nankai University (China)

B.Sc. in Biology, Nankai University (China)

Contact this candidate