SUMMARY:

• Many years of data processing experience with manufacturing, distribution, utility, government, insurance, health, royalty distribution, retail and ERP system environments (SAP, PeopleSoft, and Lawson) working as a
• Data Administrator/Database administrator using DB2 (z/OS & LUW), IMS, Oracle for Windows NT, MS Access, VisualFoxPro and CASE Modeling Tools and as a system developer/Supervisor/Team Lead using application generators, report generators, and design methodologies.

PROFESSIONAL EXPERIENCE:

Confidential, State of Texas

DB2 Assessment Expert

Responsibilities:

• Identification, assessment, and solution determination of Performance Issues
• Used BMC MainView and AppTune to determine issues
• Used Data Studio, Virtual Indexes, and Visual Explain
• To verify and document solutions
• Developed Daily Health Check Procedure and Spreadsheet
• Using BMC Mainview data and statistics capture
• Developed Peak Period SQL Monitoring and Spreadsheet of Results
• Captured Peak Period Daily Top 10 SQL based on CPU usage
• Developed a procedure and spreadsheet of CP and zIIP usage
• For DB2 started tasks and SQL
• To estimate CPU saving by adding an index
• Verified CPU savings using BMC AppTune
• DB2 Performance Expert
• DB2 Performance Improvement involving:
• Evaluated dynamic SQL
• To determine what could be done to make the SQL zIIP eligible
• Tested changes to verify zIIP processer was used and CP reduction
• Did a Proof - Of-Concept
• To show that COBOL programs could be replaced by Native Stored Procedures
• Checked the performance and results
• To show that DB2 Sequence Object could be used to produce unique ID
• Checked the performance and results
• Performed Daily DB2 Help Check to identify and correct performance issues
• Performed Morning, Afternoon, and Night DB2 Help Checks during Peak Period
• Produced Top 10 SQL Day and Night during each monthly Peak Period day
• Developed a Batch Process to produce the Top 10 SQL report using BMC AppTune
• Helped make SQL, Index, and Procedure changes
• That saved 1000+ CPU hours a year

Confidential, Madison WI

Database Architect

Responsibilities:

• Re-engineering tables to keep physical model upto date
• Review Database Design
• Review SQL using Data Studio Visual Explain
• Tune SQL using Virtual Indexes and Visual Explain
• Convert from OmegaMon DB2 to Mainview DB2
• Populate New Subsystem to test new CICS
• Maintain Stored Procedures to support Web Apps

Confidential, Cedar Rapids IA

DW DB2 DBA z/OS

Responsibilities:

• Tuned Long Running Data Warehouse Processes
• Orphan Delete Process
• Data Governance Process
• ETL SQL
• Designed, Coded, and Tested a Migration Database Load Program in COBOL
• Developed Data Studio Queries for Migration Database Issue Reporting
• Used Data Studio, Visual Explain, Declared Global Temporary Tables, and Virtual Indexes to tune SQL to improve Data Governance Reports and Aggregate Table Population
• Monitor ETL Power Exchange Loads

Confidential, Kentucky

SAP DB2 DBA z/OS and SAP DB2 DBA LUW

Responsibilities:

• Monitored ECC during Open Enrollment involving 140,000 enrollmentsDeveloped SQL to identify Portal tablespaces and indexes that need reorganizing
• Performed Monthly Reorgs using dbacockpit and TSO
• DB2 v10 implementation
• Helped with -904 documentation and testing IBM's Resolution
• Upgraded SAPCL
• Configured dbacockpit and SAPCL in v10 environment
• Converted LOBs to InLine LOBs
• Identified tablespace with best improvement
• Developed and documented Procedure
• Documented Storage Savings and Performance Improvements
• Documented procedure for non-SAP environments
• Converted tablespaces to Partition By Growth using SAP ICNV
• Configure dbacockpit and SAPCL on Cloned ABAP and Portal Environments
• Develop and Use procedure to reorg tablespaces in Advisory REOrg
• Train System Administrator and Basis Members on SAP DB2 DBA procedures
• SAP DB2 DBA LUW - BW, Redwood Scheduler, and BSI Tax
• Setup and cataloged LUW databases in dbacockpit
• Performed Daily Health Checks
• Caught Backup failures and helped with resolution
• Tuned poor performing SQL
• Performed Monthly Reorgs of BW databases
• Developed Catalog SQL to determine which tables and how times a day they were automatically reorganized
• Setup IBM Data Studio to help with administration
• Setup Dell's TOAD to administer and monitor DB2 LUW if SAP's dbacockpit is not available

Confidential

SAP DB2 DBA z/OS

Responsibilities:

