Project Sql

SUMMARY

. Total *.* years work experience. Around 4 year as DBA, SQL, PL/SQL, DB

tuner, 5.5 years in Designing, Developing and Troubleshooting of Database

Applications.

. Tuned some of the highly business critical queries, jobs which were

taking hours to execute in seconds and meet SLA.

. 12x7 on call support.

. Exposure to Data Guard, OEM Grid, Log Miner, RAC 10g, UNIX shell

scripting.

. Table partitioning using range, hash. Global, local indexing technique.

. Managing tablespaces, datafiles, redo logs, tables and its segments.

. Maintaining data integrity also managing profiles, resources and password

security.

. Managing Users, Privileges and Roles.

. Administering Oracle 10g networking such as listener.ora and

tnsnames.ora.

. Initiate and interpret user and system session traces using TKPROF.

. Monitoring and optimizing the performance of the database using automatic

workload repository (AWR) and automatic database diagnostic monitor

(ADDM).

. Usage of performance views, usage of performance utilities (Automatic

Workload Repository and Statspak).

. Implement and perform activities utilizing transportable tablespaces.

. Perform Oracle 10g Data Pump Import and export utility.

. Perform hot, cold backup & recovery.

. Perform periodical Backup, restoration and recovery using RMAN.

. Extensive experience with Oracle, SQL, PL/SQL, Performance Tuning, Oracle

Bulk features and Collections.

. Oracle Certified Associate OCA 9i (Dev), OCP 10g (Admin) with thorough

knowledge of Object-Relational DBMS Architecture, Application Tuning and

Query optimization.

. Undergoing training in RAC.

. Excellent communication skills with strong analytical and interpersonal

skills.

. Worked for clients like Cisco Systems Inc., CAP GEMINI ERNST & YOUNG, GE,

TATA INSTITUTE OF FUNDAMENTAL RESEARCH.

Technical Skills

Databases: Oracle 8i, 9i, 10g.

Tools: Developer6i (Forms 6i, Reports

6i), TOAD, Kintana,

Mercury Quality center, Remedy.

Languages: SQL, PL/SQL.

Operating System: UNIX, Windows 95/98/2000/NT/XP.

Version Control Tools: Visual Source Safe, WINCVS, PVCS.

Education

B.E. (Bachelor of Engineering) in Electronics from Mumbai University,

June2000.

Certification Summary

Oracle 10g OCP Certification.

Oracle 9i OCA Certification.

PROFESSIONAL EXPERIENCE

Client: Cisco Systems Inc., San Jose, CA Aug 2006 - Till

Date.

Project: Performance Group

This project involves proactively maintaining, tuning various applications

across Cisco Systems, Inc.

Environment: Oracle 10g/9i, LINUX, SQL, PL/SQL, TOAD.

Role: Team Member.

Responsibilities:

. Tune badly running SQL's using Explain plan, TKPROF, Dynamic

performance view.

. Provide suggestions for improving existing application code.

. Assisting team members giving them technical guidance, support

wherever required.

. Proactively Tune badly running SQL's using Explain plan, TKPROF,

Dynamic performance view, AWR.

. Provide suggestions for improving existing application code.

. Backing up database using RMAN.

. Managing Users, Privileges and Roles.

. Performing Oracle 10g Data Pump Import and export utility.

. Using Flashback Query (FBQ)

. Responsible for providing SLA based production support.

. Instance tuning.

. Capacity Planning and storage management.

. Table partitioning using range, hash. Global, local indexing

technique.

. Managing tablespaces, datafiles, redo logs, tables and its segments.

. Maintaining data integrity also managing profiles, resources and

password security.

. Assisting team members giving them technical guidance, support

wherever required.

Client: Cisco Systems Inc., San Jose, CA April 2006 - Jul

2006.

Project: Partner Data Center.

Partner Data Center (PDC) is a Migration Project, which involves upgrading

the existing database on which around 32 applications are running to Oracle

10g, Tuning the existing applications, Consolidating schemas from other

databases and making the necessary code changes.

Environment: Oracle 10g, LINUX, SQL, PL/SQL, TOAD, WIN CVS, PVCS, Kintana

Workbench.

Role: Team Member.

Responsibilities:

Was actively involved in Database Migration and post migration

validations.

Worked with DBA to get the top SQL's in existing applications and tuned

the same.

. Worked closely with cross functional teams to ensure data integrity is

maintained in both upstream and downstream systems.

. Created stored procedures, functions, packages in PL/SQL wherever

required for data analysis.

. Was involved in fixing, testing Defects raised during QA testing.

. Assisting team members giving them technical guidance, support wherever

required.

Client: Cisco Systems Inc. July 2004 - March 2006

Project: Certification and Specialization Application (CSAPP).

Certification and Specialization Application (CSAPP) acts as a tool for the

partners to apply and manage their certifications and specializations with

CISCO, which in turn helps the partners to get benefits like Product

Discounts, Access to Cisco partner E-learning connection etc from CISCO.

Environment: Oracle 9i, SQL, PL/SQL, TOAD, WIN CVS, PVCS, Kintana

