TTToyota Tsusho IndiaExecutive Cockpit

Tech Overview

The architecture under the cockpit — how data flows from many disconnected division, site and Toyota-group systems into one governed truth, how that truth becomes a decision, and how two 360s still deliver over real data gaps.

Toyota Tsusho India Private Limited · FY25 (Mar'25, MCA-filed)
India arm of Toyota Tsusho — the Toyota Group's general trading company (sōgō shōsha)
238 employees · 10+ offices, service centres & hubs · 20 export markets
Under the hood

One governed brain over
many disconnected systems.

No big-bang migration. The platform federates each division, site & Toyota-group system, resolves it to one ontology, and serves a single trusted number — then turns that number into a decision, and the decision into an owner's action.

10/12
Sources fresh
14,982
Records governed
4/10
Divisions on SAP grain
53%
Revenue at site grain
Technical architecture

The governed stack — eight tiers, federated not centralized

Each division, site and Toyota-group system stays where it is. The platform layers ingestion, master-data resolution, a shared ontology and a semantic layer on top, then serves one governed truth to the apps and AI. Data flows top → bottom.

Sources
12 systems of record
SAP / trading ERP · division ledgersSteel service-centre MES · logistics / WMSToyota-group EDI / JITCRMHRIS · payrollMCA filings · commodity & FX feeds
Ingestion
adapters · lineage · SLA
Source adaptersCDC & batch loadsFreshness / SLA monitorLineage capture
Store
raw → curated
Raw landing zoneCurated storeVersioned snapshots
MDM · Resolution
many codes → one node
Entity resolutionGolden recordsSurvivorship rulesDedup · term-conflict
Ontology
the knowledge graph
T-Box · 10 classesA-Box · instancesTyped predicatesSite = keystone
Semantic
defined once, federated
Metric definitionsGrain tagsFederation engineAllocation + confidence
Serving
governed access
Governed metrics APIQuery layerReconciliation tests
Consumption
apps + intelligence
360 views · Next.jsExec briefs · deterministicAzure OpenAIAgentsweb-grounding
Data flow

How one record travels — source to served truth

A single transaction's journey through the stack. A confidence flag and a reconciliation tie-out ride along with it the whole way.

1
Extract

Adapters pull each division, site & Toyota-group system's events on schedule / CDC.

2
Land

Raw records stored verbatim, with lineage + timestamp.

🧩
3
Resolve

Codes matched to one canonical entity.

🧬
4
Model

Mapped onto the ontology — classes & relationships.

📐
5
Define

Native fields → governed metrics; estimates flagged.

🔌
6
Serve

One metrics API; reconciliation gates the numbers.

🔭
7
Consume

360 views, exec briefs & AI read one truth.

🏷 A confidence flag (Actuals / Allocated / Region-only) and a reconciliation tie-out travel with every value — so a number is never shown without knowing how bankable it is.
From data to action · the decision flow

How one number becomes a decision

The governed truth doesn't sit in a warehouse — it routes itself to the right view, the right action, and the right owner.

The agentic layer

An agent on every value pillar

The four value-creation pillars don't just have dashboards — each has a standing agent that reads its governed data products and recommends the next move. Same ground truth, automated.

📈Profitable Trading Growth & Margin Quality
Watches

record PAT, trading margin & the recurring / anchor supply mix vs plan

Grounds on
business_unit · service_line · signal · kpi
Acts in Profitable Trading Growth & Margin Quality
🔗Toyota-Group & OEM Supply-Chain Excellence
Watches

the BD pipeline, new OEM mandates & the TKM anchor concentration vs target

Grounds on
opportunity · pipeline_stage · customer · project
Acts in Toyota-Group & OEM Supply-Chain Excellence
🌱New Energy, Rare Earths & Circular Economy
Watches

CleanMax capacity, TREI rare-earth offtake & the recycling loop

Grounds on
ma_target · synergy_prog · brand_cohort · goal
Acts in New Energy, Rare Earths & Circular Economy
💎Capital Efficiency & Working-Capital Discipline
Watches

net debt/EBITDA, debtor days & working-capital velocity

Grounds on
kpi · ar_aging · debt_tranche · covenant_qtr
Acts in Capital Efficiency & Working-Capital Discipline
The hard part

Two 360s that work before the data is clean

Some divisions and units aren't fully on the common SAP grain yet, so the unit→division mapping and site-grain detail are incomplete. These views still answer — by resolving, allocating-and-flagging, then reconciling. The estimate is labelled, never hidden.

🗂Org Roll-up 360
Open →
The gap
6 of 10entities not yet site-grain

Some units report at their own grain — so the unit → site → division → legal-entity rollup is partly missing or inferred.

How the platform bridges it
1
Resolve. AI maps each legacy unit / site / leader code to one canonical org node.
2
Allocate + flag. Where a unit isn't mapped, revenue is disaggregated from its geography on learned drivers — and marked an estimate.
3
Reconcile. Allocated parts must foot back to the division total; breaks are surfaced, not hidden.
~53%grain coverage

of revenue already at true site grain; the rest labelled & closing as divisions move onto SAP

📍Site / Service Centre 360
Open →
The gap
8 unitsallocated or region-only

For units not yet on the common grain, per-asset, recurring-supply and revenue detail isn't available at site grain — so the site twin would otherwise be blank.

How the platform bridges it
1
Estimate. Site figures are modelled to ~84% coverage from geography totals and asset signals.
2
Flag confidence. Every estimated site carries an Actuals / Allocated / Region-only badge and a coverage %.
3
Flip to actuals. As each unit cuts over to SAP, its site grain rises and estimates become ledger actuals.
~84%grain coverage

avg site-grain coverage today — transparent where it's modelled

The harness catches the gaps
13 of 14 governed identities tie out to the cent

Reconciliation runs live on the data. The 1 known break below is the site-grain gap surfaced on purpose — exactly what a CFO or auditor wants flagged, not buried.

Open Data Health →
⚠ flagged
Recurring supply = Σ site supply
13
tie to the cent