OBJECTIVE:

Seeking to handle increasing responsibility and challenging assignment to harness my technical skills, knowledge and achieve recognition. To develop my career as a valuable team member, contributing quality ideas and work for an organization where there is ample scope for individual as well as organization.

PROFESSIONAL SUMMARY:

• Over 23 years of experience in MAINFRAME (TSO, ISPF, COBOL, CICS, DB2, IMS DB/DC, VSAM, JCL, TELON) Application Study, Design, Development, Quality Assurance, Implementation and Production Support.
• Proven ability to integrate mainframe applications with other interface i.e. SALESFORCE, IBM Integration BUS, and ORACLE using Transaction Server (CTS) & CICS Transaction Gateway (CTG) & IBM integration BUS as the middleware.
• Good understanding on REST/SOAP WEB SERVICES, Customer Information System (CIS)/ Customer Relationship Management (CRM).
• Worked extensively with automated tools such as CA - 7/CA-11 (Job Scheduler), debugging tools such as XPEDITOR/TSO and XPEDITOR/IMS
• Experience in structured methodology covering the entire Software Development Lifecycle (SDLC).
• Experienced in all project phases using Waterfall and Agile Methodologies.
• Manual testing for mainframe and Web-based applications which included White-Box Testing, Black Box Testing, Functionality Testing, Regression Testing, Performance Testing and Load Testing
• Proficient in writing test plans, test scenarios/test cases and documentation of test results.
• Experience in migration and implementing projects in the Federal, State, Health Insurance, Utilities, Accounting, Banking, Retail supply chain and Manufacturing Industry.
• Proficient in gathering client requirements through standardized documenting with functional, design, technical and program Specifications.
• Strong leadership, mentoring, communication skills, highly self-motivated, goal oriented and committed to timely delivery.

TECHNICAL SKILLS:

Languages: COBOL (I/II/MF/74/85/UNISYS), SCREEN COBOL (SCOBOL), TAL, TACL, PL1, DLI, CICS, JCL, C/370, C, Cold Fusion, Visual Basic, VB Script, JavaScript, Korn Shell, Pearl, PYTHON, HTML, XML, MQ Series, EASYTRIEVE.

OLTP Environment: CICS, CICS Web Services, CICS Transaction Server 3.1 (CTS), CICS Transaction Gateway (CTG), TCP/IP.

Database: DB2, DB2 UDB, IMS-DB/DC, IDMS, BSAM, VSAM, MS SQL Server, ORACLE, MS Access.

Reporting Tools: COGNOS (Impromptu, Power Play), Crystal Reports, DFSORT, VIS (Viewing Interactive System) Report, SAS

Other Utilities: ENDEVOR, TELON, Test Director, NET Express, Server Express, DB2 MQ Series Assistant, RUMBA, IBM WEBSPHERE MQ 7.0, XML4COBOL, CA-GENER/OL, BMS/GT, TWS/OPC, INTERTEST, WINRUNNER, Relativity, COOLGEN, OMEGAMON, XGEN, TSO, ISPF, BMC, PANVALET, MS Flight, CHANGEMAN ZMF, Expeditor, FILE AID, ABEND AID, CA-7, CA-11, QMF, SPUFI, TOAD, PL/SQL, SQL*Loader, Teradata SQL Assistant, MS DTS, SMARTTEST, SYNCSORT, MS Office, MS VIZIO, MS Project, ICETOOL, ERWIN.

OS: Microsoft Windows 7/10, Windows XP/NT, UNIX, AS/400, TANDEM, IBM OS/360/390, MVX, IBM z/OS, Mac OS.

PROFESSIONAL EXPERIENCE:

Confidential, Temple, TX

Mainframe programmer/Analyst

Responsibilities:

• Engaged in study, design, development, testing, implementation of E-COMM NEW CUSTOMER maintenance project creating COBOL/DB2 programs capturing data from MQ to update DB2 tables.
• Designed/developed/unit and integration testing on new COBOL/DB2 stored procedure programs.
• These Stored procedures later called by online user screen to add/capture/manipulate the DB2 data at the backend.
• Worked parallelly with production problem tickets which will be initiated through JIRA/ACTIVITY REPORTING SYSTEM for a better management for faster delivery.
• Worked on impact analysis to capture requirement/design/unit testing documentation uploaded in WIKI. Later to co-ordinate with Java team for system integration testing.

Environment: - TSO, ISPF, SCLM, CICS, COBOL, DB2, VSAM, JCL, XPEDITOR, AGILE, SCRUM, JIRA, WIKI, FILE-AID, FILE MANAGER, SPUFI, PLATINUM, IBM DATA STUDIO.

