Post Job Free
Sign in

Data Manager

Location:
Greenbrier, AR, 72058
Posted:
August 24, 2011

Contact this candidate

Resume:

John W. Butts

Greenbrier, AR *****

Mail: ********@*******.***

cell: 501/581-1733

Professional Profile

PROFESSIONAL A multi-talented professional with exposure in the

Banking, Financial, Petroleum, Airline,

ASSETS: Credit, Retail, Insurance, Manufacturing, and Communications

Industries. With extensive

experience in the computer industry, current emphasis has been

in DB2/DBA, DB2 Systems Programming and Installation thru DB2

V9, DB2/UDB/Direct Connect, IMS/DBA, IMS DB/DC, CICS, SMPE,

Performance tuning, OMVS, WEBSPHERE, DB2PM, OMEGAMON, MAINVIEW,

SMF, DDF, AND SYSTEMS INTERFACE WITH ZOS SYSTEM PROGRAMMERS.

Programming, Systems support, Performance tuning, capacity

planning, debugging, Data Base Administration, and modeling

positions. Several years experience with applications written in

COBOL/ALC with VSAM files, DB2, and IMS. Written applications

in CICS, IMS, Batch, and stored procedures.

EDUCATION: University of Denver

SOFTWARE: DB2, QMF, DBEDIT, DXT, HDBV, AS, CSP/AD/AE, WEBSPHERE

DB2 ADMIN TOOL, DB2AM, DB2PM, OMEGAMON, MAINVIEW BMC, PLATINUM.Data

Propagator

CA Platinum suite Datacom DB/IDEAL/IPC/CICS/AD

CICS (Command and Macro) BMS,SDF

PEOPLESOFT SAP

AIX S/390

LINUX, Redhat UNIX

ORACLE 9I, RAC TOMAX Pricing

DB2 Universal Data Base (UDB) DIRECT CONNECT

MVS 2.10, ZOS 1.4 SMP/E, CB/IPO

JES2, JES3 OMVS

NETVIEW SMF

TSOE/SDSF/ISPF/NETVIEW/CLIST, CMS DFSMS, RMF, RACF

IMS DB/DC, MFS DBRC, IRLM

IEF(BSD, TD, Construction, Test, Installation, Encyclopedia)

BACHMAN (AN, DBA) STRATUS

KnowledgeWare (Planning, Analysis, Design, and Construction)

IBM Data Dictionary DBEXCEL

ERwin/ERX

ACP/TPF VTAM

MSA (Payroll, GL, IE) M&D (Payroll, GL, Millennium)

ADF TELON

HPS, Boole & Babbage

Word Perfect, EXCEL, Powerpoint, Query Manager, Microsoft Word

SQA/TEAMTEST LOTUS

OS2 MS-DOS/WINDOWS

LANGUAGES: COBOL, ALC, PL/1, SQL, SAS, REXX

HARDWARE: IBM and compatible mid to large mainframes, IBM PC's, RS6000,

Itanium servers

ACCESS DB2, UDB, ORACLE, SQL, IMS/DB (HDAM, HIDAM, HSAM), VSAM, BDAM,

METHODS: Watcom, DB2/2, XDB, Datacom DB

Apr - Curr Ingram Content Group, LaVergne, TN

2011 DB2/DBA \ DB2 Systems Programmer \

DB2 systems programmer. Install/upgrade DB2 V8 to V9 on four sub systems.

Initial planning, ZPARM analysis, Install Panels creation for four sub

systems, coordination with Systems, DASD group, applications and server

groups for production support. SMPE Receive apply and accept of base V9

system and supporting PTF's. USS library creation using HSF and ZSF .

Currently on-call for any problems that may arise while they are in CM

MODE.

Aug - Apr ACXIOM, Conway AR

2008 2011 DB2/DBA \ DB2 Systems Programmer \

DB2 systems programmer. Install/upgrade DB2 V7, V8, V9.V10 Installation

class. Installation of CA and BMC products and Data Direct. Install and

upgrade Ca Datacom DB, IDEAL, IPC, and CICS interface. Utilize SMPE (USS

library creation using HSF and ZSF ) and Create multiple SSID's for

multiple LPAR's in a SYSPLEX with data sharing and non-data sharing

environments. Global temporary tables and coupling interfaces. Bufferpool

management and system modification, including modification of JOIN limit

