Shridhar Kulkarni

Email: ac0x62@r.postjobfree.com

Cell: +1-505-***-****

Summary

10+ years of experience in Software Analysis, Design, Development, Testing, Implementation, Support and Documentation of multitier Business Applications with specialization in Mainframe technologies; worked extensively with Cobol, JCL, CICS, VSAM, DB2, File-Aid, SORT, QMF, SPUFI, Microfocus Cobol, ETL DataStage 9.1.2, ETL DataStage 11.5, Oracle 9i, Oracle 11g.

Extensive exposure in Software Development Life Cycle (SDLC) of the projects from requirement analysis to implementation, maintenance.

Extensive experience in writing/debugging Programs in Cobol, CICS, JCL, MicroFocus Cobol.

Proficient in data loads and data conversions using ETL DataStage 9.2.1 / ETL DataStage 11.5 / Informatica 6.2.1 /Informatica 9.6.1 Hot Fix 4

Fair understanding & working knowledge in Unix shell scripts, REXX and CLIST

Innovative professional with proven ability to identify, analyze, and solve problems to increase customer satisfaction through expertise knowledge in database programming

Hands on experience in performing analysis and writing jobs of IBM Datastage ETL and Informatica tool.

Experience in gathering enhancement requirements from business users and business analyst

Experience in working with offshore teams and geographically distributed team.

Demonstrated ability to work in both independent and team-oriented environments with well-developed organizational skills and excellent interpersonal and communication skills, self-starter and a quick learner.

Overview knowledge on Banner CIS system.

Technical Skills Summary

Technology

Tools

Databases

Oracle 11g, Oracle 9i, DB2, IDMS

Technologies/ Programming Languages

Cobol, MicroFocus Cobol, CICS, JCL, VSAM, Unix shell scripting, ETL DataStage 9.2.1, ETL DataStage 11.5, Informatica 6.2.1, PL/SQL,SQL

Operating Systems

Windows, Unix

Tools/Utilities/IDE

Microsoft TFS, Appworx Job Scheduler, PL/SQL Developer, Serena Dimensions, Service Now, ChangeMan, Endevour, File-AID, Xpeditor, Putty, WinScp, SecureCRT 7.2, File-AID, SORT, QMF, SPUFI, WebMethods 6.5

Business Intelligence Tools

IBM Datastage ETL Tool 11.5 / Informatica 6.2.1 / Informatica 9.6.1

Professional Expérience

Employer:

Cognizant Technology Solutions US

Project 1: Passport Maximo Data Conversion (Jan 2017 – Till Date)

Role: Sr. Systems Analyst

Client: PNM Resources

Location: Albuquerque, NM USA

Roles and Responsibilities:-

Create mapping documents based of the requirements of fields required in Maximo 7.6 System

Discussions with Client Partners for the conversion of data from Legacy system to new Maximo System

Create ETL DataStage 11.5 Jobs based on the Mapping document and Discussion with Client Partner

Verify the Converted Data, Test it in Maximo if all the integrity is maintained

Project 2: Passport Application (Apr 2012 – Dec 2016)

Role: Sr. Systems Analyst

Client: PNM Resources

Location: Albuquerque, NM USA

Details of the project:-

Passport is an end to end Asset Management System that enables PNM to manage Design & Work Management, Contract Management, Procurement and Inventory modules across its Transmission, Transmission & Distribution Lines of Business. This project includes providing maintenance and support to this high-available system, generating reports on demand and automating these reports, and enhancing the system as per the business needs.

Roles and Responsibilities:-

Involved in various stages of SDLC like Requirement gathering, high level design, low-level design, Coding.

Support and Maintain interfaces between Passport and other interfacing systems.

Generated complex Ad-hoc reports for the business users using SQL Queries and PLSQL programs

Involved in Performance tuning for the application. Used EXPLAIN PLAN, indexes etc.

Extensively used PLSQL Developer tool for database access and PL/SQL Development and SQL tuning.

Work with business users and business analysts to gather and clarify requirements related to bug fixes and enhancements

Provide technical and business solutions to the team members

Co-ordinate with infrastructure and database teams to perform DR activity.

Analyze and improve the performance of the application.

Coordinate with different development teams and helping them in understanding business requirements

Responsible for creating batch jobs and scheduling them using Appworx Job Scheduler

Provide oncall support for high priority issues in batch and online environments.

Analyzed, modified and written from scratch ETL jobs using IBM Datastage Designer / Informatica PowerCenter Designer/WorkFlow Manager/ WorkFlow Monitor tool

Worked on ETL DataStage upgrade project (Version upgrade from 9.2.1 to 11.5). Converted around 50+ Jobs

Modified existing MicroFocus Cobol programs to implement business logic in batch jobs

Responsible for creating batch jobs and scheduling them using Appworx/UC4 Job Scheduler

