The URL can be used to link to this page

Information Technology Fiscal Year 2027 Budget Copyrighted April 15, 2026 City of Dubuque BUDGET PRESENTATIONS # 2. City Council ITEM TITLE: Information Technology Fiscal Year 2027 Budget Presentation SUMMARY: SUGGUESTED DISPOSITION: ATTACHMENTS: 1. Information Technology - FY27 Budget Presentation 2. 27 Policy Book Volume IV - Information Technology Updated Page 1253 of 1455 �� . — �- � . � � 1 � t r` � 1 .:r � , • � • � - � .,� � - -, ;�. � ,- � , _ .��al � . . \. , . � . �: • ,�' \�� , � � � �. � � � � � • . . � � � � . -_�� . - Page 1254 of 1455 Information Technology Department Information Technology 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. Page 1255 of 1455 ew aces �,_- � � � � ` om � �: � C - Help Desk Technician (ERP) - Abby Gordon Chief Information Security Officer - Timothy Krieger Information Technology Intern - Landon Smith Information Technology Intern - Sneha Paudel Page 1256 of 1455 ew aces n ew aces � �_ � � � � ` om � �: � C - Administrative Support Professional - Anne Schreyer GIS Coordinator/Analyst - Nikki Rosemeyer GIS Special ist - Jacob I ronside Data Analyst - Braden Daniels Page 1257 of 1455 • . • - • • • � - � , - - • , - Chief Information Officer Joe Pregler Chief Information Security Offi Tim Krieger Administrative Senior Network Senior Network Lead Lead Lead Data Analyst GIS Coordinator Su ort System System Applications/Net A lications/Net Applications/Net Braden Daniels pp Administrator Administrator work Anal st pp work Analyst Analyst Professional y work Analyst ' Rosemeyer (Shared .20 FTE) Steven Puls Tony Steffen (DLEC) Alicia Turnis Supervisor Anne Schreyer Stacey Moore Sco 'chte User Technolog Hel Desk GIS Su ort S eciali p Specialist pp p hnical Support Jacob Jacob Hoffman ctor Hernandez- Gutierrez Ironside User Technology Support Speciali Ann Cummer Help Desk GIS chnical Support Technician Information Abby Gordon Intern Technology In Vacant Landon Smit Help Desk chnical Support Information atricia Munson Technology Inter Sneha Paudel -..- : . - Prior Year H i h I i hts g g FISCAL YEAR 2026 HIGHLIGHTS .,- - � `V ■ ■ � \ +',�1 � i `� � _h � _ �_ • 911 Ce nte r M ove � , � � _�_ �;�- . � - 1 • W� reless Replacement . • ERP Emplo ee Access � _ ... . � y � • M icrosoft Co i lot Im lementation .-- - � '� � p p .�.� Public Safet Software � ��-� _ • �` �� y . .�-�� : � ,� .�;n- � c r � �� • IT/De artment Mana er Meeti n s � �� " � p J J k • C bersecurit tar eted trainin and - � � �` ` y y g g o l i c rev i ew � � � ��- p Y � ; .� • WRRC and Water Upgrades to network connectivity of remote IO��'O�� Page 1259 of 1455 � � HRIS (Human Resources Information � • System) Software Implementation � � � Public Safety Software Go Live � Software Audits • Sharefile FTP usage audit • PDF usage audit • Sharepoint/Teams audit • Tyler finance, budget, payroll, time and attendance, utility billing, payments, RBAC, workflows efficiency audit • Catalis CRM efficiency audit � IT Asset Inventory Deployment � Increased AI adoption Page 1260 of 1455 • . • ' • • • � ■ ' � . ' � ; � - - - � - 2 135 410 33 . 43 ' ' Avera e homeowner's* Net Pro ert Tax g p y ro ert tax cost for Su ort Re uest p p y pp a Information Technolo JY (*Avg. home value of $196,508) Page 1261 of 1455 1 1 � ' � �' � � � � � *�. Page 1262 of 1455 ■ ■ on � nue as � cs roac • National guidance (Federal, State and . :,: ;�; National Organizations) emphasizes � �' � , basic cyber hygiene as the top priority. � - , - � Multi-factor authentication � Regular patching and updates � Backups and disaster recovery read i ness � Endpoint protection and secure configurations � Staff cybersecurity awareness training Page 1263 of 1455 u r ar ners ��y & �n►F �ART � �� Rqs� ,�� -�?.�� p Center for y�G _ �G � ?, Internet Security� ,l� ;i ,I`� � m c�c '�� Q,,� � �c � � �o � � : �+ ,x � � /�,,� �,, ,� � � I C I N �� o � � MS-ISACA' ,' ; �. � � � s+ Gy �� ,��' Multi-State Information �cUR�TY pG�� `�ND $�G Sharing & Analysis Center�' • �-�ED S Tq�, � J� Fs . � ��1►� � � � < z - ' �o � Office of the �� T�i / ` O Q � t�°� �j�t,,��:, �� 2 � Chief Information Officer �'F ��° lowa De artment of Mana ement 2�'q �� p g � � PRO� Page 1264 of 1455 ■ ■ ■ ■ ev � ew o ersecu r� o � c � es • Ongoing assessment of � � current cybersecurity o + policies, procedures, and � controls. 0 • Aligning our practices with � :�, • state and federal � + frameworks and industry standards. c - • Identif in a s and � � PRIVACY POLICY y gg p prioritizing projects based o on risk and impact. + ° � Page 1265 of 1455 a ere e ense ra e • No single tool or policy can stop all threats. All layers need to work together. � People: training, awareness, , and responsible access. , ; �, � � � Processes : policies, t . . . . monitoring, and incident response plans. � Technology: firewalls, MFA, backups, endpoint protection, network segmentation. Page 1266 of 1455 a ere e ense ra e con . . . • Layered defenses reduce impact, slow 0 0 o attackers, and give us 000�0 time to respond. pppp� � � • This a roach , � �� p p � pppp0 ° O im roves resilience p I pppp0 0 o while making the best 0 0 o use of our resources. 000�0 � ' I Page 1267 of 1455 • - - • Strengthening our Federal , State and Local - partnerships � . . • State and Local Cybersecurity Grant . . Program (Applied avg value $ 11 ,500 in pass-through services ) • Pol icy and Practice review • Increase Visibility on our IT environment • Continued Cybersecurity trainings • Focused in on Departments • Reducing risk and exposure across all city departments • Network Security Risk Assessment Page 1268 of 1455 1 1 � ' � , � � � � � DATA GOVE RNAN C E & ARTIFICIAL INTELLIGENCE Page 1269 of 1455 ■ ■ ■ a a overnance n � � a � ves • Working towards Results for America What Works Cities Certification � Building an Open Data Hub � Developing a Data Inventory � Establishing Data Classification Standards • Launched "Data Rockstar" Shout Outs • Ongoing Training/Education on Data Tools and Best Practices Page 1270 of 1455 n�e crtv oF DUB E Monthly Copilot Interactions Masterpiece on the Mississippi 10K Initial peak in Oct with live trainings Average 11.3% monthly increase since Dec 8462 8244 8K 7639 7818 6979 408 c 5997 0 �- 6 K � �o L Q1 •..r � r..i � Dip after trainings into Nov/Dec .� 0 U � 4K 35 o FY26 Rollout H 2K 1793 3 OK Jul 2025 Sep 2025 Nov 2025 Jan 2026 Mar 2026 Months Page 1271 of 1455 Uu:' ��, 'edge Sagr. �'e San =ritl'� Sour r ac Budd � � �. �.F • o � � 1 � � �_�e _��— �\ � -=- —� 5 a� � - � �� D� : q� �. . � � � � � ti; fi�_�: ' �� C ��. 61 /," _ . n.�buque -. ---— � - 20 GEOGRAPHIC - entralia 5 ,t,��n c.e .c s�..•_ _ I N FORMATION � � ��t. 52 n^ SYSTEMS GIS & �� 5Z � MAPS OFFICE 61 o�:�;^lough � _ ,'D��i:�,y�,� �W��i � , - �„ i, i , v i Page 1272 of 1455 Current Activities - Tree Inventory ■ ■ ` � ;' ' � .,, , � _ � `,i'�,� '�., �' a.. '.,, ��..,. � Eastern � �..=` ?� � � r � � R ed -''r �/� .�'`'' 4 s ' � � � ' Cedar%Ginkeo \✓� �`.� , 5ibrer h1� � �� -� � - �'�-'� K5�1 1 �� " � � ��,�� f �•�' __ � � — Chinkapm ['�::.: ` �f , ,� ` � �- ",�/� . l i �_�T�A� Eastern k ��\� �,; i � ,_ �� i' � �r .'.�;�� E � _'�, R��YCed�r � � Si� '� - � "�4� .. � I.��. t� `�� ,�,.-� � i. . �. �,;., . � , � .c,i I r , _�;_I �� - l:,r��ra1' 'v�ap r .; .�� - � � _ _ r �" ;,�� ...._ B��i C'vl-'�"1 � , � x F , �: .. i r . � . ''�. i �,,: � �` r. Norv��ay PA\le, �'��- , '`��. ';� . � '' � � '� ��_ , � R�. �,�� - � A'�'� 1 Bald C��press , �r ',,� : ��f, � t� �"_' ,� � �E . . , � �� r,�,-r,,t„tv13ple ``;�' � ''w# ` `ti �j�S `' - � '� ,o► _� �� - - ,,.,t_ Green � � a.` �d�_ �� ri Ash Ash �/�' � q,�_ .�n/"�''�l ,, r' `� . . ..* f� � �+� � � ' • �'��^ � � ,�" .� +;rr � - � Nr�ieru_.i� � �� +'�� `� �F � � �, -c;,�► -.� y�' « ..4 ��,��. �• , ,�� Greer�Ash``�I =t� ��,�` r �� - � -� y,�,." �` � ,� : :,` ksh \Hone L st .r i J. � ►' ' � �~�°� " �' � � N � �,'��,, � - '� ITt i�.�' , 4r +►'� ' �� , `�1��1 � ��'�I�� ,. l�- �J�r'h�fn �;�.`r$ a��1' i� .."F �' - -.. +�, � .��,'.�k�,.Y,�}( �! .�.r;� -'I :Ck�'i�id�IlUt ��d�ll��. Vf2Bf1.N5h � �H�: 'r:�eCf��y��•• f *�j-.,�e�,. Qs.,, , � ��,..'� . k 3' "7'1..�-��a� � � � � � � M.' �� .;9�'z� n �: ,r� glack 1Nainut Kentu N,d� ,, Fj PvRapi„ �� r�b�� s .� " "� �f.s sk'Ey; . �� '��' f � �{ � ,� fi- ';�i`eetr�c '�_ k r ' 'w v }T � � + Northern Re� , ' 1 �;; , , �;t+« _ �� > 1 Gree�n Sileer S I rr Pv`r�� .-��+- 1 ,�. �r '� �Ash ''�"�i �. ^�� _�► ,�� ..�.�,;,��-!" �s` .�^ ,�`_r_`, , µ ".r � ,�en Ash Oa`k Green Ash Pu a I� � �' 1 ��•� �'� � �'' N�rth=rii �� " � �,;< � '�('� - ��' ' ��- ��"�'� _ .. Shagbark J�`i �;.,, :#-� N�rthem Hackberry � . ' Y � '�� ;�: � �� i�_4. I�iU? � � � HiCkory H3ckhi i� �"c, aa�t �� ; � �.. �a=.� � Green Ash•_- � ' •��'�r . � �� i � - � Hune,� Locu �� ' . L r ;� � , }�.. �stem n,lurtli�r�� Hackberry ' �r _��+' ' a M��"�y' F��;ihud �►v ` r Ls�, ..�. -_ �"',�?'�: �� ,. T � Swamp ;'�lhi �ia�. �-I�r��;;h„rn y � � � , I n,rmanii � - _�� . ��` �� • �',~ PJlaple Hnne Locii t ii� - � � � �'� �r: � � �� ; � � l ` '1�' `�r -� � li 3uckeye '�r i-��Fi � ,':�I� �� ;I; + � y '' r ��--� r � - ' ,�►�"""` '� � ►, -.:� r��' � s �1 itternut Hi�k._ry, ,� , � . „ ,-:h,nkap+n �i_�b + ',�,;J� � �+ _� _ � • � ,st2rn White Pi •k 1 i J' !� f' --� . l��,�... �� , r:�reberr�;` �- f , � _��_� �� riMaPle � � ✓ _..� Page 1273 of 1455 Current Activities - Refuse Collection Inspection ■ ■ __ � _,�..,m�.�! - - � � �,�- - � _ � , r � i ��+y`�� .� _ �. � i r Y�� .I�al� r: + �l �;_4n,•^�, � �. �y��r�i� � ��.�' -e1 - _ r- �� .,��c4. l.;Y��. - -. ... L ��A� � �� t►'�� ►'-� s F! /`,� ��1.� ° w�rl �. �.." � � ,� � ♦��'� 'r Y'� �i�� "��ii�a , � � .,. . �� , ,�` � ., .._.. � '� ,�� •� ._ _ ._..__—. _ .— --- r `;�'.t' �r �. ' - - _-.__ --. , � `-. . � '� ,'M �'.��',��.-., — 1.�.� .�. .��-��,,r �, d � e,��r��a,��,, � �. � � ,�'-� ••-• � . � ' '� - � . • _�+�� r � \ "� _ .� _,.� �, �, _r _ , ., "_,. .« �.,��,,,_ �_ ��_ , I'� � � _.- �� . - �� '' �� " '�, �ii;i Q � �, - , ,. .__ � ��y _ i � �� Y �Crt �� , �v,'f5s�_ �� . �,_� �ie��'� I '� � — � �c.. � av-�r:,eso, oeie3 ,.ne.iz,00nm o. . .� � �'r .�, ' `�/� `C�/�L��.�� a � ��,t � .. - � � � �� 1�� ` �'� . �98MA1TAIRCT 06040 22J/26,12QOAM Basc35GalanCen 0 frday'�J �4�'- � ..�.� � �` 1 1 � "L� � �I � � ��i�i�'��';� I �.._:�.r+S�(�.. .� ■ v981NDIPNRIDGC 06�92 2/2)26,1200AM Daac35GallonCan 0 friday .�.... I ��,� , � . ;,i � � r L�lr�.c:� U�.li�' -.. �,o � .o a�MOHrnvc �o�e� vvrza,�zoonM e- 3sc� c o r,�a,r .... � J� �wx t,iy •yl �1� I�I'L �;�,o� �� \ t'�� -_ -�isr on3o aivzn�z-oonM o�-as��i c � o TM��ar -� -r . __ 1 ` �.... -- � �� .. �4��c'GY'.r+_ .�� !��.� a��'��. � . -�x(ORDST 15608 3/�2612:OOAM Basc35GallonCan 0 T�u�s�ay �._. � . I� �� %� i MS�,,�Y��1�,� ` �4r � �/:'Jib.�� 1.k� , � -I , f'. ��1 u1"r , 1 a�� 1 r- � fl � , .�':.JqST 15691 3/526.12:O�AM Bas�35GalanCan 0 Thursday ��. � �� 1 �,�_�--1— _ ��. r,y� � - . JY �� Y�I '� �I � -. i..�CL'+DP 20686 2/2J26.12:OOAM 48GaIlanGrt 0 Friday . , 4� I � /� / :o'`�.r WW.ti�ivTr�� r ■ ?9>CLNEIANDAVC 10609 2r2)R6.1200AM 64Gallui Cen 0 FridaY _...-.� a T� �'�J.� O , - -�� ` �l s�, � � ��'i I ■ .c�i�TI I ST 09231 3/526.12�OOAM 48 Gell��i Cart 0 Thu�sday _ . -�y ��' -' � +" ' - ST �09]) 22426,12QOAM Basc35GallonCan 0 Tuesday - � �_ '� �3 � �:I. -... . . . . ?c 1 �� r � .'�� ST p4058 3 9 26 2:00 AM 64 G-I n Gn 0 Monday � �R � � � � �gS�N 1)346 3/5/26,12:OOAM 8�-�35GaIlu�Cart 0 Thunday � ' � . OOD St �. ■ .+5':"��CTORIAST OSJ92 2/2)26.1200AM aBGallonCan 0 �riday . . '_ ( � � � � '-��ARDSRO 20)IS L2)/26,1200AM 6 �-35G-IlonCan 0 friday �� .�� - f� � • i� ■ . :I�:C�P�IILLIPDR OS)62 2/2)26,1200AM B � 35GaIlonCan 0 friday .. , ./� r � �v�N[VqpASf 15692 3/5/26,12:o0AM Baz��35GaIlonCan 0 Th��v1ny � � . ?95MAVfAIRCT O60AB 2/2J/26,1200AM 64GaIluiCan 0 friJay � _.. / ' / . 995KANEST 11046 2/24/2fi.12Q0AM Basc35GallonCan 0 Tuesday ...�.�.r. ' �� ` ' ■ �.IvCDR 20J22 2/2�/2fi.1200AM 6asc35GalonCan 0 �riday U�k,,... 1 _,� . ?�5 O'�irTCR2qCE 0961J 3/5�36.12-IXIAM cBG�u•Ca�. 0 T1.u�zJaV J�4�.,.. � �, ��a�„�30j5��e«�� Page 1274 of 1455 . 1 � I 1 . 1 C� ' • � r� � �\ � . ._ • \ .�'��l�/IStB '.. - ��_ �� * .� � : , � I � � Y �y � 1 ♦ � ' • •�': J f. _ �j �� :,�,,,;� ��":: �t�� +� ... � ..«.\� �� . r, . ' . �''"- + ' � � V � � � . �, �._ ,. � ' _ '_..�J �:�� "" �� { ` � _ � ' � '�j��'��' 1F+ a -� -1� 7j � ` ` ` i� ' !' �f Y ' ��Balltown ` . � •` ' !� olesburg .�� ----�--• . ' � O , •+ �,• .,., w , 4 ` . �r � �" ► z �-�_a+. � �. . ♦' y . .,r � � .� Q �,� � � . .t� ,��. :,, " ,c:. : � ��;'a�' .�. »-- � I ; N. ♦ ' _ Luxembur Holy Eross l - ' '� ��0 � Q , � ��'� � 1 rj�' . � . . t_ _ , ''�' , =.� *� O�� . _ � Kieler � . . � �. ,R`kerd9V111A� . T � I I � � � � . • �'. r W � �-��r " •1r '• � F,�y �� . J �� _� � � , W — Sayeville _�' Sandy Haok _ r � ,r, ., `..z . _W r` : _ �'' Z , • � •'� . New'Vienna .� 1�� .��„5A ' `'� t,�i . �`e. ,� r--�' ' }w :� '. �ti . � �• �•.• 0�0�' �� ,� — '_ _`' .��. -.-..y� _ �� •�� ♦��Asb�ur;y��D.�� . .�. � .,,., �.a , • �!`��/�.��r��i; �I.Dubuque ., �� ' V\ �7� 1114w � � � ' � �. _ � L� :� E .� Q �— J�ru�.�t`�. ` Menominee ,' .. Mekee _ � � ��:�� L.- Dyersvill � � +„�� ,.w i� � ��L�7'� � ti: � �� _ �r"e".i ` '�=� ~ �j�� g '��°k , • - D,u6uqu ��,` Stat�reserve� '• • . _ .,f � . � � � ,. ' ` � • , � ` ' -. . �.l..''C� " . ' �'�•/ .��• � �"4� ��` ` ♦ , L;rf.�.�j J � I �, � . . �Farley = ' Epworth W r' �A� � �O �� , .,.�� ,..�. A H« r � \7 O� _ � � 1` - ' y_ .�' . _ : � � •�. p .-' �O��pp �3� � . � .. . � . . . ' O � 0'�� , � �' -� . ` � : '.: � -��. " p � • �' � _O: `�� ,� _�: �1. 1 .1� ,F �� _ �w��--O' �; �� Q � � �,. � •��j��•� �� - �1 s r � . _1 . , . St.Uonatus _.•"��`' ° �'°' � .. . . +nr , '.� 0 � � � � '_ ' __0 _ � :� n �f � � � r = � / - , " � - � . . , • , ,. jn, . , �� ' . . _ . . � �. . W ,. � , , , � � � . W �: '; ,' : . �'�. r � ' , Fillmore s - �� , _ `�►� '� - � �1�. �� , __� ��. ,; ��.,� � i� . �f.;�^i�'�'S' ,`�" . ,. ' ^ .�- � 2winqle +� �L'a Mo -• -----i-'.�_ --. Gascade ' � �-�- L --- ��---•------ � .� , ,� r 3/,�• . �,� � L + '.�- • � ONLINE GIS USAGE ■ ■ WEEKLY ONLINE MAP USE SAMPLE Finance i Economic Development Community Impact WRRC Water Communications Parks and Rec PartneringAgencies Contractor Engineering GIS/IT Fire Police Planning Public Works Page 1276 of 1455 Project Support ■ ■ SSAMP - Sanitary SewerAsset Management Plan Downtown Land Use Survey CCTV I nspections - Closed Ci rcu it Television - Sanitary and Storm Sewer Fire Station Location and Feasibility Study Page 1277 of 1455 GIS PERFORMANCE MEASURES ■ ■ Performance Measures City Council Goal: Financially Responsible, High Performance City Organization: Sustainable and Effective Service Delivery � ept. Objective: Leverage GIS as a data management software to accurately and consistently track City assets and community information. � � FY 2026 Performance Performance Me�sure (KPI) Target 2024 2025 Actual Actual Estimated Indicator Data Accuracy and Completeness 90% N!A fWA 90% Goal Met Project Management Layers 10 7 10 15 Goal Met i Dept. Objective: Assist City departments in GIS application development to streamline 2 workflows, centralize citywide data collection, and collaborate across organization outcomes. Total Applications in GIS 1,000 1,215 1,303 1,100 Goal Met New or streamlined workflows using GIS 6 5 7 7 Goal Met i 3 Dept Objecdve: Produce interactive and engaging content to improve customer service. Website hits to open maps 70,000 45,000" 50,000* 75,000 Goal Met New public facing web applications 15 25 25 20 Goal Met Page 1278 of 1455 ' Server and Database Upgrades . . • Online Services Cleanup • Modernize GIS solutions for city departments • Data Accuracy and Completeness � Change Management Page 1279 of 1455 1 � - • � � Recurring - - • - � 1 . IT Service Management Software Page 1280 of 1455 1 � - • � � Non -Recurring - - • . � 1 . Plotter for IT Department 2. Staff Polos 3. Training and Education for IT Staff 4. Hybrid Setup for Salaried Employees 5. 200 Additional Microsoft Copilot Licenses 6. Virtual Esri GIS Training for 5 employees 7. Additional GIS Conference for GIS Coordinator 8. AED for IT Office 9. City Hall 3rd Floor Network Switch Enclosure 10. FOTDR Fiber Optic Cable Tester 11 . Additional Asset Management Equipment 12. Outdoor Hardtop Gazebo for Chavenelle Office 13. Dual Curved Monitors & Privacy Glass for IT Staff Page 1281 of 1455 Information Technology Department FY 27 CAPITAL IMPROVEMENT PROJECTS . _ � . - . . . . City-Wide Computer & Printer 506 012 2 988 653 3 494 665 Replacements $ � $ � � � � � Network Security Risk Assessment $ 25,000 $ 25,000 $ 50,000 Network Switch Replacement $ 90,000 $ 517,500 $ 607,500 Page 1282 of 1455 Information Technology Public Safety Initiatives and Support • Staffing and Support for Public Safety � FirstNet Communications Support " ,, � Public Safet A lications, Network and Devices ;,, � �� U�l�� ' Y pp :� J - � EOC Technology Support -�. �� QFE�� Implementation of Resilient Systems fi � Integrated Emergency Management Tools • Mobile in-car computers • EMS Cardiac Monitors � Body Cameras • Safeguarding Data and Protection of Critical Systems from Cyber Th reats Page 1283 of 1455 Information Technology Department PERFORMANCE MEASURES � ^ Cit Council Goal: Financiall Res onsible Hi h Performance Cit Or anization: Sustainable and Effective Service Delive 1 Dept. Objective: Provide highly available, resilient technology solutions and support services to all users. Performance Measure (KPI) Target FY 2024 FY 2025 FY 2026 Performance Actual Actual Estimated Indicator % Servers Updated 100% 95% 100.00% 100.00% Goal Met % Overall Up-Time 99% + 99.99% 98.90% 99.00% Goal In Progress % Service Ticket Resolution Backlog 2.50% N/A 3.47% 2.53% Goal in Progress % Bandwidth Utilization <80% NA 70.00% 70.00% Goal Met Positive User Satisfaction Rating (0-100%) 95% N/A 95.50% 92.80% Goal in Progress 2 Dept. Objective: Provide solutions 8�services that maximize the investment in technology assets. % of Planned and Budgeted Device Deployments 100% NA 100% 82% Goal Not Met Completed per year % of users receiving cybersecurity awareness training 100% N/A 90% 90% Goal Not Met % Latency and packet loss alerting 100°/o N/A 100% 100% Goal Met 3 Dept. Objective: Data assets are safe and continuity of business is insured. % of IT assets that are tagged, tracked, and monitored 100% N/A N/A 20% Goal Not Met for life cycle % of total inbound intrusions that were blocked 100% 100% 100% 100°/o Goal Met % of total inbound viruses that were blocked 100% 100% 100% 100°/o Goal Met User Security Testing - % of users that respond to �50�0 0 0 0 simulated security attacks 8.80/o 5.50/0 5.14/o Goal in Progress Organizational Preparedness Score- Overall score based on software updates, continuous update 100 N/A 95 96% Goal in Progress compliance, and high-risk vulnerability identification Page 1284 of 1455 https ://cityofd u buq ue .org/422/I nformation -Tech nology Page 1285 of 1455 Information Technology 21 Page 1286 of 1455 This page intentionally left blank. 22 Page 1287 of 1455 INFORMATION TECHNOLOGY DEPARTMENT % Change From FY FY 2025 FY 2026 FY 2027 2026 Budget Highlights Actual Budget Requested Budget Expenses Employee Expense $ 1,477,587 $ 1,539,285 $ 2,004,887 30.2 % Supplies and Services $ 1,123,166 $ 1,339,902 $ 1,516,245 13.2 % Machinery and Equipment $ 39,391 $ 37,797 $ 81,850 116.6 % Total $ 2,640,143 $ 2,916,984 $ 3,602,982 23.5 % Resources Operating Revenue $ 860,518 $ 863,338 $ 1,295,263 50.0 % Greater powntown TIF Loan Repayment $ — $ — $ 172,309 — °/o Total $ 860,518 $ 863,338 $ 1,467,572 70.0 % Property Tax Support $ 1,779,625 $ 2,053,646 $ 2,135,410 81,764 Percent Increase (Decrease) 4.0 % Personnel -Authorized FTE 13.00 13.00 17.25 Improvement Package Summary 1 of 17 This improvement package is for an additional User Technology Support Specialist under the Information Technology (IT) Department. As our organization continues to grow, so does the demand for our IT infrastructure and support services. Timely and effective technical support is crucial to maintain productivity and minimize disruptions. The number of support tickets continues to increase and the time to resolve each ticket is also increasing as issues become more complex. The growth in support needs will continue to grow with the expanded use of artificial intelligence, a comprehensive new public safety system, enterprise asset management, expanded modules for human resource technology, as well as moving applications such as pet licensing to in-house support. A conservative estimate would be a sustained 20% increase in tickets with the public safety system installation and another 5 -15% increase with other new applications. To provide the best service needed, funding this position would help fill the gaps in the ticketing system and will be used as the deploy technician. The importance of this position also coincides with the Information Technology department moving to a new location in 2025 as additional travel time is now needed to other City locations. The expected growth in technology cannot be maintained successfully with the current staffing. The Information Technology Department currently has 2 User Technology Support Specialists. The responsibilities of this position would address the needs including issue resolution, deployment of new computers, hardware troubleshooting, asset management, patch management, and issues that arise with the new public safety software and overflow issues with the ERP system. This improvement package responds to the council goal of Financially Responsible, High-Performance City Organization: Sustainable and Effective Service Delivery. 23 Page 1288 of 1455 Related Cost: $ 91,867 Tax Funds Recurring Recommend - No Net Cost: $ 91,867 Property Tax Impact: $ 0.0293 0.29% Activity:Administration 2of17 This improvement package was submitted as recurring but is being recommended as non-recurring. This improvement package request would provide 200 additional licenses of Microsoft Copilot for M365 for government users. Microsoft 365 Copilot Government Community Cloud (GCC) leverages large language models (LLM's) with the City's data to enhance productivity for government entities. It integrates seamlessly with Microsoft 365 apps like Word, Excel, PowerPoint, Outlook, and Teams, offering real-time intelligent assistance to boost creativity, productivity, and skills. This artificial intelligence assistant works in the flow of work, providing valuable support and insights. Copilot offers features that streamline tasks, automate workflows, and enhance collaboration to unlock productivity and creativity throughout your day. Its adaptability means that it can be customized to meet the unique needs of the City. The ability to extend its capabilities through plugins makes it a continually evolving asset that can adapt to the ever-changing landscape of business needs. This package would address the needs of users that have a demonstrated need for this technology. The 100 licenses that were purchased and approved last year were strategically assigned, but demand for additional licenses has far exceeded the initial purchase. All departments have indicated they have additional staff that would utilized a Copilot license. This budget request would fulfill that demand. This package addresses the City Council goal of Financially Responsible, High-Performance City Organization: Sustainable, Equitable and Effective Service Delivery by keeping pace and leveraging information technology and artificial intelligence to enhance City services delivery, City processes and project planning. Related Cost: $ 72,000 GDTIF Loan Repay Funds Non-Recurring Recommend -Yes Related Revenue: 11,617 GDTIF Loan Repay Funds Non-Recurring Related Cost: 567 Cable TV Fund Non-Recurring Related Cost: 1,050 CDBG Funds Non-Recurring Related Cost: 1,102 Housing Choice Voucher Funds Non-Recurring Related Cost: 2,175 Garage Funds Non-Recurring Related Cost: 648 Parking Funds Non-Recurring Related Cost: 2,187 Transit Funds Non-Recurring Related Cost: 1,458 Sanitary Sewer User Fees Non-Recurring Related Cost: 2,430 Water User Fees Non-Recurring Net Cost: $ 72,000 Property Tax Impact: $ 0.023 0.23% Activity:Administration 24 Page 1289 of 1455 3of17 This improvement package is for an additional Lead Applications Network Analyst under the Information Technology (IT) Department. As our organization continues to grow, so does the demand for our IT infrastructure and support services. Timely and effective technical application support and assistance is crucial to maintain productivity and minimize disruptions. The Lead Applications Network Analyst position primarily focuses on all City application support, whose needs will continue to grow with the expanded use of artificial intelligence, additional software, enterprise asset management, expanded modules for human resource technology in Tyler and Neogov, as well as moving applications such as pet licensing to in-house support. The IT department currently has 3 Lead Applications Network Analysts. Two of these positions are primarily focused on public safety. The third position primarily focuses on the ERP and help desk staff. To provide the best service needed, funding this position would help fill the gap that remains outside of public safety and our ERP for the rest of the city. The expected growth in technology cannot be maintained successfully with the current staffing. This improvement package responds to the council goal of Financially Responsible, High-Performance City Organization: Sustainable and Effective Service Delivery. Related Cost: $105,435 Tax Funds Recurring Recommend - No Net Cost: $105,435 Property Tax Impact: $ 0.0336 0.33% Activity:Administration 4of17 This improvement package request would provide for the purchase of a fluke OTDR (optical time domain reflectometer) tester. An OTDR tester is necessary for analyzing fiber optic cable perFormance from end to end by testing components along the cable, including connection points, bends, and splices. The device would also indicate strength of the signal to distance intended. The City has over 100 miles of fiber connecting close to 100+ sites and several more intermediate sites in networking cabinets throughout the City. Fiber optic cable also connects mission-critical sites such as the Airport, Water Plant, WRRC, SCADA, in-building telecommunications cabinets and the City's data centers. The first line of support for issues with an implementation of fiber optic networks is the presence and quality of the connection. Time is critical, and the wait time for a vendor to test fiber optic networks can be up to 24 hours. This improvement item responds to the City Council goal of Financially Responsible, High- PerFormance City Organization: Sustainable, Equitable and Effective Service Delivery and Connected Community: Equitable Transportation, Technology Infrastructure and Mobility. Related Cost: $ 29,000 GDTIF Loan Repay Non-Recurring Recommend -Yes Net Cost: $ 29,000 Activity:Administration 5of17 This improvement package was submitted as recurring but is being recommended as non-recurring. This improvement package request is for an increase in funding for ongoing training, education and conferences for the Information Technology staff. Investing in the education and training of staff is essential for the ongoing security and resilience of our organization. This allocation would be used for training classes, conferences, certifications and other education needs to keep our staff and organization at the forefront of industry developments. While the IT staff has grown over the years, funding has not kept pace for meetings, conferences and education for all staff. This improvement item responds to the City Council goal of Financially Responsible, High-Performance City Organization: Sustainable, Equitable and Effective Service Delivery. 25 Page 1290 of 1455 Related Cost: $ 28,000 GDTIF Loan Repay Non-Recurring Recommend -Yes Net Cost: $ 28,000 Activity:Administration 6of17 This improvement package request is for adding a enclosure to the City Hall Third Floor Network Switch area that is in the engineering offices. The current placement of the network switch in an open office space leaves it vulnerable to accidental damage, unauthorized access, or intentional tampering. This violates basic physical security principles outlined in most cybersecurity frameworks. Network infrastructure is typically housed behind a locked door or in a secure access-controlled environment. This request would include adding a front and back lockable door to the existing network rack. This improvement package responds to the council goal of Connected Community: Equitable Transportation, Technology Infrastructure, and Mobility. Related Cost: 2,500 GDTIF Loan Repay Non-Recurring Recommend -Yes Net Cost: $ 2,500 Activity:Administration 7of17 This improvement package request is for AED (Automated External Defibrillator) device for the Information Technology offices. An AED would enhance emergency preparedness and ensure the safety of staff and visitors. Having an AED readily available reduces liability and demonstrates a proactive approach to employee and public safety. Staff can be trained in AED use, ensuring a rapid and effective response in emergencies. This request includes the AED and all necessary supplies, including the mounting cabinet, extra battery, and pads. This improvement package responds to the council goal of Health and Safe Community. Related Cost: 2,700 GDTIF Loan Repay Non-Recurring Recommend -Yes Net Cost: $ 2,700 Activity:Administration 8of17 This improvement package request is for adding additional asset management equipment and adding spare computers for IT to deploy to users that are having computers issues so downtime is minimized. If a user is currently having issues with their desktop or laptop and downtime is necessary, the user is given an older, retired computer. This is not optimal for the user and reduces productivity. If IT had spare equipment, that computer could be setup ahead of time and ready for deployment immediately. This request includes two handheld asset tag scanners, an asset management cart, three spare laptops, three spare desktops, three spare docks and three spare monitors. This would be a one time cost initially, but the spare equipment could be added to the computer replacement CIP. This improvement package responds to the council goal of Financially Responsible, High-Performance City Organization: Sustainable and Effective Service Delivery. Related Cost: 13,000 GDTIF Loan Repay Non-Recurring Recommend -Yes Net Cost: $ 13,000 Activity:Administration 26 Page 1291 of 1455 9of17 This improvement package request will bring together several pieces of software that IT currently uses under one umbrella: Asset Management, Patch Management, Software Deployment, App Management, Data Loss Prevention, Ransomware Protection, Mobile Device Management, BitLocker Management, Ticketing System, Remote Access and Troubleshooting, OS Imaging and Deployment, as well as others. This new ITSM (IT Service Management) software includes advanced security features to protect our data, safeguard against cyber threats, and ensure compliance with industry standards. It automates routine tasks such as software updates, patch management, and device provisioning, reducing manual workload and minimizing downtime. With a centralized dashboard, we can easily monitor and manage all our devices, regardless of their location, ensuring consistency and control. The software enables remote troubleshooting and support, allowing us to resolve issues quickly and efficiently, even for remote or off-site devices. Our existing remote control software does not provide an encrypted secure connection. Once this software is implemented, we can eliminate PDQ Inventory and Deploy ($10,543) and FreshService ($33,730) out of the software budget line item. This improvement package responds to the council goal of Financially Responsible, High-Performance City Organization: Sustainable and Effective Service Delivery. Related Cost: $ 75,000 Tax Funds Recurring Recommend -Yes Related Revenue: 10,844 Tax Funds Recurring Related Cost: 529 Cable TV Fund Recurring Related Cost: 980 CDBG Funds Recurring Related Cost: 1,029 Housing Choice Voucher Funds Recurring Related Cost: 2,031 Garage Funds Recurring Related Cost: 605 Parking Funds Recurring Related Cost: 2,041 Transit Funds Recurring Related Cost: 1,361 Sanitary Sewer User Fees Recurring Related Cost: 2,268 Water User Fees Recurring Net Cost: $ 75,000 Property Tax Impact: $ 0.0239 0.24% Activity:Administration 10 of 17 This improvement package was submitted as recurring but is being recommended as non-recurring. This improvement package request is for funding related to GIS training for city staff. This improvement package allow up to five (5) city employees to attend virtual Esri GIS training per year. With new staff joining the organization on a regular basis, as-needed training for GIS is crucial for day-to-day activities. This will allow the GIS office to provide more effective software and application usage. This improvement package supports the Council goal of "Financially Responsible, High Performance City Organization: Sustainable, Equitable and Effective Service Delivery: Keep pace and leverage information technology and artificial intelligence to enhance City service delivery, City processes and project planning and to enhance cybersecurity." Related Cost: $16,000 GDTIF Loan Repay Non-Recurring Recommend -Yes Related Revenue: $11,182 Administrative Overhead Non-Recurring Net Cost: $4,818 Activity: GIS 27 Page 1292 of 1455 11 of 17 This improvement package request is for the purchase of a plotter for the Information Technology department. Since the GIS office has moved to the new data center on the west side of town, getting maps plotted has become a challenge. Having a plotter on site will make plotting maps much easier, and will make maps more readily available for the Fire Training Facility in the event of an Emergency Operation Center (EOC) setup. This improvement package supports the City Council's goal of Financially Responsible, High PerFormance City Organization: Sustainable, Equitable and Effective Service Delivery: Keep pace and leverage information technology and artificial intelligence to enhance City service delivery, City processes and project planning and to enhance cybersecurity. Related Cost: 5,000 GDTIF Loan Repay Non-Recurring Recommend -Yes Related Revenue: 3,495 Administrative Overhead Non-Recurring Net Cost: $1,505 Activity: GIS 12 of 17 This improvement package was submitted as recurring but is being recommended as non-recurring. This improvement package request is for funding to allow the GIS Coordinator to attend one (1) additional conference per year. When funding was initially set up for this activity, the GIS Coordinator was able to attend two conferences per year. However, with the rising cost of travel, conference participation has dropped back to one per year. With technology ever changing, it is important for the GIS Coordinator to stay up to date on the latest GIS and AI technology. This improvement package aligns with the City Council's goal of "Financially Responsible, High Performance City Organization: Sustainable, Equitable and Effective Service Delivery: Keep pace and leverage information technology and artificial intelligence to enhance City service delivery, City processes and project planning and to enhance cybersecurity." Related Cost: $3,000 GDTIF Loan Repay Non-Recurring Recommend -Yes Related Revenue: $2,097 Administrative Overhead Non-Recurring Net Cost: $ 903 Activity: GIS 13 of 17 This improvement package request is for adding a hybrid work-from-home setup for all information technology salaried employees. Many IT staff work from home on occasion or work offsite during on-call hours. Staff currently unplug and plug any external peripherals and carry them home, utilize their own personal equipment, or don't utilize them at all. This request would include a second dock for the laptops, a surge power strip and a headset/speaker that could be kept at home. This would make working remotely much more efficient. This improvement package responds to the council goal of Financially Responsible, High-Performance City Organization: Sustainable and Effective Service Delivery. Related Cost: 6,000 GDTIF Loan Repay Non-Recurring Recommend -Yes Net Cost: $ 6,000 Activity:Administration 28 Page 1293 of 1455 14of17 This improvement package request is for all Information Technology staff to upgrade to dual 34" curved monitors each, along with adding privacy glass to each monitor. Information Technology staff currently utilize two or three 27" monitors. The upgrade is intended to improve ergonomic comfort, reduce screen clutter, and enhance multitasking efficiency, particularly for employees working with multiple applications. The curved monitors offer a wider field of view and can reduce eye strain and neck movement. Information Technology staff often works with sensitive information on their monitors, so a privacy glass would protect that information further. This improvement package responds to the council goal of Financially Responsible, High-Performance City Organization: Sustainable and Effective Service Delivery. Related Cost: 17,000 GDTIF Loan Repay Non-Recurring Recommend -Yes Net Cost: $ 17,000 Activity:Administration 15of17 This improvement package was submitted as recurring but is being recommended as non-recurring. This improvement package request is for two City of Dubuque logo polo shirts for each IT staff member recurring every 5 years. New City of Dubuque shirts would foster a sense of unity, professionalism, and civic pride among department members. These shirts would be purchased from a local company. This improvement package responds to the council goal of Financially Responsible, High-Performance City Organization: Sustainable and Effective Service Delivery. Related Cost: 1,500 GDTIF Loan Repay Non-Recurring Recommend -Yes Net Cost: $ 1,500 Activity:Administration 16 of 17 This improvement package is for adding a large outdoor hard top gazebo next to the Information Technology Office building. This shared outdoor space would enhance employee well-being, provide a shaded outdoor workspace, and support staff engagement. Outdoor spaces promote mental health, reduce stress, and offer a change of environment that can boost productivity and morale. The gazebo can serve as a break area, informal meeting space, or venue for small departmental gatherings, especially during warmer months. A hard top gazebo offers long-term value with minimal maintenance. This improvement package responds to the council goal of Financially Responsible, High-Performance City Organization: Sustainable and Effective Service Delivery. Related Cost: 5,000 GDTIF Loan Repay Non-Recurring Recommend -Yes Net Cost: $ 5,000 Activity:Administration 29 Page 1294 of 1455 17 of 17 This improvement package request is for an additional Information Technology Vehicle. The IT department currently has one used SUV that we purchased from the police department that any staff member can utilize to transport equipment, travel to other City buildings for support, or to attend a meeting. The IT department, at full staff, is 18 people. The current vehicle is checked out and shared between all 18 staff. A second vehicle would alleviate more staff needing to use their personal vehicles and claiming mileage costs. With the IT staff relocation to the new offices, this issue is compounded with staff need to drive additional distance to every City building, incurring more mileage. This vehicle could possibly be shared with the Emergency Communications Department as a cost saving measure. This improvement package responds to the council goal of Financially Responsible, High-Performance City Organization: Sustainable and Effective Service Delivery. Related Cost: 40,000 Tax Funds Recurring Recommend - No Net Cost: $ 40,000 Property Tax Impact: $ 0.0128 0.13% Activity:Administration Significant Line Items Employee Expense 1. FY 2027 employee expense reflects a 3% wage package increase for non-bargaining employees. 2. The lowa Public Employee Retirement System (IPERS) City contribution of 9.44°/o is unchanged from FY 2026. The employee contribution of 6.29% is unchanged from FY 2026. 3. The City portion of health insurance expense is increased from $1,119 in FY 2026 to $1,175 in FY 2027 per month, per contract, which results in the annual cost being increased by $64,428 or 40%. The increase is due to the city contribution increasing 5.00% because of increasing health costs and increased number of contracts. 4. Overtime is unchanged from $3,513 in FY 2026 to $3,513 in FY 2027. FY 2025 actual was $427. 5. 50% Sick Leave Payout decreased from $4,739 in FY 2026 to $4,455 in FY 2027 based on FY 2025 actual of $4,325 + 3%. 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. The following personnel changes have occurred during FY 2026, increasing personnel from 13.00 FTEs to 17.25 FTEs. All positions were previously funded through the General Fund and will continue to be funded through the General Fund. i. Data Analyst (1.0 FTE) moved from Economic Mobility to the Information Technology Department. ii. Geographic Information Systems division (2.25 FTE) was moved from Communications to the Information Technology Department. iii. Administrative Support Professional (1.0 FTE) was moved from Economic Mobility to the Information Technology Department. This position is partially recharged to other departments as part of the IT Recharge line item. 30 Page 1295 of 1455 Supplies & Services 7. Lease expense increased from $79,530 in FY 2026 to $96,908 in FY 2027. This line item represents the portion of Information Technology's property lease purchase at 7900 Chavenelle Road. Approximately 84% of the cost will be paid by the Information Technology Department, and the remaining 16% will be paid by the Engineering Department based on use of space. This increase is due to the utilities now being charged to the IT department. These fees were previously budgeted in the Engineering department. 8. Education increased from $21,050 in FY 2026 to $21,250 in FY 2027. While many items in this budget line were moved to Meetings and Conference, there is a little increase to the amount from FY 2026 budget because of a couple recommended improvement packages. 9. Meetings and Conferences increased from $5,980 in FY 2026 to $61,930 in FY 2027. This increase is due to moving the Education budget to the Meetings and Conferences line item. This line item includes yearly conferences for LaserFiche, Tyler, Neogov and CentralSquare conferences. 10. Technology Services increased from $1,152,328 in FY 2026 to $1,255,206 in FY 2027. This line item represents the cost of all enterprise software in the City. The City-wide software licenses budgeted for FY 2027 are based on FY 2026 actual expenses. Software renewal costs vary each year, and the cost of renewal tends to increase over time. Some software products renew every year, while others renew on a multi-year schedule. Many contracts are set up as multi-year contracts to capture savings. These factors contribute to fluctuation in this line item. The FY 2027 budget includes the following software: Software 8� Data Service FY 2026 FY 2027 Budget Requested Plan Management Software $ 24,930 $ 25,677 Door Access Software $ - $ 2,690 Regional Internet Registry $ 500 $ 276 Cybersecurity Analytics & Monitoring Software $ 15,515 $ 15,061 Battery & Environment Monitoring $ 6,862 $ 15,570 a Asset Management Software Licensing $ 18,850 $ - b Phone System Management $ 938 $ 938 System Restore Software $ 80 $ 84 Domain Renewals $ 1,055 $ 1,055 Easy 365 Manager $ - $ 1,346 Efficiency Software Solution for Libraries &Tasks $ 618 $ 651 Public Safety Network $ 3,000 $ - Ticketing Service Licensing $ 23,374 $ 33,730 c GIS Annual Support $ 64,000 $ 62,500 Remote PC Access Software $ 25,438 $ 27,830 Security Awareness Training $ 52,400 $ - d Enterprise Content Management Support $ 56,536 $ 56,537 Password Management Software $ 15,120 $ 15,120 Microsoft 365 $ 318,712 $ 337,803 e Email Archive $ 38,000 $ 61,796 f Camera Software Maintenance $ - $ 1,003 Unified Phone Communication Software Maintenance $ 13,060 $ 26,948 g Open Finance/Open Budget used Tyler Data previously) $ 31,959 $ 33,557 h 31 Page 1296 of 1455 Software & Data Service FY 2026 FY 2027 Budget Requested Open Text Online Fax (formerly Rightfax) $ 2,487 $ 2,137 Network Monitoring Software $ 2,993 $ 3,159 Asset Inventory and Update Software $ 9,563 $ 10,543 Skill Development & Online Courses $ 1,158 $ 1,216 Print Audit Annual maintenance $ 11,885 $ 12,599 Technical Support Solution $ 2,349 $ 19,000 i Secure File Transfer System $ 21,169 $ 15,600 j Smartphone Data Plan (IT dept only) $ 1,629 $ — AV System Maintenance $ 3,582 $ 3,582 Security System Licensing & Maintenance $ 149,000 $ 149,000 SSL Certificates $ 495 $ 500 Disaster Recovery & Backup $ — $ 17,000 k Virtualization Technology $ 45,418 $ 30,418 I Cloud Backup Storage $ — $ 8,000 Windows Server& SQL Licensing $ 189,653 $ 48,080 m GIS Division n ArcGIS Hub Premium $ — $ 8,000 ESRI Advantage Program $ — $ 59,200 Recommended Improvement Packages Microsoft Copilot Licenses $ — $ 72,000 ITSM Software $ — $ 75,000 Total $ 1,152,328 $ 1,255,206 The change from FY 2026 budget to FY 2027 budget is largely due to the following software: a) Battery & Environment Monitoring increased due to a 3-year renewal due in FY 2027. b) Asset Management Software Licensing decreased due to this software budget moving to the Engineering and Public Works departments budgets. c) Ticketing Service Licensing increased due to other departments utilizing software and an anticipated 5% price increase. d) Security Awareness Training decreased due to purchasing a 3-year license in FY 2026. e) Microsoft 365 increased due to adding Copilot during FY 2026 and adding more user licenses. The cost of Microsoft 365 changes every three years due to locked-in rates that last three years. f) Email Archive increased due to this software now including all City users. g) Unified Phone Communication Software Maintenance increased due to adding additional users, which requires additional licenses and increase support contract maintenance costs. h) Open Finance/Open Budget used Tyler Data previously) increased due to an anticipated 5% price increase. i) Technical Support Solution increased due to adding more switches to maintenance support after coming off the initial support package. j) Secure File Transfer System decreased due to locking into a 3-year rate for$15,600. k) Disaster Recovery & Backup increased due changing vendors for backup solutions. I) Virtualization Technology decreased due to locking in a 3-year rate. 32 Page 1297 of 1455 m) Windows Server & SQL Licensing decreased due to the full license being purchased in FY 2025 and only the maintenance due after this current year. n) The GIS Division was moved to the IT department in FY 2026. In FY 2026 these amounts were budgeted in the Communications department. The estimated costs for these software are unchanged from the amount budgeted for FY 2026. Machinery & Equipment 11. Equipment replacement items include ($74,150): Information Services Machinery and Equipment Smartphones $ 400 Desk Phones 1,250 Recommended Improvement Packages Fiber Optic Test Equipment $ 29,000 City Hall Lockable Network Switch Doors $ 2,500 Asset Management Equipment and Spares $ 13,000 GIS Technical Equipment $ 5,000 Laptop Hybrid Equipment $ 6,000 Monitors and Privacy Screens $ 17,000 Total Equipment $ 74,150 Revenue 12. Specialized Services revenue related to department contracts and maintenance recharges is decreased from $390,747 in FY 2026 to $263,098 in FY 2027. Information Technology 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 the number of users, the number of devices, and the number of licenses consumed. Any increase in licensing includes an increase in Specialized Services revenue. 13. Central IT Processing is increased from $472,591 in FY 2026 to $777,538 in FY 2027. Information Technology 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 the number of users, the number of devices, and the number of licenses consumed. Any increase in licensing includes an increase in Central IT Processing revenue. 33 Page 1298 of 1455 INFORMATION TECHNOLOGY Information Technology 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. >� .� �' � � � � � � � � � � � � � 34 Page 1299 of 1455 SUCCESS IS ABOUT PLANNING, PARTNERSHIPS AND PEOPLE LEADING TO OUTCOMES PLANNING Information Technology works with all City Departments and Divisions to ensure the latest technology is available to carry out City Goals and Initiatives. � -, � PEOPLE ... A knowledgeable and competent staff � provides leadership in the technology � � activities for the City of Dubuque � including help desk, systems planning , and implementation, network .- y �� _ administration and telephony. Information Technology staff regularly attend annual conferences and � _ � education sessions to gain knowledge » '� �� . � and best practices. PARTNERSHIPS Information Technology successfully integrates people, process and technology by fostering partnerships and consistently delivering solutions that serve as the foundation of City operations. Technology support is provided for close to 800 end-users including Greater Dubuque Development Corporation and City and Counry public safety which includes 911 Dispatch, Dubuque County Sherriff, jail and police. 35 Page 1300 of 1455 INFORMATION TECHNOLOGY FY FY FY 2025 2026 2027 Full-Time Equivalent 13.00 13.00 17.25 Resource and Property Tax Support 2,500,000 2,000,000 1,500,000 1,000,000 � 500,000 0 Operating Revenue Property Tax Support � FY 2025 Actual FY 2026 Budget FY 2027 Recomm'd Information Technology is supported by 17.25 full-time equivalent employees, which accounts for 55.65% of the department expense as seen below. Overall, the department's expenses are expected to increase by 23.52°/o in FY 2027 compared to FY 2026. Expenditures by Category by Fiscal Year $1,477,587 Employee Expense $1,539,285 $2,004,887 $1,123,166 Supplies & Services $1,339,902 $1,516,245 $9,391 Machinery& Equipment $37,797 $74,150 �0 ��oo�p0 �600�p0 �900�p0�1200�p0�1�00�p0�1 aoo Op0�2100�p0 � FY 2025 Actual FY 2026 Budget FY 2027 Recomm'd 36 Page 1301 of 1455 INFORMATION TECHNOLOGY Mission & Services Information Technology advances productivity and 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: Technology support is provided 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. Information Technology Administration Funding Summary FY 2025 FY 2026 FY 2027 Actual Budget Recomm'd Expenditures $2,640,143 $2,916,984 $3,238,648 Resources $860,518 $863,338 $1,040,636 Information Technology Administration Position Summary FY 2027 Chief Information Officer 1.00 Senior Network/systems Admin 2.00 Lead Applications/network Analyst 3.00 Help Desk Support Technician 3.00 Chief Security Officer 1.00 User Technology Support Specialist 2.00 Intern 1.00 Data Analyst 1.00 Admin Support Prof 1.00 Total FT Equivalent Employees 15.00 37 Page 1302 of 1455 Performance Measures City Council Goal: Financially Responsible, High Performance City Organization: Sustainable and Effective Service Delivery Dept. Objective: Provide highly available, resilient technology solutions and support 1 services to all users. Performance Measure (KPI) Target FY 2024 FY 2025 FY 2026 Performance Actual Actual Estimated Indicator % Servers Updated 100% 95°/o 100% 100°/o Goal Met % Overall Up-Time 99% + 99.99% 98.90% 99.00% Goal In Progress % Service Ticket Resolution Backlog 2.50% N/A 3.47% 2.53% Goal in Progress % Bandwidth Utilization <80% NA 70.00°/o 70.00% Goal Met Positive User Satisfaction Rating g5% N/A 95.50°/o g2.80% Goal in (0-100%) Progress 2 Dept. Objective: Provide solutions & services that maximize the investment in technology assets. % of Planned and Budgeted Device 100% NA 100% 82% Goal Not Met Deployments Completed per year % of users receiving cybersecurity 100% N/A 90% 90% Goal Not Met awareness training °/o Latency and packet loss alerting 100% N/A 100% 100% Goal Met 3 Dept. Objective: Data assets are safe and continuity of business is insured. % of IT assets that are tagged, tracked, 100% N/A N/A 20% Goal Not Met and monitored for life cycle % of total inbound intrusions that were 100% 100% 100% 100% Goal Met blocked % of total inbound viruses that were 100% 100% 100% 100% Goal Met blocked User Security Testing - % of users that �5% 8.80% 5.50% 5.14% Goal in respond to simulated security attacks Progress Organizational Preparedness Score - Overall score based on software Goal in 100 N/A 95 96% pro ress updates, continuous update compliance, g and high-risk vulnerability identification Some KPIs have been newly created, therefore, N/A is used to indicate no historical data is available. 38 Page 1303 of 1455 GEOGRAPHIC INFORMATION SYSTEMS (GIS) (Maps & Data) Mission & Services The Geographic Information Systems (GIS) Office is responsible for the supervision, development, use, and maintenance of the City's Geographic Information System, and coordinates these duties with other City departments, partners to City projects, other government groups and private sector businesses. The GIS office provides a substantial service level to the City organization. INFORMATION TECHNOLOGY 1 GIS OFFICE O San . � . �� i c� .��. :�r: w :�. . D��„q., I . :r. i . : . : r. c __ -- `� . ....Ouque ,:�r. I.: �:v:I. � r: i e; i [ � � r: 'ti i 39 Page 1304 of 1455 Geographic Information Systems Funding Summary FY 2025 FY 2026 FY 2027 Actual Budget Recomm'd Expenditures $446,800 $386,373 $364,334 Resources $354,749 $265,550 $254,627 Geo ra hic Information S stems Position Summa FY 2027 GIS Applications Specialist 1.00 GIS Coordinator 1.00 GIS Intern - Seasonal 0.25 Total FT E uivalent Em lo ees 2.25 Performance Measures City Council Goal: Financially Responsible, High Performance City Organization: Sustainable and Effective Service Delivery � Dept. Objective: Leverage GIS as a data management software to accurately and consistently track City assets and community information. FY FY FY 2026 Performance Performance Measure (KPI) Target 2024 2025 Actual Actual Estimated Indicator Data Accuracy and Completeness 90% N/A N/A 90% Goal Met Project Management Layers 10 7 10 15 Goal Met Dept. Objective: Assist City departments in GIS application development to streamline 2 workflows, centralize citywide data collection, and collaborate across organization outcomes. Total Applications in GIS 1,000 1,215 1,303 1,100 Goal Met New or streamlined workflows using GIS 6 5 7 7 Goal Met 3 Dept. Objective: Produce interactive and engaging content to improve customer service. Website hits to open maps 70,000 45,000* 50,000* 75,000 Goal Met New public facing web applications 15 25 25 20 Goal Met 40 Page 1305 of 1455 Recommended Operating Revenue Budget - Department Total 77 - INFORMATION TECHNOLOGY FY26 FY27 FY24 Actual FY25 Actual Adopted Recomm'd Fund/Account/Account Title Revenue Revenue Budget Budget 100 - General 4A - Charges for Services 47100 - Reimbursements (150,000) (425) — — 47820 - Specialized Services (327,450) (381,750) (390,747) (263,098) 47880 - Central IT Processing (429,018) (478,343) (472,591) (777,538) 4A - Charges for Services Total (906,468) (860,518) (863,338) (1,040,636) 4N -Transfers 49600 - Transfer in Water Op — — — (60,722) 49610 - Transfer In Sanitary Op — — — (60,722) 49620 - Transfer in Storm Op — — — (60,722) 49650 - Transfer in Parking Op — — — (11,739) 49670 - Transfer in Refuse Op — — — (60,722) 4N - Transfers Total — — — (254,627) INFORMATION TECHNOLOGY -Total (906,468) (860,518) (863,338) (1,295,263) 41 Page 1306 of 1455 Recommended Operating Expenditure Budget - Department Total 77 - INFORMATION TECHNOLOGY FY 2024 FY 2025 FY 2026 FY 2027 Fund/Account/Account Title Actual Actual Budget Recomm'd 6A - Salaries &Wages 100 - General 60100 - Salaries-Regular Full Time 977,420 1,084,555 1,127,373 1,466,266 60200 - Salaries - Regular Part Time 516 - - - 60300 - Hourly Wages -Temp/Seasonal 6,735 3,597 34,192 42,794 60400 - Overtime 545 427 3,513 3,513 60630 - Special Pay Sick Lv Payout Ret 5,771 5,895 5,662 598 60635 - Special Pay Sick Lv Payout 50% 4,601 4,325 4,739 4,455 60640 - Special Pay - Vacation Payout 86 32,679 - - 60710 - Special Pay - Parental Leave 672 - - - 6A - Salaries 8�Wages Total 996,346 1,131,478 1,175,479 1,517,626 6B - Employee Benefits 100 - General 61100 - FICA- City Contribution 72,078 81,723 89,924 116,100 61300 - IPERS - City Contribution 91,359 100,169 109,983 143,208 61510 - Health Insurance 178,303 161,558 161,076 225,504 61540 - Life Insurance 512 532 552 736 61600 - Workers' Compensation 1,784 2,127 2,271 1,713 6B - Employee Benefits Total 344,036 346,109 363,806 487,261 6C - Staff Development 100 - General 62100 -Association Dues - - - 110 62325 - Mileage 175 343 1,320 5,000 62400 - Meetings & Conferences 5,711 - 5,980 61,930 62500 - Education Reimbursement 6,570 10,887 21,050 21,250 6C - Staff Development Total 12,456 11,230 28,350 88,290 6D - Repair/Maint/Util 100 - General 63400 - Equipment Maint/Repair 29,453 42,742 51,240 45,750 63730 - Telecommunications 7,053 10,919 7,053 13,955 6D - Repair/Maint/Util Total 36,506 53,661 58,293 59,705 6E - Contractual Svcs 100 - General 64020 -Advertising 70 170 70 200 64081 - Insurance - Liability 8,032 9,158 10,355 9,973 64140 - Printing 1,800 23 1,854 60 64145 - Copying 20 2 20 20 42 Page 1307 of 1455 Recommended Operating Expenditure Budget - Department Total 77 - INFORMATION TECHNOLOGY FY 2024 FY 2025 FY 2026 FY 2027 Fund/Account/Account Title Actual Actual Budget Recomm'd 64160 - Rental - Land/Bldgs/Parking 5,673 162,666 79,530 96,908 64190 - Technology Services 741,739 882,222 1,152,328 1,255,206 64900 - Other Professional Service — — 5,500 — 6E - Contractual Svcs Total 757,334 1,054,241 1,249,657 1,362,367 6F - Commodities 100 - General 65045 - Technology Equipment 1,667 9,391 37,797 74,150 65060 - Office Supplies 2,770 4,033 3,587 4,383 65080 - Postage/Shipping 14 — 15 — 65925 - Uniform Purchase — — — 1,500 6F - Commodities Total 4,451 13,424 41,399 80,033 6G - Capital Outlay 100 - General 67100 - Vehicles — 10,000 — — 67210 - Furniture/Fixtures — 20,000 — — 67500 - Buildings — — — 7,700 6G - Capital Outlay Total — 30,000 — 7,700 INFORMATION TECH -TOTAL 2,151,129 2,640,143 2,916,984 3,602,982 43 Page 1308 of 1455 Recommended Expenditure Budget Report by Activity & Funding Source 77 - INFORMATION TECHNOLOGY FY 2025 FY 2026 FY 2027 Fund/Activity Actual Budget Recomm'd 7701 - Administration 100 - General 6A- Salaries & Wages 1,131,477 1,175,479 1,315,893 6B - Employee Benefits 346,109 363,806 424,225 6C - Staff Development 11,230 28,350 62,130 6D - Repair/Maint/Util 53,661 58,293 59,250 6E - Contractual Svcs 1,054,241 1,249,657 1,295,167 6F - Commodities 13,424 41,399 74,283 6G - Capital Outlay 30,000 — 7,700 7701 - Administration Total 2,640,142 2,916,984 3,238,648 7702 - Geographic Information Systems 100 - General 6A- Salaries &Wages — — 201,733 6B - Employee Benefits — — 63,036 6C - Staff Development — — 26,160 6D - Repair/Maint/Util — — 455 6E - Contractual Svcs — — 67,200 6F - Commodities — — 5,750 7702 - Geographic Information Systems Total — — 364,334 INFORMATION TECHNOLOGY TOTAL 2,640,142 2,916,984 3,602,982 44 Page 1309 of 1455 CITY OF DUBUQUE , IOWA DEPARTMENT DETAIL - PERSONNEL COMPLEMENT 77 INFORMATION TECHNOLOGY DIVISION FY 2025 FY 2026 FY 2027 FD JC WP-GR JOB CLASS FTE BUDGET FTE BUDGET FTE BUDGET 60100 Full Time Employee Expense 100 5000 NB-07 ADMIN SUPPORT PROF - $ - - $ - 1.00 $ 49,897 100 3105 NB-21 CHIEF INFORMATION OFFICER 1.00 $ 164,526 1.00 $ 149,025 1.00 $ 159,262 100 3175 NB-17 CHIEF SECURITY OFFICER 1.00 $ 123,725 1.00 $ 134,797 1.00 $ 102,128 100 6105 NB-13 DATAANALYST - $ - - $ - 1.00 $ 76,820 100 3055 NB-14 GIS COORDINATOR ANALYST - $ - - $ - 1.00 $ 106,459 100 7005 NB-12 GIS SPECIALIST - $ - - $ - 1.00 $ 85,831 HELP DESK SUPPORT 100 7065 NB-07 TECHNICIAN 3.00 $ 172,654 3.00 $ 166,978 3.00 $ 177,598 LAW ENFORCEMENT USER 100 7075 NB-10 SUPPORTSPECIALIST 1.00 $ 71,448 1.00 $ 75,784 - $ - LEAD APPLICATIONS/ 100 3005 NB-13 NETWORKANALYST 3.00 $ 293,134 3.00 $ 304,936 3.00 $ 313,919 SENIOR NETWORK/SYSTEMS 100 3165 NB-15 ADMIN 2.00 $ 218,657 2.00 $ 225,475 2.00 $ 231,497 USER TECHNOLOGY SUPPORT 100 7075 NB-10 SPECIALIST 1.00 $ 66,198 1.00 $ 70,378 2.00 $ 162,855 TOTAL FULL TIME EMPLOYEES 12.00 $1,110,342 12.00 $1,127,373 16.00 $1,466,266 60300 Temporary Employee Expense 100 7055 NB-02 INTERN 1.00 $ 33,302 1.00 $ 34,192 1.00 $ 33,351 100 7000 NB-03 GIS INTERN - $ - - $ - 0.25 $ 9,443 TOTAL TEMPORARY EMPLOYEES 1.00 $ 33,302 1.00 $ 34,192 1.25 $ 42,794 TOTAL INFORMATION TECHNOLOGY 13.00 $1,143,644 13.00 $1,161,565 17.25 $1,509,060 45 Page 1310 of 1455 CITY OF DUBUQUE, IOWA ACTIVITY PERSONNEL COMPLEMENT SUMMARY FY 2025 FY 2026 FY 2027 WP- ACCT FD JC GR POSITION CLASS FTE BUDGET FTE BUDGET FTE BUDGET Information Technology -General Fund 7701 60100 100 5000 NB-07 ADMIN SUPPORT PROF - $ - - $ - 1.00 $ 49,897 CHIEF INFORMATION 7701 60100 100 3105 NB-21 OFFICER 1.00 $ 164,526 1.00 $ 149,025 1.00 $ 159,262 CHIEF SECURITY 7701 60100 100 3175 NB-17 OFFICER 1.00 $ 123,725 1.00 $ 134,797 1.00 $ 102,128 7701 60100 100 6105 NB-13 DATAANALYST - $ - - $ - 1.00 $ 76,820 HELP DESK SUPPORT 7701 60100 100 7065 NB-07 TECHNICIAN 3.00 $ 172,654 3.00 $ 166,978 3.00 $ 177,598 LAW ENFORCEMENT USER SUPPORT 7701 60100 100 7075 NB-10 SPECIALIST 1.00 $ 71,448 1.00 $ 75,784 - $ - LEAD APPLICATIONS/ 7701 60100 100 3005 NB-13 NETWORKANALYST 3.00 $ 293,134 3.00 $ 304,936 3.00 $ 313,919 SENIOR NETWORK/ 7701 60100 100 3165 NB-15 SYSTEMSADMIN 2.00 $ 218,657 2.00 $ 225,475 2.00 $ 231,497 USER TECHNOLOGY 7701 60100 100 7075 NB-10 SUPPORT SPECIALIST 1.00 $ 66,198 1.00 $ 70,378 2.00 $ 162,855 Total 12.00 $1,110,342 12.00 $1,127,373 14.00 $1,273,976 Information Technology-General Fund 7701 60300 100 7055 NB-02 INTERN 1.00 $ 33,302 1.00 $ 34,192 1.00 $ 33,351 Total 1.00 $ 33,302 1.00 $ 34,192 1.00 $ 33,351 Information Technology-FT GIS General Fund GIS COORDINATOR 7702 60100 100 3055 NB-14 ANALYST - $ - - $ - 1.00 $ 106,459 7702 60100 100 7005 NB-12 GIS SPECIALIST - $ - - $ - 1.00 $ 85,831 Total - $ - - $ - 2.00 $ 192,290 Information Technology-GIS Temporary General Fund 7702 60300 100 7000 NB-03 GIS INTERN - $ - - $ - 0.25 $ 9,443 Total - $ - - $ - 025 $ 9,443 TOTAL INFORMATION TECHNOLOGY DIVISION 13.00 $1,143,644 13.00 $1,161,565 17.25 1,509,060 46 Page 1311 of 1455 Capital Improvement Projects by Department/Division INFORMATION TECHNOLOGY Project FY27 Capital Improvement Project Recomm'd Number Title Department Fund Account Budget City-Wide Computer and Printer Information 7769900002 Replacements - General Gov Technology 100 65045 421,032 City-Wide Computer and Printer Information 7769900002 Replacements - General Gov Technology 190 65045 1,700 City-Wide Computer and Printer Information 7769900002 Replacements - General Gov Technology 301 65045 9,000 City-Wide Computer and Printer Information 7769900002 Replacements- Business Technology 621 65045 20,120 City-Wide Computer and Printer Information 7769900002 Replacements- Business Technology 601 65045 20,030 City-Wide Computer and Printer Information 7769900002 Replacements- Business Technology 611 65045 20,630 City-Wide Computer and Printer Information 7769900002 Replacements- Business Technology 811 65045 1,950 City-Wide Computer and Printer Information 7769900002 Replacements- Business Technology 950 65045 11,550 Network Security Risk Information 7769900012 Assessment Technology 304 64900 25,000 Information 7769000017 Network Switch Replacement Technology 601 65045 25,000 Information 7769900017 Network Switch Replacement Technology 611 65045 65,000 INFORMATION SERVICES TOTAL 621,012 47 Page 1312 of 1455 PRGRM/ DEPT PROJECT DESCRIPTION FY 2027 FY 2028 FY 2029 FY 2030 FY 2031 TOTAL PAGE INFORMATION TECHNOLOGY General Government Network Switch Replacement � _ $ 42,500 $ 142,500 $ 142,500 $ — $ 327,500 364 AerialOrthophotography $ — $ — $ — $ 98,800 $ — $ 98,800 366 Network Security Risk Assessment $ 25,000 $ — $ — $ 25,000 $ — $ 50,000 367 City-Wide Computer and Printer Replacements-General Gov $ 431,732 $1,294,736 $ 532,747 $ 376,344 $497,200 $3,132,759 368 Business Type Network Switch Replacement � g0,000 $ 47,500 $ 47,500 $ 47,500 $ 47,500 $ 280,000 370 City-Wide Computer and Printer Replacements- Business $ 74,280 $ 51,944 $ 134,952 $ 32,150 $ 68,580 $ 361,906 372 TOTAL $ 621,012 $1,436,680 $ 857,699 $ 722,294 $613,280 $4,250,965 48 Page 1313 of 1455