← All workLegacy modernisation

Legacy system modernisation

In short

  • WhatDesktop databases and spreadsheets that do not talk to each other.
  • HowOne secure web platform, with years of history brought across.
  • ResultEvery row accounted for, every change recorded.

Before and after

Legacy system modernisation, before and afterBefore: desktop databases and spreadsheet stacks, with re-typing between systems and no audit trail. After: one secure web platform with access by role, a full audit trail and the history kept.BeforeDesktop databasesSpreadsheet stacksRe-typing between systemsNo audit trailAfterOne secure web platformAccess by roleA full audit trailHistory keptrebuilt as one platformLegacy system modernisation, before and afterBefore: desktop databases and spreadsheet stacks, with re-typing between systems and no audit trail. After: one secure web platform with access by role, a full audit trail and the history kept.BeforeDesktop databasesSpreadsheet stacksRe-typing between systemsNo audit trailAfterOne secure web platformAccess by roleA full audit trailHistory keptrebuilt as one platform

Fragile systems become one platform the organisation understands, with its history intact.

What it delivers

  • History keptYears of records brought across, each one accounted for.
  • One source of recordNo more re-typing between systems.
  • Access by rolePeople see exactly what their role allows.
  • A full audit trailEvery change recorded from day one.

Principles

  • Old files are evidence: read, never edited.
  • A migration that does not balance has not happened.
  • Rules hidden in spreadsheets become tested code.

The engineering detail behind this work stays private: it belongs to the organisations I build for.

Want to talk about this work? Email me or download my CV.