Oracle Project

Chinni Bolapati Email: ******.********@*****.***

Mobile: +91-984*******

EXPERIENCE SUMMARY

• Over 7+ years of experience in IT which comprises 6+ years experience in Banking Domain

• Currently working as Oracle Production DBA at Royal Bank of Scotland, India since April 2011

• Worked at Oracle India Pvt Ltd during Sep-2009 to Mar-2011 in Retail Domain

• Worked at HCL Technologies during Jun-2005 – Sep 2009 in Banking Domain(Deutsche Bank)

OVERSEAS EXPERIENCE

• Was onsite through HCL Technologies at Deutsche Bank, Singapore for one year ( Sep 2007 – Aug 2008 )

EDUCATION

• B.E (Hons) Chemical, BITS-PILANI (7.5 CGPA)

EXPERIENCE DETAILS

Oracle Database Administrator for Oracle 11g, 10g and 9i versions - experienced in

11gR2 Grid Infrastructure

RAC

ASM

Grid Control

Data Guard

Installations, Upgrades, Patches, Application Script releases

Backup and Recovery - RMAN

Performance Tuning

Database Vault

Exports – Expdp, impdp, exp, imp

Production support 24/7 databases

Automation using shell scripting

Streams, Golden Gate

Development experience

Architecture design

Partitioning, mviews

Shell scripting

Perl scripting

Peoplecode development

SQL Tuning and optimization

Jsp, ASP, C, Oracle Forms, Proc

Other experience

Oracle Retail applications DBA

Peoplesoft DBA

on IBM – MQ series

Control-M experience

CVS and PVCS administration

Experienced in handling 24/7 critical Banking databases of over 5TB in size

TOOLS

• DBDesigner, Erwin,PVCS, CVS,Toad, SQLDeveloper, Infoman, HP Service Centre, HPSA

CERTIFICATIONS

• Oracle 10g Database Administrator Certified Professional.

• Oracle PL/SQL Developer Certified Associate.

• Basics of Banking, IIBF

• ITIL V3 Foundation

TRAININGS ATTENDED

• Oracle 11gR2 Grid Infrastructure – November 2011

• Oracle 11g R2 RAC (from Oracle Corporation India, Bangalore, Nov 22-26, 2010).

• Oracle 10g Performance Tuning (from Oracle Corporation India, Bangalore, March 12-16, 2007).

• ITIL V3 Foundation

• Basics of banking, Derivatives, Trade Finance, Foreign Exchange Markets

• General Accounting Principles, Basics of Securities, Reconciliation

• Retail Products – RMS,RWMS

• Soft skills like Email etiquettes, Communication skills

ACHIEVEMENTS AT WORK

• Received Performance Award in 2012 at RBS towards the recognition of my effective work.

• Recognized at Oracle Corporation for saving nearly 322 man days per year using Automation

• Part of O3 League (Extraordinary Performers Group) at HCL

• Received “Zenith Award” for successful completion of six sigma Yellow belt in HCL Technologies.

• Faculty for Oracle PLSQL programming training t HCL Technologies

• Trained employees on Unix at HCLT Singapore Awarded as “Best Performer of the year 2006” in HCL Technologies

• Part of SME (Subject Matter Expert) group of Oracle PLSQL in HCL and of Interview Panel for Oracle

• Recipient of AAA award, given for excellence at work, at HCLT Singapore.

• Received “Gold Medal” in 12th standard

PROFESSIONAL SUMMARY:

Project : GIS Oracle Support - Production

Company : Royal Bank of Scotland

Duration : Since Apr 2011

Role : Oracle Production DBA

Work Location : Chennai

About the application:

GIS is a Infrastructure Group at RBS which supports Production Databases of RBS. There are over 3000 production databases to which our group is providing support. These database are using various technologies like RAC, ASM, Datagaurd, Replication, RMAN Backups, streams etc..

Responsibilities:

• Production Oracle DBA

• Backup/Recovery, Patching, Maintenance of databases, Performance tuning

• Applying release to production

Environment:

• Oracle 11g/10g/9i, RAC, ASM, Oracle Designer, CVS, PVCS, Oracle Forms, Proc

Project : DSS – Database Support Services

Company : Oracle India Private Ltd

Duration : Since Oct 2009 – Mar 2010

Role : Oracle DBA

Work Location : Bangalore

About the application:

DSS is a group which maintains all the databases of Oracle Retail products. Having about 200 databases to support DSS has formulated multiple standards to maintain the source code of the databases. DSS provides support to around 30 products and the support includes maintenance of source code in version controllers, database maintenance, and database design maintenance.

Responsibilities:

• Oracle DBA. Installing retail products RMS,RWMS,RETL,RIB,ARI

