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

Work arrangement
Yes