Summary

• QA System Tester with proficiency in creating Test Plans Test Cases, Defect Tracking and Automated Tools.
• SAS Programmer with extensive years of experience in Ad-Hoc Reporting developing Applications.
• Technical Summary
• Languages: SAS, SQL, C, COBOL, PL/1, Visual Basic, FORTRAN, BASIC, Shell Scripts
• Environments: VMS, UNIX, DOS, Windows 95/98/2000/XP, Windows NT, Internet Explorer, Netscape
• Database: Oracle, Sybase, Informix, Microsoft Access, RDBMS, Teradata
• Mainframe: MVS, TSO, JCL, PROCS, ISPF, File-Aid, TCLIST/REXX, Syncsort, VSAM, IMS
• Business Analyst: Translating Business Requirements into test conditions, writing Test Scripts Test Plans for Unit, Functional, Integration, System, Assurance, White Box, and Black Box Testing
• SAS Modules: Base SAS, SAS Macros, SAS/AF, SAS/SCL, Proc SQL, Proc Sort, Proc Tabulate, Proc Print, Proc Report, Proc Summary, Proc Freq, Proc Formats, Proc Printto, Data null

Work Experience

Confidential

ICD-10 Senior Tester / Contractor

• Modified Test Plan in collaboration with PMs, Application Architect, Application Analyst.
• Required creating/reformatting Test cases, Test scripts for ICD-9 conversion to ICD-10 codes.
• Required exporting test cases to HP ALM.

Confidential

SAS Programmer / Database Admin Tester / Contractor

• Worked as the Database Analyst Tester on SQL Server 2005 for Testing of HIV/AIDS Data.
• Worked as the Lead SAS Programmer for the HIV/AIDS Dept.
• Modified SAS programs ELR/Information Builder to Import/Export data to SQL Server 2005 via
• System Testing.
• Modified SAS programs that had ProDas code- Proprietary CDC statistical analysis reporting tool
• to execute in the HIV/AIDS environment.
• Performed SQL conversion from DOS-based system to Java/JBOSS based system EHARS the HIV/AIDS Reporting System, from CDC.
• Performed Test Analyst duties via creating Test Scripts before Importing Data in a CDC application.
• Performed Manual testing and maintained the System Test Environment for CDC EHARS application.
• Project required working with ICD 9 and ICD-10 codes, System Testing, Defect Tracking, working in a SAS 9.1.3 Windows Environment, SQL Scripting, loading Access data, Excel, SQL Server 2005 and Visual Studio 2005/2008 Developer. Confidential

SAS Programmer - Data Management position / Contractor

• Created Programming SAS code for Import Data Transformation into a Clinical Research Database AHCARS
• Created SAS Programs for supporting the Statistical Analysis Teams via Ad-Hoc Reporting.
• Developed Data Validation E-Checks via SQL and created SAS Macros.
• Created SAS Report PDFs to assist in the QA Testing of the Study Data.
• Project required working in a SAS 9.1.3 Windows Environment, loading Microsoft Excel Spreadsheet data into SAS data sets, the ability to lead or work on several simultaneous projects or activities, a knowledge of Data Management principles, a Broad understanding of Good Clinical Practices GCPs , Good Laboratory Practices GLPs Standard Operating Procedures SOPs , and interacting with other departmental colleagues, line management, and customers.

Confidential

SAS Developer/Business Analyst

• Created SAS Programs to Extract Data from via SQL.
• Performed System Testing and User Acceptance Testing to validate Medicaid Medicare Enhancements.
• Produced Health Care File Layout Reports and Charts via spreadsheets from Medicaid Medicare Environment.
• Project required System Testing, SAS for Unix, Creating SAS Macros, producing charts from Access application, pulling data from an Oracle platform via SQL, Quality Center QC for Defect Tracking HP's Quality Center, Unit Testing Code Reviews, using Microsoft Visio Studio for Source Control TFS , and solving Production abends.

Confidential

System Tester - SUCCESS project / Contractor

• Validated the SUCCESS Documentation against the current Health Care Medicaid/Medicare environment via Gap Analyses .
• Created SAS Programs to extract and validate SUCCESS Test data against Mainframe DB2 tables

