SUMMARY

• 15 Years of total experience wif 13 Years of experience as an Oracle Application DBA Consultant in full life cycle implementations and up gradation of Oracle e - Business Suite applications, Providing *24/7 Support on Production Instances and training.
• Expertise in Performance Tuning, Migrations, Scripting, Disaster Recovery techniques, Backup & Recovery for Oracle 10g RAC, 9i, 8i Databases using shared Storage (SAN/NAS).
• Have good knowledge in e-Business Suite Architecture.
• Installation of Oracle Application wif single node and multi nodes in R12 and 11.5.10.2 on Linux/Unix environments.
• Good at applying patches of Oracle Applications and Maintenance using AD Utilities.
• Performing Regular Application Health Checkups.
• Monitoring Concurrent Manager and Troubleshooting.
• Expertise in setup, configure and maintain RMAN, Data Guard and ASM components.
• Experience wif OEM, OAM and Oracle Grid-control.
• Expertises in configure Discoverer 10g wif Oracle Applications R12.
• Up gradation of Oracle database from 9.2.0.6 to 9.2.0.8 and 10g to 11g and also Oracle Application from 11.5.10.2 to R12.
• Configuration and Troubleshooting of Workflow Notification Mailer.
• Expertise in Configuration of Oracle Discoverer 10g.
• Capacity planning, monitoring, auditing, database/application performance optimization and other tasks.
• Ability to multitask be flexible under pressure, and work wif changing priorities in a dynamic environment.
• Manage project - task estimation, planning, risk mitigation analysis, etc.
• Very good experience working wif Oracle Applications as Technical Developer.
• Worked wif Oracle for resolving critical and transactional issues through SR’s and OWC’s.

TECHNICAL SKILLS

Database: Oracle 9i, 10g, 11g RAC, MS SQL Server 2000 & 2005, MS Access.

Middleware: Oracle Application Server 10g, WebLogic, SSO, OID, LDAP.

Hardware&OS: Linux, UNIX, Solaris 9, 10, Windows 2000/2003.

Programing: SQL, PL/SQL, Shell Scripts, C, HTML, JavaScript and XML.

NetWare: TCP/IP, FTP, Telnet, Netscape, and Internet.

Tools & Utilities: RMAN, Data Pump, Dataguard, OEM, Grid Control.

Oracle Tools: Dev.2000 (Forms 10g/6i/4.5, Reports 10g/ 6i), Discoverer 10g/6i/4i, SQL*LOADER Oracle SQL Navigator, TOAD, RUEI