• Tuning, Version Controlling, Shell Scripting, Scripts Migration

• Database design maintenance

Environment:

• Oracle 11g/10g/9i, Oracle Designer, CVS, PVCS, Oracle Forms, Proc

Project : DBCris

Client : Deutsche Bank, Germany. Through HCL Technologies Ltd

Duration : From Sep 2008 - Sep 2009

Role : Oracle DBA, PLSQL mentoring and tuning.

Work Location : Bangalore

About the application:

DBCris is a data warehousing which collates the trading data received from various sites. The data that is stored in dbCris is used by various other downstream applications which essentially cater to different functionalities of the bank. Inflow of the data to the database is by MQ Series which mainly consists of securities information and cash transactions information.

Responsibilities:

• Oracle DBA, Tuning, Application scripts release

Environment: Oracle 9i, 10g, AIX 5.2, Control-M, MQ Series 6.0

Project 03 : TSS-IT

Client : Deutsche Bank, Singapore

Duration : Sep 2007 – Aug 2008

Role : Oracle DBA

Work Location : Singapore

About the application:

TSS-IT, Trust and Securities Services, is a group of projects which cater to the financial sectors like Trade Financing, Fund Administration. These projects are implemented by tools which are developed in house as well as bought from third party vendors like Simcorp Dimension. As part of database administration team we maintain the databases, taking care of availability and accessibility of the backend system. Supporting various other areas in the project, other than database maintenance, like message transmitting process, MQ series, UNIX level application scripting and scheduled jobs from Control M is also a major component of work of a database maintenance group.

Responsibilities:

• Oracle DBA, Tuning

• Unix, PLSQL scripting, Supporting MQ Series at scripts level

Environment: Oracle 9i, 10g, AIX 5.2, Control-M, MQ Series 6.0

Project : C-WATCH

Client : Deutsche Bank, Singapore. Through HCL Technologies Ltd

Duration : July 2007 – Sep 2007

Role : Schema designer, Oracle DBA,PLSQL Developer

About the application:

C-WATCH application is a structured products valuation and a Risk & Collateral monitoring system for PWM (Private Wealth Management) division of Deutsche Bank Singapore. DB Trader is parent application of C-WATCH which provides trading features of various instruments that includes Stocks and Shares, Options, Foreign Exchange, Money Market and other instruments. All Business transactions, Master and Static Data changes in DB Trader by Business users are near On-Line replicated in to C-WATCH database and further enriched with C-WATCH specific data to achieve the business requirements. After enriching the data, C-WATCH generates various reports, both online and Start of Day (SOD), which are very crucial for the bank to monitor the collateral value of the customers.

Responsibilities:

• Redesigning the data model for Start of Day Reports as these reports are taking very long time to generate.

• Developing the new data model for SOD reports.

Environment: Oracle 9i, Java

Project : db Reward

Client : Deutsche Bank, UK. Through HCL Technologies Ltd

Duration : Mar 2006 – June 2007

Role : Oracle DBA and PLSQL Developer

About the application:

Compensation Controlling Team is responsible for reporting and managing all the cash and stock bonus compensation plans within Deutsche Bank Group. This project is to develop and implement the Compensation Controlling System which covers Data Sourcing, Data Processing and Reporting of Cash Bonus, Stock Compensation plans and other expenses related to Swap Interest and Equity Administration costs. This System combines the information received from both Controlling and HR Sources to produce the financial booking files. The system has the following modules incorporated

• Deferred Compensation Financial Accounting

• Bonus Monthly Reporting and Year End Processing

• Swap Interest and Equity Administration

Responsibilities:

• DBA for the Development development/testing databases in Oracle 9i and for people soft PIA.

• Developing PLSQL procedures/Functions/Triggers as developer.

• Configuration Controlling and releasing the new/changed modules.

• Upgrading the data base from people tool 8.42 to 8.46.

• Involved in Database design of the application using Erwin tool.

• Involved in Capacity planning of the application (Data Warehousing)

• Strongly participating in performance tuning in the project.

Environment: People Tools 8.46, PL/SQL & Oracle 9i

Project : People Tools Migration

Client : Deutsche Bank, Germany. Through HCL Technologies Ltd

Duration : June 2005 – Feb 2006

Role : Peoplesoft Developer

About the application:

DB-people application is the customized version of People Soft HRMS module (Ver. 7.0) used by Deutsche Bank for automation of its HR activities. In the project Oracle databases are migrated from 8i to 9i and People Tools 8.18/8.43 upgrade to 8.46.

Responsibilities:

• Peoplecode developer

Environment: AIX, People Tools 8.46, PL/SQL, UNIX shell scripting & Oracle 8i/9i

Contact this candidate