SUMMARY

• Having total 11 years’ experience on Oracle Database
• Having 3+ year experience as Oracle DBA on Windows Platform
• Having 7+ year experience on Oracle Applications DBA
• Good experience in Oracle 8.x/9i/10g on Linux & Windows NT environments
• Expertise in Backup and Recovery process with Non-RMAN and RMAN
• Experience in installing the Oracle Applications on single and multi nodes
• Experience in cloning using cold and hot backups
• Experience in Upgrade of Database to 10G/11G
• Experience in Upgrade of Oracle E-Business Suite to 11.5.0.2/R12
• Extensive experience in AD utilities
• Support for Production databases
• Excellent communication skills and interpersonal skills
• Having on-site experience on Oracle/Oracle EBS upgrade projects

Education

M.COM
Post Graduate Diploma in Management Information System through computer applications (PGD-MISCA)

Professional Qualifications

Oracle certified professional OCP (DBA)

Technical Environment

Operating System : Win 95/2000/NT/Adv 2000 Server, Sun Solaris, Linux
RDBMS : ORACLE 8i/9i/10G/11G
Languages : PL/SQL
Designing Tool : Erwin
Database Tool : TOAD/OEM
ERP : Oracle E-Business Suite 11.0.3/11.5.3/11.5.9/11.5.10.2/R12
10gAS for BI/Oracle Demantra/ASCP
Work experience
Working as Senior Oracle Apps DBA Consultant for Confidential,2010 to Till Date
Worked as Senior Consultant (Oracle Apps DBA) For Confidential, (USA) 2009 to 2010
Worked as Project Lead for Confidential, (India) from 2004 to 2009

Project Details

Dec 2011 to Till Date Confidential,
Project 11.5.10.2 Upgrade
Position Senior Apps DBA
Environment Oracle E-Business Suite (11.5.9/11.5.10.2 9i/11g) Solaris 10
Project Description Primary DBA for upgrade of 11.5.9 Instance to 11.5.10.2
Roles and Responsibilities

Ï Analyzed current 11.5.9 Instance for upgrade
Ï Patch Analysis for technical Upgrade
Ï Analyzed custom objects in 11.5.9
Ï prepared the estimation of Test Upgrade
Ï Involved with Functional/technical team to estimate the upgrade impact
Ï Applied Tech Stack Patches in upgrade
Ï Upgraded forms/JDK/Deployed Sun JRE 6.0

Ï Converted Non-OATM tablespace module to OATM
Ï Upgraded the 11.5.9 Instance to 11.5.10.2
Ï Upgraded Database from 9i (9.2.0.8) to 11gR2 (11.2.0.3)
Ï Applied Extended Support Patches
Ï Prepared the Instance for CRP1 Upgrade Test
Ï Actively involved in CRP1 to resolved upgrade issues

________________________________________________________________________________

Apr 2011 to Nov 2011 Confidential,
Project R12 Upgrade and Support
Position Senior Oracle Apps DBA
Environment Oracle E-Business Suite (11.5.10.2/R12 (12.1.3)) with 10g/11g
OEL 5.4/5.2
Project Description
Involved in on-going R12 Upgrade Project at Amazon, Upgraded Database from 10g (10.2.0.4) to 11gR2 (11.2.0) on TEST/DEV/UAT environments for Upgrade/Cloning the Production EBS for Upgrade cycles.
Roles and Responsibilities

Ï Support Activities on Test/UAT/DEV environments
Ï Patch Application
Ï SSL Setup on 11i/R12 Instances DEV/UAT/TEST Refreshing Process
Ï Database Upgrade from 10.2.0.4 to 11gR2 (11.2.0)
Ï cloning a database from production Standby database
Ï Clone of EBS 11i/R12 Instances Multi-Node to Multi Node
Ï Documentation of Process
Ï Involved in Production Upgrade from 11.5.10.2 to R12 (12.1.3)
Ï Trouble shooting in clone/patch/upgrade process
Ï supporting Day-to-Day Production Support Activities
­­­­­­­­­­­­­­­­­­­­­­­­­­­________________________________________________________________________________
Aug 2010 to May 2011 Confidential, Houston TX (USA)

