ROLE : Oracle Apps EBS SCM Functional Consultant

Key Responsibilities :

- Lead the technical design, development, and implementation of customizations, extensions, interfaces, and reports (RICEW) in Oracle EBS R12.

- Develop and maintain Oracle Forms, Reports (RDF/XML/BI Publisher), PL/SQL packages, and OAF components.

- Collaborate with functional consultants and business users to understand requirements and deliver scalable solutions.

- Create and manage interfaces between Oracle EBS and external systems using APIs, Web Services, and Oracle integration tools.

- Troubleshoot and resolve technical issues related to Oracle EBS modules and custom components.

- Perform performance tuning of PL/SQL code and long-running concurrent programs.

- Participate in impact analysis, patch review, and release management activities.

- Prepare technical design documentation, unit test cases, and deployment guides.

- Guide and mentor junior developers and review technical deliverables.

- Ensure compliance with Oracle best practices and coding standards.

Required Skills & Experience :

- 10 to 15 years of experience as an- Oracle Apps EBS Technical Consultant.

- Expertise in- Oracle Forms, Reports, PL/SQL, SQL, BI Publisher, OAF, and Workflow Builder.

- Strong understanding of- Oracle EBS data models and standard APIs.

- Experience with RICEW components across modules like- Financials (AP, AR, GL, FA), SCM (PO, OM, INV), and HRMS.

- Experience in- data conversion, interface development, and- custom integration.

- Exposure to- code migration tools, patch analysis, and version control systems.

- Excellent analytical, troubleshooting, and debugging skills.

- Strong documentation, communication, and stakeholder interaction abilities.

Preferred Skills :

- Exposure to- Oracle Cloud (Fusion)- or experience with migration from EBS to Cloud.

- Familiarity with- SOA Suite, Oracle Integration Cloud (OIC), or web services development.

- Working knowledge of- Agile/DevOps methodologies.

- Oracle EBS Certification is a plus.

Educational Qualification :

- Bachelor's or Master's degree in- Computer Science, Information Technology, or related field.

- Relevant Oracle certifications (e.g., OCP - EBS R12) preferred.