Oracle functional consultant

Experience

10+ years (Oracle EBS R12 Techno-Functional).

Technical – 80% and Functional – 20%.

Role Summary:

EBS Finance Modules: AR, AP and GL. Experience in RICE Components and developing Interface scripts. Proficient in Procure to Pay (P2 P) Business flows and O2 C cycle rules in Oracle Applications. Proficient in handling Interfaces, API's, Forms Personalization, XML Publisher, Reports, Stored procedures and Triggers in Oracle Apps R12. Strong experience in EBS Technical Senior Developer with hands-on experience in Oracle database development. Strong experience in Migration, Implementation, Upgrade and End-to-End Development project. Good Communication and Leadership skills are must. Work closely with Customer Leads and Project planning execution. Fair IBM Data Stage knowledge is added advantage.

Key Responsibilities

Oracle EBS Technical (Primary – 80%)

Design, develop, and maintain Oracle PL/SQL packages, procedures, functions, and triggers. Alert Manager, Interfaces, APIs, Web ADI, SQL*Loader, Shell scripting. Oracle - Database Migration, Packages, triggers, procedures, forms. Write and optimize complex SQL queries for large-volume data processing Perform performance tuning using explain plans, indexes, and statistics Handle data validation, reconciliation, and exception handling.

Oracle EBS Functional (Secondary – 20%)

• EBS Finance Modules: AR, AP and GL.