David Frazier

Rowlett, TX *****

469-***-**** (Cell)

ac8xna@r.postjobfree.com

ac8xna@r.postjobfree.com

SENIOR QUALITY ASSURANCE

TEST ANALYST

Offers more than Twenty Years of Quality Assurance Software Testing experience, along with Test Case Preparation, Execution and Defect Reporting. Experience includes project management and business analyst in planning and management of technology projects.

Technical Skills

Lotus Notes Version 5.7.3, Lotus 123, Excel, Microsoft Word, Groupwise Mailing Systems, CCC/Harvest, Mercury Winrunner Training, BugZilla, Rational ClearQuest, TestDirector 7.0, Softlanding Turnover Software, CICS, MICS, Compucell, Macrocell, TSO, Unix HP, PC X-Ware, SQL, AMDOCS-Telegence Billing System, AS400 Model 620, Microsoft SQL Server 6.5, Microsoft SQL Enterprise Manager, TFS-Team Foundation Server 2012, CBP-Convergent Billing Platform, Saville Systems, Siebel 99 version 5.5 and 5.6 Order Entry System, Kenan/Arbor Billing Platforms 8.1 and 9.1, Siebel Test eEnergy 2000 6.3, SPL Worldgroup Cordaptix V1.3.20, Vitria (MiddleWare), IPS-Integrated Provisioning System, TBS-Metasolve, WinSCP3, Putty, Squirrel Oracle, and CSI Atlas Middleware.

PROFESSIONAL EXPERIENCE

SONIC HEALTHCARE USA-Richardson, TX

April 2016 – February 2019

Title: SR BA/QA Test Analyst

ESSENTIAL JOB FUNCTIONS:

Tested the LabIS (Lab Information System) for the Clinical Pathology Industry.

Wrote Test Cases and performed System Testing for the (Misys) Legacy Lab System.

Participate in the design, testing and documentation of the AP LabIS application, which includes upgrades, enhancements and hot fixes, to thoroughly understand business needs and ensure comprehensive testing scenarios are documented.

Develop, maintain and execute test cases, ensuring the quality and stability of the system throughout the project. Testing of projects is to be in accordance with written business and functional design documents and following established standards.

Responsible for delivering assignments within specified time frames, adhering to all established methodologies, standards and guidelines individually or as a member of a project team.

Report, monitor and verify application project defects, as necessary. Ensure that defects in the software products have been corrected and document results of testing using SmartBear QA Complete defect tracking tool.

Provide ownership and accountability for assigned testing, keeping supervisor aware of progress and risks.

Document testing and technical applications to maximize user understanding.

Create and maintain regular status reports to immediate Team Lead or Manager.

Work independently with users to define concepts and fundamental functional requirements.

Verified HL7 messages against the Technical Specification document for accuracy

Critically evaluate all information gathered and compose it into a detailed specification for developer use and client sign-off.

Successfully engage in multiple initiatives simultaneously.

Used MySQL Workbench 6.3 to verify data in the tables

Used Agile Testing Methodology

EXCENTUS-Addison, TX

November 2015 – March 2016

Title: Contract – QA Test Analyst

ESSENTIAL JOB FUNCTIONS:

Perform Web testing using SOAP SmartBear UI 5.2.1 and REST API in the JSON format and verified that the XML messages updated in the Administration Portal

Participate and provide input in user stories estimation and technical design review meetings.

Develop and document test strategy for sprints.

Develop, maintain, and execute manual test cases from the User Stories

Identify, analyze, and report test results.

Used Putty to tail the logs for SOAP and REST messages and verify no exceptions in the logs

Used SQL Developer to verify data in the tables

Develop, maintain, and update test criteria and test cases via black box testing module

Used Agile and Kanban Methodology

Rally was used to house test cases and track defects

Used Postman to send the API request and responses

HEALTHFITNESS-Richardson, TX

September 2014 – July 2015

