Project System

• **+ years of experience in complete lifecycle of software development including

Requirement Analysis, System Study, Program Design,

Development, Unit Testing, System Testing, Integration Testing, System

Maintenance and Documentation

• Vast experience with maintenance, development, enhancement and production

support for mainframe based applications.

• Responsibilities have included analyzing business requirements, researching and

resolving technical problems, designing technical solutions, documenting and

implementing technical solutions and providing 24X7 production support for

mainframe based systems.

• Application development experience on IBM Mainframes using VS COBOL II,

VSAM, DB2 UDB, SQL, Stored Procedures, IMS, JCL, FILEAID, XPEDITOR,

REXX and CICS.

• Conversant with ISO 9001 and SEI CMM 5 quality procedures.

• Sound knowledge in using IBM utilities like SORT, IDCAMS, and IEBGENER.

• Worked on high to medium priority initiatives. This entailed complex query

construction, data analysis/fixes and on occasion code refinement(s).

•I have worked closely on data validation & reporting and contributed to numerous

process improvements. Additionally, facilitate & manage meetings on a daily

•basis with Business technical audiences

• Expert in development and maintenance of batch programs in COBOL and testing

with appropriate JCL.

•Worked on AS/400 enviornment.

• Ability to operate independently

• Skilled in exhibiting solid analysis, decision-making, and problem solving

• Ability to assess requirements, alternatives, and risks/benefits for low-to-medium

impact projects

• Excellent understanding and proficiency in JCL/Cobol and mainframe tools

• Ability to communicate effectively verbally and in writing

• Ability to accomplish client requirements through effective team building activities

with better understanding with team members

•Achieving customer satisfaction by ensuring service quality norms and build the

company image by exceeding customer expectations.

•Preparing, documents, tests, required programs and procedure data displays in an

efficient manner

•Ensuring reports, analysis data and programming code meet regulatory and company

standards and are consistently structuring to permit efficient programming and

reporting.

•Knowledge about Software Testing Life Cycle, Bug Life Cycle and SDLC

Email: ***************@*****.***

Phone : 513-***-****

TECHNICAL SKILLS:

Languages VS :COBOL II, JCL, PL/SQL, JAVA, SQL.

Operating Systems : MVS/ESA, OS/390, Windows XP / 2000 / 98

Tools/ Software : CICS, XPEDITOR,SPUFI, REXX, File-Aid, TSO/ISPF, Peregrine,

Install/1,CONTROL-M,BMC tools, CA-Easytrieve Plus

Access Methods : VSAM

Databases : VSAM, DB2 UDB, IMS

GUI Tools: : Visual Basic 6.0, Visual Interdev, Jbuilder 5.0, Visual Studio

Version Control Tools: : Visual SourceSafe, Rational Rose

Java/J2ee Technologies : Core Java, Servlet, web server

Web/Application Servers PowerTier, IIS 5.0

:

PROFESSIONAL EXPERIENCE:

Cincinnati Financial Corporation, Fairfield, OH (Mar 2008 to Oct 2010)

The Cincinnati Insurance Companies continuously strengthen service by offering agents and

policyholders a stronger local presence, unparalleled claim service, work-saving technology initiatives

and competitive products, rates and compensation.

COBOL Programmer/Analyst

Responsibilities:

• Developed detail systems design

• Reviewed approved system design with project team.

• Developed program logic and reviewed programs that required modification.

• Developed necessary JCL.

• Performed unit testing, systems testing, and user testing activities.

• Assisted with system testing as required.

• Performed implementation activities, which included cleaning up the test environment

and initiating promotion procedures.

• Provided technical assistance to end-user and I/S staff.

• Assisted with routine work of the department as required.

Worked on MVS operating system with COBOL, DB2, JCL, Endevor.

GEICO, Chevy Chase, MD (Apr 2007 to Nov 2007)

GEICO is one of the largest auto insurance companies in the United States. Active member on multiple

projects. Projects included adding functionality for commercial lines of insurance and collectively working

