Project Manager

KISHORE ALR

Mobile : +91-814*******

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

Career Objective:

To learn and improve day-by-day and to take up new and

challenging responsibilities which helps me grow better.

Professional experience:

. Currently working with HTC Global Services, Hyderabad as a Senior

Software Engineer from Oct 2009 to till date.

Experience Summary:

. Software professional with 4.4 years of experience in design,

development and maintenance of applications using Mainframe

technologies.

Major Strengths:

. Experience in COBOL, PL/1, JCL, SQL,DB2, IMSDB, VSAM and CICS

. Executing projects using Agile methodologies

. Analyzing requirements, Preparing designs and Performing enhancements

. Preparing Check and Report SQLs.

. Preparing test cases and test logs

. Preparing proper estimates and analyzing the challenges to be faced

. Following up with the onsite teams for query resolution and calls

. Reviewing offshore deliverable before delivering it to the onsite

teams

. Ensuring timely and defect free deliverables

. Maintaining quality procedures related to projects

. Experience in the Insurance domain

. Extensive use of HP Service Manager to solving the Requests, Problems

and Incident tickets.

Technical Skills:

Languages COBOL, JCL, SQL and PL/1

Operating Systems MS Windows, and Z/OS

Databases VSAM, DB2 and IMSDB

Applications ISPF, Xpeditor, IBM Data Studio, SPUFI, QMF, Lotus

Notes, File-AID and Rdz

Middleware CICS

Educational Qualification:

. B.Tech - Instrumentation and Control Engineering with 70.01% at

SKTRMCE, 2003-07.

. Board of Intermediate with 72.6% from Ravindra Junior College,

Kurnool, 2001-03.

. SSC with 71.33% from Everest English School, Kurnool, 2000-01

Awards and Achievements:

. Awarded as Employee of the month multiple times.

. Got appreciation mails from my managers and Onsite Co-Coordinators for

quick and accurate work

Personal Skills:

. Hardworking with good perseverance

. Commitment towards work assigned

. Strong Belief in Never give up attitude

. Easy to approach for help

. Can effectively communicate and collaborate with team members

Project Experience:

StateFarm Insurance, IL July 2013 to Present

Project Name: Data Cleanup - Single Source

Description:

Customer data is been stored in the different databases on the basis of the

type of Policy the customer opts. As per the Cleanup Design, there has been

the change in Customer database and making it as single source for any kind

of retrieval.

Roles and Responsibilities:

. Worked as a team member and involved in analyzing the specification

provided and coding the programs in COBOL, DB2 and JCL from scratch.

. Preparing the Test Cases and Unit Testing.

Environment: JCL, COBOL, VSAM, SQL, DB2, SPUFI, Lotus Notes and Rdz

StateFarm Insurance, IL April 2013 to June 2013

Project Name: Marketing Systems

Description:

The project aims at enabling the Marketing Systems team to develop a

process which assigns mailer information for all leads related to Current

Corporate Marketing Campaigns in Marketing Systems Lead/Lists Management

application which is under Opportunity Management of CRM Marketing

Management.

This effort includes loading of mailer information into letter-lead table

in Pre LMS (Leads Management Process) stage and pulling the mailer

information at Post LMS process for current LMS process. Apart from this

developing a totally new Post LMS process which functions with new Sales

Force (SFDC) application and environment.

Roles and Responsibilities:

. Worked as a team member and involved in analyzing the specification

provided

. Preparing proper estimates and analyzing the challenges to be faced

. Doing Peer reviews among the team for all the Deliverables

Environment: PLI, JCL, SQL, DB2, VSAM, COBOL, Rdz, SPUFI, Lotus Notes, and

MVS

StateFarm Insurance, IL October 2010

to March 2013

Project Name: SAMS Service - Maintaining Data Quality of database

Description:

As Team Lead involved in the SAMS service project, which enables the SAMS

service team to fix the defects of AIMs update process and analyze the

daily update error table.

Responsibilities:

. Creating, updating and analyzing the incident/problem tickets in HP

Service Manager

. Preparing Check and Report SQLs which fetch the data form DB

. Analyze and estimate for changes and Preparing high level design

documents

. Coding Jobs which include multiple databases such as DB2 and IMS-DB to

verify and correct/update the data discrepancies

. Working with Onsite Coordinator on the work priorities for the team

. Allocating work to team and following up with the onsite team for

query resolution and calls

. Reviewing offshore deliverable before delivering it to the onsite team

. Guiding the team for timely and defect free delivery of the results

Migrate Electronic Library Data to the Associate Data Store

Migrate Electronic Library Data to the Associate Data Store and transfer

ownership of the data to the Associate Register System area.

. Identify the possible scenarios where we may get discrepancies from

the initial population.

. Validating the SQL's prepared by others and testing the output

records.

. Check for active and inactive role counts and prepare ELIB (Electronic

Library) reports accordingly.

Environment: COBOL, PLI, JCL, SQL, DB2, IMS, Xpeditor, Panvalet, QMF,

SPUFI, Lotus Notes, IBM Data Studio, and MVS

State Farm Insurance, IL March 2010 to September

2010

Project Name: Assignment Hold List

Description:

As Team Member involved in the development of Assignment Hold List project,

which handles the data for agents, who are put on hold to carry out their

business. The project involved developing host (mainframe) services for the

web team to retrieve the data and carry out insert, update, and delete

operations on Assignment Hold tables.

Responsibilities:

. Performing analysis of the specifications provided

. Preparing proper estimates and analyzing the challenges to be faced

. Developing retrieval stored procedures and insert, update, correction,

and delete functionality stored procedures

. Preparing test cases, test logs, and fabricating the data for testing

. Performing unit testing and reviewing the test results

. Performing knowledge sharing with other team members

Environment: PL/1, COBOL, JCL, SQL, DB2, SPUFI, File-AID, Xpeditor, IBM

Data Studio, Lotus Notes, and MVS

Indianapolis Power & Light Company October 2009 to February

2010

Project Name: IPL-Mobile Data Project

Description:

As Team Member involved in the enhancement and testing of IPL-Mobile Data

project, which involved converting CICS programs to DB2 stored procedures

that maintains the electric meter details of IPL customer such as new meter

installation, meter removals, meter disconnect, and meter investigation. It

also involved segregating the application program to CICS program and DB2

stored procedures, which will be invoked from web applications.

Responsibilities:

. Performing enhancements

. Participating in planning and estimations phases

. Performing analysis, design, coding, and unit testing

. Managing defects and reporting the status to the customer

. Communicating with the onsite team

Environment: COBOL, CICS, JCL, SQL, DB2, SPUFI, Xpeditor, and MVS

Personal Details:

Father's Name Narayana AV

Nationality INDIAN

Marital Status Married

Date of Birth 27/01/1986

Languages Known English, Hindi,Tamil and Telugu

Declaration:

I hereby declare that the information provided is true.

Place:

Date: (KISHORE ALR)

Contact this candidate