Job Description
The Principal Consultant (Oracle E-Business Suite) is responsible for leading Oracle EBS technical consulting, development, customization, client engagement, and production support across SCM, Financials, and Manufacturing modules. The role requires extensive experience in Oracle development tools, RICE components, reporting, documentation, and enterprise support processes.
Key Responsibilities
Oracle EBS Development
- Develop and customize Oracle E-Business Suite applications.
- Design, develop, and maintain RICE components (Reports, Interfaces, Conversions, Extensions).
- Create and customize Oracle Forms and Forms Personalization.
- Develop Oracle Application Framework (OAF) solutions.
- Build Oracle Workflow solutions.
- Develop Interfaces and Data Conversions.
- Create Oracle Reports and XML Publisher Reports.
- Develop and maintain Discoverer Reports.
Database Development
- Write complex SQL queries.
- Develop PL/SQL procedures, packages, functions, and triggers.
- Optimize SQL and PL/SQL performance.
- Support database development activities.
Functional Modules
Work across Oracle EBS modules including:
- SCM
- Order Management (OM)
- Inventory (INV)
- Purchasing (PO)
- Financials
- Accounts Payable (AP)
- Accounts Receivable (AR)
- General Ledger (GL)
- Manufacturing
- Work In Process (WIP)
- Bill of Materials (BOM)
Documentation
- Prepare MD070 Technical Design documents.
- Prepare MD120 Technical Specification documents.
- Create and maintain AIM documentation.
- Produce technical design and implementation documents.
Client & Consulting
- Interact with business users and clients.
- Lead technical discussions and solution workshops.
- Gather requirements.
- Provide technical consulting and solution design.
- Support implementation and production issues.
Support & Governance
- Work on Development and Support projects.
- Follow ITIL processes.
- Handle incident management and change requests.
- Ensure best practices and documentation standards.
Required Technical Skills
Oracle EBS
- Oracle EBS 11i
- Oracle EBS R12.1.x
- Oracle EBS R12.2.x
Oracle Development
- SQL
- PL/SQL
- Oracle Forms
- Oracle Reports
- XML Publisher
- Oracle Workflow
- Oracle Application Framework (OAF)
- Forms Personalization
- Interfaces
- Conversions
- Discoverer Reports
Oracle Modules
Supply Chain Management (SCM)
- Order Management (OM)
- Inventory (INV)
- Purchasing (PO)
Financials
- Accounts Payable (AP)
- Accounts Receivable (AR)
- General Ledger (GL)
Manufacturing
- Work In Process (WIP)
- Bill of Materials (BOM)
Programming & Scripting
- SQL
- PL/SQL
- Shell Scripting (preferred)
- Python Scripting (preferred)
Documentation & Methodology
- MD070
- MD120
- AIM Documentation
- ITIL Framework
Soft Skills
- Client Management
- Technical Consulting
- Leadership
- Technical Discussion & Presentation
- Communication Skills
- Problem Solving
- Analytical Thinking
- Documentation Skills
- Stakeholder Management
- Team Collaboration
Keywords
Oracle EBS, Oracle E-Business Suite, Oracle 11i, Oracle R12, Oracle SCM, Oracle Financials, Oracle Manufacturing, OM, INV, PO, AP, AR, GL, WIP, BOM, Oracle Development, SQL, PL/SQL, Oracle Forms, Oracle Reports, XML Publisher, OAF, Oracle Workflow, Forms Personalization, Discoverer Reports, RICE Components, Reports, Interfaces, Conversions, Extensions, Shell Scripting, Python Scripting, MD070, MD120, AIM Documentation, ITIL, Client Management, Principal Consultant, Technical Consulting.