TTriveniExecutive Cockpit

Customer Master · Golden Record

The single view of the customer the legacy mill & distillery systems never had — the same account, mastered across SAP and every mill / distillery system, resolved into one.

Triveni Engineering & Industries Limited · FY24 (Mar'24, audited anchor)
One of India's largest integrated sugar & ethanol producers
5,500 employees · 13+ plants & units · 15 export markets
Executive read· the answer, then the moves

24 fragmented records across 7 source masters resolve to 10 golden records — a 58% duplicate rate collapsed on merge. Reconcile the 9 customers with conflicting payment terms to stop cash leakage and unlock the 10 cross-division accounts.

10 of 24 records resolved to golden · 14 duplicates collapsed · 9 term conflicts open

Do now — ranked by urgency
  1. 1
    Reconcile 9 customers with conflicting payment termsAct now
    Why it matters

    The same buyer sits on Net 30 in one brand and Net 60 in another across 9 accounts — direct cash leakage and credit risk a single master removes.

    What's driving it
    • 9 customers carry conflicting terms
    • 58% duplicate rate across 7 systems
    FYI
    • Conflicts surfaced to credit and sales
    • Total exposure netted across brands
  2. 2
    Collapse the 14 remaining duplicate recordsWatch
    Why it matters

    24 raw records reduce to 10 golden — finishing survivorship gives every team one account, one team, one set of terms.

    What's driving it
    • 14 duplicates collapsed on merge (58%)
    • 24 records across 7 source masters
    FYI
    • Match → merge → survive → reconcile
    • Borderline matches queued for a steward
  3. 3
    Activate 10 cross-segment accounts for cross-sellOpportunity
    Why it matters

    10 golden records are already served across ≥2 segments — the resolved master is the cross-sell base no single mill / distillery system could see alone.

    What's driving it
    • 10 accounts served across ≥2 segments
    • 10 golden records mastered
    FYI

    Golden record is the join key for Customer 360 and Cash 360

💎 Value creation & investor readinessStep 6 of 7 · resolve the golden record (MDM)Transformation 360Value CreationAll journeys
🌐 Enterprise 360 modules· on Customer MasterBrowse all 31 views ▾
● LiveBuilt forSales / Key Accounts· one account, one teamCredit / Finance· one set of terms & exposureData / MDM· dedupe & survivorship

Each segment and legacy mill system kept its own customer list, so IOCL, BPCL and HPCL each exist several times across the systems — with different names, IDs and even payment terms. Until they're resolved, no one can see the true relationship, total exposure, or cross-sell base. This is the golden record AI builds on top of the mesh.

Data backing: customer_source (SAP + mill / distillery system fragments) · entity resolution · survivorship rules
7
Source masters
SAP + mill / distillery systems
24
Raw customer records
across all systems
10
Golden records
after AI resolution
58%
Duplicate rate
collapsed on merge
10
Cross-segment accounts
mastered across ≥2 systems
9 customers carry conflicting payment terms across systems — the same buyer on Net 30 in one brand and Net 60 in another. That's direct cash leakage and credit risk a single master removes.
One customer, every system

Pick a customer → see its fragments merged

The ★ master survives; the rest merge with a match confidence. Conflicting terms are flagged in red.

Customers · # source records
★ Golden record

IOCL (Indian Oil)

resolved from 3 source records · master = Triveni CRM / SAP
Consolidated AR
₹520 Cr
Survivorship terms
Net 21
Sources merged
3
Term conflict
Yes — review
Match confidence
96%
Source records merged into the golden record
Source systemName as storedIDTermsARMatch
Triveni CRM / SAPIndian Oil Corporation LtdACCT-30011Net 21₹250 Crmaster
0Ethanol dispatch / OMC portalIOCL - EBPOMC-2201Net 21₹180 Cr96%
0Distillery ERPIndianOil (ethanol)DIS-4471Net 30₹90 Cr92%

Conflict: payment terms differ across systems (Net 21 vs Net 30). Survivorship keeps the master's Net 21; the others are flagged for credit to reconcile — exactly the kind of leakage a single view removes.

Cross-segment signal: IOCL (Indian Oil) is served across 3 Triveni systems / segments. That's a relationship to coordinate (one account team, one set of terms) — and a cross-sell base already inside the house.

How AI builds the golden record

Match → merge → survive → reconcile

1 · Match

Fuzzy + LLM matching on name, address and tax ID links 'Indian Oil Corporation Ltd', 'IOCL - EBP' and 'IndianOil (ethanol)' to one entity — with a confidence score, not a blind merge.

2 · Merge

Records above the confidence threshold collapse into one; borderline matches are queued for a human steward.

3 · Survive

Survivorship rules pick the winning value field-by-field (most-recent, most-complete, or the governed source) to form the golden record.

4 · Reconcile

Conflicts — different terms, duplicate AR — are surfaced to credit and sales, and total exposure is netted across the brands.

The golden record is the join key for everything else: it lets Customer 360 show one account, Cash 360 net one exposure, and the cross-sell engine see that a customer already buys from two segments — the same entity-resolution layer that powers the mill-grain and order/tender views.