• Performed Services from Resolving Technical Issues to Database Server Sizing to Go-Live Analysis and Problem Resolution
• Solved Buffer Pool Performance Problems, SQL performance Problemsand ZPARM changes using SAP Tools
• Identified Issues with Dynamic Statement Cache, Buffer Pools, RID Pool, and Tablespace that needed to be moved to another Buffer Pool using SAP Tools
• Did the database part of a Solution Management Analysis involving ZPARMS, Buffer Pool, EDM Pool, and Dynamic Statement Cache check and Tablespace and Indexspace size check, and Statement Cache Analysis using SAP Tools
• Did services from Technical Integration Check through Go-Live Service
• Worked with both DB2 9.1.5 and 10.1.5 and help resolve Temporary Work File issues involving RID Pool Shortages

Confidential

IMS DBA

Responsibilities:

• System Interface Discoveries involving scans and investigation of
• System Functional Spec written and approved
• Conversion Technical Spec to produce SAP iDoc data written and approved
• Consulted, Supervised, and check results of offshore development
• Three conversion programs written and unit tested to produce iDoc data
• Program written and tested to update Purchase Order Item Master from SAP input
• 5+ Work Product Inspections
• 6 sets of Test Plans and Cases to have proof the conversions work
• Put 4 conversions into production using a Remedy process involving Cab meetings and JSOX documentation
• Ran and checkout 4 conversion against production data with HP Quality Center to track defects and completion of conversion test cases
• Designed End-to-End Test Plan and Cases to prove the interfaces to the Purchase Order System works
• Developed and implemented SQL to fix data problems
• Coordinated DB2 structure changes in Test, QA, and Production - Sandbox
• Helped Developer with SQL problems and questions
• Researched and tuned SQL that was performing poorly by identifying an index change to get DB2 to use the correct index and efficiently
• Documented production object changes with test results, approvals, object move requests, move results, and checked changed results
• Researched, unloaded, downloaded, and updated (Checkout and Checkin) Technical Specs, Test Plans, and Test results in SharePoint
• Developed, Unloaded and updated Knowledge Transfer Documents in RPM
• Conducted Knowledge Transfer sessions using SABA
• Confidential all times I used my DB2 and IMS knowledge to improve the processes and to help the other Team Leads and developers.

Confidential

SAP DB2 DBA z/OS

Responsibilities:

• Large Object Report (Make sure no objects were near 64 GB dataset limit)If getting close, open Solman Ticket for SAP group and a HP Service
• Master ticket to track to resolution
• BW and SC Runstat checking
• If not completed, check and run using DB13
• Setup new Planning Calendar enteries - DB13
• Take Offline Backups using Flashcopy
• Take Online Backups using Flashcopy
• Make a DB2 SAP Homogeneous System Copy
• Setup and Troubleshoot SAPCL
• Do Soft Failover
• DB2 Connect CLI Driver Maintenance

Confidential

DB2 DBA z/OS

Responsibilities:

• Created two new tables and 76 trigger to be used to feed updates to other systems
• Created trigger SQL to keep duplicate of the control table
• Used a trigger to populate an archive table on deletion of the original table row
• PeopleSoft DB2 DBA z/OS
• Managed the PeopleSoft Database upgrade (PeopleTools 8.49 and AP/GL 9.0)
• Created new Databases and Tablespaces and organized the new objects and reorged changed objects to free DASD space used by Drop/Create
• Split out large PeopleTools tables into their own compressed tablespaces to reduce DASD usage and improve performance
• Worked with PeopleSoft system administrator to tune PS/nVision reports after upgrade
• Determined DASD and upgrade time needed and worked with DASD administrator on making sure DASD was available

Confidential

DB2 DBA z/OS

Responsibilities:

• Purged, adjusted partitions free space and reorged archive tables to free up 28.5 GB of disk space
• Enhanced, Tuned, Executed, and Documented a PeopleSoft Database Purge Process
• Tuned a Purge Process that took over 6 hours and hadn't deleted many rows - after tuning the Purge Process took 8.5 minutes and deleted 11.1 million rows
• Enhanced, Executed, and Documented a Tablespace Partition Roll process - Making the Process, so it can be scheduled
• Created PeopleSoft Database to 9.0 for Demo system
• Resized Development PeopleSoft tablespaces for upgrade to PeopleSoft 9.0
• Change Test PeopleSoft Partitioning to handle this years Archive
• Added Index to tune 10+ SQL statements
• Tested new version of BMC tools and identified a COMPARE problem
• Copied Production PeopleSoft Data to Environment using Unloads and Loads
• Maintain, Implement, Tune and Upgrade DB2 Databases (Z/OS V8) in a PeopleSoft Environment and other insurance application environments
• Used Change Manager's Compare to identify differences between new version and old version of Exceed
• Used BMC's LOG MANAGER to back out database changes do to a bad CDR
• Standardized and Migrated a new table using BMC Change Manager
• Migrate Production Data to Test using BMC Change Manager
• Monitored and tuned SQL using BMC's MAINVIEW, AppTune, and SQL Performance For DB2
• Used BMC Change Manager's Compare to tell the database changes between Exceeds new release and the old release
• DB2 Cleanup and Testing DB2 after Maintenance
• Developed and Tested a process to FREE old and invalid DB2 Packages before applying DB2 Maintenance or a new release
• Develop and Implemented a check list of BMC Tools and DB2 Features that need to be tested after maintenance is applied

