Optimized store stock with improved product availability by implementing big data solution

Optimized store stock with improved product availability by implementing big data solution

Optimized store stock with improved product availability by implementing big data solution

About the Client:

 

Our client is one of the largest American multinational food-manufacturing company producing cereal and convenience foods

 

Business Challenges:

 

  • Unavailability of consolidated data led to slow customer processes, affecting response to product availability enquiry from retailers
  • Lack of visibility to identify revenue improvement opportunities using external data

 

The Solution:

 

TekLink expert identified the weak spots in PoS data management practices within the organization and developed data cleansing / data enrichment engine in Scala/Spark, connecting PoS data to EDW database for generating product availability KPIs for different retailers. The solution focused on

  • Connecting Point of Sale (PoS) and Inventory data through third party data service provider
  • Transferring of PoS data into customer HDFS data lake ensuring data security
  • Integrating and enriching the PoS and Inventory data using Spark / Scala processing engine while storing it into HDFS data lake
  • Enrichment of selective retailer’s PoS and Inventory data using BODS tool and load into SQL Server
  • Designing and building integration procedures and orchestration layer to move data into memSQL & EDW using BODS
  • Developing custom reports and dashboards with product availability KPIs in Tableau on memSQL database

 

Outcome and Benefits:

 

The solution implemented provided a competitive advantage by adding capability to demonstrate greater comparative advantage

  • Increased visibility of product availability and inventory of retailers enabling effective inventory and promotion management
  • Enhanced capability to run targeted promotions and increased conversion opportunities
  • Improved visibility into revenue enhancement opportunities and higher profitability due to optimized supply chain efficiency

 

Contact Us to learn more about this experience.

Contact Us

Contact Us

TekLink