Sales Oracle

Vijay Patel Oracle **g OCA, OCP

** ******* **, *******, ** 07067

Cell: 908-***-****

Summary

. Over 14 + years experience in Information Technology.

. 14 years of experience working as an Oracle DBA/Data Architect.

. 12+ years experience in design, development and implementation of Data

Warehouse (DW) and OLTP applications using Oracle and Informix under

different UNIX and Windows environment.

. Over 7 years experience in design, development and implementation of

Siebel CRM Applications.

. 2+ years of experience working with DB2.

. Experienced in Enterprise Database Design, database administration,

application design and development.

. Experienced in CRM, Data Warehousing and OLTP applications from database

design, development and maintenance prospective.

. Experience in installation & Upgrade of Oracle 10g Software on various

UNIX (HP-UX, AIX) / Linux / Windows Environment.

Certifications

. Oracle 10g OCP Certified

Education

. Bachelor in Mechanical Engineering Kakatiya Institute of Technology and

Sciences, Warangal, India

. Master in Environmental Engineering Stevens Institute of Technology,

Hoboken, NJ

. Master in Management Information Systems Kean University, Union, NJ

Professional Experience

Sanofi-Aventis, Bridgewater NJ

Oct 07 - May 10

Senior Oracle DBA

Responsibilities

< Design, Develop, and maintained the web based Oracle Inventory

Application using Oracle Application Express (HTML DB).

< Install & Upgrade Oracle 10g Software on various UNIX (HP-UX, AIX) /

Linux / Windows Environment. Applying Quarterly CPU patches on various

flavors of UNIX / Linux for Oracle 9i/10g was part of the Job.

< Used OEM Grid Control along with ADDM / AWR / ASH to trouble shoot the

performance issues.

< As a part of DBA team was responsible for 10 Sox Oracle databases.

Responsible from opening the Remedy ticket once the change is approved to

implement the change in the databases and Sending back the output log

file to the Business Application Owner.

< Wrote UNIX shell Script and PL/SQL Procedure for Database access reports

for the Sox Compliant Databases. Set up Cron Job to generate Monthly

database changes report for the Sox Compliant Databases.

< Was responsible in upgrading the Oracle database from 8.1.7 to 10.2.0.3

for Dermik application, which was using Siebel 6.3 to Siebel 7.8 within

the ACES Contact Center application.

< Server life Cycle Project - Responsible for coordinating with the

Business Users Community, Migrations / Retiring / Deleting of the Oracle

Databases instance from Server / OID / Grid Control / Inventory database

/ eCMDB / NetIQ Oracle Monitoring

< Application DBA for Siebel ACES Contact Center Application. It was on

Oracle Data Guard for High Availability, data protection, and disaster

recovery

< Application DBA for GIS application, which was also on Oracle Data Guard

for High Availability, data protection, and disaster recovery.

< Apps DBA for the Following Application

o Fleet Data Warehouse - Used Oracle 10g Data Pump for export /

Import of the Data from Dev to production.

o Clinical Supply Management Systems (Validated Application).

o Measured Application.

o Siebel ACES Contact Center Application. (Validated Application)

o Gentran Integration Suite Application. (Validated & SOX

Compliant Application)

o Remedy Application (Validated Application).

< Internal Server Build of the Various Windows, UNIX and Linux servers.

< Install Hostsos profiler P5 application for Tuning of Oracle database on

the Windows Server. Test various trace files to troubleshoot the SQL

query.

< Change Management of Quantum Database (VLDB).

< Trouble shooted the RMAN backup issues.

< Read and made modification of IQ/OQ Document for various Test Cases.

BroderBros, Co Philadelphia PA

Oct 05 - Sep 07

Senior Oracle DBA

Responsibilities

< Designed, Developed and Implemented the

Returns/PO's/Receipt's/ASN's/Forecast/Inventory within the Inventory Data

Mart.

< Designed, Developed and implemented the Lost Sales (Demand) Matrix,

Rebate Matrix within the Existing Sales and Revenue Data Mart.

< Designed, Developed and Implemented Common Global Skus, Style for all

Products within Alpha, Broder and NES division within the DW for the

various Matrix Analysis using the Sales and Inventory Data Mart.

< Gathered Requirement for various enhancements of various entities within

Sales/Revenue and Inventory Data Mart.

< As Oracle DBA Manage 5 different instances of Oracle database which

Supports Sales and Inventory Data Mart, Business Object repository,

YANTRA WMS.

< Manage and Guide the 2 Business Object Developers and an Oracle DBA on a

