Jo Ann Todd

adgp71@r.postjobfree.com

H 703-***-****

M 469-***-****

Public Trust Clearance

Summary:

32+ years of progressive technical responsibility with extensive experience in SDLC methodologies in multi-platform environments: IBM mainframe, Internet, Intranet, Sharepoint. Skills:

• Functional requirement derivation

• SIT, QA, CAT/UAT, Integration test planning and execution

• Define User Stories, Use Cases, Test Scenarios, Test Cases and scripts

• Database conversion and validation; data management

• Requirement Driven testing

• Rational Tools Suite

• End-User Training including Materials and other Technical Documentation

• DB2 and IBM mainframe (JCL, TSO/ISPF, Control-M, File Aid and File Manager for DB2 Tools, SQL)

• Legacy Application and Mainframe development

• Project Planning and Timeline

• System Integration

• Budgeting and Financial Management

• Front and Back end testing

Employment History:

2018-Present, Sr Business Analyst IV Test, Northrop Grumman (USPS HQ Contract – PTR Marketing – GOVT – Full BI). Create and maintain automated and manual testing methods. Develop, maintain, and upgrade automated test scripts. Perform analysis including test scenarios, test cases, test scripts, and determine expected results for CAT/UAT. Programs SQL queries using SQL table joins for multi-table databases to select data for test conditions, prove expected results, and provide reporting. Define test data requirements, acquire/create data, and modify for test conditions. Execute and/or verify database, front end testing, back end testing, and application conversions for tests. Provide support for testing internet applications. Identify and document any changes to existing instruction manuals. Provide support and coordinate the transfer of data files to/from other external system(s) for systemic processing. Create procedure for reporting system testing status and implement. Maintain procedure throughout test period. Analyze test case progress and report status for system test cases. Serve as subject test matter specialist, and provide expertise for testing user requirements in complex integrated software platforms. Participate in scrum meetings designed to provide software quality assurance and quality control in a joint application team environment. Attend daily status meetings to discuss daily Scrum sprint activities and objectives. Identify and document any defects found in the documentation or software and provide appropriate problem definitions to the team coordinator. Analyze requirements and design test plans to prioritize test activities for each sprint. Analyze, document, and present test results. Discuss test results during the ready-to-deploy review. Recommend user story adjustments for future test sprints. Perform production validation after deployment. Maintain test log to document status of review for all work requests. Prepare Weekly Test Status Report and participate in Weekly Status Meetings. Prepare Project Deliverables as assigned include Pivot Tables, Test Script, Test Status Report. Maintain a project folder. Post-test file maintenance. Platform includes AGILE Development Methodology, Notepad++, SQL Developer, MQ Visual Edit, SoapUI 5.5.0, Filezilla, UnixPutty, Oracle12, TRP API, HP ALM, HP QuickTest Pro, VersionOne, TeamTrack, Informatica, Infa, ServiceNow, MS Office, HP LoadRunner, and Sharepoint.

