POSITION NAME - Oracle Record to Report (R2R) Consultant

Location : NEW YORK , NY

Duration ; 1 year Contract

Oracle EBS - Finance, Oracle SaaS Accounting Hub (AHCS)

General Ledger (GL) & Financial Architecture

Hierarchies & COA: Hands-on experience designing and maintaining Value Sets, Flex field structures (KFF/DFF), and Tree Hierarchies.

Must be able to manage the impact of hierarchy changes on reporting cubes (Essbase).

Ledger Engineering: Expertise in configuring Primary/Secondary Ledgers, Reporting Currencies, and Ledger Sets.

Must understand the technical logic behind "Subledger Accounting" (SLA) to customize how data flows from AP/AR/CM/PPM into the GL.

Expertise in configuring cross validation rules, data access sets, segment value security

Financial Accounting Hub (FAH)

Account Rules & Mapping Sets:

Designing rules to dynamically derive Chart of Accounts (COA) segments based on source data attributes, Defining journal line and description rules.

Subledger Accounting Methods (SLAM): Grouping all rules together into a cohesive accounting method assigned to the ledger.

Transaction Types: Identifying and categorizing the different business events coming from the legacy system.

Source Data Definition:

Defining the header and line-level data elements (sources) that need to be captured from the external system to drive accounting rules and reporting.

Cash Management & Banking

Bank Integration (Host-to-Host): Technical mastery of the bank transmission and secure file transmission (SFTP/PGP) for automated statement retrieval.

Reconciliation Engines: Expert knowledge of Manual and Automated Reconciliation Rule Sets, including the use of "Tolerance Rules" and "Mapping Sets" to handle high-volume bank statement lines.

External Transactions: Ability to develop automated "sweep" or "zero-balance" technical logic for global liquidity management.

Embedded banking: Knowledge of embedded banking feature in Fusion Cash Management.

Configuration and maintenance of cash posting rules.

Excellent communication and stakeholder management skills

Ability to work independently in an onsite client facing environment

Strong documentation and presentation skills

Proven leadership and mentoring capabilities