ABCD Mobile : +91 -
98488XXXXX
Email : xxxxxdba@yahoo.com
Summary of Professional Experience
· Having 3 years of
experience as Database
Administrator.
· Having hands-on
experience in DBA activities like Implementing Database Design, Data Maintenance,
Authorization and privileges for DB2 access, Regular Back up and Recovery
Activities.
· Diligent,
versatile, ambitious, hardworking and with excellent interpersonal and
Representation skills.
· Experience in
operational 24x6 support, best practice trouble shooting, monitoring.
· Strong pro-active
team player.
Professional experience:
·
Working
as DBA for XXX Global, XXX from jun 2009 till date.
·
Worked
as DBA for YYY, YYY from Jul
2007 may 2009.
Educational
Qualifications:
- Master of Computer Applications from OsmaniaUniversityY.
- B.Sc (Computer Science) from OsmaniaUniversityY.
Technical
Skills:
Operating Systems : ZOS, OS/390, Windows XP
Languages : COBOL, JCL
Databases : DB2
Tools : TSO/ISPF, SPUFI, QMF, DB2 Admin tool,
BMC tools
Project
Project
1 :
Project : Insurance Management system
Client :
State Farm
Insurance of America(SFI)
Duration : jun
2009 till date
Organization : XXX Global
Domain : Insurance
Description:
This project is an
Enhancement Project related to the Life Insurance and various systems involved
in it are General Policies Systems, Maturity Systems, Claims Systems, Loan
Systems and Report Systems.
The system enables
the users to see the available policies, benefits, terms and conditions and new
schemes and select the appropriate option and conduct the premium transactions.
It will also facilitate the company to focus on the customer service and give
the timely response back to the clients.
Responsibilities :
· Handles the
authorizations of DB2 objects to users, applications and Utilities.
· Creating views and other DB2 objects depending upon
the application group requirement.
· Alteration of
objects definitions.
· Regular Backup and
Recovery.
· Load and Unload
utilities.
· Starting and
stopping Db2 subsystems.
· Starting and
stopping of databases, tablespaces, indexspaces .
· Monitering the
Object.
Project 2 :
Name : Financial
Services and Processes (FSP), AVIS Inc, USA.
Duration : Jul 2007 may 2009.
Client : AVIS CCRG (Cendant Car Rental Group)
Location : YYY, India
Duration : Jul 2007 may 2009.
Client : AVIS CCRG (Cendant Car Rental Group)
Location : YYY, India
Descrption:
The existing application (Source system) will be on Mainframe and the target system will be on People Soft. The basic functionality of this project is to extract the data from the appropriate IMS DB segments as well DB2 tables across the interface level and feed the data according to the AVIS Europe People Soft data formats. The data from IMS as well DB2 databases are to be unloaded and data converted as stated in Transformation Rules as provided by the AVIS Europe data standards.All the Revenue location data is stored in IMS Data base segments and Non‑Revenue location data is stored in DB2 tables.
The existing application (Source system) will be on Mainframe and the target system will be on People Soft. The basic functionality of this project is to extract the data from the appropriate IMS DB segments as well DB2 tables across the interface level and feed the data according to the AVIS Europe People Soft data formats. The data from IMS as well DB2 databases are to be unloaded and data converted as stated in Transformation Rules as provided by the AVIS Europe data standards.All the Revenue location data is stored in IMS Data base segments and Non‑Revenue location data is stored in DB2 tables.
Responsibilities:
·
DBA
activities
·
Implementing
Database Design: Database, Table space, Table, Index and various objects.
·
Data
Maintenance.
·
Authorization
and privileges for DB2 access.
·
Regular
Back up and Recovery Activities
·
DB2
Utilities: Runstats, Reorgs,
DSNCOPY, DSN1COMP etc.
·
Query
tuning, stored procedures, Triggers.
·
Involved
in Performance tuning and Problem Solvig..
3.
PROJECT : AMEX GPP(Global Product
Platform)
Company : xxx Inc.
Client : American Express
Duration : e
Role : ADMIN
Environment : JCL, TSO/ISPF, SPUFI, QMF, DB2 Admin tool
Description:
American Express was started in the year 1850 and plays various roles in the financial sector. American Express plays a vital role in the Cards domain. They deal with Open and Closed cards. The Global Product Platform is a platform designed exclusive for Stored Value Products which are either owned or managed by American Express.
Company : xxx Inc.
Client : American Express
Duration : e
Role : ADMIN
Environment : JCL, TSO/ISPF, SPUFI, QMF, DB2 Admin tool
Description:
American Express was started in the year 1850 and plays various roles in the financial sector. American Express plays a vital role in the Cards domain. They deal with Open and Closed cards. The Global Product Platform is a platform designed exclusive for Stored Value Products which are either owned or managed by American Express.
