Skip to content
John Charlie CatedrillaSelected work

Representative work

Business Operations Software

Internal tools that replace spreadsheet processes: role-aware records, reporting views, and business rules that live in one place.

This is a representative work note, not a public product case study. It describes the class of problem, the scope of the work, and the engineering practices involved; client identities, product specifics, figures, and implementation details are deliberately withheld to respect confidentiality.

The problem

Internal teams eventually outgrow spreadsheets, but operational software has to model real business rules faithfully while staying flexible enough to change with the process it supports.

Scope of the work

  • Build and maintain features for operational tools — record management, role-aware access, list and detail views, and reporting screens — across frontend and backend.
  • Translate rules the business currently enforces by hand into explicit, testable domain logic.
  • Deliver iteratively with the non-technical people who use the tool, adjusting workflows as their process changes.
  • Contribute within employer-owned products and established team conventions.

Engineering considerations

  • Encode business rules in one typed domain layer instead of scattering conditionals across the UI.
  • Treat permissions as product design: enforce role checks where data is accessed, not only behind hidden buttons.
  • Design forms and list views around the operator's actual sequence of work, with sensible defaults and batch actions.
  • Keep schema migrations boring and reversible; operational data is a liability to corrupt and an asset to protect.
  • Prefer clear error messages over clever ones — an operator mid-task needs the fix, not the HTTP status.

Capabilities demonstrated

  • Domain and data modeling
  • Role-aware access patterns
  • Internal-tool and record-management interfaces
  • Reporting views
  • Iterative delivery with non-technical stakeholders

Technology categories

  • TypeScript and React frontends
  • Node.js APIs
  • PostgreSQL (Prisma)
  • Internal tooling patterns