Product Consultant -Oracle Retail Solutions

Job description

Oracle Retail Technical Consultant Must Have Technical/Functional Skills

• 15+ years of hands-on experience supporting Oracle Retail RMS (v14.x, v16.x, or later).
• Strong understanding of retail merchandising processes —
• Item setup, purchasing, pricing, inventory, and invoice reconciliation.
• Experience with SQL and PL/SQL for data analysis, debugging, and fixes.
• Familiarity with Unix/Linux environments for job monitoring and log analysis.
• Working knowledge of Oracle integration technologies (SOA, OIC, flat files, or API-based).
• Experience using ITSM tools (ServiceNow, Jira, Remedy) for incident and change management.
• Excellent analytical, documentation, and problem-solving skills. Core Modules Supported

RMS (Retail Merchandising System)

• Item, supplier, cost, and purchase order management.

RPM (Retail Price Management)

• Pricing, promotions, and markdowns.

ReIM (Retail Invoice Matching)

• Invoice matching and cost reconciliation.

ReSA (Retail Sales Audit)

• POS data validation and store-level reconciliations.

Allocation / RWMS / SIM

• Stock movement, allocation, and replenishment processes.

Roles & Responsibilities

• Provide L2/L3 support for Oracle RMS and its integrated suite (RPM, ReIM, ReSA, Allocation, RWMS, SIM).
• Investigate, troubleshoot, and resolve production issues related to
• Item setup, purchase orders, inventory, and cost discrepancies.
• Perform root cause analysis (RCA) for recurring issues and implement preventive actions.
• Support daily and periodic batch processes, EOD (End-of-Day), and EOW (End-of-Week) cycles.
• Ensure accuracy and consistency of data flow between RMS and other systems (POS, Finance, Warehouse, etc.).
• Monitor interface jobs and data transfers, identifying and resolving failures in integration layers (SOA, OIC, flat files, etc.).
• Coordinate with vendors (Oracle Support, integration partners) for product defects, patches, or upgrades.
• Maintain configuration parameters and system setups across RMS modules.
• Manage data correction scripts, SQL fixes, and mass data updates in coordination with DBAs.
• Support patch deployments, upgrades, and functional testing.
• Maintain documentation of configurations, data mappings, and system interfaces.
• Participate in change requests, release management, and deployment activities.
• Conduct functional, regression, and integration testing for new releases and patches.
• Collaborate with business teams to validate system fixes and enhancements in UAT environments.
• Ensure all system changes follow IT governance and audit standards.
• Partner with Merchandising, Finance, Supply Chain, and IT Operations teams
• to identify and resolve business process issues.
• Provide data analysis and reporting support using SQL queries or standard RMS reports.
• Train and guide L1 support and business users on common troubleshooting techniques.
• Document known issues, workarounds, and SOPs to enhance team efficiency.

Education

Bachelors (B.E) Salary Range: $120000 - $175000 a year #LI-JH1 </div

Qualifications

BACHELOR OF COMPUTER SCIENCE