PROFESSIONAL EXPERIENCE

Confidential

Database ETL, Data Migration Expert

Responsibilities:

• Responsible for imparting knowledge and expertise of both Univac and Sperry type Unisys Mainframes and DMS, RDMS and DMS II Databases; in support of client project proposal presentations, Proof of Concept (POC) work and edification of other Data Modernization team members.
• Performed data usage analysis, documenting data flow in programs, files, databases, datasets, DASDLs, procedures, and copybooks.
• Ensured ETL (extract, transform and load) of all data from databases and data files, by creating and compiling COBOL extraction programs, creating SQL databases, tables, and scripts to transform and load data.
• Verified data integrity and accuracy using Slick Edit software tool, SQL Bulk Admin, and SYSTEM/DUMPALL to identify HEX, DEC, ASCII, EBCDIC and unprintable characters.
• Resolved data extraction and migration issues due to complex variable data type and field length redefines within compressed data fields and complex data set relationships.
• Responded to requests for information and issue resolutions using JIRA Software and shared documents and reports via Sharepoint.
• Acquired additional training in Legacy Modernization, Powershell, Agile Principles and Methodologies, SQL Server (2012/14), SSMS, SSIS, SSRS.

Confidential

Test Management, Data Migration & Integration Specialist

Responsibilities:

• Responsible for testing of OMS II system (79th largest national ecommerce business); by planning and conducting Data Migration, Systems Integration, Reports, and Ecommerce functionality and comprehensive testing; throughout all project phases, including Soft launch and Go - live, using stand-up SCRUM and agile testing methods.
• Conducted unique test scenarios brainstorming sessions with US Mint Numismatic Subject Matter Experts (SMEs).
• Created the following: RTM; Testing Flow; brainstormed Test Scenarios; 40 manual and 110 automated tests scripts; crosswalk of Business Requirements (BRD) to test scripts; Database Data Migration and Systems Integration Plans; Migration and Integration checklists; Entry and Exit criteria checklists for Unit Testing (UT), System Integration Testing (SIT), Quality Assurance Testing (QAT), and User Acceptance Testing (UAT); Data Migration Testing Summary Report, SIT Summary Report, and QAT Summary Report.
• Validated testing and completed summary reports for project phases UT, SIT, QAT, UAT and Soft Launch.
• Utilized HPQC to upload test scripts, trace scripts to RTM, export scripts for test execution, create test lab folders for tracking test execution, record results and progress, and to upload reported defects and resolution progress.
• Used IBM Digital Analytics to view statistics and market trends.
• Acquired additional training in Agile Software Testing Methodologies

Confidential

Test Management - Team Lead & Database ETL Test Specialist

Responsibilities:

• Responsible for Data Extraction, Transformation and Load (ETL) from 224 source file feeds and tables using Informatica to SQL Parallel Data Warehouse (PDW) Staging tables, Staging to SQL Physical Design Structure (PDS) tables in 10 Functional Areas, PDS to SQL Enterprise Data Warehouse (EDW) tables, Data Marts and SAS Reports.
• Created Business Requirements Documents (BRD) for all 30 output SAS Reports, Requirements Traceability Matrix (RTM), Test Cases, Test Scenarios, and Test Scripts for each ETL stage.
• Led test team validation of source feeds through Informatica to SQL Staging tables using Informatica Workflow Manager, Design & Monitor; and Staging to PDS, PDS to EDW, using complex SQL queries, SQL Bulk Admin, and SQL Server Management Studio (SSMS).
• Utilized Agile test methodology with daily standups, storyboards, whiteboards and SCRUMs for testing all ETL stages and regression. Serena was used for logging defects and fixes.
• Acquired additional training in Test Management and Informatica

Confidential

Business Analyst, Programmer Analyst & Project Management

Responsibilities:

• GSA Federal Acquisition Service - Applications, Maintenance, Enhancements (FAS-FAME) Project, Crystal City, VA
• Responsible for Quality Control COBOL Team Research, Analysis, Design, Development, Maintenance, Testing and Peer Review of all: Daily, Weekly, Monthly and ad-hoc processes QC COBOL applications, Work Flow Language (WFL) and DMS II datasets; utilizing Systems Development Life Cycle (SDLC) Methodology, Programmer’s Workbench (PW), CANDE, and DM Inquiry, TRACKER, Relativity, and Eclipse.
• Led all COBOL Major Projects: Finance Reconciliation, Wrap plus Daily, MASS Email Capabilities, RCVP Phase I, RCVP Phase II, OCMS-CIS, M-QC-ID, CAV, SUBK, Payments & Claims Processing, RCVP Enhancements, Contract Handling, Closing Headers, QC Log, Home Sales Transactions, BPA Contracts, and Email Address Verification.
• Contributed majority of QC COBOL 4 member Team workload: 85% of all Research & Analysis; 75% of all Design & Development; 55% of all Testing; and 35% Peer Review; while training and supervising Junior COBOL programmers, and as a supporting member of the OCMS project team.
• Established Documentation Library, as a repository for storing and sharing QC processes and application documents to all teams; with directories consisting of QC Documentation, Programs, WFLs, Software Design Documents, Test Plans, DASDLs, Processing flowcharts, I/O Structures and sample Web Reports.
• Created detailed Test Plans & Software Design Documents, increasing application documentation from 22% to 47% and a Documentation Repository Checklist to ensure and maintain documentation for each library directory.
• Awards: 7 Blue Chips, 3 Certificates of Appreciation (RCVP 2009, O&M Changes 2011, Supplier Visit 2011)
• Committee Chair: Lockheed Martin Peer Awards & Activities
• Acquired additional training in OCMS Modernization, Business Analytics, Business Modeling, UML, Eclipse, JAVA

