Oracle Manager

US CITIZEN

SUMMARY

. Over * years of experience in providing technical leadership and

direction for the design, installation, customization, implementation,

and ongoing support of Oracle 10g/11g databases on Solaris and Windows

environments.

. Extensive experience in Database Administration, Backup, Recovery,

Capacity Planning, SQL Tuning, good experience in Backup and database

recovery using RMAN.

. Installed 11g on Solaris. Migrated database 10g to 11g using

EXPORT/IMPORT utilities.

. Upgraded a single node Oracle Applications E-Business Suite from 11.5

7 on Windows Platform to 11.5.9 on Windows Platform.

. Migrated Oracle Applications from Windows Platform (11.5.9) to Multi-

node Oracle Applications 11.5.10.2 on Solaris Platform.

. Upgraded Enterprise E-Business Suite production database from 8i to

9.2.0.6.

. Cloned Oracle Applications from Production Environment to Development

Environment using Rapid Clone.

. Upgraded Apps-tier (Developer 6i and iAS-Client Binaries) and applied

oracle critical patches for Oracle E-Business Suite

(11.5.9/11.5.10.2).

. Installed and configured Oracle Collaboration Suite in Production and

development environments.

. Wrote Shell scripts to administer database activity and to automate

several important production jobs.

. Establish backup and recovery procedures on Windows and Solaris

platforms. Analyzed and enhanced the database environment on Sun

Solaris servers and windows servers that supports hundreds of end-

users.

. Installed Oracle Enterprise Manager Grid control and configured agents

on solaris system.

. Monitored all the databases through Enterprise Manager Grid Control.

. Proficient in PL/SQL Development creating Packages, Stored Procedures,

Functions & Triggers using SQL*PLUS and Toad as development tools.

. Customized existing oracle financial application Reports. Developed

new Oracle Forms and Reports. Experience in Oracle Portal development

using Oracle web tool kit. Developed various HTML applications using

PL/SQL interacting with Data Ware House Database.

. Have work experience in Oracle Utilities such as SQL*Loader,

EXPORT/IMPORT, UTL_FILE, TOAD.

. Extensive experience in data production support, data mart, data

warehouse, database user management and storage management for schema

objects.

. Designed the data warehouse using Oracle Designer.

. Developed PL/SQL packages to populate Data Warehouse Database on

nightly basis from Oracle Applications Database.

. Developed Web Services, SQL Loader scripts and PL/SQL packages to

populate the Data Warehouse Database on nightly basis from third party

NETSUITE system.

. Developed interfacing programs as web applications on Oracle AS10g

server for accessing data ware house on Windows Platform and Oracle

Applications Database on Solaris Platforms.

. Have good understanding of Logical and Physical Data modeling and Data-

warehousing concepts.

Technical Skills

Operating Windows XP/2000/NT, Sun Solaris UNIX

System

Languages & SQL, PL/SQL, SQL*FORMS, SQL*REPORTS, SQL*PLUS,

Tools SQL*LOAD, PL/SQL web tool kit, Designer/2000,

Discoverer, ADI, Oracle Enterprise Manager Grid

Control, HTML, JavaScript, Java, JSP,

RDBMS Oracle 11g, 10G, 9i, 8i, 7.x

Application Oracle Application Server.

Servers

Miscellaneous SOAP, Eclipse, Netsuite Webservices

Professional Experience:

Roboz Surgical Instruments 07/2000 - To-

date

Roboz is a specialized surgical instruments company that provides

researchers with customized, hand-crafted surgical instruments designed to

meet their unique demands. Roboz has multiple enterprise applications

cutting across different business areas from Order Entry, Financials &

Accounting to Reporting via the data warehouse. Roboz also has another

business unit called Cell-Point and both units have their own databases.

Production Support Data warehouse and Net Suite for Roboz

03/2010 - To-date

. Implemented NetSuite financials package for entering sales orders,

inventory, Accounts Receivable, Accounts Payable and General Ledger.

The data is stored in NetSuite database servers. Web Services were

developed in java to get the daily transaction data in flat files.

. Developed web services using Java to retrieve the date from the

NetSuite database and created CSV (comma delimited) files.

. Developed SQL*LOADER scripts to load the data from the CSV files into

Oracle temporary tables.

. Developed PL/SQL routines to reformat the data from the temporary

tables into permanent Data warehouse tables.

. Developed Unix shell scripts to automate loading and reformatting

process and created a CRON job to run nightly.

Production Support Data warehouse and Net Suite for Cellpoint

12/2008 - 02/2010

. Implemented NetSuite financials package for entering sales orders,

inventory, Accounts Receivable, Accounts Payable and General Ledger.

The data is stored in NetSuite database servers. Web Services were

developed in java to get the daily transaction data in flat files.

. Developed web services using Java to retrieve the date from the

NetSuite database and created CSV (comma delimited) files.

. Developed SQL*LOADER scripts to load the data from the CSV files into

Oracle temporary tables.

. Developed PL/SQL routines to reformat the data from the temporary

tables into permanent Data warehouse tables.

. Developed Unix shell scripts to automate loading and reformatting