using SQL.

• Created Special AD-Hoc Reports using Base SAS SAS Macros and File-Aid.
• Created a Test Case Template for the SUCCESS Team and Mainframe Macros.
• Developed Test Cases without having a manual available.
• Produced Excel Charts to assist in validating of the Application
• Evaluate information from multiple sources to create test scenarios.
• Project required WinRunner, Manual Testing, Defect Tracking, SQL, SAS, COBOL, IBM Mainframes, TSO/JCL, DB2, and Outlook.

Confidential

Business Analyst /Computer Specialist II / Contractor

• Validated current Reporting product to make sure Individual Household definitions were accurately
• translated into Business Rules for the Market Performance Data Integrity Product.
• Performed SAS Programming to verify the expected results and created Test Data from the
• input/output files.
• Documented the Methodology/Process used to create the Market Performance Reports.
• Recommended appropriate product processors, Gap Analyses, and technology changes to propel the MPR from reliance on Excel Spreadsheets into a stable/automated reporting environment.

Confidential

Chaplain

• Worked as a Chaplain at the Atlanta Medical Center, which is a Level II Trauma Center, via
• Care Counseling Centers of Georgia. Was assigned to the CICU and VICU within the
• Intensive Care Area and the orthopedics' floor as well.
• Assisted in the On-Call Duty Chaplain rotation. Duties included providing Crisis Intervention
• and Pastoral Care /Spiritual support to staff and patients, especially on Death Dying consultations.
• Confidential Marketing Lead SAS Programmer/ Contractor
• Performed SAS Programming to create Marketing Financial Target Lists and Adhocs Reports
• using SQL, SAS Teradata to pull information from Oracle and Teradata Warehouse platform.
• Participated in the QC QA of SAS programs for Integrity Checks and reported defects
• found in the SAS Programming Logic Code and on the Campaign Lists Marketing Reports
• Project required Producing Derived-Analysis datasets, UNIX Shell Scripting, SAS Programming with SAS Macros utilizing 8.2 on a Solaris machine and Mainframe, Win2000 and Teradata utilities: BTEQ, FastLoad, MultiLoad, Fast Export and Tpump, and using Cognos Impromtu .
• Pfizer Inc, NY 03/2000 to 11/2001

System Tester / Contractor

• Performed SAS Programming to develop a SAS/AF application utilizing SQL to extract data from Oracle databases for checking the validation of the Clinical Health Data.
• Reduced the Backlog of SAS Macros against the Java Clinical Trials reporting system
• that required interfacing with the Customer to support questions and productions issues.
• Participated in the creation/executing of Test Plans Test Scripts against a Clinical Trials
• Java Web-Based application and reported Defects to Team Leads and Programmers.
• Initiated and executed a Test Plan w/Test Scripts for automation of the Manual Testing
• by using both QARun WinRunner and Test Director
• Project required UNIX, SAS Programming utilizing PC SAS 6.12 8.0 on a Solaris machine, working on Windows NT, WIN2000 and WIN98/95, Internet Explorer Netscape Browsers

Confidential

Unix System Tester

• Built a Test Plan w/Tool for the MPS Application using SAS Programming to create SAS Macros
• to read in Telephony Data and provided Mentoring Training for the Testing Tool.
• Processed Unix Shell Scripts and queried Oracle Databases via SAS Proc SQL for the
• Genesis system and reported defects to the PVCS tracker system
• Developed and performed Manual Testing of Test Scripts w/Test Cases for a Mainframe
• and Client Server Billing System via SAS Programming and SQL.
• Assisted the Development Team with JAD Planning, Gap Analyses, System, Integration, and Acceptance Testing. and Troubleshooting/Resolving Production issues
• Project required the knowledge of Manual Testing, RDBMS, HP UNIX, Access, TSO/JCL,
• SAS COBOL Language, PC SAS, File-Aid for MVS and Client Server, Shell Scripts, SQL,
• and PVCS Tracker for defects.

Confidential

UNIX MAINFRAME Tester / Contractor