daily basis to meet the Business Needs.

< Worked about Six months on Data Integrator version XI and various

versions of Business Objects.

< Excellent data-analysis skills and ability to translate specifications

into a working universe and/or report.

< Configured and installed Business Objects Data Integrator XI (BODI XI)

and Job Server on client and server systems.

< Knowledge of data warehousing techniques, Star / Snowflake schema (Ralph

Kimball methodologies), ETL, OLAP and Report delivery methodologies.

< Provided ETL Design services to support enterprise data integration.

< Experience in debugging and performance tuning of sources, targets and

mappings.

< Creating Jobs, Workflows, Data Flows and Executing jobs with Data

Integrator Designer.

< Loading Data into Target using flat files and from database tables used

as source files.

< Creating Metadata Reports Using Data Integrator.

< Expert in designing, implementing, distributing and maintaining

Universes.

< Specialized in creating complex query reports using Oracle, MS Access and

various RDBMS.

< Programming knowledge in ORACLE 10g/9i/8i/8.x/7.x/6.x and MS Access.

IBM Global Services Basking Ridge, NJ

May 02 - Sept 05

Senior DBA/Data Architect

Responsibilities

< Designed and developed the process to purge the service requests and its

related account, contact, activities, Account Notes and Contact Notes for

Siebel Call Center Application of IBM CRM Group.

< Developed Siebel EIM, UNIX Shell and SQL scripts for this process. Call

Center application was running under Siebel 7.5 on DB2 UDB V8.

< Lead the team of application DBA for the QRU Release in Siebel 7.5.3

Environment. QRU Release comprise of integration of Siebel SFA

Application from Siebel 6 and PRM application from Siebel 7.5.2

environment into a single fully integrated Siebel 7.5.3 environment.

< Created Siebel development, Test, training, staging and production

database based on Siebel Recommendation. Troubleshoot the performance

issues in all the environments.

< Assisted the development team and trouble shoot the data conversion

issues faced by the conversion team. Oracle 9.2.0.2 database for Siebel

7.5.3 Environment was resided on AIX platform using EMC on Raid 5.

< Designed and developed the Templates and created EIM process to load seed

data such as LOV's, Views, Position, Responsibilities, Users (Internal

and External), and Divisions etc. into Siebel Applications.

SQL*Loader/EIM Process was used to load the Data into the Staging/Base

Tables.

< Upgraded the Existing Oracle database from 8.1.7 to Oracle 9.2.0.2 in

order to support Siebel upgrade to 7.5.3 in

Dev/Test/Staging/Training/Production environment.

< Lead the IT team to get all the Avaya Siebel and eCommerce application

comply with the new Avaya IT security Guidelines.

< Troubleshoot day-to-day problems for all the Oracle databases supporting

Siebel, eCommerce application.

< Perform Junior Level Siebel Application Administrator tasks.

< Created Siebel Database environments, Imported the Siebel Repository.

< Migrated the repository from Dev to different environment (dev2prod),

compiled the srf and installed new browser scripts on to the Siebel

Application Servers. Create the Siebel Users and perform Database Extract

for those users on need basis.

< Implemented the Siebel database for Siebel Analytics in Prototype

Environment.

Avaya Lincroft NJ Nov 99 - Apr

02

Senior DBA/Data Architect

Responsibilities

< Gathered the business requirements from the User community for various

reports to be generated from the global data warehouse.

< Designed the Technical Requirements and the data model for the Data

Warehouse using Erwin.

< Designed the Logical and Physical database structure using Star Schema.

Also responsible for physical and logical database design.

< Developed the code for the various reports requirement within Oracle

Database using SQL, PL/SQL, Views, Procedures, Functions, Packages,

Materialized Views and UNIX Shell scripts. ODS consisted information from

Siebel, SAP, Callidus TrueComp, Finance, HR and various internal Avaya

systems.

< Used SQL*Loader for Loading the data within ODS System. Developed SQL,

PL/SQL, SQL*Loader and shell Scripts for ETL.

< Troubleshoot the application as well as database performance issues. Used

TKProf, EXPLAIN PLAN and OEM.

< Managed and Maintained Dev, test, UAT and production Oracle database

environments.

< Supported 18 instances ranging from 100- 500 GB. 5 in prod, 3 in Prod

support, 5 Dev 5 Test running on Solaris 8, HP 9000, and AIX 5L

platforms.

< Used Cognos as a reporting tool within the global warehouse.

Remote Feature Activation (RFA)

< RFA is a new Avaya Web system that deploys Avaya License Files for the

