Quality Assurance Business Analyst

Christopher J. Newell

*** ******* ****

Monroeville, Pa. 15146

412-***-**** (c)

mail to: ***********.**********@*****.***

OBJECTIVE

Seeking a challenging position that capitalizes on my extensive background in all areas of the Software Development Life Cycle process in both windows-based and web-based environments as well as my gained experience in project management, software development, quality assurance, business analyst, and software testing.

SUMMARY

- Thorough knowledge and extensive experience of all phases that exist in the Software Development Life Cycle process.

- 20+ years of SDLC experience including 6 years software development in both procedural and object oriented languages, 4+

years business analysis experience, 15 years manual testing experience and 4+ years of experience in automated testing.

- Extensive experience in developing test plans, test cases, traceability matrices and establishing test environments

- Extensive experience in business, functional, and non-functional requirements analysis, definition, and development

- Strong knowledge and experience of application development in numerous industries including Retail, Financial, Logistics,

Healthcare, Medical and Insurance industries

- Extensive experience in multiple test methodologies such as Waterfall, Joint Application Development, Rational Unified Process,

Agile, Scrum

- Vast testing experience including Unit, Functional, UI, System, Integration, Workflow, UAT, Alpha, Beta, Gamma, Smoke, Stress,

Performance, Load (Volume), Boundary, Object, Recovery, Security, Positive, Negative, Sanity, parallel, Pilot, Regression &

User Acceptance Testing

- Thorough SQL and data access method/utilities experience across multiple platforms including DB2, Teradata, Oracle, SQL Server,

Vertica and Access databases.

- Strong analytical, problem-solving, defect analysis skills using multiple defect tracking tools including Mercury, Rational, and

multiple proprietary products

- Strong analytical skills using multiple requirements management tools including Altissan, HP, Mercury, Rational, Seapine,

enterprise-level, mid- market and open-source products

WORK EXPERIENCE

Vapotherm, Inc. December 2021 – Present

Senior Quality Assurance Engineer

- Lead and build an independent software verification and validation capability to ensure product quality and continuous improvement

- Develop verification test plans and protocols for Vapotherm HVT 2.0 Linux-based embedded medical device

- Conduct formal verification testing and document results adhering to Vapotherm good documentation practices

- Author verification and validation reports to be used for regulatory submissions

- Select and deploy automated test tools to be used for both formal verification testing and regression testing

- Conduct/manage ad hoc testing and bug discovery activity

- Collaborate with software developers on requirements definition and management and integration testing of new features and

incremental changes and bug fixes

- Author or update Standard Operating Procedures for SQA development functions

- Participated in project design reviews, development code reviews and software protocol peer reviews

- Participate in Software Risk Management activities

- Sole SQA resource on a software team of seven developers and provided SQA support for one formal limited market release, three

full market releases and one maintenance release in 2022.

- Sole SQA resource for a formal full market release which included a medical device software release to 14 additional countries

- Sole SQA resource for proof of concept release to three hospitals which included incorporating embedded wireless capability of the

HVT 2.0 medical device.

- SQA lead on data migration of all HVT 2.0 documentation from Sharepoint to Polarion QA quality management system tool.

Performed imports of all documentation as well as configuration of all project work items with the tooil.

Kelly Mitchell Group, LLC. April 2021 – October 2021 (Huntington Bancshares, Inc. – Contractor)

Senior Quality Assurance Analyst/Business Systems Test Analyst

- Managed all User Acceptance Testing (UAT) activities of seven applications for a large scale commercial data conversion project

during the merger and acquisition of TCF into Huntington Bancshares. Ensured all customer data migrated correctly, all business

rules defined were adhered to as well as validated all customer data migrated correctly to all digital (business online) applications.

This also included the verification of all business admin access/privileges migrated correctly from TCF workspace to Huntington

- Managed the migration of all Huntington test assets from HP ALM Quality Center (v12) application to Azure DevOps (ADO)

Server (v. Dev18.M170.8). Once migrated, performed all necessary gap analysis to identify all business test assets to be leveraged

for existing, ongoing conversion project.

- Managed the authoring of all applications’ Business Test Strategy document. This test plan defined all in-scope business testing, the

UAT test schedule, all impacted integrated applications as well as all resources, dependencies, constraints and risks.

- Managed the business resources correctly authored test cases based upon detailed business user requirements clearly defined in the

the Business Test Strategy document.

- Managed each applications business UAT test team’s ADO Server tool activity. This included creating Test Plans in ADO used by

each application’s business team for user acceptance test execution, providing a dashboard for each application’s team to view which

