Summary:

• More than 10 years of experience in various projects doing Analysis, Design, Development, Maintenance, Testing and Documentation in Banking, Insurance, Financial, Health care and Energy Retail Applications. Performing in different roles as Programmer, Team Lead, and Business Analyst. Proficient in obtaining project requirements from user and manager, formulating the requirements into design specs, preparing system specifications, assigning tasks to team members, and tracking project progress.
• Extensively worked on Mainframe Technologies with various Applications. Specializing in COBOL, APS-COBOL, DB2, CICS, PL1, JCL, VSAM, SQL, QMF, SPUFI, MVS, OS/390, ENDEVOR, XPEDITOR, TSO/ISPF, Change-man, PANVALET, IBM-DEBUG, XML, SYNCSORT, Easytrieve, DB2/UDB, Stored Procedures, File-Master, File-Aid, MF-EEE, AMB, MQ-Series, and Intertest.
• Good Experience in High-level and detailed technical software design documents.
• Strongest skills in support activities, analysis, technical design, testing mainframe applications.
• Good knowledge on testing SAS impacted programs.
• Strong skills in working with various debugging tools in the mainframe environment for trouble shooting using XPEDITOR, INTERTEST.
• Obtained strong skills in writing effective and exhaustive test strategies to ensure zero defect applications.
• Attained production support experience via usage of supportive tools including Remedy.
• Possess very good organizational, analytical, teamwork and Project management skills along with excellent interpersonal skills.
• Having an Attitude of willing to learn, accept the challenging environment and confidence in delivering the results within timelines by constantly motivating the concerned teams to provide the best solutions to the clients.
• Good experience working with offshore teams and ability to train the team members on process and technology updates in the project by conducting Knowledge sharing sessions and regular telecom meetings.

Skills:

Mainframes: COBOL, APS, DB2, CICS, JCL, VSAM, TSO/ISPF, SAS, SPUFI,

MVS, MFEEE, PL1

Tools: File-Aid, File-Master, Interest, Xpeditor, Sync sort, Change man, Endeavor, SCLM, Stored Procedures, File Master
Hardware: IBM Mainframes S/390.
Operating Systems: OS/390, Solaris 2.7, Windows 7/2008.

Programming: SQL, PL/SQL, XML
RDBMS: DB2/UDB, Oracle 8.x/7.x,

Education:

Graduated in Bachelor of Engineering

Professional Experience:

Project: Bank Deposit Program

Client: Confidential,

Role: Senior Consultant.

Duration: Nov 2009 to Till Date.

Description:
The Bank Deposit Program is a sweep alternative to money funds that allows clients to invest cash balances into FDIC insured bank accounts. Eligible Accounts enrolled in BDP will have free cash balances in their brokerage accounts invested/swept into interest bearing FDIC insured deposit accounts at ten Citigroup affiliated banks. All free credit balances will be automatically swept into the Bank Deposit Program. This provides the client with up to $1,000,000 of FDIC insured bank deposits in Citigroup affiliated banks with any overage deposited in a money market fund chosen by the client. The interest rate is based on the rate on SBCX.

Responsibilities:

• Interaction with Clients on Technical Requirements, Work Requests and new projects.
• Coordinate with Technical analysts and review the technical requirements, and prepare the required documents before starting the development process.
• Coding new programs in COBOL and enhancements in SAS Programs, Creating Adhoc reports in Easytrieve as per the requirements.
• Created new JCL’s and Procedures and SYSIN cards pertaining to the Project.
• Used Data manipulation tools like File-Aid, File-Aid for DB2/UDB, SPUFI/QMF effectively to analyze the performance of the DB2/UDB queries before coding them in the respective programs and Troubleshooting using Xpediter.
• Used Change man for Version control Management for all BDP Related Projects.
• Unit testing, preparation of test plans, test data, test cases and documenting Test results to ensure the Quality standards.

Project: Escheat Software Replacement.

Client: Confidential,Columbus GA.

Role: Senior Application Developer.

Duration: Sep 2009 to Oct 2009.

Description:

In 2009 Stone River, Owner of Tracker & APCES Multi-Tier Software announced they will no longer support APECS Multi-tier Software. Therefore, Aflac must convert to the Tracker software to ensure Aflac remains in compliance with State escheat regulations. The Tracker Software also ensures that Aflac includes the required information for each property reported to the states, which hopefully increases the chances of the states locating the owners of the property. The New software provides Aflac an opportunity to automate some manual process related to unclaimed property. Aflac is responsible for distributing letters to owners of properties in an effort to locate the owners prior to remitting the funds to the states.