Project Implemented ASCP R12 (12.1)
Position Senior Consultant
Environment Oracle E-Business Suite (12.1) with 11.1.0.7 Database on OEL 5.4 with single node installation, Windows 2003, 10g AS
Project Description
Implemented ASCP R12 (12.1) Instance on decentralized architecture integrating ASCP with Source
Instance 11.5.10.2 for Value Chain Management and also integrated 10g AS Oracle Business
Intelligence with R12 and Integrated Oracle Demantra 7.3 with ASCP Instance
Roles and Responsibilities

• Involved in System Studies for ASCP architecture
• Documented the Installation and Integration Process
• Analyzed the software/Hardware requirements
• Installed R12.1 for UAT
• Patch Analysis for 11i and R12 ASCP Integration
• Applied ASCP Consolidate Patches
• Installed Oracle Demantra 7.3 and Integrated with ASCP
• Installed 10g AS Business Intelligence and Integrated with ASCP
• Resolved Post UAT Issues
• Cloning and Patching
• Gone-Live for ASCP Architecture
• Post-Go Live Support

Oct 09 to July 2010 Confidential,CA (USA)
Project Worked on CSSD/ERMO Multiple Projects
Position Senior Consultant
Environment ERP/NON ERP Instances (11.5.9/R12) 9i/10G Databases
Description Worked on Multiple projects Including RAC Installations, Involved in Monthly/Quarterly ERMO Activities
Roles and Responsibilities

• Attending Day-to-Day Issues using Remedy tool
• Cloning the Code Trees for 10G RDBMS/CRS
• Installed RAC Database for Non-ERP Instances
• Patching the Test/DEV Instances
• Cloning Non-ERP Databases
• Pager Duty
• Schema Migration using Export/Import Utilities
• Space Management
• Supporting Monthly/Quarterly ERMO Activities
• Supporting Deployment Process
• Migration of 9i Databases to 10g

Sep 08 to July 09 Confidential,Project (India)
Project R12 Upgrade

Position Project Lead (Senior APPS DBA) Environment Oracle E-Business Suite (11.5.9) with 9.2.0.3 Database on RHEL 3 with single node installation, Oracle E-Business Suite (12.0.4) with 10G (10.2.0.4) on RHEL 4.4 Project Description

STPL (Sharadha Terry Private Limited) is a flagship company of US$ 500 million KG Group conglomerate, Using Oracle Applications 11.5.9 with Financials, Distribution and Manufacturing modules, upgraded to Oracle E-Business Suite R12 (12.0.4) with Database 10g(10.2.0.4)
Roles and Responsibilities

• Involved in the system study requirement about the existing architecture
• Analyzed the existing functionality of the instances
• Prepared the scope document for the upgrade phases (which includes risks and challenges)
• Analyzed the set patches for Upgrade
• Cloned the Production Instance
• Applied all the required patches on 11.5.9 to move forward to R12 Upgrade
• Applied all technology stack patches which is compatible with 11.5.9 version
• Upgraded Forms/iAS/Jinitiator
• Applied CU2 patch on 11.5.9
• OATM Conversion
• Upgraded the database to 10g which includes pre and post upgrade process
• Installed R12 Upgraded Files system
• Applied A.D.A.6 Delta patch for R12
• Applied Unified driver patch for R12
• Completed Post-Upgrade patches for R12
• Attended the Post-Upgrade issues
• Implemented RMAN backup strategy

Oct-2007 to Sep-2008 Confidential, (India)
Project Confidential,

Position Project Lead (Apps DBA) Environment Oracle E-Business Suite (11.5.10.2) with 9.2.0.6 on IBM-AIX 5L with Multi Node Installation Project Description

Mascon Global Limited is implementing the Oracle E-Business Suite 11.5.10.2 with Oracle HRMS/Financials and Project Accounting for its business operations in various worldwide locations.
Roles and Responsibilities

