Oracle R2R Consultant Job New York New York USA,IT/Tech

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 Auto Invoice processes and interface errors.
Design validation logic for high-volume billing integrations.
Configure Auto Lockbox 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.