Gaurav Jain

acqnfk@r.postjobfree.com

480-***-****

Summary

Certification

Certified Scrum Master, 2014

KYI – Banking Industry, 2011

IBM Database Associate, 2007

Experience

Ten years of IT industry experience encompassing a wide range of skill set, roles and industry verticals.

Extensive experience with analysis, design, development, customizations and implementation of Mainframe based software applications using COBOL, JCL, DB2, VSAM, CICS.

Hands on experience in COBOL, DB2, JCL, VSAM, Stored Procedure, performance Tuning.

Proficient in analyzing and translating business requirements to technical requirements and architecture.

Strong database skills and development knowledge.

Experience in leading and managing teams. Handled multiple roles – Project Management, Technical Product Owner, Technical Lead, Business System Analyst, Software Developer, Onsite Coordinator.

Executed software projects for Banking and Finance industry.

Good experience in process like Water fall, Iterative, Agile/Scrum.

Good communication skills, interpersonal skills, self-motivated, quick learner, team player.

Recognition / Achievements:

Received Service Excellence Award in April-2015

Received The Best Of IBM Award in Sept-2014

Received Service Excellence Award Sept-2012

Received HSBC Thanks Award Nov-2007

Education:

B.E. in Instrumentation Engineering from Jorhat Engineering College, Dibrugarh University, Assam, from the year 1999-2003.

Higher Secondary from Bholanath Booruah College, Guwahati, from the year 1997-1999.

H.S.L.C (Matriculation) from Vidya Mandir School, Guwahati in the year 1997.

Technical skills

COBOL

Job Control Language(JCL)

CICS

DB2

VSAM

Endeavor, Changeman

Xpeditor

File Aid, SPUFI, QMF

Data Studio

HP Quality Center, Rally

Relativity Tool

Command Editor, Development Center, Command Center

PL/1

Basic Java

Microsoft Windows XP

Microsoft Word

Microsoft Excel

Internet Explorer

Professional Experience

Project - Merchant Interactive (MI)

Client - American Express

Designation - Tech Lead, Mainframe Application

Duration - May, 2010 – Till Date

Team Size – 10 to 25

Application: Merchant Interactive (MI) - Merchant Interactive is a suite of products offered to Merchants that accepts Amex card. It includes Dispute management, Payments to Merchant and Online account Management. It’s is web based application. Data is stored in DB2 tables and it is sent to front end (Web based screen) using DB2 Stored Procedure. The database is refreshed by batch jobs written JCL. I have worked on several new features and enhancements in this application which includes –

Implementation of Disputes Functionality in EMEA

Implementation of Rich Internet Based Disputes Functionality in JAPA and LAC

Design of Global Dispute database for International and Domestic Markets.

Implementation of GMAR and Omniture tagging in OMS application

Re-write of Domestic Disputes

Migration to GDM from legacy case systems.

Roles: Technical Product Owner, Technical Lead, Developer, Tester.

Responsibilities:

Leading and executing a project / work package within a project from a technical / functional perspective.

Produce and explore requirements in collaboration with users.

Define "complete" requirements, data analysis to understand the usage and decide on the user experience.

Work with users to develop acceptance criteria or test cases for the system.

Communicate project objectives and end-user requirements to the team based on inputs obtained from the Project Manager and communicate effectively with all relevant stakeholders, regarding delivery feasibility, planning, project progress status and milestones.

Manage quality throughout the lifecycle of the projects.

Manage and mitigate risk and issues, manage assumptions, dependencies and constraints of the project / module of the project.

Assisting Project Manager in Project Planning, Control and Closing.

Technical planning, execution and monitoring of project tasks.

Engage and collaborate with Business, Testing, and Configuration & Release management teams for the execution of the project.

Participate in people management activities.

Develop source code for the program, unit or module. Follow coding standards.

Participate in code review activities.

Conduct unit testing and system integration testing.

Project - Various Core Banking Projects

Client - HSBC

Designation – Senior Software Engineer

Duration - Jan, 2006 – April 2010

Team Size – 4 to 15

Project 1 - Regulation Demand Deposit (Sept, 2009 – April 2010, HSBC, Pune, India)

Scope: Demand Deposit is an accounting system at HSBC. The application is known as DDA. The objective of this project is to make the required changes to DDA systems to address disclosure requirements related to overdrafts and Bring HSBC disclosures into compliance with revised Regulation DD amendments as noted in the final rule published in December 2008. The effective date for these Regulation DD amendments was January 1, 2010.

6 New COBOL program were developed to make this amendments. It’s a batch process and source of data is QSAM and VSAM files.

Project 2 - Client Service Menu (Aug, 2008 – Aug 2009, HSBC, Buffalo, NY)

Scope: Designed a Graphical User Interface (GUI) based front end Application written in Java. The user facing screen (Front end screen) interacts with CICS Online programs via MQ series and gets the data stored in DB2 database. This application is used by users to set up new wholesale deposit customers and accounts for the bank.