Involved in debugging various defects relating to implementation of business logic.

Used Team Foundation Server (TFS) version control tool.

Start/Stop/Modify WebMethods 6.5 services which were an interfaces to external Vendors for Invoicing.

Appreciated by Client for implementation of Passport Server Migration Project successfully without any post production defects. This migration along with Server also included Upgrade in Java, Tomcat and Apache versions.

Project 3: ESPP Application (Aug 2010 – Feb 2012)

Role: Sr. Systems Analyst

Client: BNY Mellon

Location: Pune, India

Project Details:-

With the Emergency Economic Stabilization Act of 2008, Congress concluded over a third of individuals is misreporting their capital gains and losses by overstating cost basis. Therefore, this legislation seeks to facilitate IRS enforcement by forcing the industry to track and report adjusted cost basis and holding period information for covered securities. Because of this enactment, the IRS expects to raise $6.67 billion in tax revenue over a 10 year period. If BNY Mellon SOS does not comply with these regulations, the IRS could enforce penalties be imposed for the following failures on our part to:

File a correct 1099-B

Provide correct payee statement

Provide a correct transfer statement to a transferee broker

Provide corporate action information

Generate Account-Key module development

Roles and Responsibilities:-

Gathering requirements from Client

Review the requirement and technical specification documents to ensure that the correct requirements have been captured, and the solution provided satisfies business needs

Provide support to the testing team during System Testing and UAT Support.

Employer:

HSBC GLT, Pune

Project 4: One Bank (Oct 2009 – Aug 2010)

Role: System Analyst

Client: HSBC

Location: Pune India

Project Details:-

Leading provider of Banking and other financial services to individual and institutional customers.

Develop new services

Business analysis

SME reviews

Designing for different services

Technical assist for development team.

.

Roles and Responsibilities:-

Requirement Study and Analysis: Understanding the requirements of the task assigned to me and suggests what needs to be done in order to fulfill the requirements.

Roles : Functional Lead, Design Lead.

Create Functional Design and Technical Design.

Coding: Writing new codes for different services from Scratch.

Testing and debugging.

Documentation.

Direct Communication with Client.

Resolving Technical and Non-Technical queries.

Employer:

Patni Computers, Pune

Project 5: Auto & Home Insurance Enhancement (Jan 2007 – Sept 2009)

Role: System Analyst

Client: Metlife Auto and Home Insurance

Location: Pune India

Project Details:-

Leading provider of Insurance and other financial services to individual and institutional customers. The company is currently in the business of selling various types of Property and Casualty insurance products like Auto, Boat, Home, Fire and PELP.

Auto Insurance Policy administration is the Project, handling maintenance support and enhancements, related to Auto insurance business. The application handles New Business as well as the Inquiry system and Endorsements in the existing policies.

Maintenance Change Requests

Service Requests

Cleanups

Production Problems

Business analysis

Roles and Responsibilities:-

Requirement Study and Analysis: Understanding the requirements of the task assigned to me and suggests what needs to be done in order to fulfill the requirements.

Coding: Making code changes to the existing programs of writing new programs for the given task.

Testing and debugging.

Documentation.

Direct Communication with Client as well as Onsite coordinator.

Resolving Technical and Non-Technical queries.

K-Rep.

Configuration Manager (CM).

Project 6: Reverse Engineering (Jun 2006 – Dec 2006)

Role: System Analyst

Client: Metlife Auto and Home Insurance

Location: Pune India

Project Details:-

Main objective of this project is data analysis of the re-plat forming effort of Insurance company following:

Home servicing and renewals.

Auto Servicing and renewals.

Pre-rating and automatic activity for Auto, Home.

Data analysis is done for each attribute of the life cycle of above mentioned lines of business. Following information against each attribute would be captured and documented:

Full definition.

All possible values (This includes the meaning of valid values).

Where the attribute is used in the policy lifecycle (New business, Renewals, Servicing).

How the attribute is used in the policy lifecycle.

Relationship to other attributes.

Relationship within the business object model (BOM).

Roles and Responsibilities:-

Analysis and documentation of complete life cycle of each variable of Auto master file.

Final (SME) reviewer of the document.

Tracking and ensure weekly delivery to onsite.

Appreciations and Awards

Multiple Certificates of Appreciation from PNM Resources

Won the Patni’s Dream team award for the excellent team work in the very first project.

Received Kaizan Certificate for Value Innovation done in the project.

Received Valuable Contribution Award for Q1 2009.

Education

Masters in Computer Application (Science) with First Class, New Modern College, Pune University, India in 2008

Personal details

Date of Birth

January 25th 1985

Present Location

Albuquerque, New Mexico, USA

Languages Known

English, Hindi, Konkani, Marathi

Marital Status

Married

Visa Type

H1B (Valid till 30th September 2018) Approved I-140

Location Preference

No Constraints

Contact this candidate