Job opening
Oracle Record to Report (R2R) Consultant
Filed under IT Services and IT Consulting
Full job description
Oracle Record to Report (R2R) Consultant
Location – NYC, NY
Work Mode – Hybrid – 3days from Client Office
Client – LTM
Duration – 6 Months
Skills
Mandatory Skills : Oracle EBS - Finance
Job description
Mandatory Skills:
- 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.
Soft Skills
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