Confidential

SAP DB2 DBA z/OS

Responsibilities:

• Maintain, Implement, Tune and Upgrade DB2 Databases (Z/OS Data Sharing Environment) in a SAP Environment
• Installed V9 of DB2 UDB on Z/OS in multiple DB2 Subsystems (Data Sharing).
• Researched new features of DB2 V9 that would help in a SAP Environment (zLinux). Researched and tested "Partition by Growth" to eliminate a 64GB restriction on large SAP tablespaces. Developed "Partition by Growth" procedure for Transparent Tables and one for Cluster and Pool Tables.
• Tested and developed procedures to compress indexes. Calculated the index compression savings and what bufferpool to use.
• Developed queries to determine custom indexes not being used.
• Helped test fail over and back in a Data Sharing Environment to keep SAP going in case of a DB2 Subsystem outage.
• Tune SAP SQL using SAP SQL trace and Visual Explain
• Approve Transports to production of Tables and Table changes
• Helped research DB2 and Query Monitors to help in performance tuning.

Confidential

DB2 DBA z/OS

Responsibilities:

• Design, Implement, Tune, and Refresh DB2 Databases (Z/OS Data Sharing Environment) in a Lawson ERP Environment
• Create, Maintain, and Enhance DB2 Lawson product lines using the Lawson dictionary and commands
• Design and Implement Lawson DB2 Database conversion from 8.0.2 to 8.0.3
• Work out database performance problems in converting 8.0.3 Lawson DB2 databases to 9.0 Lawson DB2 databases
• Performance tune Lawson DB2 database access and physical databases
• Design and implement new partitioning for large tables (1 to 150 million rows) to help with parallel company processing
• Test DB2, DB2 Connect, and DB2 tools after DB2 upgrade from 7.1 to 8.0
• Maintain and Enhance the DB2 Performance Testing environment

Confidential

DB2 DBA z/OS

Responsibilities:

• Design, Implement, and Tune DB2 Databases (OS390) DB2/OS390 in a Royalty Distribution environment
• Plan, Test, and Implement Refresh of unit test and system test subsystems
• Help with the installation of 7.1 of DB2 and resolve any issues
• Built new Image Copy Jobs to reduce end of volume tape problems and speed up the process
• Help setup and resolve issues with Strobe…Help Applications with the use of Strobe
• Tune many application programs with long running SQL
• Setup tables and packages for new release of QMF for Windows
• Design tablespace partitioning on four large tablespaces to spread out disk requirement and speed
• Setup, and tested RUNSTATS job to runstat only the first 3 to 5 columns in the index

Confidential

DB2 DBA z/OS

Responsibilities:

• Design, Implement, Tune, and Refresh DB2 Databases (OS390) in a Lawson ERP Environment
• Create, Maintain, and Enhance DB2 Lawson product lines using the Lawson dictionary and commands
• Maintain and Enhance the DB2 Performance Testing environment

Confidential

DB2 DBA z/OS and Developer (z/OS and OS2)

Responsibilities:

• Analyze, Design, Implement Major Enhancements to Parts Ordering System with Data Modeling responsibilities (Logical and Physical)
• DB2, IMS, CICS, KnowledgeWare ADW
• Analyze, Design Enhancements to Parts Ordering system (DB2, IMS, CICS) using Endeavor scans, DB2 FileAid, FileAid, Infopac, BMC Catalog Manager, etc.
• Design and Enhance Logical and Physical Data Model using MS Access, KnowledgeWare, and Rexx Programs
• Support CICS table (PCT, PPT, RCT) maintenance using CATS and CEDA

Confidential

DB2 DBA z/OS

Responsibilities:

• Tune DB2 Databases (OS390 and UDB on AIX)
• Design, Implement,) and application SQL DB2/OS390
• Warehousing Database support and tuning both database and SQL (up to 60 million row tables) using Platinum tools, INSIGHT, and DB2 Utilities
• PeopleSoft DB2 DBA z/OS included adding Tax Letters using Platinum tools, Insight, and DB2 Utilities
• DB2 DBA LUW on AIX
• Policy/Claim Processing Database support and tuning large databases (up to 15 million rows) and SQL (up to 9 table joins) using DB2 Utilities, Snap, AIX utilities, and Quest Central for DB2 UDB on AIX.
• Resolved 5.2 to 7.1 issues and tuned performance problems (7 to 9 table joins).
• Policy/Claim History Database conversion from Informix to DB2 UDB on AIX.
• Policy/Claim Warehouse support involving support and tuning of adhoc query and report processing that uses Rocket Shuttle, SAS, MS Access, Query Man, and QMF.
• Used Quest Central for DB2 to tune, monitor, and make database changes.
• Converted large Policy/Claim tables from DB2 UDB on AIX and DB2/OS390 to Teradata using OLE Load and Teradata Utilities

