We provide IT Staff Augmentation Services!

Sr. Consultant Resume

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
  • 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.

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Consultant

Responsibilities:

  • 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 Confidential 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
  • Performs Business Continuity testing quarterly on both Oracle and DB2 databases.
  • Migrated multiple mainframe DB2 database to Linux DB2 10.5.

Environment: 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

Sr. Database Administrator

Confidential, Menasha, WI

Responsibilities:

  • 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

Confidential, Green Bay, WI

Sr. Database / PeopleSoft Administrator

Responsibilities:

  • 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.

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

Confidential, Chicago, IL

Sr. Database / PeopleSoft Administrator

Responsibilities:

  • 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

Confidential, WI

Consultant /UDB DB2 DBA

Responsibilities:

  • As a Database Administrator consultant, supported the Content Management database for a leading Insurance company in the Confidential . 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

Confidential, Madison, Wisconsin

Consultant/DB2 DBA

Responsibilities:

  • 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 classes focusing on the various components of DB2.
  • I geared each class for the audience and modified the materials to reflect the specific skill sets of the audience I was teaching.

Environment: /versions: DB2 OS/390 version 7.2

Confidential, Chicago, IL

Systems Supervisor/ UDB DB2/ DB2 DBA / PeopleSoft Administrator/Project Manager

Responsibilities:

  • 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 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 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 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 in corporate 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

Confidential, Chicago, Illinois

Sr. Programmer Analyst / DB2 DBA

Responsibilities:

  • 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 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

Confidential, Elgin, IL

Senior Analyst

Responsibilities:

  • 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

Hire Now