process and created a CRON job to run nightly.

Support and Platform Migration of Oracle Applications

12/2006 - 06/2009

. Extensively used Oracle financials Order Management, Accounts

Receivables, Payables, Inventory and General Ledger Modules.

. Migrated data from remote databases to the local server by

establishing database link between the servers. Wrote necessary stored

procedures and packages to populate remote data into local databases.

Constantly monitored and managed space, database security, export and

import of database, loading of data from non-Oracle data sources using

SQL*Loader. Developed data warehouse applications using PL/SQL

procedures.

. Migrated Oracle Applications 11.5.9 from Windows Platform to Sun

Solaris (5.10) Platform. On Windows Oracle Applications used to be

Single-node Application. On UNIX Platform I have converted it to muti-

node application with Web-tier on a separate Server and Concurrent/

Admin tier sharing the Database Server. In the process I have

successfully migrated Oracle Applications from Version 11.5.9 on

Windows to 11.5.10.2 on Unix Platform. I have also configured RMAN

for regular hot backups and restores in Development environment. I

have also cloned several times Production environment to Development

environment using Rapid Clone.

. Installed Oracle Enterprise Manager Grid Control on Windows server and

constantly monitored and managed space, database security, export and

import of database, loading of data from non-Oracle data sources using

SQL*Loader.

. Scheduled Exporting of Databases and hot backups through Enterprise

Manager Grid Control.

. Upgraded Oracle Applications 11.5.7 on Windows to Oracle Applications

11.5.9. Migrated Data ware house Database from Windows Platform to

Unix Server and also maintained the Windows Platform version. Migrated

E-mail Server in Lotus Notes to Unix Platform and Installed

Collaboration Suite on UNIX (Solaris). Created users in collaboration

suite and set up their email accounts. Creation of Database, Table

Spaces, Tables, Views, Indexes, Stored Procedures, users and roles.

. Developed several custom programs using PL/SQL with Oracle

Applications Database.

. Developed Web Applications using Oracle Application Server. Customized

existing oracle financial application Reports, developed new Oracle

Reports, Graphics using Developer/2000. These reports are deployed in

Reports Server Cartridge, Graphics Server Cartridge to the Application

Server and displayed on the web browser.

. Maintained and Supported Oracle Data Ware house Database on Unix

Server. Developed several HTML reporting programs using PL/SQL

interacting with Data Ware House Database.

. Maintained Collaboration Suite with E-mail server on Unix Platform.

Trouble shooting issues on timely basis.

. Developed Catalog Requests dynamic web page using oracle HTP package.

Customers enter data for requesting catalog requests. Added feature

for printing labels on thermal printer. Catalog requests will be sent

out for the customers.

. Developed Price List request and Promotional Code Request dynamic web

pages using oracle HTP package. Customers request for price list or

any promotional coupon codes by entering their email addresses. Price

List or Coupon codes are sent out to the customers by automatic email.

Used Oracle SMTP packages to send the emails with attachment.

Upgrades Oracle Apps and Platform Migration of Data warehouse 01/2003

- 12/2006

. Designed Data Warehouse application with star schema design using

Designer 2000.

. Upgraded Oracle Applications 11.0.3 on Windows to Oracle Applications

11.5.7. Cloned databases from production system to the test

systems after production systems were upgraded.

. Established standard operating procedures for Database Backup,

Recovery and database tuning.

. Maintained Lotus Notes, Oracle Data ware house databases in Production

environment.

. Created required fact and dimensional tables and developed PL/SQL

procedures and packages to populate the Data warehouse.

. Created Materialized views in Data Warehouse instance to extract the

data from the Oracle financial systems through Database link.

. Developed PL/SQL programs to generate custom ad-hoc reports for Order

Management module.

. Converted Oracle web applications from oracle http packages to JSP

pages by using Dream weaver and deployed in the application server.

. Integrated Shipment packing slips generated from oracle financial

Applications with United Parcel Service Software by using ODBC

Connection

Impelmentation and Support of Oracle Apps on Windows 07/2000

- 01/2003

. Installed Oracle database version 7 on windows platform.

. Designed tables, indexes and created in the database.

. Developed batch files to get the data from the FACTS system daily and

load into the oracle tables for reporting purposes.

. Developed SQL*PLUS reports and Adhoc queries for management.

. Installed Oracle Applications 11.0.3 on Windows Platform. Customized

Application Modules Accounts Receivables, Order

Management, Purchasing, General Ledger modules. Developed batch file

scripts for regular maintenance.

. Designed Data Ware house and written several interfacing custom

scripts for transferring data between Data Ware house and Oracle

Applications Database. Migrated data from remote databases to the

local server by establishing database link between the servers. Wrote

necessary stored procedures and packages to populate remote data into

local databases

EDUCATION:

B.S., Major: Accounts

JOB-RELATED TRAINING COURSES:

Oracle 8i, SQL, PL/SQL, Developer/2000, Visual Basic, and Microsoft

Access97 programming courses from Montgomery College.

Attended Oracle PL/SQL course and Enterprise DBA backup and recovery

course conducted by Oracle University.

References: Available upon request

Contact this candidate