We provide IT Staff Augmentation Services!

Analyst/programmer Resume

Pittsburgh, PA

PROFESSIONAL SUMMARY:

  • Seasoned professional with success in serving clients in the banking, insurance, hotel, telecommunications and manufacturing industries as well as government agencies.
  • Excels in Programmer/Analyst, Technical Lead and Subject Matter Expert roles.
  • Has over 30 years of analysis, design, programming, testing, maintenance and production support in IBM mainframe environments.
  • Places a premium on providing simple, clean solutions using good design and programming techniques.
  • Strives to constantly think outside the box to find the best answers to the user's requirements.
  • Excellent verbal and written communication skills and a proven track record of providing the best professional IT services possible.

SKILL:

COBOL

JCL

TSO / ISPF

DB2, SQL

VSAM

CICS

FILEAID

Rexx

IMS DB/DC, DL/I

JAVA

MQSeries

EASYTRIEVE PLUS

SAS

TELON

CAREER SUMMARY:

Analyst/Programmer

Confidential, Pittsburgh, PA

Hardware: IBM mainframes, PC’s

Software: Z/OS COBOL, JCL, DB2, SQL, TSO SPF/E, Rexx, MQSeries, CICS, CA - 7, NDM, PEGA, XML, Informatica, ETL, Oracle, Toad, Artifactory, uDeploy, Java, Javascript, web services, REST apis, JSON.

Responsibilities:

  • Created and maintained ETL systems for the CIM Outbound project using Informatica ETL. These systems involved high-volume transfer of data between distributed systems and the mainframe.
  • Worked in the CIM team to maintain and develop batch mainframe f eed processes to populate a DB2 table-based Data Element XML repository accessed by the CIM PEGA distributed systems.
  • Designed, coded and implemented online CICS programs for the OFM (Offer Management) back- end that serves the OFM PEGA distributed system.
  • Created tools in Rexx/ISPF to support CIM developer activities, many relating to the maintenance and reporting of the Data Element XML repository.

Analyst/Programmer, Technical Lead

Confidential, Baltimore, MD

Hardware: IBM mainframes, PC’s

Software: Z/OS COBOL, JCL, DB2, SQL, TSO SPF/E, Rexx, MQSeries, Testbase, Control-M, Java Swing

Responsibilities:

  • Worked in the DAT team to provide DB2 database backup and restore services using the Testbase product.
  • Designed, coded and implemented all of the DAT team's main subsystems (Backups, Accretions, Ad Hoc and Batch User). All of these subsystems are MQ messaged services supported by a client UI java front-end.
  • Designed, coded and implemented the MQ Messaging architecture for all of the DAT subsystems mentioned above. These use batch triggering to call a common messaged service api which generates and submits batch jcl to perform the subsystem tasks using Testbase.
  • Designed, coded and implemented a rich client app in Java Swing to provide a common standard user interface for all of the DAT subsystems. This app utilizes many different technologies such as FTP, JDBC, DB2 Admin stored procedures, TCP/IP Sockets and MQSeries to fulfill the many different types of client to mainframe interaction needed by the tool.
  • Created many developer tools in Rexx/ISPF, including many DB2-related tools, an MQ Message Manager, many reporting functions for the various DAT subsystems and many developer support tools such as a Control-M Schedule Editor/Manager and a FileAid-like file interface specifically for the DAT team's files. Created a Developer Workbench which provides a “browser favorites-like” interface for managing a developer's task-specific mainframe source libraries. A number of these tools were significant expansions/improvements on tools I had developed at previous sites.

Contract Analyst/Programmer

Confidential, Bethesda, MD

Hardware: IBM mainframes, PC’s

Software: Z/OS COBOL, JCL, DB2, SQL, TSO SPF/E, Rexx, Java Swing

Responsibilities:

  • I also once more performed analysis and rework on a number of components of the Confidential batch cycle with an aim to improve reliability and runtime efficiency.
  • This consisted of analyzing and optimizing data accesses and SQL statements as well as the restructuring and recoding of jobs and programs.
  • Substantially expanded and improved on the rexx tools I had created in my past time at Confidential .
  • The developer’s tools currently number over 30 and include complex tools such as a Mainframe File Navigator for easy access to frequently accessed files and a Source Code versioning system to maintain better control over historical versions of all types of source components.
  • Created a number of performance analysis and monitoring tools (in Rexx and COBOL) to aid in the optimization/tuning of the batch and online Confidential systems.
  • Created a number of Java Swing Client apps for use by mainframe developers and the Confidential Help Desk.
  • These included many apps to access and update Confidential data in such areas as Property Initialization and Forecast Level updates.