on production tickets to solve problems in CICS screens with DB2 database.

Senior Programmer Analyst

Responsibilities:

• Unit Testing of CICS, DB2, COBOL programs.

• Set up the necessary testing environment to test with DB2 database.

• Checked if the data was available to test all the test cases. If not, requested DBAs to copy

the data from production.

• Migrated modules to appropriate Endevor stages for Integration and User Testing.

• Prepared required paper work for monthly release for test cases, review documents, test

results and migration documents for moving the modules to production.

Environment: MVS, VS COBOL II, DB2, JCL, File-Aid, Endevor, SPUFI, JIRA, CICS

Wellpoint, Mason Oh (July 2005 to Dec 2006)

WellPoint is the nation's leading health benefits company serving the needs of approximately 34 million

medical members nationwide. WellPoint is included in the S&P 500 index

Project: Check free Apecs Integration

The purpose of this project was to integrate the OH and VA Recon and Bars accounts to CA Recon.

Mainframe Developer

Responsibilities:

• Coded Unit Testing of new programs to retrieve name and address information from DB2 tables.

• Coded and Unit Tested necessary reports for the unknown name and addresses.

• Converted Bars account numbers to Recon account numbers.

• Created/Modified Procs.

• Created JCLs when required to send the data to CA mainframe

• Supported feature/integration and User Acceptance Testing.

• Conducted code reviews for the development work

• Implemented the programs/procs/jcls/sortcards, etc. in production.

Project: North East Reporting

New Reports Developed on CT Mainframe:

Responsibilities:

• Created design documents for the new report programs (weekly and monthly claims

reports).

• Prepared the unit test case documents for the report programs

• Coded 12 new programs, created the necessary jobs, procs, copybooks, and sort

parameters.

• Identified the new datasets and GDGs.

• Moved the programs, procs, jcls, parms, copybooks to Endevor.

• Completed the Unit Testing.

• Supported Feature/Integration Testing and User Acceptance Testing.

• Created DB2 parms, DB2 packages and bonded the programs to appropriate DB2 Region

for Unit, Feature and User Acceptance testing

• Conducted walkthroughs with service delivery team for code, design and unit test cases

Environment: IBM 3090, MVS, VS COBOL II, DB2, JCL, File-Aid, Endevor, Peregrine Service Center,

Easytrieve,Clearquest,VSAM

WellPoint North East Reporting:

Legacy Anthem converted to the new WellPoint MBU account structure effective January 2006. New

Northeast Reports were created to include the new WellPoint chart fields. These reports are now used

to balance and reconcile the NE source systems to the General Ledger and the Data Warehouse.

Project: Finance Integration

Mainframe Developer

Responsibilities:

• Participated in the development and enhancement of new programs, JCL and procedures

to redirect the files

• Modified existing reports / creating new reports as per the direction from business

partners.

• Setup JCLs to FTP the data files to PeopleSoft general ledger.

• Supported Feature, Integration and User Acceptance Testing for the modified modules in

the system

• Moved all the modified programs, procs, jcls, parms to Endevor.

• Created packages.

• Created the implementation plan and migration documentation for production move.

• Conducted walkthroughs with service delivery team for code, design and unit test cases

• Tested DMS GEN - Processed FCS, Facets data through DMS job cycles and sent the

GL interface file to central translator

Environment: IBM 370, MVS, VS Cobol II, JCL, File-Aid, Xpeditor, Endevor, Peregrine Service Center,

Clearquest.

SONY Electronics (Worked in IBM as contractor) (Feb 2003 to July 2004)

Sony Business Application is mainly divided into 4 systems: Logistics, STN (Sony Tighter Network), Data

Warehouse and EDI. Logistics system is then further divided in subsystems like IMEX, C-Tracks, HUDD,

Exports, Shipment Close, Treasury and Freight.

Mainframe Developer

Responsibilities:

• Study of existing system, databases and dependency of various applications involved in

SONY business.

• Provided production support to SONY Electronics for their Logistics System

