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