Project Overview

I designed and implemented a billing system that improves visibility into payment issues, identifies common causes of revenue loss, and introduces automation to prevent recurring problems. The work began with a structured manual process and later evolved into a fully automated system that monitors usage and enforces billing rules in real time.

Objective

To build a reliable billing system that:


Technology Stack

Category Tools
Languages Python, TypeScript, SQL, YAML
Cloud & Database Supabase (PostgreSQL), Edge Functions
DevOps GitHub Actions, Git, VS Code
Operations Jira Service Management, Kanban

Part 1: Billing Operations Foundation

Billing issues in SaaS products often surface only after a customer is affected. This project focuses on changing that pattern.

Phase 1: Centralized Tracking & Standardization

Action

Centralized Billing Log

A single tracking system was created to capture all billing-related issues, including failed payments, usage overages, and customer disputes.

This replaced scattered records and made it easier to see patterns across all billing activities. Issues were grouped into clear categories such as authorization failures, expired payment methods, and invoice discrepancies.

Outcome:

Improved visibility into recurring billing problems and early signs of revenue leakage.