• Resolved business critical problems within 2 hours which involved job amends due to

data problem, contention, deadlock, FTP, file not existing, space amends etc. (Carried

pager and mobile to get notified for job failures)

• Challenges involved acquiring thorough business knowledge of SONY electronics

systems

• Developed new programs to create new reports as per user’s requirement.

• Followed specified quality procedures and documented all tasks during the life cycle.

• Provided permanent fix to frequently occurring job amends.

• Handled the user request, examples included: user getting problem in reports, error

messages while using/accessing online screens, invoices not received loaded into

IMEX(Import/Export) system, errors related to Freight allocation

• Modified the existing programs as per the requirements

• Completed the enhancement work within the stipulated time as per the documentation.

• Identified bugs/problems in existing code and provided the permanent fix to the problem

• Developed a tool in REXX for checking coding standards

Environment : IBM 3090, MVS, Visual Studio, HTML, DB2 UDB, SQL, XML, CICS, VS Cobol II,

VSAM, JCL, IMS, File-Aid, Xpeditor, Peregrine, SPUFI, REXX, Control-M

Projects done in L&TITL (Pune India) 1998 to 2003

Travelers,

Travelers Automation is a program that automates the testing of mainframe based applications. Existing

mainframe application is developed in CICS, VS COBOL.

Programmer /Analyst / Developer

Responsibilities:

• Studied existing travelers’ application/database and created understanding documents.

• Tested database creation for test automation and test data preparation.

• Coded WinRunner TSL script to automate the testing of mainframe based applications

• Tested entire mainframe application through WinRunnerREXX tool that was developed while

test data preparation. BMC tools used to improve CPU performance

Environment : IBM S390 system, WinRunner 7.1, Visual Studio, XML, HTML, CICS, Install/1, VS

COBOL II, DB2, SQL, BMC Tools, REXX, MS-ACCESS

UniSure,

The Re-Insurance system is in a mainframe environment. The system, which interacted with VSAM

originally, was changed to interact with DB2. Online and Batch COBOL programs were modified and then

tested. The programs were divided into work packets. A pre-processor tool was developed and used to

convert the programs to replace the VSAM file fields to DB2 table fields. Analysis involved mapping of

the VSAM tables used in the original COBOL programs to corresponding DB2 tables, and the study of

program logic / flow. Coding involved converting the transactions on VSAM tables to SQL queries/cursors

for corresponding DB2 tables so that the original functionality was retained. Rigorous Unit Testing of all

the programs was carried out to ensure 'Zero Defects'

Software Programmer /Analyst / Developer

Responsibilities:

• Preprocessed tool development for the faster conversion process from VSAM to DB2.

• Analyzed the existing VSAM files used in original application and mapped to corresponding

DB2 tables

• Studied existing program flows

• Code involved converting the VSAM calls to appropriate SQL Queries for DB2 in COBOL

programs.

• Wrote stored procedures wherever necessary.

• Unit and Integrated tested applications for batch as well as online programs

• Conducted trainings on IBM utilities, DB2 Catalog Table

• Developed a tool in REXX for checking language standards.

Worked on AS/400 Platform which is RDBMS supported, menu driven interface,

Support for multiple users.

Environment: AS/400, CICS, COBOL, DB2 UDB, OS390, REXX, JCL, VSAM

Johns Manville,

This project was to setup QA region Environment using existing development database. It was just like

installation of new DB2 subsystem on mainframe. Once environment was working, setting up data

migration utility into QA System was done.

Programmer /Analyst

Responsibilities:

• Analysis/Study of existing applications.

• Setup environment on JM's Machine to setup new DB2 subsystem on mainframe.

• DBA related activities included access control, modification of JCL for backup etc.

• Coordinated with Application team to modify existing application according to requirement

• Coded (COBOL), Tested and Implemented different Utility to meet requirement.

• Handled daily request related to Data mismatch in JMs data ware house setup.

Environment: S90 Mainframe, MVS environment, COBOL II, JCL, VSAM, DB2 Version 6.1

