unthinkable
Case study · Utility payments platform, Nigeria · electricity, cable and broadband in 8 cities

Power companies see failed and delayed recharges as they happen, so customers' payments do not go missing.

The platform wanted every customer's electricity payment to go through and be accounted for, and its power company partners to see how well they serve their customers.

Nigeria

What changed

66%less data processing (as reported)
80%shorter throughput time (as reported)
52.86%lower Google Cloud cost (as reported)
What stood in the way

What stood in the way.

What stood in the way
  • Power distribution companies using the app needed reports on usage, payments, new users and channel efficiency, and the platform lacked the data engineering team to produce them.
  • Analytics were slow and costly: each refresh processed nearly 4 GB of data.
What changed
  • 66%less data processing (as reported)
  • 80%shorter throughput time (as reported)
  • 52.86%lower Google Cloud cost (as reported)
What we built

What we built.

  • ETL pipelines in BigQuery with partitioned tables refreshed hourly, cutting each refresh from nearly 4 GB to 129 MB.
  • Automated reconciliation of the accounting figures with payment gateway transactions, including chargebacks and reversals.
  • Dashboards for cohorts, failed payment attempts, time to resolve payments, customer service calls and failed or delayed meter recharges.
  • Detailed views for the finance team down to changes every few seconds, using Datastream, BigQuery and Data Studio.
  • Google Cloud Datastream
  • BigQuery
  • Data Studio
  • SQL
What it shows

What this work shows about us.

We know where a payment goes missing

Reconciliation against the gateway and reports on failed recharges are where a customer's money is found or lost.

Data work that pays for itself

Partitioning and better queries cut the cloud bill while making reports hourly.

Want similar data engineering and reporting for your payments app? Tell us what you want to change. Our AI assistant, Ask Unthinkable, helps you define your requirements, then connects you with the right team.

Start your plan ↗
If we built it today

If we built it today, with AI.

This work came before today's AI. If the Nigeria-based utility bill payment platform asked us now, this is what we would add, step by step.

A failed recharge

An agent would spot a customer whose payment went through but whose recharge failed, tell them what is happening and raise it with the power company. Refunds still follow the reconciliation rules.

The monthly review

An agent would write each power company's monthly summary from the dashboards, pointing out channels and areas where failures rose. The companies decide what to change.

Related

Where this work fits.

    Facts and figures from the project records; nothing added.

    Ask Unthinkable

    Want this for your business?

    Tell us what you run or what you're building. Our AI assistant, Ask Unthinkable, helps you define your requirements, then connects you with a senior AI engineer.

    Send us a note instead

    Required

    Thanks. A senior AI engineer will reply to you.
    u
    Ask UnthinkableClarity first, then the right team
    Your conversation

    An AI agent. This prototype uses prepared answers and sends nothing.