Confidential

Business Analyst & Programmer Analyst

Responsibilities:

• GSA Federal Acquisition Service - Applications, Maintenance, Enhancements (FAS-FAME) Project, Crystal City, VA
• Responsible for Quality Control COBOL Team Research, Analysis, Design, Development, Maintenance, Testing and Peer Review of all: Daily, Weekly, Monthly and ad-hoc processes QC COBOL applications, Work Flow Language (WFL) and DMS II datasets; utilizing Systems Development Life Cycle (SDLC) Methodology, Programmer’s Workbench (PW), CANDE, and DM Inquiry.
• Diagnosed problems and engineered improvements to QC COBOL applications, and restored integrity to the DMS II database; created critical resolutions: X31M1 orphan dataset, database restore safety feature, and Finance file verification & reconciliation process.
• Created Business Requirements Document (BRD) for FSS-19 Data Transfer to Past Performance Information Retrieval System - Statistical Reporting for Department of Defense (DOD).
• Created WIKI Documents: Daily Audit Verification, OLA Processing, FAX/SMTP/Email Send, Implementing & Testing Web Reports, WFL Guidelines, Coding COBOL Programs (Best Practices), Error Handling, Analyst Guide, Developer Guide, Unit Testing Guide and Peer Review Guide.
• Created Processing Reference Guides: QC Cycle WFL Flow; WFL/Program/Dataset/File/Web Reports.
• Led Major projects: SRC, ARC, 72A Redesign and PR Monthly IFF Sales Reports regarded by Congress.
• Acquired additional training in SDLC, Relativity, Six Sigma, 3D Blueprinting, Business Architecture, Business Analysis

Confidential

Applications Programmer

Responsibilities:

• Responsible for Audit and OLA processing; Design and maintenance of QC COBOL applications, DMS II datasets, DASDL(s), and WFL(s); using CANDE, PW, and DM Inquiry.
• Created WIKI Documents for Master URSA User’s guides of SRC, ARC, and GWAC, and how to upload to Wiki guide.
• Responsible for Systems Analysis, development and maintenance of all Unisys Mainframe System software, hardware and functionality; all system related applications, backup and recovery processes, all internal and external interfaces with other systems and servers which included: V77, Tandem, Tartan, IBM AS/400, Xerox, Unix, FTP and MS2000.
• Responsible for Programming Analysis, development and maintenance of all Western Union Messaging COBOL and VB applications, all PhonePay Lotus Notes and Crystal Report applications; all program processes, execution runs, data flow, interfaces betwixt client and vendor systems, and all documentation and procedures.
• Responsible for Business Analysis, documenting all business processes, business flow and interfaces utilizing MS Visio.
• Responsible for Database Administration, database reorganization, backup, retention and recovery processes of all Unisys Mainframe DMS and RDMS, as well as SQL and Access databases.
• Responsible for Project Management and programming lead of all technical projects, using MS Project Manager.
• Analyzed all WU business, environment, applications and processes for future legacy migration from Unisys Mainframe to a Network and PC based environment.
• Championed the DMS to RDMS migration project, by analyzing and extracting data from all DMS databases, datasets, subsets and repositories; designing and creating all RDMS relational database structures and repositories and loading extracted data. Converted all COBOL applications to use SQL instructions for accessing the new RDMS databases.
• Engendered the Billing and Finance overhaul project saving 2.5 million by analyzing EDS’ AS/400 system applications and screen functionality, redeveloping all WU applications and processes for effective transfer of data, and hatching a new Billing revenue code structure with an auto-breakout process from complex to simplex codes.
• Authored design and development of Federal and State Representative zip+4 district indexing, update and matching processes based on senders zip+4 address; for Capitol Hill, Hotline and POM products using COBOL and VB.
• Created new White Mail, Self-Mailer and Next Day Telegram products and processes; and guided creation of the online Web version of the Next Day Telegram and Libra system processes.
• Directed development of COBOL applications for text and address manipulation process of RTF formatted data, supporting all messaging products; and the IP address change projects.