PROFESSIONAL SUMMARY:

• 10+ years of experience with hands-on technology in IBM Mainframes – COBOL, PL/I, JCL, DB2, VSAM and CICS.
• Mainframe Lead & Developer.
• Expertise in IBM MAINFRAME - COBOL, DB2, VSAM, JCL, IMS-DB, CICS, SQL, Endeavor, Changeman, Xpediter, QMF, SPUFI, FILE-AID, ABEND-AID, CA7 Scheduler, Clist, IBM Utilities, ISPF/SDSF, Syncsort, design, development and deployment of applications using mainframe softwares.
• Experience in all phases of SDLC, Project Management, Software Practices and Standards.
• Proficient in manual testing of Mainframe applications.
• Experience in development, maintenance of existing applications and Production Support activities.
• Experience in preparing, reviewing Business and Functional Requirements.
• Involved in the Business analysis of user requirements by interacting with SME’s and Business Users.
• Involved in resolving the incidents received from batch runs of the applications.
• Involved in solving the service requests created by the Business users.
• Excellent analytical, communication and problem-solving skills. Team player with excellent organizational skills to assess needs, set priorities and meet deadlines.
• Effective communicator, skilled in building positive working rapport with clients at all levels of technical expertise.
• Strong analytical skill, able to work independently.
• Experience in leading a team. Ability to mentor and train junior team members.
• Quite familiar to onsite-offshore model.
• Have good knowledge in Automobile, Insurance and Retail domains.

TECHNICAL SKILLS:
Mainframe Software : COBOL, Pl/I, JCL, DB2, VSAM, CICS, Changeman, Endeavor, Xpediter, File-Aid, SPUFI, QMF, TSO/ISPF, SDSF, ABEND-AID, CA7 Scheduler, IBM Utilities.

PROFESSIONAL EXPERIENCE:

Confidential,Chicago, USA.
Duration: January 2012 - Till Date.
Role: Support Engineer / Mainframe Programmer

Description: Marketing & Pricing Applications
AdPlan and PMI are legacy formats of promotional activities related to candidates for Sears system. AdPlan is basically a part/sub application of Promotional Marketing Integration (PMI) application.

The Advertising Management and Planning System (AMPS) is an electronic tool that serves as a single source for advertising-related information. The AMPS standardizes how this information is captured, stored and accessed across the organization, while supporting the Advertising process. This data is used to Plan and create corporate advertised offers. Approved offers will then feed to the ADV POS system where the planned offers are expanded to all KSNS and the restrictions expanded to stores for ad pricing download.

The Frequency Planning provides planning, tracking and reporting of promotional sales frequency for both full-line and off-mall formats within the Promotional Marketing Information (PMI) system. Frequency is an application that is used to monitor the number of days an item is on sale in order to stay in compliance with state guidelines. It helps in maintaining the state of an item so that it can’t violate the business rules.

Responsibilities:

• Onsite/Offshore coordination
• Preparation of Basic process flow document.
• Preparation of Job flow for each application.
• Supporting applications related marketing & pricing on daily basis.
• Resolving the incidents received through incident management tool.
• Preparing test JCL and running them for data analysis.
• Creating documents related to incident resolutions for future use.
• Creating RCA documents for frequently occurring incidents.
• Work on the service request provided by the users.
• Creating documents related to service requests for future use.
• Preparation of DOU for each application containing functional, technical and operational overviews.

Environment: COBOL, JCL, DB2, VSAM, Changeman, Endevor, Spufi, QMF, Share, Teradata SQL Assist.

Confidential,Chicago, USA.
Duration: December 2011 - January 2012.
Role: Systems Engineer / Mainframe Consultant

Description:
Walgreens Automatic Matching System (WAMS) is used for processing all the warehouse invoices and does the matching process with the invoices, receipts and purchase orders. This will be accomplished by gathering all the invoices, receipts and purchase orders from various other sources or applications and performing the matching process. In addition, the system will allow Walgreens to generate reports of anomalies that are sent over to the accounting department in Danville, Illinois for further verification.

Responsibilities:

• Onsite/Offshore coordination
• Analyze Functional Requirements after discussion with Business through conference call or email.
• Preparation of Basic process flow document.
• Preparation of Future state document.
• Remove any conflict found during Functional Analysis.
• Preparation of Technical Design Specifications.
• Test scenarios and test case preparation.
• Preparing test JCL and running them for data analysis.
• Test case execution.
• Tested the Integration of different modules.

Environment: COBOL, JCL, VSAM, File Manager.

Confidential,USA.
Duration: June 2008 - February 2011.
Role: Team Lead / Mainframe Developer

Description:
This project deals with creation of Vehicle orders, for each order there are various types of validations & checks. This project caters to the needs of various dealers over North America, Mexico, Canada. Application was on DB2, this project was predominantly comprising of analysis initially and followed by coding, development, testing.

Responsibilities:

• Onsite/Offshore coordination
• Analyze Functional Specifications after discussion with client through conference call or email.
• Preparation of Basic Design document.
• Prepared Minutes of Meeting document.
• Remove any conflict found during Functional Specification Analysis.
• Preparation of Technical Design Specifications.
• Assigning tasks to Team and generating status reports.
• Creating DBCR’s required for coding stored procedures.
• Involved in development of stored procedures and testing them through DB2 Development Center.
• Test scenarios preparation.
• Test case preparation and uploading it to quality center.
• Preparing the traceability matrix.
• Preparing test JCL and running them for data analysis.
• Test case execution (batch or online).
• Tested the Integration of different modules.
• Review the new programs or code fixes with the OSC.
• Promoting the new programs or code fixes to production environment using version control tools.
• Involved in QA Meetings for the code and construction tasks with the Client.
• Created documents of the new programs or code fixes required for the future use or support team.

Environment: COBOL, JCL, DB2, IMS-DB, XPEDITER, CHANGEMAN, DB2 Development Center.

Confidential,USA.
Road, Bangalore – 560025, India.
Duration: December 2006 - June 2008.
Role: Senior Software Engineer / COBOL Developer

Description:
Package 8 consists of applications related to VIPS, CADRE and WRAPS etc.

VIPS:- The VIPS(Vital parts) system contains data pertaining to a vehicle that is mandated by the government as well as other information for vehicle recalls. The data is retained only 2 years plus the current production year on the mainframe as the datamart is the system of retention for this data.

CADRE:- The CADRE(Corporate Attendance Department Reporting Environment) system is the time and attendance system that supports NNA-S (Smyrna, Decherd, and Canton). The system is an exception-based system in which attendance entries are only required when an employee’s actual attendance differs from their normal work schedule. Exceptions to the employee’s normal schedule are compared to pay policies and other rules to ensure that only valid information is entered.

Responsibilities:

• Onsite/Offshore coordination
• Coordinating with onsite team for new functional requirements.
• Preparation of Basic Design document.
• Analysis of Functional requirements, Preparation of Detail Design documents.
• Preparation of Technical Design Documents.
• Develop new programs or changing the existing programs as per the requirements.
• Review the new program or changes to the existing program as per the programming standards document.
• Preparing test JCL and running test batch cycles for data analysis.
• Test scenarios preparation.
• Test case preparation and uploading it to quality center.
• Test case execution (batch or online).
• Tested the Integration of different modules.
• Review the new programs or code fixes with the onsite.
• Involved in Unit Testing, Integration and Regression Testing.
• Promoting the new programs or code fixes to production environment using version control tools.
• Documenting of the new programs or code fixes for the future use or support team.

Environment: COBOL, JCL, DB2, XPEDITER, ENDEVOR.

Confidential,ILLINOIS, USA.
Duration: December 2004 - December 2006.
Role: Programmer

Description:
Six systems comprise the Agent Tracking Systems .These systems have served State Farm well since mid-1980. However, this group of systems now largely consists of fragmented data stores and out-of-date technologies. Use of out-of-date technology has forced a number of State Farm business areas to develop copies of the agent information within the systems. These copies are redundant and significant resources are utilized each year to maintain them. Today, this group of Agent Tracking Systems hinders State Farm\'s ability to respond quickly to new business directions and new marking and quality initiatives for the benefit of our policy and account holders.

It is in State Farm\'s best interest for the future to move away from the current system and application design structure. The goals of this project are to produce the conceptual, logical and physical data store models, create the production data stores and populate them utilizing existing data, perform data analysis and cleansing as necessary, create and deliver a process to synchronize data on the new data stores with legacy AIMS data. This overall effort will increase State Farm\'s ability to respond quickly to new business directions and new marketing and quality initiatives for the benefit of our policy and account holders at reduced ongoing costs.

Responsibilities:

• Analysis of new requirements and preparing TSD’s.
• Preparing Data flow documents and Unit Test plans.
• Develop new programs or changing the existing programs as per the requirements.
• Review the new programs as per the project standards checklist.
• Source code walkthrough and review of programs created by other team members.
• Writing the Unit test cases, executing them and capturing the unit test results.
• Review the new programs, test results with team members, team lead and onsite coordinator.
• Documenting the new programs or code fixes for the future use or support team.

Environment: PL/I, COBOL, JCL, DB2, IMS-DB, XPEDITER.

Confidential,USA.
Duration: November 2002 - November 2004.
Role: Programmer

Description:
ACES is mainframe based application system developed for claim processing of Liberty Mutual PAL (Property, Auto and Liability) claims. The claims handled by ACES are personal and commercial market automobile, general liability, property liability, environmental, fire losses and miscellaneous lines. ACES comprises a number of modules fulfils the following functionalities Claims registration - online and batch, Claimant data and coverage verification, Payment processing, Subrogation, Loss display, Expense summary, Appraisal, Claim block transfer, Refunds, Claims purge, Feeding claims data to COBRA for financial reporting, Sending claims data to Loss data Warehouse Sending claims data to National Insurance Bureau, Automobile Insurance Bureau for filing, Check reconciliation, Reports.

Responsibilities:

• Analyzing the Work Packets (change requests) provided by the clients.
• Involved in Impact Analysis of the programs.
• Preparation of Detail design document, Unit Test Plans,
• Testing the flow of data for the changed programs using XPEDITER.
• Designing the test cases and executing them.
• Documenting the changes made to programs for future reference.

Environment: COBOL, JCL, DB2, IMS-DB, Endevor, Xpediter.