Prasanna Kulkarni

Mainframe Technical lead

Phone #: 856-***-****

Email: acpwo7@r.postjobfree.com

PROFESIONAL SUMMARY:

• 7 years of strong experience in Design and Development in the fields of DB2 databases utilizing Mainframes.

• Worked on Cobol, CICS, VSAM, GDG, PL/1, REXX, Ezytrieve, DB2, JCL, SAS, Websphere MQ, ISPF,

PROCS

• Strong data processing experience in designing and implementing Data Warehousing applications.

• Strong working experience in the Data Analysis, Design, Development, Implementation and Support using

Mainframe applications

• Experience in creating functional requirement documents, system requirement documents, System design

documents, Test case documents and Test results Document .

• Experience in integration of various data sources like DB2, fixed block, variable block, VSAM and Flat files.

• Experience in performing Unit testing, System testing and Regression testing.

• Debugging and error solving by analyzing the application programs in Cobol, CICS, REXX, PL/1, SAS

• Experience in Performance Tuning, Optimization of SQL queries, Project approvals, Version control of

application programs using Mainframe tools like Explain, Endevor.

• Experience in DB2 database administration.

• Experience in Mainframe development using COBOL, CICS, REXX and VSAM

• Experience with IBM DB2 Analytics Accelerator (IDAA)

• Experience in Development of mappings in Informatica(PowerCenter designer, Workflow Monitor and

Workflow Manager)

• Excellent team player with good communication and interpersonal skills.

• Performed various roles like Project Leader, Module Leader, Developer.

• Experience in working in Onshore/Offshore model.

• Extensive experience in Investment banking, retail banking and finance, manufacturing, healthcare and

education domains.

• Experience in working on SDLC and Agile methodology processes.

• Quick learner and willing to learn new technologies and tools.

EDUCATION:

Bachelor of Engineering (Electrical)

TECHNICAL SUMMARY:

Software Cobol, Easytrieve, JCL, VSAM, DB2, CICS, Informatica(8.6/9.1/9.5)

Products

Tools AQT, Toad, Intertest, Dfsort/Icetool, File-Aid, Qmf, Spufi, Endevor, Osda, Explain,

Microsoft Office, CA7, Intertest, ISPF,PROCS, NDM, TSO, SAR, SDSF, Imagecopy,

Runstats, IDCAMS, JCLPLUS, IBM utilities

Databases DB2 v8, v9

Programming SQL, COBOL, CICS, PL/1, REXX, SAS

Operating Windows, Z/Os, Unix

systems

PROFESSIONAL EXPERIENCE:

Employer: Tata Consultancy Services, LTD

Sep 2008 – Current

Project Thesis

A) Fifth Third Bank-IDAA data warehouse

May 2014-Till date

Fifth Third Bank (5/3 Bank) is a U.S. regional banking corporation, headquartered in Cincinnati, Ohio at Fifth Third

Center, and is the principal subsidiary of holding company Fifth Third Bancorp. The company operates under an Ohio

charter.

The company's main areas of activity are as follows:

• branch banking

• commercial banking

• consumer lending

• investment advising

• Title insurance

Role: Project leader

The project I am working is IDAA-Data warehouse. The project scope includes

1) Migration of Data warehouse from current location Florence KY to new location in Grand Rapids MI

2) Installing and testing IBM appliance called IDAA for optimization of SQL queries.

Responsibilities:

• Analysis of the entire Data warehouse system to identify the components which needs to be changed, created for

migration.

• Development of JCL batch jobs, Procs and parameters.

• Perform unit testing and System testing.

• Perform IDAA performance testing and analyzing the SQL optimization.

• Creating new DB2 objects, unload/load tables across different environments.

• Creating new objects, tables, unload/load them in IDAA across different environments.

• Converted 100 SAS programs into REXX as a part of migration activity.

• Creation of Unit testing, System testing and analysis documents.

• Performing project lead activities and responsible for all the deliverables.

• Communicating with the customer, understanding the requirement, drafting the business requirement, co-

ordinating with the offshore team etc.

• Creating project dashboard, monthly metrix review documents to address the project level activities at corporate

level.

• Managed multiple short term projects like AML-CIP, UDS Deposit risks other than IDAA Data warehouse and

delivered them successfully.

• Communicate status of project, updates with, Stake holders, business users and clients.

Environment: JCL, DB2, AQT, SAS, REXX,, Imagecopy, Runstats, IDCAMS

Achievements: 1) Received customer appreciation for SAS-REXX conversion module

2)Received customer appreciation for successful deployment of AML-CIP project.

B) Advanced Broadband Solutions Inc. (ABSi)

June 2013-Mar 2014

Advanced Broadband Solutions Inc. (ABSi) provides engineering services and technology expertise in three specific

practice areas: Complex Servers (RS/6000 including the SP, Netfinity (NT) and AS/400), Enterprise Software Services,