Analyst/Programmer

Confidential

Hardware: IBM mainframes, PC’s

Software: Z/OS COBOL, JCL, DB2, SQL, TSO SPF/E, Rexx, MQSeries, CICS, IBM Event Publisher, Control-M

Responsibilities:

  • Designed, coded and implemented the MQSeries Messaging architecture for the CIF Synchronization System which synchronizes changes to mainframe DB2 CIF datastores (monitored and captured by IBM Event Publisher), parses the XML messages and performs ‘data enrichment’ through CBA Party Service calls.
  • The enriched data packets are then sent as MQ Messages to an SAP application on an AIX platform.
  • The original messaging architecture for this project was poor (due to lack of MQ experience within the team), and I was able to provide a design more suited to the strengths of MQSeries messaging.
  • Created a number of developer utilities in Rexx/ISPF/COBOL, including an MQ Message Manager which allows convenient management of Queues with options to load/unload/browse/formatted-browse/clear messages and the ability to set triggers, set Get and Put inhibits and easily monitor queue message depths - all interactively through ISPF panels.

Contract Analyst/Programmer

Confidential, Bethesda, MD

Hardware: IBM mainframes, PC’s

Software: Z/OS COBOL, JCL, DB2, SQL, TSO SPF/E, Rexx

Responsibilities:

  • Provided Production Support for the Confidential hotel reservation and billing system consisting of a large batch COBOL DB2 system and a large number of DB2 Stored Procedures serving as a backend for the Confidential web-based online system.
  • Performed analysis and rework on a number of components of the Confidential batch cycle with an aim to improve reliability and runtime efficiency. This consisted of analysing and optimising data accesses and SQL statements as well as the restructuring and recoding of jobs and programs. This proved to be very successful, cutting runtime costs significantly.
  • Created a number of performance analysis and monitoring tools (in Rexx and COBOL) to aid in the optimization/tuning of the batch and online Confidential systems.
  • Performed training and mentoring to a small team of developers providing support for the Confidential system, particularly in the use of the analysis and monitoring tools.
  • Created a Stored Procedure Test Bed (in Rexx/ISPF), allowing developers to test their stored procedures and examine returned parameters/result sets from mainframe ISPF panels. This makes the backend testing of stored procedures significantly easier.
  • Due to the lack of developer utilities at this site, I developed an extensive collection of tools (in Rexx/ISPF) to provide services such as:
  • Mainframe email
  • Source code comparison reports for change control
  • DB2 Table and Index reports
  • DB2 Stored Procedure analysis reports
  • DB2 DBRM/Load module Timestamp checking
  • DB2 interactive SQL Explain reports
  • Formatted file viewing
  • Many application-specific utilities for the support and analysis of the Confidential systems.

Analyst/Programmer

Confidential, Baltimore, MD

Hardware: IBM mainframes, PC’s

Software: Z/OS COBOL, JCL, CICS, DB2, SQL, VSAM, TSO SPF/E, Endevor, Rexx, Java, WebSphere, Struts

Responsibilities:

  • Performed analysis and development of the Comprehensive Work Opportunity Support System (CWOSS).
  • This is a large web-based system for maintaining SSA Disability Ticket Holders.
  • Performed analysis of legacy mainframe COBOL CICS DB2 processes and DB2 datastores with intent to leverage this functionality and data in the new CWOSS system.
  • Designed, coded and implemented a suite of Rexx tools for software developer support and provided support and training on development of Rexx execs for system support.
  • These tools have proved very popular with mainframe developers and are now used widely in the LM team and also in SSA customer areas.

Contract Analyst/Programmer

Confidential, Friendship Heights, DC

Hardware: IBM mainframes, PC’s

Software: Z/OS COBOL, JCL, CICS, DB2, SQL, Expediter, MQSeries, VSAM, TSO, ISPF, Endevor, Rexx

Responsibilities:

  • Responsible for the conversion of a large Cogen application system to a newer Exceed package application. Both applications are COBOL CICS and DB2-based systems serving a web-based Confidential Billing Inquiry front-end messaged through MQSeries.
  • Redesigned and rewrote a number of large, hard-to-maintain COBOL programs using structured techniques with emphasis on code clarity to allow easier maintenance and enhancement. A particularly large and troublesome program now serves as a model template for conversion of these old programs.
  • Introduced SQL date handling and COBOL Intrinsic function techniques to improve the flexibility and performance of existing code.
  • Provided expertise in optimising the MQSeries driver programs utilized by the Exceed system.

Analyst/Programmer, Technical Lead

Confidential, Baltimore, MD

Hardware: IBM mainframes, PC’s