ERP Modules: Oracle Applications R12/11i(Oracle Receivables, Oracle Payables, General Ledger, Purchasing, Order Management, Shipping, Fixed Assets, Cash Management, Inventory, Advance Pricing, Oracle Workflow, Oracle e-Commerce Gateway and Oracle Projects (PA), iExpenses, iProcurement, iSupplier, Oracle HRMS and Oracle Payroll, Bill of Materials, Quoting, Inventory, Configurator, Integrated SOA Gateway.

Methods: Oracle Applications Implementation (AIM) Methodology.

Others: SAN/NAS, Vmware, VERITAS Net Backup.

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Oracle Apps DBA Lead

Responsibilities:

• Worked on Upgrade of Oracle Applications from 12.1.3 to 12.2.4
• Integration of E-Business Suite wif Oracle SSO 11g (Single Sign on)/OID (Oracle Internet Directory), Oracle Access Manager ( OAM ) wif LDAP (Microsoft Active Directory) configuration.
• Administration and managed Web logic Server 11g
• Apply online patches (ADOP) to teh production environment in Oracle EBS 12.2.4.
• Coning from Prod to Test/Dev environments.
• Extensively worked on managing teh Concurrent Managers and its operations like starting, stopping teh concurrent managers and monitoring of teh concurrent managers.
• Generated and analyzedSTATSPACK, AWR, ADDMreports and monitored statistics for performance tuning of teh database.
• Monitor all teh production Alerts and do necessary changes in teh production
• Support 24x7 Support in all teh production environments.
• Worked extensively wif production support tickets wif proper SLA's and admis
• Oracle Support (Metalink) SR maintenance and administration.

Environment: Oracle EBS 12.1.3, Oracle 11.2.0.4, RH Linux 5.7, Weblogic11g, SSO/OID/OAM 11g

Confidential, Chicago, IL

Oracle Apps DBA

Responsibilities:

• Implemented PGP encryption Program in Production to send teh files to JPMorgan Bank in encrypted format. Worked wif JPMorgan on PGP encryption testing and teh Process.
• Implemented 3rd party tool LiveVault Web Management Portal to backing up teh SSO EBS production servers.
• Implemented Load Runner 11.50 and created scripts to do load testing on HYATT HYPERIAN production servers.
• Setup DR and tested DR environment for Hyatt.
• Worked on SSO environment wif Oracle On Demand.
• Proactively worked heavily to streamline workflow inbound/outbound notifications (me-Expenses) and cleaned up all teh open notifications and filter all notification which are not valid.
• Involved daily regular Production support.
• Extensively worked on Patching and Coning.
• Created all teh Process documents for Hyatt.
• Created Virtual machines on UNiX environment and install operating Systems Linux/Redhat for creating SSO environment using CITIX XenCenter.
• Ability to communicate wif business users at all levels to resolve production issues.
• Monitor all teh workflow notification IMAP server, backups, VM ware Servers.

Environment: Oracle Applications 11i/R12, Oracle 11g, Oracle Application Server 10g, Linux 5, Database Grid Control, Weblogic, WebCenter, SOA, OBIEE, HYPERIAN . VM’s

Confidential, Sunnyvale, CA

Oracle Apps DBA Support Lead

Responsibilities:

• Worked on Production DBA Lead to support multiple Production environments and Development Oracle Application environments.
• Developed shell scripts to automate some of teh processes like Struck order, custom concurrent Managers, Workflow deferred agents.
• Developed queries for SOX control for production environments.
• Worked on Oracle Application 12.0.3/11i wif 11.2.0.2 4 node RAC Database wif WebCenter, WebLogic, SOA and OBIEE environment.
• Worked on SOA wif BPEL/OBIEE and worked creation and supporting of WSDL’s for SOA in R12/11i Environment.
• Extensively worked on integration issue to figure out teh SOA issues from SOA monitor wif SOA users and Webservices.
• Extensively worked on Upgrades, Patches and Coning and Change Management Process.
• Worked extensively wif Kintana tool for Production Migrations.
• Monitor all teh production Alerts and do necessary changes in teh production.
• Strong experience working wif all boundery systems like PeopleSoft, Siebel, SOA, CMAT, SFDC.
• Extensively worked on OMC and troubleshoot OMC user issues and access.
• Worked extensively on weekly production major and minor releases.
• Support 24x7 Support in all teh production environments.
• Worked extensively wif production support tickets wif proper SLA's
• Working wif Oracle support: opening, managing, and resolving Oracle SR's.
• Created Process documents for all teh releases and trained teh onsite and offshore DBA's.
• Work closely wif Development Team to identify potential future re-designs efforts supporting continuous improvement of teh system.
• Ability to work wif other infrastructure teams like Storage, UNIX, Tools and Windows etc.
• Documentation of solution knowledge and process monitoring techniques for re-use by Development and Support teams.
• Worked wif Performance tools AXIBASE, BAC (Business Availability Center), RUEI (Oracle Real User Experience Insight).
• Trained off-shore DBA team and coordinate all teh DBA activities.
• Created all teh process documents for teh Production environments.

Environment: Oracle Applications R12, Oracle 11g, Oracle Application Server 10g, Linux 5, Database Grid Control, Weblogic, WebCenter, SOA, PeopleSoft, Siebel, CMAT, SFDC, OBIEE.

Confidential, St Louis, MO

Oracle Apps Dba/SysAdmin

Responsibilities:

• Implemented new feature in R12 Role Back Access Control (RBAC) in User Management for Financial modules, HRMS, Quality and Advanced Supply Planning.
• Migrated FSG Reports from one instance to other instances.
• Worked on implementing Report Manager (Web based FSG reports) new feature in R12.
• Worked on migrating objects from one instance to other.
• Experience in managing and working through Oracle's TAR escalation process.
• Ability to work closely wif users, cross-functional teams and external vendors.
• Ability to multitask be flexible under pressure, and work wif changing priorities in dynamic environments.

Environment: Oracle Applications R12, Oracle 11g, Oracle Application Server 10g, Linux 5, Database Grid Control, SQL, SQL*Plus, PL/SQL.

Confidential, MI

Oracle Apps Dba

Responsibilities:

• Worked on Cross platform Migration from HP-UNIX to Sun Solaris on Apps 11.5.10.2. in shared APPL TOP environment.
• Worked on migrating database nodes on R12 environment.
• Worked on teh Oracle Diagnostic Tool.
• Worked on Forms & Reports 6i Patch 19 wif Patch validation report.
• Deployed SUN JRE for E-Business Suite on 11i and applied interoperability Patch.
• Applied latest TXK AUTOCONFIG and TEMPLATE ROLLUP PATCH.
• Worked on advanced cloning for 11i and R12 instances
• Upgrade JAVA version.
• Worked on custom Forms and custom concurrent reports.
• Worked on ASM based databases wif RAC.
• Patch Application to resolving and fixing bugs.
• Backup and recover databases using RMAN scripts.
• Apply Quarterly cumulative patch updates CPU.
• Troubleshooting Apache and Jserv.
• Worked wif Oracle for resolving critical production issues.

Environment: Oracle Applications R12/11i, Oracle 11g/10g, Oracle Application Server 10g, SunSolaris, Database Grid Control, SQL, SQL*Plus, PL/SQL, SQL*Loader

Confidential, San Jose, CA

Oracle Apps Dba

Responsibilities:

• Worked on Application upgrade from 11.5.10.2 to R12 (12.1.1).
• Worked on Cloned appsTier, dbTier and apply patches.
• Configured 4 node 11gRAC setup on Linux5 platform and Performed GRID home and RDBMS home from RAC systems using SAN.
• Worked on cross platform migration (Solaris to Linux), upgrading from 10g to 11g database and perform auditing between teh source and teh target databases.
• Worked as support Dba in all CISCO databases.
• Worked on Hyperion Environment.
• Worked wif Oracle for resolving critical and transactional issues through SR’s

Environment: Oracle Applications R12, Oracle 11g, Oracle Application Server 10g, Linux 5, Database

Grid Control, SQL, SQL*Plus, PL/SQL, SQL*Loader

Confidential, Atlanta, GA

Oracle Apps Dba Lead

Responsibilities:

• Involved in Real Application Clusters installation and creating teh RAC databases using raw devices and asm instance.
• Migrated from NON-RAC database to RAC database.
• Successfully Added node to teh existing cluster database.
• Implementing sound backup and recovery strategies, for rac databases using rman according to teh SLA. Taking teh backup of voting Disk and OCR as per teh backup policy.
• Monitoring and administrating rac database using utilities like srvctl, crsctl, crs stat, olsnodes and ocrconfig.
• Configured Flash Recovery Area, monitoring and working wif FRA.
• Created ASM instance and disk groups.
• Migrated non ASM based database to ASM based database.
• Cloning teh production database and refreshing teh test and development databases to synchronize wif production database.
• Perform regular database activities like database health check up, space management.
• Monitoring teh scheduled jobs and solving any issues related to failed jobs.
• Managing Tablespaces, Data files, Control files, Redo Log files and Archived logs.
• Applied Interim and Patch set Patches.
• Upgraded database from 9i to 10g.
• Security Administration by creating Users wif appropriate ROLES and PRIVILEGES.
• Monitoring teh System response time and detect for any bottlenecks by using AWR reports and ADDM reports.
• Used Oracle Diagnostics tools such as SQL Trace, TKPROF to analyze timing and execution plan for SQL query to tune teh SQL statements.
• Rebuilding teh Fragmented Indexes, Pinning or Unpinning Objects like PL/SQL packages, procedure, functions in Production environment to improve performance.
• Keep track of invalid objects and compiling them.

Environment: Oracle 11g/10g, RMAN, SQL Server 2000 & 2005, Oracle Application Server 10g, Red Hat Linux, Database Grid Control, Windows 2003, HP, Toad, Verities Netbackup.

Confidential CA

Oracle Apps DBA

Responsibilities:

• Configuration of RMAN to perform Backup and Recoveries.
• Created scripts to run RMAN Incremental and Full Backups automatically.
• Planning for Backup and Recovery of Database information and maintaining HOT backups, COLD Backups also include RMAN backups.
• Configuration of CLONING teh database from PRODUCTION to DEVELOPMENT using RMAN.
• Created scripts to REFRESH teh PRODUCTION database to DEVELOPMENT database for Testing Purpose.
• Database Performance Tuning using (statspack, tkprof, AWR).

Environment: Oracle10G, HP UNIX, MS SQL, SYBASE, PEOPLESOFT 9.0, GL, AR, AP, HRMS, PAYROLL Forms, Reports, SQL, SQL*Plus, PL/SQL, SQL*Loader and Win 2003.

Confidential

Application DBA Lead

Responsibilities:

• Experience in Implementing Oracle Apps R12 on Redhat Enterprise Linux 4 (64Bit) Server operating system environment for creating Test and Development environment on different modules Oracle Financials, Oracle HRMS and Oracle Payroll.
• Applied product specific fix patches, family packs, maintenance packs.
• Troubleshooting expertise for all tiers (Apache, Forms, Concurrent, Admin and database).
• Installed Quantum for Oracle Payroll.
• Implemented Vertex Payroll Tax Q Series (Quantum) Libraries and Quantum Library environment configuration.
• Configured Oracle Enterprise Manager (OEM) Grid Control and and Repository in OEM 10G.
• Experience wif applying HR Global patches and updates.
• Sound knowledge of AD utilities, cloning and System Administration tasks.
• Patch Applications for resolving and fixing bugs.
• Troubleshooting teh Applications issue and performance problems.
• Creating and Monitoring Application users, assigning Responsibilities and managing user profiles.

Environment: Oracle Applications R12, Oracle10G, GL, AR, AP, AOL, HRMS, PAYROLL Forms10g and Reports 10g, SQL, SQL*Plus, PL/SQL, SQL*Loader, Win NT and UNIX.

Confidential, Illinois

Oracle Apps Dba Lead

Responsibilities:

• Expertise in applying Mini pack, Family pack, Maintenance packs Diagnostics packs, IOP patches.
• Implemented Custom Concurrent Manager for running Month end reports.
• Implemented Workflow Notification Mailer for employee’s expense approval through email in iExpense module.
• Implemented Workflow Notification Mailer for various notifications dat are sent to Suppliers in iSupplier module.
• Worked on iSupplier and iProcurement Customization for Store linkup and setup stores Office Depot and Chateau Products.
• Implemented Oracle Payroll TAX LIBRARIES.
• Installed and configured OEM for Database, Applications and concurrent managers monitoring.
• Analyzed teh Application tables, indexes & gatheird statistics for CBO.
• Cloned appsTier and dbTier numerous times before GO-LIVE and automated this process for post-production procedures using shell scripts.
• Created automated backup procedures using RMAN and shell scripts for cold and hot backups including archive logs.
• Upgrading database from 9.2.0.6 to 10.2.0.2.
• Involved in upgrading teh Applications from 11.5.10.2 to R12.
• Configured 10gRAC setup on Linux4 platform and Performed CRS home and RDBMS home from RAC systems using shared storage (SAN/NAS).
• Removed existing node and Added new node to teh Cluster environment.
• Backup and Recovery using HOT, Exports/Imports and RMAN Methodologies.
• Migrate teh NON-RAC database to RAC-database.
• Creating of database indexes on certain tables to improve query performance after thoroughly testing teh same in teh development environment.
• Regular monitoring of Alert log file on day-to-day basis.
• Expertise Administering Applications using AD utilities.
• Purge teh frequently generated workflow data using concurrent manager.
• Troubleshooting teh Applications issues and performance problems.
• Registering custom forms and reports.
• Creating and Monitoring Applications Users, assigning Responsibilities and managing user profiles.
• Monitor and Troubleshoot Performance issues as reported by users.
• Worked wif Oracle for resolving critical and transactional issues through SR’s and OWC’s.

Environment: Oracle Applications R12, 11i, Oracle 10g, 9i,Discoverer 10g, INV, PO, AOL, GL, AR, PA Forms 10g/6i, and Reports 10g/6i, Workflow2.5, iExpenses, iProcurement, iSupplier, SQL SQL*Plus, PL/SQL, SQL*Loader, Win NT and UNIX.

Confidential

Sr. Application DBA

Responsibilities:

• Installing Multi-node Oracle-Apps 11i (11.5.9) on HP-ux11i-64bit operating environment for creating Test, Development, environments.
• Expertise in applying Mini pack, Family pack, Maintenance pack Diagnostics packs, IOP patches.
• Applied database Opatches.
• Participated in teh Upgradation of Apps (11.5.5-11.5.9 ) using Adaimgr utility.
• Diagnosed and Tuned Oracle Apps11i for me/O Load and relieve contention.
• Worked on Platform Migration from HP UNIX to Linux.
• Upgrading database from 9.2.0.6 to 10.2.0.2.
• Configured and Handling DATAGARD (Physical).
• Resolved locking issues in Applications.
• Perform Manuel cloning using Adclone utility.
• Upgrade Jinitiator and regenerate Digital Certificates.
• Analyzed teh Application tables, indexes & gatheird statistics for CBO.
• Expertise Administering Applications using AD utilities.
• Expertise in monitoring Application-using tools as OEM.
• Purge teh frequently generated workflow data using concurrent manager.

Environment: Oracle Applications 11i.10, Oracle9i, OM, INV, BOM,QP, PO, OLM, AOL, GL, AR, PA, Forms 6i and Reports 6i, Workflow2.5, SQL, SQL*Plus, PL/SQL, SQL*Loader, Win NT and UNIX.

Confidential, IL

Application Dba

Responsibilities:

• Installing Oracle-Apps11i (11.5.9) on Linux Advance Server2.1 operating environment for creating Test and Development environment.
• Administered Workflow (Starting and monitoring teh workflow engine, Purging absolute workflow data and Trouble shooting workflow issues).
• Patch Applications for resolving and fixing bugs.
• Tuning of Concurrent Manager.
• Backup and restoration.
• Troubleshooting teh Applications issues and performance problems.
• Liaison wif Oracle-Support for bug fixes and patch applications.
• Creating and Monitoring Applications Users, assigning Responsibilities and managing user profiles.
• Monitoring and Managing Concurrent Programs and Reports.
• Managing Application Security.
• Managing Profile options.
• Registering custom forms and reports.
• Assigning Resource Consumer Groups having similar Resource requirements.
• Managing Profile options.

Environment: Oracle Applications 11i.10, Oracle9i, GL, AR, PA, OLM, BOM,QP, INV, WIP,AOL, Forms 6i and Reports 6i, Workflow 2.5, SQL, SQL*Plus, PL/SQL, SQL*Loader, Win NT and UNIX.

Confidential, Chicago IL

Application Dba

Responsibilities:

• Configured, maintained and Resolve issues in Standby database.
• Monitor and Troubleshoot Performance issues as reported by users.
• Perform Instance tuning for peak performance.
• Cloning and Refreshing Database instances.
• Configure network component for Load Balancing and security.
• Resolve users Network connectivity Issues.
• Installation of Oracle 9i for Production, Testing and Development environments on Linux and Solaris Platform.
• Setup V$ Scripts and Unix Shell Scripts (Bourn shell) for automated DB Monitoring and Diagnosis.
• Performed Database Backup using RMAN and Recover from media failure.
• Migrated Databases from NT to UNIX servers and also participated in Oracle 8i to 9i upgrade project.
• Proactive monitoring of Table space, Data files, and Logs.
• Use OEM to monitor and maintain teh Database / Objects, to refresh teh Snapshot Replication Groups.

Environment: Oracle Applications 11i.10, Oracle9i, GL, AR, PA, OLM, AOL, Forms 6i and Reports 6i, Workflow 2.5, SQL, SQL*Plus, PL/SQL, SQL*Loader, Win NT and UNIX.

Confidential, NY

Application DBA

Responsibilities:

• Monitoring teh Instance on daily basis.
• Installation of 11.5.9 Oracle Application.
• Single node and Multinode Maintenances of Oracle Application 11.5.9.
• System Administration Tasks like Create users, assigning responsibilities.
• System Administration Tasks on Concurrent Manager.
• Troubleshoot problems wif web server, web listener, forms server, concurrent managers, and database on 11.5.9.
• Maintaining teh instance wif AD Administration.
• Apply application patches and database patches.
• Cloning Oracle Applications.

Environment: Oracle Applications 11i.9, Oracle9i, GL, AR, PA, OLM, AOL, Forms 6i and Reports 6i, Workflow 2.5, SQL, SQL*Plus, PL/SQL, SQL*Loader, Win NT and UNIX, Toad.

Confidential, Madison, WI

Technical Consultant

Responsibilities:

• Involved in teh system study and analysis of business requirements of teh users.
• Working on issues related to Item import, Requisitions import, PO export, custom imports and exports of vendor data and Receipts.
• Make changes to standard Oracle Applications views to improve teh performance of PO CHANGE HISTORY form as advised by Oracle Support and involved in cloning, troubleshooting technical issues.
• Modified teh custom PO approval workflow to prioritize teh notifications so dat users can identify teh high severity notifications.

Environment: Oracle applications 11.0.3 (AP, GL, INV, PO and OE) Sun Solaris 5.8, Forms 4.5, Reports 2.5, Oracle 8.1.7 and PL/SQL, Oracle Workflow 2.0

Confidential, TX

Technical Consultant

Responsibilities:

• Defined Workflow for approval of Invoices.
• Completed teh AP cycle by running teh Payables Transfer to GL Concurrent Request.
• Run teh Invoice Inbound Program (INI), an E-Commerce interface program to import supplier invoices into Oracle Payables for manual and or electronic payments.
• Conversion and reconciliation of Legacy AP Invoices and Payments into Oracle Applications.
• SQL/Performance tuning using explain Plan and TKPROF utility. Involved in Design and Code reviews. Written database triggers, functions and procedures.

Environment: HP-UNIX, ORACLE Applications 11.03, Modules - AOL, GL, AP, PO, EDI, Alerts, Oracle 8.0.5, Developer 2000, SQL*Plus, Toad, SQL*Navigator, PL/SQL, Reports 2.5, Forms 4.5.