Confidential, AUSTIN, TX

Mainframe Programmer/Analyst

Responsibilities:

• Engaged in study/design/development/Unit testing/Creating Unit test plans with existing ATM Format Conversion and Confidential applications in COBOL/CICS/VSAM/DB2.
• As a part of conversion project, got busy creating flow chart detailing the JOB/PROC/PROGRAM flows, documenting the logic flow, data mapping between mainframe and OPEN systems and the data conversion.
• Handled COBOL upgrade project from 4.2 to 6.2 compiler version project for Treasury and Settlement system.
• This involves working with SCM to see all new processor groups are aligned in each ENDEVOR environment for ADDING/COMPILING the COBOL/CICS/VSAM/DB2 programs in ENDEVOR DEV/QA region. Co-ordinated with QA team for SIT to see how the results come up when dealing with external applications.

Environment: - TSO, ISPF, CICS, COBOL, DB2, VSAM, JCL, CA-7, ASKNOW, TELON, XPEDITOR, FILE-AID, FILE MANAGER, DFSORT, SPUFI, ENDEVOR, QMF.

Confidential, DALLAS, TX

Mainframe Programmer/Analyst

Responsibilities:

• Executed Confidential SYSTEM ( Confidential ) SDLC process and promotion of a vision for new and existing component change request.
• Researched & implemented a large volume of COBOL/CICS/VSAM/DB2/IMS coding with sound technical knowledge in order to deliver both online and batch application efficiently.
• Proof of Concept (POC) to integrate mainframe COBOL/DB2/IMS programs with SALESFORCE - Customer Relationship Management (CRM) platform & ORACLE TRANSFORMATION (OTM project) using IBM INTEGRATION BUS (middleware).
• Evaluate current business practices with emerging technology and recommend relevant process enhancements and products that anticipate or complement corporate direction.
• Planned and developed the flow of user documentation in order to ensure that the technical material was accurate and easily understood by potential users.
• Developed stored procedures and triggers to facilitate consistent data entry into the ORACLE staging table.

Environment: - TSO, ISPF, CICS, MQ series, COBOL, DB2, IMS DB, VSAM, JCL, CA-7, TELON, XPEDITOR, FILE-AID, FILE MANAGER, SPUFI, ENDEVOR, QMF, MF COBOL, CICS Transaction Server (CTS), CICS Transaction Gateway (CTG), TCP/IP, Teradata SQL Assistant aka QUERYMAN, MICROFOCUS NET EXPRESS V5.1. IBM Integration BUS, SAS, ORACLE, PL/SQL, TOAD.

Confidential

Mainframe Programmer/Analyst

Responsibilities:

• Analyzed, Designed, Developed& tested On-line screens & batch processing programs using TELON, Cobol, CICS, DB2, IMS DB
• Developed new inbound/Outbound programs in CICS Web Services Environment with support of CICS Transaction Server 3.1
• Documenting and coordinating project activities for internal knowledge base.
• Escalation of issues within Project Tracking Systems appropriate
• Estimate workload and Resource planning.
• Worked on loading of data from several flat files sources to Staging using Teradata MLOAD, FLOAD.
• Worked on exporting data to flat files using Teradata FEXPORT.
• Worked exclusively with the Teradata SQL Assistant to interface with the Teradata.
• Executed performance, scalability, system, functional and integration test plans based on detailed feature requests
• Worked on dataset
• Worked on-call during the weekends for the production support of batch processes

Environment: - TSO, ISPF, CICS, CICS Web Services, CICS Transaction server, COBOL, DB2, IMS DB, VSAM, JCL, CA-7, TELON, COGNOS, XPEDITOR, FILE-AID, FILE MANAGER, DFSORT, SPUFI, ENDEVOR, QMF, MQ Series, HTML, JAVASCRIPT, Terada, BTEQ, MLOAD, FLOAD, FEXPORT.

Confidential, Indianapolis, IN

Mainframe Programmer/Analyst

Responsibilities:

• Researched &implemented a large volume of COBOL/CICS/VSAM/DB2 coding with sound technical knowledge in order to deliver both online and batch application efficiently.
• Involved in ON-CALL production support for claims &accounting batch cycles.
• Hands on with JCL’s and procedures, which include implementing better way of RESTORE & BACKUP logic.
• Worked with CA-7/CA-11 job scheduler to schedule and identify the job flow.
• Worked with report DISPATCH to create & monitor the reports.
• Worked with ABEND AID to research the day-to-day online screen ABEND.
• Worked with XPED debugging for production ABEND i.e. data exception etc.,
• Planned and developed the flow of user documentation in order to ensure that the technical material was accurate and easily understood by potential users.
• Conducted discussions with the Accounting team in order to understand the business for any kind of System Change request or production ABEND/problem fix.
• As a part of UHC SDLC, wrote system change request, functional design, technical design, system test plan, system test results &back out specifications based on the recent changes/prod.

