SUMMARY

• Over 5.7 years of professional IT experience with technical expertise in Mainframe technology and functional experience in Insurance domain.
• Experience in SDLC process: Analysis, Design, Coding, Unit Testing, Integration Testing and Implementation experience for COBOL components, JCL, REXX tools and Excel VBA automation tools. Maintaining the quality in every phase of SDLC by conforming to industry standards.
• Proven team leading skills. Experience in leading a team of five and implemented 8 projects under my leadership with zero post production defects by following stringent unit testing and validation at each phase of review.
• Experience in the conversion and integration projects - Data conversion from Mainframe to open end system and integration of the same with web services.
• Extensive experience in developing Automation tools using REXX and Microsoft Excel VBA macros.
• Experience in Report Generation using DB2, Excel VBA Macros, JCL, REXX and DFSORT.
• Experience in the tools Endevor, Intertest, Xpeditor, File-Aid, File manager.
• Good understanding on the architecture design of legacy system involving various interfaces.
• Good understanding of database concepts with good knowledge on Oracle, SQL, DB2 and VSAM.
• Good knowledge on HTML, CSS, JavaScript, XML.
• Expertise in Microsoft Excel 2003, 2007, 2010 and Excel VBA programming.
• Experience in Microsoft Powerpoint 2007, 2010 and Microsoft Visio 2007.
• Confidential academy trainer for the language - REXX and conducted various trainings through Confidential training academy
• Good communication, Presentation and Interpersonal skills with excellent problem solving ability and analytical skills.
• Excellent Team player and a self-starter with proven ability to grasp complex technical subjects quickly and communicate them effectively to a non-technical audience.

TECHNICAL SKILLS

Operating System: OS/390, Z/OS 1.13, Windows 98, XP, 7

Programming Languages: JCL, Cobol, Rexx, Clist, Core Java, Excel VBA

Database: DB2 10.1, VSAM, Oracle 9i/10g

Transaction System: CICS TS 4.2

Web & Java Technologies: Core Java, Servlets & JSP, HTML, CSS, Javascript.

IDE: Eclipse

Tools: & Utilities: DB2 Connect, Endevor, File Aid, File Manager, Intertest, Xpeditor, SPUFI, QMF, DFSORT 1.12, SDSF, TSO/ISPF, IBM Utilities Microsoft Excel 2003, 2007, 2010, Excel VBA programming, Microsoft Powerpoint & Visio 2007.

PROFESSIONAL EXPERIENCE

Confidential

Mainframe Project Lead and Developer

Responsibilities:

• Successfully converted around 1.5 million Auto claims from Mainframe to the new open end Claims system with zero defects.
• Successfully performed Unit testing, Integration testing, system testing and functional testing for the open end Claims system with expected performance of the application.
• Implemented more than 8 major development projects and many other minor projects successfully under my leadership with Zero Post-production defect.
• Provided business consulting on designing the Conversion of claims data.
• Expert in DFSORT and used it effectively to generate reports from the VSAM database.
• Mentored the newly joined associates in technical and domain areas to enable them to scale up to the project needs.
• Development of Automation tool using Excel VBA for Bulk upload processing.

Developer

Responsibilities:

• Development of Auto Policy lookup interface using COBOL, TSQ and integrating it with the web service using MQ connection.
• Development of Claim loss summary module using COBOL file operations to provide the claim loss summary report associated with a set of policies.
• End to end automation of batch cycle execution and Data extraction process using REXX.
• Creation / Modification of programming entities that conformed to the project as part of application enhancement activities.
• Requirements analysis and approach identification.
• Performing Root Cause Analysis for the issues.
• Preparation of test scenario documents, unit test cases and creation of test plans.
• Production job setup and batch cycle execution in the test environment.
• Development of jobs for Claims data extraction and loading into the test regions.
• Defect tracking, Risk tracking, Software Configuration Management, Project status report projection.

Environment: z/OS, REXX, COBOL, JCL, DFSORT, VSAM, CICS, Endevor, Microsoft excel 2003/2007, VBA programming, CA View SAR, CA tools, File Aid, File Manager, Xpeditor, Intertest, IBM Utilities

Confidential

Programmer analyst - Mainframe developer

Responsibilities:

• Exceed Data Copy Utility Tool - Copy data from the database of a PROD/Test Region to the Database of a Test Region. No manual intervention required in the process. This tool provided dollar savings up to half a million for the client.
• After Data copy Automation - Install all Pending Releases in Emergency region after a monthly mass Data copy between PROD and Emergency Region. No manual intervention required in the process.
• Endevor Bind tool - Bind the Endevor package to respective lower regions after installation of package in Production environment through Endevor.
• Release Automation - PAD Tool: Install all the Mainframe Release Packages. No manual intervention required in the process.
• Mainframe Commands – Created Mainframe Commands, using REXX, to simplify the day-to-day work. More than ten commands were created
• Automation of Reports – Used DB2, Excel Macros, REXX, JCL, DFSORT and ICETOOL to automate the Reports that were done manually for a long period. No manual intervention required in the process.