Loading...
HomeMy WebLinkAbout08. IT-FY1415_1_201409081105524301INFORMATION TECHNOLOGY City Information Systems  Light and Water  Information Systems Sewer Information Systems  131 THIS PAGE INTENTIONALLY LEFT BLANK 132 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. Also, ongoing equipment replacement, helpdesk function, internet, e-mail, and web sites, wireless, the fiber backbone and network infrastructure on which all systems reside. STRATEGIC GOALS:  Maintain computer network uptime at 99%.  Ensure the integrity of the network, security, traffic and segmentation.  Upgrade and replacement of legacy infrastructure hardware FY 2014-15 PROGRAM HIGHLIGHTS:  Upgrade of Financial System  Integration of GIS mapping with CAD Police system 133 Budget Division: INFORMATION TECHNOLOGY (SUMMARY) FY 13-14 FY 14-15 FY 13-14 FY 14-15 Revised Adopted Revised Adopted FY 13-14 FY 14-15 FY 13-14 FY 14-15 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,025 Senior Information Technology Analyst 3.00 3.00 258,750 258,750 Information Technology Analyst 1.00 1.00 68,540 68,540 TOTAL 6.00 6.00 $562,815 $562,815 TOTAL 0 0 $0 $0 Full Time Positions Part Time Positions 134 BUDGET UNIT: ALL FUND 48 DIVISIONS-INFORMATION TECH (SUMMARY) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #11-12 12-13 13-14 14-15 PERSONNEL 6003 Salaries/Regular 512,735 488,405 562,815 562,815 - 6006 Salaries/Temp & Part-Time 3,395 -- - - 6012 Salaries/Comp-Time 805 300 - - - 6015 Salaries/Vacation 35,540 26,510 - - - 6024 Salaries/Sick Leave 15,915 17,910 - - - 6027 Salaries/Bereavement - 410 - - - 6033 Overtime Pay/Premium 2,680 -- - - 6039 Salaries/Standby 1,200 250 1,000 - (1,000) 6048 Salaries/Language Pay 3,300 2,520 3,600 3,600 - 6063 Salaries/Jury Duty -1,325 - - - 6066 Allowances/Uniform 150 150 - - - 6069 Allowances/Vehicle 4,050 4,900 5,400 5,400 - 6091 Leave Liability Adjustments 5,815 28,865 - - - 6101 PERS/Employee Contribution 39,505 37,715 40,055 40,055 - 6105 PERS/Employer Contribution 73,790 45,405 49,350 49,940 590 6109 PARS/Employer 12,495 15,085 15,310 15,310 - 6125 FICA/Employer Contrib/Med 8,250 8,235 9,645 9,700 55 6140 Life Insurance Allocation 1,495 1,400 1,520 1,520 - 6155 W orkers' Comp Allocation 22,980 21,500 22,870 22,870 - 6160 LTD Insurance Allocation 4,545 4,500 4,380 4,380 - 6165 Unemployment Allocation 585 510 665 665 - 6175 Benefits/Flex Plan 98,215 88,310 93,370 96,910 3,540 6180 Deferred Comp/Employer Paid 6,000 1,225 3,960 3,960 - PERSONNEL SUBTOTAL 853,445 795,430 813,940 817,125 3,185 135 Budget Division: INFORMATION TECHNOLOGY - CITY INFORMATION SYSTEMS FY 13-14 FY 14-15 FY 13-14 FY 14-15 Revised Adopted Revised Adopted FY 13-14 FY 14-15 FY 13-14 FY 14-15 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,060 Senior Information Technology Analyst(b)1.50 1.50 129,375 129,375 Information Technology Analyst(d)0.10 0.10 6,850 6,850 (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,535 TOTAL 0 0 $0 $0 Full Time Positions Part Time Positions 136 Budget Division: INFORMATION TECHNOLOGY - LIGHT & WATER INFORMATION SYSTEMS FY 13-14 FY 14-15 FY 13-14 FY 14-15 Revised Adopted Revised Adopted FY 13-14 FY 14-15 FY 13-14 FY 14-15 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 $66,965 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,605 TOTAL 0 0 $0 $0 Full Time Positions Part Time Positions 137 Budget Division: INFORMATION TECHNOLOGY - SEWER INFORMATION SYSTEMS FY 13-14 FY 14-15 FY 13-14 FY 14-15 Revised Adopted Revised Adopted FY 13-14 FY 14-15 FY 13-14 FY 14-15 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 138 BUDGET UNIT:Fund 48 INFORMATION TECHNOLOGY (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED Acct. #11-12 12-13 13-14 14-15 VARIANCE PERSONNEL CITY COMPUTER SERVICES 6003 Salaries/Regular 263,280 181,330 238,535 238,535 - 6006 Salaries/Temp & Part-Time 3,395 --- - 6012 Salaries/Comp-Time 665 130 -- - 6015 Salaries/Vacation 19,705 10,530 -- - 6024 Salaries/Sick Leave 9,980 5,775 -- - 6027 Salaries/Bereavement -205 -- - 6033 Overtime Pay/Premium 1,735 --- - 6039 Standby Pay/Premium 800 125 -- - 6048 Salaries/Language Pay 2,100 480 1,320 1,320 - 6063 Salaries/Jury Duty -365 -- - 6069 Allowance/Vehicle 2,700 2,450 2,700 2,700 - 6091 Leave Liability Adjustments 5,815 12,790 -- - 6101 PERS/Employee Contribution 20,765 13,940 16,995 16,995 - 6105 PERS/Employer Contribution 39,120 16,760 20,915 21,175 260 6109 PARS/Employer Contribution 4,680 5,245 6,510 6,510 - 6125 FICA/Employer Contrib/Med 3,910 3,040 4,070 4,090 20 6140 Life Insurance Allocation 775 515 645 645 - 6155 Workers' Comp Allocation 12,040 7,955 9,700 9,700 - 6160 LTD Insurance Allocation 2,405 1,725 1,855 1,855 - 6165 Unemployment Allocation 310 190 280 280 - 6175 Benefits/Flex Plan 51,505 31,360 38,190 39,570 1,380 6180 Deferred Comp/Employer Paid 2,905 545 1,495 1,495 - SUBTOTAL 448,590 295,455 343,210 344,870 1,660 LIGHT AND WATER INFORMATION SYSTEMS 6003 Salaries/Regular 249,455 307,075 298,605 298,605 - 6012 Salaries/Comp-Time 140 170 -- - 6015 Salaries/Vacation 15,835 15,980 -- - 6024 Salaries/Sick Leave 5,935 12,135 -- - 6027 Salaries/Bereavement - 205 -- - 6033 Overtime Pay/Premium 945 --- - 6039 Standby Pay/Premium 400 125 1,000 - (1,000) 6048 Salaries/Language Pay 1,200 2,040 1,560 1,560 - 139 THIS PAGE INTENTIONALLY LEFT BLANK 140 BUDGET UNIT:Fund 48 INFORMATION TECHNOLOGY (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED Acct. #11-12 12-13 13-14 14-15 VARIANCE 6063 Salaries/Jury Duty -960 -- - 6066 Allowances/Uniform 150 150 -- - 6069 Allowances/Vehicle 1,350 2,450 2,700 2,700 - 6091 Leave Liability Adjustments - 16,075 -- - 6101 PERS/Employee Contribution 18,740 23,775 21,185 21,185 - 6105 PERS/Employer Contribution 34,670 28,645 26,125 26,415 290 6109 PARS/Employer Contribution 7,815 9,840 8,800 8,800 - 6125 FICA/Employer Contrib/Med 4,340 5,195 5,125 5,155 30 6140 Life Insurance Allocation 720 885 805 805 - 6155 Workers' Comp Allocation 10,940 13,545 12,115 12,115 - 6160 LTD Insurance Allocation 2,140 2,775 2,325 2,325 - 6165 Unemployment Allocation 275 320 355 355 - 6175 Benefits/Flex Plan 46,710 56,950 50,545 52,495 1,950 6180 Deferred Comp/Employer Paid 3,095 680 2,305 2,305 - SUBTOTAL 404,855 499,975 433,550 434,820 1,270 SEWER INFORMATION SYSTEMS 6003 Salaries/Regular --25,675 25,675 - 6048 Salaries/Language Pay --720 720 - 6101 PERS/Employee Contribution --1,875 1,875 - 6105 PERS/Employer Contribution --2,310 2,350 40 6125 FICA/Employer Contrib/Med --450 455 5 6140 Life Insurance Allocation --70 70 - 6155 Workers' Comp Allocation --1,055 1,055 - 6160 LTD Insurance Allocation --200 200 - 6165 Unemployment Allocation --30 30 - 6175 Benefits/Flex Plan --4,635 4,845 210 6180 Deferred Comp/Employer Paid --160 160 - SUBTOTAL - -37,180 37,435 255 PERSONNEL SUBTOTAL 853,445 795,430 813,940 817,125 3,185 141 Cost 4849XXXXXX 6220 $4,500 6235 $4,500 6415 187,000 6493 $16,240 6499 Contract Services - Matrix, SAS Access Control, Novell, HDL $9,425 6504 $88,670 6570 $18,000 6835 $79,200 6846 $60,985 6915 Utilities-Telephone - City phone expense, Verizon T1x3, Charter fiber, cell phones, aircards $173,760 Computer Hardware Maintenance - Charter Fiber, Verizon T1x3, Cisco , Watchguard, Laser printer service, Hewlett Packard, Barracuda,Plotter support DescriptionAccount Number Maintenance & Repair/Equipment - Avaya support, Spenser Communications, Music on Hold, Mutare Training Schools - Microsoft Training, Novell/Brainshare Meetings/Conferences - SNUG, MISAC, Liebert Cassidy sessions, Women Leading Government, MISAC Computer Software Services - SunGard, SIRSI, ESRI, HDL, Civicplus, Granicus, HDL Outside Services & Repairs - JD Briggs, Iron Mountain, SIRSI Computer Software Licensing - MS Office, PC Anywhere, Netware, McAfee, Adobe, Novell Patch Management, Zenworks, GroupWise, Solarwinds Orion,Digicert,Verisign, Veritas, Miscropaver, AutoCAD Computer Hardware Peripherals - GovConnection, CDW-G, PC Mall Light and Water Information Systems INFORMATION TECHNOLOGY ACTIVITY DETAIL (SUMMARY) 142 BUDGET UNIT: ALL FUND 48 DIVISIONS-INFORMATION TECH (SUMMARY) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #11-12 12-13 13-14 14-15 OPERATIONS 6220 Training Schools 6,350 390 4,000 4,500 500 6230 Dues & Subscriptions 1,150 790 1,500 1,500 - 6235 Meetings & Conferences 470 3,070 4,500 4,500 - 6240 Mileage Reimbursement 105 70 400 400 - 6415 Computer Software Support 175,980 163,975 195,700 187,000 (8,700) 6493 Outside Services & Repairs 4,465 6,325 16,240 16,240 - 6499 Contract Services & Fees/Other 2,010 275 9,425 9,425 - 6504 Computer Software/Licensing 52,630 53,515 78,900 88,670 9,770 6521 Messenger Service 50 35 100 100 - 6527 Supplies/Computer/Small Equipment 6,175 10,250 14,700 14,700 - 6530 Office Supplies 690 530 850 690 (160) 6563 Supplies/Special 1,870 1,765 2,000 2,000 - 6569 Small Equipment 8,715 7,205 31,835 16,300 (15,535) 6570 Computer Peripherals/Misc 15,770 16,245 18,000 18,000 - 6835 Maint & Repair/Equipment 40,640 40,788 79,200 79,200 - 6846 Computer Hardware Maint/Repair 57,310 56,690 65,180 60,985 (4,195) 6915 Utilities/Telephone 164,830 181,641 149,760 173,760 24,000 OPERATIONS SUBTOTAL 539,210 543,559 672,290 677,970 5,680 INFORMATION TECH FUND TOTAL: 1,392,655 1,338,989 1,486,230 1,495,095 8,865 Funding: ALLOCATION FROM L&W FUND (506,705) (614,560) (595,225) (580,960) (14,265) ALLOCATION FROM SEWER FUND --(42,160) (50,355) 8,195 ALLOCATION FROM GENERAL FUND (885,950) (724,429) (848,845) (863,780) 14,935 Total Funding (1,392,655) (1,338,989) (1,486,230) (1,495,095) 8,865 143 Cost 4849930000 6235 $500 6415 $166,700 6493 $10,800 6499 Contract Services - Matrix, SAS Access Control, Novell, HDL $5,425 6504 $53,500 6846 $24,035 Cost 4849940000 6835 $79,200 6915 Utilities-Telephone - City phone expense, Verizon T1x3, Charter fiber, cell phones, aircards $168,760 Cost 4849942000 6220 $4,500 6235 $4,000 6415 $18,000 6493 $5,440 6504 $25,050 6499 Contract Services - Matrix Consulting, SAS Access Control, HDL, Custom Signs $4,000 6570 $18,000 6846 $36,450 Computer Software Services - SunGard, SIRSI, ESRI, HDL, Civicplus, Granicus, HDL Outside Services & Repairs - JD Briggs, Iron Mountain Meetings/Conferences - SNUG, MISAC, INFORMATION TECHNOLOGY ACTIVITY DETAIL Account Number Description City Computer Hardware Peripherals - GovConnection, CDW-G, PC Mall Account Number Communications Services Description Maintenance & Repair/Equipment - Avaya support, Spenser Communications, Music on Hold, Mutare Account Number Description Light and Water Information Systems Computer Hardware Maintenance - Laser printer services, Watchguard, Hewlett Packard, Cisco, Barracuda,Plotter support Meetings/Conferences - Liebert Cassidy sessions, Women Leading Government, MISAC Computer Software Services - SunGard, SIRSI, ESRI, HDL, Civicplus, Granicus, HDL Computer Software Licensing - MS Office, PC Anywhere, Netware, McAfee, Adobe, Novell Patch Management, Zenworks, GroupWise, Solarwinds Orion,Digicert, Autocad, Miscropaver, AutoCAD Outside Services & Repairs - JD Briggs, Iron Mountain, SIRSI Training Schools - Microsoft Training, Novell/Brainshare Computer Hardware Maintenance - Charter Fiber, Verizon T1x3, Cisco , Watchguard, Laser printer service, Hewlett Packard Computer Software Licensing - MS Office, PC Anywhere, Netware, McAfee, Adobe, Novell Patch Management, Zenworks, GroupWise, Solarwinds Orion,Digicert,Verisign, Veritas, 144 INFORMATION TECHNOLOGY ACTIVITY DETAIL Cost 4849942120 6915 $5,000 Cost 4849944000 6415 $2,300 6504 $10,120 6846 $500 Account Number Description Account Number Description LW Technology Fund Utilities-Telephone - City Council phones and aircards-Verizon Wireless Sewer Information System Computer Software Licensing - Autodesk, AutoCAD Computer Software Services -Junno, ESRI Computer Hardware Maintenance - Charter Fiber, Verizon T1x3, Cisco , Watchguard, Laser printer service, 145 BUDGET UNIT:Fund 48 INFORMATION TECHNOLOGY (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED Acct. #11-12 12-13 13-14 14-15 VARIANCE OPERATIONS CITY COMPUTER SERVICES 6220 Training Schools 4,690 --500 500 6230 Dues & Subscriptions 1,150 790 1,000 1,000 - 6235 Meetings & Conferences 470 150 500 500 - 6240 Mileage Reimbursement --200 200 - 6415 Computer Software Support 157,085 151,890 172,865 166,700 (6,165) 6493 Outside Services & Repairs 1,130 2,200 10,800 10,800 - 6499 Contract Services & Fees/Other 1,330 275 5,425 5,425 - 6504 Computer Software/Licensing 30,965 30,100 53,850 53,500 (350) 6527 Supplies/Computer/Small Equip 2,435 4,675 3,000 3,000 - 6530 Office Supplies 480 375 650 490 (160) 6563 Supplies/Special 1,430 1,555 1,500 1,500 - 6569 Small Equipment 3,350 2,210 3,300 3,300 - 6835 Maint & Repair/Equipment -175 -- - 6846 Computer Hardware Maint/Repair 23,395 13,690 24,385 24,035 (350) 6915 Utilities/Telephone 340 --- - SUBTOTAL 228,250 208,085 277,475 270,950 (6,525) BROADBAND - LIBRARY 6846 Computer Hardware Maint/Repair 3,780 4,200 4,200 - (4,200) SUBTOTAL 3,780 4,200 4,200 - (4,200) COMMUNICATION SERVICES 6493 Outside Services & Repairs 200 --- - 6835 Maint & Repair/Equipment 40,640 40,613 79,200 79,200 - 6915 Utilities/Telephone 164,490 176,076 144,760 168,760 24,000 SUBTOTAL 205,330 216,689 223,960 247,960 24,000 146 BUDGET UNIT:Fund 48 INFORMATION TECHNOLOGY (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED Acct. #11-12 12-13 13-14 14-15 VARIANCE LIGHT AND WATER INFORMATION SYSTEMS 6220 Training Schools 1,660 390 4,000 4,000 - 6230 Dues & Subscriptions --500 500 - 6235 Meetings & Conferences -2,920 4,000 4,000 - 6240 Mileage Reimbursement 105 70 200 200 - 6415 Computer Software Support 18,895 12,085 18,000 18,000 - 6493 Outside Services & Repairs 3,135 4,125 5,440 5,440 - 6499 Contract Services & Fees/Other 680 -4,000 4,000 - 6504 Computer Software/Licensing 21,665 22,520 25,050 25,050 - 6521 Messenger Service 50 35 100 100 - 6527 Supplies/Computer/Small Equip 2,635 4,390 8,700 8,700 - 6530 Office Supplies 210 155 200 200 - 6563 Supplies/Special 440 210 500 500 - 6569 Small Equipment 2,470 -18,535 3,000 (15,535) 6570 Computer Peripherals/Misc 15,770 16,245 18,000 18,000 - 6846 Computer Hardware Maint/Repair 30,135 38,800 36,450 36,450 - SUBTOTAL 97,850 101,945 143,675 128,140 (15,535) LIGHT AND WATER TECHNOLOGY FUND - 6504 Computer Software/Licensi - 895 -- 6527 Supplies/Computer/Small Equip 1,105 1,185 3,000 3,000 - 6569 Small Equipment 2,895 4,995 10,000 10,000 - 6915 Utilities/Telephone -5,565 5,000 5,000 - SUBTOTAL 4,000 12,640 18,000 18,000 - SEWER INFORMATION SYSTEMS 6415 Computer Software Support --4,835 2,300 (2,535) 6504 Computer Software/Licensing - --10,120 10,120 6846 Computer Hardware Maint/Repair - -145 500 355 SUBTOTAL - -4,980 12,920 7,940 OPERATIONS SUBTOTAL 539,210 543,559 672,290 677,970 5,680 147 BUDGET UNIT:Fund 48 INFORMATION TECHNOLOGY (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED Acct. #11-12 12-13 13-14 14-15 VARIANCE INFORMATION TECH FUND TOTAL: 1,392,655 1,338,989 1,486,230 1,495,095 8,865 Funding: ALLOCATION FROM L&W FUND (506,705) (614,560) (595,225) (580,960) 14,265 ALLOCATION FROM SEWER FUND --(42,160) (50,355) (8,195) ALLOCATION FROM GENERAL FUND (885,950) (724,429) (848,845) (863,780) (14,935) Total Funding (1,392,655) (1,338,989) (1,486,230) (1,495,095) (8,865) 148