2013-2018 SQL Tester/Software Quality Engineer, Northrop Grumman (IRS Contract - ACS and FIT - GOVT– Full BI). Perform Analysis including levels of effort and work request impact analysis. Derive requirements, test scenarios, test cases, test scripts, and determine expected results for UAT. Programs SQL queries using SQL table joins for multi-table databases to validate expected results in front and back end testing and provide reporting an test results. Define data requirements, acquire/create data, and modify data for test conditions. Maintain data integrity. Provide support to modify JCL and Schedules in Control-M in preparation for each UAT test. Provide support to the database and application conversions for systems acceptability and end-to end integration tests. Execute and/or verify database and application conversions for tests. Execute the Weekly/Daily schedules for batch processing in Control-M for each test. Provide support for testing the interfaces between internet and mainframe applications. Identify and document any changes to existing instruction manuals. Provide support and coordinate the transfer of data files to/from other external system(s), for systemic processing. Perform test for assigned Work Request(s). Participate in Output Review Activities. Maintain test log to document status of review for all work requests. Maintain a project folder. Post-test file maintenance (mainframe environment). Identify and document any defects found in the documentation or software and provide appropriate problem definitions to the team coordinator. Prepare Weekly Test Status Report and participate in Weekly Status Meetings. Prepare Project Deliverables as assigned including: End of Test Report, Documentation Review Reports, Test Plan, Work Request Analysis Reports, Staff Hour Worksheets, Lessons Learned, Post Implementation Review, WBS, Weekly Test Status Report, and Test Logs. Platform includes IBM Mainframe, FMAN, FMAN DB2, UNISYS, SDLC Methodology, AGILE Development Methodology, AGILE/Waterfall, Pegasis, RQM, EFTU, Snag-It, Jira, MS Office, Control-M, JCL, Informatica, Perl, PHP, JMF, Powershell, Drupal, 8XCMS, HP LoadRunner, IBM Rational Performance Tester, Rational Suite (RQM), Selenium, Jenkins, Javascript, JSON, JQuery, Crystal Reports, Spufi, SQL, XML, CSS, HTML5, SASS, QMF, Windows, UNIX/Linux, Sharepoint, SQL Server, and Visio. 2011-2013 Computer Systems Analyst III, 21CT, Inc. (DOL Contract GOVT – Full BI). Analyze business processes for improved business efficiency in a client-facing Federal Government environment. Strong client interaction skills. Lead requirements gathering and decompose into functional requirements. Proficient in developing wireframes, models, mockups, screens, GUI, interface design, form structures, and business use cases. Provide SME expertise on assigned system functionalities. Collaborate with client teams & offshore teams to identify and recommend system modifications for IT related projects. Liaison for analytical support to technical teams, stakeholders, and end users throughout the process; especially during issue resolution, development, and testing lifecycle phases. Updates the program’s management plan to accurately reflect percentage-of-completion, project schedule milestones, and indicate user/management participation at appropriate milestones. Generate artifacts for level of effort assessment (man-hours), functional requirements, functional design documents, training materials, and testing. Composes test plan for SIT testing, QA testing, and UAT testing including test cases, test scenarios, test scripts, test schedules, requirements traceability matrix, and status reports. Hands-on technology experience including test data setup and data creation for new products, and test execution. Lead testing activities for all participants. Manages defects from discovery thru resolution. Trains other analysts as requested. Internet platform includes SDLC Methodology, Java/J2EE, Oracle 10G, PL/SQL, AJAX, Coldfusion, HP Quality Center, Oracle, Bugzilla/Jira, SQL Server,Jquery, CMMI, and Coldbox. (www.icert.doleta.gov). Microsoft Word, Powerpoint, Visio, Excel, Project, and rest of MS Office. 2003-2011 Database Analyst, Centech Group, Inc. (CBP Contract GOVT– Full BI -CSPO) Proficient in mainframe support including security access for ACS, PRATS, PARTS, AES, COSS, TRUL, and self-serve applications. UAT Tests internet application (ACE: Sea, Rail, and Trucking). Analyzes software functionality for user guides, training manuals, and other artifacts for mainframe, desktop, and internet applications. Performs peer reviews of training manuals, user guides, and technical documents for mainframe and internet systems. Follows agency specified procedures for standards guide, peer reviews, quality assurance review, and training board review. Programs reporting in ROSCOE, mainframe training in Phoenix, and web based training in Captivate 4. Updates instructional content and selects visual components for web based training products. Task management includes work breakdown structure, task scheduling, and project status. Updates the program’s management plan to accurately reflect percentage-of- completion, project schedule milestones, and indicate user/management participation at appropriate milestones. (Client-facing, Federal government, CMMI/SDLC environment). Microsoft Word, Powerpoint, Visio, Excel, Project, and rest of MS Office. 1996-2003 Senior Systems Analyst/QA Specialist, MCI/WorldCom Performs life cycle duties in functional role in large billing system. This is a large multiple platform mainframe system with different interfaces inbound and outbound, such as e-mail, internet, other mainframe feeds, and external tapes. Primary focus is manual user acceptance testing (UAT), functional testing, volume testing, and integration testing. Composes test plan, test scenarios, test cases, test scripts, test schedules, requirements traceability matrix, defect tracking matrix, status reports, and other artifacts. Performs test data setup and data creation for non-existing data fields. Executes test cases and coordinates testing effort in team environment. Interfaces between the client, the programming staff, and offshore users. Executes tests on all levels of data from corporate to line level in large financial billing system for mass market of direct remit customers. SME for presentations, message, and icon quality assurance testing. Estimates time to complete in man-hours. Works in team effort or individually as assigned. Performs multiple tasks assignments simultaneously. Automated testing tools used as needed on test scripts, test data, test customer selection, and defect tracking; File-Aid, SQL, Snag-It, and MS Office.

