The ledger

Problem after problem, solved.

Thirty-five years produces a certain kind of consultant: one who has run the P&L, walked the shop floor, administered the ERP, written the code — and now wields AI as a force multiplier on all of it. Below is a working ledger of real problems and how they got fixed. Every entry drew on more than one discipline, because in manufacturing the real problems always do.

Disciplines in play: EXECUTIVE FINANCE MANUFACTURING INFORMATION TECH PROGRAMMING AI
The force multiplier

One operator, moving like a team.

Every discipline below got sharper the day AI entered the workflow. Requirements captured in a working session become a validated specification the same day. Specifications become production code overnight through an AI-assisted build pipeline. Reconciliations that took a week of squinting at exports become systematic queries with documented root cause.

The result is a delivery model no traditional firm can match: senior-operator judgment on every decision, with build velocity that used to require a bench of six. You don't pay for the bench. You pay for the judgment — the AI supplies the leverage.

Case ledger

Recent entries.

Clients anonymized by industry until they've approved being named. The problems are real, the details are real, and references are available in every case.

Medical device OEM · SAP S/4HANA Executive Manufacturing Programming AI

An operations portal SAP couldn't be — with an AI knowledge core on top

The problem

SAP screens didn't fit how the plant actually worked. Cycle counting, receiving, quality inspection, fulfillment, and service each needed interfaces built around the workflow, not the transaction code. And decades of tribal knowledge lived in senior technicians' heads and scattered documents.

What I built

A unified operations portal against the live SAP HANA schema — Customer 360, cycle count, receiving, quality, fulfillment, service and executive command centers, with barcode capture where the workflow demanded it. On top: a retrieval-augmented AI knowledge core with role-based filtering, so techs query documentation and service history in plain English and get source-cited answers.

Outcome

In daily use across plant and service teams. Answers cite their sources — the knowledge base earns trust instead of demanding it. The operation's institutional memory no longer retires when people do.

National hardware & paint retailer · Fourth Shift → Oracle Finance Information Tech AI

Feeding a corporate Oracle migration — and reconciling every number to root cause

The problem

A divestiture put a manufacturing division's Fourth Shift data on a hard deadline to land cleanly in the parent company's Oracle environment: AP invoices, supplier masters, GL extracts — with a corporate integration template of dozens of required fields, and finance teams on both sides who needed the trial balances to tie.

What I did

Built and iterated the extract suite against the corporate template, tightening invoice-selection logic to eliminate duplicate-payment exposure. When period batches disagreed between systems, I didn't pick a side — I reconciled to root cause and published the explanation, with query-level proof. Delivered AR visibility screens so finance could see the state of the book throughout.

Outcome

Migration workstream delivering on schedule against corporate review cycles, with a discrepancy log the client can read — because showing the log builds more trust than hiding it. Finance signs off on numbers, not vibes.

Aerospace supplier · France · Infor Finance Information Tech Executive

French e-invoicing compliance with a regulatory clock running

The problem

France's e-invoicing mandate meant a Tier-1 aerospace supplier had to produce and exchange structured Factur-X/CII invoices through a certified platform — a hard government deadline, a multi-party integration spanning the ERP, a compliance platform, and corporate stakeholders on two continents.

What I did

Owned the integration architecture and field-level mapping from the ERP through to the certified e-invoicing platform: invoice lifecycle states, error handling, and the unglamorous work of making every mandated field land correctly. Ran the workstream across French operations, corporate, and platform vendors — the coordination is half the job.

Outcome

A compliance program on track for its mandated go-live, with a specification the client's teams can maintain after the engagement ends. Regulatory deadlines don't move; the plan was built so it wouldn't have to.

Forging operation · North America Manufacturing Programming AI

From an undocumented Access database to a modular quality portal

The problem

Quality management ran on an aging Access database nobody fully understood, alongside a rough shop-floor system. The client wanted modernization but had been burned by big-bang rewrite pitches — and when portal numbers disagreed with the legacy system, "trust the new tool" wasn't an acceptable answer.

What I did

Insisted on a Phase 0 gate: fully reverse-engineer the Access database before writing migration code. Then built module by module — customer scorecards with normalized quality/delivery/service/cost scoring, returns management, audit forms, a defect-to-resolution workflow. When scrap numbers disagreed between systems, I reconciled both to root cause and documented exactly why they differed.

Outcome

Modular portal in production, each module earning its keep before the next was added. The legacy database is documented for the first time in its life — and the portal caught a data-integrity problem the plant had been living with for years.

Automotive wheel manufacturer · South Africa · Fourth Shift Manufacturing Programming

Shop-floor scripting where a wrong scan costs real money

The problem

High-volume wheel production with barcode-driven material movements — interlayer handling, paint-line conversion, bin logic — where the standard ERP transactions didn't match how material actually flows, and a mis-scan means wrong inventory in a plant that runs around the clock.

What I did

Designed and wrote the data-collection scripts that sit between the scanner and the ERP: substitution logic, receiving conversions, guarded prompts that make the right action the easy action. Every change proven in a sandbox environment against production-shaped data before a controlled deployment — because on a live shop floor, "it should work" isn't a deployment plan.

Outcome

Scripts running in production across shifts, with a sandbox-to-production protocol the client's team now follows for every change. Inventory the plant can trust, from the scan up.

Foundry consumables manufacturer · 25-year relationship Executive Programming AI

Modernizing an ERP I wrote myself — decades later

The problem

Decades ago I wrote this manufacturer's ERP in FoxPro. It has run their business ever since — a testament to fit, and a growing liability. They needed a path to a modern web platform without betting the company on a rip-and-replace, from a partner who understood every quirk of the system. Fortunately, one was available.

What I did

A piece-by-piece conversion to a modern web stack — each module replaced only when its successor is proven, so the business never stops running on software it trusts. AI-accelerated development makes an incremental path economical that would have been unaffordable at consulting rates a few years ago.

Outcome

A modernization underway measured in working modules, not migration decks. Twenty-five years of institutional knowledge conserved instead of discarded — the Ship of Theseus, rebuilt plank by plank while it sails.

Agricultural equipment manufacturer · Fourth Shift Finance Manufacturing Information Tech

Giving a mature ERP the reporting layer it never shipped with

The problem

A European-headquartered manufacturer's North American operation ran a mature, stable Fourth Shift environment — with reporting that stopped at what the vendor shipped in the nineties. Operations and finance were flying on exports and spreadsheets.

What I did

A phased reporting build: procurement intelligence first — vendor scorecards, PO reliability, lead-time drift, open-PO risk — because supplier surprises were the acute pain. Built directly on their real data, structured so each phase funds the case for the next.

Outcome

A BI layer the operations and finance teams actually open in the morning, on an ERP the vendor stopped improving years ago. Proof that "legacy system" and "flying blind" don't have to be the same sentence.

Your entry here

What's the problem that won't stay fixed?

Bring it to me. You'll get a straight read, a tight scope, and a ledger entry with your name on it.

Email Dan directly