Employment History:

Confidential

Sr. Oracle Functional Consultant

• Coded Main and Sub programs for PL/I, ASM COBOL, DB2 and CICS modules which contain ASM Interface to pass output data to Unix FTP files.
• Involved in designing some of the modules in the TRACR project
• Execution of Unit test plans and verification of the test results thereby ensuring quality delivery.
• Created new online CICS/IMS DC screens using SDF/MFS methodology.
• Delivered new and complex high quality solutions to clients in response to varying business requirements.
• Newly coded REXX JCL, PROC and Control Cards for running batch applications
• Prepare and run Embedded SQL queries on the database to verify data using SPUFI, QMF.
• Used Expeditor for the debugging the large code with multiple subprograms and logged / tracking defects in Quality Center.
• Worked on CF systems DEVLT on online CICS and DB2.
• Worked on Online xped and batch xpeditor jobs.
• Worked on DB2 platinum to check date entries.
• Defect SR/PL analysis and resolution for live and system test defects.
• Root cause analysis of system test and oncall production abends
• Fixing the code for the live defects raised by Testing team and the BSD's.
• Responsible working on UNIX commands and creating korn shell scripts
• Coded Programs for the Enhancement projects that come from clients using COBOL and DB2.
• Estimate upgrades to the Recovery Software System.
• Retrieval of backup tapes
• Responsible of creating the directories in UNIX and save the files on these directories coming from mainframe application through FTP
• Extracting information from IMS database and creating the online screen using IMS DC
• Working with Rapid Deployments RD like RD520 and RD352 etc which come for rate changes and changes in SAS Notes.
• Experienced in using ISPF tool for working with panels
• Involved in creating test scenarios based on use cases base on the new features incorporated in then version.
• Used to lead the bug triage meetings for bug resolutions.
• Worked with NDM Connect Direct for the transmission of files from one region to other like Test to Production and Vise versa.
• Experienced in using SORT, SYNCSORT, IDCAMS, IEBGENER, IEFBR14 and many other utilities
• Experienced in using RACF tools for giving authorization for different datasets for BSD's
• Used FTP for transferring the files in between and documenting then into word

Environment: IBM OS/390, COBOL, CSF, DB2, JCL, CICS, VSAM, REXX, CA-7, TSO/ISPF, Endevor, InfoPac, EFT, EDI/EDIFACT, ANSI X12 transaction sets, ACH, PEP , EditPlus, Gentran, PRC, SPUFI, QMF, SQL, FILE AID, ABEND AID, Testbase, XPEDITER, Panvalet, Lotus Notes, MS-Office, MS-Word, MS-Excel, PowerPoint.

Confidential

Development/Maintenance and System test/Production support

Roles and Responsibilities:

• Understanding Technical Requirements of APAR shipment from IBD team.
• Preparing Retrofit note for each shipment APAR or SR-release notes from Vinner team
• Worked on CLONE Business user test environment on DB2 and IDMS
• Promote all APAR, SR shipment into CHISD development regions.
• Performing retrofit each fun level CHIS-US code changes
• Preparing Detailed design and Specification documents of all SR/PL business requirements.
• Performing checkout testing of each APAR or SR shipment
• Conducting reviews on SR/PL's, Detailed designs, UTPs and UTRs along with client.
• Coding and development as Per the Low Level Design.
• Conducting code walkthroughs on deliverables along with client and offshore team.
• Attending SR/PL/Release Project meetings along with client and sharing the same to other team members.
• Worked on CF systems DEVLT on online CICS and DB2.
• Worked on Online xped and batch xpeditor jobs.
• Worked on DB2 platinum to check date entries.
• Defect SR/PL analysis and resolution for live and system test defects.
• Root cause analysis of system test and oncall production abends
• Giving 24X7 system test and oncall Production support CHIS-US.
• Performing review checkout test results of each shipment SR/PL's for both Host Mainframes and frontend JAVA.
• Unit Testing on Service Request's SR , Problem Log's PL and evaluating the test results for test plans and test cases and prepare the test result summary report.

Environment : COBOL, JCL, IMS-DB/DC and DB2 and IDMS.

Confidential

Sr. Mainframe programmer Analyst

Responsibilities:

• Understanding the Overall functionality and Business requirements for Interexchange Carrier Billing System
• Understanding the SFAD and Technical Requirements
• Preparing Detailed design and Specification documents for business requirements.
• Conducting reviews on SFAD, Detailed designs, UTPs and UTRs along with client.
• Coding and development as Per the Detailed design.
• Conducting code walkthroughs on deliverables along with client and offshore team.
• Attending FAR/Status/Recovery/ Project meetings along with client and sharing the same to offshore team.
• Defect analysis and resolution for live and system test defects.
• Investigated the code for the BSD Queries and giving them solutions for fixing the code to get rid of defects
• Created JCL's for the recoveries that must be done for usages with invalid data and the usages that were rated incorrectly.
• Fixing the code for the live defects raised by Testing team and the BSD's.
• Responsible working on UNIX commands and creating korn shell scripts
• Coded Programs for the Enhancement projects that come from clients using COBOL and DB2.
• Experienced in using SORT, SYNCSORT, IDCAMS, IEBGENER, IEFBR14 and many other utilities
• Experienced in using RACF tools for giving authorization for different datasets for BSD's
• Used FTP for transferring the files in between and documenting then into word
• Create test ware using only the business/functional and technical requirements as input
• Creating the Packages in CHANGE-MAN for all the PMT's.
• Experienced in using ABEND-AID tool to debug the code
• Experienced in using SPUFI tool for executing queries in DB2
• Experienced in using IBM Utilities for getting the usages as per the BSD's requirements for further testing
• Expertise with Analysis and Design to create specification doucuments with using MS office suite MS- WORD, MS- EXcell and powerpoint .
• All executable statements must be tested using EXPEDITOR, expected results documented
• Experienced in working with REXX tool for creating JCL's and for weekly and monthly recurring jobs
• Involved in 24/7 production call support.
• Worked with Quality Center for testing mainframes projects.
• Worked on ATT internal installer STAR.
• Coordinate with EPAS IBM Brazil team to fix all production issues and EFIX and and system test issues.
• Worked on DB2 capacity planning and management
• Coordinate with Offshore for all Defect, ADHOC, Requirements etc..
• Preparing Requirement Tractability Matrix for all BR TR and FR

Environment: MVS/ESA, Z/OS, COBOL, DB2 8.0, IMS DB/DC, JCL, CICS, FILE-AID, CHANGE-MAN, SPUFI, CLIST, ISPF, VSAM, FILE-AID, SQL, XPEDITOR, NDM Connect Direct, ABEND-AID, CA7, RACF, EASYTRIEVE, REXX, SAS, FTP, SAR, QUALITY CENTER,SMP, E installation, Rexx VISIO and UNIX.

Tools: Changeman, NDM, Vantive, Quality center, File aid, Comparex, BMC, RD trac, QMF and SPUFI.

Confidential

Maintenance and System test and Production support

Responsibilities:

• Involved in designing some of the modules in the TRACR project
• Execution of Unit test plans and verification of the test results thereby ensuring quality delivery.
• Preparation of unit test plans.
• Developing many modules in TRACR2 and TRACR.
• Gathering business requirements, preparing functional and technical specifications by understanding business requirements.
• Coded Main and Sub programs for PL/I, ASM COBOL, DB2 and CICS modules which contain ASM Interface to pass output data to Unix FTP files.
• Created new online CICS/IMS DC screens using SDF/MFS methodology.
• Delivered new and complex high quality solutions to clients in response to varying business requirements.
• Newly coded REXX JCL, PROC and Control Cards for running batch applications
• Prepare and run Embedded SQL queries on the database to verify data using SPUFI, QMF.
• Used Expeditor for the debugging the large code with multiple subprograms and logged / tracking defects in Quality Center.
• Conducted disaster recovery DR exercise on all region datasets and environment.
• Developed optimized coding on REXX, unit testing and quality documents and tested PL/I, COBOL, IMS DC , VSAM, DB2, JCL jobs and programs.
• Created test plans as per business and user requirements. Responsible for manually testing the entire application for system process functionality and business logic.
• Responsible for Quality of the Product and Co-coordinating with Users during User Acceptance testing.
• Worked on various region data center relocation on full billing cycle.
• Follow up with the Production run and checked the derived result with the post production team.
• UnderstanConfidential

As a developer responsible for following:

• Translated business requirements and functional specifications into detailed system and program design specifications.
• Develop and implement new programs and to existing applications including Coding, Testing, and implement using COBOL, DB2, CICS, JCL, VSAM, Copybook, DB2 Stored Producer, Triggers development and SQL Optimization and PL/SQL.
• Debugged and tested programs using XPEDITER.
• Understanding the HLAD and EBF Technical Requirement Documents
• Preparing Detailed Designs, Specification Documentation for the work request
• As Per the detailed design coding all the modules
• Performing the Unit Testing and evaluating the test results and pre prepares documentations
• Development of Test Plans and Test Cases

Environment: MVS/ESA, Z/OS, COBOL, DB2 8.0, IMS DB/DC, JCL, CICS, FILE-AID, CHANGE-MAN, SPUFI, CLIST, ISPF, VSAM, FILE-AID, SQL, XPEDITOR, NDM Connect Direct, ABEND-AID, CA7, RACF, EASYTRIEVE, REXX, SAS, FTP, SAR, QUALITY CENTER, VISIO and UNIX.

Tools: Changeman, NDM, Vantive, Quality center, File aid, Comparex, BMC, RD trac, QMF and SPUFI.

Confidential

Responsibilities:

• Coded Main and Sub programs for PL/I, ASM COBOL, DB2 and CICS modules which contain ASM Interface to pass output data to Unix FTP files.
• Involved in designing some of the modules in the TRACR project
• Execution of Unit test plans and verification of the test results thereby ensuring quality delivery.
• Preparation of unit test plans.
• Developing many modules in TRACR2 and TRACR.
• Gathering business requirements, preparing functional and technical specifications by understanding business requirements.
• Created new online CICS/IMS DC screens using SDF/MFS methodology.
• Delivered new and complex high quality solutions to clients in response to varying business requirements.
• Newly coded JCL, PROC and Control Cards for running batch applications
• Prepare and run Embedded SQL queries on the database to verify data using SPUFI, QMF.
• Used Expeditor for the debugging the large code with multiple subprograms and logged / tracking
• Preparing Detailed Designs, Specification Documentation for the work request
• As Per the detailed design coding all the modules and fix the test and live defects,
• Root cause analysis of system test and production application abends
• Performing the Unit Testing and evaluating the test results and pre prepares documentations
• Development of Test Plans and Test Cases
• Conducting Chain test along with various upstream and down stream applications.

Environment: MVS/XA, VS COBOL II, JCL, CICS, VSAM, DB2, SAS, FORTRAN, Easytrieve, Informatica ETL tool , COMPAREX, DYL-280, CLIST, TSO/ISPF, Xpediter, Endevor, SPUFI, File-AID, Visual CACTUS, MS-Office, MS-Word, MS-Excel, MS-Outlook, PowerPoint

Confidential

Mainframe System programmer

rent system in Ford, and IT Solution and Development Life-cycle.

• Analyzing and developing programs in COBOL/DB2, VSAM, JCL, Stored Procedures and IMS/DB.
• Responsible in data separation activities of DB2 tables data using Move for DB2 utility and loading them into new LPAR.
• SPOC Single Point Of Contact for any technical and PLI/COBOL/JCL/DB2 related mainframe issues.
• Prepare exhaustive plan of approach and design a phased structure to carry out migration work.
• Gathering complete system and architectural details from SME of each application.
• Prepare the splitter / joiner programming logic and data separation rules and developing programs.
• Involved in gathering Business Requirements, Technical requirement for preparing deliverables.
• Involved in carrying out impact analysis of the program due to any modifications in the business functionality.
• Involved in coding new programs and technical review discussions.
• Identify the possible splitters, joiners and write a temporary interface programs to deploy applications in a phased manner.
• Prepare critical deliverables like porting design document, interface document for each application.

Environment: IBM OS/390, COBOL, CSF, DB2, JCL, CICS, VSAM, REXX, CA-7, TSO/ISPF, Endevor, InfoPac, EFT, EDI/EDIFACT, ANSI X12 transaction sets, ACH, PEP , EditPlus, Gentran, PRC, SPUFI, QMF, SQL, FILE AID, ABEND AID, Testbase, XPEDITER, Panvalet, Lotus Notes, MS-Office, MS-Word, MS-Excel, PowerPoint.