AIA Group
Amplify Health · AIA Group June 2022 – December 2024

Orchestration: AIA Vitality Health Data Cloud Migration

Role
Senior Digital PM
Team
34 people · 7 work streams
Scope
Oracle → PostgreSQL · Azure
Annual savings
$1.2M
~400
Java backend APIs rewritten and testing automated
20
Services revamped and moved to the new PostgreSQL stack on Azure
0
Data loss across 34 billion records, verified by row-count and checksum

Orchestration: AIA Vitality Health Data Cloud Migration

Complex project rewriting Java apps to connect to PostgreSQL and move everything to Azure cloud with blue-green cutover.

My impact: Coordinated 34 people in 7 different work streams to estimate and execute and test functional and non-functional requirements for successful cutover.

Learnings: Production environment often presents unique challenges not seen in lower environments, underscoring the importance of meticulous planning and high standards for the definition of done and handovers.

Tech stack

Data
Oracle (source) PostgreSQL (target) Striim (replication)
Cloud & Backend
Microsoft Azure Java
Delivery & Tooling
Jenkins (CI/CD) Jira Confluence Bitbucket ChatGPT (stored procedure translation)
Healthcare Cloud migration Team leadership HealthTech

Similar work

Working on a similar migration?

The rollback sequencing and the AI-assisted stored procedure workflow are the parts most people want to dig into. Happy to compare notes.

Get in touch →

Related case studies

2018
HSBC Hong Kong: Public website replatform
600+ pages · 3 languages
Read case study →