Responsibilities:

• Interaction with Clients on Technical Requirements, Work Requests and new projects.
• Coding new programs in COBOL creating Adhoc reports in Easytrieve as per the requirements.
• Created new JCL’s and Procedures and SYSIN cards pertaining to the Project.
• Used Data manipulation tools like File-Aid, File-Aid for DB2/UDB, SPUFI/QMF effectively to analyze the performance of the DB2/UDB queries before coding them in the respective programs and Troubleshooting using Xpediter.
• Unit testing, preparation of test plans, test data, test cases and documenting Test results to ensure the Quality standards.

Environment: IBM-MVS, OS390, COBOL, JCL, CICS, DB2, VSAM, IOF, Endevor, SPUFI, QMF, XPEDITER, FILE-AID, File-Aid for DB2, SYNCSORT, QMF.

Project: Plastic Card System.

Client: Confidential,Atlanta GA.
Role: Senior Application Developer.

Duration: April 2009 to July 2009.

Description:

Atlanta-based SunTrust enjoys leading market positions in some of the highest growth markets in the United States and also serves clients in selected markets nationally. The Present Project deals with Existing Debit cards, Check cards and National Debit cards. And also to some more Business check cards and Personal Check Cards which are being introduced in conjunction with Major Airlines. The Project mainly emphasizes on checking whether the processes with are currently in place with existing cards also applies to the new cards based on various criteria and specifications.
Responsibilities:

• Interaction with Business Analysts on Technical Requirements, work Requests.
• Coding new programs in COBOL and Enhancements in CICS modules.
• Created new JCL’s and Procedures and SYSIN cards pertaining to the Project.
• Used Data manipulation tools like File-Manager, File-Manager for DB2/UDB, SPUFI effectively to analyze the performance of the DB2/UDB queries.
• Troubleshooting the components using tools like IBM-DEBUG.
• Unit testing, preparation of test plans, test data, test cases and documenting Test results to ensure the Quality standards.

Environment: IBM-MVS, OS390, COBOL, JCL, CICS, DB2, VSAM, IOF, Endevor, SPUFI, QMF, XPEDITER, FILE-Manager, File-Manager for DB2, SYNCSORT, QMF.

Project: Escheat State Mandate.

Client: Confidential,Columbus GA.
Role: Senior Application Developer.

Duration: Nov 2008 to Dec 2008.

Description:

Aflac is the holder of unclaimed property for Aflac Columbus and Aflac New York. Aflac is responsible for recording, tracking and reporting unclaimed property to states according to state regulations. Aflac is responsible for reporting beneficiary information for properties issued under a Life Policy in an effort to assist the states with locating the rightful owners after remitting the funds to the states. If The Checks that are issued under a life policy and that are payable to the insured, then at the time of check escheatment, both the insured and beneficiary data must be passed to APECS. If the check is made payable to the beneficiary(s) or any other payee such as a funeral home on behalf of the insured, then only the beneficiary data or payee data must be passed to APECS. The new system enhancements
Allowed automating the manual process of determining which properties belong to an A & H or Life Policy.

Responsibilities:

• Coding new programs in COBOL creating Adhoc reports in Easytrieve as per the requirements.
• Created new JCL’s and Procedures and SYSIN cards pertaining to the Project.
• Used Data manipulation tools like File-Aid, File-Aid for DB2/UDB, SPUFI/QMF.
• Unit testing, preparation of test plans, test data, test cases and documenting Test results to ensure the Quality standards.

Environment: IBM-MVS, OS390, COBOL, JCL, CICS, DB2, VSAM, IOF, Endevor, SPUFI, QMF, XPEDITER, FILE-AID, File-Aid for DB2, SYNCSORT, QMF.

Project: MSP Billing System

Client: Confidential,Peel Park, UK

Role: Programmer Analyst.
Duration: June 2005 to April 2008

Description:

Confidential,is a leading provider of energy, serving five million homes and businesses in the UK and in the western United States. CustomISer product is the Multi Utility IT Programme, formerly known as MSP (short for Multi Service Project).is based on the CUDOS commercial and domestic quarterly billing system and MSP Phases When the Phases are complete all of the Scottish Power gas and electricity accounts will be billed on CustomISer.

Gas and Electricity supply with options to bill supply, distribute and metering as individual offerings. Although CustomISer\'s primary function is billing, the metering and premises details are also maintained here, including third party meter details

Responsibilities:

