The URL can be used to link to this page

Information Services Fiscal Year 2024 Budget PresentationCopyrighted March 21, 2023 City of Dubuque Special Meeting P UBLIC HE ARINGS # 01. IT E M T I T L E:I nformation S ervices Fiscal Year 2024 B udget Presentation S UM M ARY: S UG G E S T E D D I S P O S I T I O N: AT TAC H ME N TS: Description Type Policy Budget Book Updated Supporting Documentation Presentation_Uploaded 3.21.23 Supporting Documentation Information Services -1- This page intentionally left blank. -2- INFORMATION SERVICES DEPARTMENT Budget Highlights FY 2022 Actual FY 2023 Budget FY 2024 Requested % Change From FY 2023 Budget Expenses Employee Expense 890,409 1,233,932 1,408,386 14.1 % Supplies and Services 675,184 715,044 731,664 2.3 % Machinery and Equipment 7,329 101,890 47,735 (53.2) % Total 1,572,922 2,050,866 2,187,785 6.7 % Resources Operating Revenue 619,429 612,807 756,465 23.4 % Total 619,429 612,807 756,465 23.4 % Property Tax Support 953,493 1,438,059 1,431,320 (6,739) Percent Increase (Decrease) (0.5) % Personnel - Authorized FTE 9.00 12.00 13.00 Improvement Package Summary 1 of 6 This improvement item would recommend adding a part-time (0.5 FTE, GE-25) Secretary/Administrative Assistant to the Information Services Department. Due to the growth in staff, technology support needs, and workload of the Information Services staff, there is a gap in staff support services, including payroll preparation, budget preparation, processing purchasing cards, and purchase orders. There is also a need for call-taking, council agenda item submission, and meeting scheduling. All the staff support tasks are being done by IS staff that could be better spent on technical leadership and support. This improvement item supports the Council's goal of High-Performance City Organization: Effective Service Delivery. Related Cost:$ 23,683 Tax Funds Recurring Recommend - No Related Cost:$ 2,610 Tax Funds Non-Recurring Net Cost:$ 26,293 Property Tax Impact:$ 0.0103 0.10 % Activity: Administration 2 of 6 This improvement item will provide an additional core switch for the core stack at City Hall Annex. A core switch is a high-capacity switch placed at the core layer (the backbone of the network.) Core switches serve as the gateway to a wide area network (WAN) or the Internet - they provide the final aggregation point for the network and allow multiple aggregation modules to work together. The switch performs the main functions in the network, including but not limited to: central functions such as routing; monitoring/ transferring of data packets; defining the route of destination IP; providing high speed at the backbone; more secure overall data connections internally and on the web as additional buildings, sites and users are added. There are numerous sites, including but not limited to, SCADA, new offices (Office of Shared Prosperity), and Schmitt Island that will most likely max out the number of available ports on the current core. This proposal includes the switch, configuration, and installation. This project addresses the council's goal of high-performance government-network security. -3- Related Cost:$ 16,285 Tax Funds Non-Recurring Recommend - Yes Property Tax Impact:$ 0.0064 0.06 % Activity: Administration 3 of 6 This improvement item would provide security software and tools for conducting monthly scans of our technology environment to show areas of concern and where we need to make changes to better secure our network/systems. The monthly scans would show the vulnerabilities and it would also show if the changes made the month prior have been addressed, giving a clear vision of strengths and weaknesses. This improvement addresses the council's priority of high-performance government network security. Related Cost:$ 4,000 Tax Funds Recurring Recommend - Yes Property Tax Impact:$ 0.0016 0.02 % Activity: Administration 4 of 6 This improvement item would provide an online, course-based learning system specifically geared to advanced technical training and support for IT professionals. The package proposes a course-based solution with a repository of thousands of structured learning classes with secure, hands-on content, including sandboxes, labs, and real-world projects. The courses are updated as technology changes. Some of the immediate priority training needed include SQL advanced, M365 admin advanced, Microsoft Azure management training, cyber security, group policy/active directory, and server/virtual/cloud. Courses could be assigned and tracked through the Neogov system. This improvement item supports the Council's goal of high-performance government. Related Cost:$ 1,200 Tax Funds Recurring Recommend - Yes Property Tax Impact:$ 0.0005 0.01 % Activity: Administration 5 of 6 This improvement item would provide for 3 staff members to attend the 2024 annual user and education conference for the new Tyler software. Travel, per diem, and hotel costs are calculated for 3 staff, and registration is for 1, as our Tyler support agreement includes 2 conference attendance passes. The conference provides training on the Tyler modules the City uses, along with networking with the Tyler team, to address issues that we were encountering at the time and to gather contacts for support depending on the area of expertise. The other beneficial networking is with other entities using Tyler products. This improvement item responds to the Management in Progress under high-performance government - Enterprise Resource Planning (ERP) Software Implementation. Related Cost:$ 8,490 Tax Funds Recurring Recommend - Yes Property Tax Impact:$ 0.0033 0.03 % Activity: Administration 6 of 6 This improvement item provides for replacements of 5 projectors that are either assigned to the IS Department or have come to the department from other departments. All are at least six years old and would be used for presentations and used for check-out for presentations in locations where a projector is not available or as a contingency in conference rooms should a projector or smart TV fail. This improvement item responds to the council goal of high-performance government. -4- Related Cost:$ 4,000 Tax Funds Non-Recurring Recommend - Yes Property Tax Impact:$ 0.0016 0.02 % Activity: Administration Significant Line Items Employee Expense 1.FY 2024 employee expense reflects a 5.00% wage package increase. 2.The Iowa Public Employee Retirement System (IPERS) City contribution of 9.44% is unchanged from FY 2023. The employee contribution of 6.29% is unchanged from FY 2023. 3.The City portion of health insurance expense is unchanged from $1,119 in FY 2023 to $1,119 in FY 2024 per month, per contract, which results in an annual cost unchanged of $— or —%. 4.Overtime is unchanged from $3,513 in FY 2023 to $3,513 in FY 2024. FY 2022 Actual was $3,332. 5.50% Sick Leave Payout unchanged from $4,736 in FY 2023 to $4,736 in FY 2024 based on FY 2022 Actual of $3,539 . Effective July 1, 2019, employees over the sick leave cap can convert 50% of the sick leave over the cap to vacation or be paid out. 6.During FY 2023, the following personnel changes were approved: a.A Law Enforcement User Support Specialist was moved from Police to Information Services (GE-29), resulting in a net increase of $91,739. Supplies & Services 7. Technology Services increased from $643,841 in FY 2023 to $621,102 in FY 2024. The software licenses budgeted are as follows: Sophos Mobile $13,877 $13,877 $ — (b) LogLogic $13,650 (13,650) Aristotle Insight $1,510 1,510 Azure Premium 1 $52,000 52,000 Battery & Environment Monitoring $861 $861 — Cartegraph Licensing $15,780 $15,780 — Chronicall $889 889 Domain Names/SSL Certificate $2,171 $2,200 29 FreshService Licensing $2,461 $15,000 12,539 FTP Site $5,336 $5,232 (104) GIS Annual Support $63,700 $63,000 (700) (c) GitHub Maintenance $306 $306 — (c) GotoAssist $5,280 $2,123 (3,157) (a) GotoMeeting $14,088 $14,014 (74) (a) GoToMyPC $25,412 $11,424 (13,988) Informix 4J's Compiler $604 (604) Software FY 2023 FY 2024 Change -5- Informix 4J's User $4,953 (4,953) Knowb4 $23,660 23,660 Lasefiche Forms $0 — Laserfiche $52,106 $51,739 (367) LastPass Manager $0 — Microsoft Licensing Servers $0 — Novus Agenda $5,800 $5,800 — Office 365 $130,840 $152,026 21,186 Office 365 Manager Plus $3,720 (3,720) Path Solutions $5,700 5,700 PDQ Deploy $6,750 $7,875 1,125 Print Audit $0 $8,070 8,070 Retain Email Archive $34,606 $38,000 3,394 Rightfax $1,808 $2,900 1,092 Ruckus Watchdog Support $2,348 2,348 Mitel Maintenance $8,879 (8,879) Mitel Reporting $0 — Shoretel Maintenance $10,241 10,241 Smartphone Data Plan $1,629 1,629 Socrata Licensing & Maintenance $72,000 (72,000) Solar Winds $0 — Sophos Antivirus/Licensing $30,115 $20,000 (10,115) Sophos Firewall Maint.$4,722 (4,722) Spam Filter $0 $7,778 7,778 Superna- 3 Year 2024 $33,000 33,000 Tyler Data & Insights $29,000 29,000 VMWare $24,303 $23,120 (1,183) $ 544,128 $ 621,102 $ 76,974 Software FY 2023 FY 2024 Change (a) This item was a FY 2023 recommended improvement item (b) This software has been dropped and is replaced (c) Volume licensing provided in FY 2024 (d) Additional licensing was added in FY 2023 (e) Software added in FY 2023 in response to cybersecurity needs (f) Software was added to replace an existing software for less price and/or more features (g) Maintenance has been bundled with another line item Machinery & Equipment 8. Equipment replacement items include ($47,735): Information Services Machinery and Equipment Smartphones (7)$ 2,450 Desk Phones (100)$ 25,000 Recommended Improvement Packages $ 20,285 Total Equipment $ 47,735 -6- Revenue 9. Specialized Services revenue related to department contracts and maintenance recharges decreased from $369,340 in FY 2023 to $327,447 in FY 2024. Information Services uses a recharging system for help desk support, PC set-up, troubleshooting, and repair using service agreements with departments. Recharges are for labor and enterprise software costs allocated based on number of users, number of devices and number of licenses consumed. 10. Central IT Processing increased from $243,467 in FY 2023 to $429,018 in FY 2024. The increase in IS recharges is a result of additional employees hired to support the ERP system and the additional Microsoft365 licensing required for the FY 2023 improvement item of e-mail for all employees. In the Fiscal Year 2023 budget, the Information Services Department added 3.0 FTE (Help Desk – ERP 1.0 FTE, User Technology Specialist – ERP 1.0 FTE and Chief Security Officer 1.0 FTE.) There was also an addition of the Law Enforcement User Support Specialist (1.0 FTE) from the Police Department budget and direct report to the Information Services Department. The Help Desk and User Technology Specialist have a primary role of supporting the ERP system. The scope of ERP support is new for Information Services and is reflected in the associated support recharges for these positions. The Law Enforcement User Support Specialist, Lead Application/Network Analyst, and Intern are recharged 100% to DLEC which in turn splits those costs 50/50 with Dubuque County. The additional position of Law Enforcement User Support Specialist impacted the recharge to the Dubuque Law Enforcement Center. Microsoft365 licensing increased $18,000 for FY 2024 largely due to the addition of G1 (kiosk) licensing for new e-mails. Software for e-mail filtering and retention also showed increases which are needed for any added Microsoft license. -7- INFORMATION SERVICES Information Services is committed to enhancing and supporting high performance government through the effective application of technology, resilient and reliable infrastructure and demonstration of quality of services to our users. SUCCESS IS ABOUT PLANNING, PARTNERSHIPS AND PEOPLE LEADING TO OUTCOMES -8- INFORMATION SERVICES FY 2022 FY 2023 FY 2024 Full-Time Equivalent 9.00 12.00 13.00 Resource and Property Tax Support FY 2022 FY 2023 FY 2024 Operating Revenue Property Tax Support 0 500,000 1,000,000 1,500,000 2,000,000 Information Services is supported by 13.00 full-time equivalent employees, which accounts for 64.37% of the department expense as seen below. Overall, the departments’ expenses are expected to increase by 6.68% in FY 2024 compared to FY 2023. Expenditures by Category by Fiscal Year $ (Millions) $890,409 $675,184 $7,329 $1,233,932 $715,044 $101,890 $1,408,386 $731,664 $47,735 FY 2022 FY 2023 FY 2024 Employee Expense Supplies & Services Machinery & Equipment $0 $200,000 $400,000 $600,000 $800,000 $1,000,000 $1,200,000 $1,400,000 -9- INFORMATION SERVICES Mission & Services Information Services advances productivity and equitable resident responsiveness of department staff by saving time and money through the effective use of technology, supporting resilient and reliable infrastructure and providing high quality services. •Network Administration : Providing secure, effective and efficient use of technology infrastructure and resources. •User and Application Management and Support: Providing high quality, responsive technical support to the City’s 800 users of technology and enterprise application management. •Security: Sustaining security and protection of the City’s data assets using state-of-the art threat protection/response and cybersecurity best practices. •Consultation and Project Management: Providing consultation and project management to new and updated technology projects and initiatives. Position Summary FY 2024 INFORMATION SERVICES MANAGER 1.00 SENIOR NETWORK/SYSTEMS ADMIN 1.00 LEAD APPLICATIONS/NETWORK 4.00 HELP DESK TECHNICAL SUPPORT 3.00 CHIEF SECURITY OFFICER 1.00 USER TECHNOLOGY SPECIALIST 1.00 INTERN-SEASONAL 1.00 LAW ENFORCEMENT USER SUPPORT SPECIALIST 1.00 Total FT Equivalent Employees 13.00 Performance Measures City Council Goal: Financially Responsible, High-Performing Government 1 Dept. Objective: Provide high-quality technical solutions and support services to all users. Performance Measure (KPI)Target FY 2021 Actual FY 2022 Actual FY 2023 Estimated Performance Indicator % Virtual Servers Updated (% updated of total 77 servers)100%N/A 95%97.00% % Overall Up-Time 99% +N/A 99.99%99.99% 2 Dept. Objective: Provide solutions & services that maximize the investment in technology assets. % storage growth N/A N/A N/A N/A # Training sessions/education provided for employees by IS staff 75 N/A 62 60 # Hours planned "down-time" for network maintenance 75 NA 75 75 -10- 3 Dept. Objective: Data assets are safe and continuity of business is insured. % of total inbound intrusions that were blocked 100%99%100%100% % of total inbound viruses that were blocked 100%100%100%100% -11- Recommended Operating Revenue Budget - Department Total 77 - INFORMATION SERVICES Fund/Account/Account Title FY21 Actual Revenue FY22 Actual Revenue FY23 Adopted Budget FY24 Recomm'd Budget 100 - General 4A - Charges for Services 45500 - Miscellaneous Chg for Svcs 0 (285) 0 0 47100 - Reimbursements (318) (300) 0 0 47150 - Refunds (1,921) 0 0 0 47820 - Specialized Services (371,171) (371,171) (369,340) (327,447) 47880 - Central IT Processing (247,673) (247,673) (243,467) (429,018) 4A - Charges for Services Total (621,083) (619,429) (612,807) (756,465) INFORMATION SERVICES - Total (621,083) (619,429) (612,807) (756,465) -12- 6A - Salaries & Wages 100 - General 60100 - Salaries-Regular Full Time 624,629 652,580 884,229 1,007,821 60200 - Salaries - Regular Part Time 531 0 0 0 60300 - Hourly Wages - Temp/Seasonal 14,367 0 28,752 31,602 60400 - Overtime 848 3,332 3,513 3,513 60630 - Special Pay Sick Lv Payout Ret 0 5,227 5,658 5,658 60635 - Special Pay Sick Lv Payout 50% 4,736 3,539 4,736 4,736 60640 - Special Pay - Vacation Payout 1,259 7,426 0 0 60710 - Special Pay - Parental Leave 7,580 0 0 0 6A - Salaries & Wages Total 653,950 672,103 926,888 1,053,330 6B - Employee Benefits 100 - General 61100 - FICA - City Contribution 47,734 48,928 70,708 79,783 61300 - IPERS - City Contribution 60,709 63,585 86,517 98,456 61510 - Health Insurance 98,368 104,256 147,708 174,499 61540 - Life Insurance 448 342 506 598 61600 - Workers' Compensation 1,647 1,195 1,383 1,720 61700 - Unemployment Compensation 0 0 222 0 61992 - Physicals 0 0 0 0 6B - Employee Benefits Total 208,906 218,306 307,044 355,056 6C - Staff Development 100 - General 62100 - Association Dues 0 0 966 966 62325 - Mileage 87 77 285 630 62400 - Meetings & Conferences 469 2,594 2,449 14,470 62500 - Education Reimbursement 0 3,305 12,560 12,560 6C - Staff Development Total 556 5,976 16,260 28,626 6D - Repari/Maint/Util 100 - General 63400 - Equipment Maint/Repair 29,914 45,483 29,924 51,240 63730 - Telecommunications 17,390 7,111 8,879 7,111 6D - Repari/Maint/Util Total 47,304 52,594 38,803 58,351 6E - Contractual Svcs 100 - General 64004 - Internal Service Charge 0 0 0 0 64020 - Advertising 0 411 0 411 64080 - Insurance - Property 0 0 0 0 64081 - Insurance - Liability 3,684 4,306 5,166 6,894 64140 - Printing 0 0 58 58 64145 - Copying 172 53 172 172 64160 - Rental - Land/Bldgs/Parking 2,835 3,690 3,840 3,690 64190 - Technology Services 696,366 601,543 643,841 626,302 64900 - Other Professional Service 6,650 4,450 5,500 5,500 6E - Contractual Svcs Total 709,708 614,452 658,577 643,027 6F - Commodities Recommended Operating Expenditure Budget - Department Total 77 - INFORMATION SERVICES Fund/Account/Account Title FY21 Actual Expense FY22 Actual Expense FY23 Adopted Budget FY 24 Recomm'd Budget -13- 100 - General 65040 - Small Tools & Equipment 2,400 0 0 0 65045 - Technology Equipment 93,158 7,329 101,890 47,735 65060 - Office Supplies 730 1,660 1,404 1,660 65080 - Postage/Shipping 0 0 0 0 65925 - Uniform Purchase 0 502 0 0 190 - CableTV 65080 - Postage/Shipping 0 0 0 0 6F - Commodities Total 96,288 9,491 103,294 49,395 6G - Capital Outlay 100 - General 67500 - Buildings 0 0 0 0 6G - Capital Outlay Total 0 0 0 0 INFORMATION SERVICES - TOTAL 1,716,712 1,572,922 2,050,866 2,187,785 Recommended Operating Expenditure Budget - Department Total 77 - INFORMATION SERVICES Fund/Account/Account Title FY21 Actual Expense FY22 Actual Expense FY23 Adopted Budget FY 24 Recomm'd Budget -14- Recommended Expenditure Budget Report by Activity & Funding Source 77 - INFORMATION SERVICES Fund/Activity FY22 Actual Expense FY23 Adopted Budget FY24 Recomm'd Budget 7701 - Administration 100 - General 6A - Salaries & Wages 672,103 926,888 1,053,330 6B - Employee Benefits 218,306 307,044 355,056 6C - Staff Development 5,976 16,260 28,626 6D - Repari/Maint/Util 52,594 38,803 58,351 6E - Contractual Svcs 614,452 658,577 643,027 6F - Commodities 9,491 103,294 49,395 6G - Capital Outlay ——— 190 - CableTV 6F - Commodities ——— 7701 - Administration Total 1,572,922 2,050,866 2,187,785 7799 - Pcard Clearing 100 - General 6F - Commodities ——— 7799 - Pcard Clearing Total ——— INFORMATION SERVICES TOTAL 1,572,922 2,050,866 2,187,785 -15- C I T Y O F D U B U Q U E , I O W A DEPARTMENT DETAIL - PERSONNEL COMPLEMENT 77 INFORMATION SERVICES DIVISION FY 2022 FY 2023 FY 2024 FD JC WP-GR JOB CLASS FTE BUDGET FTE BUDGET FTE BUDGET 61010 Full Time Employee Expense 100 9400 GE-44 INFORMATION SERVICES MANAGER 1.00 $ 130,163 1.00 $ 149,237 1.00 $ 156,098 100 8650 GE-37 SENIOR NETWORK/SYSTEMS ADMIN 1.00 $ 96,686 1.00 $ 100,629 1.00 $ 105,255 100 8600 GE-35 LEAD APPLICATIONS/NETWORK 3.00 $ 259,271 4.00 $ 347,424 4.00 $ 368,779 100 8500 GE-30 INFORMATION TECH SPECIALIST 1.00 $ 66,299 —$ — —$ — 100 GE-27 HELP DESK TECHNICAL SUPPORT 1.00 $ 49,212 3.00 $ 150,184 3.00 $ 151,292 100 GE-39 CHIEF SECURITY OFFICER —$ — 1.00 $ 85,390 1.00 $ 99,033 100 490 GE-29 USER TECHNOLOGY SPECIALIST 1.00 $ 64,610 1.00 $ 51,365 1.00 $ 59,576 100 GE-29 LAW ENFORCEMENT USER SUPPORT SPECIALIST 1.00 $ 67,788 TOTAL FULL TIME EMPLOYEES 8.00 $ 666,241 11.00 $ 884,229 12.00 $ 1,007,821 61030 Seasonal Employee Expense 100 650 NA-38 INTERN-SEASONAL 1.00 $ 27,854 1.00 $ 28,752 1.00 $ 31,602 TOTAL SEASONAL EMPLOYEES 1.00 $ 27,854 1.00 $ 28,752 1.00 $ 31,602 TOTAL INFORMATION SERVICES 9.00 $ 694,095 12.00 $ 912,981 13.00 $ 1,039,423 -16- CITY OF DUBUQUE, IOWA ACTIVITY PERSONNEL COMPLEMENT SUMMARY FY 2022 FY 2023 FY 2024 ACCT FD JC WP-GR POSITION CLASS FTE BUDGET FTE BUDGET FTE BUDGET Information Services - General Fund 10077100 61010 100 9400 GE-44 INFO SERVICES MANAGER 1.00 $ 130,163 1.00 $ 149,237 1.00 $ 156,098 10077100 61010 100 8650 GE-37 SENIOR NETWORK/SYSTEMS ADMIN 1.00 $ 96,686 1.00 $ 100,629 1.00 $ 105,255 10077100 61010 100 8600 GE-35 LEAD APP/NETWORK ANALYST 3.00 $ 259,271 4.00 $ 347,424 4.00 $ 368,779 10077100 61010 100 8500 GE-30 INFO TECHNOLOGY SPECIALIST 1.00 $ 66,299 —$ — —$ — 10077100 61010 100 GE-27 HELP DESK TECHINICAL SUPPORT 1.00 $ 49,212 3.00 $ 150,184 3.00 $ 151,292 10077100 61010 100 GE-39 CHIEF SECURITY OFFICER —$ — 1.00 $ 85,390 1.00 $ 99,033 10077100 61010 100 490 GE-29 USER TECHNOLOGY SPECIALIST 1.00 $ 64,610 1.00 $ 51,365 1.00 $ 59,576 10077100 61010 100 GE-29 LAW ENFORCEMENT USER SUPPORT SPECIALIST 1.00 $ 67,788 Total 8.00 $ 666,241 11.00 $ 884,229 12.00 $ 1,007,821 Information Services - General Fund 10077100 61030 100 650 NA-38 INTERN-SEASONAL 1.00 $ 27,854 1.00 $ 28,752 1.00 $ 31,602 Total 1.00 $ 27,854 1.00 $ 28,752 1.00 $ 31,602 TOTAL INFORMATION SERVICES DIVISION 9.00 $ 694,095 12.00 $ 912,981 13.00 $ 1,039,423 -17- Capital Improvement Projects by Department/Division INFORMATION SERVICES Project Number Capital Improvement Project Title Department Fund Account FY 24 Recomm'd Budget 7769900002 City-wide comp/printer replac Information Services 190 65045 14,800 7769900002 City-wide comp/printer replac Information Services 301 65045 920 7769900002 City-wide comp/printer replac Information Services 304 65045 545,847 7769900002 City-wide comp/printer replac Information Services 601 65045 11,200 7769900002 City-wide comp/printer replac Information Services 611 65045 45,130 7769900002 City-wide comp/printer replac Information Services 621 65045 9,920 7769900002 City-wide comp/printer replac Information Services 651 65045 21,819 7769900002 City-wide comp/printer replac Information Services 691 65045 14,105 7769900002 City-wide comp/printer replac Information Services 950 65045 6,400 7769900003 Data Center Information Services 304 67500 87,000 INFORMATION SERVICES TOTAL 757,141 PRGRM/ DEPT PROJECT DESCRIPTION FY 2024 FY 2025 FY 2026 FY 2027 FY 2028 TOTAL PAGE INFORMATION SERVICES Business Type City-Wide Computer and Printer Replacements- Business $ 108,574 $ 89,130 $ 92,870 $ 75,524 $ 134,010 $ 500,108 300 General Government City-Wide Computer and Printer Replacements - General Gov $ 561,567 $ 453,986 $ 1,040,987 $ 833,319 $ 824,255 $ 3,714,114 301 Network Security Risk Assessment $ — $ 15,000 $ — $ — $ — $ 15,000 302 Fiber Optic/Conduit Asset Maintenance and Documentation $ — $ 50,000 $ — $ — $ — $ 50,000 303 Data Center $ 87,000 $ — $ 297,000 $ — $ — $ 384,000 304 TOTAL $ 757,141 $ 608,116 $ 1,430,857 $ 908,843 $ 958,265 $ 4,663,222 -18- INFORMATION SERVICES FISCAL YEAR 2024 BUDGET PRESENTATION MISSION STATEMENT Information Services Department Information Services is committed to enhancing and supporting high performance government through the effective application of technology, resilient and reliable infrastructure and demonstration of quality of services to our users. New Faces + New Places Insert Image Here IS Interns Daniel Ruiz and Nikesh Shah User Technology Specialist Jacob Hoffman Law Enforcement User Support Specialist Ann Cummer Network Administration Cybersecurity Public Safety Support Enterprise Support Functional Areas of Information Services Support Chris Kohlmann Information Services Manager Vacant Chief Information Services Security Officer Joe Pregler Senior Network Administrator Tony Steffen Lead Application/Network Administrator Stacey Moore Lead Application/Network Administrator Alicia Turnis Lead Application Network Administrator Ann Cummer Law Enforcement User Support Specialist Nikesh Shah Intern Scott Schlichte Lead Application Network Administrator Jacob Hoffman, User Technology Specialist Patricia Munson Help Desk Technical Support Vacant Help Desk Technical Support ERP Vacant Help Desk Technical Support Daniel Ruiz Intern Information Services Department (13.00 Full-Time Equivalents) Network Administration Cybersecurity Public Safety Enterprise Digital Equity Affordability •FY 22 341 Households Served •FY 23 681 Households Served •33% of those visiting the site sign up •$244,800 aggregate annual savings ($30/month/household) Broadband Partnership Impact On Dubuque Increase availability and affordable bandwidth and redundancy through public- private partnerships Leverage Network Investments Fiber Optic to the Home (FTTH) Broadband Partnerships Defined •Work with the private and public sectors to analyze and communicate “last mile” fiber optic and conduit capacity that already exists here in Dubuque; •Identify additional expansion, services and competition that may be presently under consideration for the Dubuque area and form a team to work quickly to identify how those efforts can be supported and additional investment made more feasible for the Dubuque area; •Create a collaborative process between public and private sectors to identify regulatory process improvements and infrastructure assets that could be available in Dubuque for projects that provide value to the community through enhanced access or reduced costs. Broadband Partnerships Broadband Partnerships •Partnership with GDDC, Engineering, IS and Legal •Over 60 Agreements with 18 Providers and Partners •Resulting in a leverageable network investment of over $10 Million •Fiber to the Home (FTTH) FISCAL YEAR 2023 HIGHLIGHTS Resiliency Equity Fiber to The Home 2022 Builds •Number of Cabinets 8 •Number of Addresses Served 3915 2023 Builds •Number of Cabinets 22 •Number of Addresses Served 12,500 239,059 ft Aerial Fiber 295,240 ft Buried Cable Proposed Fiber to the Home by Cabinet Data Security •Cybersecurity Prevention and Awareness •Hiring Chief Security Officer •Upgrade of Firewall •Replacement of Core Switches •Backup and Replication •Security Audit •Researching Physical Location for Data Center •Researching Implementation of Co- Location and Disaster Recovery Site FISCAL YEAR 2023 HIGHLIGHTSResiliency Equity High Performance Government Technology Solutions FISCAL YEAR 2023 HIGHLIGHTS •Application and Support ◦ERP System Implementation ◦Finance/Budget ◦Office365 ◦E-Mail for All Staff ◦Advanced Azure Management ◦FirstNet Public Safety Communications ◦Axon Body Cameras ◦Replacement Cycle of Hardware ◦Work From Home ◦Support Ticketing and Issue Tracking ◦Hiring Help Desk Support (2) Resiliency FUTURE INITIATIVES •Broadband Public -Private Partnerships ◦Fiber to the Home ◦Digital Equity Initiatives ◦Extension of Fiber to 200+ Sites (ARPA) •Application Support ◦ERP System Implementation ◦HRM ◦Utility Billing ◦Office365 ◦Public Safety Software Replacement •Network and Cybersecurity ◦Security Risk Assessment and Response ◦Zero-Trust Security Architecture ◦Disaster Recovery Implementation Information Services Department FY 2024 REQUESTED PROPERTY TAX SUPPORT $1,431,320 $20.71 Net Property Tax Support Request Average homeowner’s* property tax cost for Information Services (*Avg. home value of $159,503) FY 2024 RECOMMENDED IMPROVEMENT REQUESTS 1.Additional core switch for the core stack Non-Recurring | $16,285 2. Security software and tools for conducting monthly scans Recurring | $4,000 3.Online, Course-based Technical Learning system Recurring | $1,200 4.3 Staff to Attend Annual Tyler ERP Conference Recurring | $8,490 5.Replacements of 5 projectors Non-Recurring | $4000 Project FY 24 Cost Total Cost City-Wide Computer & Printer Replacements –All Funds $670,141 $4,214,222 Network Security Risk Assessment $$30,000 Fiber Optic Documentation and Maintenance $$50,000 Data Center $87,000 $384,000 FY 24 CAPITAL IMPROVEMENT PROJECTS Information Services Department PERFORMANCE MEASURES Information Services Department THANK YOU www.cityofdubuque.org/422/Information-Services