Oracle Functional Consultant

Topcoder · India

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 (P2P) Business flows and O2C 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 DataStage 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.