from 15 to over 35. Data Warehouse, WEBSPHERE, PEOPLESOFT Financials. MVS

2.8 to 2.10 upgrade and z/OS upgrade participation thru Z/OS 1.10. Disaster

recovery planning and offsite storage of 3590's. Peoplesoft support for

data bases and software installation. PeopleSoft's tool support for SQR.

PSOFT QUERY, and PSOFT NVISION. Peoplesoft data base re-alignment.

Splitting related tables into multiple table spaces and data bases for

easier maintenance, backup, and performance. On a daily basis I would check

and cross check the catalogs in all subsystems. Looking for reorganization

requirements, broken chains, and/or any other required maintenance for any

of the subsystems using REXX and manual queries. Given the repetitive

nature of maintenance, I create weekly maintenance reorg's and tuning jobs

for production and test environments to maintain the tables at a consistent

threshold of optimal performance.

May - Aug Newt Global consulting, Verizon

2008 2008 DB2/DBA \ Programmer

DB2/DBA and Consultant for development pf ODI (ORACLE Data Integrator)

interface to mainframe for PEOPLESOFT Applications. Created LISTDEF and

TEMPLATE logic as interface to DSNUTILS procedure for uploads and down

loads to ORACLE and DB2 UDB

March - April RSA consulting, The Grocers Supply Co.

2008 2008 DB2/DBA \ DB2 Systems Programmer

DB2/DBA and Consultant for Application support and SQL performance tuning.

V8 planning and installation. Triggers and stored procedures. MQ and OMVS

support. Business requirements and DataBase design, COBOL, CICS, REX, SQL,

QMF and DB2 Connect. Responsible for performance on System wide buffer

pools with TMON history tracking. DB2 and BMC utility support for

application cross-loading and backups and data migration. Plan table

analysis and performance recommendations. BMC installation. USS.

April - Feb IMS consulting, Stater Bros. Markets, Colton, Ca

2007 2008 DB2/DBA \ DB2 Systems Programmer

DB2/DBA and Consultant for Application support and SQL performance tuning.

PeopleSoft data base tuning, V8 planning and installation. Triggers and

stored procedures. MQ and OMVS support. Business requirements and DataBase

design, COBOL, CICS, REX, SQL, QMF and DB2 Connect. Responsible for

performance on System wide buffer pools with TMON history tracking. DB2 and

BMC utility support for application cross-loading and backups and data

migration. Plan table analysis and performance recommendations. BMC and

TMON installation.

June - March CTG Technology, Dallas, TX

2006 2007 DB2 DBA \ Application Analyst

DB2/DBA and Consultant for Application support and SQL performance tuning.

Business requirements and DataBase design, COBOL, CICS, REX, SQL, QMF and

Data Propagator. Responsible for tracking and analysis of CARDS system,

VISIO documentation, and quality assurance of SRS system for Rewards and

data warehouse. DB2 7.1 and DB2 UDB V8 interfacing with NDM transmissions.

DB2 and BMC utility support for application cross-loading and backups. Plan

table analysis and performance recommendations. Multi partitioning for data

warehouse, data loads, replication, and Data Propagator.

July - Apr Clarke American Checks, San Antonio, TX

2005. 2006 DB2/DBA \ DB2 Systems Programmer

Partition multiple simple and segmented table spaces that were reaching

maximum capacity of 2GIG. Install DB2 7.1 and V8, from Release tape to SMPE

. Create 8 SSID's for 3 LPAR's, global temporary tables. Bufferpool

management and system modification. MVS 2.8 to 2.10 upgrade and z/OS 1.4

upgrade participation. DB2 UDB for z/OS version 8 installation

documentation, planning and technical preview. Disaster recovery planning

and offsite storage of 3590's.

Oct - June Raley's. Sacramento, Ca

2001 2005 DB2/DBA \ DB2 Systems Programmer \ Oracle DBA

Install DB2 7.1, from Release tape to SMPE (USS library creation using HSF)

and addition of PUT0212. Create 8 SSID's for 3 LPAR's in a sysplex with

data sharing, global temporary tables and coupling interfaces. Bufferpool

management and system modification, including modification of JOIN limit

from 15 to 20. Data Warehouse, WEBSPHERE, PEOPLESOFT Financials. MVS 2.8 to

2.10 upgrade and z/OS upgrade participation. DB2 UDB for z/OS version 8

