SUMMARY:

EBS Experience involves Oracle Apps Database Administration, Analysis, Design, Testing, Implementation, Troubleshooting & Maintenance.

Experience on 9i/10g/11g/12c RAC databases Including Installation/Troubleshooting.

Implemented and Configured 12c/ 11g Grid Infrastructure - CRS & ASM.

Worked on Very Large Databases over 7TB to 40 TB with different Application Platforms

Worked on Oracle Database Upgrades from 11g to 12c, Cloning and Patching.

Worked on 11i upgrade with Platform Migration of oracle applications and database from Solaris to Linux.

Involved in Installation/Implementation/Configuration/Upgrades/Support of 11i/R12/12.2.2/12.2.4 instances.

Upgraded Ebiz from 11.5.10 to 12.2.2 & from 12.2.2 to 12.2.4

Troubleshooting 11i/R12 Production Support Issues including Batch ( Concurrent Manger) and OLTP.

Implemented PCP, Shared Application top and OATM.

Production Support on 12.2.2/12.2.4 which includes Patching ( adop utility ), Cloning ( dualfs ).

Worked on Externalization/Hardening of R12 istore and R4 OID/SSO.

Involved in Installation/Configuration/Maintenance of Oracle Applications Techstack.

Setup/configure/Support/maintenance of multinode 11i/R12 Environments.

In-depth Knowledge of Oracle Apps Administration 11i/R12.

Involved in Oracle Apps Upgrades to all major versions including R12.

Worked on Self service i-module implementation like istore and iexpenses.

Implemented and Configured SSL for R12 applications.

Hands on Experience on Oracle Applications 10.07/11.0.3/11i/11.5.9/11.5.10/R12 on Unix /Linux Platforms

Involved in Platform migration of Oracle Applications 11i/R12 using Transportable Tablespaces

Installed and Configured Fusion Applications 11.1.4.

Integrated Ebiz R12 with OAM 11.1.1.7 with AD Integration.

Installed and Configured Goldengate 12c.

Installed and Configured Fusion Middleware 11g.

Worked on Implementing SOA/BPEL/OAM/OIM in a High Availability Environment.

Worked on Integrating Ebiz, Siebel OnDemand Applications with OID/SSO/Identity Federation.

Oracle Database Administration for Siebel OLAP and Analytics.

Worked on fusion middleware technologies including setup of SOA/OID/OAM/ODI/SSO. The SOA experience includes installation of BPEL, maintenance and administration of OC4J environment.

Database and Application Support in Production, testing and Development Environments.

Involved in installation / Support of OBIEE databases.

Shell Scripting, PL/SQL and SQL Scripting.

24*7 Oracle Production Support Experience.

Oracle configured Exadata X5-2 at the client site (2 compute notes, 3 storage servers).

Migrated EBS/DB to the compute nodes and upgraded DB from 11g to 12c.

Migrated OBIEE 11g database from AIX to this Exadata Linux.

Upgraded the exadata and storage server images to 12.1.2.3.2

Knowledge on storage indexes and HOC compression.

Support and Work on Various Oracle Application Development, Testing, Quality Instances.

Worked for a Major Companies which follows High Quality Standards such as CMM level 5 and Six Sigma.

Green Belt Certification using 6 sigma methodology from GE Captial.

Worked for major clients like GE Capital, GE Fleet, GE Power systems, GE CRE,GE Aircraft Engines, Agilent Technologies (HP), CISCO Systems, MASCO, US Steel, CMS – HIGLAS IBM,Google at various locations including USA, Singapore, Hungary.

TECHNICAL SUMMARY:

Storages : Super Domes, EMA 12000, ESA 12000 Compaq Storages.

Servers : HP N4000, HP K570, HP K380, Alpha 1200, AIX P5,P6,P7

Operating Systems : HP-UX 11.00, HP-UX 10.20,AIX 6.1, Sun OS v.5.5.1, Compaq Tru64 Unix 4.0G.

Hardware : Raid 5 & Raid 0+1.

DBA : Oracle 7.3/8i/9i/10g/11g/12c, Oracle Applications 10.7/11i/R12,Sybase 11.9.2, SQLServer, CRM 11i, Basis administration.

ERP : Oracle Applications 10.7/11.0.3/11i/11.5.9/R12, CRM 11i, SAP R/3,

Fusion Apps 11.1.8

Fusion Middleware : 10g/11g, BPEL, OID,OAM,OIF,SOA,OIM,OAM,OBIEE,Weblogic,GoldenGate,ODI

Languages : SQL, PL/SQL, C, Oracle, SAP ABAP Programming.

