Over 12 years of experience in analysis, design, development, maintenance , project implementation, user interviews, test plan preparation, QA/QC and testing . More than 8 years of experience as Oracle DBA. with wide range of experience in Data warehouse database, application performance tuning and oracle instance tuning, Reorganizing database, configuring of Multi Threaded server, Preparation of low mean time recovery, Space management statistics, Server installations (8x, 7.x), upgrades, Capacity planning, performance tuning, backup & recovery, Security Administration. More than 3 years of experience as a SAP Basis Administrator with installation, upgrade, transports, daily monitoring, applying OSS notes etc.

· Quality and result-oriented consultant who combines technical expertise with ability to deliver quality, competitive products and solutions.

· Self-starter and leader who excels in troubleshooting, defining strategies and improving productivity and profitability.

· Excellent analytical and problem solving skills.

EDUCATION : Master in Computer Application(MCA), 1988, India

Master in Business Administration (MBA), 1993, India.

Bachelor In Physics with Honours and Distinction, 1985, India

CERTIFICATION : ORACLE CERTIFIED PROFESSIONAL (ORACLE 8)

PROFESSIONAL SKILLS :

Hardware : HP 9000 series(v2200,k570), ORG UNIX Server, NEC 1000, HP Workstation, Sun

Workstation, Pentium and Intel Family

OS : HP-UNIX(9.x,10.x,11.x),UNIX System V release 4.2, XENIX, UNIXWARE, ACOS, DOS 6.2

Language : ABAP/4, COBOL, PRO*C, C

RDBMS : ORACLE-8.05.2.1, 7.x

ERP : SAP/R3 4.5 B, 3.0 D

SAP Trainings : BC 360 – Technical Core Competence – UNIX/Oracle

BC 305 – Advanced R/3 System Management

BC 325 – Software Logistics

BC 315 – R/3 Workload Analysis

Tools :

· Legato Networker

· EMC

· MAESTRO(Job Scheduler)

· BMC Patrol

· Connect:Direct

· Designer 2000

· SQL*Forms 4.5 SQL*Forms 3.0/2.3, PL/SQL 2.0/1.0,SQL*Report 2.5,SQL*Report Writer 1.1, SQL*Report 1.1

· SUBLIME (Testing Tool)

· SQLLAB

· TSREORG (PLATINUM)

· DBVISION

PROFESSIONAL EXPERIENCE :

1. Jan 98 - Continuing

DATABASE ADMINISTRATION

Aera Energy, CA, USA

Currently working as a Senior DBA in the SAP environment. My responsibility is to take care of the backups, monitoring the health of the databases, fixing user problems and any other adhoc works like export, import, data loading, creating new databases etc. Also as a Senior DBA, I guide other DBAs for taking a decision or fixing any problem where they need help.

HP-9000 (V2200) Server, HP UNIX(11.0),ORACLE 8.0.5.2.1, SAP/R3(4.5 B), ABAP/4

2. December 96 – Jauary 98

DATABASE ADMINISTRATION

Cal Resources, CA, USA

As a DBA my responsibility is to keep the database running round the clock, taking backup, maintaining users, tuning the database, writing stored procedures and triggers, auditing, data loading, responding to the database problems faced by the users etc. In addition to the above activities , I have done the database sizing(table sizing, index sizing), database setup for three databases running under one server.

HP-9000 Server, HP UNIX, ORACLE 7.3, SQLLAB, TSREORG, DBVISION, DESIGNER 2000

3. January 96- December 96

ADVANCED SERVICES OPERATIONS SYSTEM (ASOS)

DATABASE ADMINISTRATION

Pacific Bell, San Ramon, CA, USA

ASOS is a part of consumer broadband services for managing and supporting advance telephony/multimedia communications networks and services in addition to telephony developed by AT&T. I was involved in the Data Base Administration, writing scripts, preparing data for testing, loading test data into the database, writing SQL scripts to help the testers, etc.

HP-Pentium Server, UNIX, ORACLE 7.1, SQL*Forms 4.5, SQL*Report 2.5

4. January 95 - December 95

ON-LINE FLOOD INFORMATION SERVICE, Irrigation Department, India

The ON-LINE FLOOD INFORMATION SERVICE(OFIS) is designed to create an environment for data sharing among interested departments. The main objective of the system is to bring all the departments those who are involved in flood management to a common platform. The system will provide on-line information to various users during monsoon and flood time. I was looking after the Database Administration.

Pentium, UNIXWARE, ORACLE 7, SQL*Forms 4.5, PL/SQL 2.0, SQL*Report Writer 1.1

5. February 94 - December 94

MAHANADI MANAGEMENT SYSTEM, Flood Control Cell, India

The system is used in all three types of Flood management(Pre Flood, During Flood &Post Flood stage). The result of any query can be displayed through spatial as well as non spatial data. The objective of the system was create databases useful for the Mahanadi river management, to forecast stage and discharge on point to point basis, to forecast inundated villages, weak point analysis, water distribution pattern of the basin etc. I was involved in the Design part and was looking after the database.

Pentium,UNIXWARE,ORACLE 7, SQL*Forms 3.0, PL/SQL 2.0, SQL*Report Writer 1.1

6. October 93 - December 93

FOREIGN EXCHANGE RATE INFORMATION SYSTEM, State Bank of India

This project was developed to take care of the calculation of Foreign Rate for International Banking Division, SBI,Bhubaneswar. Everyday the system provides the rate for the 19 currencies which are supplied to the branches dealing with Foreign Exchange.. The system generates reports for Card Rate, Traveler’s Check etc.

Pentium,UNIX, ORACLE 6, SQL*Forms 3.0, to PL/SQL 1.0, SQL*Report Writer 1.1

7. March 93 - August 93

DISASTER MANAGEMENT SIMULATION, Emergency Department, India

Pentium,UNIX, ORACLE 6, SQL*Forms 3.0, PL/SQL 1.0, SQL*Report Writer 1.1

8. March 92 - February 93

FLOOD FORECASTING SYSTEM, Central Water Commission, India

UNIX, ORACLE 6, SQL*Forms 3.0, PL/SQL 1.0, SQL*Report Writer 1.1

9. August 91- February 92

RAINFALL INFORMATION SYSTEM, Special Relief Commissioner, India

UNIX, ORACLE 6, SQL*Forms 3.0, PL/SQL 1.0, SQL*Report Writer 1.1

10. December 90- March 91

APPLICATION TRACKING SYSTEM, Indian Metals and Ferro Alloys limited, India

Application Tracking Systems was developed to help the HRD department in the manpower recruitment process.

UNIX, ORACLE 7, SQL*Forms 3.0, PL/SQL 2.0, SQL*Report Writer 1.1

11. January 90 - August 90

MAINTENANCE MANAGEMENT SYSTEM, Indian Metals and Ferro Alloys Limited, India