Oracle Consultant

Job Summary

We are seeking an experienced Oracle Record-to-Report (R2R) Consultant with strong expertise in Oracle Financials, General Ledger, Financial Accounting Hub (FAH), Cash Management, AP, AR, and Fixed Assets. The role requires hands-on experience in financial architecture, accounting configurations, integrations, and troubleshooting.

Key Responsibilities

General Ledger & Financial Architecture

• Configure and maintain COA, Value Sets, KFF/DFF, and Tree Hierarchies.

• Configure Primary/Secondary Ledgers, Reporting Currencies, and Ledger Sets.

• Design and troubleshoot Subledger Accounting (SLA) flows into GL.

• Configure Cross Validation Rules, Data Access Sets, and Segment Value Security.

• Understand impacts of hierarchy changes on reporting and Essbase.

Financial Accounting Hub (FAH)

• Design Account Rules, Mapping Sets, Journal Line Rules, and Description Rules.

• Configure Subledger Accounting Methods (SLAM).

• Define transaction types and source data required for accounting and reporting.

• Configure accounting logic for data received from external and legacy systems.

Cash Management & Banking

• Support Host-to-Host bank integrations using SFTP/PGP.

• Configure automated bank statement processing and reconciliation rules.

• Develop reconciliation logic using Tolerance Rules and Mapping Sets.

• Support cash posting rules and automated sweep/zero-balance processes.

• Knowledge of Oracle Fusion Embedded Banking is preferred.

AP, Payments & Tax

• Experience with Oracle Supplier Portal, IDR, and DocIO.

• Develop payment formats including ISO 20022, NACHA, and SWIFT using BI Publisher/eText/XSL-FO.

• Configure tax regimes, rules, and withholding for cross-border transactions.

Fixed Assets

• Configure Asset Books, Depreciation Methods, and Prorate Conventions.

• Support and troubleshoot FA Mass Additions and AP/Projects integrations.

AR & Collections

• Configure and troubleshoot AutoInvoice processes and interface errors.

• Design validation logic for high-volume billing integrations.

• Configure AutoLockbox transmission formats and receipt matching rules.

Required Skills & Experience

• Strong hands-on experience with Oracle Financials / R2R.

• Expertise in General Ledger, SLA, FAH, Cash Management, AP, AR, and Fixed Assets.

• Strong knowledge of Oracle financial integrations and accounting flows.

• Experience with financial interfaces, banking integrations, payment formats, and reconciliation.

• Strong troubleshooting, documentation, and analytical skills.

• Excellent stakeholder communication and leadership abilities.

• Ability to work independently in a client-facing environment.

• Experience mentoring technical and functional teams.