2015 Finance & Budget Commission Presentation City of Davis - - PowerPoint PPT Presentation

2015 Finance & Budget Commission

Presentation City of Davis Information Systems Department Jason Best – IS Administrator Robin Canale – Project Manager

Item 5

Information Systems Mission Statement

To provide excellence in information technology solutions and services that will facilitate the vision, objectives and goals of the City of Davis (COD). Our objectives:

• Improve communication between the Information Technology

department and COD departments

• Seek automation opportunities for efficiencies, effectiveness and

customer satisfaction.

• Provide an up‐to‐date online means of accessing City of Davis

information.

In Inform rmation ion Or Organi nizati tion

• n Chart

Chart

IS IS Support Supported Technol hnology gy

Hardware Number Type 75 Copiers and Scanners 14 MDC (in‐car Computer/Cameras) 104 Network Laser Printers 62 Network Switches 425 PCs and tablets 323 Portable Radios 76 Servers 7 Storage Area Networks (SAN ) 30 Wireless Access Point Software Number Type 7 Cisco Enterprise Applications 17 Citywide or Department wide Enterprise Applications 359 End Users Applications 11 Hyper‐V Virtual Servers 36 Microsoft Back Office Application 1 VMWare Virtual Server

IS IS Support Supported Technol hnology gy Mission ssion Critic itical Syste Systems

Applications Owner 3 different irrigation control software packages Parks Arbitrator/DataMax/Dataworks/L3 Police Cisco UCS Phone System City Wide Cognos for Naviline City Wide ESRI GIS City Wide Lucity Work Order System Public Works, Community Services NaviLine for SunGardPS City Wide Noho Child Care Community Services Questsys Document Imaging City Wide RecTrac Community Services RevCord Telco Recording Software Public Safety RIMS (Computer Aided Dispatch) Public Safety Scada and LabWorks Servers Public Works Zoll FireRMS Fire

The The In Inform rmatio ion Syste Systems Budg Budget et Ov Over ervi view ew

Systems

HR $1,283,013 Operations $828,742

Mailroom

HR $61,721 Operations $137,340

Phone System

Operations $61,750

Replacement

Operations $607,800

Radio

Operations $144,764

iNet

Operations $44,936

IS Internal Service Charges for FY 2015/16 Percentage Spread

Dept CPU Laptop Tablets Printer Other Total % NonAS400 CC 3 1 4 0.67% $12,521 CMO 20 2 6 5 5 38 6.38% $118,946 CS 49 6 1 13 4 73 12.25% $228,501 FIN 21 4 11 5 41 6.88% $128,336 FIRE 20 1 12 6 6 45 7.55% $140,857 HR 9 2 2 7 20 3.36% $62,603 DCDS 33 1 1 10 6 51 8.56% $159,638 PD 79 18 12 17 26 152 25.50% $475,783 PW 97 23 4 32 16 172 28.86% $538,386 331 51 43 96 75 596 $1,865,571

ERP System

20% of Dept CPU Laptop Tablets Other Printer Total ERP costs AS400 CC 3 1 4 0.72% $317 CMO 20 2 6 5 5 38 6.85% $3,014 CS 49 6 1 13 4 73 13.15% $5,791 FIRE 20 1 12 6 6 45 8.11% $3,570 HR 9 2 2 7 20 3.60% $1,587 DCDS 33 1 1 10 6 51 9.19% $4,046 PD 79 18 12 17 26 152 27.39% $12,058 PW 97 23 4 32 16 172 30.99% $13,644 Sub Total 310 51 39 85 70 555 $44,027 FIN 21 4 11 5 41 80% of charges $176,108 ERP Charges $220,135

Technology Road Map

HR Payroll Purchasing & Inventory Fleet

Vendor & Banking Fixed Assets General Budget

AP Misc Receivables

GL/GMBA LAND

Cash Receipt Business Licenses Code Enforcement Construction Muni Code Building Permits Building Resale Encroachment Utility Billing

Executime

Click 2 Gov (C2G3)

Parking Tickets

Public Safety

Budget Work Orders Planning & Engineering Credit Card at the Counter Building Permits Online Business License Misc Receivables Account Payment Inquiry

Fuel

External AP Apps

• Questsys
• Childcare
• VoIP Journal Entries
• Print Program Payments
• Electronic Fund Transfers

SUNGARDPS

External Land Apps

• GIS
• Lucity – Work Orders