Ensuring accurate data to provide confidence in your decision making
Our staff have analyzed customer, financial, and regulatory systems using “Forensic Data Analysis” concepts to identify opportunities for data cleansing, process improvements, and system upgrades that can restore confidence in the organization’s information. We have successfully identified system configuration errors resulting in millions of dollars in annual losses, have uncovered unallowable behaviors by temporary utility staff resulting in the prevention of collections enforcement, and have identified billable customers not receiving bills for services. We work to pair audit findings with recommendations that can be rapidly implemented to prevent further financial losses.
In many cases, doubts relating to information originating from key utility systems are not caused by the source data, but rather by the reporting mechanisms employed to extract the information. Raftelis staff have the ability to review reporting logic in a variety of programming languages and systems to ensure that the results of reports reflect the desires of utility decision makers. We have rewritten reporting logic for metrics as seemingly simple as the number of billable accounts, to complex financial reports used to support bond purchases or regulatory requirements. Our staff have also created data warehouses to support performance metrics and reporting needs that are not natively supported by a utility’s standard information systems. We can help restore staff confidence by providing objective analysis of your key reports and information systems.