01
Modernization of case-management systems handling legally restricted records
Replacement of aging record systems in domains where confidentiality is a legal obligation rather than a preference, and where an entire class of record must remain non-discoverable across every surface of the system.
That constraint is more demanding than it sounds. A record that must not be discoverable cannot leak through a result count, a stale cache, a greyed-out row, a differently-worded error, an export total, a notification email, or a log line an operator reads six months later. Designing an absence that is invisible but not deceptive is a data-model problem, a query-path problem, an interface problem and an observability problem at the same time, and a system that treats it as any one of those will leak through the others.
Outcome shape. A clean-sheet architecture in which non-discoverability is enforced by construction — row-level security in the database rather than hoped for in the service layer, effective-dated policy, declarative rules over a restricted evaluation surface, and a full audit trail that itself does not disclose what it is auditing.