and High-speed Networking (with focus on value- add engineering). Each practice can provide focused technology

support within its specific domain or can be combined to support the more complex requirements of an integrated

solution.

Role: Developer

The project I worked on is called TED ICD10. On this project we were updating an existing system for the Department of

Defense to validate their health claims from different medical providers.

Responsibilities:

• Loading and unloading of DB2 databases using JCLs, QMF

• Development of Cobol, DB2 programs to prepare the data for ETL system.

• Extensively worked with Designer, Workflow Manager and Workflow Monitor.

• Done extensive testing and wrote queries in SQL to ensure the loading of the data.

• Perform unit testing at various levels of the ETL.

• Preparation of Business requirement document, System Design Document, test case and test results documents.

• Developed and implemented the coding of Informatica Mapping for the different stages of ETL.

• Fixed the invalid mappings and troubleshoot the technical problems of the database.

• Used most of the transformations such as the Source qualifier, Router, Filter, Lookup, Aggregator, joiner,

Normalizer, Update strategy, Rank, Sequence Generator, Sorter, Transaction Control and Expression as per the

business requirement.

• Debug the sessions by utilizing the logs of the sessions.

• Extensive use of Parameters and variables.

Environment: JCL, Cobol, DB2, QMF, Toad, AQT, Informatica PowerCenter 8.6 /9.1/9.5 (Power Center Designer,

workflow manager, workflow monitor)

C) The City University Of New York

Nov 2012-May 2013

City University of New York (CUNY) is the nation's leading urban public university. CUNY is the third-largest university

system in the United States, in terms of enrolment, behind the State University of New York (SUNY), and the California

State University system. Serving 540,000 students, City University of New York (CUNY) has more than 271,000 degree-

credit students and nearly 270,000 in adult, continuing and professional education at 24 institutions in New York City.

Role: Programmer Analyst

Responsibilities:

Development of Application Framework and Application components, Support, Testing and Review.

I worked on following Applications:

1) SKAT(Skill Assessment Test)

2) SFA(Student Financial Aid)

• Perform Specific system requirements gathering with client interaction.

• Coordinated with Business Users to understand business needs and implement the same into a functional Database

design.

• Analyze system specifications to understand the application impacts.

• Create system requirement specification (SRS) documents.

• Create functional document by analyzing the system requirements.

• Generate the Student Skill assessment test reports and sending them to another server.

• Identify the suitable technology to implement the solution.

• Communicate impact to other interfacing applications and users.

• Communicate the project status to supervisor and stake holders.

• Development of application programs using COBOL, PL1 and REXX.

• Perform post implementation monitoring and support.

Environment: DB2, REXX, COBOL, JCL, VSAM, PL1

D) Chrysler LLC

June 2011-Oct 2012

Chrysler LLC is an USA based multinational automaker, in global strategic alliance with its majority owner, Fiat. It

produces the cars under brands Chrysler, Jeep, Ram, SRT, Dodge, Mopar and Fiat

The various aspects under Pentasap DBA support are:

• Creation of test region similar to production for testing purposes.

• Creation of new DB2 and IMS databases

• Creation of Tables

• Granting access to users on tables.

• Unloading and loading of tables.

• Giving solutions to user's queries and supporting for their testing.

Role: Database Administrator

Responsibilities:

• To configure the parameters of the database.

• Provide support for the database administration.

• Develop and maintain the application; implement quality standards.

• Review the developed code to ensure the quality standards are met using assent.

• Manage the implementation of db2 application.

• Monitor backup data to ensure consistency.

• Tune the performance of database using the aptune and explain tools.

• Set up and schedule administrative tasks in the database.

Environment: DB2, JCL, VSAM, Explain Tool, GDG,, Imagecopy, Runstats, IDCAMS

Achievements: Completed the IBM Certified Database Administrator - DB2 10 DBA for z/OS Certification

E) ML-Bank of America

Nov 2008 – May 2011

Bank of America is one of the leading global financial consultants and investment companies. It manages different

systems to satisfy its global clients. RRS is one such system which tracks, identifies and provides suggestion to the clients

to plan for their life after retirement. The project I worked was called GPC Retail Retirement Systems

The various categories under RRS are:

1) Fees

2) IK Core

3) AFS/ADS

4) MSA

5) CNS

6) SITS

7) Loans

Role: Mainframe Developer

Responsibilities:

• Development of Application programs using COBOL, CICS and DB2.

• Design of system functionalities.

• Unit Testing, System testing, Regression testing and Review.

• Debugging and fixing the defects.

• Creation of adhoc reports using Easytrieve tools and application programs.

• Scheduling the batch jobs using CA7 scheduler.

Environment: DB2, COBOL, REXX, JCL, VSAM, CICS, GDG, CA7

Achievements: Completed the DB2 UDB V8.1 Family Fundamentals certification.

Contact this candidate