Sr. Ims Dba Consultant Resume
SUMMARY:
- Over forty - five years of proven IT experience with a wide variety of technology responsibilities.
- Proven excellence in project management, requirements gathering, analysis and systems design, technical documentation, application/systems support and testing, technical training, help desk support, IMS data base administration, and systems integration for enterprise-wide applications.
- Achievements include successful project implementations, increasing customer satisfaction and measurably enhancing performance while lowering resource usage costs.
SOFTWARE EXPERTISE:
Task Software: Microsoft Office Suite including Word, Excel, PowerPoint, Outlook, Visio; Microsoft Project; Project Management Workbench
Legacy Mainframe Software: IBM DB/DM/System Utilities; BMC DB/DM utilities; z\OS mainframe utilities; COBOL; TSO/ISPF; CICS; Abend-Aid; Fast Path, (P)HDAM/(P)HIDAM, OSAM, VSAM (ESDS/KSDS); DBRC; JCL; CA File-Aid (MVS and IMS products); DBCTL; DCF; IBM Change Data Capture software (Consolidation and Publication Server)
Call Center Software: HP Service Desk (GM); HP Project and Portfolio Management; REMEDY (customer problem ticket system); RETAIN (internal IBM help desk software); SDP/Manage Engine ( Confidential problem ticket data system); SCCD/MAXIMO/DISPATCH (IBM Change Management software); CISCO Web-Ex Connect and CA (ADOA change management tracking software); ClearQuest/Reflections (Problem/Action record tracking)
EXPERIENCE:
Confidential, Virginia/New Jersey
Sr. IMS DBA ConsultantResponsibilities:
- Successfully maintained and monitored existing IMS database space utilization and built processes to manage space. This resulted in reduced application team down time due to unscheduled outages from lack of data base space.
- Collaborated with the application development staff in resolving day-to-day processing issues. Coordinated with the rest of the Technical Support team to design overall solutions when processes failures were time sensitive.
- Analyzed, planned and successfully implemented application/data base component changes as part of application quarterly release schedules. Utilized IBM's IMS Data Dictionary software to create and promote IMS PSB's, COBOL includes and COBOL copybooks as part of application release process preparation.
- Successfully coded and maintained IMS user exits, written in Assembler and COBOL, that were used in each application release schedule.
- Documented data base release procedures that had not been previously documented by predecessor staff.
- Collaborated with the Change Control team to coordinate database changes as part of application release processing.
- Planned and successfully tested system software components against all existing IMS test and production data base copies. This was done to insure "error-free" implementation while isolating problems that may have affected "live" data bases and users.
- Maintained standard backup and recovery processes.
- Maintained and documented the IMS Disaster Recovery processes.
- Responsible for IMS data base recovery and usability, as well as IMS data replication/publication, as part of twice annual Disaster Recovery/Continuity of Operations exercises.
- Handled the day to day processing of IMS data, to the DB2 and Data Warehouse processes, using IMS Change Data Capture (V9.5) software. Responsibilities include using the IMS Change Data Architect and IMS Change Data Capture for Consolidation Server and Publication Server (V9.5) software, along with using IBM File Manager software to provide real-time replicated data to over two (2) million customers. IMS data replication services are performed on six (6) non-Production and one (1) Production LPAR.
Confidential, Virginia
Sr. IMS DBA ConsultantResponsibilities:
- Took time off, after the completion of my last project assignment, for seasonal holidays and recuperation following successful rotator shoulder surgery.
- Attended “International Institute of Business Analysis ( Confidential )” Washington DC chapter meetings as well as the Confidential PM/BA convention in Virginia.
- Prepared to continue studies for Project Management (PMP) and Business Analysis (CBAP) certifications while enhancing my core competency knowledge.
Confidential, New Jersey
Sr. IMS DBA ConsultantResponsibilities:
- Moved back to Virginia, from Arizona, to accept a contract that allowed me to work from home.
- Supported an important customer, who required specific IMS DBA skills, with encompassing IMS data base application support.
Confidential, Arizona
Sr. IMS DBA ConsultantResponsibilities:
- Utilized IBM, BMC and CA utility software to image copy, restore, reorganize, measure and evaluate IMS data base stability, while maintaining maximum performance of over 40,000 IMS and DB2 data bases (across 13 JES complexes, 20 Confidential and 85 subsystem ID’s) in a distributed environment on a scheduled on-call basis.
- Co-authored the IMS portion of the “class room ready” data base curriculum that was used to train the GM applications teams across all divisions. The curriculum consisted of DB2, IMS, VSAM and Systems Architecture sections. The ensuing classes, and classroom documentation, were well-received and successfully presented.
- Provided IMS application support for application teams and infrastructure support to the IMS DBA leadership. This is all part of GM’s goal of “in-sourcing” key applications back into the US from various foreign locations.
- Provided IMS support during IMS V10 to IMS V12 implementation across all Confidential .
- Active co-subject matter expert (SME) supporting the successful planning, testing and implementation of IBM InfoSphere 'Change Data Capture' software into GM’s IMS test and production Confidential - by application. This software provides “near - real time” data from the mainframe to relational platforms (i.e., Oracle). It will eliminate GM’s ETL's used for manufacturing and other automotive functions. The budget savings will grow as the use of Confidential is expanded to other applications over the next several calendar years.
- Actively participated in all IBM Regional User Group ( Confidential ) functions in the Phoenix area. Participation kept our team appraised of new techniques and software innovations shared by the Arizona business community.
Confidential, Arizona
Sr. IMS DBA ConsultantResponsibilities:
- Utilized IBM and BMC utility software to image copy, restore, reorganize, measure and evaluate IMS data base stability, while maintaining maximum performance, of over 1000 data bases across multiple IMS Confidential, in a distributed state government environment, on a 24x7x365 basis.
- Shared project leader duties for the successful planning, testing and implementation of IMS V12 (across all IMS Confidential ) with the IMS Systems Programming leader.
- Provided in-house training to the Confidential Applications programmers and Operations Help Desk supervisors and staff regarding basic IMS processing and troubleshooting topics. Classes were well received and positive feedback was obtained.
- Evaluated, tested and provided possible recommendations of IMS data base vendor software including, but not limited to: IMS Cloning Tool w/data masking feature; BMC Online Reorg/Max; BMC Change Accumulation Plus; IBM Change Data Capture.
- Mainframe technical lead for the successful planning, testing and implementation of Change Data Capture software in Confidential 's IMS test and production Confidential . This software will eliminate Confidential ETL's used for photo and driver demographic data. The budget savings will grow as the use of Confidential is expanded to other applications over the next several calendar years.
- Actively participate in all IBM Regional User Group ( Confidential ) functions in the Phoenix area.
Confidential, Virginia
Sr. IMS DBA ConsultantResponsibilities:
- Took time off, after the completion of my last project assignment, for seasonal holidays and recuperation following successful knee surgery.
- Was an active member of the International Institute of Business Analysis ( Confidential ) Baltimore chapter and served on the Confidential DC Chapter
- “Re-Launch” Committee (Board member) as well as acting VP of Communications of the Confidential Washington, DC Chapter.
- Prepared to continue studies for Project Management (PMP) and Business Analysis (CBAP) certifications while enhancing my core competency knowledge.
Confidential, New Jersey
Sr. IMS DBA/Consultant
Responsibilities:
- Elicited and assimilated documentation, system requirements, operational standards and naming conventions related to the client’s test and production Confidential data base systems, resulting in the creation of lesson plans and training aids used in educating off-shore outsourced staff.
- Successfully trained off-shore outsourced staff to support the client’s IBM system architecture, adherence to all client operational standards, IMS data base administration techniques, REMEDY software usage, first level service desk troubleshooting, and problem resolution techniques. This resulted in the trained off-shore staff providing the client with 24 x 7 ‘off-hours’ system and application first-line support. The initial team that was trained in 2009 is still operational today.
- Provided second-level technical, operational and subject matter expert (SME) support to the client management, IT-related teams and applications developers, in the client’s IBM z\OS distributed corporate Confidential environment on a 24 x 7 basis, resulting in strong letters of performance sent to project management.
Confidential, Pennsylvania
Sr. IMS DBA Consultant
Responsibilities:
- Monitored growth, evaluated performance, documented changes to and maintained control of several hundred data bases across multiple systems in a distributed corporate team environment supporting client management and IT-related teams on 24 x 7 basis, achieving a reduction in “unscheduled” data base and client application outages.
- Performed numerous successful IMS data base recoveries, reorganizations and log synchronizations, resulting in superior application test and production data base performance in support of documented service level agreements (SLA). Software from IBM, BMC and other vendors was used to achieve consistent performance results.
- Presented monthly summaries of IMS database team activities to other management teams, which resulted in management making better collaborative business decisions.
Confidential
Sr. IMS DBA Consultant
Responsibilities:
- Monitored growth, evaluated performance, documented changes to and maintained control of hundreds of data bases across eight test and two production systems, providing superior data base application support to various financial and IT-related teams on 24 x 7 basis.
- Evaluated third-party IMS data base software tools, products and upgrades, in collaboration with customer Infrastructure Team members. Successfully completed verification(s) of IMS V8 to IMS V9 system software upgrades allowing for successful implementation(s) across all systems.
- Created project and implementation plans and test scripts for successful business initiatives such as: z\OS1.4 to z\OS1.7 migration testing, Production Manufacturing data base “purge” processing, and conversion of large production data base(s) from HIDAM architecture to HALDB architecture.
- Provided IMS DBA project support to application test teams, during their successful testing cycles, for applications scheduled for future migration to Web-based systems.
Confidential, Minnesota
IBM Level 2 Product and Customer Support
Responsibilities:
- Using effective telephone and interpersonal skills to assist a world-wide IBM customer base and supported approximately twelve primary IBM Data Management software products, achieving effective successful resolution of customer problems on a 24 x 7 on-call basis.
- Collaborated with remotely distributed systems programmers and product developers to resolve IBM product problems. Recreated customer problems to determine if product defects were present. Analyzed customer dump files, opened APAR maintenance, and provided customer follow-up contact until solutions were delivered and verified, yielding measurably improved customer satisfaction.
- Analyzed customer problems, researched solutions and produced numerous technical documents using the Document Control Facility (DCF), which were published in an IBM knowledge database for online customer access and self-service support.
- Supported IBM software product development teams via collaboration and rigorous testing resulting in the proven functionality of developed products.
