Oracle Record Report R R Consultant

Oracle Record to Report (R2R) Consultant
New york city,NY(3 Days Onsite)
Contract-6 Months+

Job Description - Must have and good to have skills
Mandatory Skills:
12 -15 year of experience
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.
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.

Other Skills:
Payables (AP) & Payments
PTP: Experience in Oracle Supplier Portal, IDR or DocIO for vendor onboarding and invoice processing
Payment File Formatting: Hands-on development of ISO 20022, NACHA, and SWIFT payment templates using BI Publisher (eText/XSL-FO) to facilitate direct integration with global banks.
Tax & Withholding: Technical configuration of tax engines, including tax rules, regimes, and automated tax calculation logic for cross-border transactions.

Fixed Assets (FA)
Asset Lifecycle Automation: Technical expertise in configuring Asset Books (Corporate/Tax), Depreciation Methods (STL, DB), and Prorate Conventions.
Mass Additions Logic: Hands-on experience with the FA Mass Additions process, specifically troubleshooting the technical interface between AP/Projects and the FA module.

Accounts Receivable (AR) & Collections
Auto-Invoice Architecture: Mastery of the Auto-Invoice Master Program; must be able to debug interface table errors and design custom validation logic for high-volume billing imports from external CRMs (e.g., Salesforce).
Lockbox & Receipt Processing: Experience designing and building Auto-Lockbox transmission formats and "Auto-Match" rule sets for high-accuracy receipt application.