Murtaza (Taz) Zakir

ORACLE Consultant

***** ******* ***** *****, *******, TX 77095

Email : ac4lk5@r.postjobfree.com Cell : 510-***-****

Status: U.S. Citizen & U.K Citizen

PROFILE 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, to include Pacific Gas & Energy (PG&E) and Montana Dakota Utility

PROFESSIONAL EXPERIENCE

Oracle CC&B/MDM/ODM QA Analyst

Kansas City Power & Light - Kansas City, MO (Contract)

January 2018 to Present

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

Zahab LLC - Houston, Texas (Contract)

January 2017 to March 2017

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

Kauai and Maui Water Company,Hawaii, U.S.A (Contract)

March 2016 – September 2016

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

Louisville Water Company, Louisville, KY, U.S.A (Contract)

September 2014 – December 2015

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

Honolulu Board of Water Supply, Honolulu, HI, U.S.A (Contract)

September 2013 – June 2014

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

Pacific Gas and Electric Co (PG&E), San Francisco, CA, U.S.A (Contract)

November 2012 – September 2013

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

Montana Dakota Utility (MDU), Bismarck, ND, U.S.A (Contract)

January 2012 – August 2012

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

Pacific Gas and Electric Co (PG&E), San Francisco, CA, U.S.A (Contract)

August 2009 – January 2012

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

Ezzi Signs, Houston, Texas (Contract)

March 2009 – June 2009

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

PG&E Pacific Gas and Electric Co (PG&E), San Francisco, CA, U.S.A (Contract)

May 2008 – November 2008

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

People Quest, Houston, TX, U.S.A (Contract)

January 2008 – March 2008

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

AIG Valic, Houston, TX, U.S.A (Contract)

March 2007 – August 2007

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

Charles Schwab, San Francisco, CA, U.S.A (Contract)

May 2006 – December 2006

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

May 2005 – April 2006

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

Fruit of the Loom, Bowling Green, KY, U.S.A

May 2003 – May 2005

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

Charles Schwab, San Francisco, CA, U.S.A (Contract)

May 2002 – January 2003

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

Cisco Systems, San Jose, CA, U.S.A (Contract)

November 2001 – April 2002

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

Charles Schwab, San Francisco, CA, U.S.A (Contract)

April 1997 – October 2001

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

Bay Networks, Santa Clara, CA, U.S.A

November 1996 – April 1997

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

Pacific Bell Information System, San Ramon, CA, U.S.A. (Contract)

February 1996 – November 1996

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

Roche Bioscience, Palo Alto, CA, U.S.A. (Contract)

December 1994 – February 1996

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

General Data Comm, CT, U.S.A. (Contract)

June 1994 – November 1994

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

Sr. Analyst/Programmer

Eurotunnel Public Limited Company, England (Contract)

March 1993 – July 1994

Developed the Traffic and Revenue System working from Functional specifications, designed, programmedand provided unit testing on a bilingual system

Utilized VMS5.5, ORACLE VERS 6, ORACLE VERS 7, SQL FORMS 3.0, SQL MENU 5.0, SQL PLUS, PL/SQL, CASE DICTIONARY, ALL-IN-1

Sr. Analyst/Programmer

Hampshire County Council, England (Contract)

December 1992 – March 1993

Developed a new Student Recording System

Utilized VM/CMS, ORACLE VERS 6, SQL FORMS 3.0, SQL PLUS

Sr. Analyst/Programmer

Information System International, England (Contract)

July 1992 – October 1992

Developed a multi-lingual European Factor Management System, worked from functional specifications, design programming, unit and system testing

Utilized VMS 5.4, ORACLE VERS 6, SQL FORMS 3.0, SQL PLUS, SQL LOADER,PRO COBOL.

Sr. Analyst/Programmer

British Petroleum, England (Contract)

October 1991 – June 1992

Designed, programmed and tested the Oracle Based System for the Engineering Division of British Petroleum

Utilized VMS 5.4, ORACLE VERS 6, SQL FORMS 2.3, SQL FORMS3.0, SQL PLUS, PRO COBOL, CASE DICTIONARY, ALL-IN-1

Sr. Analyst/Programmer

British Gas Plc, England (Contract)

April 1991 – August 1991

Developed the new Billing System for the Contract Gas Customers

Utilized VMS 5.4, ORACLE VERS 6, SQL FORMS, SQL PLUS, PRO COBOL, CASE, ALL-IN-1

Sr. Analyst/Programmer

Sedgwick Lloyds Underwriting Agents, England (Contract)

December 1990 – April 1991

Developed the Distribution of the Results System for the Lloyds underwriters

Utilized VS 7.21, ORACLE, SQL FORMS, SQL PLUS, PRO COBOL

Contact this candidate