EXPERIENCE SUMMARY

• Over sixteen years of systems analysis, designing, development, maintenance, implementation, Database Administration experience in Oracle based ERP and Datawarehouse systems
• Good understanding of Oracle Applications implementation methodology (AIM)
• Around 15 years of experience in Oracle Applications 10.7NCA, 11i and R12 (11.5.4/11.5.7/11.5.9/11.5.10.2/12 - 12.1.3) installations, upgrade, implementation, customizations and System & Database Administration
• Worked on Oracle Applications(10.7, 11i and R12) HRMS, Financials, Distribution, Manufacturing, ASCP, CRM Modules & Embedded Data Warehouse (EDW)
• Worked on Oracle 9i / 10g RAC( Real Applications Clusters) with E-Business suite 11.5.9/1.5.10 and Parallel Concurrent Processing (PCP) Configuration
• Well experienced with Oracle E-Business Suite advanced configurations like Oracle HTTP Server with DNS & Cisco Load balancer, Forms Load Balancing, Jserv Load balancing etc.
• Well experienced with Oracle E-Bsuness suite Security, Advanced secrurity options(ASO), SSL Configurations
• Well versed with Oracle E-Business suite Integrated SOA Gateway,Fusion Middleware, Oracle BPEL integration with Oracle E-Business suite.
• Well experienced with Oracle 9i / 10g R2 RAC on Sun Solaris, AIX and RedHat Linux
• Well versed with PMP, Agile, Scrum, ITIL methodologies
• Configuration of Oracle Applications 11i with Oracle Portal 3.0.9 & OID, SSO
• Configuration of Business Intelligence systems With Oracle Applications 11i
• Well Experienced with upgrading Oracle Applications 10.7NCA to Oracle Application 11i(11.5.5),11.5.4 to 11.5.9 and 11.5.8 to 11.5.10.2, 11.5.10.2 to Rel 12.
• Worked Oracle Application Database performance Tuning
• Working knowledge of Oracle E-business suite Multi language support (MLS) and Installation
• Good knowledge of functional aspects of Oracle applications GL, AP, AR, OM, INV, PO modules
• Holding Oracle certification in Oracle 8, 8i, 9i & 10g Database administration
• Worked on Large Oracle dabases ( 300GB to 1 TB)
• Well versed with Oracle High Availability Solutions( Standby database in Oracle 8i and Data Guard in Oracle 9i) for E-Business Suite and Standalone Oracle Database
• Well versed with Global database standards, SQL, Export/Import, SQL*Loader, PL/Sql Development, Shell Scripts, and User management
• Extensive experience in the database design, capacity planning, administration of Oracle Database, Backup and Recovery, SQL Tuning, Disaster Recovery, Installation of Oracle Software, Oracle 9iAS portal v1.0.2.2, RMAN, Netbackup
• Logical and physical database design for Datawarehousing and used ETL tools
• Requirements gathering & analysis.
• Project co-ordination
• Worked for two of the big 5 consulting firms Oracle Consulting Services and IBM Global Services.
• Well experienced with Oracle Business Intelligence 11.1.1.1.5

TECHNICAL SKILLS

Industry Knowledge: Finance, Banking, Transportation, Software, Manufacturing, Supplychain/Distribution, ASP,Healthcare, Pharmacuiticals, Aviation, TourismProject Methodologies: PMP, Agile, Scrum, ITIL, SDLC

ERP: Oracle E-Business Suite Rel 12(12.0.4&12.1.3), 11i(11.5.10.2), 11.0.3, 10.7 NCA (HRMS,Financial, Distribution, Manufacturing & CRM Modules, DBI/BIS & Portals, SSO, OID)

Datawarehouse: OBIEE

Application Servers: Oracle Application Server 4.0.8.1/ 9iAS / 10g, Fusion Middleware

Databases: Oracle 7X, 8X, 9X, 10g & 11g SQL server7/2000

Programming Languages: C, SQL, PL / SQL, Shell Script, JAVA

Operating Systems: MS-WINDOWS, UNIX (Sun Sloaris, AIX, HP), NT/2000 and Red Hat Linux 3.0 /4.0

Front-end Tools: Developer 2000, Forms 6i, Reports 6i and Discoverer 4.x / 10g, SQR Reports

DBA Tools: Oracle Enterprise Manager, OAM, TOAD,Export & Import, SQL Loader,RMAN,STATSPACK

ETL Tools: Tapestry/Informatica, Data Stage

