Internal system / Product Engineer

Hamilton IFRS Reporting

Dashboard for IFRS reporting and financial analysis

Private client project — no public link
  • Golang
  • PostgreSQL
  • Oracle
  • Kubernetes
  • Docker
  • TypeScript
  • React
  • Tailwind

About This Project

Hamilton is a reporting platform that finance teams use to produce IFRS (International Financial Reporting Standards) reports. It runs on-premise inside each client's own infrastructure.

I joined in late 2021 as a junior engineer and have worked on it since, as a Product Engineer covering backend, frontend, and deployment.

Version 1: Python and Flask

I wrote the first backend in Python with Flask on top of PostgreSQL. I learned Flask for this project because it was the fastest way to get reports in front of users. It worked, but the structure didn't hold up well as features and clients piled on.

Version 2: The Rewrite

In late 2024 a new client required Oracle instead of PostgreSQL. Adding a second database to the old codebase would have made it fragile, so I proposed a rewrite. It was approved and started in January 2025.

Backend (Go):

  • Database access sits behind Go interfaces, so the same report logic runs on PostgreSQL or Oracle
  • Redis caches the expensive report queries
  • Heavy report generation runs as background jobs with Asynq

Frontend (React + TypeScript):

  • A shared component library built on Tailwind
  • TanStack Query for fetching and caching large report datasets

Everything ships as Docker images and runs on Kubernetes.

Results

  • PostgreSQL and Oracle clients run on the same codebase
  • Lower, more predictable memory usage than the Python version
  • New developers get productive faster because the code structure is consistent and typed

Tech Stack

  • Backend: Golang
  • Frontend: React, TypeScript, Tailwind CSS
  • Databases: PostgreSQL, Oracle
  • Caching & Queues: Redis, Asynq
  • Infrastructure: Docker, Kubernetes