Loading...
HomeMy WebLinkAbout09. Information TechnologyINFORMATION TECHNOLOGY City Information Systems  Light and Water  Information Systems Sewer Information Systems  135 THIS PAGE INTENTIONALLY LEFT BLANK 136 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 City-wide 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; ongoing equipment replacement, helpdesk function, internet, e-mail, web sites, social media, wireless network, and the fiber backbone and network infrastructure on which all systems reside. STRATEGIC GOALS:  Complete and “GO Live” with the Finance system upgrade  Upgrade and debut the new website and integrated mobile APP  Implementation of contract management on-line FY 2014-15 PROGRAM HIGHLIGHTS:  Began the coordinated effort to upgrade the Financial System  Managed the GIS component of the Spillman 911 Computer Aided Dispatch (CAD) system  Assisted with software and hardware implementation of Light and Water Cloud Call Center  Migration of legacy systems to Windows 7  Replacement of Patron Access Computers in the Library 137 Budget Division: INFORMATION TECHNOLOGY (SUMMARY) FY 15-16FY 14-15 FY 15-16 FY 14-15 Revised Adopted Revised Adopted FY 14-15 FY 15-16 FY 14-15 FY 15-16 Revised Adopted Revised Adopted Position Title Allocation Allocation Salary Salary Position Title Allocation Allocation Salary Salary Director of Information Systems 1.00 1.00 $132,500 $132,500 Information Systems Manager 1.00 1.00 103,025 103,270 Senior Information Technology Analyst 3.00 3.00 258,750 258,750 Information Technology Analyst 1.00 1.00 68,540 68,545 TOTAL 6.00 6.00 $562,815 $563,065 TOTAL 0 0 $0 $0 Full Time Positions Part Time Positions 138 BUDGET UNIT: ALL FUND 48 DIVISIONS-INFORMATION TECH (SUMMARY) DESCRIPTION ACTUAL ACTUAL REVISED YEAR END EST ADOPTED VARIANCE Acct. #12-13 13-14 14-15 14-15 15-16 PERSONNEL 6003 Salaries/Regular 534,860 566,510 562,815 551,885 563,065 250 6033 Overtime Pay/Premium ---811 - - 6039 Salaries/Standby 125 --541 - - 6047 Sal/Bonus - 11,465 -- - - 6048 Salaries/Language Pay 2,520 3,631 3,600 3,520 3,600 - 6069 Allowances/Vehicle 4,900 4,582 5,400 4,450 5,400 - 6070 Allowances/Telephone ---- - - 6091 Leave Liability Adjustments 28,865 (86,034) -- - - 6101 PERS/Employee Contribution 37,715 40,056 40,055 39,020 40,000 (55) 6105 PERS/Employer Contribution 45,405 49,636 49,940 48,805 63,590 13,650 6109 PARS/Employer 15,085 17,489 15,310 21,075 28,845 13,535 6125 FICA/Employer Contrib/Med 8,235 9,328 9,700 8,900 9,700 - 6133 Retiree Health Premium Reimb - 1,450 -1,495 1,510 1,510 6140 Life Insurance Allocation 1,400 1,456 1,520 1,365 1,520 - 6155 Workers' Comp Allocation 21,500 23,264 22,870 22,255 22,880 10 6160 LTD Insurance Allocation 4,500 5,073 4,380 4,820 4,380 - 6165 Unemployment Allocation 510 564 665 510 665 - 6175 Benefits/Flex Plan 88,310 94,976 96,910 96,910 96,910 - 6180 Deferred Comp/Employer Paid 1,225 3,479 3,960 6,120 6,120 2,160 PERSONNEL SUBTOTAL 795,155 746,926 817,125 812,481 848,185 31,060 139 Budget Division: INFORMATION TECHNOLOGY - CITY INFORMATION SYSTEMS FY 14-15 FY 15-16 FY 14-15 FY 15-16 Revised Adopted Revised Adopted FY 14-15 FY 15-16 FY 14-15 FY 15-16 Revised Adopted Revised Adopted Position Title Allocation Allocation Salary Salary Position Title Allocation Allocation Salary Salary Director of Information Systems (a) 0.50 0.50 $66,250 $66,250 Information Systems Manager (b)0.35 0.35 36,060 36,145 Senior Information Technology Analyst(b)1.50 1.50 129,375 129,375 Information Technology Analyst(d)0.10 0.10 6,850 6,855 (a) .50 FTE-Light and Water Information Systems (b) .65 FTE-Light and Water Information Systems (c) 1.20 FTE-Light and Water Information Systems; 0.30 FTE-Sewer Information Systems (d) .90 FTE-Light and Water Information Systems TOTAL 2.45 2.45 $238,535 $238,625 TOTAL 0 0 $0 $0 Full Time Positions Part Time Positions 140 Budget Division: INFORMATION TECHNOLOGY - LIGHT & WATER INFORMATION SYSTEMS FY 14-15 FY 15-16 FY 14-15 FY 15-16 Revised Adopted Revised Adopted FY 14-15 FY 15-16 FY 14-15 FY 15-16 Revised Adopted Revised Adopted Position Title Allocation Allocation Salary Salary Position Title Allocation Allocation Salary Salary Director of Information Systems (a) 0.50 0.50 $66,250 $66,250 Information Systems Manager (b)0.65 0.65 66,965 $67,125 Senior Information Technology Analyst(b)1.20 1.20 103,700 103,700 Information Technology Analyst(d)0.90 0.90 61,690 61,690 (a) .50 FTE-City Information Systems (b) .35 FTE-City Information Systems (c) 1.50 FTE-City Information Systems; 0.30 FTE-Sewer Information Systems (d) .10 FTE-City Information Systems TOTAL 3.25 3.25 $298,605 $298,765 TOTAL 0 0 $0 $0 Full Time Positions Part Time Positions 141 Budget Division: INFORMATION TECHNOLOGY - SEWER INFORMATION SYSTEMS FY 14-15 FY 15-16 FY 14-15 FY 15-16 Revised Adopted Revised Adopted FY 14-15 FY 15-16 FY 14-15 FY 15-16 Revised Adopted Revised Adopted Position Title Allocation Allocation Salary Salary Position Title Allocation Allocation Salary Salary Senior Information Technology Analyst(a)0.30 0.30 $25,675 $25,675 (a) 0.50 FTE-City Information Systems; 0.20 FTE-Light and Water Information Systems TOTAL 0.30 0.30 $25,675 $25,675 TOTAL 0 0 $0 $0 Full Time Positions Part Time Positions 142 BUDGET UNIT:Fund 48 INFORMATION TECHNOLOGY (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED YEAR END EST ADOPTED Acct. #12-13 13-14 14-15 14-15 15-16 VARIANCE PERSONNEL CITY COMPUTER SERVICES 6003 Salaries/Regular 198,335 239,885 238,535 233,625 238,625 90 6033 Overtime Pay/Premium ---405 - - 6047 Sal/Bonus - 4,782 --- - 6048 Salaries/Language Pay 480 1,326 1,320 1,290 1,320 - 6069 Allowance/Vehicle 2,450 2,291 2,700 2,225 2,700 - 6091 Leave Liability Adjustments 12,790 (43,443) --- - 6101 PERS/Employee Contribution 13,940 16,944 16,995 16,500 16,965 (30) 6105 PERS/Employer Contribution 16,760 20,995 21,175 20,635 26,955 5,780 6109 PARS/Employer Contribution 5,245 7,591 6,510 9,415 12,880 6,370 6125 FICA/Employer Contrib/Med 3,040 3,931 4,090 3,735 4,090 - 6133 Retiree Health Prem - 1,450 -1,495 1,510 1,510 6140 Life Insurance Allocation 515 613 645 575 645 - 6155 Workers' Comp Allocation 7,955 9,839 9,700 9,415 9,705 5 6160 LTD Insurance Allocation 1,725 2,207 1,855 2,110 1,855 - 6165 Unemployment Allocation 190 239 280 215 280 - 6175 Benefits/Flex Plan 31,360 38,828 39,570 39,570 39,570 - 6180 Deferred Comp/Employer Paid 545 1,316 1,495 2,575 2,575 1,080 SUBTOTAL 295,330 308,795 344,870 344,055 359,675 14,805 LIGHT AND WATER INFORMATION SYSTEMS 6003 Salaries/Regular 336,525 300,263 298,605 292,870 298,765 160 6039 Standby Pay/Premium 125 --270 - - 6047 Sal/Bonus - 6,233 --- - 6048 Salaries/Language Pay 2,040 1,567 1,560 1,525 1,560 - 6069 Allowances/Vehicle 2,450 2,291 2,700 2,225 2,700 - 6091 Leave Liability Adjustments 16,075 (39,600) --- - 6101 PERS/Employee Contribution 23,775 21,208 21,185 20,685 21,165 (20) 6105 PERS/Employer Contribution 28,645 26,281 26,415 25,875 33,650 7,235 6109 PARS/Employer Contribution 9,840 9,898 8,800 11,660 15,965 7,165 6125 FICA/Employer Contrib/Med 5,195 4,988 5,155 4,770 5,155 - 6140 Life Insurance Allocation 885 772 805 725 805 - 6155 Workers' Comp Allocation 13,545 12,322 12,115 11,795 12,120 5 6160 LTD Insurance Allocation 2,775 2,664 2,325 2,515 2,325 - 6165 Unemployment Allocation 320 299 355 270 355 - 143 BUDGET UNIT:Fund 48 INFORMATION TECHNOLOGY (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED YEAR END EST ADOPTED Acct. #12-13 13-14 14-15 14-15 15-16 VARIANCE 6175 Benefits/Flex Plan 56,950 51,435 52,495 52,495 52,495 - 6180 Deferred Comp/Employer Paid 680 2,014 2,305 3,385 3,385 1,080 SUBTOTAL 499,825 402,636 434,820 431,470 450,445 15,625 SEWER INFORMATION SYSTEMS 6003 Salaries/Regular -26,363 25,675 25,390 25,675 - 6047 Sal/Bonus - 450 --- - 6048 Salaries/Language Pay -737 720 705 720 - 6063 Salaries/Jury Duty -732 --- - 6091 Leave Liability Adjustments - (2,991) --- - 6101 PERS/Employee Contribution -1,905 1,875 1,835 1,870 (5) 6105 PERS/Employer Contribution -2,360 2,350 2,295 2,985 635 6125 FICA/Employer Contrib/Med -409 455 395 455 - 6140 Life Insurance Allocation -71 70 65 70 - 6155 Workers' Comp Allocation -1,102 1,055 1,045 1,055 - 6160 LTD Insurance Allocation -202 200 195 200 - 6165 Unemployment Allocation -26 30 25 30 - 6175 Benefits/Flex Plan -4,713 4,845 4,845 4,845 - 6180 Deferred Comp/Employer Paid -148 160 160 160 - SUBTOTAL - 35,495 37,435 36,955 38,065 630 PERSONNEL SUBTOTAL 795,155 746,926 817,125 812,480 848,185 31,060 144 THIS PAGE INTENTIONALLY LEFT BLANK 145 Description 6220 Training Schools - Microsoft Training, Novell/Brainshare, ESRI 6235 Meetings/Conferences - SUGA, MISAC, Liebert Cassidy sessions, Women Leading Government, 6415 Computer Software Services - SunGard, SIRSI, ESRI, HDL, Civicplus, Granicus, HDL, ActiveNet, Envisionware 6493 Outside Services & Repairs - JD Briggs, Iron Mountain, SIRSI 6499 Contract Services - Matrix, SAS Access Control, Novell, HDL, Custom Signs Reader Board 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, Spenser Communications, Music on Hold, Mutare 6846 Computer Hardware Maintenance - Charter Fiber, Verizon T1x3, Cisco , Watchguard, Laser printer service, Hewlett Packard, Barracuda,Plotter support, Watchgard, Juno 6915 Utilities-Telephone - City phone expense, payphones, Charter WiFI, cell phones, aircards Account Number 4849XXXXXX INFORMATION TECHNOLOGY ACTIVITY DETAIL (SUMMARY) 146 BUDGET UNIT: ALL FUND 48 DIVISIONS-INFORMATION TECH (SUMMARY) DESCRIPTION ACTUAL ACTUAL REVISED YEAR END EST ADOPTED VARIANCE Acct. #12-13 13-14 14-15 14-15 15-16 OPERATIONS 6220 Training Schools 390 920 4,500 - 4,500 - 6230 Dues & Subscriptions 790 990 1,500 1,250 1,500 - 6235 Meetings & Conferences 3,070 634 4,500 200 4,200 (300) 6240 Mileage Reimbursement 70 150 400 400 400 - 6415 Computer Software Support 163,975 168,176 187,000 184,700 175,000 (12,000) 6493 Outside Services & Repairs 6,325 2,906 16,240 14,500 7,940 (8,300) 6499 Contract Services & Fees/Other 275 502 9,425 7,000 4,000 (5,425) 6504 Computer Software/Licensing 52,620 65,097 88,670 81,750 84,320 (4,350) 6521 Messenger Service 35 -100 - 100 - 6527 Supplies/Computer/Small Equipment 10,250 2,242 14,700 12,700 5,500 (9,200) 6530 Office Supplies 530 667 690 690 690 - 6563 Supplies/Special 1,765 1,007 2,000 2,000 2,000 - 6569 Small Equipment 7,205 6,708 16,300 10,300 12,800 (3,500) 6570 Computer Peripherals/Misc 16,245 10,370 18,000 18,000 15,000 (3,000) 6835 Maint & Repair/Equipment 40,613 35,905 79,200 50,000 35,000 (44,200) 6846 Computer Hardware Maint/Repair 52,490 59,974 60,985 60,985 55,250 (5,735) 6915 Utilities/Telephone 181,641 164,431 173,760 173,760 174,560 800 OPERATIONS SUBTOTAL 538,289 521,474 677,970 618,235 582,760 (95,210) INFORMATION TECH FUND TOTAL: 1,333,444 1,268,400 1,495,095 1,430,716 1,430,945 (64,150) 147 BUDGET UNIT:4849942000 LIGHT AND WATER INFORMATION SYSTEMS DESCRIPTION REVISED YEAR END EST ADOPTED Acct. #14-15 14-15 15-16 VARIANCE Explanation OPERATIONS 6405 Computer Software Licensing 25,050 25,050 27,620 2,570 E-Contract/Contract tracking system 148 BUDGET UNIT:4849942120 LIGHT AND WATER TECHNOLOGY FUND DESCRIPTION REVISED YEAR END EST ADOPTED Acct. #14-15 14-15 15-16 VARIANCE Explanation OPERATIONS 6915 Computer software licensing 5,000 5,000 5,800 800 Base on actual increase in cell phone equipment and service costs 149 BUDGET UNIT:4849944000 SEWER INFORMATION SYSTEM DESCRIPTION REVISED YEAR END EST ADOPTED Acct. #14-15 14-15 15-16 VARIANCE Explanation OPERATIONS 6415 Computer Software Support 2,300 - 3,000 700 Increase in software support for JUNO handheld and ESRI 6846 Computer Hardware Maint/Repair 500 500 800 300 Hardware support for JUNO handheld 150 Description City 6235 Meetings/Conferences - Liebert Cassidy sessions, Women Leading Government, MISAC 6415 Computer Software Services - SunGard, SIRSI, ESRI, HDL, Civicplus, Granicus, HDL 6493 Outside Services & Repairs - JD Briggs, Iron Mountain, SIRSI 6499 Contract Services - Matrix, SAS Access Control, Novell, HDL 6504 Computer Software Licensing - MS Office, PC Anywhere, Netware, McAfee, Adobe, Novell Patch Management, Zenworks, GroupWise, Solarwinds Orion,Digicert, Autocad, Miscropaver, AutoCAD, Public Contract Software Service 6846 Computer Hardware Maintenance - Laser printer services, Watchguard, Hewlett Packard, Cisco, Barracuda,Plotter support, Juno Account Number 4849930000 INFORMATION TECHNOLOGY ACTIVITY DETAIL 151 Description Communications Services 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 4849940000 INFORMATION TECHNOLOGY ACTIVITY DETAIL 152 Description Light and Water Information Systems 6220 Training Schools - Microsoft Training, Novell/Brainshare 6235 Meetings/Conferences - SNUG, MISAC, 6415 Computer Software Services - SunGard, SIRSI, ESRI, HDL, Civicplus, Granicus, HDL 6493 Outside Services & Repairs - JD Briggs, Iron Mountain 6504 Computer Software Licensing - MS Office, PC Anywhere, Netware, McAfee, Adobe, Novell Patch Management, Zenworks, GroupWise, Solarwinds Orion,Digicert,Verisign, Veritas, 6499 Contract Services - Matrix Consulting, SAS Access Control, HDL, Custom Signs 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 INFORMATION TECHNOLOGY ACTIVITY DETAIL 153 Description LW Technology Fund 6915 Utilities-Telephone - City Council phones and aircards-Verizon Wireless Account Number 4849942120 INFORMATION TECHNOLOGY ACTIVITY DETAIL 154 Description Sewer Information System 6415 Computer Software Services -Junno, ESRI 6504 Computer Software Licensing - Autodesk, AutoCAD 6846 Computer Hardware Maintenance - Charter Fiber, Verizon T1x3, Cisco , Watchguard, Laser printer service, Account Number 4849944000 INFORMATION TECHNOLOGY ACTIVITY DETAIL 155 BUDGET UNIT:Fund 48 INFORMATION TECHNOLOGY (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED YEAR END EST ADOPTED Acct. #12-13 13-14 14-15 14-15 15-16 VARIANCE OPERATIONS CITY COMPUTER SERVICES 6220 Training Schools -20 500 - 500 - 6230 Dues & Subscriptions 790 965 1,000 1,000 1,000 - 6235 Meetings & Conferences 150 696 500 200 200 (300) 6240 Mileage Reimbursement --200 200 200 - 6415 Computer Software Support 151,890 153,091 166,700 166,700 160,000 (6,700) 6493 Outside Services & Repairs 2,200 306 10,800 9,500 2,500 (8,300) 6499 Contract Services & Fees/Other 275 502 5,425 4,000 2,000 (3,425) 6504 Computer Software/Licensing 30,100 42,453 53,500 53,500 53,500 - 6527 Supplies/Computer/Small Equip 4,675 1,554 3,000 3,000 3,000 - 6530 Office Supplies 375 517 490 490 490 - 6563 Supplies/Special 1,555 1,007 1,500 1,500 1,500 - 6569 Small Equipment 2,210 3,421 3,300 3,300 3,300 - 6846 Computer Hardware Maint/Repair 13,690 18,371 24,035 24,035 18,000 (6,035) SUBTOTAL 207,910 222,905 270,950 267,425 246,190 (24,760) COMMUNICATION SERVICES 6415 Comp Sft Sppt - 2,953 --- - 6835 Maint & Repair/Equipment 40,613 35,905 79,200 50,000 35,000 (44,200) 6915 Utilities/Telephone 176,076 158,054 168,760 168,760 168,760 - SUBTOTAL 216,689 196,912 247,960 218,760 203,760 (44,200) 156 BUDGET UNIT:Fund 48 INFORMATION TECHNOLOGY (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED YEAR END EST ADOPTED Acct. #12-13 13-14 14-15 14-15 15-16 VARIANCE LIGHT AND WATER INFORMATION SYSTEMS 6220 Training Schools 390 900 4,000 -4,000 - 6230 Dues & Subscriptions -25 500 250 500 - 6235 Meetings & Conferences 2,920 (62)4,000 -4,000 - 6240 Mileage Reimbursement 70 150 200 200 200 - 6415 Computer Software Support 12,085 11,061 18,000 18,000 12,000 (6,000) 6493 Outside Services & Repairs 4,125 2,600 5,440 5,000 5,440 - 6499 Contract Services & Fees/Other --4,000 3,000 2,000 (2,000) 6504 Computer Software/Licensing 22,520 22,643 25,050 25,050 27,620 2,570 6521 Messenger Service 35 -100 -100 - 6527 Supplies/Computer/Small Equip 4,390 549 8,700 8,700 2,500 (6,200) 6530 Office Supplies 155 150 200 200 200 - 6563 Supplies/Special 210 -500 500 500 - 6569 Small Equipment -410 3,000 2,000 2,000 (1,000) 6570 Computer Peripherals/Misc 16,245 10,370 18,000 18,000 15,000 (3,000) 6572 Office Furn -794 --- - 6846 Computer Hardware Maint/Repair 38,800 41,454 36,450 36,450 36,450 - 6915 Utilities/Telephone -573 --- - SUBTOTAL 101,945 91,617 128,140 117,350 112,510 (15,630) LIGHT AND WATER TECHNOLOGY FUND - 6527 Supplies/Computer/Small Equip 1,185 139 3,000 1,000 - (3,000) 6569 Small Equipment 4,995 2,877 10,000 5,000 7,500 (2,500) 6915 Utilities/Telephone 5,565 5,804 5,000 5,000 5,800 800 SUBTOTAL 11,745 8,820 18,000 11,000 13,300 (4,700) SEWER INFORMATION SYSTEMS 6415 Computer Software Support -1,072 2,300 -3,000 700 6504 Computer Software/Licensing --10,120 3,200 3,200 (6,920) 6846 Computer Hardware Maint/Repair -149 500 500 800 300 SUBTOTAL -1,221 12,920 3,700 7,000 (5,920) OPERATIONS SUBTOTAL 538,289 521,474 677,970 618,235 582,760 (95,210) 157 BUDGET UNIT:Fund 48 INFORMATION TECHNOLOGY (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED YEAR END EST ADOPTED Acct. #12-13 13-14 14-15 14-15 15-16 VARIANCE TRANSFERS OUT 5950 Transfers Out -City -16,217 -12,840 - - 5950 Transfers Out -L&W -18,865 -15,840 - - 5950 Transfers Out -Sewer -1,015 -1,300 - - TRANSFSERS OUT SUBTOTAL -36,097 -29,980 -- INFORMATION TECH FUND TOTAL: 1,333,444 1,304,497 1,495,095 1,460,695 1,430,945 (64,150) 158