Project 3 - National Check Encashment (Nov 07 – Jul 08, HSBC, Buffalo, NY)

Scope: Designed a product called National Check Encashment for the commercial customers of the Bank. To accommodate partnership between our Payments and Cash Management Division (PCM) and Certegy, this product provides Certegy with payroll “check issue” data from our clients that are subsequently used to verify the payroll checks which may be presented for payment at various retail businesses, via Certegy terminals.

Project 4 - Teller Positive Pay (Nov 07 – Jul 08, HSBC, Buffalo, NY)

Scope: Bank’s Official check data was sent to third party for verification and payment. A new in house application called Teller Positive Pay was developed to handle this process. BMS screens were developed which interacts with CICS online program to find the status of a check. The screen were also used for update the status of a check real time. The data was stored in VSAM files.

Project 5 - Customer Profile System (Jan 06 – Oct 07, HSBC, Pune, India)

Scope: The Customer Profile panel is an enquiry-only function that is the first point of reference for users when either in contact with, or preparing for contact with HSBC customers.

Developed new CICS program and modified existing CICS programs for MCD Phase 1.2 UK functionalities which includes RM Portfolio, Contact History, Contact Logging, Account Summary, Account Plan, Individual Solution Enquiry/Update/History etc. This online program calls Customer Data utility and Band data utility programs to get customer and bank data respectively. The database was Db2.

Role: Project Management, Onsite Coordinator, Technical Lead, Cobol Developer

Responsibilities:

Onshore Coordination - I was onshore coordinator and was poasted at Buffalo, NY from Nov – 2007 to Sept, 2009. Coordinating with onshore and offshore team was primary responsibility.

Communicate project objectives and end-user requirements to the team based on inputs obtained from the Project Manager/Business users and communicate effectively with all relevant stakeholders, regarding delivery feasibility, planning, project progress status and milestones.

Manage quality throughout the lifecycle of the projects.

Technical planning, execution and monitoring of project tasks.

Status reporting of project tasks to Project Manager on weekly basis.

Engage and collaborate with Business, Testing, and Configuration & Release management teams for the execution of the project.

Develop COBOL source code for the program, unit or module. Follow coding standards.

Participate in code review activities.

Conduct unit testing and system integration testing.

Prepare implementation, verification and back out plan for new software.

Perform root cause analysis, Pareto analysis and Fish bone analysis on the defect data captured during design, build and testing phases.

Providing production support on need basis.

Project - Merrill Lynch Global Core and Reporting

Client - Merrill Lynch

Designation – Associate Consultant at Zensar Technologies, Pune

Duration - Sept, 2005 – Dec 2006

Team Size – 10

Project Name: Merrill Lynch Global Core and Reporting (Sept 05 – Dec 05, Zensar, Pune)

Scope: Merrill Lynch is one of the world’s leading financial management and advisory companies with offices in 44 countries. Merrill Lynch handles total client asset of $1.4 trillion. Merrill Lynch is a leading global underwriter of debt and equity securities and strategic advisor to corporations, governments, institutions and individuals worldwide. ZenSar India in association with Fujitsu Consulting is involved in 7 X 24 production support, enhancements and maintenance of Mutual Fund application at Merrill Lynch. The application is developed in Cobol, DB2, CICS on mainframe. It is a batch system comprising 1600 jobs.

The application is sub divided in two modules namely

1.CORE

2.Reporting

CORE – CORE is a critical module in Mutual Fund processing cycle. It takes in all executed orders for Merrill Lynch Mutual Funds and settles for broker/dealer as well as for proprietary business. After orders are flown in CORE, various jobs run to calculate the different fees, charges and commissions. Once the trade is generated position, profit-loss, credit and other back office related files are updated in CORE. This is a daily job and provides data to various reporting modules. Originally CORE was online software but was customized and standardized for Merrill Lynch’s use.

Project – POLA OCM

Client - POLA

Designation – Associate Consultant at Zensar Technologies, Pune

Duration - Dec, 2004 – Aug 2005

Team Size – 6

Scope: Migration of POLA OCM. POLA is one of the biggest cosmetics firm in Japan. OCM is a system used by the POLA people (sales members) to register orders online. The system has various functions like order registering, Order correction, correction and enquiry of returned products and enquiry of order status. POLA OCM programs are written in PL/1 which interacts with CICS. The jobs are written in Job Control Language (JCL) and the data is stored in VSAM files. The POLA OCM application which is running on mainframe environment were migrated to GUI bases front end application written in Java and

Role: Cobol Developer

Responsibility:

I was involved in production support and Implementation of change request which includes changing Job Control Language, COBOL programs etc depending on the requirement.

Develop COBOL source code for the program, unit or module. Follow coding standards.

Participate in code review activities.

Conduct unit testing and system integration testing.

Understanding PL/1 source code and documenting it in English.

Contact this candidate