Tools/Applications : Datawarehousing, Informatica, Cognos, Unix (Sun Solaris, AIX, HP), Shell, Perl Programming, Veritas, Quest Tools.

EXPERIENCE:

Client CMS - HIGLAS, Linthicum Sept 2014 to Till Date Role Sr. Oracle DBA

Responsibilities:

Upgrade of Ebiz 11.5.10 to 12.2.2

Upgrade of Ebiz from 12.2.2 to 12.2.4 and Database upgrade from 11g to 12c.

Support, Cloning & Patching of Ebiz 12.2 Instances.

Implemented, configured and troubleshooting WebLogic issues.

Implemented and configured 11g RAC with Grid Infrastructure on ASM.

Implemented and configured Grid Infrastructure for Database 11g/12c.

Implemented and configured SSL for Ebiz 12.2

Implemented and configured Shared Appl_top for Ebiz 12.2

Implemented and configured OEM grid 12c.

Implemented RMAN Backup on 12c Databases

Implemented and Configured Active Dataguard 12c

12c Grid/Database Patching for latest PSU.

Cloned EBS Oracle Database 12c using RMAN, Flash Copy.

Environment:

AIX / Linux, Oracle Applications 11i/R12, 11g/12c RAC Database, Grid,SQL,PL/SQL PACKAGES/SHELL/Perl ORACLE 11g RAC, OEM 12C, Middleware 11g –OBIEE.

Client US Steel, Pittsburgh, PA. May 2013 to Sept 2014

Role Sr. Oracle DBA

Responsibilities:

Production Support of ERP R12/Fusion Middleware environment.

Implemented and Configured GoldenGate 12c for Ebiz

Implemented, Integrated, Configured 11g OAM for Ebiz R12.

Implemented and configured 11g/12c RAC with Grid Infrastructure on ASM.

Implemented and configured Grid Infrastrucutre for R12 / Database 11g.

Implemented and Configured Fusion Applications 11.1.8

Production Support for Fusion Middleware components like OID/OAM/OBIEE/OIM/OIF/SOA/OAM/BPEL Environments running on 11g.

Installed and Configured OEM 12C/11g for monitoring EBS application and databases.

Troubleshooting ERP and Database Issues.

Oracle configured Exadata X5-2 at the client site (2 compute notes, 3 storage servers).

Migrated EBS/DB to the compute nodes and upgraded DB from 11g to 12c.

Migrated OBIEE 11g database from AIX to this Exadata Linux.

Upgraded the exadata and storage server images to 12.1.2.3.2

Knowledge on storage indexes and HOC compression.

Performance tuning of application – OA Framework,Concurrent manager,Techstack,PCP.

Performance tuning of the RAC database using OEM, Wait event Approach, AWR reports.

Implemented Oracle Real User Experience Insight for troubleshooting EBS Configurator Issues.

Implemented and configured OEM grid 12c.

Implemented RMAN Backup for Production/Non Production Databases

Implemented and Configured Active Dataguard 11g

11g Grid/Database Patching for latest PSU.

Cloned EBS Oracle Database using RMAN

Cloned database schemas using expdp/impdp

Environment:

AIX / Linux,,Oracle Applications 11i/R12, 11g/12c RAC Database, Golden Gate 12c, GridSQL,PL/SQL PACKAGES/SHELL/Perl ORACLE 11g/12c RAC, OEM 12C, Middleware 11g – OAM, SOA, OBIEE.

Client Masco, Ann Arbor, MI Dec 2008 to May 2013

Role Lead Oracle DBA

Responsibilities:

Production Support of 3 Node RAC, ERP R12/11.5.10 environment.

Involved in Implementing Oracle Applications 11i/Techstack projects.

Involved in Implementing PIM module on 12.1.1 and 11g database.

Production support of ASCP instance.

Upgrade ASCP instance from 10g to 11g and apps from 12.0.4 to 12.1.3. Applied latest Value chain planning 12.1.3 patches as part of Upgrade.

Monitoring of the production environments using OEM 11g.

Implemented and Configured 11g Grid Infrastructure – CRS& ASM.

Support of Dataguard environment and backups using RMAN.

Upgrade of 11.5.10 to R12.

Configured multiple Jservs, forms, report and concurrent managers for PCP.

Troubleshooting production issues for boundary systems like discoverer, sabrix etc

Involved in patching, refresh and upgrading the system to the latest RUP levels.

Production Support for Fusion Middleware components like OID/SSO/OIM/Portal/OIF/SOA/BPEL Environments running on 10gAS application server

