Role: Oracle Retail RMS Techno-Functional Consultant
Project Duration: 4 Months
Location: Remote
Job Overview:
We are seeking experienced Oracle Retail RMS (Retail Merchandising System) techno-functional consultants to deliver a set of client change requests (CRs) across a 4-month engagement. The team will be responsible for addressing critical business requirements related to costing, invoice reconciliation, automated reporting, and integration improvements between Oracle RMS, EBS (Oracle Financials), and other downstream systems.
Key Responsibilities:
• Techno-Functional Development & Support:
• Analyze business requirements and design system enhancements within Oracle Retail RMS.
• Configure, customize, and develop technical solutions to address client change requests.
• Work on costing visibility, vendor invoicing, reconciliation automation, and shipment tracking improvements.
• Integration & Data Flow Management:
• Improve and develop data exchange mechanisms between RMS and EBS (Oracle Financials).
• Address issues related to vendor codes, invoice numbers, and UNR (Unapplied Receipt) mismatches.
• Work on automation of forex gain/loss reconciliation entries and manual reconciliation minimization.
• Functional Analysis & Business Impact Mapping:
• Collaborate with business teams to ensure RMS changes align with financial and operational workflows.
• Troubleshoot and resolve issues related to shipment cost tracking, invoice validation, and supplier payment processing.
• Implement best practices in automated financial reporting and reconciliation tracking.
• Reporting & Data Analytics:
• Develop automated SMR (Shipment Matching Report) generation to improve reconciliation cycles.
• Work on financial data transformation from RMS to EBS and related reporting tools.
Required Skills & Experience:
• 5+ years of experience in Oracle Retail RMS (Retail Merchandising System).
• Strong understanding of Oracle RMS module workflows, costing structures, invoice management, and financial integrations.
• Hands-on expertise in PL/SQL, Oracle Forms, BI Publisher, and integration tools (SOA, ODI, or similar middleware).
• Experience in EBS Financials integration with RMS, specifically in AP (Accounts Payable), GL (General Ledger), and UNR reconciliation.
• Good understanding of shipment cost visibility, vendor invoicing, forex adjustments, and payment reconciliation processes.
• Strong problem-solving skills with the ability to analyze large datasets and debug complex system issues.
• Ability to work closely with business users, finance teams, and IT leadership to align solutions with organizational goals.
• Exposure to reporting automation, SQL-based financial reconciliation reports, and process optimization strategies.
• Excellent communication skills with the ability to work in a client-facing, fast-paced environment.