DEFINITY family of products. These License Files is used to activate

software including features, capacities, and release and offer

categories.

< As a DBA of this System responsible for regular upgrade, backup/recovery,

performance tuning and maintenance of Oracle 9i database on Sun Solaris

Platform.

< Maintain and enhance the existing logical and physical database model on

Erwin for various releases of the application.

< Develop and implement various reporting and application functionality

using PL/SQL procedures, functions and triggers based on requirements.

< Maintain the Master data on MS Access and refresh the data in Oracle

database using SQL*Loader/NT Batch Scripts.

< Physical Standby Database was designed for the High Availability using

Oracle Data Guard.

MIDAS (Management Information Data Acquisition System)

MIDAS is one of the largest Marketing Databases in Avaya with detailed

information about 3.5 Million customers and 11 Million Prospects across the

Globe (95% data is US based). Midas Database collects processes and

summarizes data for End Users (Marketing, Sales, Information Service

Bureau, etc) and other interfacing systems (SAP, Siebel, OCTEL, EMT, etc).

Database size is 200 GB and increasing. It's running on Oracle - 8.x

Engine. PRO*C, PL/SQL, SQL*Loader and Developer 6.x is used to write data

processing routines. COGNOS, Midas touch (WEB - Based), SQL*PLUS, Developer

6.x and PL/SQL is used to access Midas Database. COGNOS Tools is used for

the purpose of Multidimensional Analysis and for Ad-hoc reporting of data.

< Working on Midas as an Application Database Administrator. Primarily

responsibility includes Midas Database Management, Physical Database

Design, Performance monitoring and tuning of application and database,

Tuned offensive SQL, support users and maintain database security,

interacting with TI/IBM for System and Database Operational support and

time to time required Database upgrades, applying patches and system

tuning.

< Used Pro*C and SQL*Loader to load feeds from D&B and HHMI into Oracle.

< Wrote SQL, PL/SQL and Shell scripts for automating summary processes. In

addition to above responsible for application development (Pro*C,

SQL*PLUS, PL/SQL), Technical documenting and Coaching/Supporting

Developers and End Users to use Database efficiently.

Siebel Sales, Marketing, eSales, Siebel7

< Upgraded the existing Oracle database from Oracle 8.1.7 to Oracle 9.2 in

order to support Siebel upgrade to 7.5.2 in prototype environment.

Troubleshoot the encountered problems.

< Responsible for the Design, development and maintenance of various

interfaces within globally implemented, Unicode enabled (UTF-8 encoding)

Siebel applications.

< Bi-directional Interface with Siebel and other Internal Application

(MIDAS, Voyager, SAP, and SAP-BW) involves transfer of Account, Address,

Contacts, and Products, Opportunity etc data to and from various Siebel

applications.

< Responsibility includes writing PL/SQL Code, SQL*Loader to Massage and

Load the Data. EIM was used to Import, Export, Purge and Merge the Data

within Siebel Application. .

< Designed Developed and Maintained the Account, Product, Categories and

Pricelist Load for the Avaya Web Ordering Application for Direct and

Indirect Customers. This Application Allows the Fortune 500 Customer and

the Distributor to order the Avaya Product through the Web. Designed and

developed the Customer Specific Catalog and Price List.

< Automated the Process to run it through the Schedule jobs. Modified the

Data load process for existing Siebel 6.3, 7.0.3 environment to Siebel

7.5.2 environment for the Current Web Ordering Application.

< As an Application DBA I am responsible for setting the entire various

database environments (Dev, Test, Training, Staging and Production) for

various Siebel Applications.

< Make sure the backup/recovery strategy designed using RMAN adhere to the

standards established by Avaya guidelines & methodologies.

< Configure the Siebel Application using Siebel tools for EIM process.

Space management, performance tuning, trouble shooting day to day issues

with the users, tester and developers is part of daily job

Lucent Technologies, Holmdel, NJ Mar 98

- Oct 99

Oracle DBA (BCS Data Warehouse Group)

LFDW Reporting Iteration

Responsibilities

< Responsible for physical database design and development for acquisition,

storage, display of Lucent SAP portion of the Lucent Financial Data

Warehouse (LFDW). This system allows the BCS Finance users to access the

finance data via Business Objects.

< Database was created on Oracle 8.0.5 on Sun Solaris platform.

Opportunity Management System Iteration.

< Responsible for physical database design and development for acquisition,

storage and display of Lead and Opportunity generated by the sales

center. This system also stores information about account executive,

products and campaign generated by the sales center.

