Data Quality Control

LILIYA MEYERSON

***** ********** *****, *********, ** 20850 * Phone: 301-***-****

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

SUMMARY

* ****** ******* **** **+ years of SAS programming experience, including statistical programming for the analysis

and reporting of clinical, financial, and demographical data

2 Experience with design, development and testing of SAS programs and complex manipulations of large data sets

3 Wide SAS programming experience and analysis support to the International and Domestic Pediatric HIV Studies

Network Coordination Center and Centers for Disease Control and Prevention.

4 Ability to work on multiple projects simultaneously and meet the deadlines

5 Experience of 4+ years in local system administration duties for Sun servers

RELATED EXPERIENCE

SAS Programmer, TSymmetry, Inc. 2013 - 2014

For the United States Postal Service (USPS) (short term contract)

Designed and built datasets to be needed for analytical purposes such as population segmentation and

targeting, historical/predictive modeling, metric measurement read-outs and customer surveys. Translated and

implemented necessary business rules into datasets. Contributed to the development of best practices to improve

quality, efficiency and effectiveness, including data validation. Manipulated data using Data Step programming.

Developed with SAS Enterprise Guide and SAS BI using SAS/MACRO, SAS/ODS, SAS/GRAPH, and SAS/SQL.

Performed complex data manipulation in large SAS datasets (up to 135 million records). Converted SAS datasets to

various file types (text, CSV and excel). Performed regression and correlation analysis for Excel files. Worked

effectively under tight deadlines and frequent deliverables.

SAS Programmer, Bluestone Insourcing Solutions 2012

- 2013

For the Department of Education

Provided programming support for Program Risk Management and Monitoring Team. Utilized SAS 9.2 on Windows

and UNIX platforms to work on Student Loan Finance Projects. Used SAS Enterprise Guide 4.3, SAS Data Integration

Studio 4.2 for development and maintenance of databases/repositories including any necessary preparation, conversion,

and reformatting of data before loading as well as the loading and updating of data and removal of deleted data.

Performed design/code reviews to ensure that code adhered to the Department of Education standards and met industry

best practices. Developed application enhancements and fixed defects, according to prioritization. Analyzed current

processes and technologies to determine where efficiencies and process improvements can be implemented. Developed

using SAS/BASE, SAS/SQL and SAS/MACROS.

Performed complex manipulation of large SAS datasets including merging various datasets, creating combined datasets

using PROC SQL, cleaning up data, computing new variables, standardizing data and storing resultant data into data

library. Exported SAS datasets into CSV files to produce reports. Modified Perl script programs for new requirements.

Systems Analyst, CNSI, Suitland, MD 2010- 2012

For the U.S. Census Bureau

Supported Administrative Records Data Preparation Group. Used SAS 9.2 to work on projects that require input from

several national level administrative records such as the ones provided by the IRS and Medicare.

Created new and modified existing programs on Linux and UNIX platforms. Analyzed requirements and constructed

related design elements. Designed and developed program modules consistent with requirements and specifications.

Manipulated large-scale datasets including loading, formatting, editing and merging of data. Performed quality

assurance tasks including execution of datasets/files through programs. Developed, ran, updated and monitored

Page 1 of 3

LILIYA MEYERSON

13836 Lambertina Place, Rockville, MD 20850 * Phone: 301-***-****

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

production programs. Developed using SAS/BASE, SAS/STAT, SAS/MACROS, SAS/GRAPH, SAS/ODS, SAS/SQL.

Constructed technical specifications and produced validated SAS programs.

Systems Analyst, Westat, Rockville, MD 2006 – 2010

International and Domestic Pediatric HIV Studies Network Coordination Center - Under this contract, involved in 3

challenging projects: National Institute of Child Health and Human Development (NICHD) International Site

Development Initiative (NISDI), HIV Prevention Trials Network (HPTN) 040, and Adolescent Trial Network (ATN).

In support of NISDI (3 protocols of observational study: infants, maternal and pediatric) reviewed analysis, created

new programs, modified and revised existing programs. Used SAS Output Delivery System to extract statistics and

place them in tables and graphic formats. Utilized statistical procedures such as Proc Tabulate, Proc Freq, Proc Means,

Proc Univariate and Proc Summary. Created RTF, PDF reports using SAS/ODS and checked table shells in the

specifications to match all SAS reports. Optimized the existing SAS code performance using SAS/MACROS and SAS

Proc SQL. Responsible for solving unusual and complex programming tasks and issues.

Supported HPTN 040 (DSMB semiannual reports, FDA annual reports, Reconciliation reports, Toxicity reports,

Formula Feeding Study reports, Virology reports) by reviewing analysis, developing new programs, and documenting

new and existing programs. Extracted and validated data from Oracle clinical and SAS datasets. Modified SAS

