PHILIP TRBOVIC, Jr.
Willowbrook, IL 60527
Email: *.*******@*******.***
Summary
Over 30 years of IT experience
Over 25 years of experience as a DB2 DBA
Over 8 years of experience in People Soft
Over 10 years of experience in SAP
10 years of Oracle experience
Over 10 years of Project Management experience
Close to 2 years of working with the IBM Purescale product
Worked for major clients like United Airlines, Sentry Insurance, Blue Cross Blue Shield, KPMG, ShopKo Stores Inc., Sears Stores, Pfizer, Ameritrade, Exelon, Dupont, Raytheon.
Additional Details
Specializes in analysis, design, installation, and implementation of hardware configurations on a variety of different platforms.
Expertise in client server application systems as well as data warehousing on AIX.
Expertise in application software systems on Mainframe systems, PC workstations, as well as LAN based systems.
Experience includes extensive programming using multiple languages operating on several different hardware platforms. These platforms include IBM PC's, LAN’s, and large system mainframes as well as the Unix operating system.
Education
National-Lewis University – BAAS in Behavior Science 1985
Morton College – Associates in Data Processing 1983
Representative Accomplishments
01/ 2018 – 06/2018 Artech/IBM
Sr. Consultant
Performed DB2 instance upgrades on numerous servers from version 9.5 to 10.5
Performed DB2 database upgrades on databases ranging in size from a few hundred MBs to 15 TB.
Performed database restores to relocate databases between servers.
Participated in a PoC to implement TLS for DB2 on AIX and Linux servers
Environment/versions: DB2 LUW version 9.x, 10x 11x, AIX 7.2 Linux Redhat
2004 – 2018 CSC Consultant.
Sr. Consultant
Support multiple DB2 databases on Z/os
Support of very large SAP databases on both Z/os and LUW environments.
Performed database tuning using native DB2 commands and built-in SAP T-codes.
Created and maintained Core and custom z-tables within the SAP databases.
Support all UDB databases on multiple platforms.
Support over 130 Oracle databases across numerous servers.
Analyze business needs/problems and provide technical solutions focusing on migrating databases from the IBM data centers to the CSC data centers.
Resolve technical issues as they arose in a quick and efficient manner.
Created 5TB warehouse utilizing DPF and BCUs.
Converted several database instances from Windows to AIX
Upgraded 48 Node database from V8.2 to V9.2 of UDB
Installed and tuned V9.7 of UDB for clients around the world.
Upgraded over 1000 DB2 LUW Instances from Version 9.5 to version 10,5
Upgraded numerous 10.5 LUW databases using purescale
Performs Business Continuity testing quarterly on both Oracle and DB2 databases.
Migrated multiple mainframe DB2 database to Linux DB2 10.5.
Environment/versions: DB2 UDB version 6.1, 7.1, 7.2, 8.1, 9.x, 10x 11x, AIX 4.3, 5.2, Solaris 4x, Sun 9, Linux ; Oracle 9i, 10g, 11g; z/OS 1.4; Linux Redhat
06/2004 – 07/2004 IBM Consultant.
Sr. Database Administrator
Banta Digital, Menasha, WI
Completed configuration of the Production PeopleSoft Financials 8.4 application using DB2 LUW 8.1.
Analyzed business needs/problems and provide technical solutions focusing on the AP, AR, & GL modules. Provided tuning of SQL produced from these modules.
Resolved technical issues as they arose in a quick and efficient manner.
I worked closely with customer’s business objectives and system requirements for the PeopleSoft HRMS 8.3 development environment.
Environment/versions: DB2 UDB version 8.1, AIX 5.2
2003 – 06/2004 ShopKo Stores Inc.
Sr. Database / PeopleSoft Administrator
Green Bay, WI
Provided rotational on call 24-hour support for escalated Intranet urgent issues and outages. I also participated in the tool sets Choose appropriate tool sets and architectures to implement solutions.
Completed maintenance development, configuration, and reporting tasks on existing internally developed and purchased systems.
Analyzed business needs/problems and provide technical solutions. I worked closely with Content Management Coordinator, content experts to understand customers’ business objectives and system requirements for Intranet web based applications and web site development.
Acted as a liaison between the Corporate System Team and the IT System Development Teams in assigning larger scale web-based applications.
In my role as a DB2 UDB DBA, I performed performance tuning for all DB2 database environments and maintained the database changes on a daily basis. Environments included the Corporate Data warehouse.
Project Led the Technical Team in Implementation of PeopleSoft 8.8 CRM using DB2 LUW .
Environment/versions: DB2 OS/390 version 6.1, DB2 LUW 8.1, Oracle 7.3.4, Oracle 8.1.7, Oracle 9i, Microsoft SQL Server 7, AIX 4.3 - 5.2
02/2003 – 07/2003 United Airlines
Sr. Database / PeopleSoft Administrator
Chicago, IL
As a DB2 Database Administrator, I led the conversion project of the PeopleSoft benefits package from version 3.2 to version 7.5. This database was successfully converted in less than 8 weeks. My primary responsibility was to insure that all data was converted correctly and to mentor the PeopleSoft Administrator in testing the new version of the software. Al so built and implemented backup and recovery processes within DB2 LUW to backup and to insure recoverability. The database resides on OS390. I was maintaining server and middle tier software essential for the PeopleSoft environment; coordinate database changes, complete environmental administration, apply updates and patches, and administer enterprise security. I also played a key role in responding to support needs and suggestions from the end-users.
Provided rotational on call 24-hour support for escalated Intranet urgent issues and outages. I also participated in the tool sets Choose appropriate tool sets and architectures to implement solutions.
Completed maintenance development, configuration, and reporting tasks on existing internally developed and purchased systems.
Analyzed business needs/problems and provide technical solutions. I worked closely with Content Management Coordinator, content experts to understand customers’ business objectives and system requirements for Intranet web based applications and web site development.
Acted as a liaison between the Corporate System Team and the IT System Development Teams in assigning larger scale web-based applications.
In my role as a DB2 DBA, I performed performance tuning for all DB2 database environments and maintained the database changes on a daily basis.
Wrote very simple JAVA programs to verify database connectivity and to perform data extraction using SQL.
Created a demo project in PeopleSoft 8.3 HRMS. Performed gap analysis between 7.5 and 8.3.
Environment/versions: DB2 OS/390 version 7.2, DB2 LUW 5.0, 5.2, 6.1, 7.0, 8.1
2002 – 2/2003 Sentry Insurance, WI
Consultant /UDB DB2 DBA
Stevens Point, WI
As a Database Administrator consultant, supported the Content Management database for a leading Insurance company in the state of Wisconsin. This database resided in UDB and utilized the Siebel product along with IBM’s Content Manager, Websphere and MS Series Workflow products. I developed several scripts to execute both online and offline backups of the databases, scripts for recoverability of the database, along with scripts to maintain the statistics for performance tuning.
Environment/versions: DB2 OS/390 version 7.2, UDB 7.2, Websphere 4.0, Content Manager 1.2, AIX 5.2, Shell Scripting
6/2002 – 10/2002 State of Wisconsin – DWD, Madison, Wisconsin
Consultant/DB2 DBA
Madison, WI
I led the conversion of the Voice Response database from IDMS to DB2. This effort involved creating the new database in DB2, and assist in converting old IDMS programs to work with DB2. I worked with the applications development group to create DB2 packages and DB2 plans to execute their converted programs.
I also developed and conducted several DB2 training classes focusing on the various components of DB2. I geared each training class for the audience and modified the training materials to reflect the specific skill sets of the audience I was teaching.
Environment/versions: DB2 OS/390 version 7.2
1995 – 2002 Blue Cross Blue Shield, Chicago, IL
Systems Supervisor/ UDB DB2/ DB2 DBA / PeopleSoft Administrator/Project Manager
Chicago, IL
Managed two upgrade projects of PeopleSoft HRMS from version 6.12 to version 7.56 to version 8.14 as well as upgrading the PeopleSoft Financials application from version 7.541 to version 8.14. My role in this project was to manage the project plan and coordinate the activities of a team of about 60 people across various groups of the company, which spread across 7 states. I worked with the PeopleSoft System Administrator to coordinate all patches and application upgrades. I became very fluent in the PeopleSoft Upgrade tool. I played a key role in and deploy the security, support, and maintenance of the Corporate Systems servers and associated software. Coordinate server upgrades and complete application upgrades.
Provided direction, mentoring, and assistance to less experience technicians during the project life cycle, client interactions, and troubleshooting process.
Responded to support needs of the end-users.
Provided rotational on call 24-hour support for escalated Intranet urgent issues and outages.
Maintained detailed project plans, identifying any potential deadline problems before they become critical.
In the role of project leader, I was in charge of a team of 5 DBAs assigned to our PeopleSoft initiative. This initiative consists of two packages: HRMS and Financials. We are in our final phase prior to implementation of the HRMS product. The HRMS system contains 8 DB2 databases across 3 subsystems. Each database contains a little more than 60 tablespaces, 1500 tables and nearly 2500 indexes
Managed the Database Administration activities to implement an e-Business solution for the corporation’s membership system. This involved installing DB2 LUW 6.1, Websphere 3.0, and MQ Series workflow Manager on both AIX and NT platforms. My role was to oversee the installation and tuning of the various products that interacted with the database, as well as the tuning requirements of the database itself. The initial inquiry only rollout was successfully implemented in less than 4 months. This implementation involved maintaining over 20 Websphere servers serving thousands of Internet clients.
Managed the installation of the Siebel tool suite. This product was brought in to help perform document management throughout the corporation. I managed the installation of the product on the AIX platform and worked with representatives from IBM and Siebel in order to develop the most optimal network topography to serve the corporation. This project required that I become more deeply involved with contract negotiations between the various vendors. These negotiations included purchasing hardware, software, and acquiring contractors to assist in the installation.
In my role as a Database Administrator, I oversaw the installation/upgrade of the DB2 LUW software for the corporation. We upgraded from version 3.1 to version 4.1. version 5.1, 6.1, and currently to version 7.1. This involved performing the required maintenance to the DB2 catalog on 3 different subsystems. I also changed the Zparms in order to take full advantage of Type 2 indexes, new subsystem recognition characters, and stored procedures.
Created, with management’s approval, a virtual Database Administration team. The purpose of the team was to allow cross training of the DBAs across the various applications, which they supported. This also allowed the User community to call any DBA and have their questions answered. I managed this team of 6 other DBAs.
Project managed the design, creation, and implementation of a DB2 database which supported a redesigned Membership system. The project is a multi-phase design, which spans multiple years. The first phase that was implemented into production was the Account Maintenance Release (AMR). The AMR database contains 88 tables in 88 tablespaces with 73 Referential Integrity constraints. Underwriter Approval added an additional 40 tablespaces and tables and 53 indexes. Billing increased the database by an additional 78 tablespaces, 82 tables, and 112 indexes. We are currently in the testing phase of the Members release. This release has added another 80 tablespaces and tables, and 120 indexes.
Implemented a Customer Service database in DB2. This database was integrated with a Client/Server application, which allowed the Customer Service Representatives to access the database through GUI screens developed in Powerbuilder. The connection from the Server to DB2 was established through Gupta software.
Supervised a team of consultants through implementation of a new Corporate Provider database. This new database will incorporate data that is currently stored in 6 different flat file databases. This new database was built in DB2 and using Client/Sever technology as well as incorporating Internet capabilities.
Worked on the project team to implement a new asset management system. . This new system will use the Tivoli Systems Inventory Database, Remote Control, Software Distribution, and the Tivoli Event Control database. The inventory database uses DB2 UDB for AIX. The TEC database utilizes Oracle. I am acting as lead DBA on this project and have 2 other DBAs reporting to me.
Led the initiative to convert the PeopleSoft HRMS application from the use of Centura’s SQLHOST to using IBM’s DB2 Connect. This involved coordinating the activities of several people from different departments within the company. My role also included contacting the vendor and arranging our support schedule. I also had a small part in the negotiating of the service contact with our vendor.
Environment/versions: DB2 OS/390 version 7.2, LUW 7.2, Websphere 3.0, Shell Scripting
1992 - 1995 KPMG Peat Marwick Management, Chicago, Illinois
Sr. Programmer Analyst / DB2 DBA
Chicago, IL
Implemented over 100+ LAN workstations utilizing Novell’s NetWare for OS/2 for a leading financial corporation. This included installing all software and setting up all hardware. This also included training the staff in how to use NetWare for OS/2 as well as in the use of OS/2.
Managed a hardware configuration/security audit for a leading wireless communication corporation, which consisted of conducting a full audit of their hardware and software. The audit also included evaluating the possible gaps that were found in their security procedures.
Project managed a hardware configuration/re-engineering initiative for a leading lending institution, which consisted of re-engineering a credit loan processing system and downsizing it to PC workstations. The downsizing included acquiring the workstations, installing al the networking cards, installing the networking software as well as the programming software. The re-engineering effort also included converting all the programs in the system and porting them down to the workstations.
Developed and implemented a Data Capture system for the state of Tennessee. The system allowed the state’s staff to input their time and attendance information through a Common User Interface developed for their workstations. The system interfaced with the Labor Distribution and Cost Allocation system, and posted the appropriate information to the proper accounts. The system utilized DB2 MVS, UDB, AIX, NT, IMS, and CICS.
Acted as the Technical Manager during the implementation of a Labor Distribution and Cost Allocation system for the state of Tennessee. This involved overseeing the purchasing and installation of the workstations that contained interfaces to allow IMS databases and DB2 tables to communicate to each other within the same programs. This system operated within both online CICS as well as batch COBOL II environments. This system was installed in all the various state agencies.
Developed and implemented a software configuration management system for a leading financial corporation. The system assisted staff in identifying the interrelationships between components and assessing the complexity of enhancement efforts. The system utilized DB2 and ISPF.
Developed a static analysis tool for determining the complexity of BAL programs. This tool was developed using Microsoft Access and Visual Basic.
Environment/versions: DB2/MVS 5.1, UDB for AIX 5.0, LUW/NT 5.2, Shell Scripting
1991 - 1992 First Card, Elgin, IL
Senior Analyst
Developed a model for predicting possible bankcard fraud through various analysis tools.
Developed a Data Model for a credit card portfolio analysis database and the database is DB2.
Developed ad hoc queries to assist bank management in the decision-making processes of the bank.
Developed statistical reports using SAS
Environment/versions: DB2/MVS 5.1
1990 - 1991 The Signature Group, Schaumburg, IL
Senior Programmer/Analyst
Assisted in converting a mainframe based telemarketing system to a PC workstation system. The conversion consisted of installing new PC workstations for migrating VS Cobol applications on the mainframe to Micro-Focus Cobol on the PC. The database was DB2
Lead a team of analysts in enhancing a retail sales system for a major Chicago-based department store. The enhancements included converting old programs from VS Cobol to Cobol II.
Environment/versions: DB2/MVS 4.0
1989 – 1990 Spiegel Inc, Oakbrook, IL
Senior Programmer/Analyst,
Assisted in hardware design, installation, and implementation as well as the software developing an EIS system for upper-management. This system utilized state of the art technology using touch screens and a magnetic card entry in order to logon to the system.
Managed a team of analysts that migrated Spiegel’s Master Inventory File from a VSAM/CICS system to a DB2/CICS system.
Manually converted master item file system written in Assembler to Cobol II. This project also required writing interfaces to DB2 and CICS.
Environment/versions: DB2/MVS 4.0, DEC/VAX VMS
1986 - 1989 Metromail Corporation, Lombard, IL
Senior Programmer
Designed and programmed a sophisticated matching program that utilized various types of matching criteria. This program was parameter table driven.
Developed numerous list-processing programs that merged client lists with Metromail’s database. These programs would apply demographic criteria and remove all duplicates from the client lists.
Programmed dozens of form letters for different mail order companies and record clubs. These programs were written in BAL.
The database system was DB2 and Adabase.
Environment/versions: DB2/MVS 4.0, Adabase
1985 - 1986 Borg-Warner Acceptance Corporation, Chicago, IL
Programmer
Migrated an accounting software package from DOS VSE to OS MVS.
Installed McCormick and Dodge Payroll package. Incorporated all incremental updates of the package.
Developed ad hoc reports to assist management in the decision making process. These reports were written in RPG on a System 36.
Environment/versions: DB2/MVS 4.0