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.
What changed
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.
- 66%less data processing (as reported)
- 80%shorter throughput time (as reported)
- 52.86%lower Google Cloud cost (as reported)
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 this work shows about us.
Reconciliation against the gateway and reports on failed recharges are where a customer's money is found or lost.
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, 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.
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.
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.
Where this work fits.
Facts and figures from the project records; nothing added.
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
An AI agent. This prototype uses prepared answers and sends nothing.
We use essential cookies to run this site. With your consent we also use analytics cookies to see which pages help. Privacy policy