Patrick Wyatt

C: 312-***-****

E: ad0w1z@r.postjobfree.com

SUMMARY

Patrick Wyatt is a Software Test Engineer with over twenty years of experience in quality assurance and software testing. Patrick has performed both manual and automated testing for client/server and web-based applications. He has worked in a variety of industries including banking, legal, energy, insurance, software, education, and manufacturing.

•Experienced in system, acceptance, validation, and web-testing

•Knowledgeable in using various automated tools for the purpose of regression testing and stress testing

•Proficient working with SilkTest, LoadRunner, and Sikuli

•Proficient working with SQL database tools like SQL Server Management, AQT, Rapid SQL, Oracle SQL Developer and Squirrel

•Strong background developing and implementing QA processes using various methodologies

•Motivated Team Player with strong drive for Customer Quality

TECHNICAL PROFICIENCIES

Operating Systems:

UNIX, Windows 7, XP, 2000, NT, 98, 95, 3.1, DOS, MS Edge

Test Management Tools:

Test Case Manager, Test Studio, HP Quality Center/ALM, and Jira

Databases

Oracle, Sybase, SQL-Server, MS Access, DB2, TOAD, SQL plus, Rapid SQL, Advance Query Tool (AQT), Squirrel SQL Client, Oracle SQL Developer

Desktop Software:

Rational ClearCase, MS Word, Microsoft Project, Excel, Power Point, Lotus Notes, SharePoint, Visual Source Safe, Microsoft Visio, Genesis, Hyperion, Thinkfolio, Charles River, Bloomberg AIM, and XIP

Browsers:

All Browsers

Programming Languages:

Visual C++, C++, C, VB Script, Visual Basic, RPG, Oracle, SQL

Methodologies:

Rational Unified Process (RUP), SCRUM, Agile, Waterfall, and Prototyping

Tools:

SILK, LoadRunner, RAID 3.5, Fiddler, SoapUI, JMeter, Bad Boy, Firebug, FIGMA, Confluence, USG Answers Business Intelligence, Appworx, webMethods, Box, Bard AI, Chat GPT

PROFESSIONAL EXPERIENCE

TEKsystems 06.23 – Present

Client: United States Gypsum Corporation 06.23 – 09.23

Role: ETL, BI Tester, Finance and HR QA analyst

Project Name: EFT, CGC Benefits Change, and Knauf Financials

Description: Although each one of these projects were different, they mostly involved data validation testing.

Responsibilities:

Planned, Developed and Executed test cases for USG Business Intelligence application to support USG HR Team. This involved:

Configuring payroll data for Canadian Union and Non-Union workers.

Ensuring the payroll calculation was correct in USG BI application.

Ensuring data was successfully updated from USG BI to Oracle

Planned and Reviewed Test results with HR Team

Performed ETL testing for USG Finance team. This involved:

Comparing data from source and target tables.

Manually ran Oracle jobs in Appworx.

Ensured all jobs ran successfully and no errors were returned.

Verified logic/transformation of data is displayed correctly in staging tables.

Ensured data was successfully loaded to the target tables.

Planned, Developed, and Executed test cases for a smaller finance project which involved:

Verifying conversion of Canadian currency to US Currency.

Reviewed all test results with Dev and Business

Created test cases in ALM

Logged issues in JIRA

Qualitest 05.07 – 12.22

Client: Louisiana Department of Education (LDOE) 05.20 - 10.22

Role: ETL Tester and QA Manager

Project Name: Edlink 360

Description: This project involved upgrading/consolidating LDOE from their legacy systems to a one stop platform.

Responsibilities:

ETL testing of EdLink 360 integrated with Hoonuit framework. This involved:

Meeting with business team to identify bad data within the legacy systems and ensure that it’s not carried over into target tables.

Ensured business rules and logic from source to staging were validated.

Compared data from source to target.

Ensured data displayed correctly and could be retrieved Using Edlink 360 BI application. This including retrieving data from all the section below:

Accountability & Assessment

Assessment and Audit Trails

Business Information and Data

Data Collection

Data Integrity

K-12 User Roles

Early Childhood User Roles

Product Owner verification of Edlink 360

Eligibility

Training/Certification

Notifications

Task Management

Workflow Strategy

Worker Portal Roles

User Portal

Mobile testing of Hoonuit Dashboard

Functional and UAT Testing of EdLink360

Planned wrote and developed test case in Jira.

Reviewed test plan with the business team.

Reviewed test results and defects with the project team.

Managed a team of three resources.

Ensured all deliverables were met on time.

Client: Consumer Credit Union 11.19 - 02.20

Role: Senior QA Analyst

Project Name: Consumers Credit Union Velocity V2019.2 Upgrade

Description: To assure the delivery of a reliable Velocity Version 2019.2 Upgrade from Velocity, the LOS system Vendor, to Credit Union.

Responsibilities:

•Planned, wrote, developed and executed manual test cases for Velocity upgraded

•Performed functional and regression testing

•Created daily defect status reports

Client: BMO Harris Bank - Global Account Management 08.17 - 08.19

Role: Functional Testing Specialist

Project Name: Project One

Description: This project consisted of replacing their current middle office infrastructure (SimCorp) with a better infrastructure (MEDM). This will allow all portfolio managers globally to get the same information in real-time as their counterparts.

Responsibilities:

•Planned, wrote, developed and executed manual test cases for US and Hong Kong release

•Provided input to Test Manager regarding test estimation

•Supported and ran regression test cases for UK, Hong Kong, Canada, and US

•Submitted test trades via Charles River Application for Hong Kong and Canada

•Ensured trade were successfully sent from Charles River to MEDM and downstream to State Street and roundtrip back to Charles River with updated positions

