Cc B Oracle

PROFILE SUMMARY

A Seasoned lead Quality Test Consultant with several years of progressive QA and testing experience. Test Lead focused on testing Oracle CC&B, C2M, MDM, and WAM applications using SQL to verify test results. Writing and executing Integration tests to confirm mapped tables are created and updated properly when adding new customers and for Billing Reconciliation. In a lead capacity, has managed and mentored large test teams, giving presentations on how to write UAT test cases and how to upload them to HP_ALM and ADO.

Expert level experience in the full QA life Cycle, which includes entire QA process; the gathering of requirements, test strategies, documentation of test plans, test cases, test procedures and developing test scripts for database, WEB and client/server applications as well as using the Agile Testing Methodology and testing Customer Care, Field Credit and Collections, and Billing.

THE FOLLOWING WORK EXPERIENCE ARE ALL FROM CONTRACT POSITIONS

WORK EXPERIENCE

Functional Analyst / Tester

C.O.R.E CC&B Implementation 2.8

September 2020 – March 2024

wrote Oracle CC&B Implementation Test Cases

Lead tester working on project to help other tester perform daily functional duties. Moved to test lead and then to UAT support lead.

As Support Lead trained other UAT testers to execute test cases in both the Customer Service and Field Credit and Collections Modules

Reviewed business, functional and design specifications to ensure full understanding for test development for Oracle CC&B for Electric, Gas and Steam

Evaluated manual test cases and reports test results, opened defects when needed.

Wrote test cases for the warehouse order system

Developed, documented and maintained functional test cases and other test artifacts like detailed test script, test data, and test results

Ensured that validated deliverable's meet functional for both Gas and Electric and design specifications and requirements

Isolated, replicated, and reported all defects in ADO and validated defect fixes

Executed test scripts creating, and updating Start Stop and Transfer accounts.

Wrote Test Cases

Created Test Cases from creating Premise to turning on service and disconnecting service for multiple reasons

Verified process by checking for letter creation for order completion

Executed some SIT test cases and supported UAT testing effort

UAT Lead for testing.

Checked accounts in CIto update account in CC&B.

Used CIS to estimate accounts in CC&B

Environment: Dev Ops, Oracle CC&B,CIS, SBI, MDMS,Maximo, MDM, SQL Developer, SharePoint, MS Office

Functional Analyst / Tester

Evergy/KCPL CC&B Enhancements/Upgrade to 2.6

January 2020 – March 2020

Wrote test cases for CC&B enhancements upgrade.

Working Agile methodology

Document the outcome of test executions and all information needed to support ongoing measurements and defects, tests, and coverage

Execute MDM test cases based on requirements for CC&B upgrade

Evaluated test exit criteria to assess if additional tests are required or if test scenarios need to be adjusted

Environment: Sharepoint, HP_ALM Oracle CC&B, MWM, SQL Developer,

Quality Assurance Tester

LADWP Oracle CC&B Enhancements/Regression Testing (Short Term)

October 2019 – Dec 2019

Wrote test cases for CC&B enhancements upgrade.

Working Agile methodology

Documented the outcome of test executions and all information needed to support ongoing measurements and defects, tests, and coverage

Executed Regression test cases based on requirements for CC&B upgrade

Evaluated test exit criteria to assess if additional tests are required or if test scenarios need to be adjusted

Executed test cases used for Billing Reconciliation ensuring customers are being billed correctly.

Executed test cases for posting payments both online and through the customer portal.

Environment: Rationale, Web Center, Oracle CC&B, MWM, SQL Developer, MS Office

QA Performance WAM Tester

WSSC CC&B to C2M Upgrade

March 2019 – June 2019

Wrote Integration Test Cases from Legacy system to WAM

Reviewed business, functional and design specifications to ensure full understanding for test development for WAM, MWM

Executed and evaluated manual test cases and reports test results

Developed, documented and maintained functional test cases and other test artifacts like detailed test script, test data, and test results for Integration