Cars Information System (CIS),

CIS is a leading Campus administrative software provider. This software mainly caters to higher

education segment. The existing CARS system ran on AIX & HP-UX & and was tightly coupled to

Informix database. The project was to re-engineer the CARS Edvanta system. EdVanta is an

application that caters to Administration/Campus Management needs of a University. The system is

targeted for use by educational institutions for complete management of admissions, student database,

financial management, etc. The re-engineering involved converting a host centric, Informix application

to a Web based, platform independent, database independent and n-tier product.

Programmer/Analyst

Responsibilities:

• Studied existing system that runs on AIX & HP-UX.

• Requirement gathering of Cars Edvanta system to re-engineer the system.

• Prepared high level and low level design using Rational Rose during the Design phase

• Built application menu hierarchy using Xml.

• Coded programs in Java and prepared test plans, wrote test cases for Unit as well as

Integration Testing.

• Designed and coded for the Scheduler using EJB. Scheduler is used in Menu system to

schedule the tasks as per time, daily, weekly, monthly.

Environment : Windows NT 4.0, Informix 7.3 on HP-UX, JDK 1.2, EJB, XML, PowerTier EJB Server,

Rational Rose 2000 Enterprise Edition, Netscape Directory Server 4.1

CDS Software,

TeamChimes is a software package developed for CDS Software Inc., USA. TeamChimes is developed

for a Health Care System. TeamChimes is a web-based product. The TeamCoach assesses the

completed tasks to evaluate the performance of task areas and employees. TeamCoach builds the

performance database of tasks and employees depending upon the feedback of the assessments.

Depending upon the performance it recommends training to the employees or the task areas.

TeamCoach is web-based system which, is divided into following modules: Assessment, Surveys,

Rounds, Training, and Complaints

Project: TeamCoach

Software Programmer /Analyst

Responsibilities

• System analysis and documentation of requirement specifications

• Database design and implementation.

• Preparation of high level and low level design.

• Coded Java classes, code reviews, design reviews, prepared test cases, prepared test plan, Unit

testing, Integration testing

Environment : Windows95, WinNT 4.0, Microsoft Visual J++ 6.0, JDK 1.1, Microsoft Access, JDBC,

Visual Source Safe, MS Office 97, Palm OS, Microsoft IIS Server, Code Warrior SDK

CDS Software, Dec 98 to Apr 99

The TeamLinen is a web based laundry management system. It provides for the management of

laundry and linen distribution tasks through the enhancement of information flow and control of tasking

information. This program will accommodate entry of linen requirements and distribution tasks through

hospital order /entry system or manually, scheduling of recurring tasks, request status tracking,

employee status monitoring, assessment of labor productivity, and reports for analysis for analysis by

staff and client

Project: TeamLinen

Software Programmer /Analyst

Responsibilities:

• System analysis and documentation of requirement specifications

• Database design and implementation.

• Preparation of high level and low level design.

• Coded Java classes, code reviews, design reviews, prepared test cases, prepared test

plan, Unit testing, Integration testing

Environment: Win95, WinNT, Microsoft Visual J++ 6.0, JDK 1.1(for windows), Microsoft Access,

JDBC, Visual Source Safe, MS Office 97

IMS, Year 2000 conversion project

IMS gathers, maintains and provides Medical statistics for many countries world-wide. This project

involved the work to analyze the date fields, processes related to it and to making it Y2K capable. The

techniques used were Fixed Windowing, Data Encoding and Physical Expansion as applicable.

Responsibilities:

• System analysis (Cobol and PL/1 programs)

• Database and copybook analysis to provide input to driver programs

• 3.Writing test cases, Unit Testing using JCL

Environment: IBM ES/9000, VS COBOL II, JCL, XPEDITER, ENDEVOR, PANVALET, PDM, PL/1

EDUCATION:

Bachelor of Computer Science (B.E), Shivaji University, India (B.S Computer Science)

Contact this candidate