Workbench.

Role: Team Member.

Responsibilities:

. Responsible for requirement gathering, analysis and design of various

enhancements.

. Created test plans required for testing with cross functional systems.

. Created stored procedures, triggers, functions, packages in PL/SQL for

various business requirements.

. Worked on fixing, testing Defects raised during QA testing.

. Was involved in providing production support post deployment.

Client: CAP GEMINI ERNST & YOUNG, Mumbai. January 2004 - June 2004

Project: ASIP DS3 (Availability Determination of service points).

The scope of this project was to enable the LCM (Loop Control Manager)

of Bellsouth to provide services to their customers. The LCM sends

a

request to the system asking for the availability of a service point

at a

particular geo location. Based on the availability of various

equipments

required to provide a service point a response indicating whether

service

can be provided or not to a customer located at the entered geo location

is sent back to the LCM. If the service is available at the entered geo

location then the number of days within which the service can be activated

is also provided.

Environment: Oracle 9i, SQL, PL/SQL, TOAD, WIN CVS, Mantis.

Role: Consultant.

Responsibilities:

. Was involved in creating low-level design documents based on discussions

with client.

. Created test plan documents required for unit, integration testing.

. Created stored procedures, triggers, functions, packages in PL/SQL for

various business requirements.

. Was actively involved in Code Reviewing, Testing and Bug Fixing.

Client: G.E., USA. December 2002 - January 2004.

Project: Credit Card Services.

GE Credit Card Services is a leader in providing credit services to

retailers and consumers. Formed in 1932 as a provider of consumer

financing for GE Appliances, Card Services provides private label credit

cards, commercial programs and card-related financial services for hundreds

of retailers and manufacturers across North America. Card Services offers

clients a full range of operational, financial and analytic support, and

develops customized marketing programs designed to increase sales and

customer loyalty.

Environment: Oracle 8i, SQL, PL/SQL, TOAD,

Role: Programmer.

Responsibilities:

. Responsible for requirement gathering, analysis and design of various

enhancements.

. Created test plan documents for unit testing.

. Created stored procedures, triggers, functions, packages in PL/SQL for

various business enhancements.

. Worked closely with QA team to fix defects raised during QA testing.

. Was involved in providing production support post deployment.

Client: Galaxy Surfactants Ltd., Mumbai. March 2002 -

November 2002.

Project: Personnel & Human Resource Management.

The scope of this project was to computerize the Work of Personnel and

Human resource department. The system comprised of various modules like Man

Power Requisition, Recruitment and Training, which enabled the client to

generate various reports as and when required.

Environment: Oracle 8i, SQL, PL/SQL, Developer 2000 (Forms 6i, Reports 6i).

Role: Programmer.

Responsibilities:

. Created various user interfaces, reports as per business requirement

using Oracle

Forms/Reports 6i.

. Created stored procedures, triggers, functions, packages in PL/SQL based

on design documents.

. Involved in providing support during UAT and also making modifications as

suggested by business users.

Client: TATA INSTITUTE OF FUNDAMENTAL RESEARCH (TIFR), Mumbai.

Duration: August 2000 - March 2002.

Project:

. T.I.F.R Stores: The existing stores program was written in COBOL. There

was a need to change the program as it lacked proper user-interface. So

the new package was designed using Oracle as back-end and Developer2000

as front-end. I was involved in designing various user interface

programs. It involves transactions like arrival of stock materials, issue

details, new item and supplier details, which are received by the stores

department and then transferred to various other departments. Depending

upon the type of material transaction the respective stocks are updated

in the database.

. T.I.F.R Budget: T.I.F.R is an autonomous unit, which receives funds from

Department of Atomic Energy (D.A.E). The system then allots these funds

to various departments for carrying out research activities. After

allocation, budget heads from individual departments place requests to

utilize these funds as and when required. Depending on the availability

of funds under their account their request may be approved or rejected by

the system.

. QUALITY CONTROL MANAGEMENT SYSTEM: The Quality Control Program is being

designed for the HIGH ENERGY COSMIC RAYS, department of TIFR. The HECR

department is involved in designing various instruments in collaboration

with different organizations worldwide. So all the information about the

various instruments are stored in a database and all the organizations

connected to HECR across the world can submit their queries to get the

necessary information.

. T.I.F.R Canteen Schedule: T.I.F.R being a very big organization, the

staff requirement for the canteen varied from day to day. On public

holidays & weekends the staff requirement for the Canteen is less as

compared to the weekdays. Depending on the employee's Previous duty

performed, the employee who has done least no. Of duty is given higher

Priority and is called on holiday's and weekend's to perform duty.

Environment: Oracle 8i, SQL, PL/SQL, Developer 2000 (Forms 6i, Reports 6i).

Role: Programmer.

Responsibilities:

. Created various user interfaces, reports as per business requirement

using Oracle

Forms/Reports 6i.

. Created stored procedures, triggers, functions, packages in PL/SQL based

on design documents.

. Involved in providing support during UAT and also making modifications as

suggested by business users.

Contact this candidate