• Cloning Test Instances
• Application of Patches
• Upgraded developer 6i patch set 18
• Installed Oracle iLearning on standalone Server
• Attending day to day issues in CRP Process
• Installed Oracle Discoverer and Integrated with EBS
• Installed Oracle iLearning5.0 as standalone application
• Applied HRMS Patch set K
• Implemented Java Workflow Mailer
• Implemented SSL
• Applied Indian localization patches for Financials
• Support to the Production Instance for 24/7
• Mentoring Apps DBA Team
• Installation of Oracle E-Business Suite R12 (12.0.0) Test and Dev Instances.
• Upgraded Database to 10G (10.2.0.3)

May-2007 to Sep-2007 Confidential,
Project Confidential,

Position Senior Consultant Apps DBA [On-Site]

Environment Oracle E-Business Suite (11.5.4)/11.5.10.2 Database 8.1.7/10g Solaris 8(Multi-Node) and Windows XP client

Project Description

Confidential,holding life insurance is a Prestigious Client involved in Insurance and Holding business in Caribbean region with large network and they are currently using 11.5.4 multi-node node Instance with financial modules AP, GL, AR and upgrading their existing instance to 11.5.10.2 with 10g
Roles and Responsibilities

• Analyzed the existing instances
• Prepared the project plan and resource allocation in a upgrade process
• Cloned the Production instance
• Applied TUMS patch
• Applied Validate Roll up(TXK) patch
• Applied Technology Stack utility patch
• Upgraded the database from 8.1.7 to 9.2.0.8
• Upgraded the Forms and iAS Server
• Upgraded the JDK(1.4)/Jinitiator(1.3.1.29)
• Applied Maintenance Patch
• Upgraded Database from 9.2.0.8 to 10g
• Tested all the new features in CRP’s
• Solved all the issues raised in Upgrade Process
• Completed Production Upgrade
• Provided Post-Upgrade Support

Nov 2006 – Apr 2007 Confidential,
Projects Confidential,
Position Senior Consultant Apps DBA [On-Site]

Environment Oracle E-Business suite (11.5.9)/11.5.10.2 and Database 9.2.0.3/9.2.0.8 Linux 4(Multi-Node) and Windows XP client

Project Description

Trinidad Cement Limited (Trinidad and Tobago) is one of the leading cement manufacturers in Caribbean Region using Oracle Application (11.5.9) with HRMS/Financial/Payroll modules on Linux on two nodes and Upgrading the existing application to 11.5.10.2 version
Roles and Responsibilities

• Cloned the Production Instance from Multi-Node to Single Node
• Applied Tums Patch
• Upgraded the database from 9.2.0.3 to 9.2.0.7
• Upgraded the iAS from 8.1.7.0 to 8.1.7.4
• Upgraded the Forms from 6.0.21.8 to 6.0.27.8
• Applied maintenance patch for 11.5.10.2
• Applied On-Line Help patch for 11.5.10.2
• Trouble shooting the Post Upgrade Issues
• Cloned the Single Instance to Multi-Node Instance
• Prepared the system for CRP
• Upgraded the Production Instance
• Upgraded the existing HRMS and Payroll Module to RUP1
• Provided off-shore support
• Provided Off-Shore Support for Upgrading 10g on Production database

Jun 2006 – Oct 2006 Confidential,
Projects PPGPL Upgrade Project and Project Cost Implementation
Position Senior Consultant Apps DBA [On-site]
Environment Oracle application systems11i (11.5.9), Database 9.2.0.5 on Windows 2003(Multi-Node) and Windows XP

Project Description

Phoenix Park Gas Processors Limited is one of the major gas processor companies in Caribbean Region located in Trinidad. They already Implemented Oracle Applications 11i (11.5.9) Financial/HRMS and upgraded the existing Application to 11.5.10.2 and also implemented Project Costing module
Roles and Responsibilities

• Applied Tums Patch
• Upgraded the database from 9.2.0.3 to 9.2.0.7
• Upgraded the Using Rollup patch set
• Upgraded the Forms from 6.0.21.8 to 6.0.27.8
• Applied maintenance patch for 11.5.10.2
• Applied On-Line Help patch for 11.5.10.2
• Trouble shooting the Post Upgrade Issues
• Implemented Project Costing