captured, test suite information, execution status as well as overall project metrics in regards to UAT execution. Additional tasks

were overseeing the adding all test cases into ADO Server tool, ensuring business teams correctly executed test cases and logged

bugs correctly. Trained the application business teams on test case execution, defect management, and linking all work items

correctly in order to provide easier metrics reporting and test asset traceability.

- Oversees the tracking of quality assurance metrics such as defect density and open defect counts. Oversees team members

responsible for testing and inspection of products to determine compliance with specifications

- Participated in bi-weekly defect triage meetings to ensure all defect classifications such as severity, priority, etc., were properly

assigned. Assigned all defects to the proper resources based on defect classifications as well as time allocations or resource

constraints identified. The defect triage process greatly reduced the lifecycle of all defects

- Provided test execution status to project management. This occurred daily and included the percentage rate of passed/failed/blocked

UAT test case execution as well as all defects not in a closed or rejected status, with focus on those with critical or high severity in

order to adhere to the defined SLA. Blocked test cases included the mandatory cause and expected resolution, once again as deemed

by the defined SLA.

Beacon Hill Staffing, Inc. September 2020 – January 2021

(Rue21, Inc. – Contractor)

Quality Assurance Tester

- Assisted business users in the User Acceptance Testing (UAT) for the major release of the Rue21.com website

- UI test lead for all content management, product list and product display pages as well as all product category hierarchies. Ensured

that all available products with inventory were being displayed. Inventory levels were verified and manipulated via TOAD Oracle

database tool (v11).

- Provided test support across multiple operating systems on both mobile and desktop devices including Android, iOS, Windows and

Mac, as well as providing test support for multiple browsers, i.e. Chrome, Edge, IE, Safari, Firefox, Opera and Yandex

- Performed extensive data setup for multiple test scenarios via TOAD Oracle database tool (v11). Data setup included providing

sufficient money balances for different methods of payment for testing which included Rue21 gift cards, multiple credit card types,

etc.

- Assisted business users in the verification of the Rue21 Rewards program. Testing included verifying the proper threshold was met

before applying rewards to an account. Testing also included ensuring applied reward(s) for a given placed order adjusted order total

correctly. Extensive boundary testing was also performed to ensure the minimum and maximum number of rewards guideline was

being adhered to.

- Assisted business users in testing website promotions to ensure that promotion rules were being applied correctly.

- Reported quality metrics daily to evaluate progress of UAT.

- Logged and tracked issues found in a Google Share spreadsheet. It was determined during the triage process if issues were actual

defects, non-duplicates, etc. Once determined to be an actual defect, the issues were the further triaged to apply correct priority,

severity, etc., and then logged into a tracked in Atlissian JIRA tool (version 7.9.2) to effectively communicate concise details

TTI USA, Inc. August 2019 – September 2020

(BNY - Mellon, Inc. – Contractor)

Quality Assurance Lead

- QA Lead for the Enterprise Data Structure (EDS) team. The EDS QA team is the sole team responsible for all testing activities for a

large ETL project, which involved the onboarding of new lines of business (source) data files as well as ensuring the data files were

offboarded to the customers (consumer) successfully.

- Validated all source file template requirements provided by the business data team against the files constructed in the

proprietary Self Provisioning Tool (SPT) application. Validation included ensuring all file delivery schedule information is correct as

per the defined schedule. Standard licensing agreement was verified to ensure the file is being delivered at the correct time of day,

the correct EDS file and the correct Vertica tables are being used in the ETL process, as well as other critical information. These

were validated via the use of Oracle queries in the Oracle SQL Developer application (version 19.1.0.094) and then comparing the

query results to the data that existed in the SPT application as well as the same data in the proprietary Metadata Browser tool

- Validated all field definition requirements. Verified that the data element names, field types and lengths existed in the SPT

application and Metadata Browser tools as per defined.

- Processed all source files in the lower test regions in a proprietary EDS Web Browser tool. Files were provided by the source data

team. File processing injected the file data into the Vertica tables.

- Debugged problems via monitoring log files during errors encountered during file processing. Problems were resolved by analyzing

the specific data in the error log files.

- Authored and executed Vertica queries in the DB Visualizer tool (version 10.0.7). Queries returned specific file data for the source

data team to analyze. Provided the query results in Microsoft Excel format. The source data team then provided sign off in the

applicable region.

- Submitted all work requests in the Atlissian JIRA tool (version 7.9.2). This included all requests for workflow promotion from the

lower test regions to the next, data team support requests, i.e. loading production files in the UAT region and masking of sensitive

data in production files to use in UAT. JIRA was also used to provide the SDLC Evidence issue for each release. This issue type