Title: Contract – BA/QA Test Analyst

ESSENTIAL JOB FUNCTIONS:

Support all internal and external clients on requirements, including client meetings.

Translate business requirements into technical and functional requirements.

Develop, maintain, and update test criteria and test cases via black box testing module, documented and presented test results to Management.

Execute test scripts, document and present test results for projects and document test issues using BugZilla.

Perform data analysis using various technologies to support creation of the documentation or to respond to inquiries from teams.

Work as liaison between internal development team on operational and technical file issues.

Complete all scoped deliverables by mutually agreed upon delivery dates based on data communication plans with internal and external customer.

Use TFS (Team Foundation Server 2012) to proactively identify and facilitate resolution of issues affecting timeline or quality of deliverables.

Troubleshoots process and technical problems externally/internally for vendors and customer service representatives.

Conducted UAT for the end client which entailed writing testcases, executing testcases, system testing and uncovering defects found while performing UAT.

ABBOTT LABORATORIES-Irving, TX

March 2014 – September 2014

Title: Contract - Software Test Engineer

ESSENTIAL JOB FUNCTIONS:

Used Agile Methodology, responsible for verification and validation of integrated modules that included testing of functional software, embedded software, UI testing on the device simulator, and instrument testing in the lab.

Planning and development of lifecycle documentation for Test protocols (IQ/OQ/PQ), requirements, functional specifications, test plans, and traceability.

Additional duties included: test setup and execution, defect tracking, writing test reports, white box, black box and debug testing, as well as worked closely with the company software development team to ensure correct software and hardware functionality.

Understanding of regulatory verification (non-software verification), validation CAPA, and completed internal audit training for business and compliance purposes.

Created the JavaScript oriented log files for the experiment on instrument and simulator to do testing on features.

Created the data table by using the configuration data editor tool.

Created the test plan on word document, and created the test cases in Quality Center and execute in the simulator, logging the defects in the Jira.

Updated the new builds from the Bamboo and run smoke test.

Involved in acceptance, black box and ad-hoc testing on EP and VP phase by using the simulator and instrument.

Wrote automated test cases in QTP and integrated them in QC.

Used Excel to perform the data parameterization on QTP.

Environment: HP-QC, Doors-IBM, JIRA, KANBAN, BAMBOO, Agile Scrum, XML, HTML, Oracle, MS- Office, and Data editor tool.

HEALTHFITNESS-Richardson, TX

June 2012 – March 2014

Title: Contract – BA/QA Test Analyst

ESSENTIAL JOB FUNCTIONS:

Supported all internal and external clients on requirements, including client meetings.

Translated business requirements into technical and business functional requirements.

Develop, maintain, and updated test criteria and test cases, as well as execute test scripts, and system testing via black box testing module, documented and presented test results to Management.

Documented test issues using BugZilla.

Performed data analysis using various technologies to support creation of the documentation or to respond to inquiries from teams.

Work as liaison between internal development team on operational and technical file issues.

Completed all scoped deliverables by mutually agreed upon delivery dates based on data communication plans with internal and external customer.

Identify and facilitated resolution of issues affecting timeline or quality of deliverables.

Troubleshoot process and technical problems externally/internally for vendors and customer service representatives.

Conducted UAT for the end client which entailed writing testcases, executing testcases, system testing and uncovering defects found while performing UAT.

AMERIPATH/QUEST DIAGNOSTICS-Addison, TX

August 2006 – June 2012

Title: Test Lead/Cognos Reporting

ESSENTIAL JOB FUNCTIONS:

Tested the LIS (Lab Information System) for the Pathology Industry.

Led the LIS Quarterly releases which consisted of writing test plans and test scenarios via black box models created test assignments, defect tracking, conducting Release Health Check meetings between the Test Team, Development Team and Business Analyst to discuss the health of the release before production deployment, and reporting the status to management.

