SUMMARY

IBM Certified Database Associate

o

Over twenty years development experience in an IBM mainframe z/OS environment.

o

Nine years of PACBASE application development experience.

o

Five years PeopleSoft development experience supporting HRMS and Financials AP modules utilizing

o

PeopleTools, PeopleCode, Application Designer, Data Mover, Application Engine, SQR, COBOL and DB2.

PeopleSoft Technical Infrastructure Lead for a major PeopleSoft 8.x system merger, implementation and

o

upgrade.

TECHNOLOGY

Hardware: IBM Mainframe, PC Workstations and Servers.

Operating Systems: OS/390, Z/OS, PeopleSoft Internet Architecture, NT/2000, Unix System Services, Tuxedo,

Jolt, Websphere, Weblogic, MVS/XA, MVS/ESA, CICS, VM, ACP/TPF.

Software: COBOL, COBOL II, JCL, PACBASE, PeopleTools 8.x, PeopleCode 8.x, Application Engine 8.x, SQR,

DataMover, Unix Shell JCL Scripts, Assembler, PL/1, IBM Mainframe Utilities, TSO/ISPF,

IOF, SDSF, SPUFI, XPEDITOR, Intertest, StarTools, File-Aid, ZEKE, OPC, CMS, Panvalet,

Clist, Quickjob, Easytrieve, SAS.

DB2 V7/V8/v9 for z/OS, DB2 Connect Personal/Enterprise Editions, SQL, VSAM, IMS.

Databases:

SPECIALIZED TRAINING AND CERTIFICATIONS

IBM Certified Database Associate-DB2 9 Fundamentals, April 2009.

PeopleCode 8.18, June, 2003.

PeopleSoft Server Administration, July 2002.

PeopleSoft Application Engine 8.12, March 2002.

PeopleSoft 8.1 PeopleTools II, July 2001.

PeopleSoft 8.1 PeopleTools I, November 2000.

Electronic Data Systems Engineering Development Program, November 1985.

PROFESSIONAL EXPERIENCE

Maxwell Consulting Services, Inc. Bellbrook, Ohio October,

2002 – Present

President/Senior Application Developer

Self-employed, independent consultant offering application development expertise in an IBM z/OS environment.

Experienced in DB2, COBOL, CICS, JCL, VSAM, PACBASE, and PeopleSoft Development. Additional skills in

PeopleSoft Internet Architecture implementation and PeopleSoft upgrades.

Client Engagements:

Duke Energy Corporation

Developed programs for the Labor Data Capture System in support of a major financial re-engineering project.

Coded new programs to convert existing accounting fields on Predefined Employee Timesheet records to new

accounting definitions. Modified batch programs to generate new accounting information for each employee

during a payroll cycle. Modified Accounting Distribution Mass change processes to incorporate new accounting

fields. Programs developed using COBOL, DB2, JCL, and IBM utilities.

MeadWestvaco Corporation

PeopleSoft 8.9 Upgrade: Performed maintenance and support functions for PeopleSoft 8.3 HRMS system during

upgrade to HCM 8.9. In support of the 8.9 upgrade, designed and developed an in-house archiving solution for

PeopleSoft 8.3 pay and balance tables utilizing Application Engine. Developed batch programs using COBOL and

SQR to validate that the 8.3 Job table date columns were mapped and converted correctly to the proper 8.9 table

columns. Developed multiple SQRs to extract and compare PeopleSoft 8.3 table row counts to PeopleSoft 8.9 row

counts for upgrade validation purposes.

PeopleSoft 8.3 Upgrade: Served as Technical Infrastructure Team Lead responsible for successful implementation of

system architecture for PeopleSoft HRMS/Payroll system merger and upgrade to HRMS 8.3. Completed PeopleTools

upgrade to PeopleTools 8.18 from PeopleTools 8.17. Implemented all tax updates for tax year 2002. Performed fail-

over and stress testing of servers for production implementation. Developed custom SQR’s to identify object

customizations prior to Tax Upgrades.

Wal-Mart Corporation

Designed and developed mainframe COBOL batch processes to automatically load third-party competitor pricing

data into DB2 and Teradata databases. This data is used as input to Teradata and SAS Price Modeling algorithms to

ensure competitive pricing on Wal-Mart grocery items. Processes were developed using DB2, COBOL, JCL, SAS,

Easytrieve, IMS databases, Teradata Pump (TPUMP), Teradata MultiLoad (MLOAD), and Basic Teradata Query

Language (BTEQ).

Lowes Corporation

Consultant responsible for design and development of conversions and interfaces in support of PeopleSoft Accounts

Payable 8.4 module implementation. Developed programs to convert legacy Vendor information into PeopleSoft

Vendor tables. Developed Electronic Funds Transfer (EFT) extract program to extract PeopleSoft Accounts Payable

transactions for transmission to the bank (EDI format 820). Developed batch JCL to execute PeopleSoft delivered

Accounts Payable Pay Cycle processes through mainframe z/OS scheduler and Unix System Services. Processes were

developed using Application Designer, DB2, COBOL, VSAM, JCL, BMC utilities, and XPEDITOR.

MeadWestvaco Corporation, Dayton, Ohio January, 2001 –

September, 2002

Senior Systems Analyst

PeopleSoft 8.3 Upgrade: Infrastructure Team Lead responsible for installation and configuration of PeopleSoft 8.3

Internet Architecture on PeopleTools 8.17. Completed initial build of PeopleSoft “vanilla” database using delivered

Datamover scripts Configured Application and Report Server domains using Windows NT/2000 servers. Developed

OS/390 batch server environment on Unix System Services. Created and configured Unix System Services JCL Shell’s

to perform Payroll/HRMS batch processes. Coordinated tasks for installation of Websphere on Windows NT/2000.

Responsible for maintenance and development of Mead PeopleSoft 7.5 HRMS and Payroll systems. Various system

fixes and development projects were completed using PeopleTools, PeopleCode, SQR, COBOL, JCL, and IBM DB2

utilities.

Interactive Business Systems, Dayton, Ohio November, 1994 –

December, 2000

Staff Consultant Client: Lockheed Martin

Corporation

Programmer/analyst responsible for development of batch and online enhancements to the Air Force Equipment

Management System (AFEMS) utilizing PACBASE applications generator, COBOL II, CICS, Assembler, JCL, SQL,

VSAM, and DB2. PACBASE development breakdown included approximately 60% online repetitive category CICS

programs, and approximately 40% batch report entity and control break processing programs.

Developed online and batch programs for an in-house solution to automate the process of adding and maintaining

system user ids. This system creates direct interface feeds to update user id information in TSO, CA-Top Secret, CA-

Dispatch, DB2, and EMC2 (email).

Electronic Data Systems, Dayton, Ohio June, 1985 - October,

1994

Systems Engineer Client: General Motors

Acceptance Corporation

Served as programmer/analyst responsible for maintenance and development of GMAC financial systems

applications. These systems include Credit Evaluation, Acquisitions, Payments, Inquiry, and General

Ledger. These applications were maintained using: CICS, COBOL II, PACBASE applications generator,

VSAM, VM/CMS, ACF/TPF, Assembler, Sabretalk, PL/1 and JCL. PACBASE development breakdown included

approximately 50% online repetitive category CICS programs, and approximately 50% batch report entity and control

break processing programs.

Education

Southern Illinois University, Carbondale, Illinois. Bachelor of Science, Data Processing, 1985.

References

Available upon request.

Contact this candidate