Project Analyst

Derek Chochol

**** ****** ******

San Francisco, CA 94102

(630) 550 - 1803

Professional Experience:

Pacific Gas & Electric (PG&E) - San Francisco, CA - USA

IT Consultant - Systems Analyst and Developer

Feb. '10 - Current

ORACLE CC&B - Usage & Biling - SmartMeter, ITRON, MDMS and FAS and other

Interfaces, Version 2.3 Upgrade

. Performed and documented impact analysis for CC&B version 2.3 upgrade

- Meter Read, Field Activities and Billing interfaces;

. Developed estimates, detail designs, test plans and matrix for CC&B

version 2.3 upgrade

. Developed enhancements, or new programs for SmartMeter, Field Activity

and Billing interfaces (PL/SQL, Java, Microfocus COBOL, java, Perl and

UNIX Korn Shell)

. Supported XAI development for adhoc CC&B interfaces

. Developed adhoc reports and audits (PL/SQL, java)

. Responsible for design, test and implementation of the Usage

Threshold Notification Customer Contact

. Designed and developed jobs and programs for CC&B extracts for ABS and

MV90 synchronization processes

. Created enhancements for Meter Read History and Delayed Cancel/Rebill

calculations

. Tested CC&B Rate changes, documented and presented findings to Process

Owners

City of Raleigh - Water Department - Raleigh, NC - USA

IT Consultant - Technical Lead and Systems Analyst

April '09 - Feb. 2010

ORACLE CC&B - Implementation and Customization Projects

. Designed and developed Jave and Microfocus COBOL, users exit and

interface programs, using local SDK installation - Eclipse, and Unix

Microfocus compiler

. Designed and developed Java plug-in algorithms

. Developed Portals, Zones and XAI services; worked on Web Self-Service

. Configured new business and maintenance objects and other configurable

CC&B entities

. Developed Unix scripts for batch processes - Korn Shell and Perl

. Developed and set up new Portals and Zones in CC&B online environment

. Participated in the CC&B version 2.2 implementation project for City

of Raleigh water department that included People Soft integration GL,

BI Publisher, DOC 1, Web Self-Service interfaces and other new CC&B

extensions

. Created project documentation including Functional and Technical

Design; test plans and matrix; system and program flowcharts;

configuration

. Planed configuration and modules migration to multiple CC&B

environments

Nicor Gas - Naperville, IL - USA

IT Consultant - Technical Lead Analyst

March '06-April '09

ORACLE CC&B - Upgrade and Customization Project

. Performed in conversion project - data mapping, systems analysis and

documentation, testing.

. Participated in an upgrade project - version 1.5 to 2.2.

. Customized Oracle CC&B CRM package to meet Nicor Gas business

requirements - change CC&B configuration, add/modify custom programs.

. Created project SDLC documentation including business requirement,

process flowcharts, project plan and recommendations, detail design

including program specs, data mapping, test plans and test matrix and

other project related documents.

. Presented project plans, recommend solutions, and report project

progress to the Business partners and IT managers.

. Developed new and update existing programs for Billing, Remittance,

General Ledger, Collection and Financial Reporting departments with

PL/SQL, Microfocus COBOL, Java, PERL, Korn shell scripts and other

languages.

. Ran unit, string and regression tests; document results and present

them for the Users' review and acceptance.

. Worked with Accountants and Financial Analysts to determine existing

system's issues, and to find the root cause and to design and

implement appropriate fixes - config change, custom programming, data

repair, issue reporting, database changes, or other solutions.

. FTP and process files sent between Nicor and the third parties -

banks, collection and credit reporting agencies, and others.

Information Resources Inc.

IT Consultant - Programmer/Analyst

Oct. '01-December '05

Data Warehouse (Global Priority) Project

. Participated in design, coding, testing and implementation phases of

an Oracle data warehouse; programmed ETL to extract data resided on

variety of sources (Oracle, DB2, flat files, other) and load it onto

Global Priority Data Warehouse.

. Worked directly with the Business Analyst, translating business

requirements into systems specifications - technical designs, impact

analysis, data mapping, program specs, tests conditions and other

project documentations.

. Coded multiple C and VB .NET programs for data extracts and reporting.

. Ran user's acceptance tests, rolled out modules to production and

assisted with post implementation issues.

Allstate Insurance

IT Consultant - Programmer/Analyst

March'98-Oct. '01

Billing - Enhancement and Support Projects

. Responsible for supporting 15 million account Billing System.

. Maintained COBOL, PL1 programs in DB2, IMS, CICS and JCL environment.

Adhoc Refund and Audit Projects

. Design coded and tested COBOL and PL1 programs to extract DB2 and IMS

date and create audit file used in refunds processing.

Ernst and Young LLP

IT Consultant - Programmer/Analyst

Aug.'97-March'98

TRUE VALUE and COAST-TO-COAST HARDWARE RETAILERS MERGER

. Analyzed Unix and Windows NT based Microfocus COBOL programs, created

modification specs and test plans according to E&Y Fusion project

methodology

. Mapped fields on Indexed files to columns on DB2 UDB tables - data

mapping chart.

. Coordinated extensive System testing at client side

Education:

DeVry Institute of Technology - Addison, Illinois

Bachelor of Science in Computer Information Systems, GPA 3.81/4.00

Certifications:

IBM DB2 UDB V5 - Database Administration

(installation, security, utilities and commands, performance)

Technical Summary:

UNIX

Five (8) years experience with UNIX application systems development and

support, including: ORACLE, DB2 UDB, PL/SQL, SQL Plus, LOADER, SQL,

WebSphere MQ,

Microfocus COBOL, Java, C/C++, PERL, KORN Shell scripts, vi editor and more

IBM Mainframe OS390

Eight (8) years experience with large scale mainframe application systems

including:

DB2, IMS, VSAM, CICS, JCL, TSO/ISPF, SPUFI, QMF, SyncSort, WebSphere MQ,

COBOL, PL1, C, SAS, C-LIST / Rexx, ASSEMBLER, EXPEDITER, Smart Test, Change

Man, ENDEAVOR, FILE AID, Star Tools, ABEND AID and others.

Windows

Hands on experience with following desktop and Internet software:

VB 6, VB .NET, Java, Microfocus COBOL, JavaScript, HTML, Eclipse, Visio, MS

Access, Excel and other MS Office programs, MS Project, Secure Source, BI

Publisher and others.

Contact this candidate