The SOA experience includes installation of BPEL, maintenance and administration of OC4J environment.

Involved in tuning of SOA databases and applications.

Deployed applications in SOA/BPEL in a HA environment.

Troubleshooting ERP and Database Issues.

Troubleshooting Fusion Middleware issues related to BPEL/OID/SSO.

Integrating SSO with Ebiz.

Installed and Implemented OBIEE, Informatica for Sales/GL/AP

Administration of BI applications including OBIEE,Informatica and DAC

Move the concurrent manager from database node with shared appl_top setup.

Performance tuning of 11i.

Performance tuning Of SQL using ASH and AWR reports.

Performance tuning of application – OA Framework,Concurrent manager,Techstack .

Performance tuning of the RAC database using OEM, Wait event Approach, AWR reports.

Installed, Configured, administered OBIEE,Informatica and DAC environments

Involved in OBIEE database backup procedures and performance tuning.

Involved in supporting full and incremental OBIEE Loads.

Involved in implementing OBIEE Clustering and Integration with OID.

Promotion of OBIEE content across environments.

Experience in installing, administering and supporting weblogic for OAM applications.

Environment:

AIX / Linux, NetApps,Oracle Applications 10.7/11i, SQL,PL/SQL PACKAGES/SHELL/Perl ORACLE 10g RAC/SSO/OAM/ODI,OEM 11g, SOA,OID,OBIEE.

Client JDS Uniphase Inc, Milpitas,CA Mar 2008 to Dec 2008

Role Sr Oracle DBA

Responsibilities:

Upgrade of Oracle Applications from 11.5.7 to 11.5.10

Upgrade of Oracle Applications included OATM, Implementing Shared Appl_Top,PCP, externalization, platform migration, techstack etc.

Upgrade of Underlying database from 9.2.0.8 to 10.2.0.3

Migration of Oracle Database from Solaris to Linux using TTS.

Enabling 4 Node RAC for 11.5.10 upgraded Applications including CRS setup.

Externalization of istore on 11.5.10

Involved in day to day Oracle Applications DBA activities like patching,cloning etc

Setup of SSO/OIM/OIF for Oracle Applications and Siebel CRM On Demand

Involved in upgrade of SOA environment from 10.1.3.1.0 to 10.1.3.3.0 and applied the latest MLR patches

Involved in maintenance and administration of OC4J instances post release.

Performance tuning Of SQL using ASH and AWR reports.

Performance tuning of application – Framework,Concurrent manager,Techstack

Environment:

SUN SPARC SOLARIS 5.8 / Linux, NetApps,Oracle Applications 10.7/11i/R12, SQL,PL/SQL PACKAGES/SHELL/Perl,ORACLE 10g/11g, RAC/SSO.

Client Cisco Systems, Inc,San Jose,CA Aug 2004 to Mar 2008

Role Sr. R12/11i Oracle Apps DBA

Responsibilities:

Externalization of R12/10g (10.1.4.0.1) across DMZ Using Reverse Proxy.

Implementation of Self Service imodules: istore in R12 and iexpenses in 11i which includes multiple jvm setup.

Hardening of R12 and OID 10.1.4.0.1

Upgrade of 11.5.10 to R12.

Involved in all phases of 11i to R12 Upgrade of Oracle Applications.

Involved in all phases of 10.7 to 11i Upgrade of Oracle Applications.

Oracle Apps R12/11i Installations/Patching/Upgradation.

OID/SSO 10g (10.1.4.0.1) Installations and externalization, Setup of SSL between OHS and OC4J SSO, Setup of Server Side authentication between OID and SSO.

Registration of R12 and R3 as partner applications in R4

Implementation of 9i/10g RAC.

Cloning 9i/10g RAC and Non-RAC Instances

Concurrent Manager – PCP Implementation and administration.

24*7 Production Support /On-call Activities

Involved in maintenance and administration of OC4J instances post release.

Worked on maintaining SOX guidelines on the existing databases.

Oracle Database Creation/Upgrades.

Writing the Shell scripts/Perl script to automate the jobs.

Environment:

SUN SPARC SOLARIS 5.8 / Linux, Veritas Cluster/HP SAN/EMC SAN Environments,Oracle Applications 10.7/11i/R12, SQL,PL/SQL PACKAGES/SHELL/Perl /ORACLE 9i/10g RAC/SSO.

Employer: GE Capital International Services, Hyderabad,India June 2003 to July 2004

Role Consultant

GECIS - IT Services offer services across verticals including: Finance & Insurance, Computer software services, Medicine, Manufacturing, and Aerospace, Media & Telecom etc.

