Summary:
Highly skilled Oracle EBS Techno Financials Consultant with 3-5 years of experience in designing, developing, and supporting Oracle Financials applications. Specialized in technical solutions (RICEW) for Oracle GL, AP, AR, FA, CM, with deep expertise in PL/SQL, BI Publisher, Interfaces, Conversions, and Workflows. Strong understanding of financial business processes with a proven ability to translate complex requirements into robust Oracle ERP solutions. Oracle GRC (Governance, Risk and Compliance) knowledge is preferred.
CORE COMPETENCIES
Technical:
- Oracle EBS R12/11i (Financials)
- Oracle GRC
- PL/SQL, SQL, Oracle APIs
- RICEW Development
- BI Publisher, Oracle Reports, XML/Excel Templates
- Oracle Forms/Forms Personalization
- Oracle Workflow Builder
- OAF (Oracle Application Framework) - (if applicable)
- Linux Scripting
Key Responsibilities
- Business Process Analysis: Understand client financial & Business processes and gather requirements for Oracle Financials & SCM modules.
- Understand Module Configuration: General Ledger (GL), Accounts Payable (AP), Accounts Receivable (AR), Fixed Assets (FA), Cash Management (CM), GRC
- Documentation: Create MD50s (functional specs for custom development) & MD070.
- Testing & UAT: Design and execute functional test cases, SIT, and support UAT.
- Training & Support: Prepare training materials and provide knowledge transfer to end users.
- Custom Development: Create or assist with RICEW objects (Reports, Interfaces, Conversions, Extensions, Workflows).
- SQL/PLSQL Development: Write and troubleshoot complex SQL and PL/SQL queries for data extraction, validations, and reporting.
- Interface Development: Design interfaces between Oracle and external systems.
- Customization: Collaborate with developers to build customizations using tools like Oracle Forms, Reports, BI Publisher, and Workflow Builder, Linux scripts
- Technical Documentation: Prepare MD70 (technical design docs), support unit testing, and deployment coordination.
Skills Required
Languages & Development
- SQL / PL-SQL - Strong skills in writing queries, procedures, functions, packages, and triggers.
- Oracle APIs - Usage of seeded APIs for data import and transactions.
- Oracle Forms / Forms Personalization.
- Oracle Reports / BI Publisher / XML Publisher.
- Oracle Workflow Builder - Customizing and creating approval workflows.
- Shell Scripting - For automating concurrent program runs or FTP interfaces (optional but useful).
- OAF (Oracle Application Framework) - (Optional, for advanced UI customization).
RICEW Components
- Reports - Custom financial reports (Trial Balance, Aging, etc.)
- Interfaces - Inbound/Outbound interfaces with external systems (e.g., banks, payroll)
- Conversions - Data migration scripts for vendors, customers, assets, etc.
- Extensions - Customizations using APIs, personalization, or OAF
Tools & Utilities
- TOAD / SQL Developer
- Oracle Applications Concurrent Manager
- FND Debug / Debug Log / Trace
- AIM / OUM Documentation - MD50, MD70, TE40
- Oracle Alerts - For email notifications and exceptions
- FNDLOAD, WFLOAD - For migrating setups and workflows