April -2005 -May-2006 Confidential,
Project Confidential,
Position Senior Consultant Apps DBA [On-Site]
Environment Oracle Applications system11i (11.5.9), Database 9.2.0.3, windows 2003 server (Single Node) and Windows XP client

Project Description

Airport Authority of Trinidad and Tobago is already using Oracle Applications systems 11i (11.0.3) Financial module and they are upgraded the existing 11.0.3 version to 11.5.9 from Windows NT To Microsoft 2003 and also implementing HRMS and Payroll module. Providing the ON-SITE service in upgrade of 11.0.3 to 11.5.9 And HRMS and payroll implementation process
Roles and Responsibilities

• Cloned the 11.0.3 production to the Test Instance for upgrade
• Used Export and Import utilities for moving the data in upgrade process
• Used auto upgrade utility upgrade the database objects
• Applied the AD patches
• Configured the Auto Config for upgrading
• Applied Maintenance Pack Patch for 11.5.9
• Configured the new Upgraded 11.5.9 for Test Instance
• Involved in trouble shooting in the Upgrade process
• User’s creation and assigning responsibilities
• Customizing the responsibilities according to user requirements
• Provided production support to the client
• Cloned the production server
• Implemented CRP’s for HRMS by applying HR.H family pack
• Developed SQL scripts and Windows scripts for Maintenance
• Prepared backup strategy
• Monitoring the performance of database using Stats Pack
• Attending the Daily Queries/Issues of the user group and providing the solutions
• Cloning the production server
• Running supportive scripts for each module
• Maintaining the space management
• Performed SYSADMIN responsibilities
• Worked with Oracle Support Service

Jan 2005 – Dec 2005 Confidential,
Project Confidential,
Position Senior Consultant Apps DBA [On-Site]
Environment Oracle application systems11i (11.5.9), Database 9.2.0.5 on Windows 2003(Multi-Node) and Windows XP (client)

Project Description

Phoenix Park Gas Processors Limited is one of the major gas processor companies in Caribbean Region located in Trinidad. They already Implemented Oracle Applications 11i (11.5.3) Financial Module and upgraded the existing Application to 11.5.9 and also implemented HRMS module
Roles and Responsibilities

• Cloned the production oracle Application (11.5.3) to the Test Instance Used for Upgrading process
• Upgraded the Database from 8.1.7 to 9.2.0.5
• Applied the AD-H family Patches to the Database and Applications
• Upgraded the JDBC/JDK Applications by applying the related patches
• Implemented the Auto Config
• Upgraded the Forms and Jinitiator
• Applied the Maintenance pack patch for Upgrading 11.5.3 to 11.5.9
• Ported the New Upgraded Oracle Applications 11.5.9 from Test to Production
• Provided the Post production services to the client
• Worked with Oracle Support System (OSS) to resolve the issues in Upgrade and Post Production services process
• Implemented the HRMS module on CRP by applying HR.H patches
• Providing the technical support to the Users on HRMS module implementation
• Trouble Shooting the Applications and Database
• Created the new concurrent programs as per user requirements

Aug 2004 – Jan 2005 UCAL Fuel Systems Application Database (India)
Project Confidential,
Position Senior Apps DBA
Environment Oracle Applications 11i (11.5.8), Oracle Database 8.1.7 on HP-UX (Single Node) and Windows XP (clients)

Project Description

UCAL Fuel Systems India limited Chennai the manufacturer in carburetor in India having 3 plants at different locations and they have implemented Oracle Application system 11i (11.5.8) Manufacturing module AP, AR For their business process
Roles and Responsibilities

• Installation Oracle database server/clients
• Used SQL*LOADER for dumping the data into database
• Created tablespace and properly sized the SGA
• Created schemas in a database
• Created roles for granting the privileges to the users
• Interaction with a client in database issues
• Taking a regular backup of the Huge database using export and other Backup modes
• Tuning the PL/SQL applications (Stored Procedures, functions)
• Involved in Back End programming with crystal Reports to Support BI on -site team
• Monitoring the database performance with help of STATSPACK tool
• Utilizing the database resources with the help of Resource manager
• Used many built in packages for database activities