Confidential

Responsibilities:

• Permanent consultant position, on assignment Confidential the following clients, some simultaneously

Confidential

ORACLE DBA

Responsibilities:

• Designed and Documented Oracle Databases, Installed Oracle for Windows NT (7.3.3 & 8.0.4 - both client and server), Installed Personal Oracle for Windows
• Created Databases, Tablespaces, Tables, Indexes, and Referential Integrity on Oracle Server (7.3.3 & 8.0.4) and Personal Oracle (8.0.4), converted dBaseIIIplus data to Oracle using MS Access utilities and queries (Server and Personal), and migrated data for Server to Personal Oracle and back

Confidential

Data Migration Analyst

Responsibilities:

• Documented differences between old and new databases and helped with the conversion - FoxPro / MS Access DBA - maintained VisualFoxPro tables, compared old and new database design and converted dBaseIIIplus and Rbase data using MS Access, and Loaded FoxPro tables

Confidential

DB2 DBA z/OS (DB2 on MVS)

Responsibilities:

• Documented database design, estimated space requirements, setup reorgs

Confidential

Team Lead

Responsibilities:

• Assessed (TELON, Easytrieve, and COBOL) using in house developed ProVision 2000 (MS Access and Visual Basic)
• Received source code using QualStar MF tape drive (UNIX), FTP, and E-Mail
• Renovated lines of code identified in the planning phase
• Assisted with the with Unit Testing
• Setup Unit Test Environment including MicroFocus COBOL and CICS, DB2 for windows, and resolved problems with MF COBOL and CICS and DB2 for windows

Confidential

Team Lead

Responsibilities:

• Assessed using in house developed ProVision 2000 (MS Access and Visual Basic) MF COBOL, SQL, FOCUS, Easytrieve, and many other languages

Confidential

DB2 DBA z/OS and DA/KnowledgeWare - Data Administration/Database Administration Consultant (MVS)

Responsibilities:

• Tuned a large time and attendance system (online averaged 1000 sql calls per tran and one second response time)
• Enhanced the KnowledgeWare Support System (OS/2 DBMS) that utilize and report new ADW 2.7 facilities and develop procedures to add physical characteristics to the Physical Data Model so that complete DB2 table DDL could be generated and used.
• Maintained and enhanced (both delivered and custom tables), applied tax letters, backed up and recovered, tuned, and moved data from one subsystem to an other for D&B HR and Payroll (GEAC Series-m)
• Developed and tested DB2 tuning procedures and educated the DBAs on these procedures.
• Develop a system to keep track of DB2 table growth.

Confidential

Senior Contract Programmer

Responsibilities:

• Made program changes to EDI programs (COBOL) and wrote new COBOL and CA Earl programs to balance EDI transmission data to received EDI data.

Confidential

Senior Consultant

Responsibilities:

• Developed an Information Strategy Plan for an old Data General/PC network/MacIntosh network shop

Confidential

DB2 DBA z/OS and DA - MVS/CICS & KnowledgeWare

Responsibilities:

• Redesign a critical IMS segment to a partitioned tablespace for performance
• Develop, test, and implement a KnowledgeWare Support System (OS/2 DBMS) that produces customized reports, checks entity and attribute names, produces physical column names from a business name, and SAA field level help information from the KnowledgeWare Encyclopedia (OS/2 Remote Data Services and REXX - OS/2 DBMS programming).
• Develop procedures to take a Logical Data Model in KnowledgeWare and produce a Physical Data Model and DB2 tables.
• Produce normalized DB2 tables from Logical Data Models, and maintain a Corporate Data Model Encyclopedia (120+ tables and many changes).

Confidential

DB2 DBA z/OS - DB2/CICS/CSP on MVS

Responsibilities:

• Supervise a Database Administration group for a major development project Confidential that included 353 tables with over 4000 columns, 4000 views, 900 programs, and over 1200 Database changes. This system design involved a large amount of user input and the on-line system was written in CSP. Tuned the on-line system that averages about 150,000 transactions a day and has an average response time of nine tenths of a second.
• Design, program, and implement a PC based Data Dictionary. This system was written in Dbase III Plus and included 25 tables, 40 views, and 500 programs.
• Developed a system to determine tables that need reorganization and DB2 applications that need to be tuned.