Oracle ERP Finance Techno Functional Consultant

Oracle Techno Functional Financial Consultant

Must have technical/functional skills technical skills (techno functional) Oracle EBS 12.2 technical - SQL, PL/SQL - Oracle Forms & Reports - OAF (Oracle Application Framework) - Workflow Builder & AME - XML Publisher / BI Publisher - Personalization’s & Extensions - RICEW components (Reports, Interfaces, Conversions, Extensions, Workflows) - API usage for financial modules - Unix shell scripting Mandatory functional skills core functional expertise (finance) Oracle EBS 12.2 financial modules Accounts Payable (AP) Accounts Receivable (AR) General Ledger (GL) Cash Management (CE) Fixed Assets (FA) Subledger Accounting (SLA) E Tax configuration and troubleshooting Period close activities and reconciliation across modules Desirable functional skills Oracle Fusion Cloud Financials - Fusion GL, AP, AR, FA, CM - Fusion Tax - OTBI, BI Publisher, Smart View Additional competencies - Strong understanding of accounting principles (GAAP/IFRS) - Requirement gathering & solution design - Fit gap analysis - UAT support & training - Production support & issue resolution - Knowledge of SOX controls & audit compliance - Agile/Scrum methodology exposure Desirable skills- Oracle Fusion Technical - OTBI & BI Publisher report development - FBDI templates & ADFDI - REST & SOAP Web Services - Integration Cloud (OIC) – mappings, orchestrations, adapters - BIP bursting, scheduling, and data models Reporting & analytics - BI Publisher - OTBI - FRS (Financial Reporting Studio) - Smart View Roles & responsibilities The Oracle techno functional financial consultant will support, enhance, and optimize Oracle E Business Suite (EBS) 12.2 and Oracle Fusion Cloud Financials. This role requires a strong blend of functional finance expertise and hands on technical development skills. The consultant will work closely with business users, finance teams, and IT to deliver solutions across AP, AR, GL, FA, Cash Management, and related financial modules. Functional responsibilities - Lead requirement gathering, fit gap analysis, and solution design for Oracle EBS 12.2 and Fusion Financials. - Configure and support financial modules including AP, AR, GL, FA, CE, and SLA. - Support month end and year end close activities, reconciliations, and financial reporting. - Provide functional expertise for Fusion modules such as GL, AP, AR, FA, CM, and Fusion Tax. - Develop and maintain financial reports using OTBI, BI Publisher, FRS, and Smart View. - Collaborate with finance stakeholders to streamline processes and improve system usage. Technical responsibilities - Develop and support RICEW components (Reports, Interfaces, Conversions, Extensions, Workflows). - Build and maintain PL/SQL packages, Oracle Forms/Reports, OAF pages, and XML/BI Publisher reports. - Support EBS 12.2 online patching (ADOP) and custom code remediation. - Develop Fusion integrations using REST/SOAP APIs, OIC, FBDI, ADFDI, and BIP bursting. - Troubleshoot technical issues across EBS and Fusion environments. - Support data migration activities and third party integrations (banking, procurement, etc.).