Ensured that validated deliverable's meet functional and design specifications and requirements for C2M and WAM

Isolated, replicated, and reported all defects in ALM/QC

Executed test scripts adding, removing and updating all Inventory and employee Items in WAM and MWM

Created and tested New Integrations from EBS adding/updating new materials and syncing both.

Verified process by checking WAM for order completion

Wrote test cases to verify order completion from WAM.

Validated both WAM and EBS tools by running queries

Environment: HP_ALM, Oracle C2M, WAM, MWM, EBS, SQL Developer, MS Office

Quality Assurance UAT Tester

ONCOR CC&B Upgrade

April 2016 – September 2017

Rewrote CIS Oracle CC&B Application Test Cases

Reviewed business, functional and design specifications to ensure full understanding for test development for Oracle CC&B

Executed and evaluated manual or automated test cases and reports test results

Developed, documented and maintained functional test cases and other test artifacts like detailed test script, test data, and test results

Ensured that validated deliverable's meet functional and design specifications and requirements

Isolated, replicated, and reported all defects in ALM/QC and validated defect fixes

Executed test scripts adding, removing and updating Maximo Meters

Executed test cases for Billing Reconciliation

Created and tested from creating Premise to turning on service and disconnecting service for multiple reasons

Verified process by checking MDMS for order completion

Validated MDMS tool by running queries

Environment: HP_ALM, Oracle CC&B, SBI, Maximo, MDMS, Inet, SQL Developer, MS Office

Quality Assurance Tester

ABB/Enquero

January 2016 – April 2016

Performed simple and complex query creation

Working Agile methodology

Gathered and documented the outcome of test executions and all information needed to support ongoing measurements and reporting on risks, defects, tests, and coverage

XML creation for automation and testing

Created test plans and cases based on requirements

Oracle to MS SQL framework and testing

Contributed to the design of test scenarios and performs peer reviews of test cases

Evaluated test exit criteria to assess if additional tests are required or if test scenarios need to be adjusted

Participated in and contributed to internal design reviews of testing materials

Senior Quality Assurance Analyst

AMDOCS

September 2015 – December 2015

Senior Quality Assurance Analyst

Progressive

Apr 2015 – Jun 2015

Interactive voice response contract routing senior analyst

Call steering and Speech customer experience validation

Wrote test cases to follow call flows for IVR.

Held meetings to discuss call flows and skills

Tested and retired IVR components no longer used

Completed Adhoc queries to validate results

RISK methodology training

Created test strategy workbook

CSR Technical Support

Verizon FIOS

January 2015 – April 2015

Trained to take calls from Verizon customers with technical issues

Troubleshot issues for voice, data and video

Acted as team lead for internal team group

Documented all issues and dispatch technicians’ for in home wiring issues

Analyzed all diagnostic issues from the central office to the router

iSeries Quality Assurance Tester/Lead Tester

COSTCO

September 2013 – November 2013

Trained other developers on using the HP ALM application

Instructed team members how to create and write test cases from requirements on the AS400 billing platform

Wrote and executed test for billing runs in both batch and interactive

Taught team members how to upload test steps into HP ALM via excel spreadsheets

Gave presentations on how to test batch, interactive and menu applications

Created and tested CONGOS reports

Assisted team in executing Billing Reconciliation Test Cases.

Assisted team lead in writing SQL queries to verify results for both existing and new products

Assisted team lead in analyzing requirements for current projects and providing leadership when needed

Information Level 3 Tester/Test Specialist

Hewlett Packard

May 2013 – September 2013

Analyzed new process for any flaws or gaps using Agile EDI testing methods

for healthcare processing 837 & 834 transactions.

Analyzed the business rules for processing claims for testing purposes

Updated ALS system adding functionality to the screens

Completed writing manual testing on Mainframe migration for NON-Stop to NextGen HealthCare process

Tested and verified all GUI’s for Integration side

