All work
Shipped

Pharmacy data migration

A converter that moves a pharmacy’s entire history out of a legacy system and into Box, proven on real pharmacies with zero failed records.

Role
Designed & built
For
Box Labs
Year
2026
Platform
Data engineering

Overview

Switching pharmacy software means bringing years of records with you. I built the migration that carries patients, prescribers, care homes, insurance plans, prescriptions, claim history, compounds and inventory out of a legacy pharmacy system’s SQL Anywhere database and into Box’s PostgreSQL.

What I built

  • The full record

    Every entity a pharmacy depends on, converted and linked back together on the other side.

  • Dry run first

    A dry-run mode writes everything out for review before a single record is inserted.

Under the hood

  • Zero failed records

    Validated on real pharmacies, including one with hundreds of thousands of prescriptions, without a single failed insert.

  • Messy data, handled

    Found and documented quirks the old system hid, like insurance plan IDs that are only unique within a single insurer.

Built with

  • SAP SQL Anywhere
  • PostgreSQL
  • Node.js
  • SQL Server
  • Sequelize
  • Jest

Next project

IT infrastructureCompleted

Office server & network build

A new HPE ProLiant server running Windows Server 2025 for a 20+ person office, with shared file storage, a rebuilt mesh Wi-Fi network and every employee laptop set up.

  • HPE ProLiant
  • Windows Server 2025
  • TP-Link mesh
View project