Case Study · USA's top Telecommunications Carrier

Retail inventory leakage rectified — $3M saved.

Migrated SAP-based Supply Chain Management data to a Cassandra NoSQL database via the UDMF platform in phased waves, and established end-to-end daily reconciliation between the source systems and Cassandra — identifying expected-vs-actual stock variances, transaction anomalies and critical reconciliation issues for a leading US telco. Delivered $3M in cost savings through the RISP programme.

Talk to deliveryAll case studies

Industry

Retail

Region

Year

2022

Retail / Supply Chain / Inventory Management / Data Reconciliation

The case study focuses on supply-chain data migration, inventory reconciliation and leakage/variance assessment. The customer needed to migrate its existing SAP-based Supply Chain Management data into a NoSQL Cassandra database using the UDMF platform, in a phased approach. Alongside the migration, the solution established a comprehensive daily reconciliation process between the various source systems and the Cassandra database — to identify and resolve discrepancies in inventory and transaction data and reduce inventory variances.

Business requirements & challenges

Migrating a complex supply-chain estate to a new data model — while proving, every day, that nothing was lost or mis-stated in the process.

Major challenges

Strong supply-chain domain expertise (inventory, stores, SKUs, sales, returns, transfers, receipts, adjustments, transaction flows)
Transform SAP-based supply-chain data to meet the NoSQL Cassandra data model
Establish correlation among systems and transaction flows to enable daily reconciliation
Onsite presence during critical phases of delivery

Solution

A framework fetches data from ECC and OER SAP systems, then manages and analyses it to support data-quality analysis, migration reconciliation, transaction reconciliation and inventory analysis. Migration to Cassandra runs on the UDMF platform in phases, and a dedicated reconciliation framework performs end-to-end reconciliation of transaction data across systems.

Data extraction from ECC and OER SAP systems, with management and analysis
Tailored reports for data quality and migration reconciliation (migrated vs source)
End-to-end (E2E) reconciliation of transaction data across tightly coupled systems
Daily business discrepancy reports, tracked and resolved via PIER tickets
Store-level expected-vs-actual stock reporting per store and SKU from daily transactions
Transaction anomaly detection across coupled system flows

Stack

Technologies used

SAP ECCOER SAP systemsCassandraNoSQL DatabaseUDMF PlatformPIER TicketsData ExtractionE2E ReconciliationInventory Analysis

How it works

Process workflow

01Extract data from SAP ECC / OER systems
02Data management & analysis — data-quality analysis and migration reconciliation
03Migrate SAP supply-chain data to Cassandra NoSQL via the UDMF platform (phased)
04E2E reconciliation of transaction data across systems
05Analyse transactions — sales, returns, transfers, receipts and inventory adjustments
06Expected stock analysis, then compare expected vs actual to identify variances
07Daily business reports → PIER tickets for issue tracking & resolution
08Resolve critical reconciliation issues → reduced inventory variances

What's new

Key innovations

SAP → Cassandra migration

Migrates SAP-based supply-chain data to a NoSQL Cassandra database via the UDMF platform, in a phased approach.

E2E transaction reconciliation

A reconciliation framework compares transaction data across tightly coupled systems end-to-end.

Expected-vs-actual stock

Computes expected stock from daily transactions and compares it with actual stock per store and SKU.

Transaction anomaly detection

Highlights anomalies where transaction information doesn't correlate across systems.

Daily reports + PIER tickets

Daily discrepancy reports feed PIER tickets for tracking and resolution.

Migration reconciliation reporting

Data-quality and migration-reconciliation reports verify migrated information matches the source.

Business benefits

Store-level stock variances and cross-system transaction anomalies were surfaced daily, and critical reconciliation issues were resolved to reduce inventory variances.

Identified variances between expected and actual stock at stores (per store and SKU)
Identified transaction anomalies across tightly coupled systems
Critical reconciliation issues identified and resolved, reducing inventory variances

$3M

cost saved through the RISP programme

At a glance

Key highlights

Customer	USA's Top Telecommunications Carrier
Primary Objective	Inventory leakage & reconciliation
Source Systems	SAP ECC + OER SAP
Target Database	Cassandra NoSQL
Migration Platform	UDMF
Migration Approach	Phased
Reconciliation	E2E transaction reconciliation
Transactions	Sales, Returns, Transfers, Receipts, Inventory Adjustments
Reporting	Daily reconciliation & discrepancy reports
Issue Tracking	PIER Tickets
Stock Analysis	Expected vs Actual (stores + SKUs)
Key Detection	Transaction anomalies
Cost Saved	$3M USD (RISP programme)

More from retail.

See all case studies

Retail

L1 Help Desk & SIAM on ServiceNow across 800+ stores

A robust L1 Help Desk and SIAM (Service Integration and Management) framework for a leading USA-based liquor store chain operating 800+ retail locations and 120+ head-office employees. Built on ServiceNow as the centralized incident and service-management platform, it logs, categorizes and prioritizes incidents, resolves common issues from a searchable knowledge base, automates escalation to L2/L3, and coordinates third-party vendors for major incidents via SIAM — across email, phone and web-portal channels. The result: reduced operational downtime, streamlined IT operations, enhanced service quality and data-driven decisions.

Leading USA-based liquor store chain

Make this kind of impact at your organisation.

Talk to us

// loading…