Senior Oracle Application Technical Consultant with over 10 years of experience in software development, database development & administration, and operational IT.
Hands-on Experience in developing RICEW components using SQL, PL/SQL, Oracle Reports (RDF), XML Publisher (RTF), Oracle Forms, Oracle Application Framework OAF, Oracle Workflows, SQL*Loader, Data Conversion, Data Migration, Oracle standard API's and Developing Interfaces within several modules in Oracle Applications EBS R12. Proficient experience in Oracle Financials, SCM Modules - General Ledger, Accounts Payables, Accounts Receivables, Fixed Assets, Purchasing, Inventory.
Strong knowledge of Application Object Library (AOL) implementation standards, Application Implementation Methodology (AIM), Trading Community Architecture (TCA), and software Development Life Cycle (SDLC). Expertise in designing and implementing Oracle Alerts, Lookups, Personalization, Customization, and extension. Extensively worked on Oracle PL/SQL Development - Packages, Stored Procedures, Functions, Anonymous Procedures, and Triggers, effectively used Indexes, Collections, Materialized views, Analytical Functions, Database tables, and Schemas. Expert in Oracle Performance Tuning using Gather Stats, TK Prof, Explain Plan, Hints, SQL Trace. Expertise in Oracle Application Express Apex. Hands-on Experience in database cloning, patching, maintenance, administration, and technical support. Experience in customization, upgrade of Oracle E-Business Suite.