Software: Z/OS COBOL, JCL, CICS, DB2, SQL, VSAM, TSO SPF/E, Endevor, Rexx

Responsibilities:

  • Performed development and maintenance on the eQA System (Electronic Quality Assurance). This is a large COBOL CICS DB2 back-end for the web-based quality assurance system.
  • Performed redesign and development of the CPMS System (Case Processing Management), a large COBOL CICS DB2 based system serving a web-based front end.
  • Provided technical advice and assistance to team members and developers company-wide on issues spanning COBOL, DB2/SQL, CICS, Z/OS JCL, Rexx and other mainframe areas.
  • Converted a large assembler-based batch process with performance problems to a COBOL-based job using good Syncsort and file handling techniques. The job execution time was cut from over 5 hours to under 50 minutes.
  • Researched, designed and coded an SQL Metadata Extract Stored Procedure using COBOL Dynamic SQL. These techniques had never before been used at this site.
  • Researched, designed and coded Proof-of-Concept COBOL modules utilizing a range of powerful techniques such as:
  • Dynamically obtaining DDnames and associated DSNames (via PSA-TCB chain traversal)
  • Dynamic allocation of datasets using Environment variables in-program
  • Dynamic LISTCAT on GDG bases to provide G00V000 numbers in-program
  • Obtain PDS member lists in-program (utilizing ISPLINK)
  • Dynamic program storage allocation (utilizing LE-callable services)
  • All of these Proof-of-Concept programs are available for leverage in future projects and for developer training in advanced techniques.

Analyst/Programmer, Technical Lead

Confidential, Columbia, SC

Hardware: IBM mainframes, PC’s, Unix boxes

S oftware: APS, OS/390 COBOL, JCL, CICS, IMS DB, DL/I, OS/390 MQSeries, VSAM, TSO SPF/E, SmartTest, Endevor, FastList, NDM, HIPAA, EDI, FTP

Responsibilities:

  • Designed and Developed COBOL CICS IMS EDI Gateway systems for processing of EDI X12 Transactions for Commercial, Tricare and Wisconsin Claims systems. The systems use MQSeries messaging to transfer data between applications on OS/390 mainframe and Unix platforms.
  • Converted incoming HIPAA Claims to Proprietary format for Commercial Systems.
  • Produced specifications, coded and tested COBOL CICS IMS HIPAA applications.
  • Developed COBOL CICS processes to accept and translate EDI input including transaction sets 837 (Claims), 270/271 (Eligibility Inquiry and Response), 276/277 (Claim Status and Response), and 278 (Remittance).
  • Designed and developed COBOL MQSeries developer utilities for loading, unloading and maintaining MQSeries application queues.
  • Designed and developed tools for easy source change control and source comparison within the Endevor environment.
  • Provided support and mentoring to team members unfamiliar with the use of MQSeries.

Analyst/Programmer, Technical Lead

Confidential, Richmond, VA

Hardware: IBM mainframes, PC’s, Unisys A-Series

Software: OS/390 COBOL, JCL, CICS, DB2, Stored Procedures, SQL, SPUFI, OS/390 MQSeries, MQConnect, FTP, VSAM, TSO SPF/E, XPEDITER, CHANGEMAN, FILEAID, Strobe

Responsibilities:

  • Worked as Technical Lead. Designed, coded and implemented a messaging architecture for use between legacy Unisys applications and OS/390 Server applications. This architecture uses MQSeries on the OS/390 and MQConnect on Unisys.
  • Designed and developed a COBOL CICS MQSeries “heartbeat” message queue monitoring application which allows front-end monitoring of queue depths and performance and provides alerts for message queue overflows and other queue problems.

Analyst/Programmer, Technical Lead

Confidential, Washington, DC

Hardware: IBM mainframes, PC’s

Software: OS/390 COBOL, JCL, CICS, DB2, SQL, SPUFI, VSAM, OS/390 MQSeries, WinNT, AIX, MQSeries, NDM, FTP, TSO SPF/E, XPEDITER, PANVALET, Java, C++, FILEAID

Responsibilities:

  • Worked as Lead Architect in the design and development of 2 large COBOL CICS DB2 MQSeries Message-based systems: Eligibility and Benefits Determination. This involved conversion of COBOL CICS Legacy batch-oriented systems to messaged systems.
  • Worked as the Technical lead on the design and development of OC Online, a backend COBOL CICS DB2 system providing data server functionality for a new Java-based front-end system. This involved heavy use of MQSeries messaging architecture, both on the mainframe side, Windows NT boxes and a middle-tier AIX box architecture.
  • Designed and developed cleaner and better-coded MQSeries message drivers for all systems

Hire Now