Overview
Work history
Education
Skills
Personal Information
Custom
Timeline
Generic

TURBAN MAHAPATRA

Overview

16
16
years of professional experience
3
3
years of post-secondary education

Work history

ORACLE RETAIL CONSULTANT

QUICKBORN CONSULTING
200 Silverside Road, Wilmington
06.2023 - Current
  • Working as Oracle Retail Suite Developer of the below mentioned applications: -
  • RMFCS/RMS
  • Design & Developed PO workflow E2E with 3PL.
  • Design & Developed Transfer Order workflow E2E with 3PL.
  • Worked in Oracle Retail customizations for RMFCS outbound in DAS.
  • Designed, developed, and deployed integration solutions using Oracle Integration Cloud (OIC) to streamline business processes and enhance data exchange between Oracle Retail (SaaS) and other Oracle E-business Cloud (Finance, HCM)
  • Actively overseeing and providing hyper care support as L3.
  • Worked in Oracle Retail customizations for RMFCS outbound in DAS.

MANAGER: ORACLE RETAIL TECHNO-FUNCTIONAL CONSULTANT

KPMG LLC
02.2023 - 03.2024
  • RMS
  • Worked with business on fixing various foundation & transactional data issues
  • Stock counts.
  • Oracle RMS-RPM & RIB Integration issues and re-design.
  • Worked in design and development of RMS with ReSA integration generating RTLOG files both of intra-day and EOD sales transactions.

SENIOR CONSULTANT: ORACLE RETAIL TECHNO-FUNCTIONAL CONSULTANT

CAPGEMINI
04.2021 - 02.2023
  • Working as Oracle Retail Suite Developer of the below mentioned applications: -
  • RPM
  • Design & Developed Regular Pricing Changes from RPM to Downstream apps E2E flow.
  • Design & Developed Clearance/promotional Pricing Changes from RPM to Downstream apps E2E flow
  • Design & Developed Price Zone location flow from RPM to Downstream apps E2E.
  • Developed complex package for Custom Conflict Check automation program by adding new custom rules for both active and future promotion.
  • Design & Developed & Migrated historical item price data to RPM
  • RMFCS/RMS
  • Design & Developed PO workflow E2E with 3PL.
  • Developed CO integrations between Sterling OMS and RMS various Apps.
  • Design and developed RTLOG file generation via OIC with Retail sales Audit cloud service.

PACKAGE SOLUTION CONSULTANT: ORACLE RETAIL

IBM INDIA
02.2016 - 04.2021
  • RMS
  • Design & Development of below interfaces in RMS both in on-premise & Oracle Retail SAAS App: -
  • RMS Foundation data
  • RMS Transactional
  • Purchase Order
  • Transfers
  • Shipments
  • Receipts
  • Inventory Adjustment
  • RTV

PROJECT ASSOCIATE: ORACLE RETAIL

COGNIZANT TECHNOLOGY SERVICES INDIA
06.2014 - 01.2016
  • Monitoring daily batches maintained in Approx
  • And took actions for any batch failure.
  • Resolving and raising SR to Oracle Support whenever required and active participation in problem solving.
  • Maintaining day to day records of duration of scheduled batches ran which will help

APPLICATION DEVELOPER: ORACLE RETAIL

IBM INDIA
08.2008 - 05.2014
  • Developing & customizing application interfaces for integration and migration between Oracle Retail applications for e.g
  • RMS 16, RPM 14, RIB 119,16,13.2 ALLOCATION and legacy applications as and when directed.

Education

Master of Computer Applications - COMPUTER APPLICATIONS

WEST BENGAL UNIVERSITY OF TECHNOLOGY
INDIA
08.2004 - 08.2007

Skills

  • Oracle Retail SaaS/On-premises Modules:

RMFCS/RMS(FOUNDATION ,TRANSACTIONAL)

RTV

RPM -

RIB/RICS -

ReSA –

Language Proficiency

Oracle PL/SQL, TERADATA

Pro C, Unix Shell Script

Oracle Integration Cloud (OIC)

Core Java, Web Services development

Testing Tools: -

SoapUI - End to End testing with SOAP web services & REST

Java - Rest/GraphQL API (Selenium/Cucumber Framework)

Personal Information

Title: Oracle Retail Techo-Func Consultant: RMFCS/RMS (v13.2, v15, v16, v19, v23)

