Post Job Free

Resume

Sign in

SAS, Statistics, SQL, Excel

Location:
Washington, DC
Posted:
October 12, 2014

Contact this candidate

Resume:

Meisheng Zhou, Ph.D.

**** ******** ******, *** ***, Bethesda, MD 20816

Phone: 301-***-****(C); Email: acgckn@r.postjobfree.com

SUMMARY

SAS Certified Statistical Business Analyst Using SAS 9: Regression and

Modeling

Knowledge of software development life cycle (SDLC), database design, RDBMS,

SQL, data warehouse, business intelligence, SAS, and SAS statistical analysis

• Strong working experience with SAS statistical methods such as descriptive analysis,

categorical data analysis, linear regression, logistic regression, analysis of variance

(ANOVA), and model performance measurement

• Extensive working experience with SAS BASE, SAS Macros, PROC SQL, SAS/STAT(R),

SAS/GRAPH, SAS Enterprise Guide, SAS Web Report Studio, OLAP Cubes, and Ad-hoc

analysis reports

• Experience with interfacing between SAS and various external data sources such as Excel,

Access, DB2, Oracle, and raw data files

• Strong working experience with SAS data step to create SAS data sets, perform complex

data file merges, create analysis variables, and execute SAS processing such as Do Loop

and arrays

• Strong working experience with Base SAS procedures to generate listing, reports, tables,

charts, plots, and graphs

• Knowledge and experience using ODS to produce output to various destinations (HTML,

PDF, Text, Excel, XML)

• Specific expertise in assembling and organizing data in tabular (tables, graphs, and charts)

and narrative form for documentations, presentations, and regulatory submissions

Familiar with Oracle 11g, Microsoft SQL Server 2012, My SQL, T-SQL, and PL/SQL

Proficient with Microsoft Office Word, Excel, PowerPoint, Access, XML, and HTML

Knowledge and experience with business intelligence, project management, and

business requirements

Familiar with clinical trials including knowledge and thorough understanding of

CDISC, SDTM, ADaM, and principles of SAS programming validation

PhD with knowledge of medicine, healthcare, pharmaceuticals, biology, and statistics

Familiar with therapeutic area such as HIV, virology, microbiology, and oncology, and

especially with anti-HIV drug development, and strong record of scientific achievements

• Strong time management/organizational skills, analytic and problem-solving skills; and

abilities to work independently

• Excellent verbal and written communication skills, interpersonal and collaborative skills;

and abilities to work effectively in a team-oriented environment

1

CITIZENSHIP

U.S. Citizen

EDUCATION

Ph.D., 1996, Microbiology & Immunology, Chinese Academy of Preventive Medicine,

China

Master's Degree, 1993, Pharmacology & Toxicology, Peking Union Medical College,

China

Bachelor’s (equivalent to MD in US), 1988, Medicine, Nanjing Medical University, China

CERTIFICATION

SAS Certified Statistical Business Analyst Using SAS 9: Regression and Modeling

Certificate No: SBARM001155v9

EXPERIENCE

SAS Programmer (Certified SAS Statistical Analyst), CBCMG, Gaithersburg, MD;

01/2014 –Present

Design and develop data applications using SQL Server Integration Services (SSIS),

PL/SQL, T-SQL, SAS PROC SQL, and stored procedures

Analyze and update datasets using the SQL Server Analysis Services (SSAS) and

SAS programs

Maintain and report data using SQL Server Reporting Services (SSRS), PROC

REPORT, PROC TABULATE, and SAS/GRAPH

Data Analyst / Business Manager, Berry Yo Bethesda LLC, Bethesda, MD;

06/2010 - 12/2013

Performed collection and storage of unstructured raw data for business intelligence

(BI)

Developed business intelligence by data integration, data quality, data warehousing,

data mining, master data management, and text and content analytics

Identified and created new business opportunities and implemented effective business

strategies

Performed data import and export through utilizing integrated CCS database

programs

Executed aggregate functions or SAS dataset functions through writing SQL queries

or SAS codes and data reporting with SSRS or SAS procedures

PAGE

Conducted data sorting and grouping and data analysis utilizing SAS statistical

programs

Research Fellow, National Institutes of Health (NIH), Bethesda, MD; 03/2003 - 05/2010

Utilized SQL an SAS to plan and manage research projects and analyze and interpret

scientific experimental data

Created SAS data sets by interfacing Microsoft Office Access, Excel spreadsheets,

and raw data files

Grouped and sorted data by utilizing SAS procedures such as PROC SORT, PROC

REPORT, and PROC MEANS

Analyzed data with PROC SQL and SAS statistical methods such as dispersion

analysis, analysis of variance (ANOVA), linear regression, and logistic regression

Performed SAS programming to generate output listings, reports, tables, charts, plots,

and graphs

Incorporated the tabular form (tables, graphs, and charts) of scientific data into

narrative form for internal documentation requirements and regulatory submissions

Research Scientist, George Washington University, Washington, DC; 09/2000 - 03/2003

Converted scientific experimental observations to dataset formats by knowledge-

based software applications

Managed research projects and analyzed experimental data with SQL and SAS

programs

performed SAS programming, SAS function applications, SAS PROC SQL, and SAS

statistical analysis

Assembled and organized scientific data in tabular and narrative form for

documentation, presentations and publications

Postdoc Fellow, National Institutes of Health (NIH), Bethesda, MD; 10/1996 - 04/2000

Utilized Microsoft Excel, SQL, and SAS to analyze and interpret experimental data

Created and restructured scientific data sets, and executed conditional, DO Loop and

SAS array processes

Performed SAS statistical analysis such as descriptive statistics and inferential

statistics

Generated data reports in tabular form (tables, graphs, and charts) for presentations

and publications

3



Contact this candidate