Roles & Responsibilities
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), GRCDocumentation : 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 scriptsTechnical 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 OAFTools & Utilities
TOAD / SQL DeveloperOracle Applications Concurrent ManagerFND Debug / Debug Log / TraceAIM / OUM Documentation – MD50, MD70, TE40Oracle Alerts – For email notifications and exceptionsFNDLOAD, WFLOAD – For migrating setups and workflowsTell employers what skills you have
Technical Documentation
UAT
Oracle
XML
ERP
Unit Testing
Financials
Scripting
Test Cases
SQL
Data Migration
Oracle Reports
Linux
Oracle Workflow
Technical Design