Test Cognos Reports using the RCL GUI and validated against the Lab Information System data input.

Validated technical specifications against the Lab Information System and Cognos Report Central application.

Documented any defects found while executing test cases using HP Quality Center 9.2.

Validated HL7 against the technical specification for the Cancer Registry Center.

Gathered business requirements from the Business and developed test scenarios using those requirements.

Validated the functional requirements against the technical requirement for discrepancies.

CINGULAR WIRELESS-Richardson, TX

May 2005 – August 2006

Title: Contract - Quality Assurance Engineer/Middleware Tester

ESSENTIAL JOB FUNCTIONS:

Tested the TIBCO Hawk CSI Atlas Middleware application for the Wireless Telecommunication Industry.

Create and monitored the messages, which were XML files using SOAP Client or Unix, sent from the Middleware System to downstream Billing Systems.

Checked the log files to determine if the message Published successfully or failed in the Billing System.

Verified JMS Gateway, EMS Server, CSI_BW, CARE and TLG log files.

Wrote test plans from business requirements and design documents for Atlas Middleware.

Updated test scripts and verified XSD to XML Data for consistency.

Wrote and executed test cases, and reported any defects via in-house reporting tools such as Jack Track, CAM and SOD ticket trackers.

Tested new functionality and regression testing the Atlas Middleware version 8.5, 8.5.1, 8.6,8.6.2 and 9.0 using the following tools: Junit for testing Atlas outbound transactions, TLG Test Tool for simulating Telegence outbound test, Unix for viewing log files, Vi Editor, WinSCP3 for editing the CARE and TLG files, Softerra LDAP Browser 2.6 for viewing updates from the CARE or TLG Billing Systems, Oracle CVD updates the Enterprise Oracle Database that a subscriber has migrated from AWE to Cingular, SOAP XML Client for testing Atlas Inbound transactions, and Putty was used to run and edit the Junit properties files.

ALLIANCE DATA SYSTEMS-Richardson, TX

February 2003 – May 2005

Title: Quality Assurance Engineer

ESSENTIAL JOB FUNCTIONS:

Tested an in-house Java Web-based application for a provider of retail transaction services.

Performed Web testing using the business requirements and design documents for functionality verifying that the Web is functioning as designed, and easily accessible by the user; Navigation verifying that the user is able to go from screen to screen without any delays or problems; Performance making sure that the screen opened in an adequate amount of time with one or more users accessing the same record or link; and consistently verifying that each web page was consistent from page to page including font sizes and colors; link testing verifying there are no broken links on the web page; and verifying the web layout for spelling mistakes.

Create, validate, and system testing EDI ANSI ASC X12 Version 4010 transactions for the various utility clients which are governed by ERCOT transaction files for the Texas Set 2.0 implementation.

814_01, 814_16, 814_05, 867’s, 810, and 820 EDI transactions via OTS (Online Transaction System) to run test data in the user acceptance-testing environment to simulate the production database.

Wrote test plans from business requirement documents using the UTVM (Unified Testing Validation Methodology.)

Wrote test CASES, and reported any defects via in-house reporting tools.

Verified inbound and outbound map translation by Gentran for EDI flat files, and compared XMD to XML for accuracy.

Conducted system testing of the Service Center, a GUI application for Direct Energy used to house the Customer’s information.

Queried Oracle database using Toad SQL to validate data.

System testing issues which failed in production, would pull the production data, recreate the issue in a QA environment, request the developer to create a release build with the fix, upload the release build into QA environment using CVS, a version control system, and retest the issue for a failed or passed rating.

Participated in status meetings, maintained the test activity log, reported status, and updated the test schedule as required.

Updated test conditions, scripts and data as required.

XO COMMUICATION-Plano, TX

December 2002 – February 2003

Title: Contract - Integration Test Engineer

ESSENTIAL JOB FUNCTIONS:

Created end to end data product test scenarios and test cases in Siebel 99 5.6 Order Entry System.

