Keary McCullough

Chandler, Arizona ***** 253-***-**** ad1wy2@r.postjobfree.com

QUALITY ASSURANCE LEAD

Software Testing Software Test Case Creation & Execution API & Web Service Testing

Accomplished Senior Quality Assurance Analyst, eager to leverage valuable experience testing user interfaces, application programming interfaces, APIs and back end testing with databases. Demonstrated expertise and success with QA test plans, procedures, documentation, technical writing, reporting, development life cycles, and methodologies.

Draws on 15+ years software testing expertise in regression testing, integration testing, white box testing and black box testing, as well as 11+ years of success as a Quality Assurance Lead and Analyst designing, building, and executing test cases for client server and web-based software applications deployed in Java, UNIX / Oracle and .NET / Angular environments.

Wide-ranging success delivering highly valued solutions aligned with business strategy. Excels with project planning, technical management, system integration and development testing. Thrives working proactively, under pressure in major QA environments. Adept at leading large project teams focused on high-quality deliverables.

Core Competencies

Quality Assurance & Control Data & Analytics Expert Consultations Proactive Solutions Agile Methodologies Leadership

User Interface Testing Application Programming Interfaces APIs Back End Testing Databases Functional Requirements

Business Analysis Strategic Planning Process Improvement Analyses & Reports Full Testing Scenarios Project Lifecycle

Select Qualifications

Agile/SCRUM development methodology.

Azure DevOps, Jira.

Airline experience.

Knowledge of SRP Water or flood irrigation.

Adept in collaborations with programmers and business experts.

Highly skilled in context-based, exploratory or scenario testing.

Skilled with end-to-end testing. Able to build strategy for E2E and SIT testing.

UAT lead test experience.

Working experience with SIT.

Working experience with UAT.

Working experience with ETL.

Experience with HP ALM.

15+ years of quality assurance/testing experience.

Excellent analytical, critical thinking and problem-solving skills.

High level of attention to detail with strong organizational skills.

Comprehensive knowledge of tools, concepts, and associated methodologies of QA.

Hands-on experience writing and executing test cases in accordance with acceptance criteria.

Ensures test coverage of business processes.

Supports functional workstreams in creation and review of test coverage.

Reviews and facilitates signoff of test cases and scripts for SIT (systems integration test) cycles.

Accountable for UAT preparation, execution and closure.

Point of contact for quality.

Champion of operational accountability/monitoring

UNIX experience.

Oracle and SQL Server experience.

Experience providing weekly testing status reports.

D365 CRM testing experience.

Configure, Pricing, Quote in D365.

Experience creating advanced SQL Queries.

Writes black box and GUI test cases, designing tests to mitigate risks and helping business experts define requirements.

Valuable experience with SQL and SQL Server Management Studio, as well as testing of web services.

Demonstrated ability to use discretion and make sound decisions under pressure.

Excels in self-directed, collaborative and distributed team environments.

Successfully implemented multiple projects that received Special Recognition Awards.

Career Progression

Senior QA Analyst – SRI International Phoenix, AZ Nov 2021 – Mar 2023

Project: Participant Portal, HANDS, Clinic Search, Complaint Tracking

Senior QA Analyst with SR International working with the state of Arizona Department of Health Services.

Created test plans and test cases for HANDS, Clinic Search, Complaint Tracking and Participant Portal applications and reports in DevOps.

Test plans and test cases included smoke tests and regression tests for applications. Tested upgrades for above applications on laptop using Chrome and Edge.

Tested with iPhone using Safari for Participant Portal and Clinic Search applications. Tested upgrades and production installs. Worked nights and weekends as required.

Created test plans and test cases in Azure DevOps.

Software Engineer – U.S Tech Solutions Chandler, AZ July 2021 – Oct 2021

Project: Product Support

Software Engineer with US Tech Solutions working at Intel. Supported shop floor systems used to manufacture Intel chips.

Rebooted systems remotely to install Windows and software upgrades. Used Oracle SQL Developer to find application anomalies in Oracle database. Debugged issues as needed. Worked 10:00pm to 10:00am.

Senior QA Consultant, Valore Partners, Tempe, Arizona Aug 2017 – Sep 2020

Client: Transact Campus June 2020 – Sep 2020

Project: Transact – D365

Provided expert consultations to team tasked with customizing Dynamics 365 Sales. Utilized DevOps for sprint planning, user stories and defect management for the project.

Tested modifications to Configure, Price, Quote functionality.

Successfully tested modifications to Dynamics 365 Sales. Tested software updates to Dynamics 365 CRM.

Provided weekly testing status reports.

Results: Successfully tested modifications to the Transact – D365 project, including designing and administering test cases.

Compared test results as documented in user stories; tested user stories and defects after production pushes.

Client: Salt River Project Aug 2017 – April 2020

Project: Water Pump Systems

Ensured test coverage of business processes.

Led the entire test management process.

