SUMMARY:

• 14 plus years of experience performing Requirements elicitation/analysis and documentation—worked with stakeholders, SMEs and end users to identify/define requirements and specifications for new applications and re - engineering for existing applications.
• Excellent writing skills in preparing business requirements documents (BRDs), systems requirements specifications (SRS), system design specifications (SDS) and functional specifications.
• In depth knowledge of Iterative Software Confidential Life Cycle (SDLC) at all stages, Perform Gap analysis and Cost/Benefit analysis, ERP applications—PeopleSoft & SAP; Relational Database Management Systems (RDBM), Passenger Admin System. Systems Analysis/Design, Business Process analysis, Application programming - multiple languages.
• System and User Acceptance Testing; Quality Assurance and Configuration Management. Data Conversions and Testing methodologies to include developing test plans, test conditions and test scripts.

TECHNICAL SKILLS:

Modeling Tools: MS Visio, DFD

Utilities: MS Office Suite, MS Project, SharePoint, Rally Dev, Rally Idea Manager

Methodologies (SDLC): Waterfall, Agile

Databases: Oracle 11/10g, DB2, SQL/DS, MS Access

Testing Tools: WinRunner, QuickTest Pro, HP Quality Center, Rational ClearQuest, SQL Developer

Languages: C, C++, PL/SQL, SQR, SQL, PeopleCode, COBOL, SAS, Shell Scripts

Operating Systems: OS/390, UNIX, Linux, WINDOWS 9x/NT, HP 9000

PROFESSIONAL EXPERIENCE:

Confidential

Sr. IT Analyst

• Attended Mapping Sessions with the vendor to identify data tables and data elements required for data migration
• Performed Data mapping—created Oracle staging tables, default data values and data attributes
• Created and modified MICRO FOCUS COBOL programs to extract data from the legacy Oracle data base
• Created SQL scripts and PL/SQL procedures for data analysis and data extraction
• Created Shell scripts to load staging tables and automate the data load process
• Created PL/SQL procedures and reports to validate the data load process
• Created flat files to transmit legacy data loads to the vendor
• Modified PL/SQL data extract procedures to resolved data load defects and errors

Confidential

Sr. Requirements Analyst

• Created Initial Draft BRD outlining Document Purpose, Intended Audience, Investment Description, Background, Business Objectives, High-Level Requirements, Assumptions and Constraints, Project Roles and Responsibilities, Requirements Points of Contact and Document References
• Incorporated peer review feedback
• Incorporated requirements manager feedback
• Incorporated Confidential team feedback
• Updated signature page based on Business Owner feedback
• Updated the document based on management feedback
• Updated the document based on Business Owner final decision

Confidential

Sr. Consultant

• Configured business rules for the PeopleSoft HR, Recruitment and Payroll modules
• Analyzed, documented and validated requirements for customized PeopleSoft objects
• Made modifications to delivered PeopleSoft Pages, Components and Menus for the HR and Recruitment modules
• Developed Application Engine program to create security interface file with all terminated employees information for transmittal to the security department
• Developed PL/SQL packages, procedures and functions for extracting and updating data
• Developed overall test approach - Scope and objectives, test conditions, test cases, metrics, test entry/exit criteria for the DAPPS application
• Created functional specification documents for required PeopleSoft customizations for interfaces and reports
• Provided requirements validation and system testing of the Inventory Management System (IMS)
• Provide IV&V testing for the Computer-Assisted Clerical Coding (CACC) Software to include requirements validation, test case Confidential, testing, reports generation and status reporting
• Provide IV&V testing for the 2010 Census Coverage Measurement (CCM) creation of the E-Sample and P-Sample person data files Creation software to include test case Confidential, testing, reports generation and status
• Requirements management via Quality Center—loading requirements, mapping requirements to test cases, executing test cases, linking QC defects to test cases, generating QC test execution reports.

Confidential

Consultant

• Configured Legal Plan Rules for three Defined Benefit Plans for the District of Columbia
• Collected requirements, designed procedures and implemented customization to delivered COBOL programs for Service, Final Average Earnings, Optional Forms and payroll
• Designed and developed Application Engine program to compute Leave Without Pay for applicants
• Performed Fit/Gap analysis, designed gap strategies and recommended business process changes to take advantage of delivered functionality and eliminate obsolete customizations
• Modified SQR to implemented COLA calculation for the POLFF and TEACH Pension Plans
• Made enhancements to SQRs for calculating Equalization for Police & Fire Fighters
• Created Custom Statements, Database Aliases and Table Lookups to implement Service functionality
• Analyzed legal plan rules/functional requirements and created technical specifications
• Analyzed Compare Reports and Customizations for the upgrades from v8.0 to v8.3 & v8.3 to v8.9.
• Mapped requirements to test conditions; Created test plans, test scripts and expected test results
• Performed System and User Acceptance testing for the different releases
• Created ‘Helpers’ documents to provide single sources of information for Bureau of Public Debt users.

Confidential

Team Lead

• Developed the Time & Labor and Interface Conversion Implementation Plans
• Developed the Legacy System Data Conversion Test Plan
• Established the ADP/ASG and Vanguard interfaces to transmit HR, Benefit and 401K data to the SAP system
• Ran SAP payroll process
• Developed ABAP reports for Labor Pricing and Labor Collection systems
• Performed “As-Is” / “To-Be” analysis on existing interfaces.

Confidential

Senior Consultant

• Performed Gap/Requirement analysis for re-designs of Labor applications
• Coded/Modified COBOL/CICS applications, IBM Execs, REXX, JCL and VB applications
• Developed Ad hoc and Headcount reports for the Pass Bureau system
• Led requirements gathering for the redesign of the Pass Bureau system.

Confidential

Sr. Consultant

• Performed requirements gathering and Gap analysis for the CATS application
• Created and maintained the CATS DB2 databases and all DB2 related objects
• Created backup and recovery procedures
• Performed database and application performance tuning of SQL
• Created test plan for performance testing DB2 applications.

Confidential

Sr. DB2 DBA

• Performed requirements gathering for the ACS application
• Developed the DB2 to CICS interface
• Created all DB2 related objects—storage groups, tablespaces, tables, views, indices
• Supported application Confidential for performance tuning
• Created database backup and recovery procedures
• Installed the DB2 subsystem at IRS Service Centers
• Converted DOS/VSE JCL and procedures to IBM 3090 MVS/XA JCL and procedures