Validate and provisioned the order in TBS-Metasolve.

Accessed the AS400 GUI verified that the products and offers provisioned in TBS-Metasolve flowed to the Saville Billing System.

Report and logged any defects found in the testing Life Cycle using Rational Clear Case the defect tracking tool.

Participated in status meetings, maintained the test activity log, reported status, and updated the test schedule, test scripts and data.

TXU UTILITIES-Downtown Dallas, TX

May 2002 – November 2002

Title: Contract - Quality Assurance Tester

ESSENTIAL JOB FUNCTIONS:

Wrote test cases and test scripts for DASR (Direct Access Service Request) in Siebel eEnergy 2000 6.3, the Order Entry System and CorDaptix 1.3.20, the Billing Product for SPL Worldgroup. CISPLUS was used to house the Customer Care and Billing Information.

Participated in system enhancement and modification of Legacy System to SPL/CORDAPTIX/CIS+ (Billing), Siebel, and PeopleSoft (CRM/Front End).

Evaluated technical requirements definition and mapping.

Held a leadership role of testing and technology deployment.

Performed requirements gathering and led preparation of scope definition documents, as well as test case scenarios, test Plans, and test scripts.

Worked to manage defects, change controls and regression test planning.

Analyzed business requirements, created a test plan, project plan, and gap analysis of an order entry and billing system.

Performed Data Preparation and ran SQL Queries.

Provided analysis, troubleshooting, and reports using resources such as ERCOT Daily Extracts and Portal.

Set-up of test cases in for the Order Entry and Billing applications. These applications were coded in PeopleSoft v 8.8.)

Located and tracked defects in a database and documented finding in Rational ClearQuest.

Provided status reports and measurements throughout the testing cycle, which included detail project testing status and troubleshooting issues.

Served as the liaison between the Business and Information Technology divisions to identify billing problems and make appropriate corrections to promote bill segments according to accuracy and protocol standards.

Completed billing adjustment service orders and resolved escalated billing disputes in a timely matter.

Performed stress, regression, system, and end user testing of new/revised functions and provided general user support for Utility. Billing System was in a Web environment.

Wrote test cases and test scripts for 814_01, 814_16, 814_17, 814_05, 867’s, 810 and 820 EDI ANSI ASC X12 Version 4010 transaction files for the Texas Set 1.5 implementation to ERCOT.

Validate and reported defects in Rational ClearQuest the defect tracking tool.

EXOLINK CORPORATION-Lewisville, TX

November 2000 – January 2002

Title: Quality Assurance Engineer – Black Box Testing

ESSENTIAL JOB FUNCTIONS:

A provider of retail transaction services, responsible for testing an in-house Java Web-based application (Exotran) for the utility industry.

Create and validated EDI ANSI ASC X12 Version 4010 transactions files for the Texas Set 1.3 and 1.4 implementation to ERCOT 814_01, 814_16, 814_05, 867’s, 810, and 820 EDI transactions via OTS (Online Transaction System) to run test data in the user acceptance-testing environment to simulate the production database.

Wrote test plans from business requirement documents.

Wrote test cases, and reported any defects via in-house reporting tools.

Verified inbound and outbound map translation by Mercator and Gentran for EDI flat files.

Compared XMD to XML for accuracy.

Participated in status meetings.

Maintained the Test activity log, reported status, and updated the test schedule as required.

Updated test conditions, test scripts and data as required.

VERIZON TELECOM-Grapevine, TX

July 2000 – November 2000

Title: Contract - UAT Arbor Billing Lead

ESSENTIAL JOB FUNCTIONS:

Wrote test cases for various interfaces that included EDW, Verizon Gateway, End User Billing, and Access Bill Formatter. These test cases where specifically for validation into and out of Kenan Arbor Billing Software.

Validated converted legacy data into Kenan Arbor 9.1 using Oracle SQL plus 8.0.

