SUMMARY:

Degreed Software CC&B Quality Assurance Analyst and former CC&B ORACLE Programmer skilled in the analysis, testing and overall test direction, skilled in the development and testing of CC&B Applications. Experienced with Test Plans, Test Cases and Test Scripts in a CC&B Centric Development environment in support of major Power Generating Utilities.

TECHNICAL SKILLS:

• Oracle CC&B 1.5/2.3/2.4/2.5
• Oracle MDM/ODM 2.1
• Oracle RDBMS 12c
• HP ALM
• Mercury QC
• SAS Programming
• Crystal Reports 11.0
• Teradata V2R6
• Oracle RDBMS Financials 9.1, Oracle RDBMS Financials 11.03
• Designer 2000
• Developer 2000
• SQL Forms 3.0 & 4.5, SQL reports 2.5, SQL Menu 5.0, SQL Plus, SQL Navigator, TOAD, PL/Sql, SQL Loader, PRO Cobol, CASE Dictionary, Application Foundation
• PVCS Apps
• Integrity, Peregrine, Lotus Notes 6.5, SQL - Server, Paradox, MQSeries, Control-M, XML, Stylesheet(XSLT), Perl, Mercury Quality Center (Formerly TestDirector), Visual Source Safe (VSS)
• SQL Server 2008 R2
• UNIX,AIX,VMS,MPE/IX,HP-UX,VM/CMS,OS/MVS,VS,ITX,MOD400,TOPS-10,RXS-11M,Windows NT,Windows 10

PROFESSIONAL EXPERIENCE:

Oracle CC&B/MDM/ODM QA Analyst

Confidential, Kansas City, MO

Responsibilities:

• Working on application security testing on Consolidation 1CIS project, primarily worked on solving Test Cases/Test Scripts on CC&B, MDM and ODM.
• Executed and evaluated manual test cases and report test report test results in HP ALM defects tab and organized Defect Triage
• Have an explicit understanding of CC&B / MDM and ODM application functionality
• Utilized Oracle CC&B VERS 2.5, MDM and ODM VERS 2.1 ORACLE VERS 12c, Oracle SQL Developer, HP ALM

Senior Oracle Programmer/Analyst

Confidential, Houston, Texas

Responsibilities:

• Designed and developed backend pl/sql stored procedures and functions for their inventory system
• Utilized ORACLE VERS 12c, PL/SQL, SQL, SQLPLUS Oracle SQL Developer

Business Intelligent Lead

Confidential, Hawaii

Responsibilities:

• Worked on Oracle Cloud Service Application consisting of CC&B, Billing Insight, Field Service Management, Online Policy Automation and APEX (Oracle Application Express)
• Converted complex custom SQL Server Reports into Oracle SQL Reports, some of them into APEX
• Developed new user required Oracle SQL Reports
• Provided ongoing data requests from the CC&B function departments
• Utilized Oracle Cloud Service, Oracle CC&B VERS 2.4, ORACLE VERS 12c, Oracle SQL Developer, APEX

Sr. Developer/Quality Assurance

Confidential, Louisville, KY

Responsibilities:

• Provided Testers with The “V” related data by Data Mining the CC&B database
• Developed some of the complex Custom CC&B SQL Reports for the Users and Testers to validate the CC&B functionality
• Provided ongoing data requests from the CC&B function departments
• Provided SQL Training for the CC&B users

Sr. Developer/Quality Assurance

Confidential, Honolulu, HI

Responsibilities:

• Developed and Tested Custom CC&B Write-Off Event Algorithm Triggers using Cobol and SQL
• Developed complex reports on financial and consumption related data
• Tested rates by developing Rates Calculation Sheets in Excel and validated results in CC&B against corresponding Bill Segments on Calculation Lines and SQ Details
• Worked with Oracle Utilities Application Framework (OUAF)
• Utilized Oracle CC&B VERS 2.3, SQL SERVER 2008 R2, TOAD

Sr. Quality Assurance

Confidential, San Francisco, CA

Responsibilities:

• Involved in Test Planning, Data Preparation and also Test Execution of the new Bill Redesign Project
• Extensive knowledge of billing rates and customer service modules. Strong background with rate calculation and validation
• Involved in Energy statement validation of various graphs by preparing and executing complex Oracle queries
• Worked on the Gas Corrective Maintenance/Mobile project. The crew communicated the Gas Leak via mobile device DG8200 to Ventyx system and eventually to CC&B
• Utilized Oracle CC&B VERS 2.3, ORACLE VERS 11g, Mercury Quality Center 9.1, Oracle SQL Developer, PL/SQL, SQLPLUS, SQL LOADER, Ventyx

Sr. Software Developer/Quality Assurance Analyst

Confidential, Bismarck, ND

Responsibilities:

• Strong understanding of CC&B application, business requirements, designed, developed complex reports against CC&B Database using PL/SQL with the experience in constructing the procedures, packages, triggers, tables, functions, and user defined data type
• Developed Crystal Reports against oracle objects for report presentation
• Proficient in Unit and performance Testing
• Utilized Oracle CC&B VERS 2.2, ORACLE VERS 11g, Crystal Reports Vers 11.0, Oracle SQL Developer, PL/SQL, SQLPLUS, SQL LOADER

Sr. Quality Assurance

Confidential, San Francisco, CA

Responsibilities:

• Involved in Test Planning, Data Preparation and also Test Execution of the CC&B upgrade from CC&B V1.5 to CC&B V2.3 and also General Rate Case (GRC) implementation
• Coordinated and participated in complex data mining for PDP (Peak Day Pricing) project. Enhanced Middleware Software using PL/SQL and SQL
• Utilized Oracle CC&B VERS 2.3, ORACLE VERS 11g, Mercury Quality Center 9.1, Oracle SQL Developer, PL/SQL, SQLPLUS, SQL LOADER

Sr.Oracle Programmer/Analyst

Confidential, Houston, Texas

Responsibilities:

• Designed and developed backend pl/sql stored procedures and functions for their inventory system
• Utilized ORACLE VERS 10g, PL/SQL, XML, PL/SQL Developer, PL/SQL, SQLPLUS

Sr. Oracle Developer

Confidential, San Francisco, CA

Responsibilities:

• Enhanced existing packages, procedures and functions for the California Independent Operator (CAISO) market risk management system using PL/SQL and SQL. Involved in Component, Assembly and Product Testing and created and executed test scripts
• On the Gas Register Constant Project, prepared test plans from function requirements and completed testing in the test lab using Mercury Quality Center and also SPL (CC&B), SPL
• Utilized ORACLE VERS 91/10g PL/SQL, SQLPLUS, SQL*LOADER,TOAD 9.6, PVCS7, Mercury Quality Center 9.0,Visual Source Safe (VSS)

Sr. Oracle Programmer/Analyst

Confidential, Houston, TX

Responsibilities:

• Designed and developed backend PL/SQL stored procedures and functions for the nMarket product for electricity and gas related java based front end. Designed and developed stored procedures (API) for the daily loads
• Utilized ORACLE VERS 10g, PL/SQL, XML, PL/SQL Developer, Test Director, SourceSafe, JAVA

Sr. Oracle Programmer/Analyst

Confidential, Houston, TX

Responsibilities:

• Developed new modules and enhanced existing modules using PL/SQL within packages and stored procedures for their insurance application projects
• These are Data Warehousing projects, Extract, Transform and Load (ETL) with high volume of data
• Utilized PL/SQL, SQLPLUS, SQL LOADER, SQL Navigator, Visual Source Safe (VSS)

Data Analyst

Confidential, San Francisco, CA

Responsibilities:

• Data Analyst, Migrating Oracle 9i Data Warehouse System (ETL) to Teradata Contract V2R6 RDBMS
• As Data Analyst, analysis, classification and maintenance of data relationships in the Teradata Database(ETL)
• Utilized TERADATA V2R6, SQL ASSISTANT, TOAD, PL/SQL, SQL, ORACLE FINANCIALS (GL, AR)

Analyst/Oracle Programmer

Confidential

Responsibilities:

• Data Analyst, Migrated Oracle 9i Data Warehouse System (ETL) to Teradata Contract V2R6 RDBMS
• Analyzed classification and maintenance of data relationships in the Teradata Database(ETL)
• Utilized TERADATA V2R6, SQL ASSISTANT, TOAD, PL/SQL, SQL, ORACLE FINANCIALS (GL, AR)