•Responsible for daily runbook updates

Client: ComEd 09.17 - 10.17

Role: Senior QA Analyst

Project Name: Telephony Project

Description: Provided functional testing support during UAT

Responsibilities:

•Planned, wrote, developed and executed manual test cases

•Provided input to Test Manager regarding test estimation

•Supported and ran regression test cases for all releases

•Planned, wrote, created test cases for Call Routing and Score

•Provided RTVM support in ALM

Client: Arthur J. Gallagher & Co. 05.13 - 10.17

Role: Senior QA Analyst

Project Name: CSP Project

Description: Provided functional testing support during SIT and UAT

Responsibilities:

•Planned, wrote, developed and executed manual test cases

•Provided input to Test Manager regarding test estimation

•Analyzed, tested, and documented database stored procedures

•Planned, wrote, created test data in EPIC System

•Executed backend API testing

•Ensured data process from EPIC to all downstream systems (i.e., EPIC, Staging, CSP, and Document Management System) using SQL queries

Client: BMO Harris Bank 12.08 - 10.12

Role: Test Manager

Project Name: Commercial Banking Loan Migration Project

Description: Test Manager for UAT Testing of Commercial Banking Loan Migration Project Phase 1A, CCL M&I Deposit Conversion, and MRA V5.1 to V5.4.

Responsibilities:

•Created and maintained the UAT Execution Calendar; monitor UAT test cycles and calendar status; and communicate to technical and testing resources

•Act as point of contact for all UAT teams

•Monitored UAT cycle and calendar status

•Ensured the creation of User test cases / scripts – provide hands-on assistance with tasks as needed

•Ensured traceability by ensuring UAT test scripts/results are entered by LOBs in the Traceability matrix – provided hands-on assistance with tasks as needed

•Coordinated with Risk Management and Technology team to resolve test scheduling and support issues Setup the incident reporting vehicle and process.

•Setup the incident reporting vehicle and process

•Facilitated UAT incident meetings

•Communicated UAT cycle and calendar status to technical and testing resources

•Maintained UAT testing metrics reporting

•Participated in the development of post UAT defect remediation action plans

•Participated in Approval Gateway Meetings

•Participated in Satellite Support Command Center during Harris BMO M&I conversion

•Participated as a Subject Matter Expert for Basel Model

•Train Consultants on new Basel II Models

Role: QA Analyst

Project Name: BMO Harris Bank Web Focus Reporting Applications

Description: Responsible for UAT testing of BMO Harris Bank Web Focus Reporting Applications.

Responsibilities:

•Created functional test cases

•Facilitated Test Plan and Test Case review

•Executed Test Cases

•Communicated and reported test status to key players

Role: QA Analyst

Project Name: BMO Harris Bank, Basel II (Phase II – V) Data Collection Utility Applications

Description: Responsible for functional testing of multiple Basel II models

Responsibilities:

•Test Lead for Personal Borrower, Builder Developer, General Commercial, Investor Owned and Risk Adjusted Annual Review Model (RAARP) model Applications

•Test Lead for Data Acceleration Project

•Utilized DB2 and AQT to retrieve data values from multiples tables for test data setup

•Utilized Microsoft Visual Basics for applications to develop complex macros in Excel for data validation

•Planned, wrote, developed and executed test scripts

•Organized and lead test strategy and test plan reviews

•Prepared test metrics and test status reports

•Provided support for maintenance releases

•Developed/Designed Test Models and Calculations for Basel and RAARP project

•Trained/Presented new functionality to business users

Client: Northern Trust Bank 05.07 – 11.08

Role: QA Analyst

Project Name: Personal Account Origination (PAO)

Description: Responsible for System Testing of Northern Trust, Personal Account Origination Applications.

Responsibilities:

Test Lead for Personal Account Origination Applications

Planned, wrote, developed, and executed test scripts

Organized and lead test strategy and test plan reviews

Prepared test metrics and test status reports

Researched and implemented new techniques for testing processes

Organized and lead SCRUM meetings

Provided support for maintenance releases

LexisNexis 07.02 – 05.07

Role: Software Test Analyst

Description: Responsible for API/ Infrastructure testing of LexisNexis Products and Applications.

Responsibilities:

Test Lead for Overseas Test Group (manage meetings to troubleshoot current projects)

Planned, wrote, developed, and executed automated test scripts using LoadRunner and SILK

Planned, wrote, developed, and executed manual test cases

Organized and led test strategy and test plan reviews for Infrastructure Access Layer

Supported and ran regression test cases for all Unix releases

Analyzed, tested, and documented database stored procedures

Prepared test metrics and test status reports

Research and implement new techniques for testing encryption and decryption

Performed regression testing

Backend API analyst for multiple applications

Active member of Disaster Recovery Team

Microsoft Corporation 07.00 – 07.02

Role: Software Test Analyst

Description: Responsible for testing Microsoft Licensing UI application, Clarify UI application and related integration with MS Products.

Responsibilities:

Attended the testing process reviews with the project manager and the business analyst

Logged in and tracked defects using Visual Source Safe

Developed manual test cases and test scenarios in Test Director

Attached snapshots to test cases in Test Director

Performed ad hoc, sanity. integration, system, regression, and end to end testing for the Microsoft and Clarify front end application

Communicated with developers and analysts regarding the status of programs (i.e.

ensured that all reported bugs had been fixed)

Performed back-end testing with PSS Warehouse team

EDUCATION

University of Phoenix

B.S. Business Management

CERTIFICATIONS AND TRAININGS

•Microsoft: API testing

•SQL Server 2000 Design and Implementation

•How to be an Expert Tester

•Working Effectively with India

•How to Become a Better Communicator

•Negotiating to Yes

•Automation 101

Contact this candidate