Loading...
HomeMy WebLinkAbout09. Information Technology_201808011201084033INFORMATION TECHNOLOGY City Information Systems Light and Wate r Information Systems Sewer Information Systems 154 PROGRAM DESCRIPTION: INFORMATION TECHNOLOGY PROGRAM COMMENTARY 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 permit 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. Coordination of acquisition of new and replacement hardware and software for all City departments. Fv201a-19 STRATEGIC GOALS: •New GIS Digital Imagery via LARIAC consortium •Evaluate and recommend a phone system replacement, begin implementation •Complete study for active directory exchange server/e-mail implementation and transition project EX 2017-18 PROGRAM HlGHUGHTS: •Implementation of Mobile Device Management (MDM) for ipads and iPhones •Work with Budget Efficiency Committee to help create efficiencies citywide using technology •Expansion of PUBworks system to include Streets modules •Upgrade Business Licensing System to Prime •Digitization of all Community Development Microfiche Records to digital 155 INFORMATION TECHNOLOGY ACTIVITY DETAIL (SUMMARY) Account Number Description 4849XXXXXX 6220 Training Schools -Microsoft Training, ESRI 6235 Meetings/Conferences -MISAC, Women Leading Government, CENIC, SU GA 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 156 BUDGET UNIT: ALL FUND 48 DIVISIONS-INFORMATION TECH (Summary) ACTUAL ACTUAL REVISED YEAR END EST ADOPTED VARIANCE Acct.# DESCRIPTION 15-16 16-17 17-18 17-18 18-19 PERSONNEL 6003 Salaries/Regular 602,381 613,401 616,929 633,520 633,075 16,146 6012 Salaries/Comp-Time 518 561 820 6015 Salaries/Vacation 33,694 27,644 23,390 6024 Salaries/Sick Leave 34,022 13,027 18,705 6027 Salaries/Bereavement 43 1,000 6033 Overtime Pay/Premium 1,937 1,325 3,555 6039 Salaries/Standby 356 6048 Salaries/Language Pay 3,620 3,614 3,600 3,600 3,600 6063 Salaries/Jury Duty 2,651 6069 Allowances/Vehicle 5,101 5,421 5,400 5,400 5,400 6072 Salaries/Injury 173 6075 Vacation Pay-Off 27,167 32,847 36,925 6078 Sick Leave Pay-Off 5,404 9,141 9,730 6082 Lve Bank Usage 38,594 1,498 6091 Leave Liability Adjustments {8,290) 9,588 6101 PERS/Employee Contribution 42,753 43,348 43,650 44,980 44,870 1,220 6104 PERS Lump Sum 71,017 71,017 82,500 11,483 6105 PERS/Employer Contribution 44,335 64,879 14,208 14,208 10,327 {3,881) 6109 PARS/Employer 43,014 32,262 32,235 35,165 34,280 2,045 6125 FICNEmployer Contrib/Med 10,444 10,069 10,465 9,970 10,715 250 6133 Retiree Health Premium Reimb 1,526 1,554 1,595 1,595 1,635 40 6140 Life Insurance Allocation 1,451 1,403 1,665 1,450 1,710 45 6155 Workers' Comp Allocation 24,406 24,722 24,990 25,665 25,685 695 6160 LTD Insurance Allocation 5,181 4,815 4,790 5,065 4,925 135 6165 Unemployment Allocation 572 559 720 590 745 25 6175 Benefits/Flex Plan 104,627 98,075 96,905 91,525 96,905 6180 Deferred Come/Emeloler Paid 5,679 6,171 6,120 5,970 7,920 1,800 PERSONNEL SUBTOTAL 1,031,144 1,006,138 934,289 1,043,845 964,292 30,002 157 BUDGET UNIT: ALL FUND 48 DIVISIONS-INFORMATION TECH (Summary) ACTUAL ACTUAL REVISED YEAR END EST ADOPTED VARIANCE Acct.# DESCRIPTION 15-16 16-17 17-18 17-18 18-19 OPERATIONS 6201 Uniforms & Laundry 228 143 6220 Training Schools 3,674 4,000 4,000 4,500 500 6230 Dues & Subscriptions 711 889 1,500 1,500 1,400 (100) 6235 Meetings & Conferences 143 265 4,200 4,200 4,200 6240 Mileage Reimbursement 72 120 400 400 400 6415 Computer Software Support 186,125 154,265 196,310 196,310 223,190 26,880 6493 Outside Services & Repairs 6,506 3,823 22,023 22,023 30,823 8,800 6499 Contract Services & Fees/Other 923 800 9,000 4,000 29,000 20,000 6504 Computer Software/Licensing 51,655 58,244 122,353 121,697 110,650 (11,703) 6521 Messenger Service 100 100 100 6527 Supplies/Computer/Small Equipment 4,290 8,978 13, 111 13,111 15,505 2,394 6530 Office Supplies 851 836 690 690 690 6563 Supplies/Special 1,838 4,474 2,000 2,000 2,000 6569 Small Equipment 6,730 10,641 12,800 10,300 51,249 38,449 6570 Computer Peripherals/Misc 29,595 16,406 15,000 15,000 15,000 6835 Maint & Repair/Equipment 36,742 37,928 35,000 40,000 55,200 20,200 6846 Computer Hardware Maint/Repair 53,323 60,359 66,675 66,675 78,835 12,160 6850 Lease Payments 34,000 34,000 35,000 1,000 6915 Utilities/Telephone 170,932 172,586 144,960 144,960 140,500 (4,460) OPERATIONS SUBTOTAL 554,338 530,757 684,122 680,966 798,242 114,120 CAPITAL OUTLAY 7140 Equipment & Machinery 13,600 (13,600) 7142 Computer Equipment 484 27,627 7143 Comeuter Software 8,156 CAPITAL OUTLAY SUBTOTAL 484 27,627 21,756 (13,600) INFORMATION TECH FUND TOTAL: 1,585,966 1,564,522 1,640,167 1,724,811 1,762,534 122,366 158 BUDGET UNIT: DESCRIPTION Acct.# OPERATIONS 6415 Computer Software Support 6493 Outside Services & Repairs 6499 Contract Services & Fees 6504 Computer Software/Licensing 6569 Small Equipment 6846 Computer Hardware Maint/Repair 4849930000 CITY INFO TECH REVISED 17-18 179,720 2,583 2,000 85,197 3,300 25,225 YEAR END EST ADOPTED 17-18 18-19 179,720 205,060 16,583 9,540 2,000 14,500 85,197 68,000 3,300 18,287 25,225 32,535 VARIANCE Explanation 25,340 Increases for Granicus,SIRSI (Library) Superion, additional items Granicus High Defintition, civic Plus additional Request tracker users, Pub works support, SEP backup software individual server licenses. 6,957 Superion training and reports 12,500 Consultant Study on email system replacement. (17,197) based on actuals Graffitti Tracker $6,000. Removed any one time project budgets from FY1718. 14,987 PCs, monitors, and laptop. 7,310 Server maintenance suppport contract renewal increase, message archiver maintenance support agreement (new item). 159 INFORMATION TECHNOLOGY ACTIVITY DETAIL Account Number Description City 4849930000 6236 Meetings/Conferences -ESRI 6415 Computer Software Services -SunGard, SIRSI, ESRI, HDL, Civicplus, Granicus, HDL 6493 Outside Services & Repairs -Superion, SIRS! 6499 Contract Services -SAS Access Control, HDL 6604 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 160 BUDGET UNIT: 4849940000 COMMUNICATION SERVICES DESCRIPTION REVISED YEAR END EST ADOPTED Acct.# 17-18 17-18 18-19 VARIANCE Explanation OPERATIONS 6835 Maint Repair & Equipment 35,000 40,000 55,200 20,200 This is the estimated full year FY1819 costs on maintenance and repairs for equipments. 6915 Utilites/Telephone 139,160 139,160 133,000 (6,160) Savings form renegotiated contract 161 INFORMATION TECHNOLOGY ACTIVITY DETAIL Account Number Description Communications Services 4849940000 6835 Maintenance & Repair/Equipment -Avaya support, Spenser Communications, Music on Hold, Mutare 6915 Utilities-Telephone -City phone expense, Verizon Tlx3, Charter fiber, cell phones, aircards 162 BUDGET UNIT: VARIANCE DESCRIPTION Acct.# OPERATIONS 6499 Contract Services & Fees 6504 Software License 6569 Small Equipment 4849942000 LIGHT AND WATER INFORMATION SYSTEMS REVISED YEAR END EST ADOPTED 17-18 17-18 18-19 VARIANCE Explanation 7,000 2,000 14,500 7,500 Consultant Study on email system replacement. 34,656 34,000 40,200 5,544 True up MS Office/Server, Addt'I GW Licenses. ERSI License. 2,000 2,000 22,462 20,462 PCs, monitors, and laptop. 163 INFORMATION TECHNOLOGY ACTIVITY DETAIL Account Number Description Light and Water Information Systems 4849942000 6220 Training Schools -Microsoft Training, ESRI, 6235 Meetings/Conferences -SUGA, MISAC, 6415 Computer Software Services -SunGard, SIRS!, 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, Group Wise, 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 Tlx3, Cisco , Watchguard, Laser printer service, Hewlett Packard 164 INFORMATION TECHNOLOGY ACTIVITY DETAIL Account Number Description LW Technology Fund 4849942120 6915 Utilities-Telephone -City Council phones and aircards-Verizon Wireless 165 INFORMATION TECHNOLOGY ACTIVITY DETAIL Account Number Description Sewer Information System 4849944000 6415 Computer Software Services· 6504 Computer Software Licensing -Autodesk, AutoCAD 6846 Computer Hardware Maintenance - 166 BUDGET UNIT: ALL FUND 48 DIVISIONS-INFORMATION TECH (Detail) ACTUAL ACTUAL REVISED YEAR END EST ADOPTED Acct.# DESCRIPTION 15-16 16-17 17-18 17-18 18-19 VARIANCE PERSONNEL 4849930000 CITY COMPUTER SERVICES 6003 Salaries/Regular 255,076 260,611 262,053 270,220 268,705 6,652 6033 Overtime Pay/Premium 819 662 1,520 6039 Standby Pay/Premium 136 6048 Salaries/Language Pay 1,328 1,325 1,320 1,320 1,320 6063 Salaries/Jury Duty 1,325 6069 AllowanceNehicle 2,550 2,710 2,700 2,700 2,700 6072 Salaries/Injury 86 6075 Vacation Pay-Off 11,850 14,903 16,195 6078 Sick Leave Pay-Out 2,702 4,570 4,865 6091 Leave Liability Adjustments (3,954) 4,794 6082 Lve Bank Usage 19,297 1,428 6101 PERS/Employee Contribution 18,101 18,400 18,540 19,190 19,045 505 6104 PERS Lump Sum 30,186 30,186 35,045 4,859 6105 PERS/Employer Contribution 27,301 27,543 6,054 6,054 5,765 (289) 6109 PARS/Employer Contribution 13,863 14,488 14,465 15,915 15,340 875 6125 FICA/Employer Contrib/Med 4,458 4,292 4,420 4,225 4,525 105 6133 Retiree Health Prem 1,526 1,554 1,595 1,595 1,635 40 6140 Life Insurance Allocation 612 593 710 615 725 15 6155 Workers' Comp Allocation 10,334 10,498 10,625 10,950 10,915 290 6160 LTD Insurance Allocation 2,260 2,105 2,035 2,220 2,090 55 6165 Unemployment Allocation 241 237 305 250 315 10 6175 Benefits/Flex Plan 42,725 40,042 39,570 37,375 39,570 6180 Deferred CometEmelo�er Paid 2,317 2,595 2,575 2,510 3,475 900 SUBTOTAL 414,867 413,439 397,153 427,905 411,170 14,016 4849942000 LIGHT AND WATER INFORMATION SYSTEMS 6003 Salaries/Regular 318,866 325,133 327,051 335,475 336,545 9,494 6033 Overtime Pay/Premium 1,118 662 2,035 6039 Standby Pay/Premium 220 6048 Salaries/Language Pay 1,548 1,566 1,560 1,560 1,560 6063 Salaries/Jury Duty 1,325 6069 AllowancesNehicle 2,550 2,710 2,700 2,700 2,700 6072 Salaries/Injury 86 6075 Vacation Pay-Off 13,963 15,879 18,579 167 BUDGET UNIT: ALL FUND 48 DIVISIONS-INFORMATION TECH (Detail) ACTUAL ACTUAL REVISED YEAR END EST ADOPTED Acct.# DESCRIPTION 15-16 16-17 17-18 17-18 18-19 VARIANCE 6078 Sick Leave Pay-Off 2,702 4,570 4,865 6082 Lve Bank Usage 19,297 70 6091 Leave Liability Adjustments (4,035)4,441 6101 PERS/Employee Contribution 22,602 22,954 23,090 23,785 23,805 715 6104 PERS Lump Sum 37,527 37,527 43,720 6,193 6105 PERS/Employer Contribution 13,921 34,352 7,483 7,483 3,937 (3,546) 6109 PARS/Employer Contribution 29,150 17,774 17,770 19,250 18,940 1,170 6125 FICNEmployer Contrib/Med 5,548 5,344 5,560 5,300 5,705 145 6140 Life Insurance Allocation 768 744 880 765 910 30 6155 Workers' Comp Allocation 12,905 13,089 13,225 13,575 13,630 405 6160 LTD Insurance Allocation 2,715 2,527 2,540 2,655 2,620 80 6165 Unemployment Allocation 303 295 380 310 395 15 6175 Benefits/Flex Plan 56,675 53,129 52,490 49,570 52,490 6180 Deferred Come/Emeloler Paid 3,188 3,412 3,385 3,300 4,285 900 SUBTOTAL 505,330 508,738 495,641 528,734 511,242 15,601 4849944000 SEWER INFORMATION SYSTEMS 6003 Salaries/Regular 28,439 27,657 27,825 27,825 27,825 6048 Salaries/Language Pay 745 723 720 720 720 6075 Vacation Pay-Off 1,353 2,065 2,151 6091 Leave Liability Adjustments (300)353 6101 PERS/Employee Contribution 2,051 1,994 2,020 2,005 2,020 6104 PERS Lump Sum 3,304 3,304 3,735 431 6105 PERS/Employer Contribution 3,112 2,983 671 671 625 (46) 6125 FICNEmployer Contrib/Med 438 433 485 445 485 6140 Life Insurance Allocation 71 66 75 70 75 6155 Workers' Comp Allocation 1,167 1,135 1,140 1,140 1,140 6160 LTD Insurance Allocation 206 183 215 190 215 6165 Unemployment Allocation 28 27 35 30 35 6175 Benefits/Flex Plan 5,228 4,903 4,845 4,580 4,845 6180 Deferred Come/Emeloler Paid 174 163 160 160 160 SUBTOTAL 42,712 42,687 41,495 43,291 41,880 385 PERSONNEL SUBTOTAL 1,031,144 1,006,138 934,289 1,043,845 964,292 30,002 168 BUDGET UNIT: ALL FUND 48 DIVISIONS-INFORMATION TECH (Detail) ACTUAL ACTUAL REVISED YEAR END EST ADOPTED Acct.# DESCRIPTION 15-16 16-17 17-18 17-18 18-19 VARIANCE OPERATIONS 4849930000 CITY COMPUTER SERVICES 6201 Uniforms & Laundry 228 143 6220 Training Schools 500 500 6230 Dues & Subscriptions 711 889 1,000 1,000 1,200 200 6235 Meetings & Conferences 71 125 200 200 200 6240 Mileage Reimbursement 200 200 200 6415 Computer Software Support 170,162 144,589 179,720 179,720 205,060 25,340 6493 Outside Services & Repairs 249 1,102 2,583 16,583 9,540 6,957 6499 Contract Services & Fees/Other 923 800 2,000 2,000 14,500 12,500 6504 Computer Software/Licensing 32,011 39,211 85,197 85,197 68,000 (17,197) 6527 Supplies/Computer/Small Equip 4,290 5,434 6,805 6,805 6,805 6530 Office Supplies 650 542 490 490 490 6563 Supplies/Special 1,568 2,756 1,500 1,500 1,500 6569 Small Equipment 3,344 3,994 3,300 3,300 18,287 14,987 6570 Computer Peripherals/Misc 8,483 6846 Computer Hardware Maint/Repair 10,938 15,366 25,225 25,225 32,535 7,310 6850 Lease Patments 34,000 34,000 35,000 1,000 SUBTOTAL 233,630 214,951 342,220 356,220 393,817 51,597 4849940000 COMMUNICATION SERVICES 6415 Comp Sft Sppt 1,900 6493 Outside Services & Repairs 14,000 14,583 583 6504 Computer Software/Licensing 270 6846 Computer Hardware Maint/Repair 266 6835 Maint & Repair/Equipment 36,742 37,928 35,000 40,000 55,200 20,200 6915 Utilities/T eleehone 165,987 159,027 139,160 139,160 133,000 �6, 160� SUBTOTAL 205,165 196,955 188,160 179,160 202,783 14,623 4849942000 LIGHT AND WATER INFORMATION SYSTEMS 6220 Training Schools 3,674 4,000 4,000 4,000 6230 Dues & Subscriptions 500 500 200 (300) 6235 Meetings & Conferences 71 140 4,000 4,000 4,000 6240 Mileage Reimbursement 72 120 200 200 200 6415 Computer Software Support 13,090 8,676 15,890 15,890 17,130 1,240 169 BUDGET UNIT: ALL FUND 48 DIVISIONS-INFORMATION TECH (Detail) ACTUAL ACTUAL REVISED YEAR END EST ADOPTED Acct.# DESCRIPTION 15-16 16-17 17-18 17-18 18-19 VARIANCE 6493 Outside Services & Repairs 6,257 2,721 5,440 5,440 6,700 1,260 6499 Contract Services & Fees/Other 7,000 2,000 14,500 7,500 6504 Computer Software/Licensing 18,280 16,702 34,656 34,000 40,200 5,544 6521 Messenger Service 100 100 100 6527 Supplies/Computer/Small Equip 3,544 6,306 6,306 8,700 2,394 6530 Office Supplies 201 294 200 200 200 6563 Supplies/Special 270 1,717 500 500 500 6569 Small Equipment 1,692 2,233 2,000 2,000 22,462 20,462 6570 Computer Peripherals/Misc 21,112 16,406 15,000 15,000 15,000 6846 Computer Hardware Maint/Repair 42,118 42,497 41,450 41,450 46,300 4,850 6915 Utilities/Teleehone 8,329 SUBTOTAL 106,837 103,380 137,242 131,586 180,192 42,950 4849942120 LIGHT AND WATER TECHNOLOGY FUND 6569 Small Equipment 1,694 4,414 7,500 5,000 10,500 3,000 6915 Utilities/Telephone 4,945 5,230 5,800 5,800 7,500 1,700 SUBTOTAL 6,639 9,644 13,300 10,800 18,000 4,700 4849944000 SEWER INFORMATION SYSTEMS 6415 Computer Software Support 974 1,000 700 700 1,000 300 6504 Computer Software/Licensing 1,093 2,331 2,500 2,500 2,450 (50) 6846 Comeuter Hardware Maint/Reeair 2,496 SUBTOTAL 2,067 5,828 3,200 3,200 3,450 250 OPERATIONS SUBTOTAL 554,338 530,757 684,122 680,966 798,242 114,120 CAPITAL OUTLAY 4849930000 CITY COMPUTER SERVICES 7142 Computer Equipment 484 27,627 7143 Comeuter Software 8,156 {8,156) SUBTOTAL 484 27,627 8,156 (8,156) 4849942000 LIGHT AND WATER INFORMATION SYSTEMS 7140 Eguiement & Machine!}'. 13,600 {13,600} SUBTOTAL 13,600 (13,600) 170 BUDGET UNIT: Acct. # DESCRIPTION CAPITAL OUTLAY SUBTOTAL INFORMATION TECH FUND TOTAL: ALL FUND 48 DIVISIONS-INFORMATION TECH (Detail) ACTUAL 15-16 484 1,585,966 ACTUAL 16-17 27,627 1,564,522 REVISED YEAR END EST ADOPTED 17-18 17-18 18-19 VARIANCE 21,756 (21,756) 1,626,567 1,724,811 1,762,534 135,966 171