Loading...
HomeMy WebLinkAbout09. Information TechnologyINFORMATION TECHNOLOGY City Information Systems Light & Water Information Systems Sewer Information Systems 139 INFORMATION TECHNOLOGY PROGRAM COMMENTARY PROGRAM DESCRIPTION: The Department of Information Technology provides leadership in the development of powerful, cost-effective technical services, and business solutions for City staff and policy makers. Services include the management and support of the technology infrastructure and network administration, providing citywide systems and solutions. Maintaining a 24/7 center of information and services via WEB and social media to the community. Ongoing responsibilities include: Strategic planning related to technology and the City’s networking infrastructure; Software and hardware support of all systems including but not limited to: software licensing, financial software systems, business licensing systems, building p ermit systems, land management systems, geographic information systems (GIS), library systems, utility billing and integrated systems, and all phone and telecom systems; helpdesk, internet, e-mail, web sites, social media, wireless, and the fiber backbone and network infrastructure on which all systems reside. Coordinate acquisition of new and replacement hardware and software for all City departments. FY 2019-20 STRATEGIC GOALS:  Evaluate and recommend a phone system replacement, begin implementation.  Acquisition of Storage Area Network (SAN) will allow for additional storage and virtualization of servers  Implementation of On-Line Recreation Registration and Reservation system  Research and recommend an integrated Community Development/Planning/Building/Code Enforcement software solution FY 2018-19 PROGRAM HIGHLIGHTS:  Implementation of Mobile Device Management (MDM) for iPads and iPhones.  New GIS Digital Imagery via LARIAC consortium.  Telecommunications assessment including analysis of all facilities for needed upgrades to cabling and infrastructure 140 Description 6220 Training Schools - Microsoft Training, ESRI 6235 Meetings/Conferences - MISAC, Women Leading Government, CENIC, SUGA 6415 Computer Software Services - Superion, SIRSI, ESRI, HDL, Civicplus, Granicus, HDL, ActiveNet, Envisionware, BMI, PubWorks, SEP 6493 Outside Services & Repairs - JD Briggs, CorData SIRSI 6499 Contract Services - SAS Access Control, HDL 6504 Computer Software Licensing - MS Office, PC Anywhere, Netware, McAfee, Adobe, Novell Patch Management, Zenworks, GroupWise, Solarwinds Orion,Digicert,Veritas, Public Contract Software Service 6570 Computer Hardware Peripherals - GovConnection, CDW-G, PC Mall 6835 Maintenance & Repair/Equipment - Avaya support, Music on Hold, Mutare, CMS communications 6846 Computer Hardware Maintenance - Charter Fiber, Verizon T1x3, Cisco , Watchguard, Laser printer service, Hewlett Packard, Barracuda,Watchgard 6915 Utilities-Telephone - City phone expense, payphones, cell phones, aircards, CENIC Account Number 4849xxxxxx INFORMATION TECHNOLOGY ACTIVITY DETAIL (SUMMARY) 141 BUDGET UNIT: ALL FUND 48 DIVISIONS-INFORMATION TECH (Summary) ACTUAL ACTUAL REVISED YEAR END EST ADOPTED VARIANCE Acct. #DESCRIPTION 16-17 17-18 18-19 18-19 19-20 PERSONNEL 6003 Salaries/Regular 613,401 627,319 633,075 634,740 633,065 (10) 6012 Salaries/Comp-Time 561 936 - 1,100 - - 6015 Salaries/Vacation 27,644 21,782 - 28,685 - - 6024 Salaries/Sick Leave 13,027 16,288 - 19,430 - - 6027 Salaries/Bereavement 43 872 - - - - 6033 Overtime Pay/Premium 1,325 3,508 - 3,270 - - 6048 Salaries/Language Pay 3,614 3,600 3,600 3,600 3,600 - 6063 Salaries/Jury Duty - - - 350 - - 6069 Allowances/Vehicle 5,421 5,400 5,400 5,400 5,400 - 6072 Salaries/Injury 173 - - - - - 6075 Vacation Pay-Off 32,847 42,871 - 36,745 32,500 32,500 6078 Sick Leave Pay-Off 9,141 11,242 - 8,100 9,500 9,500 6082 Lve Bank Usage 1,498 - - - - - 6091 Leave Liability Adjustments 9,588 13,110 - - - - 6101 PERS/Employee Contribution 43,348 45,095 44,870 45,550 42,270 (2,600) 6104 PERS Lump Sum - - 82,500 82,500 88,170 5,670 6105 PERS/Employer Contribution 64,879 82,764 10,327 14,720 16,770 6,443 6109 PARS/Employer 32,262 70,899 34,280 14,930 33,885 (395) 6125 FICA/Employer Contrib/Med 10,069 10,005 10,715 10,255 10,785 70 6133 Retiree Health Premium Reimb 1,554 1,605 1,635 1,415 - (1,635) 6140 Life Insurance Allocation 1,403 1,446 1,710 1,505 1,870 160 6155 Workers' Comp Allocation 24,722 25,743 25,685 26,035 25,690 5 6160 LTD Insurance Allocation 4,815 5,202 4,925 5,600 4,915 (10) 6165 Unemployment Allocation 559 581 745 585 740 (5) 6175 Benefits/Flex Plan 98,075 92,823 96,905 97,090 100,800 3,895 6180 Deferred Comp/Employer Paid 6,171 6,120 7,920 5,970 9,615 1,695 PERSONNEL SUBTOTAL 1,006,138 1,089,314 964,292 1,047,610 1,019,575 55,283 OPERATIONS 6201 Uniforms & Laundry 143 86 - - - - 6220 Training Schools - 80 4,500 4,500 4,500 - 6230 Dues & Subscriptions 889 644 1,400 1,400 1,400 - 6235 Meetings & Conferences 265 2,109 4,200 4,200 4,200 - 6240 Mileage Reimbursement 120 181 400 400 400 - 6345 Program Consultants - - - - 25,000 25,000 6415 Computer Software Support 154,265 143,483 223,465 223,465 225,550 2,085 6493 Outside Services & Repairs 3,823 20,130 30,823 30,823 30,823 - 6499 Contract Services & Fees/Other 800 8,048 56,000 56,000 2,000 (54,000) 6504 Computer Software/Licensing 58,244 89,535 110,650 126,847 147,862 37,212 6521 Messenger Service - 342 100 100 100 - 6527 Supplies/Computer/Small Equipment 8,978 6,489 15,505 15,505 15,505 - 6530 Office Supplies 836 690 690 690 690 - 6563 Supplies/Special 4,474 2,506 2,000 2,000 2,000 - 6569 Small Equipment 10,641 10,237 51,249 36,262 15,800 (35,449) 6570 Computer Peripherals/Misc 16,406 11,324 15,000 15,000 15,000 - 6835 Maint & Repair/Equipment 37,928 41,518 55,200 55,200 55,340 140 6846 Computer Hardware Maint/Repair 60,359 44,019 78,835 78,835 105,725 26,890 6850 Lease Payments - 34,537 35,000 35,000 35,000 - 6915 Utilities/Telephone 172,586 153,492 140,500 140,500 125,400 (15,100) OPERATIONS SUBTOTAL 530,757 569,452 825,517 826,727 812,295 (13,222) CAPITAL OUTLAY 7140 Equipment & Machinery - 25,990 - - - - 7142 Computer Equipment 27,627 4,943 - - - - 7143 Computer Software - 4,550 4,000 - 100,200 100,200 CAPITAL OUTLAY SUBTOTAL 27,627 35,483 4,000 - 100,200 100,200 INFORMATION TECH FUND TOTAL:1,564,522 1,694,249 1,793,809 1,874,337 1,932,070 138,261 142 BUDGET UNIT:4849930000 INFORMATION TECHNOLOGY - CITY REVISED YEAR END EST ADOPTED Acct. #DESCRIPTION 18-19 18-19 19-20 VARIANCE EXPLANATION OPERATIONS 6230 Dues & Subcriptions 1,200 1,200 750 (450) Moved to L&W 6345 Program Consultant - - 12,500 12,500 Consuting Services E-Mail Migration 6415 Computer Software Support 205,335 205,335 170,080 (35,255) Increases in support contracts for SIRSI, HDL- BL, Granicus, moved 50% of CivicPlus, OneSolution to 942 6499 Contract Services & Fees 28,000 28,000 2,000 (26,000) One time project 6504 Computer Software/Licensing 68,000 85,197 96,132 28,132 Additional e-mail license for PT employees, Graffitti tracker, JAMPF moved to 942. $14,352 is for Co-Star Subscription 6569 Small Equipment 18,287 3,300 3,300 (14,987) One time project 6846 Computer Hardware Maint/Repair 32,535 32,535 45,980 13,445 Increase in hardware support costs. $12,045 is related to 20 PC Replacements 143 Description 6235 Meetings/Conferences - ESRI 6415 Computer Software Services - SunGard, SIRSI, ESRI, HDL, Civicplus, Granicus, HDL 6493 Outside Services & Repairs - Superion, SIRSI 6499 Contract Services - HDL, JD Briggs 6504 Computer Software Licensing - MS Office, PC Anywhere, Netware, McAfee, Adobe, Novell Patch Management, Zenworks, GroupWise, Solarwinds Orion,Digicert, Autocad, AutoCAD, Public Contract Software Service, Mobile Device Management 6846 Computer Hardware Maintenance - Laser printer services, Watchguard, Hewlett Packard, Cisco, Server support Account Number 4849930000 INFORMATION TECHNOLOGY - CITY ACTIVITY DETAIL 144 BUDGET UNIT:4849940000 INFORMATION TECHNOLOGY - COMMUNICATION SERVICES REVISED YEAR END EST ADOPTED Acct. #DESCRIPTION 18-19 18-19 19-20 VARIANCE EXPLANATION OPERATIONS 6835 Maint Repair & Equipment 55,200 55,200 55,340 140 Mutare voicemail to mail increase 6915 Utilites/Telephone 133,000 133,000 119,400 (13,600) City Cellphone audit reduction 145 Description 6835 Maintenance & Repair/Equipment - Avaya support, Spenser Communications, Music on Hold, Mutare 6915 Utilities-Telephone - City phone expense, Verizon T1x3, Charter fiber, cell phones, aircards Account Number INFORMATION TECHNOLOGY - COMMUNICATION SERVICES ACTIVITY DETAIL 4849940000 146 BUDGET UNIT:4849942000 INFORMATION TECHNOLOGY - LIGHT AND WATER INFORMATION SYSTEMS REVISED YEAR END EST ADOPTED Acct. #DESCRIPTION 18-19 18-19 19-20 VARIANCE EXPLANATION OPERATIONS 6230 Dues & Subcriptions 200 200 650 450 Moved from General Fund 6345 Program Consultants - - 12,500 12,500 Email Consultants 6415 Computer Software Support 17,130 17,130 54,470 37,340 Additional Request Tracker Licenses, moved 50% civic plus and OneSolution here, 6499 Contract Services & Fees 28,000 28,000 - (28,000) Telecom Study 6504 Computer Software Licensing 40,200 40,200 50,280 10,080 Additonal Licenses for JAMPF/MDM 6569 Small Equipment 22,462 22,462 2,000 (20,462) One time project 6846 Computer Hardware Maint/Repairs 46,300 46,300 59,745 13,445 Increase Maintenance Costs. $12,045 is related to 20 PC Replacements 147 Description 6220 Training Schools - Microsoft Training, ESRI 6235 Meetings/Conferences - SUGA, MISAC 6415 Computer Software Services - SunGard, SIRSI, ESRI, HDL, Civicplus, Granicus, HDL 6493 Outside Services & Repairs - JD Briggs,CorData 6504 Computer Software Licensing - MS Office, PC Anywhere, Netware, McAfee, Adobe, Novell Patch Management, Zenworks, GroupWise, Solarwinds Orion,Digicert,Verisign 6499 Contract Services - SAS Access Control, HDL 6570 Computer Hardware Peripherals - GovConnection, CDW-G, PC Mall 6846 Computer Hardware Maintenance - Charter Fiber, Verizon T1x3, Cisco , Watchguard, Laser printer service, Hewlett Packard Account Number 4849942000 ACTIVITY DETAIL INFORMATION TECHNOLOGY - LIGHT AND WATER INFORMATION SYSTEMS 148 BUDGET UNIT:4849942120 INFORMATION TECHNOLOGY - L&W TECH FUND REVISED YEAR END EST ADOPTED Acct. #DESCRIPTION 18-19 18-19 19-20 VARIANCE EXPLANATION OPERATIONS 6915 Utilites/Telephone 7,500 7,500 6,000 (1,500) Based on Actuals 149 Description 4849942120 6915 Utilities-Telephone - City Council phones and aircards-Verizon Wireless INFORMATION TECHNOLOGY - LIGHT AND WATER TECHNOLOGY FUND Account Number ACTIVITY DETAIL 150 BUDGET UNIT:4849944000 INFORMATION TECHNOLOGY - SEWER FUND REVISED YEAR END EST ADOPTED Acct. #DESCRIPTION 18-19 18-19 19-20 VARIANCE EXPLANATION OPERATIONS 6504 Computer Softward/Licensing 2,450 1,450 1,450 (1,000) Reduced software license costs 151 Description 4849944000 6504 Computer Software Licensing - Autodesk, AutoCAD Account Number ACTIVITY DETAIL INFORMATION TECHNOLOGY - SEWER INFORMATION SYSTEM 152 BUDGET UNIT:ALL FUND 48 DIVISIONS-INFORMATION TECH (Detail) ACTUAL ACTUAL REVISED YEAR END EST ADOPTED Acct. #DESCRIPTION 16-17 17-18 18-19 18-19 19-20 VARIANCE PERSONNEL 4849930000 CITY COMPUTER SERVICES 6003 Salaries/Regular 260,611 263,608 268,705 270,700 271,635 2,930 6033 Overtime Pay/Premium 662 1,557 - 930 - - 6048 Salaries/Language Pay 1,325 1,320 1,320 1,320 1,320 - 6063 Salaries/Jury Duty - - - 45 - - 6068 Allowances/Management 53 - 35 - 6069 Allowance/Vehicle 2,710 2,700 2,700 2,700 2,700 - 6072 Salaries/Injury 86 - - - - - 6075 Vacation Pay-Off 14,903 18,495 - 16,500 15,000 15,000 6078 Sick Leave Pay-Out 4,570 5,621 - 3,850 5,000 5,000 6091 Leave Liability Adjustments 4,794 5,669 - - - - 6082 Lve Bank Usage 1,428 - - - - - 6101 PERS/Employee Contribution 18,400 19,225 19,045 19,380 18,115 (930) 6104 PERS Lump Sum - - 35,045 35,045 37,775 2,730 6105 PERS/Employer Contribution 27,543 35,219 5,765 6,325 7,180 1,415 6109 PARS/Employer Contribution 14,488 51,543 15,340 5,405 15,405 65 6125 FICA/Employer Contrib/Med 4,292 4,234 4,525 4,360 4,600 75 6133 Retiree Health Prem 1,554 1,605 1,635 1,415 - (1,635) 6140 Life Insurance Allocation 593 613 725 635 800 75 6155 Workers' Comp Allocation 10,498 10,977 10,915 11,065 11,030 115 6160 LTD Insurance Allocation 2,105 2,275 2,090 2,435 2,110 20 6165 Unemployment Allocation 237 244 315 245 315 - 6175 Benefits/Flex Plan 40,042 37,904 39,570 39,650 41,160 1,590 6180 Deferred Comp/Employer Paid 2,595 2,574 3,475 2,510 4,340 865 SUBTOTAL 413,439 465,433 411,170 424,550 438,485 27,315 4849942000 LIGHT AND WATER INFORMATION SYSTEMS 6003 Salaries/Regular 325,133 335,888.39 336,545 336,165 331,705 (4,840) 6033 Overtime Pay/Premium 662 1,951 - 2,340 - - 6048 Salaries/Language Pay 1,566 1,560 1,560 1,560 1,560 - 6068 Allowances/Management 52 - - - 6069 Allowances/Vehicle 2,710 2,700 2,700 2,700 2,700 - 6072 Salaries/Injury 86 - - - - - 6075 Vacation Pay-Off 15,879 22,111 - 17,250 15,500 15,500 6078 Sick Leave Pay-Off 4,570 5,621 - 4,250 4,500 4,500 6082 Lve Bank Usage 70 - - - - - 6091 Leave Liability Adjustments 4,441 5,252 - - - - 6101 PERS/Employee Contribution 22,954 23,865 23,805 24,160 22,130 (1,675) 6104 PERS Lump Sum - - 43,720 43,720 46,170 2,450 6105 PERS/Employer Contribution 34,352 43,734 3,937 7,780 8,785 4,848 6109 PARS/Employer Contribution 17,774 19,356 18,940 9,525 18,480 (460) 6125 FICA/Employer Contrib/Med 5,344 5,338 5,705 5,445 5,670 (35) 6140 Life Insurance Allocation 744 767 910 800 980 70 6155 Workers' Comp Allocation 13,089 13,625 13,630 13,825 13,440 (190) 6160 LTD Insurance Allocation 2,527 2,732 2,620 2,950 2,575 (45) 6165 Unemployment Allocation 295 310 395 310 390 (5) 6175 Benefits/Flex Plan 53,129 50,272 52,490 52,580 54,600 2,110 6180 Deferred Comp/Employer Paid 3,412 3,384 4,285 3,300 4,950 665 SUBTOTAL 508,738 538,517 511,242 528,965 534,135 22,893 153 BUDGET UNIT:ALL FUND 48 DIVISIONS-INFORMATION TECH (Detail) ACTUAL ACTUAL REVISED YEAR END EST ADOPTED Acct. #DESCRIPTION 16-17 17-18 18-19 18-19 19-20 VARIANCE LW TECHNOLOGY FUND 6091 Leave Liability Adjustments - 83 - - - - SUBTOTAL - 83 - - - - 4849944000 SEWER INFORMATION SYSTEMS 6003 Salaries/Regular 27,657 27,823 27,825 27,875 29,725 1,900 6048 Salaries/Language Pay 723 720 720 720 720 - 6075 Vacation Pay-Off 2,065 2,265 - 2,995 2,000 2,000 6091 Leave Liability Adjustments 353 417 - - - - 6101 PERS/Employee Contribution 1,994 2,005 2,020 2,010 2,025 5 6104 PERS Lump Sum - 3,735 3,735 4,225 490 6105 PERS/Employer Contribution 2,983 3,812 625 615 805 180 6125 FICA/Employer Contrib/Med 433 433 485 450 515 30 6140 Life Insurance Allocation 66 67 75 70 90 15 6155 Workers' Comp Allocation 1,135 1,142 1,140 1,145 1,220 80 6160 LTD Insurance Allocation 183 196 215 215 230 15 6165 Unemployment Allocation 27 27 35 30 35 - 6175 Benefits/Flex Plan 4,903 4,646 4,845 4,860 5,040 195 6180 Deferred Comp/Employer Paid 163 162 160 160 325 165 SUBTOTAL 42,687 43,714 41,880 47,080 46,955 5,075 PERSONNEL SUBTOTAL 1,006,138 1,089,314 964,292 1,047,610 1,019,575 55,283 OPERATIONS 4849930000 CITY COMPUTER SERVICES 6201 Uniforms & Laundry 143 86 - - - - 6220 Training Schools - 80 500 500 500 - 6230 Dues & Subscriptions 889 644 1,200 1,200 750 (450) 6235 Meetings & Conferences 125 32 200 200 200 - 6240 Mileage Reimbursement - - 200 200 200 - 6345 Program Consultants - - - - 12,500 12,500 6415 Computer Software Support 144,589 131,869 205,335 205,335 170,080 (35,255) 6493 Outside Services & Repairs 1,102 253 9,540 9,540 9,540 - 6499 Contract Services & Fees/Other 800 1,682 28,000 28,000 2,000 (26,000) 6504 Computer Software/Licensing 39,211 53,411 68,000 85,197 96,132 28,132 6527 Supplies/Computer/Small Equip 5,434 5,087 6,805 6,805 6,805 - 6530 Office Supplies 542 473 490 490 490 - 6563 Supplies/Special 2,756 1,928 1,500 1,500 1,500 - 6569 Small Equipment 3,994 3,764 18,287 3,300 3,300 (14,987) 6846 Computer Hardware Maint/Repair 15,366 14,978 32,535 32,535 45,980 13,445 6850 Lease Payments - 34,537 35,000 35,000 35,000 - SUBTOTAL 214,951 248,823 407,592 409,802 384,977 (22,615) 4849940000 COMMUNICATION SERVICES 6493 Outside Services & Repairs - 17,059 14,583 14,583 14,583 - 6499 Contract Svcs & Fees/Other - 2,592 - - - 6835 Maint & Repair/Equipment 37,928 41,518 55,200 55,200 55,340 140 6915 Utilities/Telephone 159,027 148,936 133,000 133,000 119,400 (13,600) SUBTOTAL 196,955 210,105 202,783 202,783 189,323 (13,460) 4849942000 LIGHT AND WATER INFORMATION SYSTEMS 6220 Training Schools - - 4,000 4,000 4,000 - 6230 Dues & Subscriptions - - 200 200 650 450 6235 Meetings & Conferences 140 2,077 4,000 4,000 4,000 - 6240 Mileage Reimbursement 120 181 200 200 200 - 6345 Program Consultants - - - - 12,500 12,500 6415 Computer Software Support 8,676 10,964 17,130 17,130 54,470 37,340 6493 Outside Services & Repairs 2,721 2,819 6,700 6,700 6,700 - 6499 Contract Services & Fees/Other - 3,774 28,000 28,000 - (28,000) 6504 Computer Software/Licensing 16,702 34,751 40,200 40,200 50,280 10,080 6521 Messenger Service - 342 100 100 100 - 6527 Supplies/Computer/Small Equip 3,544 1,403 8,700 8,700 8,700 - 6530 Office Supplies 294 217 200 200 200 - 6563 Supplies/Special 1,717 578 500 500 500 - 154 BUDGET UNIT:ALL FUND 48 DIVISIONS-INFORMATION TECH (Detail) ACTUAL ACTUAL REVISED YEAR END EST ADOPTED Acct. #DESCRIPTION 16-17 17-18 18-19 18-19 19-20 VARIANCE 6569 Small Equipment 2,233 1,371 22,462 22,462 2,000 (20,462) 6570 Computer Peripherals/Misc 16,406 11,324 15,000 15,000 15,000 - 6846 Computer Hardware Maint/Repair 42,497 29,042 46,300 46,300 59,745 13,445 6915 Utilities/Telephone 8,329 - - - - - SUBTOTAL 103,380 98,843 193,692 193,692 219,045 25,353 4849942120 LIGHT AND WATER TECHNOLOGY FUND 6569 Small Equipment 4,414 5,103 10,500 10,500 10,500 - 6915 Utilities/Telephone 5,230 4,556 7,500 7,500 6,000 (1,500) SUBTOTAL 9,644 9,658 18,000 18,000 16,500 (1,500) 4849944000 SEWER INFORMATION SYSTEMS - 6415 Computer Software Support 1,000 650 1,000 1,000 1,000 - 6504 Computer Software/Licensing 2,331 1,373 2,450 1,450 1,450 (1,000) SUBTOTAL 5,828 2,023 3,450 2,450 2,450 (1,000) OPERATIONS SUBTOTAL 530,757 569,452 825,517 826,727 812,295 (13,222) CAPITAL OUTLAY 4849930000 CITY COMPUTER SERVICES 7140 Machinery and Equipment - 12,446 - - - - 7142 Computer Equipment 27,627 - - - - - 7143 Computer Software - 4,550 4,000 - 87,600 83,600 SUBTOTAL 27,627 16,996 4,000 - 87,600 83,600 4849942000 LIGHT AND WATER INFORMATION SYSTEMS 7140 Equipment & Machinery - 13,544 - - - - 7143 Computer Software - - - - 12,600 12,600 SUBTOTAL - 13,544 - - 12,600 12,600 4849940000 COMMUNICATION SERVICES 7142 Computer Equipment - 4,943 - - - - SUBTOTAL - 4,943 - - - - CAPITAL OUTLAY SUBTOTAL 27,627 35,483 4,000 - 100,200 192,400 INFORMATION TECH FUND TOTAL:1,564,522 1,694,249 1,793,809 1,874,337 1,932,070 234,461 155