installation documentation, planning and technical preview. Disaster

recovery planning and offsite storage of 3590's. Current schooling and DBA

experience on ORACLE 9I with RAC on multiple Titaniums under LINUX Redhat,

for TOMAX. Peoplesoft support for data bases and software installation.

PeopleSoft's tool support for SQR. PSOFT QUERY, and PSOFT NVISION.

Peoplesoft data base re-alignment. Splitting related tables into multiple

table spaces and data bases for easier maintenance, backup, and

performance. On a daily basis I would check and cross check the catalogs in

all subsystems. Looking for reorganization requirements, broken chains,

and/or any other required maintenance for any of the subsystems using REXX

and manual queries. Given the repetitive nature of maintenance, I create

weekly maintenance reorg's and tuning jobs for production and test

environments to maintain the tables at a consistent threshold of optimal

performance.

Feb - Oct Siebel Systems, INC., San Mateo, Ca

2000 2001 DB2/DBA \ DB2 Systems Programmer

Install DB2 6.1, from Release tape to SMPE and addition of PUT0003. Upgrade

of DB2 to 7.1. Create 28 SSID's for 5 LPAR's in a sysplex with data

sharing, global temporary tables and coupling interfaces. Assist in ZOS

upgrade of new Z900 series. Bufferpool management and system modification,

including modification of JOIN limit from 15 to 45. MVS 2.8 to 2.10

upgrade.

Sep - Feb Sprint,Kansas City, Kansas

1999 2000 DB2/DBA \ DB2 Analyst

Develop logical and physical database design and recommend database design

guidelines and technology standards to developers. Conduct application

database and SQL design reviews and provide problem resolution and

performance tuning. Buffer pool tuning and advise on release 6

characteristics. On-Call support for 24X7 systems availability. Provide

Technical support and evaluation of online reorgs for both IBM and BMC

tools.

IGATE MASTECH consultant : Feb, 99 - Aug,1999

June - Aug VISA, San Mateo, California

1999 1999 DB2/DBA \ DB2 Systems Programmer

DB2 system generation V5 and V6, data migration, and conversion

to OS/390 platform. Database Administration interface and

product evaluation. Y2K compliance testing. BMC tools MasterMind

and QMF installation,

Mar - June IBM at HOMEBASE, Irvine, California

1999 1999 DB2/IMS Systems Programmer

DB2 and IMS system generation, data migration, and conversion to

OS/390 platform. Y2K compliance testing. BMC tools MasterMind

and QMF installition. AIX and RS6000.

Feb - Mar. IBM at AVNET, Phoenix, Arizona

1999 1999 LE 370 Analyst

Performance tune LE 370 (Language Environment) on a new OS/390

installation.

Feb IBM at ADP, Moorestown, New Jersey

1999 DB2 Analyst \ DBA \ Universal Data Base (UDB)

Short term UDB installation for OS2/WARP and Windows NT servers.

Jul - Jan Intel, Folsom, California

1995 1999 DB2/DBA \ DB2 Systems Programmer \ Oracle, employee

Develop logical and physical database design and recommend database design

guidelines and technology standards to developers. Conduct application

database and transact SQL design reviews and provide problem resolution and

performance tuning. Provide day-to-day database object maintenance, manage

security access and permission and manage application capacity and

forecast. Provide database backup and recovery, load and unload data, and

routinely monitor and adjust space usage for transaction log and database.

Work with application teams deciding database design tradeoff, Transact SQL

tradeoff and implications. Provide customized database training and

mentoring for developers. Gather database technical requirements and

perform special case or benchmark studies. Participate in new technology,

tool evaluations, new releases and upgrade testing. Installation and

performance tuning of DB2 V3 and V4 and preparation for data sharing and

installation of DB2 V5. DB2 PLATINUM products include Fast Recover,

Database Analyzer, RC Migrator, Rapid Reorg, Quick Copy.

Apr - Jul PCS, Scottsdale, Arizona

1995 1995 DB2/DBA \ CICS \ DB2 Analyst

CICS DB2 performance analysis for existing systems, reducing system

transaction processing times to acceptible levels and training the

programmers in efficient SQL coding. CICS coding and testing.

Aug - Apr First Interstate Bank, Phoenix, Arizona

1994 1995 DB2/DBA \ DBEXCEL Data Repository \ DB2 Analyst, employee

Data Repository data modeling for the corporate data model and conversion

