SUMMARY:

Seeking a position as DB2 for z/OS systems programmer to facilitate in performance improvement, cost reduction, resource optimization, strategic planning, software conversion, Datacenter relocation or project management for a future oriented company.

SKILLS:

• DB2 Connect
• OnDemand
• OAM/DFsms
• RACF/Top Secret
• BMC - Tools
• Platinum Tools
• DB2 HA Server
• Data Sharing
• MS Office Suite
• MS Project
• Lotus Suite
• IBM GDPS
• Data Base Design
• DB2 Performance and Tuning
• OOD/UML
• Stored Procedures
• Data Warehouse
• DCF methods
• Project Management
• Cost Analysis
• Advanced Financial Policies
• Financial Statement Analysis
• Economic Thinking
• Money Markets
• Critical Thinking
• Decision Making
• Corporate Valuation
• NPV and IRR Analysis
• Leadership
• Budgeting
• Assembler
• COBOL
• PL/1
• CSS
• HTML/XHTML
• Java
• JavaScript
• REXX
• CLIST
• Shell scripting
• SQL
• XML/XSL
• IBM DB2 V10
• IBM DB2 V11
• IBM DB2 V12
• IBM DB2 LUW
• MySQL
• Oracle
• IDMS/DB
• IDMS/DC
• IBM CICS/TS
• TSO/ISPF
• SMP/E
• DFHSM
• WLM
• ISMF
• TCP/IP, SNA
• VTAM
• VSAM
• ICF-Catalog
• SDSF
• USS
• OmegaMon
• RMF
• Strobe z/OS,z/VM,z/LinuxLinux, Windows XP
• Apache/Tomcat
• WebSphere Suite

EXPERIENCE:

DB2 Systems Support

Confidential, Pompano Beach, FL

Responsibilities:

• Planned the DB2 support function for several accounts within IBM as contractual specified with their customers.
• Set - up of maintenance procedures to use for the assigned DB2 subsystems to be used for SMP/E maintenance, subsystem upgrades and new installs.
• Created and documented overview of current conditions of DB2 subsystems and their set-ups.
• Planned for security adjustments to comply with IBM standards.
• Planned and upgraded DB2 subsystems to DB2 for z/OS V10 NFM, V11 NFM and associated software.
• Reviewed DB2 for z/OS V12 upgrade procedure and necessary action to perform prior to upgrade subsystems.
• Investigated and documented procedures to upgrade related IBM software and third party vendor products to be compliant with migration to DB2 for z/OS V11 and V12.
• Inspected DB2 for z/OS data sharing environments to determine whether set-ups are proficient and valid to accomplish the requirements of the IBM customer.

DB2 Systems Support/Team Leader

Confidential, Fort Lauderdale, FL

Responsibilities:

• Led team of 5 DB2 Systems Programmer in migrating, installing, and supporting of 36 DB2 subsystems out of 212.
• Modified 12 DB2 subsystems to be none-stop systems (HAS) by creating 3way, and 4way data sharing environments.
• Designed the data sharing environments to use a fail-over strategy which would select a remote system in case of an unplanned outage.
• For maintenance purposes the local DB2’s where all in a DS environments.
• Prepared systems to upgrade from DB2 9.1 to DB2 10.
• Participated in IBM ESP for DB2 V11. Installed and customized CA-Tools to work with current versions of DB2.
• Defined SMP/E strategy to allow for easier maintenance and future upgrades, without changes to existing JCL in batch, online, and distributed.
• Installed and customized USS Java, and all related Java-DB2 classes.
• Monitored DB2 performance with CA-Mainview and OmegaMon for DB2.

Company Owner, DB2 Systems Support

Confidential, Chicago, Illinois

Responsibilities:

• Upgraded 2 DB2 Subsystems to DB2 V10. Set-up SMP/E environment for DB2.
• Generated required stored procedures and implemented them.
• Upgraded DB2-Admin Tools and Performance analyzer to version required for DB2 V10.
• Installed DB2 V10 via SMP/E to prepare for upgrade of 7 Data sharing and 4 standalone DB2 subsystems before end of 2012 to avoid extra charges for dual licensing.
• The upgrade was from DB2 V8, which IBM announced out of support, to DB2 V10 NFM.
• All the DB2 subsystem were on DB2 V10 CM by 12/15/2012 and 5 data sharing environments were on DB2 V10 NFM at that time.
• Systems were cleaned up and utilities, such as BMC, Platinum, and OmegaMon were upgraded.
• A review of set-ups and recommendation to improve performance and availability was done and presented to the customer.
• Recommendations for the upcoming upgrade of hardware and system software was created and submitted to customer for review.
• All subsystems were successfully migrated to DB2 V10 NFM by 01/12/2013.
• Investigated the use of FlashCopy™ for the SYSTEM BACKUP and SYSTEM RESTORE utilities, which at this time could not be utilized since other hardware and software products did not support it.

Assistant VP - Data Base Systems NA, DB2 Systems Support

Confidential, Weehawken, New Jersey

Responsibilities:

• Create, upgrade, and maintain DB2 Subsystems in z/OS LPAR environments for high-availability and COB requirements.
• Planned and managed the conversion of 6 AIX environments to one z/OS environment, using cost efficiency analysis, cost benefits analysis to determine the correct course of action and the project feasibility.
• Upgraded 18 DB2 subsystems from V6 up to V10 and created scripts to automate upgrade and maintenance procedures at a local environment to be distributed to all other environments across the globe.
• Designed and implemented a data base inventory application based on DB2, REXX, COBOL, ISPF, and Java to allow companywide management of each subsystem at any location.
• This application was used to automate several maintenance processes in the global environment, which led to cost reductions and a more effective management of the 174 DB2 subsystems in North America.
• Established standardization and naming conventions for new and existing DB2 subsystems to ensure uniqueness across all data centers worldwide and therefore reduce maintenance costs by about 30%. Worked with the system development team on the implementation of GDPS in North America based on corporate and governmental requirements.
• Created cost analysis for licensing to reduce unnecessary license overlapping and to reduce the number of identical products.
• Created suggestion to implement or exclude products into or from the company’s strategy which will reduce cost and increase efficiency over the long run.
• The savings here were significant considered the global environment.

Company Owner - IT Consultant

Confidential, Merritt Island, FL

Responsibilities:

• Created own WEB-Development and service company to provide services in WEB-Development and WEB-Hosting for small to medium sized businesses.
• Designed, build, and implemented a 4-tier hardware approach with back-up strategy for the company and its customers.
• Led several projects as a systems administrator for DB2, MVS, and CICS with focus on efficient development, higher quality of service, and a more future oriented approach.
• Designed and implemented COBOL/CICS application with access to DB2, Oracle, and IDMS data base systems in consideration of structure, maintainability, and runtime costs. Also worked with Java and developed stored procedures to reduce network traffic and costs.
• As project leader I have supported the installation, and customization of MVS, and OS/390 environments, also numerous application development projects with the focus on planning, time management, resource acquisition and requirements, knowledge transfer, check point and milestone implementation, cost efficiency, cost control, functionality tests, monitoring the compliance with the SLA and contract agreements, team building and motivating, and project completion tasks such as final sign-offs from customer.
• I incorporated the method of critical thinking for decision making to ensure that the outcome will be beneficial for the customer and the project.
• I have taught developers in the use of new ways to write programs, specifically in COBOL, and to use the new implemented function of the compiler during the Y2K activities and code modifications.
• Also, more recently, I have worked with other systems administrator groups to improve on performance and availability of their environment and application.
• I have led teams in several conversion projects with the focus on being future oriented and implementing new ways of looking at development, testing, and implementation of their application programs.
• Explained and introduced the philosophy of object orientation, structured programming, relational theory, and code efficiency.

Company Owner - IT Consultant

Confidential

Responsibilities:

• I worked on several projects in regards to converting a part of a large European manufacturing company from Siemens to IBM mainframe environments, a medium sized mail-order business from a /38 environment to MVS/ESA, and a pharmaceutical company from Oracle to SQL/DS and DB2.
• I have worked as a DB2/CICS systems programmer and supported installation, upgrade, and maintenance of the related products and their newest version.
• Also, I worked in design and development of COBOL/DB2 application for various business requirements with the in corporation of newest technologies to ensure business strategies and high quality of service.
• I have worked as a developer on projects of large scale such as Confidential, a reservation project in Europe at this time.
• Using customer guidelines to accomplish high availability, low costs, and low rejection and failure ratio were some of the requirements I had to follow.