Profile Summary

• Having Seven plus years of work experience in the areas of Software analysis, development, design, coding, integration, testing, process control and maintenance of Mainframe based applications.
• Extensive exposure and excellent working knowledge of COBOL, JCL, VSAM, DB2 and CICS, Asp.net, VB.net, C#, IIS.
• Involved in all Phases of SDLC.
• Execute the Release Process model for the Development.
• Good Exposure in Onsite offshore model.
• Extensive Experience in Auto, Property and Causality Insurance.
• Used Endeavor, Change Man, and Panvalet for versioning the code.
• Used XPEDITOR, INTERTEST, and Debugger for debugging the code.
• Experienced in Documenting, preparing Test Plans & executing it.
• Good understanding of business requirements and specifications.
• Quick learner of new technologies and positive attitude towards the changes in the Industry.
• Excellent Team player with the ability to communicate effectively at all levels of the development process.
• Able to cope up with the team and driving them in the right direction when required.
• Completing the assigned work in timely manner with out disruption.
• Undergone training in Time Management, Project action Planning, QMS - Quality Management Systems, Cross culture, Interfacing with client, Assertiveness skills and Effective Team meetings.
• Worked in SEI-CMM Level 5 Organization. Capable of generating the following documents: Requirement Specification, Design Specification, Unit Test Cases, Configuration management Plan, Coding Standards and conventions

Technical Skills:

Languages:VS COBOL II, MF-COBOL, JCL,Rexx, Easytrive

Database:DB2,IMS DB/DC,SQL,Stored Procedures, IDMS.SQL

Tools:Endeavor, Change man, IBM Debugger, Intertest, Mercury Test Director, Expeditor, QMF, Panvalet, Abend-Aid, Fault Analyzer, GTB, File-Manager, list, NDM, FTP, Query man,
CA-7, SAS, Platinum, Dump Master, AppMaster Builder 5.0, MQS, File-aid, Panvalet, Lotus.

Operating Systems:Windows98/NT, OS/2, MVS,Z/OS

DC Control Systems :CICS

File System:VSAM

Utilities:TSO/ISPF, SPUFI

. Net Technologies:ASP.NET 1.1/2.0, ADO.NET 1.1/2.0., HTML, DHTML, CSS, JavaScript, VBScript, XML, XSD, XSL, SOAP, AJAX

PROFESSIONAL EXPERIENCE:

Confidential Jul’08-Till Date Customer Data Management System

Confidential is the third largest auto insurance group in the united states established in the year 1937.It is having 10 million policies in force, and growth continues as more people choose for their vehicle insurance needs. In addition to auto insurance, Confidential offers the following types of insurance to customers throughout the country: boat/personal watercraft insurance, commercial auto insurance, homeowners insurance, motorcycle insurance, RV insurance and Seaway insurance.

The purpose of the CCRI Migration project is to migrate data stored in existing DB2 databases to new Customer SQL server database and decommission the CCRI & CDMS databases from mainframe DB2. Migration will be completed in two phases, where in first phase dual update process will be designed for CCRI, CDMS & Customer databases and in second phase DB2 databases will be shut off from production.
Roles & Responsibilities:

• Extensively worked in the analysis phase by regularly meeting with the client in the client interaction meetings and understanding their requirements.
• Most of the time involved in coding COBOL, DB2, VSAM and JCL.
• Preparing key artifacts like design documents, business case, Use cases etc for customer sign off as a mandatory requirement following traditional SDLC methodology.
• Has written COBOL and DB2 new programs as batch programmer.
• Was solely responsible for implementing the design changes, enhancing and testing of programs in business areas that were allocated to me.
• Creating the Program specifications and coding of application programs based on the specifications of the client.
• Worked extensively on the enterprise projects using Service oriented architecture.
• Getting Data in the XML format from different applications and convert that into the Mainframe Copybook format to store it in the DB2 database.
• As part of data analysis, Load and unload the databases to fix the problems.
• Done Data purge process to purge the duplicate data in different environments using DB2 Utilities.
• Developed new MQ programs to transfer the data from Mainframe to the server using XML format.
• Preparation of test data and verifying test results in System test environment and supporting the module for early life cycle problems.
• Conducting Defects Casual Analysis and implementing recommendation made.
• Responsible for Unit Testing & System Testing and User Acceptance Testing
• Actively involved in Implementation Phases to elevate the projects to production and support warranty.
• Document all the project details at the SDLC phase and obtain signoff from the business and create a SM turn off document after the production elevate to support group.

