SUMMARY

• Total Fifteen years of IT experience with over Three years of experience focused in multiple Oracle Applications Implementation and post - implementation projects.
• DBA team lead responsible for managing and supervising a team of 5 DBAs
• Extensive experience as DBA in Oracle 7.3/8.1/9.1/10.2.0.2/10.2.0.4/11.1.0.7/11.2.0.2/11.2.0.3/ Oracle Applications 10.7/11.5.3/11.5.5/11.5.9/11.5.10 (Apps 11i)/R 12.1.3/12.2
• Experience in Installing/patching/cloning/upgrading/administering Oracle Applications environments (11.5.3, 11.5.7,11.5.5,11.5.9,11.5.10)
• Extensive experience with all aspects of Oracle applications 11i and Oracle Database 8i/9i/10g/11g product versions in large scale UNIX environment.
• Upgrade the Oracle Database from 9.2.0.8 to 11.1.0.7,11.2.0.2 and 11.2.0.3 Also performed Database and Applications platform migration.
• Upgrade the EBS 11.5.10.2 to R12.1.3 also Tech Stack including JRE/JDK upgrade.
• Supporting R12.2 upgrade assessment and dry runs
• Install/Upgrade 10gR2 OID/SSO (10.1.4.3)/Portal (10.1.4.2)/SSL
• Implemented GRC (AACG 7000, TCG, CCG 5.5.1, PCG) with E-business-Suite.
• Implemented WebCenter
• Portal/Login Server 3.0.9 and Integrate with EBS R12.1.3. SSL enabled.
• Reduced the R12.1.3 Main upgrade driver run time.
• Responsible for Database Refresh and DB/Apps Cloning, Patching (RUP’s, Family/MiniPacks, and One off Patches - Bug fixes) and applied CPU cycles throughout the project.
• Oracle Certified DBA(9i)
• Extensive experience in utilizing Oracle Utility tools like Toad, SQL*Loader, Import/Export, Data pumping, Data Guard and RAC.
• Past experience in large-scale, custom-developed, e-commerce environment with high availability.
• Extensively worked on 24/7 environment. Strong knowledge of all financial modules including GL, AR, AP, PO, FA, iProcurement and iExpenses.
• Worked on ETL tools, Informatica 5.1 and OBIEE 10.1.3.4.1 for OLTP systems, Upgrade OBIEE 10g to 11g.
• Proven track record of delivering multiple enterprise-wide financial application in oracle 11i environment.
• Good interpersonal, communication and client-facing skills and a very good team player

TECHNICAL SKILLS

ERP (Oracle Apps 11i): Oracle Financials 10.7/11.5.3/11.5.5/11.5.9/11.5.10 (GL/AR/AP/OM/PO/CE/FA) /Oracle Federal Financials 11.5.9/11.5.10/ 12.1.3/12.2

Languages: PL/SQL, SQL*Plus, Toad and SQL*Loader

RDBMS: ORACLE 7x, 8x, 9i, 10g (RAC),11g (RAC)

ETL Tool: Informatica 5.1, OBIEE 10.1.3.4.1 , 11.1.0.7

Front Ends: Oracle Forms 4.5, 6i, 10giAS, Autosys

Report Tools: Oracle Reports 2.5, 6i, Discoverer 3i, Content Manager On Demand 8.4.1, GRC CCG 5.5.1

OS: WINDOWS - NT 4.0/95/98/2000 , Linux, UNIX

Apps Monitoring Tool: Applimation Integra, GRC

PROFESSIONAL EXPERIENCE

Confidential, MD

Oracle Apps DBA

Environment: Oracle Applications (Federal Financials) 11.5.9(GL/AR/AP/CE), Applimation Integra, Oracle Workflow, Oracle 9.1.2. Sql* loader, FND loader, Toad, Rational ClearCase, Rational ClearQuest, SeeBeyond 4.5.1, PL/SQL, Forms 6i, Reports 6i and HP-UNIX.

Responsibilities:

• Upgrading from 11.5.9 to 11.5.10 in RAC & non RAC instances.
• Upgrading EBS 11. .1.3
• Upgrading Oracle databases to newer versions (e.g. 8i to 9i to 10g to 11g) and Character set conversion US7ASCII to WE8ISO8859P1 in RAC & non RAC instances.
• Upgrading the form version to 6.0.8.24.1 +16
• Production monitoring/issue resolution.
• Configured OEM 2.2 to monitor all Prod, Devl and Test instances, different environments varying from 8.0.6 to 9iAS and to the latest 10giAS on IBM AIX5L Based Systems.
• Cloning APPS environments frequently from PROD for development, UAT Test, Stress Test and Patch environments.
• Handling all SYSADMIN activities to support issues like changing user and system profiles, registering new concurrent requests, Adding new printers, customizing responsibilities, menus with need-based approach.
• Worked as a team member in upgrading previous 11.5.8 version Production system to 11.5.9.
• Database and Application Patching
• Installing and managing Content Manager on Demand and 10giAS for letters functionality.
• Installing and managing OBIEE 10.1.3.4.1 , OBIEE APPS 7.9.6.1, DAC 10.1.3.4.1

Confidential, Bloomington, IN

Oracle Application Developer

Environment: Oracle Applications 11.5.9(GL/AR/OM/INV), Oracle Workflow, Oracle 8i. Sql* loader, PL/SQL, Forms 6i, Reports 6i and HP-UNIX.

Responsibilities:

• Installation, Upgrade, Configuration, Backup and Recovery, Database tuning, Query optimization.
• Oracle Applications Server (OAS 3.x/9iAS) / WebDB administration.
• Application of patches.
• Configuring and trouble shooting Concurrent Managers.
• Worked as a core Oracle 11i applications DBA at a large migration project for a worldwide integration.
• Performed all duties related to installation, upgrade, configuration of database and development tools, database design, modeling, client/server connectivity, space management, capacity planning, patching, cloning, extensive performance tuning, backups.
• Designing building and running import/export scripts, loading data with sqlldr scripts, run/debug migration code, modification and support of migration PL/SQL scripts, etc.
• Oracle TAR submission and resolution.
• Scheduling concurrent processes to perform routine housekeeping activities and also for improving Application performance (Gather Statistics etc.,)

Confidential - Milpitas, CA

Techno - Functional Consultant

Environment: Oracle Applications 11.5.5(GL, AR, AP), PL/SQL, Oracle 8.1.7, Forms6i & Reports 6i, Discoverer 3i, SQL*Loader, TOAD

Responsibilities:

• Installing & Maintaining Oracle Applications Release 11.0.3 on Digital Unix and Windows NT.
• Planning and Preparing Unix Environment, Unix file system layout and Oracle database directory structure for installation of Oracle Applications Release 11.0.3 on Digital Unix version 4.0F.
• Applying necessary patches for bug fixes using utilities like adpatch, adadmin, adctlr, adrelink etc
• Handling daily system administration routines like creating/altering responsibilities, creating App.
• Users, setup custom menus based on users’ responsibilities, customizing reports, registering new Custom concurrent programs, setting profile option values at different levels for different users
• Planning and defining Key and Descriptive Flexfields and validation strategy for the value sets.
• Creating shell scripts for Nightly backups, startup/shutdown of database and web Listeners, startup/shutdown Concurrent managers for different instances.
• Creating SQL scripts for Database creation, Rollback, Temporary and other application tablespaces and scripts for space utilization and performance tuning of the database.
• Maintaining and monitoring 3 instances (Production, Test and Vision Demo environments)
• Providing Technical assistance to developers to create interfaces for AP, AR and PO modules to load data from legacy system to Oracle Applications system.
• Writing a shell script for automating the procedure to upload a Vendor’s data into Oracle Applications Account Payables using SQL*LOADER and PL/SQL cursors.
• Developing and testing database backup/recovery procedures for Production / Test instances.
• Creating user accounts, daily files system backup, monitored I/O activities, Printer setup on Unix.

Confidential

Team Member

Environment: Oracle Financials 10.7 (GL/AR/AP/CE/FA/AOL and Sys Admin), Oracle 8.1.7, PL/SQL, Informatica 5.1, Oracle Forms 4.5 and Oracle Reports 2.5

Responsibilities:

• Installation and maintenance of Oracle applications 10.7
• Prepared technical specifications for the given functional specifications, Completed database design for custom ERP tables.
• Responsible in preparing Design Specification, Coding and Unit Testing of GL Conversion from Oracle database 8.1.7 to 10.7.
• The Objective of this Conversion is to convert existing data from Oracle database to 10.7 which includes 1997 year end balances and 98-9 detail transactions.
• Customization of standard Asset Inventory report in FA to allow for ordering of reports at the business unit level
• Customization of standard Property Tax report in Fixed Assets to allow for ordering of reports at the business unit level.
• Schedule the interface of data from AR and AP to GL on a daily basis
• Developed Informatica mappings to Extract, Transform and Load the customer data.
• Define concurrent program to be added to concurrent request groups for generation of reports.
• Created Application users, Oracle users, Responsibilities and assigned the same to respective users.

Confidential

Oracle DBA

Environment: Oracle Database, Oracle 7.3/8.1/9.1, PL/SQL, TOAD, Windows NT

Responsibilities:

• Responsible for installation of Oracle database 8.1.7/9.1 on XEON and NT machines
• Executed the scripts for creating the database objects like indexes, views, triggers and Assisted the developers in Database related issues.
• Migration of Oracle database from Database 7.3 to Database 8.1.7.4 and then from 8.1.7 to Database 9.1.
• Responsible for Backup of application during the Migration and Prepared strategy for backup and recovery.
• Creating users and maintaining there profiles / Grants according to the company’s norms.
• Monitoring overall database like Tablespace utilization & fragmentation, creating and altering storage parameters of indexes and table for better performance etc. and taking appropriate measures.
• Monitoring Backup / Recovery processes.
• Hot Backup and cold backup for the production database.
• Trouble shooting in case of Database failure. Fine tuning of the application.

Confidential

Management Trainee

Environment: Oracle 7.3, PL/SQL, SQL*Plus, Windows NT 4, Forms 4.5 and Reports 2.5

Responsibilities:

• Oracle In-House ERP (Production Control, Quality Control, Packing, Dispatch)
• An integrated package was developed in-house to cater to the needs of the entire manufacturing operations.
• Application was developed on client-server architecture with Developer 2000 as front end and Oracle 7.0 as back end.
• This project enables precise material identification and tracking at 9 stages of processing involving finished product identification unto a weight of 20 kilograms in a work-in-process of 2 million kilograms.
• Design and development of forms for Inspection data entry; Customer Returns data entry; Salvaged material data entry; Raw Material composition data entry; Packing data entry module; Packing material consumption data entry.
• Data Modeling: identifying entities, normalization/de-normalization, making ERDs and DFDs.
• Database stored procedures: writing PL/SQL server side stored procedures and triggers.