Environment: - COBOL, ROSCOE, TSO, ISPF, ASSEMBLER, VSAM, CICS, JCL, DB2, QUICK JOB, Report DISPATCH, FILE-AID, ENDEVOR, XPEDITOR, ABEND-AID, CA-7/CA-11.

Confidential, Indianapolis, IN

Mainframe Programmer/Analyst

Responsibilities:

• Worked extensively in TELON/DB2 (Online screens), COBOL/DB2 (batch programs), to create/enhance new and existing programs.
• Involved in child support health insurance entity as a part of MEDICAL SUPPORT enhancement.
• Executed ISETS SDLC process and promotion of a vision for change request routines
• Analyzed client requirements, reviewed findings and implemented solutions
• Hands-on experience with deriving new SQL’s and with existing SQL for performance tuning
• Created test scenarios and test data; developed an idea from its initial stages to the final product and effort estimates
• Wrote functional design and technical design specifications based on the recent changes with the business logics
• As a part of batch support team, monitored/ran daily, weekly, beginning-of-month and end-of-month jobs

Environment: - COBOL II, TSO, ISPF, TELON, VSAM, CICS, DB2, JCL, OS/390, ICETOOL, QMF, SPUFI, FILE-AID, IBM-DEBUG, ENDEVOR, ABEND-AID

Confidential, Batesville, IN

Programmer Analyst

Responsibilities:

• Coded conversions using COBOL, Mantis and DB2, IMS DB/DC for BANKONE to FIFTH THIRD BANK, which involved coding and table design change
• Studied, designed, developed and implemented Policy Print programs, which were developed in COBOL and Mantis programming OS/390 environments with DB2
• Utilized CHANGEMAN-ZMF (Project Management Tool) for baseline movements such as Checkout, Staging and Promoting components starting with level 30; then moved to QA, approved and moved to level 50 UAT which was the final approval for changes
• Studied IMS DB utilities and converted it to DB2 utilities
• Conducted analysis, coding and testing for IT requests (Production issues) in PL1, COBOL and DB2 for code conversion from an Ingenium upgrade 5.5v into 6.3v, which had a major impact on the DB2 table change for all COBOL and Mantis programs
• Created test plans for the code conversions and IT requests which covered White Box, Black Box and Impact Analysis Testing
• Conducted DB2 table analysis using DB2 catalog, SPUFI and QMF before applying any SQL coding in COBOL and Mantis programs
• Developed design and functional level documents and discussion for Policy Print modules analysis with code conversion tables for policy print

Environment: - COBOL II, TSO, ISPF, CHANGEMAN-ZMF, PL1, Mantis, VSAM, CICS, IMS DB/DC, DL/I, DB2, JCL, Win Runner, QMF, SPUFI, FILE-AID, EXPEDITOR, ABEND-AID, BMC, OS/390

Confidential, Falls Church, VA

Systems Analyst

Responsibilities:

• Worked with QMF and SPUFI for query optimization for COBOL reports
• Worked with complex JCL for the COBOL-DB2 batch jobs
• Worked as an OS/390 environment specialist in order to organize the COBOL application and normalize and optimize data from DB2
• Involved in designing COBOL data structures with Primary and Alternate key mapping with a better understanding of the legacy system
• Worked with BMS macros, File Control, Exceptional handling, TSQ’s, TDQ’s and involved in major CICS application changes with BIA system using CICS programming techniques.
• Develop batch processes for Immigration review & Immigration appeals reporting applications using Perl and Korn shell scripts.
• Conducted Expediter analysis and testing (online and batch unit test), directly contributed to a substantial IT cost reduction in CPU cycle cost, DASD storage, batch process times
• Involved in creating test plans for both client side and server-side validation using the current business plans
• Involved in the evaluation of DB2 ASSIST for MQ SERIES
• Involved in migration including the loading of data from legacy systems to Oracle using SQL Loader utility and DTS

Environment: - COBOL II/370/VM, CICS, MVS-XA, UNIX, OS/390, IMS DB/DC, DLI, DB2, BSAM, VSAMTSO/ISPF, JCL, FILE AID, ABEND AID, Expeditor, Easytrieve, Endevor, Syncsort, Perl, Korn ShellCHANGEMAN ZMF, BMS/GT, CA-GENER/OL, QMF, SPUFI, INTERTEST, UNIX, Relativity, OmegamonVUPORT, Cold Fusion, Win Runner, MS SQL Server 2000