Loading...
HomeMy WebLinkAboutTab 8: Information TechnologyVILLAGE OF MOUNT PROSPECT 2014 - 2018 CAPITAL IMPROVEMENTS PLAN SUMMARY OF PROJECT REQUESTS Department: IT (N) = New Project (E) = Established Project ( *) = Federal Mandate Project Type Codes: 700 = Water System 701 = Sanitary Sewer 702 = Flood Control Projects 703 = Storm Sewer 704 = Street Construction and Reconstruction 705 = Resurfacing/Curbs and Gutters /Sidewalks 706 = Construction of and Improvements to Public Buildings 707 = Computer Hardware /Software 708 = Vehicles and Automotive Equipment 709 = Non - Automotive Equipment 710 = Miscellaneous G -1 Page Project Name No. Dept. 2014 2015 2016 2017 2018 Total Network Switches (E) G -2 IT 13,500 0 0 0 0 13,500 Hansen Interface (N) G -3 PW 30,000 0 0 0 0 30,000 DVD Duplication System (N) G -4 Pol 1,600 0 0 0 0 1,600 Network Attached Storage (N) G -5 Pol 7,000 0 0 0 0 7,000 Computer Workstations (N) G -6 Pol 7,000 5,600 5,600 0 0 18,200 Laptop for PIO (N) G -7 VMO 1,450 0 0 0 0 1,450 Tablets for Trustees (N) G -8 VMO 3,850 0 0 0 0 3,850 IT Strat Plan & Security Assessmnt (N) G -9 IT 25,000 25,000 0 0 0 50,000 Network Management Tools (N) G -10 IT 2,500 0 0 0 0 2,500 Microsoft Licensing (N) G -1 I IT 34,500 17,200 14,100 0 0 65,800 Wireless Access Points (N) G -12 IT 0 6,000 0 0 0 6,000 Desktop Virtualization (N) G -13 IT 0 95,000 0 0 0 95,000 Security Cameras (N) G -14 IT 0 23,820 0 0 0 23,820 PW Laptops (E) G -15 PW 0 5,860 2,930 2,930 0 11,720 VH Door Access (N) G -16 IT 0 40,000 0 0 0 40,000 Web Server to Cloud (N) G -17 IT 0 31,300 9,300 9,300 9,300 59,200 Instant Messaging (N) G -18 IT 0 8,100 7,800 7,800 7,800 31,500 SharePoint Server (N) G -19 IT 0 0 35,939 29,520 29,520 94,979 Microsoft Office Suite Upgrades (N) G -20 IT 0 0 85,000 0 0 85,000 GIS Interface (N) G -21 IT 0 0 30,000 0 0 30,000 Telephone Call Accounting (N) G -22 IT 0 0 12,000 0 0 12,000 Total 126,400 257,880 202,669 49,550 46,620 683,119 (N) = New Project (E) = Established Project ( *) = Federal Mandate Project Type Codes: 700 = Water System 701 = Sanitary Sewer 702 = Flood Control Projects 703 = Storm Sewer 704 = Street Construction and Reconstruction 705 = Resurfacing/Curbs and Gutters /Sidewalks 706 = Construction of and Improvements to Public Buildings 707 = Computer Hardware /Software 708 = Vehicles and Automotive Equipment 709 = Non - Automotive Equipment 710 = Miscellaneous G -1 VILLAGE OF MOUNT PROSPECT 2014 -2018 Project Name: Network Switches (E) Project Type Code: 707 2014 Dept. Priority: I Department: Village Manager's Office - IT Division Description: Replace network switches that have reached the end of support cycle. Hardware /Software Costs: 2014 2015 2016 2017 2018 Totals Replace 2 Switches 13,500 0 0 0 0 13,500 Sources of Funds General Fund - IT Impact to Annual Operating Budget. Existing Payment Dept - IT IT Proposed Payment Dept - IT IT Change Dept - IT IT 13,500 0 0 0 0 13,500 2014 2015 2016 2017 2018 Totals 13,500 0 0 0 0 13,500 13,500 0 0 0 0 13,500 2014 2015 2016 2017 2018 Totals 0 0 1,248 0 1,248 0 0 0 0 1,248 1,248 0 0 1,248 1,248 0 0 0 0 0 0 1,248 1,248 6,240 0 0 0 1,248 1,248 6,240 0 rage t of 1 G -2 VILLAGE OF MOUNT PROSPECT Justification/Comments: Switches have not been replaced in a timely manner because we didn't know how many would be replaced with the phone system project. 2014 - replacing 2 switches with 10/13/2014 end of support date. Is this part of the dept.'s Yes, it is included in the Technology Plan 5 yr technology plan as provided to the Tillage Technology Advisory Group? If so, how? Implementation schedule: First quarter annually. Personnel utilizing: IT Staff Page 2 of 2 File Name: 2014 -3 Network Switches -rls '(E) = Established Project G -3 VILLAGE OF MOUNT PROSPECT MardwarelSoftware Costs: Interface Development Sources of Funds. Water Fund General Fund Refuse Fund Impact to Annual Lease Payment: Existing Payment Dept (name) IT Proposed Payment Dept (name) IT Change Dept (name) IT 2014 2015 2016 2017 2018 Totals 30,000 0 0 0 0 30,000 30,000 0 0 0 0 30,000 2014 2015 2016 2017 2018 Totals 10,000 0 0 0 0 10,000 15,000 0 0 0 0 15,000 5,000 0 0 0 0 5,000 30,000 0 0 0 0 30,000 2014 2015 2016 2017 2018 Totals 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Page i of 1 G -4 VILLAGE OF MOUNT PROSPECT Is this part of the dept.'s Yes 5 yr technology plan as provided to Technical Focus Group? If so, how? Public Works 2013 Computer Vision Implementation 1st and 2nd quarter of 2014 schedule: Personnel utilizing: Entire Department Page l of 1. File Name: Hansen Laserfiche Interface CIP 2014 (N) = New G -5 VILLAGE OF MOUNT PROSPECT Sources of Funds. Police Impact to Annual Lease Payment: Existing Payment Dept (name) IT Proposed Payment Dept (name) IT Change Dept (name) IT 1,600 0 0 0 0 1,600 2014 2015 2016 2017 2018 Totals 1,600 0 0 0 0 1,600 1,600 0 0 0 0 1,600 2014 2015 2016 2017 2018 Totals 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 314 314 314 314 314 1,570 0 0 0 0 0 0 314 314 314 314 314 1,570 rage 1 of L L� 707 3 Justification /Comments: Mobile traffic stop video and video obtained from complainants /victims serve an evidentiary purpose in court proceedings. Duplication of these videos are required to meet subpoena and discovery demands. The department is currently using a DVD duplication system forfeited to the department as part of an asset seizure from 2009 and will be in need of replacement. (2014) Is this part of the dept.'s 5 yr technology plan as Yes, the department will seek replacement and enhancement of its current duplication provided to the Village systems. Technology Advisory Group? If so, how? Implementation schedule: 2014 Personnel utilizing: Administration, Technical Services, Investigations, Patrol Supervisors, Patrol Officers. Page 2 of 2 File Name: 2014 DVD Duplication System.zlsx (N) = New Project G -7 VILLAGE OF MOUNT PROSPECT Hardware /Software Costs: 2014 2015 2016 2017 2018 Totals NAS Back -Up Systems 7,000 0 0 0 0 7,000 Sources of Funds: Police Impact to Annual Lease Payment: Existing Payment Dept (name) IT Proposed Payment Dept (name) IT Change Dept (name) IT 7,000 0 0 0 0 7,000 2014 2015 2016 2017 2018 Totals 7,000 0 0 0 0 7,000 7,000 0 0 0 0 7,000 2014 2015 2016 2017 2018 Totals 0 0 0 0 0 0 1 ,372 1,372 0 0 1,372 1,372 0 0 0 0 0 0 0 0 0 0 0 0 1,372 1,372 1,372 6,860 0 0 0 0 1,372 1,372 1,372 6,860 rage 1 of L G -8 Justification /Comments: The Police Department maintains several mission critical information servers pursuant to the core operations of the department. Due to the important nature of these systems, the data needs to be backed -up to a reliable data back -up system. While the current hard disk backup systems are functioning properly, the units require replacement at regular intervals to ensure reliability of the data back -up protection process. Is this part of the dept.'s S yr technology plan as provided to the Village Technology Advisory Group? If so, how? Implementation schedule: Personnel utilizing: The two units will be utilized by the police department and will replace units currently in service at the police department and the police department's remote back -up location at Northwest Central Dispatch. Part of the Attached Storage systems. 2014 Technical Services Unit Page 2 of 2 Fife Name: 2014 Network Attached Storage Back -Up systems.xlsx (N) = New Project G -9 n iI Hardware/Software Costs: 2014 2015 2016 2017 2018 Totals Computer Workstations 5,250 4,200 4,200 0 0 13,650 Microsoft Office 1,750 1,400 1,400 0 0 4,550 7,000 5,600 5,600 0 0 18,200 Sources of Funds: 2014 2015 2016 2017 2018 Totals Police 7,000 5,600 5,600 0 0 18,200 7,000 5,600 5,600 0 0 18,200 Impact to Annual Lease Payment: Existing Payment Dept (name) IT Proposed Payment Dept (name) IT Change Dept (name) IT 2014 2015 2016 2017 2018 Totals 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1,295 2,331 3,367 3,367 3,367 13,727 0 0 0 0 0 0 1,295 2,331 3,367 3,367 3,367 13,727 Yage 1 of 2 G -10 VILLAGE OF MOUNT PROSPECT JustiJication/Com men ts: The department needs to provide computer workstations capable to meet the need for police department personnel to query informational databases to obtain information for current and ongoing investigations, crime scene technician work related to digital photography, training, computerized accident reconstruction software, and report writing. Due to this increased operational need to perform routine tasks, the police department is requesting these computer workstations to be added to the replacement schedule. Locations for replacement: 2014: Patrol Report Writing (4), Range Report Writing (1) 2015: Booking (2), Investigations (2) 2016: Front Desk (3), Range (1) Is this part of the dept.'s S yr technology plan as Yes, the department will continue to enhance its computer workstation inventory to provided to the Village meet operational needs. The department will continue to repurpose workstations Technology Advisory wherever possible and extend the life of those computers through memory upgrades Group? If so, how? whenever possible. Implementation schedule: 2014, 2015, 2016 Personnel utilizing: Administration, Investigations, Patrol Supervisors, Patrol, Records, Technical Services. Page 2 of 2. File Name: 2014 additional computersystems.xlsx (N) = New Project G -11 2014-2018 Project Name: Laptop for PIO (N) Project Type Code: 2014 Dept. Priority: Department: Manager's Office Description: Provide a laptop for the Public Information Officer. Hardware /Software Costs: 2014 2015 Laptop 1,450 0 707 I 6 2016 2017 2018 Totals 0 0 0 1,450 1,450 0 0 0 0 1,450 Sources of Funds: 2014 2015 2016 2017 2018 Totals Village Manager's Office 1,450 0 0 0 0 1,450 rage 1 or t, G -12 1,450 0 0 0 0 1,450 Impact to Annual 2014 2015 2016 2017 2018 Totals Lease Payment: Existing Payment Dept (name) 0 0 0 0 0 0 IT 0 0 0 0 0 0 Proposed Payment Dept (name) 0 0 0 0 0 0 IT 0 357 357 357 357 1,428 Change Dept (name) 0 0 0 0 0 0 IT 0 357 357 357 357 1,428 rage 1 or t, G -12 707 6 Justification/Comments: The laptop would be used for the Public Information Officer to use in the EOC and to remote into the Village network. Is this part of the dept.'s Yes, this is listed as a 2014 item. S yr technology plan as provided to the Village Technology Advisory Group? If so, how? Implementation Q1 schedule: Personnel utilizing: PIO Page 2 of 2 File Name: 2014 PIO Gaptop.xlsr (N) = New G -13 Project Name: Department: Description: Hardware /Software Costs: 7 Tablets w/ apps Sources of Funds: Village Manager's Office Impact to Annual Operating Budget: Existing Payment Dept - [HMO IT Proposed Payment Dept - VMO IT Change Dept - [HMO IT Provide iPads or other tablets for Trustees to eliminate paper copies of agenda packets 2014 2015 3,850 0 2016 2017 0 0 2018 Totals 0 3,850 3,850 0 0 0 0 3,850 2014 2015 2016 2017 2018 Totals 3,850 0 0 0 0 3,850 3,850 0 0 0 0 3,850 2014 2015 2016 2017 2018 Totals 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1,156 1,156 1,156 1,156 4,624 0 0 0 0 0 0 0 1,156 1,156 1,156 1,156 4,624 rage i of z G -14 707 Justification /Comments: The use of tablets would reduce the time needed to prepare agenda packets. It would also provide a "greener" method of distributing the packets while reducing paper and copying costs. Is this part of the dept.'s Yes, it is included in the Technology Plan 5 yr technology plan as provided to the Village Technology Advisory Group? If so, how? Implementation First or Second Quarter schedule: Personnel utilizing: Trustees Page 2 of 2 File Name: 2014 Tablets for Trusteesxls (N) = New Project G -15 VILLAGE OF MOUNT PROSPECT Description: Have an outside company perform a vulnerability assessment on the Village network Hardware /Software Costs: 2014 2015 Services 25,000 25,000 2016 2017 0 0 2018 Totals 0 50,000 25,000 25,000 0 0 0 50,000 Sources of Funds: 2014 2015 2016 2017 2018 Totals General Fund - IT 25,000 25,000 0 0 0 50,000 rage t of L G -16 25,000 25,000 0 0 0 50,000 Impact to Annual 2014 2015 2016 2017 2018 Totals Lease Payment: Existing Payment Dept (name) 0 0 0 0 0 0 IT 0 0 0 0 0 0 Proposed Payment Dept (name) 0 0 0 0 0 0 IT 0 0 0 0 0 0 Change Dept (name) 0 0 0 0 0 0 IT 0 0 0 0 0 0 rage t of L G -16 VILLAGE OF MOUNT PROSPECT 2014 -2018 Project Name: IT Strategic Plan and Security Assessment Project Type Code: (N) 2014 Dept Priority: Department: Village Manager's Office - IT Division Justification/Comments: The Village Board showed interest in having a network security assessment done in the past, but the project was canceled for budgetary reasons. This is still an important project and should be reinstated. Assessment includes 1) external vulnerability, 2) internal vulnerability, 3) firewall, 4) passwords, 5) wireless, 6) security policies, 7) backup procedures, 8) anti - virus /malware /intrusion protection As a follow -up to the security assessment, it would be beneficial to have a professionally created strategic plan to verify the Village is on track for the future. Is this part of the dept.'s Yes, it is included in the Technology Plan S yr technology plan as provided to the Tillage Technology Advisory Group? If so, how? Implementation schedule: 2014 Q2 Personnel utilizing: IT Staff 707 8 Page 2 of 2 File Name: 2014 Security Assessment (N) = New Project G -17 VILLAGE OF MOUNT PROSPECT 2,500 0 0 0 0 2,500 Sources of Funds: 2014 2015 2016 2017 2018 Totals General Fund - IT 2,500 0 0 0 0 2,500 rage 1 of l G -18 2,500 0 0 0 0 2,500 Impact to Annual 2014 2015 2016 2017 2018 Totals Lease Payment: Existing Payment Dept (name) 0 0 0 0 0 0 IT 0 0 0 0 0 0 Proposed Payment Dept (name) 0 0 0 0 0 0 IT 0 0 0 0 0 0 Change Dept (name) 0 0 0 0 0 0 IT 0 0 0 0 0 0 rage 1 of l G -18 707 9 Justification/Comments: Staff is currently using a Network Assistant, a free tool from Cisco, to manage the network infrastructure. Network Assistant only manages up to 40 Cisco devices. It does not provide the ability to send alerts, to export network maps, or to effectively manage all Village switches and routers. Solar Winds has nice tools to fulfill this void. Is this part of the dept.'s Yes, it is included in the Technology Plan 5 yr technology plan as provided to the Village Technology Advisory Group? If so, how? Implementation Q2 schedule: Personnel utilizing: IT Staff Page 2 of "2 File Name: 2015 Network Management Tools.xlsx (N) = New Project G -19 707 10 Justification/Com m ents: 2014 - Upgrade GIS, Hansen, Firehouse to Server 2008, SQL 2008 Already own Server 2008 licenses Purchase 3 SQL Server licenses, 200 SQL client license 2015 - Upgrade Exchange - Windows Server, Exchange Server, 300 users, training 2016 - Upgrade Logos.Net to Windows Server 2012 6 Windows Server 2012 licenses 300 user licenses 5 SQL Server 2012 licenses Is this part of the dept.'s Yes, it is included in the Technology Plan S yr technology plan as provided to the Pillage Technology Advisory Group? If so, how? Implementation schedule: See Justification/Comments Personnel utilizing: Village -wide rage z of L File Name: 2014 -2016 Microsoft Server Licenses. rlsx (N) = New Project G -20 Project Name: Department: Description: Hardware /Software Costs: MS SQL Server 2012 MS SQL 2012 CALs MS Windows Server 2012 MS Windows 2012 CALs MS Exchange Server 2013 MS Exchange 2013 CALs Training 707 10 2014 2015 2016 2017 2018 Totals 1,800 2,400 3,000 0 0 7,200 13,600 13,600 0 0 0 27,200 0 1,200 3,600 0 0 4,800 0 0 7,500 0 0 7,500 500 0 0 0 0 500 15,600 0 0 0 0 15,600 3,000 0 0 0 0 3,000 34,500 17,200 14,100 0 0 65,800 Sources of Funds: 2014 2015 2016 2017 2018 Totals Information Technology 34,500 17,200 14,100 0 0 65,800 Impact to Annual Lease Payment: Existing Payment Dept (name) IT Proposed Payment Dept (name) IT Change Dept (name) IT 34,500 17,200 14,100 0 0 65,800 I 2014 2015 2016 2017 2018 Totals ' 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 i 0 0 0 0 0 0 0 0 0 0 0 0 ?age I of 6 G -21 Project Name: Department: Description: Hardware /Software Costs: (5) Wireless Access Points Sources of Funds: General Fund - IT Impact to Annual Operating Budget: Existing Payment Dept - IT IT Proposed Payment Dept - IT IT Change Dept - IT IT Expand the number of wireless access points for Police video uploads and general network access. 2014 2015 2016 0 6,000 0 2017 2018 0 0 Totals 6,000 0 6,000 0 0 0 6,000 2014 2015 2016 2017 2018 Totals 0 6,000 0 0 0 6,000 0 6,000 0 0 0 6,000 2014 2015 2016 2017 2018 Totals 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 rage t or L G -22 2014 -2018 Project Name: Additional Wireless Access Points (N) Project Type Code: 707 2014 Dept. Priority: N/A Department: Village Manager's Office - IT Division Justification /Comments: Improve upload time for videos and other date from police squad cars to network. Expand number of locations where staff can connect to internal network. Is this part of the dept.'s Yes, it is included in the multi -year plan. S yr technology plan as provided to the Village Technology Advisory Group? If so, how? Implementation As needed schedule: Personnel utilizing: IT Staff Page 2 of L File Name: 2014 Additional Wireless Access Points.xls '(N) = Established Project G -23 Page 1 of 2 G -24 VILLAGE OF MOUNT PROSPECT 2- . NORM 2014 -2018 Project Name: Desktop Virtualization Hardware /Software (N Project Type Code: 707 2014 Dept. Priority: N/A Department: Village Manager's Office - IT Division Description: Desktop Virtualization will provide users with improved remote access to network applications from a variety of different device types, as well as replace workstations with less expensive terminals. Hardware /Software Costs: 2014 2015 2016 2017 2018 Totals Hardware 0 35,000 0 0 0 35,000 Licenses 0 45,000 0 0 0 45,000 Implementation Services 0 15,000 0 0 0 15,000 0 95,000 0 0 0 95,000 Sources of Funds: 2014 2015 2016 2017 2018 Totals Capital Improvement Fund 0 95,000 0 0 0 95,000 0 95,000 0 0 0 95,000 Impact to Annual 2014 2015 2016 2017 2018 Totals Operating Budget: Existing Payment Dept - IT 0 0 0 0 0 0 IT 0 0 0 0 0 0 Proposed Payment Dept - IT 0 0 0 0 0 0 IT 0 0 16,000 16,000 16,000 48,000 Change Dept - IT 0 0 0 0 0 0 IT 0 0 16,000 16,000 16,000 48,000 Page 1 of 2 G -24 VILLAGE OF MOUNT PROSPECT 2014 -2018 Project Name: Desktop Virtualization Hardware /Software Project Type Code: 707 (N) 2014 Dept. Priority: N/A Department: Village Manager's Office - IT Division Justification /Comments: Field employees need remote network access via WiFi/WiMax from a variety of devices. Desktop virtualization, in conjunction with a VPN connection, creates a secure and functional environment that can be accessed from many different hardware devices. Cost is based on 100 users, 50 concurrent. A pilot project which began in 2012 has been successful. There is a desire to expand virtual desktops to other areas, initially for remote access. A second pilot project will be undertaken to potentially replace shared desktops for operations with less expensive terminals. Is this part of the dept.'s Yes, it is included in the Technology Plan 5 yr technology plan as provided to the Village Technology Advisory Group? If so, how? Implementation 2015 schedule: Personnel utilizing: Village -wide use Page 2 of 2 File Name. 2014 Desktop Virtualization -ds (N) = New Project G -25 VILLAGE OF MOUNT PROSPECT Hardware /Software Costs: 2014 2015 2016 2017 2018 Totals Cameras - Parking Garage (7) 0 9,650 0 0 0 9,650 Labor - Parking Garage 0 2,100 0 0 0 2,100 Cameras - Finance (3) 0 2,910 0 0 0 2,910 Labor - Finance 0 1,000 0 0 0 1,000 Cameras - CD (4) 0 3,880 0 0 0 3,880 Wiring (includes labor) 0 500 0 0 0 500 Labor - CD 0 1,400 0 0 0 1,400 Software Upgrade 0 2,380 0 0 0 2,380 0 23,820 0 0 0 23,820 Sources of Funds: 2014 2015 2016 2017 2018 Totals Capital Improvement Fund 0 23,820 0 0 0 23,820 0 23,820 0 0 0 23,820 Impact to Annual 2014 2015 2016 2017 2018 Totals Lease Payment: Existing Payment Dept (name) 0 0 0 0 0 0 IT 0 0 0 0 0 0 Proposed Payment Dept (name) 0 0 0 0 0 0 IT - Software Subscription 0 0 912 912 912 2,736 Change Dept (name) 0 0 0 0 0 0 IT 0 0 912 912 912 2,736 rage i of G -26 VILLAGE OF MOUNT PROSPECT Justification /Comments: Currently, there are security cameras in and outside Village Hall. Some new cameras will be installed in the Finance and Community Development customer service areas to provide security at the point of sale (i.e. cash registers). The rest of the cameras will be installed in the parking garage stairwells to address security concerns and vandalism issues. Is this part of the dept.'s S yr technology plan as provided to the Village Technology Advisory Group? If so, how? Implementation schedule: Personnel utilizing: Yes. Additional security at point of sale registers in Finance and Community Development, as well as in the parking garage. 2015 N/A Page 2 of Z File Name. 2014 Security Cameras (E) = Existing Project G -27 Hardware /Software Costs: 2014 2015 2016 2017 2018 Totals Laptop Computers 0 5,860 2,930 2,930 0 11,720 Sources of Funds: Water & Sewer Fund General Fund - PW Impact to Annual Operating Budget: Existing Payment Dept -Public Works IT Proposed Payment Dept -Public Works IT Change Dept -Public Works IT 0 5,860 2,930 2,930 0 11,720 2014 2015 2016 2017 2018 Totals 0 2,930 2,930 0 0 5,860 0 2,930 0 2,930 0 5,860 0 5,860 2,930 2,930 0 11,720 2014 2015 2016 2017 2018 Totals 1 1 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1,880 2,561 3,501 0 7,942 0 0 0 0 0 1,880 2,561 3,501 0 7,942 rage 1 of 2 G -28 VILLAGE OF MOUNT PROSPECT Justiftcation/Com men ts: Access to mobile computing will allow key field- oriented personnel to improve decision making by reducing record retrieval rates and reducing the incidence of double -data entry. 2015 two new semi - rugged laptops for Meter Services and Forestry Technicians 2016 one new semi - rugged laptop for Service Call Technician 2017 One new semi- rugged laptop to be mounted in vehicle for Street Program Engineer Is this part of the dept.'s Yes S yr technology plan as provided to Technical Focus Group? If so, how? Via the Public Works' Department 2013 Computer Vision Implementation schedule: Annually through 2017. Typically in May /June. Personnel utilizing: Public Works foremen, pump man, service call rep and engineers. Page "l of 2 File Name: PWLAPTOPS 20/4- 2018.xls (E) = Established Project G -29 VILLAGE OF MOUNT PROSPECT 2014 -2018 Project Name: VH Door Access Project Type Code: 707 2014 Dept. Priority: N/A Department: Information Technology Description: Investigate the feasibility of centralizing building access control. Project only may include updating Village Hall door access controllers, or may systems from different buildings. Hardware /Software Costs: 2014 2015 2016 2017 2018 Totals Hardware 0 40,000 0 0 0 40,000 0 40,000 0 0 0 40,000 Sources of Funds: 2014 2015 2016 2017 2018 Totals Capital Improvement Fund 0 40,000 0 0 0 40,000 rage 1 of 1 G -30 0 40,000 0 0 0 40,000 Impact to Annual 2014 2015 2016 2017 2018 Totals Lease Payment: Existing Payment Dept (name) 0 0 0 0 0 0 IT 0 0 0 0 0 0 Proposed Payment Dept (name) 0 0 0 0 0 0 IT 0 0 0 0 0 0 Change Dept (name) 0 0 0 0 0 0 IT 0 0 0 0 0 0 rage 1 of 1 G -30 VILLAGE OF MOUNT PROSPECT Is this part of the dept.'s Yes, this is included in the 5 -year technology plan. 5 yr technology plan as provided to the Village Technology Advisory Group? If so, how? Implementation schedule: 2015 Personnel utilizing: Village -wide rage L or File Name: 2015 Building Access Control (M = G -31 707 I N/A Hardware /Software Costs: 2014 2015 2016 2017 Upgrade 0 22,000 0 0 Hosting & Maintenance 0 9,300 9,300 9,300 2018 0 9,300 Totals 22,000 37,200 0 31,300 9,300 9,300 9,300 59,200 Sources of Funds: 2014 2015 PIO 0 31,300 2016 9,300 2017 9,300 2018 9,300 Totals 59,200 rage i or z G -32 0 31,300 9,300 9,300 9,300 59,200 Impact to Annual 2014 2015 2016 2017 2018 Totals Lease Payment: Existing Payment Dept (name) 0 0 0 0 0 0 IT 0 0 0 0 0 0 Proposed Payment Dept (name) 0 0 0 0 0 0 IT 0 0 0 0 0 0 Change Dept (name) 0 0 0 0 0 0 IT 0 0 0 0 0 0 rage i or z G -32 Justiftcation/Comments: The Village has been hosting the web site in -house to save money. However, since at least one other municipality's network was hacked via their online web content management system (CMS), it may be desirable to rethink this strategy. Costs include an upgrade to the current CMS version. Is this part of the dept.'s Yes, this is included in the multi -year technology plan. S yr technology plan as provided to the Village Technology Advisory Group? If so, how? Implementation 2015 schedule: Personnel utilizing: Village -wide Yage L of L File Name: 2015 Move Web Server to Cloud (N) = New G -33 4v. � 2014-2 Project Name: Department: Instant Messaging Human Services, possibly Village -wide Project Type Code: 2014 Dept. Priority: 707 N/A Description: Provide instant messaging to Village staff. Information Technology 0 8,100 Hardware /Software Costs: 2014 2015 2016 2017 2018 Totals Annual Fee 0 7,800 7,800 7,800 7,800 31,200 Setup 0 300 0 0 0 300 0 8,100 7,800 7,800 7,800 31,500 I Sources of Funds: 2014 2015 2016 2017 2018 Totals Information Technology 0 8,100 7,800 7,800 7,800 31,500 0 8,100 7,800 7,800 7,800 31,500 I Impact to Annual 2014 2015 2016 2017 2018 Totals Lease Payment: Existing Payment Dept (name) 0 0 0 0 0 0 IT 0 0 0 0 0 0 Proposed Payment Dept (name) 0 0 0 0 0 0 IT 0 0 0 0 0 0 Change Dept (name) 0 0 0 0 0 0 IT 0 0 0 0 0 0 rage i of G -34 VILLAGE OF MOUNT PROSPECT Justiftcation/Comments: The Mount Prospect Library has provided licenses to some members of the Human Services staff to improve communication, particularly at the Community Connections Center. Human Services has found this functionality to be useful for quick messages, sometimes to inform other staff of a potential security situation. This function could initially be provided to Human Services staff, and eventually to other departments. Price is based on 339 users Is this part of the dept.'s Yes, it is included in the Technology Plan S yr technology plan as provided to the Village Technology Advisory Group? If so, how? Implementation 2015 schedule: Personnel utilizing: Human Services, possibly Village -wide rage z of L File Name: 2015 Instant Messaging.xlsx (N) =New G-35 Description: Sharepoint Server to facilitate collaboration on cross - department iniatives. Hardware /Software Costs: 2014 2015 2016 2017 2018 Totals Subscription 0 0 29,520 29,520 29,520 88,560 Setup 0 0 3,419 0 0 3,419 Training 0 0 3,000 0 0 3,000 0 0 35,939 29,520 29,520 94,979 Sources of Funds: 2014 2015 2016 IT - General Fund 0 0 35,939 2017 29,520 2018 29,520 Totals 94,979 rage i of [, G -36 0 0 35,939 29,520 29,520 94,979 Impact to Annual 2014 2015 2016 2017 2018 Totals Operating Budget: Existing Payment Dept - IT 0 0 0 0 0 0 IT 0 0 0 0 0 0 Proposed Payment Dept - IT 0 0 0 0 0 0 IT 0 0 0 0 0 0 Change Dept - IT 0 0 0 0 0 0 IT 0 0 0 0 0 0 rage i of [, G -36 Justification /Comments: Sharepoint provides a means for departments to collaborate easily. Features include the ability to publish Access databases, share calendars, view dashboards, implement document versioning, and setup blogs. It can be used to document business processes and to provide access to other information that is essential to organizational goals and processes. Other solutions will be considered such as cloud -based Sharepoint services or Google Apps. Is this part of the dept.'s Yes, it is included in the Technology Plan 5 yr technology plan as provided to the Village Technology Advisory Group? If so, how? Implementation schedule: 2016 Personnel utilizing: Village -wide rage z or File Name: 2014 SharePoint Server.xls (N) = New Project G -37 Project Name: Microsoft Office Suite Project Type Code: 2014 Dept. Priority: Department: Information Technology Description: Upgrade Microsoft Office to the current version. 707 I N/A Hardware /Software Costs: 2014 2015 2016 2017 2018 Totals Software 0 0 85,000 0 0 85,000 0 0 0 0 0 0 0 0 85,000 0 0 85,000 I Sources of Funds: 2014 2015 2016 2017 2018 Totals Capital Improvement Fund 0 0 85,000 0 0 85,000 0 0 85,000 0 0 85,000 I Impact to Annual 2014 2015 2016 2017 2018 Totals Lease Payment. Existing Payment Dept (name) 0 0 0 0 0 0 IT 0 0 0 0 0 0 Proposed Payment Dept (name) 0 0 0 0 0 0 IT 0 0 0 0 0 0 Change Dept (name) 0 0 0 0 0 0 IT 0 0 0 0 0 0 rrige 1 UI L G -38 VILLAGE OF MOUNT PROSPECT Justifcation /Com men ts: The Village purchased Microsoft Office 2010 in the year 2010. By 2016 it will be time to upgrade again or move this function to the cloud. Is this part of the dept.'s Yes, this is included in the multi -year technology plan. S yr technology plan as provided to Village Technology Advisory Group? If so, how? Implementation schedule: 2016 Personnel utilizing: Village -wide Page 2 of 2 File Name: 2016 Microsoft Office.xlsr (I) = New G -39 Description: Develop interface between Village wide intranet GIS application (GeoCortex) and LaserFiche document management application to improve access to records Hardware /Software Costs: 2014 2015 2016 2017 2018 Totals Interface Development 0 0 30,000 0 0 30,000 0 0 30,000 0 0 30,000 Impact to Annual 0 0 30,000 0 0 30,000 Sources of Funds: 2014 2015 2016 2017 2018 Totals Water Fund 0 0 10,000 0 0 10,000 General Fund 0 0 15,000 0 0 15,000 Refuse Fund 0 0 5,000 0 0 5,000 0 0 30,000 0 0 30,000 Impact to Annual 2014 2015 2016 2017 2018 Totals Lease Payment: Existing Payment Dept (name) 0 0 0 0 0 0 IT 0 0 0 0 0 0 Proposed Payment Dept (name) 0 0 0 0 0 0 IT 0 0 0 0 0 0 Change Dept (name) 0 0 0 0 0 0 IT 0 0 0 0 0 0 rage i or t G -40 VILLAGE OF MOUNT PROSPECT 2014 -2018 Project Name: Interface between GeoCortex intranet GIS Project Type Code: 707 application and LaserFiche (N) 2014 Dept. Priority: N/A Department: Public Works Justification/Comments. Develop an interface that will link LaserFiche images with parcels and/or spatial assets they pertain to. Establish link between GeoCortex Essentials web based GIS and LaserFiche. This interface will enable end users to search for documents stored in LaserFiche spatially from the Village's web based GIS mapping software. Application will improve documentation, improve retrieval time, improve employees' access to documents, and improve staff efficiencies. Is this part of the dept.'s Yes S yr technology plan as provided to Technical Focus Group? If so, how? Public Works 2013 Computer Vision Implementation 1st and 2nd quarter of 2016 schedule: Personnel utilizing: Entire Village Page 2 of 2 File Name:GeoCortex Laserfiche Interface CIP 2014 (N) = New G -41 I07 N/A Hardware /Software Costs: 2014 2015 2016 2017 2018 Totals Call Accounting System 0 0 12,000 0 0 12,000 0 0 0 0 0 0 0 0 12,000 0 0 12,000 Sources of Funds: 2014 2015 2016 2017 2018 Totals Capital Improvement Fund 0 0 12,000 0 0 12,000 rage t or G -42 0 0 12,000 0 0 12,000 Impact to Annual 2014 2015 2016 2017 2018 Totals Lease Payment: Existing Payment Dept (name) 0 0 0 0 0 0 IT 0 0 0 0 0 0 Proposed Payment Dept (name) 0 0 0 0 0 0 IT 0 0 0 0 0 0 Change Dept (name) 0 0 0 0 0 0 IT 0 0 0 0 0 0 rage t or G -42 VILLAGE OF MOUNT PROSPECT Justification /Comments: Syn -Apps, the vendor who makes the Village's Call Accounting software is dropping their Call Accounting product. They will continue their product lines for Paging and Panic Buttons. The existing Call Accounting system will continue to be supported for a couple of years, although no upgrades will be available. Eventually the Village will need to replace this system. Is this part of the dept.'s Yes, it is included in the Technology Plan S yr technology plan as provided to the Village Technology Advisory Group? Ifso, how? Implementation 2016 schedule: Personnel utilizing: Information Technology Page L of 1 File Name: 2016 Telephone Call Accounting System N) = New G -43