Navistar , Warrenville, IL 2007-presentGlobal manufacturer and distributor of commercial and military trucks, buses, and vehicles. Data Base AdministratorSupported entire DB2 Z/OS production and test environments on Version 9 in addition to being sole DBA supporting IMS V9 databases in production and test.• Converted 332 databases in test and production from user defined to DB2 stogroups, eliminating database disk space issues occuring weekly.• Teamed with disk storage team to utilize extended attributes allowing larger numbers of extents from 123 to 255. • Teamed with disk storage team to create pool allocation strategy providing an intelligent approach to utilize four different DASD pools using exact primary and secondary allocations to create same size allocations to use and re-use without wasting cylinders.• Rewrote all DB2 Copies to utilize Templates, Listdefs, Shrlevel Change and Parallel options, enabling shop 24/7 availability.• Introduced new on-line reorgs, used for conversion to stogroups plus converted all prior reorgs to on-line, reducing database downtime to zero and freeing up massive space required for I and J datasets.• Created new intelligent utilities which automatically created and ran reorgs on indexes and tablespaces weekly when needed by calculations from runstats statistics in system tables. These on-line reorgs required no down time.• Created catchall utilities (i.e. if runstats hasn’t run for > 90 days and if no copy > 7 days then run, etc.).• Suggested and implemented Data Set Groups when IMS OSAM database reached 4 gig limit and broke segments into different files allowing each file to be 4 gig.

NewellRubbermaid, Freeport, IL 2006-2007Global marketer of consumer and commercial products.Data Base Administrator Supported DB2 V8 environment and implemented new features of this release and provided secondary Oracle support.• Supported development requests on DB2 UDB Version 8 Z/OS environment, including creating databases, tablespaces, tables, indexes and baselines.• Supported development requests on Oracle OEM, including creating tables, indexes, and field changes and migrating to other servers for production. • Created 30 jobs for rolling monthly partitions for DB2 V8 and changed from Index Partitioning to Table Based Partitioning a V8 option, automating the monthly partition roll process which eliminated the old reorg process. • Re-wrote BMC utilities to IBM utilities because BMC did not support table based partitioning until late 4th quarter 2007, allowing to move forward converting to Table Based Partitioning.• Responsible for full recovery of all production and test application tables in Disaster Recovery Exercise, using BMC Recovery Plus . • Provided 24/7 on call production database support.

WPS Health Insurance, Madison, WI 2003 – 2006Major health benefits providers in Wisconsin with significant government contracts for Medicare and TRICARE.Data Base Administrator Implemented a very large DB2 warehouse structure consisting of over 170 tables on each of three separate databases with a production size of over 10 terabytes, on DB2 Rel 7.1 on an IBM Z9000, Z/OS operating system.• Assisted data administrators with Erwin logical design.• Created load jobs based on triggers using CA-7, entailing the creation and maintenance of 510 separate load jobs with constant changes along with COBOL includes for developers.• Created standard copy jobs using Rel-7 listdef masking options at the database level which allowed additional tables to be added without requiring changes to JCL.• Set up disaster recovery procedures for warehouse environment and participated in semi-annual disaster recovery tests.• Participated in creating new standards for naming of DB2 objects with intent of using these names in masking situations of utilities. • Provided consulting and informal training to application programmers and end users.• Analyzed performance of queries, and suggested changes using Visual Explain tool.• Handled 24/7 on call production database support.

Hamilton Sundstrand Corporation, Rockford, IL 1979- 2003Global suppliers of technologically advanced aerospace and industrial products. Designs and manufactures aerospace systems for commercial, regional, corporate and military aircraft, and is a major supplier for international space programs. Data Base Administrator Staff SpecialistImplemented, designed and upgraded 150 databases in DB2/UDB on OS/390, 400 databases in IMS V6 in using Hidam, Hdam, and Shisam databases, created over 1500 PSB’s Created and supported databases on SQL Server and Oracle and created utilities necessary to support these databases in test and production environments.• Assisted data administrators with logical design of databases utilizing Erwin Data Modeler.• Created physical design of databases using Data Dictionary and TSO/ISPF using ACF2 security, Panvalet and Screen Plus for creating MFS.• Installed and implemented databases and related products on all platforms.• Assisted end users in accessing any data from the databases.• Analyzed physical requirements for databases during and after implementation into production environment. This included DASD requirements as application growth occurred, implementing new application databases, and modification of existing databases for performance reasons.• Provided consulting and informal training to application programming and end users.• Analyzed performance of implemented databases, reviewing SQL, and making necessary changes to the database environment for optimal performance.• Set up backup/copy and recovery/restore/reorgs and disaster recovery procedures for databases.• Responsible for other utilities such as transaction stops/starts, reorgs, and pointer checkers for production flows.• Provided 24/7 on call production database support.