WORK EXPERIENCE:

API Integration Developer

Confidential

Responsibilities:

• Lead IBM Power 9 Upgrade project upgrading from a Power 8 to a Power 9 Using Mimix HA. Lead Power 9 to Power 9 on IBM SAN project. Deployed 5 new LPAR s to support Springs ERP Upgrade Project. Lead numerous Performance improvement projects as well as validating API calls using Postman. Developed Journaling replacement for Mimix HA after we switched to the San.

Lead iSeries DBA

Confidential

Responsibilities:

• IBM I Database and Performance monitoring using IBM iDoctor Job watcher and Performance Navigator. Developer SQL analysis and review. SQL Deployments and Journal Management. Developed automatic Journal management system using an audit journal scraper to automatically journal tables. Automated SQL plan Cache Reporting. Developed automated alter table and multi - threaded copy process to speed table alters for SQL. Developed fully automated table reorganization process to run Reorg while active. Involved in Power 9 with Vios and LPM and SRR upgrade project.
• Managed Power 6 to Power 7 Hardware upgrade together with Operating System 5.4 to 6.1 on the IBM i including upgrading third party tools, also during this time coordinated the IBM i component of a data center move. Carried out day to day tasks on the IBM i including backups and scheduled job setup using advanced job scheduler.

Senior DB2 DBA/IBM i Engineer.

Confidential

Responsibilities:

• IBM I Database and Performance monitoring using IBM iDoctor Job watcher and Performance Navigator. Developer SQL analysis and review. SQL Deployments and Journal Management. Data replication configuration and maintenance using Mimix. LPAR monitoring and management. Deployed IBM i System upgrades to 6.1 and 7.1 of IBM i OS together with third party product upgrades. Developed system dashboard for IBM i monitoring and load testing.
• Project and Technical lead for the deployment of new Power 6 hardware and the V5R4 IBM i to V6R1 IBM i OS upgrade. Project and Technical lead for the migration of WEA's data warehouse from the development partition to a stand alone production partition. Implemented Single Signon solution on the IBM i. Implemented IBM InfoPrint, automated PDF emailing and SharePoint distribution services from the IBM i. Implemented column level Encryption on the IBM I DB2 database. Deployed Net IQ and Bsafe Security solutions.
• Setup and configure Data Mirror High Availability on the iSeries. Performance tuning and day to day maintenance of the iSeries DB2 database. Configuring alerts for Tivoli monitoring for DB2.

Synon 2E/Cool 2E Consultant.

Confidential . Deerfield, IL

Responsibilities:

• Analysis, Design and Programming on the iSeries (AS400) in Synon (AllFusion 2e) and ILE RPG for Inventory Systems. Enhancing Scan out systems and designing and implementing automated ftp processes with enhanced auto recovery.
• Monitoring and managing 1700 SQL Server databases on 100 + windows servers within the Data management department. Installed and configured SQL 2000 and 2005. Carried out performance tuning and trouble shooting, Carried out backup and recovery. Configured and maintained Data Mirror Transformation Services. Installed and configured DB2 on AIX and Windows and developed the implementation strategy for DB2. Worked to configure Tivoli storage manager to work with DB2 on AIX and windows. Experience using DMS and SMS databases. Configured and installed Tivoli monitoring for Databases on SQL Server and DB2.
• 8 Week project to develop back end processing system for web based parts replacement process. Written in Cobol/CL and interfacing with ASI's manufacturing software.
• Design End to End Controls process for Order to Cash system at Kraft Foods.

Senior Consultant/Partner.

Confidential

Responsibilities:

• Database Administrator on the iSeries/As400 at Harley Davidson. Setting up SQL Triggers, managing security, setting up and supporting Data Mirror Transformation Server and Data Mirror High Availability. Journal maintenance, backup and recovery, SQL table design. Provided technical support for database related issues.
• Consultant at Kraft Foods. Designed and developed Web based Order Management system. Major Enhancements to Pricing and Invoicing system. Integrated credit checking into Order Management system. Provided technical assistance to employees.
• Consultant at Aon Home Warranty. Developed mass E-mailing system in C++, designed Web Agreement entry system. Developed Warranty address de-duplication system and designed claim locator system. Developed sales and marketing reports and FTP/EFT applications for a large insurance company.

Senior Consultant/Partner.

Confidential

Responsibilities:

• Developed realtime mainframe/As400 Client server solution. Developed multiuser Sales order processing system in Visual Basic 4.0. Produced tools to convert Multi Media viewer documentation to Html and VB Script. Developed Sales reporting system in Visual Basic 3.0. Involved in performance tuning a Synon sales reporting system on the AS400. Developing AS400 applications for a sales order processing system in Synon and providing technical expertise as a consultant at a Fortune 500 company.
• Assignments included developing in-house Multi-Language Enablement tools. Provided technical expertise at client sites and managed Infomag Consultants.
• Designed and programmed AS400 Synon Order entry system and other support systems for order entry.
• Aided in the development of a waste receiving system using Synon 2 at Waste Management in Chicago. Designing programming and performance testing a Distributed database across an AS400 Network. Analyzing AS/400 performance, providing technical assistance with capacity planning.

Analyst Programmer.

Confidential

Responsibilities:

• Developed in-house mailing system using Synon 2. Provided enhancements to the order entry and distribution systems. Acted as security officer and instituted change control systems.
• Developed Cost of sales system and Perpetual inventory systems. Interfaced to MAPICS and sales system for management reporting. developed source/program tracking system. Developed PC based Sales order processing system for a Printing company and developed a PC based payroll system for a manufacturing company.
• Developed management reporting and marketing tools instituting audit trails and programming included Insurance and catalog data entry systems on the System 38 using Cobol.