Kofi E. Ampaabeng

Selected Work

20 systems I have architected, built and run: enterprise platforms, consumer apps, and the tools and infrastructure behind them. 20+ years across regulated banking, data platforms and applied ML.

20
systems
6
enterprise
7
ML · LLM
20+
years

06 · Financial reconciliation

CWC Rekon

Every transaction matched by rule, every break owned.

Reconciliation for banks: loads transactions from the core banking system, payment channels and mobile-money operator statements, matches them by configurable rules, and routes every break to an audited exception workflow.

  • Enterprise

Surfaces

  • Web
  • On-prem
  • API
  1. 01Rule-driven matching — rules are table rows compiled to set-based SQL: one-to-one, many-to-many and reversals, matched automatically or proposed.
  2. 02Three-way sets — a payment channel against the core ledger against the settlement batch.
  3. 03Operator statements — mobile-money statement loaders for three operators, with a status requery.
  4. 04Exception workflow — seven exception types with SLAs: assign, escalate, propose, approve and close, maker-checker throughout.
  5. 05Tamper-evident audit — a hash-chained audit log with checkpoints, legal holds and SIEM forwarding.
  6. 06Masked identifiers — customer identifiers are encrypted and masked on write; every reveal is audited.
  7. 07Observability — a shipped Prometheus, Grafana, Loki and Tempo stack with eight dashboards and alert rules.
  • 16 seeded rules
  • 6 reconciliation sets
  • 7 exception types
  • 15 ADRs
SurfacesWebOn-premAPI
SOURCESINGESTMATCHEXCEPTIONSCONTROLCONSOLElatest versionrulespairs, orphansraisesCore bankingJDBC views or snapshotPayment channelAPI + webhooksOperator statementsmobile moneyLoad runnertotals check, watermarkCanonical txnone shape, masked idsSets and rulesrows in the databaseMatch enginerules compiled to SQLRun executorone active run per setClassifierseven typesException workflowSLA, approvalsSuspense ledgeropen itemsAudit storehash chainSIEM forwardTLS syslogAnalyticsrollupsREST + OpenAPIOperator consoleReact
Architecture, drawn from the codeServiceStoreModel usedModel trained hereFeedback
  • Java 21 · Spring Boot
  • PostgreSQL · SQL Server
  • Flyway
  • Spring Security · OIDC
  • OpenTelemetry
  • React · TanStack
  • Docker Compose