Reported to and worked closely with the QA Manager in creating and maintaining test plans, test strategies and testing roadmaps, tracking, and reporting on testing progress, quality metrics and milestones.

Managed, directed, and coordinated SIT and UAT teams.

Mentored and guided testing teams on the creation and execution of test cases; Prioritized and assigned test responsibilities to the testing team.

Coordinated and drove test planning sessions; Drove defect management process.

Coordinated with vendor(s) to ensure testing is on track and meets the quality metrics.

Reviewed test scenarios, test cases, and test data for completeness in requirements coverage (RTM)

Trained and guided Business users through UAT; Prepared testing manuals as needed.

Managed and mitigated test/QA-related risks and issues to the program – escalated risks as needed.

Gathered, interpreted, and presented test execution metrics for socialization with steering committees.

Reviewed client requirement and provided feedback.

Reviewed and re-evaluated the test strategy to adjust for new information, changing risks, shifting priorities, and schedules.

Oversaw quality review of various applications.

Oversaw projects to make sure work is scheduled based on priorities, risks and team strengths and assignment of resources across projects.

Assisted in test environment setup/teardown, and exploratory testing.

Provided suitable solutions for issues/errors based on the understanding of the system and client business processes.

Works with clients in evaluating and implementing new technologies and offer strategies for new opportunities.

Assisted in formulating QA standards and best practices, organizational policies and processes and strategic plans.

Assisted management in setting the direction for quality assurance within the organization.

Supported functional workstreams in creation and review of test coverage.

Reviewed and facilitated signoff of test cases and scripts for SIT (systems integration test) cycles.

Accountable for UAT preparation, execution and closure.

Point of contact for quality.

Validated ETL jobs.

Champion of operational accountability/monitoring.

Execution of the defined quality assurance process and methodology to produce QA-related project deliverables such as test plans, strategies, cases, scripts, and reports.

Work with cross-functional team to test a highly performing application based on business requirements distilled into user stories.

Participate in agile ceremonies for backlog grooming, daily stand-ups, product demos, and sprint retrospectives.

Plan, design and facilitate User Acceptance Testing with end-users.

Targeted modernization of multiple outdated Visual Basic applications – Pump Audit, Pump Test, Pump Meter Read and the Well Application into one application; replaced by one application, Water Pump Systems, utilizing Angular 8.0, Kendo UI, .NET, C#, MS SQL Server 2016 and SSRS 2016 for reports, RESTful web services for APIs, and DevOps for sprint planning, as well as user stories and defect management, HP ALM, for the test case repository, and Swagger to test the API web services.

Collaborated with Business Analysts, and Subject Matter Experts to mitigate gaps in user story acceptance criteria.

Managed UAT for Water Pump Systems 1.3 and 1.5 Releases.

Implemented Water Pump Systems in production.

Provided weekly testing status reports.

Results: Successfully implemented Water Pump Systems project by designing and administering test cases in Quality Center.

Tested Water Pump Systems security authentication and Water Contract Accounting/Water Pump Systems APIs with Swagger.

Led and orchestrated User Acceptance Testing, UAT, for Release 1.3 and Release 1.5.

Created, retested, and managed bugs in DevOps and led defect meetings with Scrum Team and UAT teams.

Analyzed defects/test results and deducted chain of events leading to a failure.

Collaborated with developers to improve overall product quality by emphasizing defect prevention throughout the defect process.

Validated data on the backend via SQL queries; tested and validated API web services.

Received a Special Recognition Award for successful Water Pump Systems Release 1.0 implementation.

Project: WITS Integrated Task Force

Directed an integrated, cross-functional team of Developers, Business Analysts, Quality Assurance Analysts and Project Managers tasked with analyzing and refining the Agile processes for system integrations for broken system integrations at production release.

Successfully led a cross-functional team that analyzed and refined agile processes to proactively plan for system integrations.

Results: New refined processes significantly lowered the risk of critical production breaks and emergency releases.

Received a Special Recognition Award for successfully leading the WITS Integrated Task Force.

Project: SQL Server Upgrade

Led upgrade applications, Pump Audit. Pump Meter Read, Pump Test, Headloss, Field Measurement Services and the Well Application from SQL Server 2008 to SQL Server 2016.

Provided weekly testing status reports.

Results: Successfully implemented the SQL Server upgrade project by designing and administering test cases in Quality Center.

Created, retested, and managed bugs in HP ALM; led User Acceptance Testing, UAT.

Project: Water CRM Upgrade

Led upgrade of the Water Call Center CRM application from CRM 2013 to MS Dynamics 365, including new functionality and removing the MS Magic Shell. Created test cases in Microfocus ALM.

Results: Successfully upgraded Water CRM project from CRM 2013 to MS Dynamics 365.

Tested and validated API endpoints for Water CRM interface to Water Accounting to verify CRM to Water Accounting APIs.

