Independent and small-chain supermarkets, known as traditional trade, did not provide the structured sell-out reporting that FMCG suppliers received from modern trade chains. Promotional and pricing campaigns running in those stores produced no register-level feed.
DTL is a consortium of 13 independent retailers operating ~700 stores, 7,000+ employees, and 280,000+ daily customers. Each member chain ran its own POS infrastructure on legacy platforms with proprietary database formats and varying SKU coding conventions, with no unified data layer across the group.
The team delivered a three-tier integration platform. For each of the 13 retailer systems, a chain-specific extraction agent ran on a scheduled cadence multiple times per day, computing a delta against the last successful sync and pushing only new transactions to a central ingestion endpoint.
A Spring Boot aggregation service ingested the extracts, applied chain-specific normalization rules, and resolved each line item against a master SKU dictionary, since identical products carried different internal codes across chains. The normalized dataset was exposed through Microsoft Power BI dashboards tailored to each enterprise client. Category managers at Coca-Cola Hellenic, Atlantic Group, Delta Agrar, and Zlatiborac used it to track sell-through by SKU, region, and store cluster, isolate the lift from specific promotional mechanics, and verify that pricing campaigns reached the shelf.