pythonodooawspostgresqlinfrastructure

ERP Migration

Multi-year ERP migration at a natural foods grocer: legacy OpenTaps/CRS to Odoo, with both systems live in parallel.

Timeline Early 2020 to 2024

Overview

At Bright Village, I led the infrastructure side of a multi-year ERP migration for a natural foods grocer, transitioning from a legacy OpenTaps/CRS system to Odoo. Both systems had to stay operational for the duration of the cutover, with data kept in sync across them.

Highlights

  • Designed and ran bidirectional data synchronization between OpenTaps and Odoo so the business could continue operating on either side during the transition.
  • Administered self-hosted Odoo instances on AWS ECS, including PostgreSQL tuning, backup strategy, and security hardening.
  • Built custom Odoo modules in Python to cover gaps between the legacy business logic and out-of-the-box Odoo.
  • Owned monitoring and incident response for the migration window.
  • Managed networking requirements between the client’s on-premise network and AWS.

Stack

  • Python
  • Odoo
  • PostgreSQL
  • AWS (ECS, S3, RDS)
  • Linux Debian
  • Docker