Led and orchestrated User Acceptance Testing, UAT.

Tested and validated Avia phone call pop-up API integration with Water CRM.

Received a Special Recognition Award for successful implementation of the Water Call Center CRM upgrade.

Senior Quality Assurance Consultant, Tech One Staffing, Tempe, Arizona May 2015 – March 2017

Senior QA Consultant targeting Tech One Quality Assurance for American Airlines supporting Crew and Cabin Systems software applications developed with .NET and Angular. Effectively utilized Rally for user story and defect management.

Select Accomplishments:

Ensured Quality Assurance Analyst support for DOTC/RAS, Daily Open Time Coverage / Reserve Availability System using agile methodology.

Contributed to daily standup Agile Scrum meetings to provide Iteration status to project members.

Attended backlog grooming, release and sprint planning, demo meetings and iteration retrospective meetings.

Developed and executed web service tests including SOAP and Web API endpoints.

Quality Assurance Lead Consultant, Genpact, Minneapolis, MN and Scottsdale, Arizona Dec 2012 – July 2014

Lead role providing Quality Assurance support for CVS Adjudication systems on both Oracle UNIX and AS/400 mainframe system with complex interfaces. Led external QA teams and project coordination with Onshore CVS Lead QA Analyst.

Select Accomplishments:

Designed, facilitated and orchestrated test plans and test cases in HP ALM from functional specification documents, integrated design documents and use cases.

Validated data loading from source to target tables.

Created, revamped, and implemented systems quality assurance reviews for numerous applications.

Benefit Builder utilizing UNIX / Oracle and CVS Adjudication on AS/400 mainframe.

Quality Assurance Analyst, Ciber Inc., Kirkland, Washington Aug 2012 – Oct 2012

Consultant for Boeing supporting Customer Service Engineering. Delivered Quality Assurance Analyst support for Performance Metrics application in Oracle Data Warehouse using Star Schema design.

Select Accomplishments:

Utilized SQL database tools to perform SQL backend testing to validate data; validated data from ETL jobs to Oracle STAR schema.

Ensured validation of data calculations from Crystal Report output in Oracle views and tables using Oracle SQL Developer.

Designed ad hoc SQL queries in SQL Developer to verify report detail data against functional design documents.

Technical Analyst- Code Configuration, Covestic, Kirkland, WA 2009 – 2010

Consultant at Clearwire supporting Amdocs and E-commerce applications.

Select Accomplishments:

Ensured senior technical analyst and test support for complex development and pre-production application problems and provided technical and pre-production support after hours and on an on-call basis.

BOEING, Bellevue, Washington

Systems and Data Test Analyst/Quality Assurance 2005 – 2009

Key role as Senior Quality Assurance Test Analyst for functional, regression and integrated testing for complex client server software. Coordinated testing with external QA resources. Supported Non-Conformance and Online Work Instruction software.

Select Accomplishments:

Designed effective software test plans/cases, created test datasets, created test planning execution procedures, and performed tests to ensure systems meet defined acceptance criteria.

Resolved production support issues and suggest long-term fixes to the development team.

Worked closely with a team moving multiple projects from CMMI Level 2 to CMMI Level 3.

Programmer Analyst/ Lead Build Engineer 1998 - 2005

Lead role as Senior Developer and Lead Build Engineer for Manufacturing Execution Systems. Subject Matter Expert (SME) in software configuration management and software builds.

Select Accomplishments:

Provided ongoing programmer analyst and build engineering support for non-conformance management and online work instruction UNIX production systems.

Designed, programmed, built, and deployed software and Java builds to UNIX environments.

Successfully integrated and implemented non-conformance management point of use application on Windows CE Handheld device, utilizing Visual Studio .NET, .NET Compact Framework, C#, Microsoft SQL Server and UNIX technologies, e.g., Oracle, Java and Linkage, UNIX Shell.

Worked closely with a team moving multiple projects from CMMI Level 1 to CMMI Level 2 for Software Configuration Management.

Previous Roles

Customer Service Engineer, GST Telematic, Bothell, WA

Education

Bachelor of Science in Computer Science, Seattle Pacific University, Seattle, Washington

Relevant Technical Expertise

Languages/Tools: Swagger, RESTful Web Services, MS SQL Developer, Oracle SQL, MS DevOps, HP ALM, SoapUI, Rally, MS Team Foundation Server, MS Test Manager, Oracle SQL Developer, TOAD, ClearCase, ClearCase MultiSite, ClearCase for Windows, ClearQuest, UML, CIMLINC Linkage, UNIX, Bourne and Korn Shell, PuTTY, Motif, X-Windows, Hummingbird HCL Exceed, Citrix, Crystal Reports, SAP Infoview, MS Excel, MS Access, MS SharePoint, MS Visio

Databases: Microsoft SQL Server, Oracle, DB2 Universal Database Server

Methodologies: Agile, Scrum and Waterfall

Contact this candidate