Mainframe Capacity Planning Lead/Db2 Systems Programmer
United Parcel Service
-Planned and presented capacity recommendations and appropriation reviews to corporate management teams-Collaborated with procurement for lease renewals and budget processes-Evaluated/coordinated group training needs based on performance reviews-Coordinated mainframe capacity activities with other support groups-Planned and coordinated application migrations to support rapid business growth-Analyzed, recommended and coordinated implementation of various vendor processor upgrades including IBM, AMDAHL and Hitachi-Analyzed and recommended application migrations for new data center-Evaluated, recommended and coordinated implementation of application contingency and disaster recovery workload configurations, application stress test environment-Evaluated vendor hardware proposals and new strategies including the first EMC Symmetrix-Evaluated several capacity and performance tools (BGS, STROBE, Candle, etc).-Using SAS: Designed and wrote capacity planning forecasting and trending system utilizing queuing techniques and algorithms, MVS performance reporting routines to support DB2 performance efforts, DB2 data-set allocation routine for enhanced placement to support improved DASD utilization, performance and availability, Hardware (CPU, Channel, CU and Device) cross-reference report for managing ESCON and non-ESCON equipment -Installation, Maintenance, restart/recovery and Performance of DB2 data sharing/Non-data sharing-Migrated to DB2 V4/V5-Implemented data sharing to support Y2K testing-Converted DB2 archive logging to DASD from tape to support data sharing in a Parallel SYSPLEX environment-Analyzed and eliminated performance bottlenecks in CICS/IMS/DB2 applications-Analyzed, recommended and implemented changes in DB2 subsystem infrastructure-Installed, tested and maintained DB2 authorization exit-Proposed and implemented improvements to DB2 maintenance processes