of the INFOBASE (Model 204) data model. Database Administrator of multiple

financial systems including daily performance monitoring and tuning, DASD

space integrity and compression, and production data warehouse loading

(history and archival). Installation and performance tuning of DBEXCEL and

DB2 release 3.1 and the physical data structures I have implemented in DB2.

Support software included EXPLAINS, OMEGAMON, DB2/AM, and Platinum.

May - Aug. American Express, Phoenix, Arizona

1994 1994 DB2/DBA \ DBEXCEL Data Repository \ DB2 Analyst

Data Repository data modeling for the corporate restructuring of business

functions and the conversion of the current DATA DICTIONARY meta data used

with IMS and DB2. Modeling of the conceptual design and administrator of

the encyclopedia standards for the new corporate data structure. Analysis

and evaluation of the impact of GUI front end interfaces for the repository

and management. Performance tuning of DBEXCEL and the extended data

structures on the physical data base utilizing OMEGAMON and EXPLAINs for

the packaged software.

Dec - May HOGAN Systems, Dallas, Texas

1991 1994 DB2/DBA \ BACHMAN \ DB2 Analyst, employee

Enterprise data modeling, adhering to the IBM FSI conceptual data model

design, using the BACHMAN and KnowledgeWare tool sets, and SEER

Technologies HPS. DB2/DBA responsibilities for Forward Engineering of the

conceptual analyst data model, administering the meta data repository, DDL

generation, implementation and support of the generated DB2 tables.

Planning, Analysis, Design and Construction Work Station usage for ADW

Modeled financial applications. Modeling of the conceptual design and

administrator of the encyclopedia standards and data base through

construction (ERD Translation to the relational Schema, interface of the

encyclopedia to the GUI Construction, and the CICS/DB2 execution). Query

Manager data base creation and SQL development for listings of the analyst

physical and forward engineered physical models that were utilized by the

development teams. DIM View and Code generation on HPS. TPNS script

generation and data base coordination of the development applications for

performance tuning and system bench marking on CICS. Capacity planning for

the performance characteristics of the business processes as they apply to

the data model for the establishment of the performance goals projected for

the application. DB2/2 server data base creation and administration.

July - Dec Independent Consultant Assignments

1978 1991

Kaiser Permanente, Walnut Creek, California DB2 DBA

Cincinnati Gas and Electric, Cincinnati, Ohio DB2 DBA

State of Texas, Comptroller, Austin, Texas DB2 DBA

JC Penny, Dallas, Texas IMS/DB2 DBA

AMR, Dallas, Texas IMS/DB2 Systems Programmer

AT&T, Dallas Texas IMS/DB2 Systems Programmer

CENTEL, Lincoln, Nebraska IMS Systems Programmer

Pacific Bell, San Ramon, California DB2/DBA \ DB2 Systems

Programmer

CITICORP, Parsippany, New Jersey CICS Systems Programmer

Mountain Bell, Denver, Colorado DB2/DBA \ IMS/DBA and Capacity

Planner

Martin Marietta Data Systems I MS DB/DC, ADF.

BDM Corp. Datacom DB, CICS, COBOL/DL, Parts

inventory system for the Air Force.

First Interstate Services ACP/TPF, POS, CICS, Credit

card interchange and cash debit system

for oil companies.

Western Federal Savings CICS, ATMs, Savings and loans.

Northrop Corp. IMS, Data Dictionary, de-centralize

the data base.

Midland Federal Savings CICS, Mortgage Loan.

Petro Lewis DMS, ADSO, OLM, reporting systems and

internal analysis.

Anaconda Minerals CICS, DL/1, Data Dictionary, cost

accounting and MRP application

programming.

Boeing Computer Services CICS, DL/1, Data Dictionary,

Budgeting system.

Coors Brewing Co. CICS, DL/1, A/P, A/R, COPICS.

United Banks Service Co. CICS, NCP, sys-gen and on-line

manager responsibilities.

Mostek CICS, DL/1, A/P, A/R, budgeting.

SPR CICS, DL/1, Manpower Resource System.

Phillips Petroleum IMS, royalties, oil & gas

accounting.

Miller Brewing Co. MVS, JES2 modifications, creation

of a system resource scheduler.

Texas Instruments IMS, convert a cost scheduling

system.

Southwestern Public Service CICS, DL/1, Customer Acctg.



Contact this candidate