Products
Enterprise class ETL system
Our consulting team developed technological and innovative solutions that made it possible to implement a corporate-class ETL system for processing and managing the debt base of utilities payers in the activities of LLC GERC Ukraine.
The used approach has a holistic view of the data and provides reliable information, regardless of the form of its storage and presentation.
Tasks that can be solved by ETL GERC:
Uploading data: bringing all data from external sources to the Unified System of Personal Accounts of Payers, ensuring their quality, reliability and credibility (uploading to temporary tables of the debt base, checking data for compliance with specifications and the possibility of further uploading to the unified data storage of GERC);
Data analytics: transformation of data on payers' personal accounts according to the established rules of GERZ data processing;
History audit is reformed.
GERC processes over 7.5 million utility personal accounts and aggregates them into 2.3 million unique flats, allowing the citizens of Kyiv, Odessa, Lutsk and other cities in Ukraine to pay for the "flat" rather than a single utility bill.