Responsibilities

Involved in managing & monitoring the Concurrent processing environment.

Involved in cloning and refresh of application environments.

Provided 24*7 support for the production problems.

Used ad utilities like adpatch, adctrl for application patching.

Cloning 9i RAC and Non-RAC Instances

Involved in upgradation of apps from 11.5.3 to 11.5.8

Troubleshooting Self Service Application issues.

Involved in managing Datawarehousing databases using Informatica, Cognos.

Involved in customization on various Oracle Application modules like Order entry,Manufacturing,Financials in areas of Oracle Reports, Forms using PL/SQL,UNIX shell scripts, Pro*C etc.

Environment:

SUN SPARC SOLARIS 5.8, Veritas Cluster/HP SAN/EMC SAN Environments,Oracle Applications 10.7/11i, ORACLE 9i RAC, Veritas, Shell, Perl, Datawarehousing Informatica, Cognos

Client: Agilent Technologies Pte. Ltd, Singapore Nov 2002 to May 2003

Role Oracle Apps 11i DBA

Agilent Technologies is the world's leading designer, developer, manufacturer and provider of electronic and optical test, measurement and monitoring instruments, systems and solutions. This application’s are presently running on Oracle Applications 11.5.5.

Responsibilities

Used ad utilities like adpatch, adctrl for application patching.

Involved in managing & monitoring the Concurrent processing environment.

Involved in cloning and refresh of application environments.

Involved in sysadmin activities like creation of user, responsibilities, configuring printers etc.

Provided 24*7 support for the production problems.

Planned & implemented Backup schedule’s & involved in creation of disaster recovery plan.

Involved in support and maintenance of Oracle application modules like manufacturing,

financials and order entry.

Environment:

Superdome,HP-UX B.11.11 A 9000/800,Oracle Applications 11.5.5,ASCP,MWA, Veritas, Shell, Perl .

Client: Agilent Technologies Inc, Colorado Springs,USA. Oct 2002 to Nov 2002

Role : Oracle Apps 11i DBA

Agilent Technologies is the world's leading designer, developer, manufacturer and provider of electronic and optical test, measurement and monitoring instruments, systems and solutions. This application’s are presently running on Oracle Applications 11.5.5.

Responsibilities

Used ad utilities like adpatch, adctrl for application patching.

Involved in managing & monitoring the Concurrent processing environment.

Involved in cloning and refresh of application environments.

Involved in sysadmin activities like creation of user, responsibilities, configuring printers etc.

Provided 24*7 support for the production problems.

Planned & implemented Backup schedule’s & involved in creation of disaster recovery plan.

Involved in support and maintenance of Oracle application modules like manufacturing,

financials and order entry.

Environment:

Superdome,HP-UX B.11.11 A 9000/800,Oracle Applications 11.5.5,MWA, Veritas, Shell, Perl

Employer: Tata Consultancy Services,Hyderabad,India Sept. 1998 to Sept. 2002

Client: GE Aircraft Engines, Hungary (Mar ’00 to Jun’00)

GE Aircraft Engines, Singapore (Feb ‘99 – Sept ’99)

GE Aircraft Engines, Cincinnati, OH (Dec ‘98 – Jan ’99)

.

Role - Programmer/I.T Analyst

Project

This Oracle Application Product is customized for service related industry. This product is the central core product with a host of interfaces with several legacy systems. It consists of Oracle Apps modules - Inventory, Purchasing, financials,Order entry and Wip.These modules constitute the core product which is interfaced with several other legacy systems. The core product replaces the existing mainframes system for which conversions and interfaces were required.

Responsibilities

Worked in manufacturing and financial module in the area of data migration from legacy systems. Involved in gathering the technical requirements, developing & testing the inventory conversion programs.

Involved in customization on various Oracle Application modules like Order entry,Manufacturing,Financials in areas of Oracle Reports, Forms using PL/SQL,UNIX shell scripts, Pro*C etc.

Involved in support and maintenance of Oracle application modules like manufacturing, financials and order entry.

Design, development, testing and implementation of Oracle Manufacturing/Financials applications.

Conversions involved data porting, functional validation, synthesis of data from existing data.

Used Utl file utility in PL/SQL procedures for the inventory conversions programs.

Configured printers & created the users, responsibilities, menus as per the user requirements.

Environment

SUN SPRAC E4500, Sun OS v.5.5.1,Oracle Applications 10.7SC, ORACLE 7.x

EDUCATION:

Bachelor Of Engineering, Gulbarga University, India

Contact this candidate