Data Sales

Walter L. Peacock

e-mail: *********@*****.***

Phone: 650-***-****

TECHNOLOGY SUMMARY

Excellent knowledge in OLAP Design and Architecture, Custom ETL, Data

Conversions and Data Mapping, Database Migration, Data Modeling, Database

Design and Development, Data Warehouse,

Database Performance Tuning including SQL Queries, Materialized Views and

Table Partitioning, Database Administration, Packages (PL/SQL), Procedures,

Functions, Database Triggers, Database Backup/Restore.

Experienced in Full Life-cycle Development: Requirements Analysis, Design,

Programming, Implementation, Testing, Change Control and Production

Maintenance of Information systems.

TECHNICAL SKILLS

LANGUAGES:

PL/SQL, SQL, Perl with DBI, XML, Pro*C, Java, C, C++, COBOL, PL/1, JCL, HTP

Web ToolKit, Visual Basic, Unix Shell Scripting, HTML, DHTML

DATABASES:

ORACLE 7.3, 8.05, 8i, 9i, 10g, 11g, SQL Server, MySQL, MS Access, Teradata,

IMS/VS

OPERATING SYSTEM:

UNIX (Linux, SOLARIS, AIX, HP-UX, DEC, XENIX), WINDOWS, MAC O/S, MVS, OS/2,

VMS

JAVA TOOLS:

JDBC, ODBC, JDeveloper, Microsoft Visual J++, JDK

SOFTWARE/TOOLS:

OracleBI Discoverer, Business Objects, Oracle Application Server(OAS),

9iAS, Enterprise Manager, SQL*Loader, SQL*Plus, QueryMan, WinDDI, Fastload,

BTEQ, Veritas NetBackup, Designer 2000, Oracle Forms, Erwin, Visio, SQL

Navigator, Toad, EDI, UC4 Automation, LDAP, CBTREE, BTRIEVE, Brio, MV90

HARDWARE:

SUN, RS 6000, UNIX Workstations, HP 9000, IBM Mainframes, VAX, CDC

APPLICATION DOMAINS:

Financial, Banking, Healthcare, Energy/Utilities, Electronic Commerce,

Insurance, Telecom

CONSULTING HISTORY

California Independent System Operator (CAISO), May 2010 - July 2010, SAT

Test Lead

Provided support and data analysis for the System Acceptance Testing of the

new release of the CAISO Settlements application. Provided data mapping,

test cases, test data and load scripts, performance testing and analysis

using PL/SQL and Perl.

PG&E, October 2009 - May 2010, Operations Interface Analyst/Programmer

As a member of the SmartMeter IT Operations Team, focused on data flows

between core applications. Monitoring SmartMeter IT Systems to meet data

delivery requirements, Operational Interface support, measurement and

analysis of SmartMeter data delivery and performance.

Configuration / execution of batch jobs, shell scripts, Perl scripts. to

assist in the design and build requirements for existing/new functionality

for the PG&E SmartMeter technology.

Provided 24/7 Operational Interface support for the daily, weekly and

monthly processing.

California Independent System Operator (CAISO), February 2006 - March 2009,

Senior Consultant

Performed in the following roles:

24/7 On-Call Operational Support for MRTU Market Simulations

Defect tracking trouble shooting and resolution of Vendor Applications

issues

Developed Perl Scripts to scan operations logs and send email notifications

Developed Perl Scripts for process automation

XML Payload Data Transformation to Billing Determinants using PL/SQL

Custom ETL Development (Test Data, Legacy Data Sources) Using Perl and

PL/SQL

Data Conversions

DB to DB Data Loaders

Support Settlements Charge Code Development, Test and Validation

Meter Data Quality Validation

Monitored Settlement Applications and Meter Data Statements and Billing

publishing

Database and Application Performance Tuning

Test Team DBA and programming Support

Designed and developed processes for the integration of the CAISO Market

Participant meter data sources with the AREVA Settlement application.

Developed PL/SQL data loader applications for Siemen's XML Meter Data

Payloads, DB to DB and CSV files. Created the SaMC Bill Determinant Data

Mapping processes and procedures and performed the Bill Determinant Data

Mapping Role for the Project. Developed automation scripts using Perl.

Assisted in the migration of vendor's applications to 64-bit app servers

and upgrade to Oracle 11g.

Lead Architect of the SOA Bill Determinant Data Mapping Application for the

SaMC Project. This custom ETL application (PL/SQL) provided the CAISO with

a user configurable Bill Determinant Data Mapping process, Rules Engine

processor, and Data Validation Engine.

The SOA Bill Determinant Data Mapping Application receives input from

multiple data sources which include Transactional XML Payloads, DB2DB,

Master File, Standing Data, and Reference Data. The data mapping

application also receives mapping rules and requirements from the SaMC

Configuration Design Guides and the data requirements. The process results

in creating the billing determinants for input data to the AREVA Settlement

application from which the California energy market is settled each day.

This approach uses dynamic PL/SQL to enable the Business Users to have

greater control and flexibility of the configuration of the input data and

minimizes the amount of programming code necessary to support the changing

business rules and data configuration requirements.

AREVA ESCA, September 2003 - January 2006, Oracle Developer/DBA

Lead Architect of the SaMC External Data Base Interface in PL/SQL which is

the DB2DB ETL engine used during MRTU SaMC Stage-1 for processing / mapping

the CAISO Legacy data sources (BBS) into the AREVA Settlements tables. The

DB2DB software is a table driven, configurable application that extracts

billing determinants from the legacy systems and transforms them into the

format that is required by the AREVA Settlements application. In addition

to the dynamic transactional data, the DB2DB also provides interfaces for

Standing Data and Master File Data sources.

