IT DSP Findings & Recommendations

Findings and Recommendations City of Berkeley: Digital Strategic Plan and Cost Allocation Plan

October 17, 2016 v5.1

Reports:  Single Audit Report  Grant Reports  IDC Report  State Controller Report Interfaces:  FUND$ or new ERP System  OnBase Enterprise Content Management System  Business Intelligence tool Benefits:  Save staff time.  Improve the coordination between Accounting and City departments.  Allow staff to focus on other important projects simultaneously, e.g., external audit.  Improve the overall quality of the finance system.

D SW 4

Public Works RealQuest Enhancements [18] Findings:

The Public Works Private Sewer Lateral Rapid Workflow ® workshop revealed that RealQuest does not have phone numbers for property owners. According to City staff, this results in:  The inability to find property owners.  The work does not get done. Recommendations:

 Explore if RealQuest can provide phone numbers.  Have RealQuest data uploaded more frequently.  Establish one customer database. Benefits:  Improved staff efficiency will improve staff time savings.  More work will be done.

D SW 5

Public Works Refuse Billing Application [12] Findings: The Public Works Refuse Billing Rapid Workflow ® workshop revealed that the process has numerous challenges:  Accurately identifying the service location.  Not getting reports with useful data for decision making.  Lack of baseline standards for customer start of service.  Lack of a sufficient level of detail in the billing statements: e.g., correct quantity of service level and service dates.  Route books lack appropriate information.  The Truck report is a manual process, labor intensive and truck reports lack real time information.  Inefficient process in closing cart delivery Lagan cases.  Lack of handheld devices for field staff.

Digital Strategic Plan: Findings & Recommendations

© 2016 50 ThirdWave Corp 11400 W. Olympic Blvd. Suite 200 Los Angeles CA 90064 310.914.0186 V 310.312.9513 F

Made with FlippingBook HTML5