The URL can be used to link to this page

Information Services FY19 Budget PresentationCopyrighted February 7, 2018 City of Dubuque Public Hearings # 1. IT EM T IT LE:Information Services FY2019 Budget Presentation SUM MARY: SUGGEST ED DISPOSIT ION: ATTACHMENTS: Description Type FY19 Information Services Budget Recommendation Supporting Documentation -1- Information Services -2- This page intentionally left blank. -3- INFORMATION SERVICES DEPARTMENT Budget Highlights FY 2017 Actual FY 2018 Budget FY 2019 Requested % Change From FY 2018 Budget Expenses Employee Expense 737,087 741,118 776,101 4.7 % Supplies and Services 541,293 562,835 549,551 (2.4)% Machinery and Equipment 18,507 9,500 29,250 207.9 % Total 1,296,887 1,313,453 1,354,902 3.2 % Resources Operating Revenue 530,532 534,817 573,394 7.2 % Total 530,532 534,817 573,394 7.2 % Property Tax Support 766,355 778,636 781,508 2,872 Percent Increase (Decrease)0.4 % Personnel - Authorized FTE 9.00 9.00 9.00 Improvement Package Summary 1 of 2 This improvement package would provide funding to begin replacement of the oldest and least functional Shoretel Internet Protocol phones. It is proposed to start a multi-year process of telephone replacement starting with approximately 50 phones in FY2019. The phones to be replaced were installed as part of the original telephone installation in 2009 of over 600 phones. Most Internet Protocol phones used in the City, including these, will be 10 years old in FY 2019. These phones have the least functionality and/or are failing for users. In addition - these phones no longer have any vendor support and are becoming less available on the 3rd party/used market if a replacement is needed. The phones would be replaced with phones that take advantage of the faster Gigabit connection and have additional functionality to better accommodate call handling. It is anticipated that approximately 50 phones per year for the following 4 years would be replaced. This first set of 50 phones will provide insight into what the most effective replacement cycle for subsequent years for telephones will be. Related Cost:$11,950 Tax Funds Recurring for 4 Years Recommend - Yes Property Tax Impact:$0.0048 0.05% Activity: Information Services 2 of 2 This improvement package would provide funding for replacement of Uninterruptable Power Systems (UPS) units connected to Servers. UPS units are not replaced on the same replacement cycle as servers. The current practice is to wait until a UPS begins to warn of failure and replace at that time. The expected life of all APC batteries is 3 - 5 years - this assumes optimal conditions for temperature and airflow as well as frequency of power failure. -4- APC recommends the following life cycle considerations for UPS: Age of UPS Recommended Action to Mitigate Failure 1 - 3 Years Extended Warranty 3 - 7 Years Battery Replacement More than 7 years Old UPS Replacement As the City places much reliance on mission critical operations that reside on servers connected to the UPS that would provide clean and consistent power this project insures maximum uptime and operations. This package would replace any UPS units 7 years old (or older) and begin a process of putting the UPS units on a 7-year equipment replacement schedule. Related Cost:$17,300 Tax Funds Non-Recurring Recommend - Yes Property Tax Impact:$0.0069 0.07% Activity: Information Services Significant Line Items Employee Expense 1. FY 2019 employee expense reflects a 1.5% wage package increase. 2. The Iowa Public Employee Retirement System (IPERS) City contribution increased from 8.93% in FY 2018 to 9.44% in FY 2019. This resulted in an increase of City IPERS expense of $2,810 in the Information Services Department. The employee contribution increased from 5.95% in FY 2018 to 6.29% in FY 2019. 3. The City portion of health insurance expense decreased from $1,325 in FY 2018 to $1,193 in FY 2019 per month per contract which results in an annual cost savings of -$8,744 or -10.00%. 4. Overtime is unchanged from $3,513 in FY 2018 to $3,513 in FY 2019. FY 2017 Actual was $3,178. 5. The Help Desk Technical Support position in Information Services is tentatively unfrozen effective May 1, 2019 with a cost of $10,468 ($63,937 in FY 2020). Supplies & Services 6. Machinery and Equipment Maintenance is decreased from $61,656 in FY 2018 to $48,700 in FY 2019. This line item includes server maintenance ($25,000); network maintenance agreement ($16,000); and Shoretel hardware and switch maintenance ($7,700). The network maintenance agreement decreased from $29,000 in FY 2018 to $16,000 in FY 2019. 7. The City has eliminated the Internet services contract with Lightedge (-$18,646) due to receiving Internet service through an agreement with Wisconsin Independent Network which is part of a ten year public/private fiber optic conduit sharing agreement. 8. Software License expense increased from $461,191 in FY 2018 to $463,449 in FY 2019. The software licenses budgeted are as follows: -5- Software FY 2018 FY 2019 Change Office 365 $63,360 $110,809 $47,449 (a) Battery & Environment Monitoring 862 845 (17) GIS Annual Support 59,823 58,765 (1,058) Zenworks Asset Management 25,700 25,426 (274) GoToMyPC 8,474 8,688 214 GotoMeeting 9,738 9,360 (378) Microsoft Licensing Servers & Desktops 46,157 40,000 (6,157) Sophos Antivirus 10,067 10,208 141 Spam Filter 34,217 23,798 (10,419) VMWare 20,549 17,025 (3,524) Aristotle Insight 10,853 13,381 2,528 Informix 4J's Compiler 1,981 2,700 719 Informix 4J's User 2,908 5,047 2,139 Cognos 1,788 —(1,788) EMC Maintenance Storage 18,421 —(18,421)(b) EMC Maintenance Tape Library & DLEC SAN 2,494 —(2,494)(b) Laserfiche 36,760 35,332 (1,428) Laserfiche Forms 1,500 1,500 — Rightfax 1,790 1,755 (35) Domain Names/SSL Certificate 1,379 1,512 133 FTP Site 5,238 5,034 (204) Verdiem Surveyor 1,180 —(1,180) Novus Agenda 3,954 3,800 (154) GWAVA Email Archive 26,020 26,021 1 Solar Winds 1,277 3,053 1,776 Shoretel Maintenance 9,104 8,750 (354) Airwatch 11,594 10,640 (954) File Management 4,004 —(4,004)(c) Socrata Licensing & Maintenance 40,000 40,000 — Total Software $461,192 $463,449 $2,257 (a) Office 365 increase due to an increase in the number and type of Office 365 licenses. The change was due to a need for additional "full" and "kiosk" type licenses where computers are shared and e-mail retention is needed and full functionality of Office 365 software at the desktop is used. The shared computers are most prevalent at Dubuque Law Enforcement Center and Fire. (b) EMC Maintenance is now included in the purchase of the software. (c) Canceled Novell File Management Service. Machinery & Equipment 9. Equipment replacement items include ($29,250): Improvement Package Requests $29,250 -6- Revenue 10. Specialized services revenue related to department contracts and maintenance recharges increased from $287,107 in FY 2018 to $317,034 in FY 2019. 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 -7- INFORMATION SERVICES Information Services provides efficient, effective and functional use of resources to create a resilient and sustainable information technology deployment for the City of Dubuque. SUCCESS IS ABOUT PLANNING, PARTNERSHIPS AND PEOPLE LEADING TO OUTCOMES -8- INFORMATION SERVICES Information Services is supported by 9 full-time equivalent employees, which accounts for 57.28% of the department expense as seen below. Overall, the departments’ expenses are expected to increase by 3.16% in FY 2019 compared to FY 2018. Expenditures by Category by Fiscal Year -9- INFORMATION SERVICES Overview The City of Dubuque maintains a centralized, full service data center for all City departments and divisions. This service is provided by implementing information processing techniques to securely gather, compute, store, process and convey information. The work of this activity provides: • User Technology Support: Providing high quality of technical solutions and support services to all users. This work includes technology problem response, installation/ upgrades, print and production services and communications and network services • Technology Direction and Assistance: Providing the solutions and services that maximize the investment in technology. • Resilient and Secure Technology Infrastructure: Insuring that data is secure, safely stored and continuity of business is insured. The major functional areas of Information Services are: User Technology Support. Information Services staff provides troubleshooting and implementation assistance to over 700 end-users in the areas of software problem determination, debugging, hardware maintenance, repair and procedural problem solving. User support for over 200 different applications is provided with approximately 5000 hours by staff expended in this activity. In addition, off-hours computer assistance is available on weekends and holidays. Technology Direction and Assistance. Staff provides implementation assistance to new and upgraded software applications such as the Sungard Financial System and Transit ITS projects as well as technology assistance needed for new construction projects such as the new transit garage and Upper Bee Branch Creek Restoration Project. The Bee Branch project included digital signage, SCADA, and lighting control assistance. Print and Production Services. Information Services provides legacy system production job scheduling, print services along with automatic financial and applications data transfer (i.e. ACH.) All production job schedules, outputs and equipment are created and monitored for accuracy, security and completeness. Equipment is monitored for service needs. Annually the print services produce approximately 415,000 prints and processes 350,000 inserts with a majority of these mailed for revenue generating and informational purposes. -10- INFORMATION SERVICES Resilient and Secure Technology Infrastructure. Information Services provides monitoring, detection and alerting for networks, connected servers, storage and end-points. Using a combination of intrusion detection, firewalls, e-mail security, change management and a system of regular patch and update management along with real time alerts provides a system that maximizes security of mission critical data and communications. Data traffic on internal external, process control (SCADA, Lighting systems) public safety and traffic/camera systems are monitored. All servers and application data residing on those servers is replicated and backed up between the data center at DLEC and City Hall Annex. Tape backups are created on a regular schedule and stored off-site. Cloud hosted applications are required to meet industry best practices for replication, backup and recovery. Working in partnership with Racom, Information Services provides monitoring and trouble-shooting for the wireless networks which include mobile computers in the public safety vehicles, remote water meter readings and surveillance cameras Communications and Network Services Information Services specifies, supports and works with departments to better utilize features and functionality of the City’s communications resources. As the city becomes an “always and anywhere” connected workforce, unified communication and access to data resources in the field are key to organization efficiency and effectiveness. Mobile device deployment continues to show a growth in both applications and number of devices. In past year Information Services has played an important role in identifying needs and availability of fiber optic conduit and cable for public-private partnerships. Working in partnership with GDDC and Engineering with new public private Master Services Agreements (MSA’s). The value-added services translate directly into operating and capital cost savings and expanded services in addition to expanded broadband for the community. Position Summary FY 2019 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 Equivalent Employees 9.00 -11- Highlights of the Past Year • On-going design, implementation and training for Sungard Public Safety Software serving City and County law enforcement and Fire • Significant development for both Open Performance and Open Data applications • Migration implementation and training completed on work to a fully integrated Microsoft environment • Public/Private Fiber Optic and Conduit agreements completed including WIN, CS Technologies, ATT, Centurylink, Mediacom and ImOn • Installation of new storage area networks with total storage of approximately 400TB. The configuration includes (2) Storage Area networks for “structured data” and 2 “Data Lakes” serving a rapidly growing need for high speed large storage capacity. • In 2017 IS began a more expanded role in specification, monitoring and server management of Milestone traffic and surveillance video applications. • Other projects involving new and/or upgraded software included the DBQIQ Water portal, Neptune remote meter readings, Office 365, Socrata Open Data and Open Performance, Body Cameras, SCBA, and Accela permitting and licensing. Future Initiatives • Continuing Open Data initiatives including Open Performance Measures, Open 311 and access to open data sets • Implementation of updated technologies including financial software, and Code Enforcement • Implementation of a 3rd data center for back-up, failover and high availability operations • Continue work with Cartegraph on implementation and support of process and products in support of a high-performance data driven organization • Continue work with leveraging investments in Fiber Optic and Conduit sharing specifically concentrating on update of sites served by I-Net fiber -12- INFORMATION SERVICES Performance Measures Information Service – Activity Statement Provide efficient, effective and functional use of resources to create a resilient and sustainable information technology deployment for the City of Dubuque. Goal: Financially Responsible, High Performance City Organization Outcome #1: Providing high quality of technical solutions and support services to all users. Whether it is for daily access or in a disaster situation, the City’s end-users and residents have an expectation that their technical resources will be accurate, supported by a technically competent and “user friendly” staff and readily available. What this means to the resident Technology resources are highly available with a service delivery of 99% uptime for users of technology providing citizen and organization services. This objective is accomplished by: • Providing a highly available and scalable technology environment consisting of: Virtualization of servers at a 9:1 ratio A regular replacement schedule for servers, workstations and mobile devices Efficient use of large capacity Storage Area Networks (SANs) 10 TB and Data Lake 387 TB • Maximizing the use of a fast, robust and scalable communications services - both wired and wireless • Clustering resources to provide failover in event of hardware failure. Performance Measures KPI: Overall Up-Time: 99% Replaced 106 personal computers Installed 7 ESXi Host Boxes Installed 1 Log management Appliance Updated 27of 75 virtual Servers -13- INFORMATION SERVICES Outcome #2: Providing the solutions and services that maximize the investment in technology assets. The investment in technology is maximized when: • End-users are equipped and capable of using technology resources where and when needed. • Investment in current technology is leveraged What this means to the resident: Investments in technology are maximized. This objective is accomplished by: • Use of products within a “suite” of product offerings so integration and support for that integration is built in to the product • Using software solutions that are highly available and functional across desktop and mobile devices • Using tools that regularly alert and notify of security, performance and availability issues • Use of Western States Alliance/NASPO and State of Iowa contract pricing to leverage buying power • Identifying and using capacity management tools to project growth and use of network and storage capacity • Solutions and services provide proactive monitoring and alerting • Automating regular processes such as software update delivery • Educating end users on technology resources and the availability of data assets • Continuing staff education and collaboration • Expanded use of mobile applications • Use of AirWatch mobile device management • Use of tools such as Zenworks to provide regular and automatic updates to applications • Planned and managed use of wired and wireless technology and assets • Vigilant watch of technology reports to be proactive in defense of the latest security vulnerabilities. Performance Measures KPI: 3% increase in budgeted annual software costs • Storage growth: 15-20% / Year • The average cost per Gigabyte across all SANS is .05 • Staff Provided Training/Education: 50 sessions • Planned “down” time for System Maintenance: 72 hrs -14- INFORMATION SERVICES Outcome #3: Insuring that data assets are safe and continuity of business is insured. Although the potential for the City’s technical infrastructure and data assets exposure to internal and external threats is always present; those dangers are minimized through effective processes, policies and applications. What this means to the resident: Data is safe, the technology environment is resilient and citizen services are provided with a high level of accuracy and availability. This objective is accomplished by: Partnering with resilient service providers Monthly production schedule for legacy operations Maintaining a system of backups, virus detection and inoculation, web site filtering and monitoring and off-site storage. Implementation of highly available network, telephony and mobile resources Implementing a change management policy for systems Production jobs are delivered on schedule and accurately Maintaining security of systems per standards of HIPPA, employment and law enforcement Leveraging cloud and hosted resources where there is a good “fit” Performance Measures KPI: 0% successful compromise or intrusion • Security and Performance notifications: 100% received and acted upon • System breach/compromise attempts: Blocked inbound breach/compromise attacks at the firewall: 44 Intrusions, 24 Viruses Outbound compromise blocked at spam filter: 136 Phishing attacks, 60 Viruses • Backup Job Success: 99.9% • Production jobs delivered on-time: 100% DID YOU KNOW? The average cost to remediate, restore and inform customers per breach of the system is estimated at $141 per record. -15- Recommended Operating Revenue Budget - Department Total 77 - INFORMATION SERVICES Fund Account Account Title FY16 Actual Revenue FY17 Actual Revenue FY18 Adopted Budget FY19 Recomm'd Budget 100 53510 FINANCE-DP SERVICE 21,922 22,383 22,882 23,602 100 53511 PAYROLL-DP SERVICE 19,944 20,362 20,814 21,465 100 53512 PERSONNEL-DP SERVICE 3,955 4,041 4,137 4,274 100 53513 BUDGET-DP SERVICE 989 1,010 1,034 1,068 100 53515 ACCTS REC-DP SERVICE 15,001 15,311 15,642 16,123 100 53516 FLEET MAINT-DP SERVICE 1,848 1,848 1,848 1,847 100 53517 PARKING FINES-DP SERVICE 14,164 14,401 14,633 14,959 100 53518 POLICE-UNIX/SYS SUPPLIES 107,879 111,180 113,490 115,411 100 53519 UTIL BILLING-DP SERVICE 51,029 52,091 53,230 54,879 100 53530 SPECIALIZED SERVICES 279,516 285,173 287,107 317,034 100 53605 MISCELLANEOUS REVENUE 0 2,407 0 2,407 100 53620 REIMBURSEMENTS-GENERAL 337 325 0 325 53 - MISCELLANEOUS 516,584 530,532 534,817 573,394 77 - INFORMATION SERVICES TOTAL 516,584 530,532 534,817 573,394 -16- Recommended Operating Expenditure Budget - Department Total 77 - INFORMATION SERVICES Fund Account Account Title FY16 Actual Expense FY17 Actual Expense FY18 Adopted Budget FY 19 Recomm'd Budget 100 61010 FULL-TIME EMPLOYEES 484,971 518,475 507,910 543,356 100 61030 SEASONAL EMPLOYEES 6,369 15,337 26,146 26,540 100 61050 OVERTIME PAY 6,547 3,178 3,513 3,513 100 61092 VACATION PAYOFF 2,044 0 0 0 100 61310 IPERS 44,053 47,078 48,005 54,130 100 61320 SOCIAL SECURITY 36,729 38,956 41,124 43,866 100 61410 HEALTH INSURANCE 112,959 111,207 111,300 102,556 100 61415 WORKMENS' COMPENSATION 2,129 2,036 2,104 1,735 100 61416 LIFE INSURANCE 386 404 1,016 405 100 61660 EMPLOYEE PHYSICALS 122 418 0 0 61 - WAGES AND BENEFITS 696,309 737,089 741,118 776,101 100 62010 OFFICE SUPPLIES 1,461 1,325 1,783 1,325 100 62030 POSTAGE AND SHIPPING 0 414 0 414 290 62030 POSTAGE AND SHIPPING 7 15 0 15 100 62050 OFFICE EQUIPMENT MAINT 438 450 0 450 100 62090 PRINTING & BINDING 3 0 4 0 100 62110 COPYING/REPRODUCTION 85 113 85 113 100 62130 LEGAL NOTICES & ADS 766 766 781 766 100 62190 DUES & MEMBERSHIPS 1,037 1,261 1,211 1,261 100 62206 PROPERTY INSURANCE 9,186 7,764 8,004 8,958 100 62208 GENERAL LIABILITY INSURAN 4,294 4,435 4,655 3,907 100 62310 TRAVEL-CONFERENCES 1,616 1,720 2,449 2,400 100 62340 MILEAGE/LOCAL TRANSP 475 235 484 235 100 62360 EDUCATION & TRAINING 2,088 3,996 4,060 4,060 100 62421 TELEPHONE 3,968 6,104 6,672 6,104 100 62424 RADIO/PAGER FEE 573 588 590 588 100 62431 PROPERTY MAINTENANCE 2,500 0 2,550 0 100 62436 RENTAL OF SPACE 3,240 3,240 3,240 3,240 100 62611 MACH/EQUIP MAINTENANCE 25,916 35,430 61,656 48,700 100 62663 SOFTWARE LICENSE EXP 373,174 459,602 461,191 463,449 100 62667 INTERNET SERVICES 19,675 11,949 1,320 1,680 100 62716 CONSULTANT SERVICES 2,626 1,886 2,100 1,886 62 - SUPPLIES AND SERVICES 453,128 541,293 562,835 549,551 100 71120 PERIPHERALS, COMPUTER 2,640 0 0 0 100 71123 SOFTWARE 30 0 9,500 0 100 71125 SERVERS 0 14,563 0 0 100 71211 DESKS/CHAIRS 0 0 0 17,300 100 72414 TELEVISION 0 1,511 0 0 100 72418 TELEPHONE RELATED 615 2,432 0 11,950 71 - EQUIPMENT 3,285 18,506 9,500 29,250 77 - INFORMATION SERVICES TOTAL 1,152,722 1,296,888 1,313,453 1,354,902 -17- Recommended Expenditure Budget Report by Activity & Funding Source 77 - INFORMATION SERVICES INFORMATION SERVICES - 77100 FUNDING SOURCE: CABLE TV Account FY17 Actual Expense FY18 Adopted Budget FY19 Recomm'd Budget EQUIPMENT 18,507 9,500 29,250 SUPPLIES AND SERVICES 541,293 562,835 549,551 WAGES AND BENEFITS 737,087 741,118 776,101 INFORMATION SERVICES TOTAL $1,296,887 $1,313,453 $1,354,902 -18- C I T Y O F D U B U Q U E , I O W A DEPARTMENT DETAIL - PERSONNEL COMPLEMENT 77 INFORMATION SERVICES DIVISION FY 2017 FY 2018 FY 2019 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 $113,720 1.00 $115,549 1.00 $117,281 100 8650 GE-35 SENIOR NETWORK/SYSTEMS ADMIN 1.00 $80,821 1.00 $62,216 1.00 $82,530 100 8600 GE-32 LEAD APPLICATIONS/NETWORK 3.00 $204,586 3.00 $207,879 3.00 $211,837 100 8500 GE-30 INFORMATION TECH SPECIALIST 1.00 $60,030 1.00 $61,606 1.00 $63,106 100 GE-27 HELP DESK TECHNICAL SUPPORT 1.00 $—1.00 $—1.00 $7,035 100 490 GE-29 USER TECHNOLOGY SPECIALIST 1.00 $59,130 1.00 $60,660 1.00 $61,567 TOTAL FULL TIME EMPLOYEES 8.00 $518,287 8.00 $507,910 8.00 $543,356 61030 Seasonal Employee Expense 100 650 NA-38 1.00 $26,246 1.00 $26,146 1.00 $26,540 TOTAL SEASONAL EMPLOYEES 1.00 $26,246 1.00 $26,146 1.00 $26,540 TOTAL INFORMATION SERVICES 9.00 $544,533 9.00 $534,056 9.00 $569,896 -19- CITY OF DUBUQUE, IOWA ACTIVITY PERSONNEL COMPLEMENT SUMMARY FY 2017 FY 2018 FY 2019 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 $113,720 1.00 $115,549 1.00 $117,281 10077100 61010 100 8650 GE-35 SENIOR NETWORK/SYSTEMS ADMIN 1.00 $80,821 1.00 $62,216 1.00 $82,530 10077100 61010 100 8600 GE-32 LEAD APP/NETWORK ANALYST 3.00 $204,586 3.00 $207,879 3.00 $211,837 10077100 61010 100 8500 GE-30 INFO TECHNOLOGY SPECIALIST 1.00 $60,030 1.00 $61,606 1.00 $63,106 10077100 61010 100 GE-27 HELP DESK TECHINICAL SUPPORT 1.00 $—1.00 $—1.00 $7,035 10077100 61010 100 490 GE-29 USER TECHNOLOGY SPECIALIST 1.00 $59,130 1.00 $60,660 1.00 $61,567 Total 8.00 $518,287 8.00 $507,910 8.00 $543,356 Information Services - General Fund 10077100 61030 100 650 NA-38 INTERN-SEASONAL 1.00 $26,246 1.00 $26,146 1.00 $26,540 Total 1.00 $26,246 1.00 $26,146 1.00 $26,540 TOTAL INFORMATION SERVICES DIVISION 9.00 $544,533 9.00 $534,056 9.00 $569,896 -20- Capital Improvement Projects by Department/Division INFORMATION SERVICES CIP Number Capital Improvement Project Title FY 16 Actual Expense FY 17 Actual Expense FY 18 Adopted Budget FY 19 Recomm'd Budget 1011069 INTERNET,MICROS & PRINTER —37,709 215,800 147,201 1021069 INTERNET,MICROS & PRINTER —393,441 430,948 306,510 1022435 CITY WIDE MULTIFUNC RPL 47,502 ——— 1022488 10G BACKBONE UPGRADE 71,270 ——— 1022683 WORKSTATION/CHAIR REPLACE ——10,000 — 1022684 LASERFICHE FULL USER LICE ——9,240 11,000 1022726 ANNEX 2ND FLR LOW VOLTAGE ——27,800 — 1022727 VMWARE PLUS LICENSING ——40,000 — 2501069 INTERNET,MICROS & PRINTER 9,748 (2,106)—— 2901069 INTERNET,MICROS & PRINTER 7,070 7,473 5,800 — 3001069 INTERNET,MICROS & PRINTER 37,859 18,122 2,300 11,700 3501069 INTERNET,MICROS & PRINTER 243,770 16,005 —12,654 3502435 CITY WIDE MULTIFUNC RPL 15,233 ——— 3502488 10G BACKBONE UPGRADE 703 ——— 3502626 TEST ENVIRONMENT —25,128 —— 3502627 DATA MINING/OPEN DATA 33,000 ——— 3502683 WORKSTATION/CHAIR REPLACE —20,992 —— 6701069 INTERNET,MICROS & PRINTER ——942 287 7101069 INTERNET,MICROS & PRINTER 9,478 4,576 24,534 30,725 7201069 INTERNET,MICROS & PRINTER 4,876 ——4,788 7301069 INTERNET,MICROS & PRINTER 7,030 2,106 14,800 2,300 7401069 INTERNET,MICROS & PRINTER 2,072 1,974 21,000 2,700 8101069 INTERNET,MICROS & PRINTER 4,434 4,213 2,300 11,900 9401069 INTERNET,MICROS & PRINTER 36,787 —2,250 44,500 INFORMATION SERVICES TOTAL 530,832 529,634 807,714 586,265 -21- PRGRM/ DEPT PROJECT DESCRIPTION FY 2019 FY 2020 FY 2021 FY 2022 FY 2023 TOTAL PAGE INFORMATION SERVICES Business Type City-Wide Computer and Printer Replacements $97,200 $80,950 $89,450 $95,250 $65,750 $428,600 316 General Government City-Wide Computer and Printer Replacements $478,065 $726,336 $594,681 $717,195 $365,445 $2,881,722 317 Laserfiche Full User Licenses $11,000 $—$—$—$—$11,000 318 Network Security Risk Assessment $—$15,000 $—$22,000 $15,000 $52,000 319 Layer 2 Redundant Network Switch $—$—$74,000 $—$75,229 $149,229 320 End Point Security $—$—$20,640 $—$—$20,640 321 Total - Information Services $586,265 $822,286 $778,771 $834,445 $521,424 $3,543,191 -22- This page intentionally left blank. Information Services Fiscal Year 2019 Budget Presentation February 7, 2018 Clarity is About … Being Accountable Building Trust Engaging Residents Destroying Apathy Ending Fear Nick Kittle, Cartegraph Information Services Manager Chris Kohlmann Lead Applications/ Network Analyst Tony Steffen Information Technology Specialist Alicia Turnis Lead Applications/ Network Analyst Joe Pregler User Technology Specialist Jim Vosberg Lead Applications/ Network Analyst DLEC Stacey Moore Intern IS DLEC Jay Gonzales, Jr. Senior Network Administrator Jason Burds Intern -IS Open Help Desk Technical Support Frozen Help Desk Technical Support Recommended “Unfrozen” May 2019 •Break/Fix ,“How To” and Training •WebQA / CivicPlus / Office365 /Sharefile •New Project Support •Accela Public Interface •Municipal Infractions/Code Enforcement •Workflows •Laserfiche Forms •Accela Licenses, Permits, Inspections •Current Application Support •Reporting and Data Extraction –Accela, Cognos, Cartegraph, WebQA •Socrata –Open Performance and Open Data •Bee Branch Healthy Homes Past Year Highlights •Network •Communications License Update •Master Services Agreements •WIN, CS Technologies and ImOn •Increased Capacity of available conduit and fiber by over 50% •Valuation •Year 1 $59,859 •Years 1 -10 $389,259 Past Year Highlights •Network •Agreements and partnerships •Mediacom, Centurylink, Verizon, ATT, UPN, Mobilitie •Connectivity to Airport •Acquisition of Conduit Abandoned in Place •Project Partnerships –Kerper Blvd •Small Cell Past Year Highlights •Infrastructure •Storage Area Network •Server Host Replacements •Computer, Tablet and Phone Replacements •Security Past Year Highlights •Software •Socrata Transparency Applications •Office365 •Accela Permitting •DBQIQ •Neptune Remote Water Reading •Public Safety •Legacy Financial and Billing Systems Financially Responsible, High Performance City Organization Technology Resources are Cost Effective, Supported and Safe •Cost Effective what used to be 9 physical servers is now accomplished by 1 server “hosting” 9 virtual servers •Supported large capacity Storage Area Networks providing failover and redundancy achieving a 99.99% uptime •Safe Implementation of a robust network security policy and monitoring resulting in 0% successful compromise or intrusion Technology Solutions and Services Maximizing the Investment in Technology Assets •Networks Supporting 2.8 Terabytes of Traffic Weekly •31.5%of data traffic is web traffic –Internet is no-cost as part of a multi-year public/private partnership valuation agreement with WIN •Leveraging Scalable and Cost Effective Storage Solutions •Provision for annual projected growth 15% -20%/year •Storage Cost .05 per Gigabyte across all SANs Recommended FY 2019 Capital Improvement Projects •City-Wide Computer and Printer Replacements •Laserfiche Full Licensing Recommended Improvement Packages •Multi-Year Replacement of Shoretel IP Phones •$11,950 per year recurring for 4 years •UPS Replacements •$17,300 Thank You!