Developer/DBA of the Stage-1 version of the SOA Bill Determinant Data

Mapping Application. Designed and developed the PL/SQL ETL software using

a Rules Engine approach and implemented interfaces for Pass Thru Bills,

BITS and PI XML payloads.

Performed maintenance and enhancements on the ASIM API ETL stored

procedures. Performed database performance tuning and maintenance.

Provided database design and development for the MISO project and CONOCO

project.

Xilinx, Sales and Marketing Data Warehouse Group, March 2002 to June 2003,

Data Warehouse Developer

Performed PL/SQL database development and database tuning for the Data

Warehouse Sales, Claims, ACME and Leading Indicators applications running

on Oracle 8i, Oracle 9i and Oracle 9iAS. Provided reports development

support for the Oracle Applications 11i migration. Maintained client-

specific data marts with ongoing data transfers and data loads using

various formats. Provided Business Intelligence support as the OracleBI

Discoverer Administrator and developed OracleBI Discoverer reports.

Developed a migration plans and support for the users during the roll-out.

Wells Fargo Bank, Internet Financial Services, August 2000 to November

2001, Oracle Developer

Provided On-Call Production DBA support for the multi-terabyte Banking

Business Events Data Warehouse. Monitored production job streams.

Provided performance tuning and enhancements to the PL/SQL data load

procedures and Oracle 8i databases. Established production data migration

procedures and database space management for the partitioned tables.

Monitored production processes. Implemented table level backup/recovery

procedures. Migrated a data warehouse application from Oracle 8i to

Teradata SQL. Used the WinDDI, QueryMan, BTEQ and FastLoad utilities.

Modeled, designed, implemented and administered Oracle 8.1.7 databases to

maintain customer financial data for management sales campaigns and

reporting. Developed a database application using PL/SQL to interface,

process and store XML customer banking transaction data from Vertical-One

(Yodlee) into a datamart. Developed database application and PL/SQL data

extract, transformation and load (ETL) procedures for wireless banking

transaction data from Bank of Montreal application. Developed SQL sales

marketing reports and migrated the databases and applications to Solaris.

PG&E Energy Services, April 1998 to August 2000, Oracle Data Analyst /Java

Developer

Provided Meter Data Management and applications development expertise in

the Electric Energy Deregulation industry. Designed and developed Meter

Usage database schema and PL/SQL code for time-series meter data

collection. Implemented data aggregation procedures and queries. Developed

PL/SQL stored procedures to provide interfaces for Java applications and

other accounting processes. Performed DBA environment activities and

performance tuning functions.

Developed an enterprise-wide Web Application and Data Warehouse for dynamic

access to energy usage data and reporting. The organizational departments

supporting and using this application includes Settlements, Load

Forecasting, Pricing, and Operations. The Web application provides

essential capabilities throughout the organization, such as data retrieval

by customer account and groups, missing data points analysis, customer

energy usage profiling, billing information, charts and reporting. The

Meter Usage Web Application was implemented using Oracle Application Server

and the PL/SQL HTP Web Toolkit. Implemented Oracle Discoverer (Web and

Client Server) Reporting tool and End User Layer(EUL). Performed

installation, system admin and tuning functions for the OAS and Discoverer.

Developed PL/SQL stored procedures and triggers for the Java ISO Settlement

application based on the Meter Usage database. Developed a datamart and

PL/SQL software for the Load Forecasting application. Provided support for

the implementation and operation of the company's flagship internet based e-

business Customer Service Data Warehouse Application (PowerSight).

Developed software to process CMEP, MV90, and MDEF formatted data and EDI

810,867. Defined database structures for California Market energy data and

New England Market energy data. Developed PL/SQL ETL loader for California

Meter Data to read and parse the EDI X12 document directly. Implemented

solutions using Oracle 7.3.3, 8.05, 8i, PL/SQL, Pro*C, LOBs, HTP Web

Toolkit, Java, C++ and Oracle Application Server.

Hitachi America, Limited, September 1997 to April 1998, Applications

Programmer

Developed server-side Java CORBA applications to provide real-time sales

information reports to sales reps over the internet from the Customer

Datamart. This effort consisted of the design and development of a multi-

tiered Web application with back-end interfaces to the BrioQuery data

mining reporting tool, Oracle and LDAP. Provide support and maintenance

for PL/SQL datamart loaders. Evaluated, tested and implemented Electronic

Commerce products. Developed test plans and pilot test strategy. Developed

and maintained an Electronic Commerce Research Web Site.

MCI Telecommunications Corporation, May 1996 to July 1997, Applications

Programmer

Developed and maintained AIX and Unix based client server applications

written in Pro*C with embedded Oracle SQL to support the datamart and

fulfillment activities of MCI Prepaid Card and Prepaid Cellular retail

businesses. These applications supported MCI's Call Center operation.

Developed automated FTP procedures of files to the remote fulfillment

vendor. Designed and implemented an inventory system to maintain inventory

data for 350 retail kiosks using Oracle PL/SQL under AIX.

Developed server-side and client-side Java applications for MCI's Intranet,

including Java financial applications with JDBC access to Oracle, a Java

Report Server which utilizes socket connections and streams to run reports

remotely on the AIX server and display the report results on the Windows

client. Also developed a Java Application server which utilizes JDBC to

access an AIX Oracle database and return result sets in response to

requests from remote clients. Completed the development of a Web based

Order Entry application in Java utilizing Marimba Bongo and Sun's Java

WorkShop under Solaris and Windows NT Web Servers.

ACADEMIC BACKGROUND:

B.S. Electrical Engineering/Computer Science; M.S. Computer Science;

University of Louisville.

Contact this candidate