Prasanna Kulkarni
Mainframe Technical lead
Phone #: 856-***-****
Email: *******************@*****.***
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.