Other Tools: SQL*Loader, Erwin,Designer 2000, NetBackup, VisioM

PROFESSIONAL EXPERIENCE

Confidential

Sr. Oracle Applications DBA

Responsibilities:

• Configurations of Oracle Database 11gR2 Two node RAC databses on Oracle Exadata V3- Quarter Rac
• Migrating Oracle EBS 12.1.1 database 11.1.7 to Oracle Exadata from AIX by following Export and Import procedures
• Migrating Oracle EBS 12.1.3 Applications to Oracle Exalogic
• Configured Oracle EBS database to Two Node RAC
• Applied Oracle Exadata Patches - Bundled patches, QUPD
• Application of Oracle EBS Patches - PSU, RPC, End of the year HR and Payroll Patches.
• Supporting funcational, Techical teams working on defferent Oracle EBS 12.1.1 moduels
• Upgrading Oracle EBS 12.1.1 to 12.1.3

Confidential

Sr. Oracle Applications DBA

Responsibilities:

• Installation of Oracle EBS R12(12.1.3)
• Upgrade Oracle EBS 11.5.10.2 to R12(12.1.3)
• Requirements analysis, design and implementation of upgrade strategy
• Worked with functional consultants(SME’s), Technical consultants and Customer project manager and Functional Team Leads
• Configured two Node RAC databases running on Oracle Exadadata Server
• Configured 6 Web Nodes: Two for Internal, Two for iRecruitment(VMWare) and Two for iSupplier portal
• Paralllel Concurrent processing, SSL, DMZ and Reverse Proxy configurations
• External Discoverer configuration

Oracle EBS 11.5.10.2 Implementation

Confidential

Responsibilities:

• Installation and Configuration of Oracle E-business Suite 12/11.5.10.2(Financials, Distribution and HRMS - Human Resource, Payroll, Time and Labour and Advanced benefits, iRecruitment)
• Installation and configuration of Oracle 10g R2 RAC on AIX
• Configured multiple(3) web nodes( 2 for internal and 1 for external) for HA by following, Hwardware (F5 – BigIP) DNS, and Jserv Load Balancing methods
• Configuring Parallel concurrent processing (PCP)
• Design and implementation of Change / configuration management process for Oracle E-Business suite implementation
• Upgrading Oracle Applications database from 10.1.0.4 to 10.2.0.2, 10.2.0.3 to 10.2.0.3, 10.2.0.3 to 11gR2
• Enabled SSL with Oracle E-Business Suite 11.5.10.2
• Configuration of Workflow Notification Mailer, OAM, OEM10g
• Installation and configuration of Oracle Discoverer 10g with Oracle EBS
• Installation and configuration of Oracle 11gR2 Grid Infrastructure, Oracle 11gR2 ASM
• Established Oracle E-Business Suite Chamge Management Processes
• Designed and implemented Monthly, Quarterly, End of the Year patching process for Oracle E-Business suite
• Applying Oracle Applications patches (Maintenance Pack, Interoperability patch,Family pack, one of Patches etc)
• Cloning Oracle Applications Production system for Testing and UAT and Devlopment purpose, using RAPID clone
• Oracle Applications Systems Administration
• Working with Functional, Technical consultants and end users in code promotions, setups & resolving various issues during implementation.
• Implementing partitioning for workflow and other large tables
• Capacity planning for PROD, TEST, DEV and patching instances for E-Business Suite
• Cordinating with Developers & Testers in various phases of SDLC
• Maintenance of Oracle Applications through Autoconfig.
• Automating Day-to-day database and Oracle Apps maintenance tasks like checking alert logs, analyzing tables, space mgt. and purging some of FND tables etc.
• Interacting with Oracle Customer Support and logging iTAR as and when required
• Patching security vulnerabilities as and when released by Oracle Support
• Patching quarterly Payroll & HR patches.
• Lead team of 5 DBA’s

Environment: Oracle Exadata V2 – Quarter RAC, Oracle E-Business suite Rel 12(12.1.2/3), 11.5.10.2 (Financials, Distribution & HRMS Modules) Oracle 11g & 10g R1/2, Oracle 10g R2 Real Application Clusters, ASM, Oracle Applications Server 10g, Oracle Fusion Middleware, Oracle BPEL, Oracle Forms 6i, Oracle Reports 6i, RMAN & Legato Networker, AIX 5L, RedHat Linux, HP Storage, VM Ware. Oracle Business Intelligecne 11.1.1.5