Back to Work
FLAGSHIP CASE STUDY

Truewill: Quality Management Platform

A quality-management platform developed for an Australian client, spanning staff, client, scheduling, shift, pricing, and incident-management workflows.

01 / Problem & Context

Mission-Critical Workflow Integrity

Managing complex multi-entity workflows across staff scheduling, shift allocations, dynamic pricing rules, and incident reporting demanded strict relational consistency, secure multi-role authorization, and extensive test coverage. Before a major application change occurred, a large portion of the Staff and Incident Management workflows were automated, requiring the automation suite to be restructured and adapted to the evolving architecture.

Problem Solved

Automated the Staff and Incident Management modules almost entirely before a major application change required the automation suite to be reworked.

02 / Server-Side Architecture

Backend Architecture & REST APIs

Developed and maintained REST APIs using Python and FastAPI. Implemented key server-side foundations:

Technical Responsibilities:
  • Engineered RESTful endpoints handling core operations across staff, shifts, and incidents
  • Implemented secure authentication and authorization controls for different operational roles
  • Encapsulated complex business logic for scheduling constraints and pricing models
  • Built file handling routines for certification uploads and incident attachments
  • Configured event notifications, structured error handling, and runtime logging
03 / Persistence & Schemas

Database Engineering & Consistency

Extensive work with PostgreSQL ensuring schema integrity, performant queries, and disciplined migrations:

PostgreSQL & Migration Discipline:
  • Designed relational schemas and entity relationships across staff, clients, and shifts
  • Applied query optimization and strategic indexing to keep key workflow queries fast
  • Handled concurrent operations and transactional integrity during shift assignments
  • Created data cleanup routines to maintain operational database hygiene
  • Managed schema versioning and zero-downtime database migrations with Alembic
04 / Automated Testing

Playwright Automation Framework from Scratch

Designed and built the entire automated test framework from the ground up to prevent regressions across business-critical workflows:

Framework Architecture & Capabilities:
  • Architected the automation framework using Playwright with modular Page Object Model
  • Authored structured step definitions and feature files for business-level readability
  • Created test utilities, factories, and strict types to standardize test construction
  • Implemented state caching and configurable test-data generation for deterministic runs
  • Automated extensive Staff and Incident Management workflows before restructuring the suite during an application rework
05 / Runtime & Delivery

DevOps & Deployment Infrastructure

Maintained containerized runtime environments, process supervisors, and deployment workflows across development and staging environments:

Infrastructure Operations:
  • Maintained Docker and Linux server environments across development and staging
  • Configured PM2 for node/service process supervision and zero-downtime reloads
  • Integrated automated build and testing workflows using Bitbucket Pipelines
  • Authored shell scripts for deployment steps, dependency updates, and backup management
06 / Architecture Trade-Offs

Key Engineering Decisions

Test Architecture

Modular Page Objects with Configurable Test Data Generation

Decoupling test logic from UI selectors allowed the test suite to remain adaptable and maintainable even when application modules underwent major structural changes.

Database Migrations

Strict Alembic Schema Versioning

Ensured database modifications were strictly repeatable and reversible between local development and staging environments, preventing schema drift.

Deployment Workflow

Shell-Based Staging Pipelines with PM2 Process Supervision

Automated application builds and safe service reloads with minimal downtime and easy rollback capabilities.

07 / Verification & Impact

Outcomes & Key Learnings

  • Automated Staff and Incident Management modules, catching regressions before production releases
  • Established a reusable, scalable Playwright test harness that could be maintained through major application rework
  • Maintained reliable PostgreSQL database schema migrations with Alembic across staging environments
  • Ensured predictable, reproducible application deployments with Docker, Linux, and Bitbucket Pipelines