Analyst/Oracle Developer

Confidential, Bowling Green, KY

Responsibilities:

• Enhanced the Promotional Pricing of the Order Processing System using HTML within PL/SQL stored procedures
• High Level Analysis of the current Order Processing System including recommendations for the future new system
• Worked on Oracle Financials, GL, AP and Fixed Assets Modules Using Developer 2000
• Utilized IBM RS/6000, AIX, ORACLE VERS 8.1.x, 9i PL/SQL, SQLPLUS, SQLOADER, TOAD, HTML, Oracle Financials version 11.03, SQL-Server, Paradox, MQSeries, Control-M

Sr. Oracle Developer

Confidential, San Francisco, CA

Responsibilities:

• Developed new modules for the Schwab Corporate Services, Retirement Product Services (RPS) project, using PL/SQL within packages and stored procedures. These are Data Warehousing projects, Extract, Transform and Load (ETL) with high volume of data
• Utilized SUN SOLARIS, ORACLE VERS 8.1.x PL/SQL, SQLPLUS, SQL LOADER,TOAD, SQL Navigator

Sr Oracle Developer

Confidential, San Jose, CA

Responsibilities:

• Enhanced and produced support for the Sales and Finance Information Technology Department’s World Wide Sales Commission System (WWCS) and Sales Credit Assignment System (SCA), using PL/SQL within packages, stored procedures, functions and database triggers. The system involves complex sales commission plans
• Utilized HP-UX 9000/800, ORACLE VERS 8.1.x PL/SQL, SQLPLUS, SQL LOADER, TOAD, SQL Navigator, PVCS, Apps Integrity

Sr. Oracle Developer

Confidential, San Francisco, CA

Responsibilities:

• Developed new modules for the Model for Understanding Schwab Economics (MUSE) and Customer Account Profitability (CAP), using PL/SQL within packages and stored procedures. These are Data Warehousing projects Extract Transform and Load (ETL) with high volume of data
• Utilized SUN SOLARIS, ORACLE VERS 7.2, 7.3, 8.0 and 8.1 DEVELOPER 2000, PL/SQL, SQLPLUS, SQL LOADER

Sr. Oracle Developer

Confidential, Santa Clara, CA

Responsibilities:

• Enhanced and supported the Information Data Warehouse (IW) project
• Designed and developed the non revenue (Deferred Revenue) modules, using PL/SQL within packages and stored procedures
• Utilized SUN SOLARIS, ORACLE VERS 7, DESIGNER 2000, DEVELOPER 2000,PL/SQL, SQL FORMS 4.5, SQL LOADER, GQL.MAESTRO

Sr. Analyst/Programmer

Confidential, San Ramon, CA

Responsibilities:

• Enhanced and supported the DMDR (Direct Mail Direct Response) system consisting of front-end SQL FORMS screens, the reporting process consisting PL/Sql within packages, stored procedures and database triggers and also using SQL PLUS and SQL LOADER
• Utilized VMS 6.1, ORACLE VERS 7, DEVELOPER 2000, PL/SQL, SQL PLUS,SQL FORMS 3.0 & 4.5, SQL LOADER, EXCEL MACROS

Sr. Analyst/Programmer

Confidential, Palo Alto, CA

Responsibilities:

• Reported on the adverse effect of drugs system, using OMNIS 7.3 as the graphical user interface and ORACLE version 7 as the server, enhancing the existing system using PL/SQL within packages, stored procedures and database triggers and also using SQL Plus, SQL Loader and SQL Forms
• VMS 6.1, ORACLE VERS 7, PL/SQL, SQL PLUS, SQL FORMS 3.0,SQL LOADER, OMNIS 7.3, APPLE MACINTOSH

Sr. Analyst/Programmer

Confidential, CT

Responsibilities:

• Enhanced and maintained the existing financial accounting and leasing system using ORACLE, ORACLE FINANCIALS and QUIZ, QUERY, QUICK, IMAGE and COBOL -HP-UX V9.0, ORACLE VERS 6.0, ORACLE FINANCIALS VERS 9.0 SQL FORMS 3.0, SQL PLUS, PL/SQL, QUIZ, QUICK, QUERY, and IMA