1996-1996 Testing Specialist, Information Analysis Inc. -- Client -- US CBP Performs life cycle duties as assigned in functional role as tester focused on one system. Primary focus is hands-on user acceptance testing (UAT). Composes test plan, test scenarios, test cases, test scripts, test schedules, test matrices, status reports. Liaison between the user community and the programming staff.

1995-1996 Senior Systems Analyst, Tera Systems -- Client -- RTC/FDIC GOVT Provides SQL technical support for PRF and Forest & Trees Helpdesks. Completed data administration functions and compiles data dictionaries for mainframe applications. Performs manual UAT testing on new PRF software releases. Compiles application-specific training manuals, user guides, and conducts classroom training in PRF/SQL for user experience. Codes SQL programs for standard reports as requested by user groups. 1994-1995 Financial Systems Analyst, Abacus Technology Corporation --Client -- USDA Performs IV&V of systems functionality primarily on technical documentation. Analyzes and documents software functionality for financial systems that track food benefits. Composes test plan, test scenarios, test cases, test scripts, test schedules, test matrices, and status reports. Identifies defects and track thru resolution. Executes test cases and coordinates testing effort in team environment. Liaison between the user community and the programming staff. 1990-1994 Financial Systems Analyst, MCI

Performs functional JAD duties as assigned in large sales commission accounting system, fulfillment system, and marketing target mailer data extractions. Systems are large multiple platform mainframe systems with different interfaces inbound and outbound, such as e-mail, internet, other mainframe feeds, and external tapes. Leads the analysis and testing related to new products, target mailers, calling campaigns, and monthly releases from initial evaluation thru implementation. Reviews program/project initiative, analyzes alternative options for accommodating the initiative, evaluates effectiveness of selected program/project selected to accommodate the requested initiative. Gathers data on assigned program/project request, prepares options for handling request, and recommends feasible solution for request. Prepares upfront analysis and functional business requirements. Hands-on testing performed for user acceptance testing, functional testing, stress testing, volume testing, and integration testing. Composes test plan, test scenarios, test cases, test scripts, test schedules, test matrices, status reports. Performs test data setup and data creation required for testing. Executes test cases and leads testing effort in team environment. Validates data conversions during testing phase and after production implementation. Uses FOCUS, SAS, and SQL programming for validating test results, performing research, and conducting production inquiries. Liaison between the user community and the programming staff. Trains end users and analysts in new procedures. Initiates working sessions throughout product development lifecycle. Recommends control processes, cost assessments, and reporting changes to management to ensure accurate operations. Multiple tasks are assigned simultaneously. Automated testing tools used as needed on test scripts, test data, test customer selection, and problem tracking. 1989-1990 Systems Accountant, Credit Card Service Corporation Researches and analyzes corporate product/project for accuracy, efficiency, and information content. Ensures reporting is user-friendly. Performs internal control reviews of data processing, billing selects, and database maintenance. Develops audit software. Documents reconciliation processes and systems flows. Reconciles bank statements, maintains bank processor relationships, and audits all bank processor feedback. 1988-1989 Accountant, Vega Precision Laboratories

Develops, installs, and maintains accounting system software and ensures data integrity. Prepares monthly operating and financial statements, contract ceilings, and progress billings. Job cost allocations includes private, foreign, and government contracts with calculation of AER, WIP, and in-house transfers/accruals. Coordinates activities of payroll, AP, AR, and GL clerical staff. Fully responsible for operation of Sperry Univac mainframe and including data transfers. Maintains and develops all job streams including in-house databases in the following areas: Labor, Payroll, AR, AP, GL, Depreciation, Job Cost, Sick/Annual Leave, 401K, Quarterly, and Year-End.

1986-1988 Operations Controller, Guest Services

Coordinates inventory, cash reports, payroll, accounts payable and productivity for five retail units. Costs and prices promotions, special events, and new products. Prepares yearly and monthly operating budgets for each unit. Performs financial and operational audits & analyses including administration, product quality, merchandising, cash register programming, cash handling, and management efficiency. Implements new financial reporting forms and procedures; serves as liaison between corporate office and retail area. Prepares trial balance and maintains general ledger. Bills and collects receivables. Trains unit managers in administration, financial reporting, and cost control.

Education & Certifications:

1997-2002 MSBA, Strayer University

1991-1993 BS Accounting, Strayer University

1980-1985 BS Finance, Virginia Tech