Providing electricity and power to its customers, the electric power or public utility industry generates and distributes power all over the world. It is important for homes as people need it to live, along with businesses that use it to operate. Access to these utilities is commonly recognized as a basic right. Reliable usage of these services allows its customers the freedom to drive economic and social development.
Third Pillar was approached by a power company to assist with their issues on data management. Providing power distribution, generation, and retail electricity services, our client needed a way to easily access and manage various customer and account data from their previous solution. With data cleansing, they’re hoping that they can work more efficiently, thus reducing turnaround time, keeping customers happy, and driving business growth.

With the client’s situation, we advised them to perform data cleansing on their accounts, customers, and service agreements data.
We established the following objectives:
- Implementation of an Operational Data Source (ODS) with cleansed master data
- Thorough review of data quality of customer, account, and asset master data
- Cleaning and transformation of customer and accounts data from CIS to ODS
- Establishment of ODS as the main source of master data for customer accounts — with the option for expansion to assets, vendors, and suppliers data as well
In line with our objectives, Third Pillar achieved and introduced the following for our client:
Customer Remediation Page
Effortlessly handle HR processes and collaborate with employees for better talent hiring and development and employee relations and retention.
Active Premise with Tax City
Introduced Active Premise to allow the user in easily remediating Tax City
Premise Address Data Cleansing
Fixed and configured the address data so it can be searched based on latitude and longitude
Account Master Remediation
Empowered users to remediate the bill cycle code and mailing premise in an easy-to-use interface per account
Monthly Report Count
Improved visibility by offering a single view of information and error data report count for the past 6 months
Error Report Dashboard
Created a dashboard that offers a graph view of total error per group per month

Providing electricity and power to its customers, the electric power or public utility industry generates and distributes power all over the world. It is important for homes as people need it to live, along with businesses that use it to operate. Access to these utilities is commonly recognized as a basic right. Reliable usage of these services allows its customers the freedom to drive economic and social development.




What Did Third Pillar Do
We established the following objectives:
- Implementation of an Operational Data Source (ODS) with cleansed master data
- Thorough review of data quality of customer, account, and asset master data
- Cleaning and transformation of customer and accounts data from CIS to ODS
- Establishment of ODS as the main source of master data for customer accounts — with the option for expansion to assets, vendors, and suppliers data as well

Moreover, we improved the way users can view and handle the bill cycle code and mailing premise by implementing an easy-to-use interface per account. We also enhanced their visibility by consolidating their view of information and error data report count for the past 6 months. Through a dashboard, they can see a graph view of total error per group per month.



Syniti – Perform data management using their intelligent solutions to collect and analyze data and insights from their customers.
Power up your business with our advanced and best-in-class solutions. Talk to us by using the contact form below.