Completed backend integration testing from billing to AR

Wrote test scenarios, test steps and executed all testing for new functionality in HP ALM.11 for claims processing

Completed ICD 9, 10 & claims training getting HIPPAA certified

Wrote test cases and executed for claims opening all defects in HP ALM.11

Wrote automated test scripts in HP ALM for manual regression tests

Wrote test cases for change request submitted from production

Assisted and tested all new requirements for folder structure and uploaded documents into HP ALM

FedEx, Pittsburgh, PA

Jul 2012 – Apr 2013

Senior Quality Assurance Analyst/Lead Tester

Analyze new process for any flaws or gaps using Agile testing method on iSeries AS400

Complete manual testing of new functionality to the CONDOR3.5 project nationwide

Wrote queries to both compare and validate data elements for backend testing

Tested and verified all GUI’s from the integration side

Wrote test scenarios, test steps and executed all testing for new functionality in Sort, GUI, location screens and

scanners and opened defects in QC.11 for all

Wrote test cases and executed for integration opening all defects in QC

Wrote and executed test cases for billing reconciliation modules destinations

Validated all sorts and destinations/chutes and opened defects for all discrepancies found

Worked as production support admin after screens were promoted to production

Helped end users by answering questions and opening defects when found

Validated scanners displayed all new functionality and routed packages to correct destinations

Conducted presentation to other team members on QC

Validated both destinations and chutes are correctly displayed

Validated all sort rules

Quality Assurance Analyst/Lead Tax Tester

Frontier Communications

June 2011 – October 2011

Documented new processes found in new billing system for taxes using SDLC

Completed manual testing of Taxes for new DPI billing system for 4 state conversion

Verified all tax transactions from billing and CC&B module

Wrote queries to both compare and validate rates for backend testing

Provisioned all new customers moved to new billing system.

Validated provisioning of customers in parallel for billing.

Validated all rate per tariffs and opened defects for all discrepancies found

Compared current bills vs. new DPI bills

Conducted presentation to other team members on QC

Validated both subscriber line charges and FUSF rates

Validated all surcharge rates

Validated customer care and billing modules

Worked with both tables and conversation team when discrepancies were found

Wrote queries to determine impact analysis on multiple accounts when discrepancies found

Completed presentation to new team members how to use and test scripts in QC

Wrote AS400 queries to verify results for both existing and new rates

Opened defects for all discrepancies found in analyzing bills in QC

\TECHNICAL EXPERIENCE

Test Director, exposure to Load Runner, MKS, SharePoint, ALM, Rational, ADO, DevOps

Methodologies: Software Development Life Cycle, Agile, Iterative, OSS

Databases: Oracle 8i & 11i, SQL, TOAD, MS-Access, DB2, MY SQL, IVR, SQL Developer, mysql

Application/Billing

Software: Customer Care Billing, Amdocs Billing, CommSoft Billing, DPI Billing, MS Office, Visio, MS Project, Outlook Express, Lotus Notes, Saville, AS400, SDA, SEU, DBASE, Certo 2, EDI, Kenan Arbor, CSM, CRM, DRI, MSP, ALS, RMS, ePMX, Kenan BP, COGNOS Reporting, Maximo, Oracle CC&B, C2M, WAM, MDM, EBS

HIGHLIGHTS

Completed UAT testing effort leading over 100 testers located in multiple states conducting seminars on the test case creation process

Created and tested New Integrations from EBS to Oracle WAM & MWM

Conducted training on the QA Testing Process, Defect Management

Successfully Implemented new system to allow customers to select Home Delivery times and dates online for delivery

Successfully completed part one of four process to convert billing from Verizon to Frontier in four states

Through continuous testing optimization, achieved moving client from SDA to G3 with major conversion to new billing system. Engineered new purchasing model to streamline data process module. Also, created new Change Management system

Conducted Mobile Testing for Telecommunications Company

Conducted E2E bill verification

Contact this candidate