The URL can be used to link to this page

Information Services Department FY22 Budget Presentation Copyrighted March 3, 2021 City of Dubuque Public Hearings # 1. Special Meeting ITEM TITLE: Information Services Department FY22 Budget Presentation SUMMARY: SUGGESTED DISPOSITION: ATTACHMENTS: Description Type Information Services Department FY22 Policy Budget Supporting Documentation Outline_Updated 3/3/21 Budget Presentation_Updated 3/3/21 Supporting Documentation Information Services -1- This page intentionally left blank. -2- INFORMATION SERVICES DEPARTMENT % Change From FY FY 2020 FY 2021 FY 2022 2021 Budget Highlights Actual Budget Requested Budget Expenses Employee Expense 777,721 842,450 929,785 10.4 % Supplies and Services 581,775 623,387 672,867 7.9 % Machinery and Equipment 22,055 106,615 73,332 (31.2)% Total 1,381,550 1,572,452 1,675,984 6.6 % Resources Operating Revenue 556,511 582,867 618,844 6.2 % Total 556,511 582,867 618,844 6.2 % Property Tax Support 825,039 989,585 1,057,140 67,555 Percent Increase (Decrease) 6.8 % Personnel -Authorized FTE 9.00 9.00 9.00 Improvement Package Summary 1 of 5 This improvement level decision package request is for a 160 hour concierge care package for professional subscriptions that supplement the support provided through the Laserfiche LSAP subscription for two years. Laserfiche is used by the City for electronic file storage and electronic work flows. The City began using Laserfiche in Fiscal Year 2000 and there has not been a system review since initial implementation. The results of an internal survey of departments indicated that additional training is needed and most departments are not fully utilizing Laserfiche. There is a strong desire by departments to increase use of Laserfiche. Future Laserfiche initiatives include developing a city-wide Laserfiche leadership team which would include decision makers from city departments using or desiring to use Laserfiche. Departments would develop their own Laserfiche initiatives that are reviewed and prioritized by the Laserfiche leadership team as part of a city-wide plan. In an effort to facilitate growth in the use of Laserfiche, the concierge care package would be shared by 22 departments, each department receiving 7 hours. The initial concierge care hours would be used for training and understanding how to properly store documents in Laserfiche, and then move to forms and work flows. The concierge care package includes priority support with fast track escalation policy, priority scheduling for service engagements, two software upgrades, and one server move/migration. The package also includes a bank of professional hours offered at a discounted rate that can be used for updates to the file plan, updates to or review of the security system, updates to forms, forms processes and work flows, system audits and upgrade planning, training and documentation, business continuity planning and testing, development and implementation of maintenance plans to ensure system performance, and professional service engagements of less that 25 hours. This request supports the council goal of Financially responsible City Government and High performance Organization. Related Cost: $ 24,000 Tax Funds Recurring for 2 years Recommend - No Property Tax Impact: $ 0.0094 0.09 % Activity: Information Services -3- 2 of 5 This improvement level decision package request is for design, implementation, custom programming, testing and training assistance for Cartegraph software. In FY2020 the city implemented an enterprise wide licensing model for Cartegraph software. With this model not only are 50 additional licenses available but also access to all of the asset "domains" available within the Cartegraph applications such as Parks and Recreation, Storm Sewer, Signal Networks, Water, Walkability, Facilities Management and Fleet Management are available. Staff in departments that move forward with implementation of asset management and work orders will need assistance in successfully implementing the applications so they work as intended and are on a fast track to deployment within Cartegraph software. The impact on city operations is in support of financially responsible high performance government goal of easy access to city information. Related Cost: $ 25,000 Tax Funds Recurring Recommend - No Property Tax Impact: $ 0.0098 0.10 % Activity: Information Services 3 of 5 This improvement level decision package request is for 80 hours of consultant services to evaluate and make recommendations on the design, configuration, synchronization status, and Domain Naming Service (DNS) configuration of the City's Active Directory (AD) environment. This evaluation will be helpful to not only identify and remedy any issues with the user and device environment but also fully document the current operational schema. Several changes have happened to the AD environment with significant changes happening in the move to Office 365.As the path continues to move to the Azure cloud for user storage and synchronization, the operation ofActive Directory in the cloud becomes critical and primary to the operation and security of the City's computing environment. Related Cost: $ 14,400 Tax Funds Non-Recurring Recommend -Yes Property Tax Impact: $ 0.0057 0.06 % Activity: Information Services 4of5 This improvement level decision package request is for installation of a Firewall between the Airport and the City Core Network. Currently access between the sites is controlled via rules in the City's main firewall along with an older firewall. The Airport has public access along with vendor access on their network. Best practice would place a new firewall between these two segments of the City's network. Related Cost: $ 7,500 Tax Funds Non-Recurring Recommend -Yes Property Tax Impact: $ 0.003 0.03 % Activity: Information Services 5of5 This improvement level decision package request is for support and maintenance for the City's core stack of switches located at City Hall, City Hall Annex and Dubuque Law Enforcement Center. As the City relies more heavily network access either to on-premise or cloud resources, there is a need to maintain and provide priority services on the switches that make up a redundant, highly available switch stack. This service would provide regular maintenance, firmware updates and error log monitoring with priority service response (1 hour call back, along with next day replacement). Related Cost: $ 5,500 Tax Funds Recurring Recommend -Yes Property Tax Impact: $ 0.0022 0.02 % Activity: Information Services -4- Significant Line Items Employee Expense 1. FY 2022 employee expense reflects a 3.0% wage package increase. 2. The lowa Public Employee Retirement System (IPERS) City contribution of 9.44% is unchanged from FY 2021 The employee contribution of 6.29°/o is unchanged from FY 2021. 3. The City portion of health insurance expense increased from $1,025 in FY 2021 to $1,086 in FY 2022 per month per contract which results in an annual cost increase of$5,888 or 5.95%. 4. Overtime is unchanged from $3,513 in FY 2021 to $3,513 in FY 2022. FY 2020 Actual was $2,023. 5. 50% Sick Leave Payout increased from $2,702 in FY 2021 to $3,040 in FY 2022 based on FY 2020 Actual. 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. Supplies & Services 6. Machinery and Equipment Maintenance increased from $39,042 in FY 2021 to $48,700 in FY 2022. This line item includes server maintenance ($25,000); network maintenance agreement ($16,000); and Shoretel hardware and switch maintenance ($7,700). 7. Education and Training unchanged from $12,560 in FY 2021 to $12,560 in FY 2022. This line item represents administrative training for Information Services. 8. The City of Dubuque continues to actively pursue a Broadband Acceleration Initiative focusing on public/private collaborations and includes a comprehensive strategy to reduce the cost and time required for broadband expansions in Dubuque. Information Services serves as part of the Telecommunications Team that plans, designs, implements, and works with partners and staff on new initiatives along with Engineering, Legal and GDDC.Among the benefits of this initiative include no cost internet services to the city saving approximately $18,000 per year, connectivity to several city-sites including Sutton Pool, Eagle Point Water Plant, Comiskey Park, the 3rd Street Water Tower Data center site, City Greenhouse, Bee Branch and several camera and traffic signal locations. The public/private collaborations have also provided shared co-location sites for network co-location at ImOn and ICN points of presence. 9. Software License expense increased from $505,737 in FY 2021 to $544,128 in FY 2022. The software licenses budgeted are as follows: Software FY 2021 FY 2022 Change Office 365 $ 117,021 $ 130,840 $ 13,819 Battery & Environment Monitoring 861 861 - GIS Annual Support 58,700 63,700 5,000 PDQ Deploy 6,750 6,750 - GoToMyPC 8,688 25,412 16,724 (a) GotoMeeting 11,232 14,088 2,856 SophosAntivirus 31,000 30,115 (885) VMWare 24,303 24,303 - Aristotle Insight 13,650 13,650 - Informix 4J's Compiler 604 604 - -5- Software FY 2021 FY 2022 Change Informix 4J's User 4,953 4,953 - Laserfiche 52,106 52,106 - Rightfax 1,808 1,808 - Domain Names/SSL Certificate 2,171 2,171 - FTP Site 5,336 5,336 - Sophos Firewall Maint. 4,722 4,722 - Novus Agenda 4,800 5,800 1,000 Retain Email Archive 33,938 34,606 668 Shoretel Maintenance 8,879 8,879 - Airwatch 13,061 13,877 816 GitHub Maintenance 306 306 - Socrata Licensing & Maintenance - 72,000 72,000 - FreshService Licensing 9,348 2,461 (6,887) (b) Office 365 Manager Plus = 3,720 3,720 - Cartegraph Enterprise Licensing 15,780 15,780 - Total Software $ 505,737 $ 538,848 $ 33,111 (a) GoToMeeting software licenses increase from 80 licenses to 234 licenses due to the pandemic. (b) FreshService cost reduction due to reducing components of the software in FY22. Machinery & Equipment 10. Equipment replacement items include ($73,332): Smartphones (7) $ 2,422 Network Switches $ 63,410 Recommended Improvement Packages $ 7,500 Total Equipment $ 73,332 Revenue 10. Specialized services revenue related to department contracts and maintenance recharges increased from $323,793 in FY 2021 to $371,171 in FY 2022. Information Services uses a recharging system for end users for network installation, PC set-up, maintenance, trouble-shooting, and repair charges thru optional service agreements that began fiscal year 2000. In addition, departments receive recharges for maintenance agreement costs on City wide software based on the number of users in their department. -6- 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. C�ty M��1�g�rrS �fF�ce Infar�ation Services SUCCESS IS ABOUT PLANNING, PARTNERSHIPS AND PEOPLE LEADING TO OUTCOMES PLANNING Information Services works with � all City�epartments and �ivisians to ensure the latest te�hnology is available to carry PEOPLE out Cify Goals and fnitiatives. A knowledgeable and competent staff � ;� � : ' � provides leadership in the te�hnalogy } I activities for the City af oubuque �J including help desk, sys#ems pkanning �, and implementation, network � � administration and telephony. I- � f�, Information Services staff regularly " �� + A� attend annual conferences and � education sessions to gain knowledge � � and best practices. � � �� .�a _ � � �i_ � PARTNERSHIPS Information Servi�es su��essfully integrates people, process and technology by fostering � partnerships and �onsistently delivering solutions ;,� that serve as the foundation of City operations. Te�hnology support is provided for close to 700 _ end-users in�luding Greater�ubuque ❑evelopment Corparation and City and County public safety whi�h includes 911 �ispatch, Duhuque Gounty sheri#f,jail and poli�e. -7- INFORMATION SERVICES FY 2020 FY 2021 FY 2022 Full-Time Equivalent 9.00 9.00 9.00 Resource and Property Tax Support 1,250,000 1,000,000 750,000 500,000 250,000 0 Operating Revenue Property Tax Support FY 2020 FY 2021 � FY 2022 Information Services is supported by 9.00 full-time equivalent employees, which accounts for 55.48°/o of the department expense as seen below. Overall, the departments' expenses are expected to increase by 6.58% in FY 2022 compared to FY 2021. Expenditures by Category by Fiscal Year $777,721 Employee Expense $842,450 $929,785 $581,775 Supplies &Services $623,387 $672,867 $22,055 Machinery& Equipment $106 615 , $73,332 $0 $100,000 $200,000 $300,000 $400,000 $500,000 $600,000 $700,000 $800,000 � FY 2020 FY 2021 � FY 2022 -8- 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. • Infrastructure: Providing effective and efficient use of technology infrastructure and resources. • User Technology Support: Providing high quality, responsive technical support to the City's 700 users of technology. • Security: Sustaining security and protection of the City's data assets using state-of-the art threat protection. • Print Center: Maintaining an active Print Center in support of the City's printing and mailing needs. • Consultation and Project Management: Providing consultation and project management to new and updated technology projects and initiatives. Position Summa FY 2022 Information Services Manager 1.00 Senior Network System Administrator 1.00 Lead Application/Network Specialist 3.00 Information Technology Specialist 1.00 User Technical Support 1.00 Help Desk Technical Support 1.00 Information Services Intern 1.00 Total FT E uivalent Em lo ees 9.00 -9- 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 2018 FY 2019 FY 2020 Performance Actual Actual Estimated Indicator %Virtual Servers Updated (% updated of o 0 0 0 �� total 75 servers) 100/0 90/o 93/0 95/o % Overall Up-Time 99% + 99% 99% 99.99% � 2 Dept. Objective: Provide solutions &services that maximize the investment in technology assets. % storage growth � #Training sessions/education provided for �5 40 50 62 [�� employees by IS staff # Hours planned "down-time"for network $$ 72 �$ �$ � maintenance 3 Dept. Objective: Insuring that data assets are safe and continuity of business is insured. °/o of total inbound intrusions that were 100% 99% 100% 100% � blocked % of total inbound viruses that were blocked 100% 100% 100% 100% � -10- Recommended Operating Revenue Budget - Department Total 77 - INFORMATION SERVICES FY19 Actual FY20 Actual FY21 Adopted FY22 Recomm'd Fund Account Account Title Revenue Revenue Budget Budget 100 53510 FINANCE-DP SERVICE 23,602 23,079 23,713 20,852 100 535ll PAYROLL-DP SERVICE 21,465 20,998 21,632 23,048 100 53512 PERSONNEL-DP SERVICE 4,274 4,162 4,162 3,997 100 53513 BUDGET-DP SERVICE 1,068 1,041 1,041 999 100 53515 ACCTS REC-DP SERVICE 16,123 15,795 16,429 13,858 100 53516 FLEET MAINT-DP SERVICE 1,847 1,847 1,847 1,847 100 53517 PARKING FINES-DP SERVICE 14,959 14,939 16,859 17,705 100 53518 POLICE-LTNIX/SYS SUPPLIES 115,411 115,409 117,742 117,742 100 53519 UTIL BILLING-DP SERVICE 54,879 53,729 55,649 47,625 100 53530 SPECIALIZED SERVICES 317,034 304,820 323,793 371,171 100 53605 MISCELLANEOUS REVENUE 1,233 0 0 0 100 53620 REIMBURSEMENTS-GENERAL 429 692 0 0 Overall-Total 572,324 556,Sll 582,867 618,844 -11- Recommended Operating Expenditure Budget - Department Total 77 - INFORMATION SERVICES FY19 Actual FY20 Actual FY21 Adopted FY 22 Recomm'd Fund Account Account Title Expense Expense Budget Budget 100 61010 FULL-TIME EMPLOYEES 471,294 565,600 600,695 666,241 100 61030 SEASONAL EMPLOYEES 25,550 19,802 27,040 27,854 100 61050 OVERTIME PAY 9,488 2,023 3,513 3,513 100 61092 VACATION PAYOFF 2,969 0 0 0 100 61095 PARENTAL LEAVE 0 1,342 0 0 100 61096 50%SICK LEAVE PAYOUT 0 3,040 2,702 3,040 100 61310 IPERS 47,269 54,072 59,589 69,133 100 61320 SOCIAL SECURITY 36,990 42,357 48,496 53,368 100 61410 HEALTH INSURANCE 102,556 86,688 98,368 104,256 100 61415 WORKMENS'COMPENSATION 1,735 1,535 1,458 1,295 100 61416 LIFE INSURANCE 363 412 458 458 100 61417 LTNEMPLOYMENT INSURANCE 0 444 0 222 100 61660 EMPLOYEE PHYSICALS 131 405 131 405 61-WAGES AND BENEFITS 698,345 777,721 842,450 929,785 100 62010 OFFICE SUPPLIES 690 1,556 690 1,596 100 62011 UNIFORM PURCHASES 0 50 500 50 100 62030 POSTAGE AND SHIPPING 15 54 17 55 290 62030 POSTAGE AND SHIPPING (10) 10 0 10 100 62050 OFFICE EQUIPMENT MAINT 447 463 456 452 100 62090 PRINTING&BINDING 0 57 0 45 100 62ll0 COPYING/REPRODUCTION 138 566 138 566 100 62130 LEGAL NOTICES&ADS 1,641 469 300 469 100 62190 DUES&MEMBERSHIPS 1,097 955 1,ll9 966 100 62206 PROPERTY INSURANCE 9,662 10,120 10,145 10,145 100 62208 GENERAL LIABILITY INSURAN 3,833 3,789 4,025 3,906 100 62310 TRAVEL-CONFERENCES 2,125 3,511 2,449 2,449 100 62320 TRAVEL-CITY BUSINESS 0 30 0 0 100 62340 MTLEAGE/LOCAL TRANSP 275 270 285 285 100 62360 EDUCATION&TRAINING 136 15,033 12,560 12,560 100 62421 TELEPHONE 7,ll4 8,217 7,ll4 20,448 100 62424 RAD10/PAGER FEE 617 633 648 671 100 62436 RENTAL OF SPACE 2,958 2,430 2,958 2,430 100 62611 MACH/EQUIP MAINTENANCE 39,042 4,615 39,042 48,700 100 62663 SOFTWARE LICENSE EXP 474,564 511,148 505,737 544,128 100 62667 DATA SERVICES 1,881 3,046 1,918 3,046 100 62716 CONSULTANT SERVICES 10,068 14,755 33,286 19,900 62-SUPPLIES AND SERVICES 556,292 581,775 623,387 672,877 100 71120 PERIPHERALS,COMPUTER 0 1,050 0 0 100 7ll23 SOFTWARE 0 0 30,240 0 100 7ll24 COMPUTER 0 2,274 0 0 100 71126 HARDWARE 0 4,893 73,975 63,410 100 72418 TELEPHONE RELATED 10,610 13,838 0 2,422 100 72515 TEST EQUIPMENT,OTHER 0 0 2,400 0 71-EQUIPMENT 10,610 22,055 106,615 65,832 100 73210 CONST CONTRACT-BLDG 0 0 0 7,500 73-CIP EXPENDITURES 0 0 0 7,500 -12- Recommended Operating Expenditure Budget - Department Total 77 - INFORMATION SERVICES FY19 Actual FY20 Actual FY21 Adopted FY 22 Recomm'd Fund Account Account Title Expense Expense Budget Budget 77-INFORMATION SERVICES TOTAL 1,265,247 1,381,550 1,572,452 1,675,994 -13- Recommended Expenditure Budget Report by Activity & Funding Source 77-iNFORMATiON SERVICES INFORMATION SERVICES -77100 FUNDING SOURCE:MEDIA SERVICE Account FY20 Actual Expense FY21 Adopted Budget FY22 Recomm'd Budget CIP EXPENDITURES 7,500 EQUIPMENT 22,055 106,615 65,832 SUPPLIES AND SERVICES 581,775 623,387 672,877 WAGES AND BENEF[TS 777,721 842,450 929,785 INFORMATION SERVICES $1,381,550 $1,572,452 $1,675,994 INFORMATION SERVICES TOTAL $1,381,550 $1,572,452 $1,675,994 -14- CITY OF DUBUQUE , IOWA DEPARTMENT DETAIL-PERSONNEL COMPLEMENT 77 INFORMATION SERVICES DIVISION FY 2020 FY 2021 FY 2022 FD JC WP-GR JOB CLASS FTE BUDGET FTE BUDGET FTE BUDGET 61010 Full Time Employee Expense 100 9400 GE-41 INFORMATION SERVICES MANAGER 1.00 $119,966 1.00 $121,681 1.00 $130,163 100 8650 GE-35 SENIOR NETWORK/SYSTEMSADMIN 1.00 $ 79,908 1.00 $ 90,291 1.00 $ 96,686 100 8600 GE-32 LEAD APPLICATIONS/NETWORK 3.00 $217,233 3.00 $222,780 3.00 $259,271 100 8500 GE-30 INFORMATION TECH SPECIALIST 1.00 $ 64,550 1.00 $ 65,320 1.00 $ 66,299 100 GE-27 HELP DESK TECHNICAL SUPPORT 1.00 $ 44,711 1.00 $ 45,955 1.00 $ 49,212 100 490 GE-29 USER TECHNOLOGY SPECIALIST 1.00 $ 62,965 1.00 $ 63,668 1.00 $ 64,610 TOTAL FULL TIME EMPLOYEES 8.00 $589,333 8.00 $609,695 8.00 $666,241 61030 Seasonal Employee Expense 100 650 NA-38 INTERN-SEASONAL 1.00 $ 27,144 1.00 $ 27,436 1.00 $ 27,854 TOTAL SEASONAL EMPLOYEES 1.00 $ 27,144 1.00 $ 27,436 1.00 $ 27,854 TOTAL INFORMATION SERVICES 9.00 $616,477 9.00 $637,131 9.00 $694,095 -15- CITY OF DUBUQUE,IOWA ACTIVITY PERSONNEL COMPLEMENT SUMMARY FY 2020 FY 2021 FY 2022 ACCT FD JC WP-GR POSITION CLASS FTE BUDGET FTE BUDGET FTE BUDGET Information Services-General Fund 10077100 61010 100 9400 GE-41 INFO SERVICES MANAGER 1.00 $119,966 1.00 $121,681 1.00 $ 130,163 SENIOR NETWORK/SYSTEMS 10077100 61010 100 8650 GE-35 ADMIN 1.00 $ 79,908 1.00 $ 90,291 1.00 $ 96,686 10077100 61010 100 8600 GE-32 LEADAPP/NETWORKANALYST 3.00 $217,233 3.00 $222,780 3.00 $ 259,271 10077100 61010 100 8500 GE-30 INFO TECHNOLOGY SPECIALIST 1.00 $ 64,550 1.00 $ 65,320 1.00 $ 66,299 10077100 61010 100 GE-27 HELP DESK TECHINICAL SUPPORT 1.00 $ 44,711 1.00 $ 45,955 1.00 $ 49,212 10077100 61010 100 490 GE-29 USER TECHNOLOGY SPECIALIST 1.00 $ 62,965 1.00 $ 63,668 1.00 $ 64,610 Total 8.00 $589,333 8.00 $609,695 8.00 $ 666,241 Information Services-General Fund 10077100 61030 100 650 NA-38 INTERN-SEASONAL 1.00 $ 27,144 1.00 $ 27,436 1.00 $ 27,854 Total 1.00 $ 27,144 1.00 $ 27,436 1.00 $ 27,854 TOTAL INFORMATION SERVICES DIVISION 9.00 $616,477 9.00 $637,131 9.00 $ 694,095 -16- Capital Improvement Projects by Department/Division INFORMATION SERVICES FY 19 Actual FY 20 Actual FY 21 Adopted FY 22 Recomm'd CIP Number Capital Improvement Project Title Expense Expense Budget Budget 1001069 INTERNET,MICROS&PRINTER 747 1011069 INTERNET,MICROS&PRINTER 54,190 104,861 1012940 FIBER OPTIC DOC&MAINT 100,000 1021051 OFFICE REDESIGN 25,000 1021069 INTERNET,MICROS&PRINTER 378,985 270,004 405,827 488,355 1022683 WORKSTATION/CHAIR REPLACE 1022684 LASERFICHE FULL USER LICE 9,707 1022726 ANNEX 2ND FLR LOW VOLTAGE 1022808 NETWORK SEC RISK ASSESS 10,000 10,000 1022809 REDUNDANT NETWORK SWITCH 74,000 1022864 RANSOMWARE DEFENDER REC - - 47,400 - 2501069 INTERNET,MICROS&PRINTER - 8,805 - - 2502435 CITY WIDE MULTIFLTNC RPL - - 3,680 - 2901069 INTERNET,MICROS&PRINTER 5,116 6,751 3,070 5,600 3001069 INTERNET,MiCROS&PRINTER 4,741 2,200 13,240 3501069 INTERNET,MICROS&PRINTER 40,731 208,926 297,337 3501846 NETWORK SWITCH RPLC 12,513 3502435 CITY WIDE MULTIFUNC RPL 91,974 3502565 10 GBE NETWORK CARD CABLE 3502628 NOVELL FILE MGMT SUITE 3502808 NETWORK SEC RISK ASSESS 12,000 5,000 3502809 REDLTNDANT NETWORK SWITCH 75,229 3502862 ENTERPRISE FIREWALL SEC 37,955 3502865 NETWORK MONITORING TROUB 30,240 3502939 DATA VAULT 200,000 3502941 ISILON D1SK STORAGE 250,000 6001069 INTERNET,MICROS&PRINTER - 10,366 - - 6002435 CITY WIDE MULTIFUNC RPL - - 4,580 - 6701069 INTERNET,MICROS&PRINTER - 3,831 5,368 - 6702435 CITY WIDE MULTIFLTNC RPL 2,547 7101069 INTERNET,MICROS&PRINTER 41,146 10,387 6,169 250 7102435 CITY WIDE MULTIFLTNC RPL 4,963 7201069 INTERNET,MICROS&PRINTER 7,137 11,119 5,460 7202435 CITY W1DE MULTIFUNC RPL 7301069 INTERNET,MICROS&PRINTER - 12,947 - - 7302435 CITY WIDE MULTIFUNC RPL - - 3,070 - 7401069 INTERNET,MICROS&PRINTER 73,312 12,609 569 - 7402435 CITY WIDE MULTIFLTNC RPL 9,620 8101069 INTERNET,MiCROS&PRINTER 1,783 14,260 4,400 2,200 8102435 CITY WIDE MULTIFLTNC RPL 0 0 4,280 0 9401069 INTF.RNET,MICROS&PRINTER 14,496 9,270 2,550 42,820 9402435 CITY W1DE MULTIFUNC RPL 0 0 0 0 INFORMATION SERVICES TOTAL 583,476 525,218 986,507 1,520,491 -17- PRGRM/ DEPT PROJECT DESCRIPTION FY 2022 FY 2023 FY 2024 FY 2025 FY 2026 TOTAL PAGE INFORMATION SERVICES Business Type City-Wide Computer and Printer Replacements-Business $ 50,730 $ 43,370 $ 92,162 $ 70,806 $ 24,210 $ 281,278 366 General Government City-Wide Computer and Printer Replacements-General Gov $ 804,532 $ 396,980 $ 458,896 $ 339,685 $387,654 $2,387,747 329 Data Vault $ 200,000 $ - $ - $ - $ - $ 200,000 330 Network Security Risk Assessment $ 15,000 $ - $ 15,000 $ - $ - $ 30,000 331 Layer 2 Redundant Network Switch $ 75,229 $ - $ - $ - $ - $ 75,229 332 Upgrade Isilon Disk Storage System $ 250,000 $ - $ - $ - $ - $ 250,000 333 Fiber Optic Documentation and Maintenance $ 100,000 $ 100,000 $ 50,000 $ - $ - $ 250,000 334 Office Redesign $ 25,000 $ - $ 50,000 $ - $ - $ 75,000 335 Ransomware Defender and File Recovery $ - $ - $ 3,210 $ - $ - $ 3,210 TOTAL $1,520,491 $ 540,350 $ 669,268 $ 410,491 $411,864 $3,552,464 -18- �`'� . _ ..�.._ . � , n � 1 1 � ' � � 1 r � , • • • '� - � . 7 \ • � -� � � � - _ ��a- .��' - '� � . ��`�+'�al \ � � \ . � ,��,�..� � 4 � '�h� f ,�� r • .'� � - � / � � � T � � I 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. � � � � � � ' � i � � � � � � � � Information Services Manager Chris Kohlmann Help Desk nior Network Information Technical Support dministrator ervices Intern Yanely Nordin Joe er Hannah Hamann ea ea ea Applications/ plications/Netw lications/Network ork Analys ork Analyst nalyst (DLEC) Ton Steffen Scott Schlichte Stace Moore n or n User Technology Tech gy IS Intern (DLEC) Specialist Specialist Vacant Alicia Turnis Jim Vosberg P RI O R YEAR HIGHLIGHTS ■ ■ • Broadband Partnershi s p � Alliant � I mOn � US Cellular � Ve ri zo n � Wisconsin Inde endent Network p � U PN FISCAL YEAR 2021 HIGHLIGHTS � ;.�� . . . .� ■ ■ � -�� . * �� _._ � � � . • Cber-Secu rit � �5� � � � � �..�_, _ �l-Y��-==� y y � � � _ _ _ � 1 � NetworkAssessment and � � . �. _ _ x . Testi n --�� - y = r �" g , �� , � Increased Em hasis on =��==�- T�:� � � � p � � = ��.:� C bersecu rit Awareness �' '�+�� -� �� y v �- o - � � , � Enhanced secur�ty � M FA � ' - .� . � ' . ,. �__ � �� Stron Passwords g � Exception Reporti ng � • Broadband Public - Private Partnerships � • • Equity and Digital Divide ■ ■ • S oftwa re � Laserfiche � M i lestone I ntercon nect Camera System � ERP System Selection and Implementation � Office365/Teams • N etwo rk � Security Risk Assessment Response � Implementation of Proactive Monitoring Tools � Ransomware and File Integrity � Firewalls, Layer Two Switching • . • ' � ' ■ ' • • ' 1 � !� � � �I�JJ � �� ■ � I_�.l�� 1 057 140 16 . 68 � � 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 Services (*Avg. home value of $146,567) Infrastructure ■ ■ ^ �� . ._ _ . �� _ � B ro a d b a n d P a rt n e rs h i s � �� y �� +�� p � � �5. -� - • 43 Agreements with 14 Providers and � - * _..�.�� * .. �'�.�� ` Partners � , � �� _ _ - - - .___ ��.�. • Creating new major redundant fiber routes to protect and - __ . � ,_ � support existing City networks. � �.:��•�� L � - ��' -� � .� � � �¢�.f,�.��:._,�+�- : , • Providing service to City and public facilities presently not � '- :� - � � � �� .. reachable via City fiber. �' � � -- �� • Revenue generated through the lease or sale of new fiber ' �� capacity. ' � �� • Supporting the availability, quality and safety of the ROW within the City • � r r �'► • - �� - � � � Futura Fi6er Needs[Paint} .� � • �nc�nezr:nc �f•i•� =� . � I � Enc�ne�r:n�.Car-era � . _ . _ ^i � .- ` Enc:ne�r:nc.5�ADA � ^'i . �] Enc�:netr;n�.5e��:a:i'ur-�Stat:vn . � . ._ 2 Enc�ine�r:n�.S�h�o Corra�t:or .._ � . ..J �� . . .. . � �nc:ne�r:n� Storm�a�.•ar Pur�Stat��n . � ��; � • � Farlcw.Cam�•a - i ��, I � i � � Parks.Ferk I �� ..l � i,� � Farks F,.�!��=a�il:t� �i�.�I ^� -- � � �..�Fr7str:6uton.ti�4'aterPumpS-e-�o- �,I A ` I.t � r-- ._. �'! ..�_�.�strhuton.'•A�ater�ower _ � ... _ ;� f� � i h�i i�. I � - _ � ..e_:.lscri`�ut�on.'s;`ate•,Po'ell I fi, "7� j*' �' "�'.� � �.. � i �, ,.: �� - �� '• i�., ,j _ .. ._�, �.�. �' � - u� _ �— _ - � �'J � �''�� '� � �ruture Fi 6er Needs(LineJ �� ``- �• ^`'-' � i� ,� � , I,^ rij � �: _ _ : s —., a�t��=-�i ,� _ � I�.l, . .' - ��r of�..., � _ =�� t r� ,� �,�, �. � , ^ . �:1 � � �w � Car=ec � F � �-.,... . . _, �::-`:w, . . . � �- .. �n Car^mumce-.o^c , - �'i � f1 ...._ _i ".. ; -•-- '�I f,-; I f . .. ` -<a ot�.e-�,alues:, - �►.� r_1 , �� I i ` � Small Cell Locations ■�_�l . I ' - . � �� i;c•:e F1 . - _. � I_� ? �� :'apa�ec ' - ... _ �•;i � 1 � 8ase Map ' — � �^� � : i � 1 � �m L �i '�� - � � i I _ � �� - � 7 � � �� L .- � , Legenc /� . - ACS In#�rnet Car�nectivity Yariafoles- Boundaries-Tract _ [�uranri�= � ,� _ � ■ Fercent of Hauseho.cs��i�h No Inte�r.et Acce�s � � �J 4 "'�'�� 20-25.2 l�a � � �e�-.su� -ravt':01,i]? �>:� f � ��.,5—1'.. Birch�+aoc � '' Gol�Cour� � � °. - 1�.� � : . 4.4-9,1 �, � i u� " 4� ' '� ' ' �_ N � ui � �711vCIG TI�s�.E�t � �.BP?Sll3 fdur."�,iil �. :,+ � ' � C�n�u� Tr_;c-.; . � �5 ��E:"�SLI� -rac�"1.ii1 C�n=�iv Tr.,c=5 ''ti . 7 q�f , . y� � +r ��173LI3 =4 - x ' ' �� 1��'l': � f'�l3SLItTract701,�74 �v=r�s_:s T:a��t 11,v.' , �s Cen�us Trac�?.::�; : ��.�•s_s - �_t 11,��^ , r 'v:!'S:5 T"e�vt 1L,v1 dllkkllf,�l1E' �'�¢ Cen=�i}Tr°c_�, ��:.... # Cen��i�Trr:c:' ::i� �� o� L �: 4';�A Ea�t � '.. aubuc�ue �� 'o-. _ �i' ��i ...:�i�.::t�� 4� � Luit.inin• �� ?��i" v�ay R`� . tii� �BI1tiLl�TIt:C:�,1�1 Cen��i�Tr:L:3.Ci7 �.k a.,�r:�. fier-:su� �rt��["ii1,ii4 � 0,5 4mi '--'-_ _ --a= ..- -_�.__ ==..--"_=a ...i�: �iii�.�� .i�-F � ser ec no o u or . . . . � ca � ons an a es Sophos Mobile FreshService Ticketing System M itel Phone System U pg rade Network Switch Replacements ■ ■ onsu a � on an ro ec ■ ■ ana emen Cartegraph • Enterprise Licensing Agreement • H ig h Performance Govern ment M u Iticu Itu ral Fam i ly Center • Av Implementation • Tech nology Su pport Transportation • Updated Fare , Cameras and On-Board Technology • Work From Home • On -Li ne Meeti ngs � � • Fresh Service Ticketing System � • • • Remote Su ort pp • Telephone and Mobile • � • POD TechnologyAssistance ` � � �_� ��:�� f,� .. _. +�t ''� �_ MDF ..� E�Lrr�za ,ry n P�N��S � � ! • • �� T��_ 'r�`'C��`' - � ' . • • � �_ ,: �� . ,� � � • � 1 1 _ ` '��y � , . �� ;�--� , �I�� 4�,�ox pG� �}�S.T�-�D, - ry G ti G ,�' . � J i'y�, ��u� G �j � �� W ;y \`� � ww, wµ�.. �� - -_, �:. � 4 O O ' �'`r� ! �� rcl_r ue�'°�,� - �� T�� ,_ ��s `a� �.'�+nl—.�.o`��.�_...�ii� 1�� . .. L.j�,� ,.. � �• i ,...,. �, . _ Mnu_' _ • Remote Communications Software • Wireless Hot S ots, Ada ters � p p � • • � and Cables • Mobile Data and Voice • � . . � $63,500 Additional Expenses to date � f,� �.�:�:�� .. _. ,t �,�, �_ MDF ..� E�Lrr�za ,ry n�` P�N��S � � ! • • �� T��_ 'r�`'C��`' - � ' . • • � �_ ,: �� . ,� � � • � 1 1 _ ` '��y � , . �� ;�--� , �I�� 4�,�ox pG� �}�S.T�-�D, - ry G ti G ,�' . � J i'y�, ��u� G �j � �� W ;y \`� � ww, wµ�.. �� - -_, �:. � 4 O O ' �'`r� ! �� rcl_r ue�'°�,� - �� T�� ,_ ��s `a� �.'�+nl—.�.o`��.�_...�ii� 1�� . .. L.j�,� ,.. � �• i �W .. . .' ' ' � � - • � � - - • � !� 1 . 80-Hours of Consultant Services Non-Recurring � $ 14,400 2. Installation of Firewall between Airport and the City Core Network Non-Recurring � $7,500 3. Support & Maintenance of City's Core Stack of Switches Recu rri ng � $5,500 Information Services Department FY 22 CAPITAL IMPROVEMENT PROJECTS ' . . . . City-Wide Computer & Printer Replacements $ 855,262 $ 2,669,025 Data Vault $ 200,000 $ 200,000 Network Security Risk Assessment $ 15,000 $ 30,000 Layer 2 Redundant Network Switch $ 75,229 $ 75,229 Fiber Optic Documentation and Maintenance $ 100,000 $ 250,000 Office Redesign $ 25,000 $ 75,000 Upgrade Isilon Disk Storage System $ 250,000 $ 250,000 Information Services Department 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 2018 FY 2019 FY 2020 Performance Actual Actual Estimated Indicator %Virtual Servers Updated (% updated of total 75 100% 90% 93% 95% � � servers) % Overall Up-Time 99% + 99% 99% 99�99% - 2 Dept. Objective: Provide solutions &services that maximize the investment in technology assets. % storage growth - #Training sessions/education provided for 75 40 50 62 � � employees by IS staff # Hours planned "down-time"for network $$ 72 78 78 ' maintenance 3 Dept. Objective: Insuring that data assets are safe and continuity of business is insured. % of total inbound intrusions that were blocked 100% 99% 100% 100% _ °/o of total inbound viruses that were blocked 100% 100°/o 100% 100% _ www. cityofd u buq ue . org/422/I nformation -Services