Oracle Record to Report (R2R) Consultant

Oracle Record to Report (R2R) Consultant
Location: Broadway, NY -Remote Role
Contract:

Job Description:
Mandatory Skills:
1.General Ledger (GL) & Financial Architecture
Hierarchies & COA: Hands-on experience designing and maintaining Value Sets, Flexfield 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.
2.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.
3.Cash Management & Banking
Bank Integration (Host-to-Host): Technical mastery of the bank transmission and secure file transmission (SFTP/PGP) for automated statement retrieval.