Ford Otosan · Product Development

You need one simple answer.

The answer existed…

“What's the status of that release?”
“Where is that test part?”
“How does this suspension sit under load?”
XLSXstatus_final_v7.xlsxa spreadsheet
\\tests / 2026 / misca shared drive
@RE: RE: FW: status?somebody's inbox

Toolbox

One front door for engineering.

01 · The platform

The single front door to our engineering apps.

  • Sign in once — company single sign-on
  • One catalog — every application
  • Search, favorite, request access
  • Redirect apps — out to other systems
  • In-house apps — open right here
toolbox / Apps
✓ Signed in · single sign-on
DigitalPD · need access?Download the authorization file ↓
Illustrative layout
02 · Program health

Is the program on track?

H84X Metrics one page 0 metrics

GREEN — on targetRED — needs attention
Chief Attestationdetails page
Approved9 / 14
Trend
▲ +2vs yesterday
planactual GLIDE PATH
✓ Data-quality checks
Daily snapshots
Illustrative data
03 · Workload risk

Green and red tell you where.

They don't tell you who is carrying it.

Workload risk, by champion

risk = Σ (weight × open items), scaled so the highest = 100
⤓ H84X_Workload_Risk.xlsx
Illustrative data
04 · From data to the physical world

PDIMinventory for engineering parts & equipment

Torque sensorSN-00417
≈ 50 fields · 6 sections
✓ Item page opened
Quantity
205
updated automatically
IN+12
OUT−15
OUT−9 · blocked, never below 0
Home page alerts
0below critical stock
0planned exit approaching
0calibration due
0maintenance due
Permission follows the shelf
Lab A › Shelf 3you are responsible · can move stock
Lab B › Shelf 1view only
Warehouse 2 › Rack 14view only
Illustrative data
05 · Engineering calculations

P9 Calculatorengineering math, turned into a product

Inputs · axle 1
P9 = Design P9 − ((Design load − Axle load) ÷ 2) ÷ Rate
✓ written once✓ tested✓ shared
p9_calc_final(2).xlsx
Illustrative data
06 · Adoption analytics

The front door sees who walks through.

Daily users0
Weekly users0
Monthly users0
Directorate ▾Chief ▾Q1 · Q2 · Q3 · Q4Engineering AI trend
Elasticsearch logs
Daily job
MongoDB snapshots
Dashboard v3
querying raw logs on every page load
Illustrative data
07 · Data in

How does the data get in?

Through an integration hub.

≈ 20 Excel feedsdaily imports
Bill of materialssystem API
Assessment systemexternal API
Integration hub
Databasesystem of record
Daily snapshotscheduled job
Card + details page
New metricbackend module→Card / Details endpoints→API client→constants→Card + Page→registry entry
↻ the same recipe, every time
08 · Under the hood

Deliberately boring.

React front ends
H84X MetricsPDIMP9 CalculatorDashboards
.NET 8 back end · clean layers
PresentationMVC shell · Web API
Infrastructurepersistence · integrations
Applicationservices · calculators
Domainentities
Oraclesystem of record
MongoDBsnapshots
Elasticsearchusage logs
Single sign-onat the door
Role-based permissionsinside every tool
OpenTelemetry · traces · metrics · logs
09 · Quality

A high bar.

0

back-end tests
xUnit

0

front-end tests
Jest

Every build
Build APInpm build + JestBuild MVC✓ Static analysis

Built with AI coding assistants

…working under written rules docs/ai/ai-rules.md

CHECK→READ→THINK→WRITE→VERIFY
toolbox/
├─ docs/ ai · pdim · ChiefAttestation ← specifications
└─ src/ ← the code, right next to them

Toolbox

One sign-inOne catalog
Program healthH84X Metrics
Physical inventoryPDIM
Engineering calculationsP9 Calculator
Adoption analyticsApplication dashboard
one placeone stackone standard
Thank you.
❚❚ paused — Space to resume

Toolbox

Spacepause← →slidesVvoice on/off (manual mode)CcaptionsFfullscreen