included all pertinent release information such as the lead points of contact for each department, links to the EDS QA test plan,

release test results, etc.

- Met with the project managers weekly to discuss source onboarding status as well as monthly to discuss release scope.

- Authored and maintained all EDS QA documentation for monthly releases to include test plans, test results, as needed ad hoc

status reports as well as consolidate all Vertica queries into a single document which was provided to the release manager at the end

of a given release on the release Sharepoint site.

- Authored and maintained all EDS QA training/support documentation which consisted of specific process documentation, test case

and test plan templates and a supporting SQL query library document which contained all queries used to validate data in the Oracle

and Vertica databases.

- Managed two EDS QA resources. Assigned work to each resource for each monthly release. Conducted daily stand-up Webex

meetings for status reporting purposes.

- Performed peer reviews on the EDS QA resources work, SQL queries, test cases and test plans.

Tailored Management, Inc. December 2018 – July 2019

(York RSG, Inc. – Contractor)

Senior Quality Assurance Analyst

- QA Lead for Service Link Plus (SLP) application. SLP is a large claims administration tool used by claims professionals for

the purpose of leveraging large amounts of data quickly, across numerous lines of liability, in order to

close claims efficiently. The SLP application included a complex rules engine where business rules could be created and

applied to the medical bills associated with claims. Complex business rules were defined, classified according to the specific

jurisdiction state.

- During agile development, represented SLP QA and participated in all sprint planning, review, retrospective meetings,

and story grooming sessions to provide QA time estimates, story points, as well as identify any resource constraints early in

the sprint development life cycle. Sprints occurred on a bi-weekly basis.

- Managed and conducted the testing for all SLP user stories created in JIRA 7.12.13 issue tracking management tool. Once

SLP user stories were updated to Ready for QA status, authored and executed all functional test cases needed for user story

sign-off to occur.

- Authored granular, specific test cases, test plans, test runs in TestRail 5.6.0.3865 web based test management tool. All test

cases were linked to the associated JIRA user story to provide traceability.

- Created customized reports in TestRail to better manage, track and organize testing efforts.

- Created all test data needed for all test scenarios in SQLyog 12.2.4 MySQL administration tool. Had full DML access to

the QA environment in order to quickly create or manipulate data for faster test turnaround. This tool was also used for

database verification during test execution.

- Conducted sign-off review meetings which were attended by all appropriate business analyst, development, and QA

stakeholders. The purpose of this meeting was to demo how all functional user stories in Sign-off status were tested to ensure

all business requirements were met. These demos were recorded sessions which were archived for future use. Once user stories

were signed off by the business analyst, these recordings were leveraged by the business in order to assist in user acceptance

testing.

- Defined and implemented traditional QA processes, documentation, i.e. scheduling, conducting peer reviews of all test assets

created, authoring complete SLP sprint and release lifecycle processes and formal SLP QA smoke test case which was

executed at the conclusion of each bi-weekly sprint or monthly release cycle.

- Used Confluence 6.12.1 collaboration software tool to drive continuous improvement of collaboration between the SLP QA,

development, business analyst, and management teams. This was achieved via sharing of knowledge, files, specifications

mockups, data flow diagrams, etc.

Randstad Professionals, Inc. March 2017 – December 2018

(PNC, Inc. – Contractor)

Business Systems Analyst

- Member of the Multi-channel Appointment Setting business systems analyst (MCASBA) team providing support onboarding

lines of retail business into PNC’s Genesis tool, a large Siebel CRM application, as well perform daily support tasks to either

resolve production issues, or satisfy field resource configuration changes

- During waterfall development managed the development and maintenance of functional and non-functional requirements

based upon review of detailed business requirements developed by internal business team

- Conducted regular functional requirement review sessions with all stakeholders including line of business leads and business

systems analyst, development and quality assurance teams. These sessions concluded with formal sign off of

approval by the business & development leads.

- Participated in design specification review sessions to ensure clarity of design and functional scope.

- Managed the import process of all functional amd non-functional requirements into HP ALM which included consolidating all

requirements into Microsoft Excel and importing them into the appropriate HP ALM project folder via HP ALM Excel Add-

on utility as well as authoring the step-by-step import process documentation.

- During agile development, authored user stories in VersionOne application across multiple development sprints based upon

detailed discussions with line of business leads and internal business systems analyst team story grooming sessions. Updated

stories status in VersionOne when formal approval was given by the business & development leads.

- Assisted the quality assurance team in manual testing in HP ALM application during current development sprint

- Set up and executed daily queries in both Genesis and Timetrade, a third party vendor application, to capture all

