SUMMARY

• SAS Certified Professional (V6) with more than 20 years experience in the Research & Analysis/SAS arena, and 3 years administering the SAS contract at the US BLS. Specifically have served as senior SAS programmer and Windows Server Administrator, and have acquired proficiency in SAS programming language, Oracle, Sybase, Unix, SPSS, IBM Mainframe TSO and JCL, MicroSoft Office, all of which are discussed further in this resume.

TECHNICAL SKILLS

Unix server: Installing SAS and testing its connectability to Oracle and Sybase; SAS in batch mode using SAS/Connect; testing programs from the command line.

Microcomputer (IBM standard, DOS and WINDOWS): Experienced user of Microsoft Office, statistical packages, spreadsheets (Excel), word processing (MS Word), database (MS Access, Reflex, Paradox), web - browser, accounting (Quicken, DAC/Easy), project management (MS Project, Insta Plan), Charting (MS Visio, RFFlow)

DEC-VAX Minicomputer: Statistical (MINITAB) and database (INGRES) software.

IBM Mainframe (OS/MVS, TSO, ISPF): SAS Programming Language, SAS Macro Language, SAS statistical procedures both batch and interactive; Utility packages (DYL250, MARK IV, SAS, SPSS, TPL); experience with DB2 and SQL (QMF and SPUFI); reading knowledge of COBOL; experience with CA DataReporter against CA Datacom Databanks, Oracle, and Sybase.

PROFESSIONAL EXPERIENCE

Confidential, Washington, DC

Sr. SAS Consultant

Responsibilities:

• Assist the IT group in upgrading to the latest SAS version. Interview current users, assess software needs. Determine appropriate environment configuration and mix of SAS modules.

Confidential, Silver Spring, MD

Sr. SAS Programmer

Responsibilities:

Convert Mainframe programs that generate case - management listings on Payroll matters to Oracle-based system under Unix (CSBSelect, DMDC1 DEERACT, XMLYCURA), and update them with new features. XMLYCURA changes reduced processing time by 2/3. Design and prototype new Case Management Listings (Anniversaries, Big Change, Detail Change, Status Counts). Prepare tables and graphs on PHS Staff composition, seniority, and age (Active Duty, Certificates, LoS Chart).

Confidential, Arlington, VA

Sr. SAS Statistical Programmer

Responsibilities:

Generate tabular counts of confidential Immigration Enforcement actions for a quarterly report to Congress. Conduct in-depth investigations of enforcement-related questions such as length of time in confidential detention, and potential weaknesses in current programming. Used PC SAS under Windows 7.

Confidential, Wakefield, MA

Sr. SAS Statistical Programmer

Responsibilities:

Develop SAS programs to create analysis files for lead analysts in medical outcomes research in a Unix environment using scripts. Prepare documentation of all programs and outputs for each project. Perform QC Reviews of colleagues’ work. Was acknowledged for programming work in 2 published studies.

Confidential, Washington DC

Sr. SAS Statistical P rogrammer

Responsibilities:

Maintain and enhance the SAS/Excel/Access/Adobe system for randomly selecting employees for random drug testing on behalf of the Department of Homeland Security. CBP Background Investigation completed. Document data sources, processes, and business requirements for the full system.

Confidential, Washington, DC

Windows & SAS Admin

Responsibilities:

Support the SAS Software in the BLS Division that produces the monthly Employment/Unemployment statistics. Perform Windows server maintenance on Production server (scan event logs, track disk free space, install and verify hot fixes, etc.). Adapted Division’s SAS programs to comply with secure logon requirements, testing in a Unix environment.

Confidential, Washington, D.C.

SAS Administrator

Responsibilities:

Track and enforce provisions of the contract between confidential; perform installations on PC and on Solaris server, including connections with Sybase and/or Oracle. Establish & maintain testing environments to investigate possible SAS version migrations. Test and install SAS hot fixes. Troubleshoot users’ issues using SAS; lead the power-users’ technical committee, advise SAS managers on technical and contract issues; lead testing and prepare documentation of new SAS products and of SAS’s interactions with other new products such as operating system versions. Testing includes the SAS connection with Oracle and Sybase. Assist LAN Support in equipping training rooms with appropriate SAS software; lead the in-house SAS Users Group. Installed and maintained 2 demonstration projects of SAS 9.1.3 Business Intelligence, using SAS Management Console, and Data Integration Studio.

Confidential, Washington, D.C.

SAS Statistical Programmer

Responsibilities:

As a Contracting SAS Programmer to a medical-care research firm, develop person- or episode-based analytical files from databanks about health-insurance claims. Work with lead investigators to perform studies of economic impact/burden of several illnesses and types of medications. Databanks reside on remote Unix server accessed via SAS Connect v8.

Confidential, McLean, VA

Sr. SAS Programmer

Responsibilities:

• As a Consulting SAS Programmer, develop appropriate data in collaboration with U.S. Customs resident statistician and field experts and perform preliminary analyses toward an algorithm for targeting newly-arrived shipments of goods for their potential to violate confidentrial Property Rights laws.
• As a Consulting Analyst, assist U.S. Customs experts in developing a system to evaluate the performance of most elements in the importation supply chain in keeping the goods safe from damage by terrorists.
• As a Consulting Analyst, maintain the SAS programming central to the U.S. Customs system to evaluate the performance of importers in complying with U.S. import laws (CAPPS). (SAS v6 and v8).

Confidential, McLean, VA

Sr. SAS Programmer

Responsibilities:

• As a Consulting SAS Programmer, radically reconstruct a Mainframe SAS application to allow Import Specialists with the US Customs Service to target incoming shipments of goods for further scrutiny based on an unusual declared unit price of the goods.
• Working closely with the resident statistician, design the selection algorithm taking into account the varying and complex shapes of the distributions of the many types of imported goods. Redesign user screens and programming with SAS/AF and SAS/FSP. Rebuild daily, weekly, quarterly, and occasional batch routines for ease of subsequent maintenance. (SAS v6)

Confidential, Fairfax, VA

Statistical Programmer

Responsibilities:

As an independent contractor, perform statistical analyses for a lead researcher in a study under Dartmouth Medical College aegis. The researcher provided computerized data and indicated the types of contrasts to be explored; I prepared the final analytical files, determined and performed the required transformations, ascertained appropriate statistical procedures, and developed the results. This work was done with SPSS PC.

Confidential, Vienna, VA

Sr. SAS Programmer

Responsibilities:

As a Consulting SAS Programmer, radically reconstructed a system of SAS v6 Mainframe programming to produce performance indices for Federal District banks in the Federal Reserve System, following a drastic overall of the definitions behind the indexes. Similarly reconstructed the Mainframe SAS programming for the Budget system pertaining to the activities measured in the performance indexes. Also produced documentation on PC with RfFlow and Word Perfect.

Confidential, Washington, DC

SAS Statistical Programmer

Responsibilities:

• As a Senior SAS Programmer, developed PC SAS v6 programming for analysis of unit non-response bias in a national mortality follow back survey.
• Converted PC SAS programming to mainframe use in a confidential study of alternative diagnostic measures for diabetes. Reconstituted the analytical files using final Public Use data; validated programming and statistical results.
• Built SPSS PC analytical data sets from ASCII data in a national study of primary-care practitioners' diagnosis and treatment of clinical depression. Prepared tables of reference data and conducted statistical analysis for a Consumer Product Safety Commission investigation of secular change in several body measures of children.

Confidential, Indianapolis, IN

SAS Clinical Programmer

Responsibilities:

• Created and maintained universal programs in the SAS v6 Macro language to transform field data from clinical trials ready for storage in the centralized DB2 database for later analysis and reporting for a world-wide pharmaceutical company.
• Prepared introductory and overview materials about data flow and about the topics on which data are collected for use in orienting new team members.

Confidential, Washington, DC

SAS Statistical Programmer

Responsibilities:

Assisted a federal health-statistical agency in converting a major nation-wide survey from paper-and-pencil to Computer Assisted Personal Interview format. Set preliminary specifications for basic analytical files to come from the new data-collection system. Designed prototype programs to extract the appropriate data from the files provided from the field into the proper structure for the analytical files.

Confidential, Vienna, VA

Systems Analyst

Responsibilities:

Designed sections of the RMA program database to accommodate information from psychological instruments supplied by subcontractor firms. Devised procedures for electronic transfer of the psychological instrument data, and other data supplied by subcontractor firms. Designed standard and custom reports for caseload management as well as program management and federal reporting.

Confidential, Madison, WI

Sr. Research Analyst

Responsibilities:

• Supervised the design, implementation, and operation of a DB2 system for local entry of field agency staff time distribution. The data was used in cost allocation and budgeting.
• Designed and conducted studies to assess efficacy, equity, and adequacy of services in the AFDC Work Program.
• Implemented and maintained eclectic database for setting workload standards, determining funding levels, and evaluating performance of field agencies. Designed, implemented, and managed information systems to allocate $20M monthly overhead costs among agency programs, including training of remote field staff.
• Developed PC- and mainframe-based system to analyze information on Food Stamp recipients disqualified for failure to seek work.
• Designed and conducted studies to explore the connections between single-parenthood and dependency on Public Assistance.

Confidential, Madison, WI

Research Analyst

Responsibilities:

Built PC-based system to measure and evaluate accident-investigation efforts. Built data system to assess hearing examiners' performance in managing caseload. Developed guidelines, forms and procedures for security of Division's mainframe-based data. Devised and implemented data security procedures and programming for the Division.

Confidential, Madison, WI

Research Analyst

Responsibilities:

• Designed and conducted study of association between accident-descriptors and confidential standards cited in accident investigations.
• Key member of design team for a major study of hazards in operating materials handling equipment. Designed and conducted the forklift portion of this study, including logistics and supervising staff.
• Developed analytical procedure, format for a series of 35 booklets analyzing patterns of illness and injury experience for major industries, including Sawmills and Ferrous-Metal Foundries.