• Created and executed a Test Plan Test Scripts via Test Cases on a Y2K Financial Accounting
• Material System using Hiperstation on a Mainframe. Created a Bug Report when defects were found
• in the Application and worked with the Programmers in solving the defects.
• Project required the knowledge of MVS/ESA, VM, TSO, ISPF, JCL, IDMS, EZTEST, HourGlass,
• working on Remedy, NT Server, Windows 98, Excel, and Word, Client Server and Amdahl
• Mainframe Machine.

Confidential

SAS PROGRAMMER

• Produced Ad Hoc SAS Reports on request against a Financial Billing System and Revenue
• Reporting System using SQL.
• Reduced the Time Backlog for User Reports by designing a Mainframe TSO Clist Automated
• Application via the created Test Plan and performed the Manual Testing of the tool.
• Originated and maintained a SAS Macros Library for executing and updating programs.
• Performed SAS Programming to produced Target Lists and Ad Hoc SAS Reports to monitor
• the sales revenue activity of a Commissions System
• The 3 Projects required knowledge of PC SAS, SAS Mainframe, ISPF, File-Aid, JCL, COBOL,
• MVS, and TCLIST/REXX

Confidential

System Tester

• Performed SAS Programming to provided mentoring training for the Test Plan creation
• of the SAS Batch Process Functionality.
• Translated Gap Analyses and Business Requirements into SAS Programming Test Cases for a Cellular Billing System Financial Systems
• Performed Manual Testing execution of Test Scripts for actual results while creating new
• Test Cases as needed.

Confidential

SYSTEM Tester / Contractor

• Prepared a Test Case Calculated Matrix for the expected data against the Retail Business requirements.
• Created executed Test cases for Regression and Acceptance testing and reported Defects.
• Project required knowledge of ISO 9001 SDLC Methodologies, HP/UNIX, Windows 95, Microsoft Excel, Integration Testing, and ISQL/Informix.

Confidential

System Tester / SYSTEM SUPPORT

• Performed System Testing against a Delta Airlines Financial Accounting System via SAS, Shell Scripts
• and SQL.
• Provided SAS Programming System/Software solutions to Abend Problems and System
• Performance on a 24-Hour Call.
• Assembled UNIX BOURNE Scripts to verify Functional Testing against Business requirements.
• Project required knowledge of SDLC, SAS, Visio, Testing Functional, Integration and System Testing , executing Batch jobs/scripts on IBM Mainframes, Oracle, Sybase, RDBMS, UNIX Environment, and SUN Machines.

Confidential

SAS PROGRAMMER

• Worked on multiple projects for various Customers as the SAS Programmer Team Co-Leader.
• Performed SAS Programming to produced Target Lists Financial Ad Hoc SAS Reports
• and Monthly Reports to support the Account Service Billing and Invoice.
• Identified various ways to improved SAS Programming work on the MVS Environment,
• which increased productivity.
• Project required the knowledge of MVS, PC Windows Environment for SAS, SAS Mainframe,
• and reading of Oracle, COBOL Language, TSO/JCL, MVS/ESA, ISPF, IBM ES9000, Teradata,
• Natural Language, File-Aid, and Syncsort.

Confidential

UNIX Tester / Contractor

• Composed and executed Test Cases against a Product Manager System utilizing Winrunner.
• Created Test Plans and performed System Integration, Functional, System Regression testing.
• Project required knowledge of ISO 9001 SDLC Test Methodologies, WinRunner, Test Director, Test Script Language TSL , AIX/UNIX, Office Vision, Lotus Notes, Windows, OS/2 Warp, Microsoft Word, AIX, HP, SUN, and IBM X-Station.

Confidential

SAS PROGRAMMER I

• Produced AD HOC SAS Reports for Target Lists from millions of Financial Statistical US Census Data records on tapes using Proc SQL.
• Composed SAS Programs that generated Tables, Listings, and Subset Data Files via programmed edited checks for the Statistical Researchers and User Community.
• Developed a SAS/AF/SCL Application providing a GUI Environment for displaying the Census Data.
• Project required knowledge of IBM ES9000, MVS, PC Windows Environment for SAS, SAS Mainframe, TCP/IP, TCLIST/REXX, File-Aid, and COBOL.