< The OMS/Data Warehouse interface was intended to facilitate the creation

of OMS reports of both a predefined and adhoc nature.

< Reports were generated via Business Object and Database used was Oracle

7.2.2 on Sun Solaris platform.

Manugistics Demand Forecasting Iteration

< Responsible for Physical database design and development for acquisition,

storage, calculation and display of demand and demand forecast

information.

< The source of the data was Manugistics Demand Forecasting and Inventory

Management tool.

< Canned reports were made available to users via the BCS Performance

Metrics Web Site on the BCS Intraworks Web Server.

< Ad-hoc reporting was also made available via the Business Objects Report

Generator.

< Database used was INFORMIX XPS NCR 8.11.UF1

Beechwood Data Systems, Clark, NJ

Nov 97 - Feb 98

Oracle DBA

Responsibilities

< Responsible for Physical database design, sizing, tuning, backup &

recovery of the database for the intercom software.

< Responsibility also includes the maintenance of the development and test

database on 3 different servers and troubleshooting the developer's day-

to-day problems.

AT&T/Lucent Technologies, Parsippany, NJ

Oct 95 - Oct 97

Oracle DBA

Responsibilities

< Installed, configured Oracle 7.3.2 on Sun, NCR 5500 UNIX Servers.

< Provided production support to mission critical databases. Supported Test

and Dev instances.

< Upgraded Production, System test and development database from Oracle

7.1.6 to 7.3.2.

< Helped developers in setting up system environments for the new Oracle

version.

< Monitor four different databases. Created the backup and recovery

strategy.

< Developed the shell script for hot and cold backup.

< Set up the new version of SQL*Net 2.3 on the server.

< Defragmented the databases.

< Tune the database, Application to improve performance. Achieved better

performance through tuning SQL, Application re-engineering, doing

selective de-normalization, OS and memory tuning, Table partitioning etc

< Integrated the Sales Database (SDB) with the existing DW.

< Modified existing structure and design, developed the new tables to

satisfy new requirements.

< Re-evaluated data-feed timing related conflicts. Re-evaluated the backup

and recovery strategy as well as security procedure for the new sets of

users. COGNOS Power Play and Impromptu was used for the multidimensional

analysis and Reporting purpose.

< Integrated the SAP Iteration with the existing DW.

< Translated warehouse data model into DBMS specific schema.

< Tuned the DBMS and optimized for decision support analyzing and queering

performance.

< Coordinated with developers for DW capacity planning and backup/recovery

strategy planning.

< Re-evaluated the security procedure and guidelines proposed for end users

access to the DW.

< Designed tables and coded PL/SQL procedure for different data aggregation

and summarization scenarios. Wrote the shell script to automate the

daily SQL*Loader load process.

< Modified the existing database in production for the second iteration of

Data Warehouse.

< This iteration of the Warehouse was initiated to analyze the

manufacturing, operating, non-operating, burden cost per products

involved by the owned and non owned facility of CP. Power Play the multi

- dimensional tool from COGNOS was used for the decision support

analysis.

< Primary responsibilities include development, administration, maintenance

and performance tuning of Oracle 7.1.6 Database on Sun Solaris, NCR 5500

UNIX Server as well as helping users in generating adhoc reports using

impromptu.

Oracle Junior DBA / Oracle & Cognos Developer

< Developed Implemented and maintained the Profitability Analysis Model for

Product Managers and Finance department. This particular Data Warehouse

was developed on Oracle 7.1 databases mounted on an NCR 5500 UNIX server.

Power Play the multi - dimensional tool from COGNOS was used for the

decision support analysis. Adhoc Reports were developed using the tool

Impromptu.

< The model provides the ability to analyze the product at a SKU, Customer,

Return Reason Code and Post Invoice Adjustment (PIA) level of detail on a

daily basis.

< Primary responsibility includes Oracle development, design and

development of the reports depending upon user's request.

< Oracle development includes writing stored procedure and functions.

< Control script was coded to load the data into the Oracle database using

SQL*Loader.

Oracle / Microsoft Access Developer

< Developed, Implemented and Maintained the Phone Center Inventory

Management and Sales Project on an NCR 5500 UNIX server in a client -

server environment. System was developed using Oracle 7.1 for AT&T phone

center management.

< Reports were generated using Microsoft Access.

< The project provides the information that helps phone center management

to monitor and identify opportunities to improve inventory productivity

to achieve year-end sales and inventory goals.

< The sales part of the project provided customer level information on AT&T

phone center stores on the daily basis. SQL*Loader was used to load the

data into the database.

Contact this candidate