Brian Kemerling
Home: 614-***-****
Cell Phone: 614-***-****
Lewis Center, Ohio 43035
Email:******@***.***
Experienced QA Tester with proven system testing resulting in high quality application delivery. Possess a unique set of quality assurance skills through all phases of software delivery. Experienced at creating and leading system test plans, execution and quality reviews with the business.
Technical Skills Summary
Tools
NCR Aloha, DevOps, JIRA, Video testing, Android testing, TFS, MS SQL Server, SSIS, SSRS, Quality Center (QC/ALM), QMF, SoapUI, WATIR, Eclipse, Pivotal Tracker, Mercury/HP Quick Test Professional (QTP), Waterfall Methodologies, Agile Scrum Methodologies.
Languages/Software:
Web application testing, Mobil Testing, Track-It, RSPEC, Cucumber, Ruby, WATIR, Janova, RSPEC, Guidewire Contact Center, Guidewire Policy Center,, QMF, DB2, Oracle, Syncsort, File-Aid, Visio, Expediter, ChangeMan, Endeavor, Abend-Aide, Intertest, Install I, Platinum, SDF II, ZEKE, HIPERSTATION, PDSMAN, Front Page and Assembler.
Operating Systems:
Microsoft Windows 7, 2000, XP, 9x,
Database Systems:
SQL, DB2, Oracle, IMS
Education: University of Central Missouri, BSBA in Computer Information Systems
Professional Experience
Bob Evans Restaurants October 2021 – July 2022
Columbus, Ohio
QA Test Lead
Created and executed tests within the NCR Aloha POS System.
Created and executed tests to be used on the website
Worked with the UAT testers in order to complete business approval for the enhancements.
Used DevOps to keep track of testing progress and defect status.
Tested the project for Single NIC
Pearson Education November 2019 – May 2021
Columbus, Ohio
UAT Test Coordinator
Creation and execution of manual test for Oracle based MDM application.
Creation and execution of manual test for Oracle based PDH application.
Helping UAT testers by creating test as guidelines for their testing purposes.
Being available to assist the UAT testers and determine if defects should be opened in JIRA.
Manual testing REVEL on Android devices to make sure the electronic textbook functioned the way it should.
Video and photograph testing of electronic textbook to make sure video and pictures were accessible and were handled correctly.
CBRE January 2019 – March 2019
Columbus, Ohio
QA Test Lead
Performing Smoke tests on the fmPilot2 application in the QA, Staging and Training regions.
Performing Regression tests on fmPilot2 application the QA, Staging and Training regions.
Working to improve the processes within the QA team.
Used TFS for keeping track of tasks and tests.
Unicon International October 2018 – December 2018
Columbus, Ohio
QA Consultant at Nationwide Insurance
Testing in an agile environment for files being generated from a Java based application that were generated on Mainframe application.
Verifying requirements for files being generated in a new Java application that were previously generated by Mainframe application.
Created excel spreadsheet in order to facilitate the compare of the files in order to identify the differences, if any.
The Judge Group September 2017 – May 2018
Westerville, Ohio
QA Consultant at JP Morgan Chase
Working on equipment and software certification testing for the Praesto project.
Created Excel macros to assist me with my testing duties.
Testing compatibility of phones with the new phone system.
Using Wire Shark and Empirix to capture and analyze phone leg information being tested.
Performing NICE phone testing for recorded phone calls.
Performing Red Box phone testing for recorded phone calls.
Defect tracking with ALM/QC.
TEKsystems May 2017 – June 2017
Dublin, Ohio
QA Consultant at Huntington Bank
Building tests from requirements documents for Hogan and EDS to be uploaded into QC.
Building requirements to be uploaded into QC.
Attended meetings with BSA’s pertaining projects.
Used TFS for keeping track of tasks, tests, defects and project release status.
Using QMF to validate or mine data for testing purposes.
PayFlex/American Health Holding/Aetna December 2011 – March - 2017
New Albany, Ohio
QA Analyst
Worked on WCAG Compliance testing .
Worked with the Tableau application in order to create and access data for the company.
Created Master Test Strategies and Test Plans for testing efforts > 40 hours.
Working with EMR and HMR records.
Mocked up credit card transactions in order to make sure the debit and credit transactions were handled properly.
Building, reviewing and executing tests for .Net applications CBAS, HealthHub, Mobile testing and HealthHub Back Office.
Worked with the developers, Business Analyst and the Business to understand the best way to test the changes.
Manual tester responsible for creating test case, updating Plan vs Actual documentation, review of peers’ test cases.
Creation of SQL queries to gather information for both validation and to gather accounts for testing purposes.
Helped coordinate the Off-shore testing effort with projects.
Backend validation using a combination of MS SQL Server and SSRS reports.
Validation of enhancements using the UI for the web-based applications.
Provide statuses of enhancement(s) being tested.
Attended meetings with BA’s and development team to understand the nature of the changes requested.
Created Comparison process to make sure that the Move to Production document matched the Track-It database.
Worked with the Application team to work and execute a test plan for the Minor and Major Releases.
Developed Excel macro by using VB scripting to format tests to be uploaded into Quality Center.
Janova July 2009 – November 2011
New Albany, Ohio
QA Test Lead
Create vanilla tests for Guidewire Contact Center, Guidewire Policy Center and chocolate tests for Guidewire Policy Center v. 7.0.
Created and executed automated tests using Cucumber, Ruby, WATIR and Janova for web based applications including Guidewire Contact Center and Guidewire Policy Center. Worked with test team to create Methods for testing purposes. Was active in all aspects of the test writing process, setting up the page information, making sure the methods were there that were needed and then writing and testing the automated tests used for the application.
Responsible for building test cases from the requirements for the enhancement or release using Pivotal Tracker.
Worked with the developers and Business Analyst to understand the best way to test the changes.
Responsible for running batch processes for regression and current iteration and reporting the results to management.
Created reporting process in order to report on success and failure of the automated tests using WATIR to report to management.
QA Test Lead for WCSI in Salt Lake City, Utah.
Bank One, Inc. June 2007 – March 2009
Columbus, Ohio
QA Tester
Responsible for building test cases from the requirements for the enhancement or release in Quality Center.
Worked with the developers to understand the best way to test the changes.
Automated tests using Quick Test Professional for web based applications.
Attended meetings on behalf of Approval Central for the Releases involved in and relayed information to management and developers as needed.
Met with Business Analysts to gather additional information for testing requirements.
Created test cases to satisfy testing requirements.
Led successful management of PTP Phase I, Password Encryption and other enhancements into production.
Waterfall methodologies were used at the bank.
Defect tracking with ALM/QC.
Bank One, Inc. April 2002 – June 2007
Columbus, Ohio
Data Analyst
Facilitated the End-to-end performance testing from the Enterprise level to make sure no performance issues were present.
Maintain ETF Environment and help resolve issues with the environment.
Developed programs and processes to help monitor DASD usage within the ETF environment
Assist in Application interviews to gather information from various applications participating in the ETF.
Performed as a contact for upgrades to the ADEV and BDEV environments.
Create ECM records for the Release Management Team for the ETF Shadow Library Refresh process.
QA Test Team Lead for the Item Capture System (ICS).
Met with BA’s to gather additional information for testing requirements.
Created test cases to satisfy testing requirements.
Led successful management of ER206 into production.
Led 2 other ICS testers for multiple release events.
Quick Solutions, Inc. November 2001 – March 2002
Columbus, Ohio
Programming Consultant
Responsible for testing ECP process for Utah and Arizona for Vector 5 including tracing through Assembler program to help determine the possible cause of a problem while testing.
Creating and testing process to split out image statements for three processing regions.
Increased efficiency of VSAM program by 33%.
Updated production run documentation.
Provided basic support.
Patrick C. Kirby & Associates May 2001 – August 2001
Columbus, Ohio
Programming Consultant
Created a regression testing process that was accessible on the Tech team web site for a conversion team.
Assisted in determining some of the conversion issues found during testing.
Limited Technology Systems August 1999 – April 2001
Columbus, Ohio
Programmer/Analyst
Responsible for Year 2000 testing and validation, system enhancements to batch and on-line programs.
Created an automated supply system that is used by over 600 stores.
Worked on package migration team building interface process to transfer information over to a Unix machine for the Arthur Allocation system.
Created download process to simplify corporate reporting by cutting down time and effort.
Independent Consultant June 1997 – August 1999
Columbus, Ohio
Consultant
Responsible for Maintenance and Development on a Customer Care system.
Worked in on-line environment in Cobol II, DB2.
Mocked up an HTML demo to mimic the on-line system.
Responsible for Year 2000 testing and coding.