Data Analyst

***** *** ********** **** ****, Rockville, MD ****2

Mobile Phone: 202-***-****. Email Address: *******@*****.***

EDUCATION

M.S. in Statistics (Computational), Texas Tech University, 1984

B.A. in Mathematics with minor in Chemistry, Texas Tech University, 1980

EXPERIENCE SUMMARY

Twenty six years of experience as SAS Data Analyst in design and

maintenance of large databases such as financial marketing data, and

operational data, national/international education data, Census data (SIPP,

Decennial Housing and Population), and health related data (Pharmaceutical,

Skilled Nurse Facility, and Canadian Health Care and Medicare).

Eight years of experience in Clinical Studies on indications of Oncology,

Systemic Lupus Disorders, and CNS (Moderate Depression). Developed,

documented, and maintained project standard MACROs and programs used across

all protocols. Wrote program templates for standard tables. Created

guidelines for validations and programming documentation. Provided

technical guidance and mentoring to consultants and junior programmers.

SKILLS SUMMARY

SAS development: 26 years (Base, Graph, SQL & MACRO), SAS 6 - 9

Owner of full lifecycle development of database: 23 years

SAS subject matter expert, provide guidance and support to junior team

member: 10 years

SAS performance turning: Simplify structure, reduce CPU time and storage

space,

Design data development with modularization Top-Down design: 10 years

Data Management (Data mining, Data warehousing, Data Storage, Log retention

for Auditor)

Design Tree structure of SAS Macro and Format Libraries

Seasoned in Automation: at Chevy Chase Bank reduced daily reporting from 6

hours to hours

Data visualization: SAS (Graph, ODS & Report), Excel (Graph & Chart)

Create Edit Check programs, QC programs, Validation programs

PROFESSIONAL EXPERIENCE

Principle Data Analyst, Capital One Financial (Chevy Chase Bank), Apr07-

Present.

Developing credit card application monitoring system, charge off and

collection process reports. Creating report system and analysis tools to

query and monitor critical Branch Operations data from central data

repository. Redesigning and automating operation to package data from

mainframe/network computers to produce MS Excel/ Visual Basic spreadsheets.

Providing analytical support during the merger of Capital One & Chevy

Chase Bank. Support fraud investigation unit by tracking, reporting and

data mining. Using SAS 9.3 on Unix/PC and SQL (Teradata, SAS).

Sr. Programmer Analyst/Data Manager, the Biostatistics Center of GWU, Feb04-

Apr07.

Collaborated with project statisticians to process and validated analysis

data; designed and produced presentation-quality tables. Conducted

technical programming and process improvement initiative for other data

manager, assisted biostatisticians and other data managers in programming

troubleshoot. Streamlined data formation process by creating user-friendly

MACROs and clear instructions to ensure efficiency and accuracy. Provided

support and guidance to junior programmers. Created critical documentation

of analysis data set to fulfill the NIH repository requirements.

Statistical Analyst, Biostatistics Department, Human Genome Science, Inc.,

May02-Jan04.

Contributed in infrastructure-building by creating new SAS MACRO programs

to enhance existing tools and writing guidelines for programming,

validation and documentation processes. Initiated more efficient methods

to handle tedious report writing elements by improving the existing Macro

to generate HTML report tables and creating MACRO to generate RTF tables.

Validated, prepared tables/listings for pivotal clinical studies.

Clinical Data Analyst, Biostatistics Department, MedImmune Oncology

(Consultant of CSG), May01-May02

Produced and validated Tables/Listings for Phase II, III and post-marketing

data in Oncology Medication Study. Provided ad hoc reports and analysis

reports on safety quality control, data issues and protocol violation;

reviewed annotated CRF; initiated building internal applications; and

validated patient profile reports and generated datasets/codebook for

electronic submission of SNDA (Supplement New Drug Application) to FDA.

Clinical Trial Data Analyst, Scientific Programming, Otsuka America

Pharmaceuticals, Inc. (Consultant of ASG), Jan00-May01

Produced and validated Tables/Listings for Phase I & II studies on

Depression Medication Studies. Validated data structures; reviewed

annotated CRF and Edit Specification; built, validated, and documented

internal applications.

SAS Developer, AT&T (Consultant of IMI), Feb99-Dec99

Converted VM generated report to SAS reports for a GUI system.

Data Analyst III, Marking Department, America One Service Corporation,

Oct96-Jul98

Designed mass-marketing service and financial database based on SAS and

Oracle (SQL) on UNIX workstation and Amdahl mainframe. Provided customized

reports to senior management, and produced ad hoc reports in a short

turnaround time. Taught SAS.

Senior Analyst, Lodging Finance, Marriott International, Jul94-Oct96

Redesigned of the Decision Support System by combining financial,

accounting, and operation data used in marketing, accounting, and

budgeting. Implemented shadow financial database system in SAS for use in

ad hoc financial reports; developed Financial OLAP Oracle Express Decision

Support Systems; and built interface systems between Marriott and External

Marketing Data Providers.

Senior Programmer/Analyst, Computer Services Department, Urban Institute,

Nov89-Jul94

Designed, created, and handled large national/international databases for

statistical analysis projects. Performed in-depth studies and critical

analyses on National Child Care, National Health Insurance Study, Canadian

Health Care, Medicare, Census Decennial Housing and Population (STF3A

70,80,90), and the fuzzy-merged data of Skilled Nurse Facility (SNF) and

Survey of Income and Program Participation (SIPP).

Associate Research Data Analyst, Educational Testing Service (ETS), Sep84-

Nov89

Performed analyses on large database (National Student Financial Aid),

historic testing data, and demographic data (HSB, NLS, SAT, GRE, TOFEL,

Handicap, National Critical Care Nurse, HEGIS.

Teaching Assistant, Texas Tech University, Sep80-Jun83

Taught undergraduate Mathematics courses.

HARDWARE/OPERATION SYSTEMS

UNIX workstation/F-Secure, Mainframe (JCL, TSO/ISPF), PC, VAX 11/780 (VMS)

SOFTWARE

SAS 9.3 (Base, Macro, Graph, ODS, Enterprise Guide, Report, DDE), SQL

(TeraData & Oracle), Excel (VB), Oracle Express, FORTRAN, RTF, HTML, C,

COBOL.

Clearance

U.S. Citizen with ability to obtain NACI clearance

Contact this candidate