SUMMARY

• Total 17 Years of Industry Experience which involves Oracle Apps Administration, Analysis, Design, Development, Testing, Implementation, Troubleshooting & Maintenance.
• Involved in Installation/Implementation/Configuration/Upgrades/Support of 11i/R 12/ 12.2.2/12.2.4 instances.
• Upgraded Ebiz from 11. .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/11 i/ 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.
• Installed and Configured 12c RAC.
• 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.
• 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.
• 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 Confidential Captial.

TECHNICAL SKILLS

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/11 i/11.5.9/R12, CRM 11i, SAP R/3Fusion 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.

PROFESSIONAL EXPERIENCE

Confidential, Linthicum

Oracle Applications R12 DBA

Responsibilities:

• Upgrade of Ebiz 11. .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.

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.

Confidential, Pittsburgh, PA

Oracle Applications R12 / Fusion Middleware / Fusion Applications 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.
• 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.

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.

Confidential, Ann Arbor, MI

Oracle Applications R12 / Fusion Middleware 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. .
• 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.

Confidential, Milpitas, CA

Sr. 11i Oracle Apps 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.

Confidential, San Jose, CA

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. .
• 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.
• 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.

Confidential

Consultant

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

Confidential

Oracle Apps 11i DBA

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. 00/800,Oracle Applications 11.5.5,ASCP,MWA, Veritas, Shell, Perl .

Confidential, Colorado Springs

Oracle Apps 11i DBA

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. 00/800,Oracle Applications 11.5.5,MWA, Veritas, Shell, Perl

Confidential

Programmer/I.T Analyst

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 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

Confidential

Oracle Apps/Basis/Oracle/Sybase DBA

Responsibilities:

• 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.
• Used ad utilities like adpatch, adctrl for application patching.
• Monitoring of table spaces, work processes & backups, system, database, dump & job logs, spool configuration and handled transports across environments in SAP R/3.
• Involved in managing & monitoring the Concurrent processing environment.
• Planned & implemented Backup schedule’s & involved in creation of disaster recovery plan.
• Involved in performance tuning at the hardware, O.S, database & application level.
• Analyzed the database resources required for the project & planned the capacity requirement for the applications.
• Created & configured the database server, application schemas & the application objects in the respective schemas.
• Created the logical volumes/ volume groups/ raw partitions / file systems required for the Oracle databases on Raid 5 & Raid 0+1.
• Automated most of the jobs using cron & shell scripts
• Involved in monitoring, administration of the billing databases, creation of hot & cold backup scripts.
• Provided 24*7 support for the production problems during Batch & OLTP window and resolved performance issues.

Environment: HP N4000 / EMA 12000 COMPAQ storage ( HP 11.00 ),HP K570 / ESA 12000 COMPAQ storage ( HP 10.20) HP K380 / Local storage ( HP 10 .20 ) Unix Server,HP Unix - 11.00 & 10.20,Oracle 8.1.7 / CRM 11i / Sybase 11.9.2 /SAP R/3.

Confidential

ABAP Programmer/Analyst

Responsibilities:

• Development of interface with external system using Batch Data Communication programs
• Development of user specific Dialog & Report programs.
• Module Pool programming - Designing the GUI screen layout and the menu for the necessary screens in the program
• Monitoring table spaces, work processes, backups and system, database, dump & job logs.

Environment: IBM 704 SERVER Pentium Pro 200 MHz, Windows NT 4.0, SAP R/3 Release 3.0f of ABAP/4 Development

Confidential

Oracle DBA

Responsibilities:

• Monitoring the Database, Tablespaces, tables space requirements
• Enrolled users and maintained system security through Roles.
• Management of data through Export, Import.
• Performed Database Backup & restoration
• Fine tuning the database and SQL statements.
• Created the necessary indexes and views.
• Involved in Re-Organization of Database.
• Developed PL/SQL packages for various modules in the application.

Environment: ORACLE 7.3, Developer 2000