Asset registry portal

A registry of physical assets with a stable identity for each one, loaded from legacy spreadsheets, where offices at each level see and maintain the assets under them.

Designed the data model and built the migration, the backend and the portal.

Model

Assets, locations and the office hierarchy as tables with enforced relationships.

Migrate

Scripts turn each spreadsheet layout into the model.

Authorise

Sign-in maps a user to a level and an area.

Maintain

Offices add, amend and review assets in the portal.