Loading...
HomeMy WebLinkAbout08.a EDB ERP Board Briefing Final EXECUTIVE SUMMARY AGENDA ITEM: Enterprise Resource Platforms (ERP) Project Update Date: May 3, 2024 BACKGROUND: The new CCUA customer account platform with SpryPoint went"live" on Monday,April 22nd . CCUA's new platform includes additional payment options and enhanced user-friendly navigation with secure and efficient transactions. We communicated our messaging campaign through the created content in messaging, social media, websites, news media, posters, hand-outs, and bill mailings to engage our customers during the ERP transition. We will continue messaging customers to address any challenges or issues that arise during the transition. Given the shear size and complexity of this transition of information systems,we consider the deployment of the SpryPoint customer portal successful. Customers are responding and registering their accounts.As of Thursday, May 2nd, the number of customers who activated their accounts in the new customer portal is 7,543 (17.7%). In addition, we observed an increase of the total AutoPay customers by 1,141 accounts. To date, we have encountered three (3) significant issues. The first issue, discovered on Thursday, May 2nd, pertains to the mismatching of previous customer account numbers to the new customer account numbers. We understand the likely cause of the issue was a data transfer between SpryPoint and Invoice Cloud. Currently, this issue affects roughly 600 customer accounts and the application of payments. We continue to work with SpryPoint and Invoice Cloud to resolve this issue. The second issue deals with reconciliation of transactions. We understand this issues centers on how data is transferred in summary form between the different platforms. Likely solutions to this issue involve transmission of additional transactional data tags such as tender type, etc. The SpryPoint team indicated they are working to resolve this issue. The third issue involves several anomalies in meter reading data. The teams working on this issue think the anomalies originate from multipliers and reading truncation in the legacy data. The issue was discovered in a new format file from CCUA's Advanced Meter Infrastructure (AMI) vendor, Sensus, in recent weeks. The technical teams are focused on resolving this issue as quickly as reasonably possible. Currently, we perceive the biggest complaint is the $1.50 charge for processing e-checks. Customers do not understand this charge comes from the banks, not CCUA. In implementing the ERP project, we recommended,and the Board of Supervisors approved passing the$1.50 bank charge to customers directly to encourage customers to sign-up for the Autopay feature. CCUA receives a benefit by processing Autopayments in bulk at one time to reduce labor costs, not the bank charges. //JDJ(Author) //KO/AB (Review) //JDJ(Final) The remaining issue is we continue to experience high call volumes for assistance to register in the new customer portal.At times, all our phone lines were occupied with callers who experienced significant wait times. To address this issue, our team redirected team members to assist the Customer Service and Billing Department. Staff indicates the trend in the volume of calls and emails is downward indicating positive movement to the new customer portal. The Board of Supervisors approved the suspension of disconnections for non-payment from March to May 2024 at the December 19, 2023, meeting as a risk mitigation measure. As we work through the technical issues, staff requests authorization to extend the suspension through June to mitigate issues related to customer payments and reconciliation issues. We would resume disconnections for non-payment in the month of July. For customers who are behind in payments, we would use the procedures during COVID to work with customers in establishing a payment plan (not to exceed six months) to bring their accounts current. Our team continues to progress in the Workday environment. We have successfully run two (2) payroll cycles. Our operations, procurement, and inventory management team continue to work through challenges related to existing processes and Workday system capabilities. We recently experienced an issue with payment to vendors. Based on information we have so far, we believe the payment issue rests with the bank, not CCUA's Workday system. Workday performed as designed along with a confirmation of the transaction by the bank before the bank lost the transaction information. Our team is close to a resolution. RECOMMENDATION: Staff respectfully requests the Board of Supervisors approve the extension of the suspension of disconnection for non-payment through June. //JDJ(Author) //KO/AB (Review) //JDJ(Final)