Environment: Z/OS, COBOL II, JCL, VSAM,CICS DB2, STORED PROCDURES, IBM Debugger, XML,NDM, FTP, Table Base, File-Aid, Sync sort, SPUFI,FTP,NDM,Changeman,QMF,CA DB2, MQ Series, Customer SQL CA-7,MS Visio.

Confidential Mar’07-Mar’08
Fire Policy Processing System

Confidential is a provider of Insurance management services and a holding company based in Los Angeles, California and operates in 41 states across USA. They serve more than 15 million customers by providing services in AUTO (Personal vehicle insurance); HOME (Home or personal property damaged by fire or theft); LIFE (Insurance for Life); BUSINESS (Building, Equipment and workers compensation etc., for Business); Finance (Mutual Funds & Annuities); HEALTHCARE (Health Coverage).

This processing includes policy entry, renewals, endorsements, cancellations, reinstatements, hard copy policy production, online inquiry and reporting for the majority of home Insurance business at Farmers.

During nightly batch processing, the Transaction databases are used to process instructions and update the Master database. A separate job reads the Master database and produces the hard copy items needed for policy issuance.

Roles & Responsibilities:

• Analyze the Business needs and provide the Estimates prior to the assignment.
• Analyze the change request and performing the required tasks.
• Involved in the requirements study and business discussions with the clients.
• Preparation of Technical Review documents according to the business specifications and attend the meetings with the Subject Matter Experts, Business people to evaluate the risk involved.
• Update the Status to the Release Mangers in the weekly status meeting.
• Involved in Code changes for the impacted programs of different projects.
• Reviewing programs of peer team members of different projects and provide the recommendations for the performance and business functionality.
• Coding different new programs and make enhancements using CICS,COBOL,DB2,REXX
• Made JCL, PROC, PARM LIB members according to business requirements to meet with the SLA’s.
• Testing the Applications for the business requirement and responsible for delivery.
• Attend the Test Documentation Review meeting and confirm the test cases for the required changes of the integration and Regression testing.
• The data coming from online applications using XML format is changed to Mainframe compatible format copybook and load it in the databases.
• Migrate reports from Easytrive to Assembler to gain for better performance.
• Test and Debug the Online programs using Interest debugging tool.
• Document the Unit Test Results and send it for the SME approval.
• Involved in System testing and attending to the trackers raised and resolving them in time.
• Preparing and maintaining documents related to quality such as Function Point Analysis and project requirements etc.
• Deliver the Code and support is given in different test environments such as Integration, functional and stress testing until it moved to production.
• Participate in the Production Turn over meetings.
• Participate in the Production Shakeout.

Environment: VS-Cobol-II, JCL, VSAM, DB2, CICS, REXX, SPUFI, Endeavor, Intertest, Assembler, QMF, File Manger, MS Visio, WSS 3.0, IIS, Win 2003 server, C#, VB.NET, XML, SQL Server 2005, and SQL Analysis Service 2005, Visual Studio 2005.

Zurich Farmers Feb\'06 - Mar\'07
P-Lines

Confidential is a customer-focused, regional property and casualty insurance company providing a broad range of insurance and alternative risks management products and services.

Vehicle Information Control System is used to process personal auto policies for Selective Insurance. This processing includes policy entry, renew the policy, updating the information in the policy history, MVRs (Motor Vehicle Requests), cancellations, active the cancellation policies, rewriting the existing policies as per the customer request, hard copy policy production, online inquiry and reporting for the majority of personal auto business at Selective.

At the end of Businesses hours, all the data processed on that day used to process instructions and update the Master database. By using a special technique, all the policy information will be printed on the hard copy by using Gunter machines.

Roles & Responsibilities:

• Developed new programs for the business functionality.
• Work involves fixing abends such as Space abends; File contention errors, space abends and DB2 related abends.
• Also involved in monitoring the Batch Cycles and flow of System jobs.
• To Perform Minor and Major Enhancements of different business applications.
• Worked extensively on Rata base programs to code the new business rules for the business enhancements.
• Perform Unit and System Integration Testing.
• Gathering requirements and involved in Design work of all projects.
• Handling Ad-Hoc Requests.
• Validating reports from report generating programs.
• Analyze functional description.
• Reviewing programs of peers projects to verify the business needs.
• Debugging and Implementing the System.
• Provide testing support in different phases of the project to turn around the issues and document it for the further reference.
• Mentoring the team as a team lead to execute the projects in quality standards.
• Prepared the Data dictionary and provide mapping to all the online fields to the data base for easy reference to execute the projects in a timely manner.
• Document all the required details from the Requirement Phase till the production and get it signed off by the Business.

