Data Integrity & Performance Analysis

Identifying the Need
 

• Are you confident that 100% of your customers are billed correctly each month?
• Do you feel that nightly processes are running as efficient as they possibly can be?
• Are you faced with data integrity and storage problems?
• What is your confidence level on collections?

KamTech Systems recognizes that the conditions listed above are found in many Utility CIS Solutions and recommends the following components to analyze data integrity and performance of your platform.

Data Integrity Analysis

This analysis concentrates on the following areas:

1. Bill History: Examine the integrity of the linkages between billing history, open items, payments, and adjustments. Also, examine the accuracy of bill history information and orphaned rows.
2. Accounts Receivable: Examine the integrity of the linkages between open items, adjustments, payments, and payment applications. Also examine orphaned rows.
3. Charge Calculation: Examine the integrity of the linkages between service history, consumption history, and open items created by the charge calc process. Also examine any orphaned rows.
4. Unprinted Transactions: Research open items, adjustments, and payments that were created prior to 2009 that have not billed.
5. Uncharged Readings: Research meter readings that were created prior to 2009 that may not have been charged.
6. Payment Balances: Examine the accuracy of unapplied balances for all payments.
7. Open Item Balances: Examine the accuracy of balances for all open items.

The Report of findings will provide details of all records found and estimations of effort to clean up errors found.

Application Performance Analysis

• Analyze and Identify Batch Performance Enhancements: To provide a Banner CIS Analysis of how the Utility Provider can increase the speed of batch processing and improve on their performance including the following:
  • Analysis of current batch processes
  • Provide recommendations on how to improve speed and performance
  KamTech will also provide historical analysis of performance enhancements from our resource and experience library in this area with several other Banner/Customer Suite clients.
• Recovery Analysis:
  • Examine the performance and reliability of the existing fail-over system.
  • KamTech can then provide an estimate, as needed, for other appropriate recovery systems.

Ongoing Maintenance and Support Analysis:

To provide KamTech’s recommendations for the Utility Provider to ensure the performance of the Banner CIS platform over the next 2 to 3 years and assess a recommended strategy for support and maintenance.