Wrote and documented test cases relating to data products: DSL, ATM and Frame Relay technology.

Verified all charges in Kenan Arbor Software.

Led UAT testing effort for Arbor B/P 9.1.

Reported status and documented defects found while executing test cases using Test Director 7.0.

EXCEL COMMUNICATTIONS-Addison, TX

October 1999 – July 2000

Title: Project Test Specialist

ESSENTIAL JOB FUNCTIONS:

Drove analysis, development, and implementation of enhancements and new projects and products related to local billing.

Wrote and documented test plans and test cases relating to the local billing project.

Reviewed test output of changes to the systems and products.

Led UAT testing for the local project, as well as maintained test activity logs, reporting status to management.

Documented defects found while executing test cases using Siebel 99 5.5 as the front end Customer Care and Kenan/ Arbor B/P 8.1 as the backend for billing functionality.

CITIZENS COMMUNICATIONS-Dallas, TX

March 1997 – October 1999

Title: System Test Analyst

ESSENTIAL JOB FUNCTIONS:

Saville CBP (Citizens Billing Platform)

System testing the AS400 GUI for the Saville Billing System, which allowed Citizens to provide their customer base with a single source for all Citizens related telecommunications services.

Data gathering for system test, reviewed functional specifications, and attended functional walkthroughs.

Created test conditions, test scripts, test data, and executed tests.

Analyzed actual results of test scripts and documented any defects found.

Participated in status meetings.

Maintained the test activity log, report status, and updated the test schedule.

Conducted system testing in Toronto, Canada.

Developed a subject matter expert (SME) level of knowledge in batch processing and customer care using the CBP front-end process for user acceptance testing.

CPS (Citizens Provisioning System)

The Citizens Provisioning System, a Client Server application written in Microsoft SQL Server, provides a gateway to the current Billing System and the Provisioning entities. It will allow Citizens communications to process and accommodate any functionality provided with the new billing solution, Citizens Integrated Billing Platform (CBP).

Developed the test plan and test schedule.

Coordinated testing activities, tracking the results, and reported to management for system test.

Managed the test environment and test case development.

Senior Billing Analyst, Pre-Billing System Enhancement

Managed the implementation of Saville CBP, a new Billing Platform for paging, internet, cellular, and long distance integrated processes.

Created system test plans and supported acceptance and implementation testing.

Provided technical support, training, documentation and special research for the improvement of Order Entry.

Monitored processes, traffic management, billing and invoicing.

Participated in status meetings, maintained the test activity log, reported status, and updated the test schedule, test conditions, test scripts and test data.

SOUTHWESTERN BELL MOBILE SYSTEM-Richardson, TX

January 1993 – March 1997

Title: Assurance Analyst

ESSENTIAL JOB FUNCTIONS:

MPS (Message Processing System)

Tested Telegence, a client server based billing software with a PowerBuilder interface, Unix DBMS, Novell Server, sub language SQL, NT 3.51 and Windows 3.0 Operating systems, ensuring all functionalities of the Message processing modules were performing pursuant to the departments Matrix requirements and developers Release Notes.

Develop and executed test plans and test cases via black box models and component testing methods.

Tracked defects using Lotus Notes.

Participated in status meetings, maintained the test activity log, reported status, and updated the test schedule.

Updated test conditions, test scripts and test data.

Bill Audit Analyst

Verification of Customer Billing and Roamer Billing accuracy processing and message processing accuracy, reporting and tracking problems discovered in Billing and Message Processing and table review, assisting other data processing groups with testing of enhancements, new billing cycles, and new software products.

Provided support to the markets on billing questions and billing change requests.

Worked as a liaison between the markets, CBIS and in-house support groups ensuring billing system changes did not affect the system adversely.

Education and Training

Arkansas College of Technology - Business Technology

Richland College - Microcomputers/Unix - 1995

Contact this candidate