Environment: VS-Cobol-II, JCL, Panvalet, CICS, VSAM, DB2, SPUFI, QMF, SQL, Dump Master and File-Aid, Sync Sort, Microsoft Office.

Confidential Jul’04 – Jan’06
Commercial PSG

Production support of Confidential Commercial System on a request basis. This system takes care of all processing related to new business, renewal, cancellation and change processing for all Commercial Insurance policies of Nationwide Insurance. The main applications being supported by this project are CLIPS II batch system and CLIPS III & ICP online systems. The scope of the project involves analysis, coding and unit testing of the various service requests assigned to Wipro. The requests vary from bug fixes to enhancements involving development of new programs.

Roles & Responsibilities:

• Receiving the business requirement from the client for different projects to enhance the business functionality.
• Converting the business requirement into User requirement specification and standards provided by the client.
• Analyze the functional specification in depth to use for the further needs.
• Involved in development/enhancement of Applications using Micro Focus Cobol, VS COBOL, JCL, DB2 and CICS.
• Made changes to the Online Interactive Commercial Systems screens using Micro Focus Cobol and Dialog.
• Testing the Applications for the business requirement and responsible for delivery and Status reporting.
• Participate in Peer Reviews for different tasks and provide the feedback to meet standards.
• Document the Unit Test Results in the specified formats.
• Maintain the Quality documents according to the standards for the project requirements.
• Responsible for the code delivery of all the assigned projects.
• Made changes to the online systems using System Dialog in Interactive Commercial Processing systems.
• Worked on DMG reporting of various Reports formatting of Variable and fixed formats.
• Enhance different Rate programs according to the Table base changes revisions.
• Format the Table base to the new version according to the needs.
• Handle the online systems lonely and enhanced different projects used by the nationwide agents in commercial processing...
• Provide testing support and creation of test data in various testing levels such as Functional testing, Stress testing, Acceptance testing etc.
• Involved in the Production migration support
• Document all the working projects and provide as a Knowledge base to the Client as a repository.
• Participate in all the team activities from the Work management, Status reporting, time reporting to the managers.

Environment: MF-COBOL, VS COBOL, Net Express, JCL, Table Base, VSAM, App Master Builder 5.0, DB2,CICS, Panvalet, Change man, File Aid, QMF ,SPUFI and IBM Debugger, Intertest.

Confidential Nov’02 – Jun’04
Auditor Request

The main purpose of this project is to populate auditor certificate for each customer lays upon request. The project is developed for itself. This involves extraction of data from DB2, which is a large database for cache accounts and last business day of month, data is extracted from VSAM database for external accounts. Audit certificate consists of nine sections for which data is extracted from DB2 and VSAM individually depending on the input, which we get from MQSeries into Commarea and extracted data is put into Commarea from where MQSeries takes the data.

Roles & Responsibilities:

• Involved in gathering Business Requirements and reviewed the same.
• Involved in developing the System Requirement Specifications to get approval from the client and also involved in preparing the System Design Document for the final development of application
• Involved in the Development and Maintenance of the different COBOL, DB2 and CICS programs.
• Modification of CICS online MAPS using GTB tool as per the business requirements
• Used Endeavour as the version controlling to maintain the programs.
• Debug the programs using Expeditor to identify the issues for the turn around.
• Done the Compares to integrate the different projects before integration test.
• Prepared Detail Design Specs based on the high level design and reviewed by the Systems analyst to signoff before the development of programs or enhancements.
• Created VSAM files to read and write the data in different environments.
• Use TSQ, TDQ’s for managing intermediate data.
• Coding the Programs using the best practices and meet with the standards of the client.
• Made small modifications to the Assembler programs and generate reports.
• Unit Test the programs developed and integrate with the other projects and move to the testing regions.
• Took all the signoff for the projects according to the client standards.
• Maintain all the project level documents according to the company standards.

Environment: VS COBOL II, DB2, TSO/ISPF, JCL, IDMS Endeavour, CICS, and VSAM, File Aid, Assembler, Expeditor, SPUFI, QMF.

Education:

Masters in Computer Applications (MCA).