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
Search apps…metrics
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
▲ +2vs yesterday
✓ 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
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
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
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 endsH84X 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.
Every buildBuild 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
+ the next toolalready has a home
one placeone stackone standard
Thank you.
❚❚ paused — Space to resume
Toolbox
Spacepause← →slidesVvoice on/off (manual mode)CcaptionsFfullscreen