Implemented a Unified Billing System for a leading Power Distribution Company 

The client is a leading electricity distribution company in Nigeria that serves four states for electricity distribution for a wide variety of customers like Residential, Commercial, Industrial / Maximum Demand customers, and more. The client is dependent on its traditional billing management system for metering, billing, and payments to various customers. 

Key Challenges

  • The existing billing management system wasn’t compatible with the ever-changing compliance regulations, billing models in the utility industry and wanted to upgrade their system 
  • Client faced challenges with the billing system that was based on Progress/4GL and ran on UNIX, which is not futuristic 
  • Furthermore, they had to deal with two different databases for prepaid and post-paid customers 


  • Sparity developed a Unified Billing System that is compatible with all types of spot billing terminals and mobile apps for more than 5 million customers, which includes prepaid and post-paid customers 
  • Enabled the users to access the UBS system even at remotest locations via internet as it is hosted on cloud infrastructure 
  • The angular library was chosen on the front end which offers faster loading than the ASPX front end
  • Developed the web application framework using ASP.NET Core 2. X 
  • Designed web application allows easy access to users’ data and helps quickly generate the bills according to Business Units and regions 
  • Integrated Audit & Risk Management modules into the system to cater the needs of compliance needs  
  • Proposed an approach to view the billing results before actual bills are generated (trail billing) so that any discrepancies crept are corrected 
  • Employed MS SQL as relational DBMS for handling large data 
  • This facilitated the application to handle higher loads of traffic with near zero downtimes and configure out of the box integrations to fully meet requirements  
  • Performed execution of regression suits for the entire application 
  • Prioritized regression test cases and implemented automation scripts through Katalon automation studio  


  • 90% reduction in manual test execution efforts  
  • More than 1.2 million customer data is present in one database, enabling end-to-end reporting with role-based authentication  
  • Implemented Automation Testing to reduce the time, and cost and improve efficiency   
  • UBS system implementation enabled easy reporting and helped identify the loss-making feeders’ / business units 
  • 40% reduction in rework through the better process standardization  
  • 50% improvement in the automation test coverage 

Want to upgrade your billing management system? 

Related Case Studies

Migrating Monolithic Application to Microservices for one of the Big 4 Consulting Firms

The client is one of the Big 4 consulting firms that provide professional services like ...

Ecommerce client cuts time-to-market by 50% with Azure DevOps solution

The eCommerce client is a US-based manufacturer that operates and ships its products across.....

A leading real estate firm reduces API testing time by 60%

The real estate client picked Sparity for carrying out API testing solutions against their API .....

AI based Expert investment advice tailored to your needs

The client approached Sparity intended to automate their manual research process of a qualitative ….

Staff Performance Assessment that empowers and unlock workforce potential

The healthcare client needed to overcome most of the issues found in traditional review methods ....

Superior Asset Tracking with RTLS that saves time, money and effort

The challenge was to improve, both the delivery and the availability, of standard medical assets ...

Transforming the streaming platform landscape with DevOps

The entertainment startup, needed to build a robust architecture platform that could scale to an....

Digital Disruption in Retail through Digital Transformation

The Retail client approached Sparity with an intent to digitally transform their online platform to…