Ravi Sharma
Email: **.**********@*****.***
Phone: +316******** - Netherland
Objective
To secure a challenging and responsible position in a corporate environment in which initiative, skills,
ambition and commitment to excellence will be utilized to their full potential.
Experience Summary
v
v
v
v
v
v
v
v
v
v
v
Strengths
v
v
v
v
Ability to grasp new technology and tools quickly.
Excellent Communication Skills
Very good presentation skills
Excellent business acumen with strong analytical abilities coupled with sound technical
knowledge
v Self belief
v Passion and commitment towards work
Technology
Below is a list of software technologies, tools and methods that I have worked on.
Software
•
•
•
•
Operating Systems: MS Windows 2000/XP, MVS, IBM Mainframe
Database: DB2, IMS
Programming Languages: COBOL, JCL,ADGEN
Others: C,C++,JAVA, NETWORKING, Shell Script
Associated with TATA Consultancy Services Limited (TCS) for last 44 months.
Extensive experience on COBOL, JCL, DB2, ADGEN, IMS.
Strong Working Knowledge on MVS, IBM Mainframe IBM OS390.
Strong Working Knowledge on various tools like Expediter, File-Aid, ECG, OPC, SPUFI,
ISPW, Fault analyzer, IS300 etc.
Excellent in SQL Queries and Database object.
Proficiency in Analysis, Design, Coding, Bug Detection, defect isolation and other soft
skills.
Designing and Coding and Self testing Application Components.
Participated in the Defect and Problem Prevention meetings.
SPOC for investment applications of Reporting and Contract. Handle the onsite meeting
with clients.
Experienced in support activities during System and User Acceptance Test and provide
them technical guide.
Ability to grasp new technology and tools quickly.
Tools
•
•
•
•
•
•
•
•
•
ADGEN
SPUFI
Expediter
File-aid
ISPW
ECG
QMF
OPC
Fault analyzer
Page 1 of 7
Page 2 of 7
Qualifications
Degree and Date
Bachelor of Technology (B-
E), June-2007
Certification Summary
Technicle Certification :
Exam Number
DB2-733
DB2-701
DB2-700
Redhat Linux
EL
Institute
Sarvjanik College of Engg &
Technology,Surat,Gujarat.
Major and Specialization
Computer Science
Exam Description
DB2 IBM CERTIFIED DEVELOPER
DB2 DBA IBM CERTIFIED ADMINISTRATOR
DB2 IBM DATABASE ASSOCIATE
Redhat linux certification EL.
Date
17th Apr-2009
6th-jan-2008
17th- Aug-2008
Only courses
undertaken
from JETKING.
Functional Certification:
Exam Name
European
Banking
Concept
Banking
and finance
fundamentals
NCFM
Exam Description
European banking and governing body. Emerging of
EURO as single European currency.
Financial Technology Centre(TCS subsidiary) –
Certificate Program in Banking Competency (E0)
N.C.F.M ( National Certification for Financial
Management ) from N.S.E ( National Stock Exchange )
Date
15th Jan 2011
3rd Dec-2008
17-Aug-208
Project Thesis
Project Title
Description
Role
Responsibilities
ABN AMRO
ABN AMRO is an international bank with European roots. They
have a clear focus on consumer and commercial clients in
their local markets and focus globally on select multinational
corporations and financial institutions, as well as private clients.
ABN AMRO is a prominent international bank, their history
going back to 1824. Now with more than 4,500 branches in
60 countries, a staff of over 110,000 full-time equivalents,
ABN AMRO ranks eighth in Europe and 13th in the world based
on total assets of EUR 999 billion (as on 1st January 2010).
Module Leader
Onsite co-ordinator for investment banking modules.
Responsible for the quality of the deliverables.
Resolving technical as well as functional issues.
Ensuring timely delivery of all the deliverables.
Configuration Management.
Page 3 of 7
Assignments
Project
Customer
Period
Description
Role
Solution Environment
Tools
Platforms
O/S
Highlights
REMEDY – Securities clients
ABN AMRO, Amsterdam, Netherlands
Feb 2011 – Till Date
Main aim of this project is to separate some clients from ABN
AMRO to Dutch Bank. It is a compliance project. After Remedy
implementation some clients will be move to DUTCH bank and
will be deactivate from ABN AMRO system. So customer don’t
affect due to separation of banks.
Onsite Co-ordinator / Module Leader
IBM Mainframe
COBOL,DB2,IMS,ICASCADE,ISPW,ADGEN
IMS-DC,IMS-DB,DB2,Cobol,JCL
OS390
•
New COBOL modules were written to extract the data
of clients and send to DUTCH bank.
New module created for Transfer the current clients
position to Dutch bank,
New Modules created to transfer historical transaction
to the Dutch bank.
New modules created to perform book off of the
positions.
New modules created to provide the corporate action
related benefits to the clients.
Very crucial project as it is a compliance project for
ABN AMRO.
New transactions and PSB defined.
•
•
•
•
•
•
Project
Customer
Period
Description
Role
Solution Environment
Tools
Platforms
O/S
Highlights
TIR ( Technical integration of Retails clients)
ABN AMRO, Amsterdam, Netherlands
July 2010 – Feb 2011
Main aim of this project is to merger of Fortis Bank and ABN
AMRO bank. Main purpose of this module is to provide all the
clients who have IVR service (Telephonic Banking) with Fortis
bank should also receive the IVR service after migrating to
ABN AMRO system. So customer don’t affect due to merger of
banks.
Onsite Co-ordinator / Module Leader
IBM Mainframe
COBOL,DB2,IMS,ICASCADE,ISPW,ADGEN
IMS-DC,IMS-DB,DB2,Cobol,JCL
OS390
•
New COBOL modules were written to insert FORTIS
clients to ABN AMRO system.
Migrated clients’ assigned SALDO Service, Transfer
•
Page 4 of 7
Service and Investment inquiry service depending
upon the core banking accounts.
Very crucial project as a part of merger,
New transactions and PSB defined.
•
•
Project
Customer
Period
Description
Role
Solution Environment
Tools
Platforms
O/S
Highlights
Periodic investment ( PEBEL )
ABN AMRO, Amsterdam, Netherlands
January – 2010 to APR -2010
Main aim of this project is to realize new channel (Internet
banking) for investment of internal fund of ABN AMRO which is
similar to mutual fund.
Team member
IBM Mainframe
COBOL,DB2,IMS,IPMS,CASCADE,ISPW,ADGEN
IMS-DC,IMS-DB,DB2,Cobol,JCL
OS390
•
•
New ADGEN module made and existing changed.
New Cobol modules made with check pointing and
restartability.
Loading and unloading jobs created.
New transactions and PSB defined.
•
•
Project
Customer
Period
Description
Role
Solution Environment
Tools
Platforms
O/S
Highlights
Static data
ABN AMRO, Amsterdam, Netherlands
June-2008 till date
This is a part of the Release wise development wherein
different change requests from the business are compiled
related to different functionalities.
Team member
IBM Mainframe
COBOL,DB2,IMS,IPMS,CASCADE,ISPW,ADGEN
IMS-DC,IMS-DB,DB2,Cobol,JCL
OS390
•
•
New ADGEN module made and existing changed.
New Cobol modules made with check pointing and
restartability.
New AV2 batch jobs built
New services built
New services built for the order entry system to validate
if the orders can be placed on a particular service
concept.
New DB2 load unload jobs built in AV2 environment for
the business to have direct access to production tables
•
•
•
•
Page 5 of 7
Project
Customer
Period
Description
Role
Solution Environment
Tools
Platforms
O/S
Highlights
Exposure on Derivative(EOD)
ABN AMRO, Amsterdam, Netherlands
March-2009 to May-2009
Project EOD is the successor of MIFID (Markets in Financial
Instruments Directive) project. The main objective is to send
the client derivative exposure report and inform about risk
associated with derivative before client place an order.
Team member
IBM Mainframe
COBOL,DB2,IMS,IPMS,CASCADE,ISPW
IMS-DC,IMS-DB,DB2,Cobol,JCL
OS390
New 14 cobol programs are made from scratch to
send the client exposure report based on clinet’s
account deviate from preffered portfolio.
• Existing dataservices changed for interfacing with
Internet and Intranet screens
• New jobs built for synchronising data between
Investment domain and the central repository of
contracts
ABN AMRO Base Support
•
Project
Customer
Period
Description
Role
Solution Environment
Tools
Highlights
ABN AMRO, Amsterdam, Netherlands
May 2008 – till date
This is an ongoing Maintenance and Production Support
project, catering to the investment activities of ABN AMRO. On-
site and offshore teams support these applications. The role
is as a team member managing about 3 key applications at
offshore.
Team member
IBM Mainframe
COBOL, JCL, TSO, Abend Aid,DB2,IMS,Advantage
Gen,Telon,Xpeditor,File Aid,IPMS,CASCADE,ISPW.
•
•
•
•
•
•
•
Estimation of the task.
Configuration Management.
Project Status reporting.
Quality review of the task.
Production Support.
Preparing MOM.
Creating Task in IPMS
• Requirement Analysis of Change requests: This
consists of analyzing the Change requests affecting
business and estimating the time required to complete
the request.
• Coding of Programs: Once analysis is complete, the
actual coding starts. While coding appropriate care
is taken that the required functionality is met and the
existing functionality of programs does not change.
Page 6 of 7
•
Creating Test Plan: The test plan is prepared in such
a way that it will consist of all test conditions that are
possible.
Unit Testing: The changed elements are thoroughly
tested to verify the required out put.
Creating system specific documentation in CASCADE:
This consists of preparing detail documentation
regarding the application system. This will give a
broad view on the various aspects of the system like
Application Knowledge, Business Aspect, Special
Process, and Production Support.
Production support to various applications.
•
•
•
Career Profile
Dates
27th-Feb-2008
1st-Aug-2007-20-Feb-2008
Achievements
v Received appreciation from IVR Project Manager for TIR – IVR project which was
published in TCS BFS magazines.
v Received STAR OF THE MONTH awards for REMEDY PROJECT performance.
v Certificate of appreciation for Static release wise development project, from
customer(ABN AMRO) , which got very high CSI from client
v FUN-AT-WORK Co-ordinator for TCS project level events.
v I was selected as mainframe selection panel co-ordinator for TCS ABN-AMRO
relationship.
v Assigned as trainer for Db2 trainings.
– Till Date
Organization
TATA Consultancy
Services Limited
Varaha System pvt. Ltd.
Role
Assistant System Engineer
Support Engineer
Personal Details
Date of Birth
Nationality
09-12-1984
Indian
Passport Details
Name as on
passport
Ravi Sharma
Relations
hip
Self
Passport
Number
G4286475
Date of Issue
21-Oct-2007
Expiry Date
20-Oct-2017
Place of Issue
Surat
Page 7 of 7