Custom

  • POUNDLAND STOCK PROJECT, Project Description: Poundland has heterogeneous middleware architecture. They are keen to normalize the process by decommissioning some legacy applications and making Oracle Retail (RMFCS) as a master data of all., My sole responsibility was to study their Enterprise architecture and come up with various interfaces and prepare an Integration & Functional design document., My responsibility also covers to evaluate various test case scenarios and help the developers to identify the same., Position: Oracle Retail Integration Consultant: RMFCS, RICS, RPFCS, Contribution:, As of now I have designed 15 functional interfaces covering from Oracle Retail Foundation to Transactional., I was involved in coordinating for various integrations happening between Oracle retail and legacy applications and played pivotal role to derive an implement the same.
  • RMS 2B.1 MERCHANDISING IMPL PROJECT, Project Description: Integration with Oracle Retail v10 suite of products with Oracle Retail v16 merchandising., Position: Senior Developer: RMS-RIB Integration, Contribution:, I was solely responsible to develop custom middleware application to transform, filter and validate SOAP based xml files from RIBv11 to RIBv16 format via web services.
  • MYER AMS PROJECT, Project Description: RDW Enhancement, Incidents and SRs, RIB Administration, Position: Senior Consultant: RMS:RIB:RPM, Contribution:, RDW Enhancement, Incidents and SRs, RIB Administration, RIB Administration., Resolving RIB, RMS,RDW Incidents and SRs as when required.
  • NEW LOOK FOUNDATION ATLAS PROJECT, Project Description: Custom Conflict Check enhancement, Position: Senior Consultant:v RMS:RIB:RPM, Contribution:, Custom Conflict Check Enhancement along with Unit and Functional Testing., RPM Report Development and Support, RIB Administration with Fusion Middleware.
  • GYM APPS PROJECT, Project Description: Oracle RMS, RPM, RIB support personal, Contribution: RMS, RIB CUSTOMIZATION & ADMINISTRATION, This retail organization has a very deep-rooted issue from the very beginning in handling item and PO outbound interfaces and data flow. Item and PO data (New, Edit, and Delete) are handled by the same eway adapter. As a result, lot of the messages gets stuck in RIB hospital tables due to this basic nature issue., Currently, I am solely responsible for design and implementation both for RMS and RIB perspective to separate item and PO outbound interfaces., I am also responsible for handling Failure message automation in RMS-RIB & RDM- RIB., I am also responsible to analyze various message failures and inform the same to various business stake holders.
  • BELK SMART PROJECT, Project Description: System Integration Testing of RMS, RIB, RWMS with Mainframe, Position: System Integration Testing Lead of RMS, RIB, RWMS with Mainframe, Contribution:, I was solely responsible for Integration Test Lead of Belk PO Testing and support along with other RMS-Rib Interfaces., I was also responsible for testing of different segments of ORA (Allocation).
  • ORACLE RMS TRANSACTION DATA PROJECT, Project Description: Implementation of Oracle Retail ERP integration with External and Legacy Applications., Position: Senior Consultant: RMS, RPM, RIB, Contribution:, RIB Installation, administration and support, RMS-RIB Integration, Complex item interface among various, Design and Integration Lead for PO Outbound and Inbound., Hyper Care activities of RMS and RIB support.
  • PROJECT EVOLUTION, Project Description: PIM Integration with Oracle Retail suite of products, Position: Application Developer: RMS,RIB,RPM, Contribution: For Release 1, main concentration of this project was the integration between PIM and RMS via RIB., RMS MODULE, I was solely responsible to develop interfaces in publishing consignment item to Legacy Applications (Pro
  • C)., I am also customizing and developing packages for Extensions, Conversions and other Interfaces., RIB CUSTOMIZATION & ADMINISTRATION, Basically in this project, items are needed to be created in PIM, so reaching supplier/ supplier site data to PIM was very important. Here I have customized and developed triggers and also customized XSD so that RMS can talk smoothly with FMW., I am also acting as SPOC for successful integration between RMS, PIM and Legacy Applications both inbound and outbound for Foundation and Advanced RMS module for current release., I am also responsible for installation, support and giving solution to any RIB related issues.
  • THE KROGER MERCURY PROJECT, Project Description: Implementation of RMS, RPM, RESA, REIM modules along with smooth integration with other external legacy application and TIBCO PIM., Position: Application Developer: RMS, RIB, Contribution:, I was solely responsible in writing UNIT test cases for successful Merchandise Hierarchy and Merchandise Hierarchy Reclassification Test cases and also testing them through RDMT for successful message delivery from RIB to RMS., I have also written PL/SQL Package for successful delivery of flex messages from RIB to RMS. for Merchandise Hierarchy & Merchandise Hierarchy Reclassification, I also designed and built interface based on Pro
  • C on TAX data coming from CIM., I have also designed and coded Sales Upload History interface where data/FLAT Files would be coming from EDW which will be in sync with RMS. This will help the client in replenishment and allocation of items., In KROGER Allocation Releasing process is performed by the Releasing business team, after all allocations linked to an Event are Approved by the Approval business team. Releasing process, flow is only performed on what-if allocations. (Standard ‘push’ allocations are Approved within, the Oracle Allocation tool itself and is then fed straight to KROGER’s downstream system.
  • PROJECT, Project Description: PIM Integration with Oracle Retail suite of products, Position: Application Developer: RMS,RIB,RPM, Contribution: For Release 1, main concentration of this project was the integration between PIM and RMS via RIB., RMS MODULE, I was solely responsible to develop interfaces in publishing consignment item to Legacy Applications (Pro
  • THE SOURCE ORACLE RETAIL IMPLEMENTATION PROJECT, Project Description: Implementation project to focus on RMS, RPM ,retail modules on MOM 13.2, Position: Application Developer: Oracle Retail, Contribution:, RMS,RPM Integration (As RIB was not deployed, total integration was based on Developing Pro
  • C interfaces to talk with Legacy Applications), Developing Unix Shell Script for house clean activities.

Timeline

ORACLE RETAIL CONSULTANT

QUICKBORN CONSULTING
06.2023 - Current

MANAGER: ORACLE RETAIL TECHNO-FUNCTIONAL CONSULTANT

KPMG LLC
02.2023 - 03.2024

SENIOR CONSULTANT: ORACLE RETAIL TECHNO-FUNCTIONAL CONSULTANT

CAPGEMINI
04.2021 - 02.2023

PACKAGE SOLUTION CONSULTANT: ORACLE RETAIL

IBM INDIA
02.2016 - 04.2021

PROJECT ASSOCIATE: ORACLE RETAIL

COGNIZANT TECHNOLOGY SERVICES INDIA
06.2014 - 01.2016

APPLICATION DEVELOPER: ORACLE RETAIL

IBM INDIA
08.2008 - 05.2014

Master of Computer Applications - COMPUTER APPLICATIONS

WEST BENGAL UNIVERSITY OF TECHNOLOGY
08.2004 - 08.2007
TURBAN MAHAPATRA