The Client is an American retail chain specializing in counterculture-related clothing and accessories, as well as licensed music. The company provides music-inspired accessory destinations for both guys and girls by online and offline modes.
They offer band-related apparel and accessories, licensed merchandise, and fashion apparel and accessories, which can be found at more than 600 stores.
The day-to-day activities of a retail company typically involve distribution, purchase, cost, inventory, sales and stock planning management. Hence, the client managed huge data for its large number of items and high volume of inventory across the 600 retail stores. Managing those datum manually was the biggest challenge which resulted in shortcomings like:
The retail IT landscape mainly comprises of different systems like stores, warehouses, remote workers, head office data, that needed to be internally and externally integrated together in a way so that they can communicate and interact smoothly. Thus, the different systems were required to be integrated, to make them interact with the existing Retail Merchandising System smoothly. In addition to that, the client was also seeking help in:
The client sought support for real-time visibility of operations and seamless integration of Retail Merchandising System with third-party applications:
JK Tech, as the client’s solutions partner played a pivotal role in technology evolution and helping the client with development, integration, implementation and support services. To manage the datum of 600 retail stores and automate the manual process – the Excel- ETL (Extract, transform and load) based tool named PD Tracker was developed which enabled the real-time database update and automated the existing manual process, successfully.
Before the PD Tracker tool the client was maintaining RMS data in excel sheet only, the data was fetched from Oracle to excel sheet (no ETL was in the picture) and then perform their day-to-day activity. There was no real-time update possible from the excel sheet to DB. The tool made it possible to update/Insert/Delete data from excel to DB in real-time and helped in standardized data integration with an easy and quick generation of reports.
The integration of different applications with the Retail Merchandising System was accomplished using BizTalk Server, which acted as a middle-ware and a communicator between the two business systems coupled with data modeling and data transformation. BizTalk played a vital role in enabling open communication between the applications. The integration covered three interfaces:
Use the form below to get in touch