appointments scheduled the previous day. Both lists of appointments were exported into Excel spreadsheets and reconciled via

the Microsoft Excel VLOOKUP function to identify scheduled appointments that were missing in Genesis application.

Missing appointments were then sent to Timetrade for the purpose of reloading them into Genesis.

- Managed the file import ETL process. This included monitoring the import of all user, resource, and location data on either a

daily (deltas) or monthly (full) basis, setting up rules in Microsoft Outlook to capture file import errors, working with the

Timetrade support team to resolve those errors, and documenting the ETL file import process via the creation of a data flow

diagram in Microsoft Visio as well as authoring a step-by-step process document used to assist resolving commonly occurring

file import errors.

- Performed daily field resource account maintenance including the initial setup in both Genesis and Timetrade, as well as

granting specific level of access, access to specific branch locations, etc.

- Managed the creation and maintenance of all MCASBA process documentation. All process documentation was authored and

maintained on a created Sharepoint team site to which access was then granted to all appropriate stakeholders.

- Assisted in user acceptance testing with business, development, and quality assurance representatives prior to each monthly

release.

- Provided verification and validation support for monthly releases which occurred one weekend each month on Saturday

evenings and Sunday mornings.

- Assisted PNC’s MCAS support team with resolution of production incidents logged in ServiceNow application in order to

provide quicker turn around, faster resolution times.

Computer Enterprises, Inc. September 2016 – January 2017

(Industrial Scientific, Inc. – Contractor)

Senior Quality Assurance Analyst/Business Analyst

- Assisted in the management of all test activities for 44 Industrial Scientific internal web-based and windows-based

applications to include embedded systems functional and integration testing for eight main gas detection instruments and their

associating docking stations and accessories.

- Managed the requirements gathering process for 44 Industrial Scientific internal web-based and windows-based applications

to include requirements identification, definition, as well as the authoring of all requirements documentation from the given

functional specifications and design documentation.

- Authored the formal software quality assurance process that was applied to each internal application

release. The process was a defined step-by-step instruction to be implemented by the internal application test team personnel

located both onsite and offshore.

- Managed the development and maintenance of all test cases in web-based JAMA 8.8 tool, including new feature functional

as well as regression test cases to keep current as new enhancements are introduced.

- Managed the development and maintenance of all functional requirements in web-based JAMA 8.8 tool, based upon review of

detailed functional specifications developed by internal development team

- Assisted in establishing, revising and verifying quality standards, processes, and procedures including internal peer-review

and formal functional specification reviews, QA test case reviews, defining test case authoring standards, a defect triage

process, the creation of test case and test plan templates to be used across the multiple SQA teams, as well as standards for

metrics reporting and test summary reports

- Develop test plans & detailed test cases from functional product requirements and design specification documents to ensure

testing adheres to established company processes. This includes developing manual and regression, functional, GUI test cases

- Executed manual tests, report execution results, and attest to the quality of enhancement or defect fix implementation

- Executed integration tests within the ISC Internal Applications infrastructure.

- Managed the setup and maintained configuration of multiple test environments.

- Managed the setup of adequate test data and ensured the verification of successful test execution via Microsoft SQL Server

2012

- Report identified defects in either the software, or documentation using web-based JIRA defect-tracking tool.

Ciber, Inc. March 2016 – September 2016

(Copernicus Group, Inc. – Contractor)

Senior Quality Assurance Analyst

- Participated in daily requirements definition/analysis meeting with the project business analysts to identify and resolve potential gaps

in business support of application functionality. Recommended requirement changes to include expansion of given requirements or

elimination of identified requirement redundancy to ensure optimal development and test approach/coverage.

- Authored functional, UI, system, and integration test cases to include both positive and negative test methodologies. Test cases were

derived from gathered requirements defined by the project business unit

- Integral partner in the testing for WCG’s integrated paperless document management web portal application used by the institutional

review board (IRB) industry which captures and manages every phase of IRB documentation, as well as a tracking/audit database

and e-document repository.

- Performed formal functional, UI, system, and integration test case execution and tracked manual execution time and individual test

case execution status for each test iteration via Seapine ALM Test Track application.

- Participated in an informal test asset peer reviews as well as formal QA review of test assets to be used in the functional, UI, system,

and integration test phases of the iterative SDLC.

- Wrote/executed SQL queries in SQL Server 2012 to set up adequate test data and to verify successful expected results of authored

test cases.

Pyramid Consulting Group September 2015 – December 2015

(PNC, Inc. – Contractor)

Senior Quality Assurance Analyst

- Assist in the application development for PNC’s electronic data interchange (EDI) for all data within their healthcare insurance

