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.