SUMMARY:

• Over 18 years of experience in design and development of legacy Mainframe applications with Social Security Administration (Federal Government)
• Telecommunications, and Auto and Home Insurance. I am an IT professional with expertise delivers strong technical solutions that solve business problems
• Built and managed teams that take pride in developing high - quality, dependable systems and services.
• Team player with excellent communication, coordination, documentation, project planning and interpersonal skills.

TECHNICAL SKILLS:

COBOL, CICS, DB2, VSAM, JCL, FILE: AID, TSO/ISPF, INTERTEST, QMF, SPUFI, ABEND-AIDMVS, OS/390, MQ Series, Web Services, Java, Ruby, Sync Sort, TOAD, Ab Initio, ETL, SeleniumPostgres, Amazon Cloud, PL/SQL, VersionOne, CCC, CLIST, REXX and XPEDITOR.

PROFESSIONAL EXPERIENCE:

Confidential

Senior Mainframe Developer

Responsibilities:

• Created work order work products in every phase of Software Development Life Cycle (SDLC) that includes Detailed Functional Requirements, Scope and Design Documents.
• Involved in architectural designing application’s meetings, demonstrated different architectural solutions with Proof of Concept (PoC) and explained the Pros and Cons.
• Created high level User and Specifications and exported them into Application Lifecycle Management (ALM) tool using Excel plugin.
• Developed application programs using COBOL, CICS, ASSEMBLER, JCL, VSAM, and DB2 technologies.
• Developed CICS-DB2 applications using WebSphere MQ for asynchronous messages to read and write data from Queues.
• Written complex SQL queries to perform data analysis using TOAD tool. This includes using temporary tables, sub queries, table Joins and Unions.
• Written COBOL programs to read data from IDMS into files. Converted the data from IMS/IDMS to DB2 by writing COBOL-DB2 programs.
• Involved in Agile/Scrum methodology and used VersionOne for creating/grooming stories. Confluence and Mattermost was used for documentation and communication.
• Built automated scripts and assisted with Unix KORN Shell scripting to set up CRON jobs.
• Performed API, Web Services testing using SOAP UI tool and back-end Mainframe system testing.
• Responsible for ETL mapping the source and target tables, modify the derivation rules and successfully loaded into Enterprise Data Warehouse using PL-SQL. Familiarized with Ab Initio and Informatica tools.
• Used Selenium tool for automated testing and set up framework. Developed scripts using RUBY and JAVA programming language.
• Analyzed and fixed data corruption issues and successfully restored production database from the backups/image copies using job flows, triggers, in-conditions, and dependencies.
• Managed and guided the team in the right direction and provided technical solutions to address system problems.
• Responsible for on call and provided support to troubleshoot the system abends in production environment.

Confidential

Mainframe Developer

Responsibilities:

• Responsible for the analysis, requirement gathering, coding, programming, and testing of mainframe based Office of Hearings and Appeals applications using COBOL, DB2, JCL, VSAM, CICS, and WebSphere MQ.
• Responsible for database conversion that includes data unloads, convert the data and load into the database using IBM DB2 utilities.
• Solved complex system/application performance issues by querying system catalog tables and running EXPLAIN, RUNSTATS and REBINDS.
• Coded embedded DB2 programs using Nested Table Expressions and Declared Temporary Tables (DTTs). Created and executed DB2 queries using QMF and SPUFI.
• Responsible for the disaster recovery and backup the data on VSAM/IDMS/DB2.
• Responsible for the code generation COBOL/DB2 programs using system catalog and DB2 tables.
• Used XPEDITOR tool to debug the batch programs to determine the exact cause of the abend.
• Extensive experience with the version control management tool ENDEVOR.
• Job Control Language (JCLs) were coded to run and test the COBOL/DB2 applications. Fixes the system problems while running the job.
• Converted Employer’s IDMS data from files into DB2 relational database.
• Responsible to prepare test data, debug programs and document all procedures.
• Bug Tracking Tool, PAIRS was used to open and close issue tickets.

Confidential, MD

Mainframe D eveloper

Responsibilities:

• Responsible for application development and legacy application maintenance for
• Personal Lines (PL) systems using COBOL, JCL, IMS, IDMS, ASSEMBLER and VSAM technology.
• Coded New York $1 Fee module as a part of Renewal process using CICS/COBOL/REXX language.
• Responsible for to run daily test ISTS cycles and resolved abends occurs.
• Communicated with the business users on a daily basis about the business needs and to get test data for validation.
• Responsible for the 24x7 production On-Call and make sure the on-line files are up by the next morning for business.
• Extensive experience with ZEKE/ZARA about scheduling of daily/weekly/monthly/yearly jobs.
• Version Control CCC was used in the development cycle. Resolves any conflicts while moving to production PROD from DEV/VAL.
• Abend-Aid tool was used to see the dump of a program and find out the exact cause.
• File-Aid tool was used for the faster search as well as to do file operations on VSAM files.
• Created 1320 to run the job from user defined library (DEV) instead of PROD to re-create 3380 and 3390 tapes which had problems in nightly production cycle.
• Coded required Job Control Language (JCLs) to drop bad policy records from the transaction files.
• Prepared the test data, ran ISTS cycles for regression/system testing and finally moved the code to Production.