PROFESSIONAL PROFILE

• Confidential TEMPhas an accumulated almost forty years of experience in data processing.
• Thirty - nine of those years have been spent working wif IMS in various technical capacities including his current role as a Senior Consulting Programmer/Analyst. In dis role,
• Confidential . Confidential TEMPhas written numerous complex online and batch IMS programs. Earlier in his career, while fulfilling his role of a DBA, he also assumed teh role of an IMS Systems Programmer and performed several IMS version upgrades, one of which was from version 7 to version 9.
• During one engagement as a consultant, Confidential . Confidential was teh sole IMS and DB2 DBA supporting teh complete test and production mainframe environment and was responsible for all facets of data base administration. As a testament to his effectiveness and success,
• Confidential . Confidential was retained in dis position for a prolonged period of time while delivering support and guidance remotely.

PROFESSIONAL EXPERIENCE:

Confidential,

Senior Consulting COBOL Programmer/Analyst

Responsibilities:

• Confidential . Confidential is currently performing in teh role of a Senior Consulting COBOL Programmer/Analyst.
• He is charged wif teh development, maintenance and modification of numerous and complex IMS DB/DC online and batch application programs for teh Confidential Assessor’s Office. Included in dis are teh coding of Message Format Services (MFS), Program Specification Blocks (PSB) and Application Control Blocks (ACB). In addition,
• Confidential . Confidential is responsible for supporting teh various production cycles and teh correction of problems which might arise.

Confidential

Senior Consulting DBA

Responsibilities:

• Confidential . Confidential performed dis engagement in teh sole DBA wif responsibilities which included teh entire mainframe IMS data base environment.
• These environments consisted of approximately 600 data bases, many of which utilized logical relationships and secondary indexing.
• DBA tasks included: data base design (entity modeling, normalization to 3rd normal form); teh coding, modification and generation of all data base descriptors, control blocks and structure creation; teh correction of data base performance issues utilizing a variety of tools such as OMEGAMON IMS, OMEGAMON DB2, OMEGAMON MVS; teh identification and resolution of application and data base problems; teh development of a data base backup and recovery/back-out strategy and its execution; providing data base technical expertise and support to teh application programming staff for efficient data base access and optimum performance; teh oversight and maintenance of teh
• Data Base Recovery Control (DBRC); teh formulation and enforcement of Data Base Administration policies and standards; teh development of teh Performance Dictionary (PerDict) for teh automatic identification and scheduling of data base reorganizations; teh upgrade of IMS to versions 5, 6, 7 and 9; teh periodic generation of teh IMS system; teh resolution of IMS system level problems; provided sole on-call 24x7 DBA support; teh entry of IMS commands directly, via an IMS console as needed. dis engagement was supported remotely.

Confidential

Senior Database Consultant (Part-time)

Responsibilities:

• During dis engagement Confidential . Confidential performed in teh capacity of a Consulting DBA co-responsible for teh test and production mainframe Property IMS system.
• Teh Property system consists of 500 data bases, 36 of which are logically related and have numerous secondary indexes.
• DBA tasks included: new data base creation and modification to existing data bases; providing technical expertise and support to teh application programming staff for efficient data base access and optimum performance; teh development of an automated disaster recovery (D/R) backup/recovery mechanism for IMS and DB2; teh resolution and correction of data base related problems; teh coding and testing of application COBOL IMS/DC programs for execution by internet JAVA programs via IMSCONNECT software.
• Participated in IMS V8 upgrade; provided on-call DBA support; teh entry of IMS operator commands directly via an IMS console as required.

Confidential

Senior Database Consultant (Part-time)

Responsibilities:

• During dis engagement, Confidential . Confidential performed in teh capacity of a Consulting DBA providing support for numerous full-size test and production DB2 subsystems.
• Tasks included: teh design, development, and implementation of all DB2 objects; performed production data refreshes of test subsystems, migrated objects to all test subsystems and into production, performance reviews of application program code prior to production implementation, successfully developed a proof of concept for teh use of DB2 triggers and stored procedures, successfully implemented teh first project to utilize triggers and stored procedures,
• Developed teh SmartReorg system which uses DB2 Real Time Statistics (RTS) which, among other functions, will automatically identify and schedule objects for reorganization.

Confidential

Senior Consultant (Part-time)

Responsibilities:

• During dis engagement, Confidential . Confidential performed in teh role of a Senior Consultant providing day-to-day support for Confidential ’s Confidential Care and Management system.
• Responsibilities included, but were not limited to: ensuring production transactions met service level commitments in regards to performance and availability, and undertook immediate remedial actions in teh event any did not. Additionally, for medium to large scale projects Confidential .
• Confidential would become an application team member in fulfilling teh role of teh project data base designer/developer who directed teh team on how best to access teh needed IMS data base data.
• Confidential . Confidential wrote application code using teh PCS language and teh Data Manager and Batch Data Manger software.

Confidential,

Senior COBOL Programmer/Analyst Consultant

Responsibilities:

• His responsibilities included teh modification and testing of numerous online and batch IMS programs. In addition, he coded MFS, PSB and ACB control blocks.
• Confidential . Confidential was also assigned teh task of providing IMS application program coding expertise to teh project team.
• He was also assigned teh task of identifying and eliminating application program performance bottlenecks. Confidential . Confidential ’s area of responsibility was teh Material Resource Planning (MRP) system for teh B2 bomber during its development.