application which exists for payers, providers, and payees. Primary responsibility is to ensure the correct migration of data from

individual payers’/providers’ proprietary applications to the payees’ in accordance to industry EDI standards.

- Manage test case execution and track manual execution time and individual test case execution status for each test sprint

with HP Quality Center & HP Application Lifecycle Management and JIRA application tools. Application development was done in

an Agile scrum environment. Sprints were managed in two-week increments.

- Manage all daily agile scrum tasks assigned with JIRA application tool. Document all task hours allocated, logged and remaining.

These metrics were tracked and discussed during daily agile scrum meetings

- Testing includes functional, UI, system, integration, user trial, and acceptance testing.

- Author/manage test plans to include/address test methodology, detailed test procedures, identification and integration of test

resources, data collection, trans/post-test analysis of results. Individual test plans authored by review of feature design specifications,

mock-ups, and wireframes included in JIRA storylines.

- Manage all defect reporting and tracking within HP Quality Center & HP Application Lifecycle Management applications. Provide

traceability for all defects reported. Provide metrics reporting for each test iteration based upon various classifications of defects

Progressive Systems Consulting/Vendor Pass December 2013 – September 2015

(Philips-Respironics Inc. - Contractor)

Senior Quality Assurance Analyst

- UI Test Lead for Phillips new Dreamstation medical CPAP device.Ensured proper display, transfer and storage of device compliance

data which was periodically downloaded via SD Card or Bluetooth.

- Manage test case execution and track manual execution time and individual test case execution status for each test iteration

with HP Quality Center & HP Application Lifecycle Management and JIRA application tools.

- Assisted in the functional requirements definition/gathering process. Provided complete traceabilty of business requirements to

functional test cases via gap analysis performed in initial design phase of SDLC

- Perform manual test case execution including development of plans to test embedded software on medical devices.

- Perform automated testing of all navigation though all device LED display screens via scripting hexadecimal commands within a

Phillips proprietary automation tool

Testing includes functional, UI, system, integration, user trial, and acceptance testing.

- Test execution in accordance with defined test plans; near-real-time quantitative/qualitative analysis of test results during and

immediately after test execution; interpretation of test results and communication of resulting information to all team testers,

developers, and senior program leadership; providing test documentation, to include architecture, problems/lessons learned, and

results versus objectives.

- Author/manage test plans to include/address test methodology, detailed test procedures, identification and integration of test

resources, data collection, trans/post-test analysis of results.

- Manage and maintain all supporting test documentation via Visual Source Safe source control software

- Manage and maintain all supporting software development documentation via IBM Rational DOORS requirements management

application

- Manage all defect reporting and tracking within HP Quality Center & HP Application Lifecycle Management applications. Provide

traceability for all defects reported. Provide metrics reporting for each test iteration based upon various classifications of defects

-Manage all daily agile scrum tasks assigned with JIRA application tool. Document all task hours allocated, logged and remaining.

These metrics were tracked and discussed during daily agile scrum meetings

Pyramid Consulting Group Pittsburgh, PA September 2013 – November 2013

(GENCO, Inc. Contractor)

QA Analyst

- Tested COGNOS reporting to include testing report formats and migration/conversion of report data to ensure successful conversion

of an old reporting application to the new.

- Tested all internal defects in the test databases prior to assigning defects to UAT for further testing and closing of issues. Maintained

test database. Activities included the managing of test data in multiple Oracle 11.1 test databases to include all data access, staging,

and manipulation of test data via SQL scripting using TOAD 11.6 application.

- All testing was executed using formal test cases authored by each tester using GENCO test case templates to provide uniformity. - All test results and test metrics were reported using standard GENCO test log results templates to provide uniformity.

General Dynamics Pittsburgh, PA July 2010 – August 2013

Senior Quality Analyst

- Performed/managed test activities for various projects across multiple platforms, and in parallel software development tracks. Test

activities included projects in both a traditional iterative and agile development processes for Java application.

- Tracked all test activities from concept to completion during agile development process in Rational Team Concert application tool.

- Manage test case execution with Rational Quality Manager application tool. Track manual execution time and individual test case

execution status for each test iteration/sprint via Rational Quality Manager.

- Perform manual test case execution including development of plans to test software-intensive system in various multi-system venues.

Testing includes functional, GUI, system, integration and acceptance testing.

- Test execution in accordance with defined test plans; near-real-time quantitative/qualitative analysis of test results during and

immediately after test execution; interpretation of test results and communication of resulting information to all team testers,

developers, and senior program leadership; providing test documentation, to include architecture, problems/lessons learned, and

results versus objectives.

- Author/

Contact this candidate