programs with the use of SAS/BASE, SAS/MACROS, and SAS/SQL for ad-hoc jobs based on the requirements. Wrote

new and modified existing reports using SAS/REPORTS. Produced reports on weekly and monthly basis. Performed

quality control reviews of SAS programs. Helped write analysis requests for laboratory data quality control and worked

closely with data research associates to resolve laboratory data issues. Researched and resolved user issues.

In support of Adolescent Trial Network (ATN) generated Excel files to select plasma and serum samples with certain

minimum volumes from frozen samples NIH repository using Proc Import/ Convert Excel NIH files into SAS datasets

and Proc Export/Convert SAS datasets into Excel files according to the client specifications.

Completed training on all minimum standard requirements for Clinical Trials Area, including but not limited to,

Human Subjects Training, Confidentiality, FDA 21 CFR Part 11.

Utilized SAS 9.2 on Widows XP platform. Work with Oracle clinical datasets.

SAS Programmer, TRI Inc, Rockville, MD 2006 – 2006

For the Centers for Disease Control and Prevention (short term contract)

Supported Centers for Disease Control and Prevention (CDC) contract. Used SAS 9.1 to work primarily with clinical

data to prepare, manage and analyze data sets. Using SAS procedures and macros created and modified programs for

anthrax vaccine research. Used Proc SQL to generate the listing of the Case Report Forms (CRF’s) for participant by

visits and sites from Oracle databases. Created tables to identify the number of participants with according-to-protocol

(ATP) violations. Developed of interim, semiannual, and final study reports.

SAS Programmer, SESC, Herndon, VA 2006 – 2006

For Fannie Mae (short term contract)

Supported Fannie Mae restatement effort. Provided technical support to business analysts by developing SAS 9.1

programs on UNIX platform. Programs were based on ad-hoc request from ClearQuest. Generated reports using

Output Delivery System in HTML format. Extensively used SAS/ MACRO and SAS Proc SQL. Performed complex

data manipulation in large Oracle databases (up to 50 million records). Developed documentation detailing new

development and process flows.

Application Developer VI, BAE Systems, Herndon, VA 2000 – 2005

Page 2 of 3

LILIYA MEYERSON

13836 Lambertina Place, Rockville, MD 20850 * Phone: 301-***-****

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

For the Bureau of Labor Statistics

Utilized SAS 6.12 and SAS 8.2 on UNIX and Windows 2000 platforms.

Designed, developed, and tested research programs for US Bureau of Labor Statistics (BLS). Performed complex

manipulation of large SAS datasets (up to 6 million records). Created programs for various research projects using

SAS procedures and macros. Developed program documentation for existing projects.

Assisted statistical staff on a research project that analyzed data of “high income” wage earners. Supported statistical

staff in preparing summary tabulations of employment data for senior management. Built and maintained environment

to calculate employment and wage rate estimates for BLS surveys by creating directory structure, transferring input

data files, and modifying parameter files. Analyzed data by manipulating multiple datasets, aggregating data and

merging datasets. Developed numerous SAS programs that generated reports and listings, as specified by statisticians.

Exported SAS datasets to Excel and DBF files to produce reports.

In addition to SAS developer responsibilities, performed local UNIX system administrator functions on two Sun

servers. Was responsible for daily and full backup of UNIX servers; server reboots, installation of patches and clusters,

installation of new and upgrade of existing software. Created and deleted user profiles using Tivoli; updated user

profiles. Maintained the Sun server hardware and its disks. Created and maintained file systems on the Sun servers.

Kept servers in compliance with BLS security procedures. Provided end-user support on UNIX servers.

SYSTEMS AND SOFTWARE

Hardware: Sun-Solaris, IBM Compatible PC

Software/Programming Languages: SAS (BASE, MACRO, SQL, GRAPH, ODS), SAS Enterprise Guide, SAS

Data Integration Studio, SAS BI, PERL, Oracle, Tivoli, IBM ClearQuest, MS

Visio, MS Office

Operating Systems: UNIX, MS Windows, MS DOS

EDUCATION

M.S. in Chemical Engineering, Polytechnical Institute, Ekaterinburg, Russia

Additional Training

1 SAS Proc Tabulate, SAS Institute, Rockville, MD

2 SAS/MACRO Language, SAS Institute, Rockville, MD

3 Introduction to SAS/STAT, SAS Institute, Rockville, MD

4 Supporting the SAS Version 9 Environment for IT Administrators, Destiny Corp., Washington, DC

5 SAS Web Tools: Overview of SAS Web Technology, SAS Institute, Rockville, MD

6 SAS Report Writing: A Programming Approach, SAS Institute, Rockville, MD

7 UNIX Administration, Learning Tree International, Rockville, MD

8 Getting Started with Output Delivery System, SAS Institute, Rockville, MD

PERSONAL US Citizen and Clearable

Page 3 of 3

Contact this candidate