• Designed and developed programs using APS-COBOL and MF-EEE ((Mainframe Express Enterprise Edition).
• Constructing the Source Code in APS-COBOL, AMB (App Master Builder) and involved in recompiling the DB2/UDB Programs working on Stored Procedures.
• Tested and Debugged the Programs using IBM-DEBUG tool.
• Used SCLM for Version control Management of all of MSP modules.
• Used APS Macros, APS Stubs, and Application Master Builder while coding new programs and On-Line Express for online programs.
• Prepare the test data and test plans and test cases in order to verify and validate the functionality of the Programs.
• Resolving Production issues and providing quality alternative solutions to challenging and new problems, Bug fixing (both data changes and code changes).

Environment: IBM-MVS, OS390, APS-COBOL, PL1, JCL, CICS, SYNCSORT, EASYTRIEVE, DB2, DB2/UDB Stored Procedures, SPUFI, IBM-DEBUG, MF-EEE, MF-COBOL, QMF, SDF, CA-7/CA-11, REMEDY.

Project: Confidential,

Client: Confidential,New York.

Role: Senior Programmer Analyst.

Duration: Sep 2004 to May 2005.

Description:

Confidential,offers Group Insurance and Individual Insurance. The Document Automation System, DocAuto concentrates on generating policy, booklet documents to the policyholders and beneficiaries of the Guardian Life Insurance (GLIC) Group line of business. It is a mainframe based application that consists of several components that work together to generate various types of policy and booklet documents. DocAuto interfaces with other Guardian Group systems including the Phoenix and Zeus applications. These applications provide Plan holder information to the Docauto system. This system is critical to the business since it generates legally binded policy documents and automatically ships it to the policyholders.

Responsibilities:

• Coding new programs in COBOL and Enhancements in CICS modules.
• Created new JCL’s and Procedures and SYSIN cards pertaining to the Project.
• Preparation of necessary documents like WRAF – Work Request Analysis Form, WRS – Work request supplements form and complete project documentation.
• Involved in resolving Production support issues
• Monitoring the execution of the jobs in Sameday batch process and docauto batch process using IOF and resolved the issues/abends that were occurred.

Environment: IBM-MVS, OS390, COBOL, JCL, CICS, DB2, VSAM, IOF, CHANGEMAN, SPUFI, QMF, XPEDITER, FILE-AID, SYNCSORT, POWERTERM/V32 EMULATER, In-house Utilities, QMF.

Project: Profile Conversion (PC)

Client: Confidential,Reston, Virginia
Role: Programmer.

Duration: Sep 2003 to Aug 2004

Description:

In the past several years Sallie Mae has bought/merged with several of their competitors. As part of the cost savings for the mergers/Acquisitions, Sallie Mae is converting many loans from one system (CLASS) to another system (Eagle). The conversion consists of converting the profiles from CLASS to the appropriate profiles on Eagle. The profiles control how the software works. The many profiles for CLASS do not match the many profiles for Eagle. The conversion lists the values from CLASS and creates information to load the Eagle profiles.

Responsibilities:

• Coding new programs in COBOL and Enhancements in CICS modules.
• Created new JCL’s and Procedures and SYSIN cards pertaining to the Project.
• Used Data manipulation tools like File-Master, SPUFI effectively to analyze the performance of the DB2/UDB queries.
• Used GT Software to create/maintain help for CICS screen fields and SDF to create new maps in CICS as per the specifications.
• Preparing the ENDEAVOR packages and getting them approved for next staging.
• Used PRIDE Application to track all SallieMae Reston system changes.

Environment: IBM-MVS, OS390, COBOL, DB2, JCL, CICS, VSAM, SPUFI, XPEDITER, FILE-MASTER, In-house Utilities, QMF, ENDEAVOR, PRIDE, GT, SDF, SAS

Project: Construction Intelligence

Client: Confidential,U.K.

Role: Consultant

Duration: Feb 2000 to Aug 2002
Description:

This project is mainly developed for Building Materials Association of U.K. This is mainly an E-commerce based portal, which facilitates the users with functionalities like Material identification, the appropriate usage related to Construction Industry adapting to various climatic conditions

Responsibilities:

• The job mainly involves identifying the category, to which a building material belongs, important attributes of the same which are manufactured by the clients in and around U.K. The data mining is done and the same is uploaded into the portal.
• Guiding a team of 30 members in categorizing, identifying and tagging the important and relevant attributes of the product. Also involved in assisting the database team for quality control. Also providing support at the database level for quality control.

Environment: SQL, VB, MS-Office.