Okaloosa County BOCC — July 28, 2015 — Agenda Packet — reading text

7 Full-time Operations & Trades 2 2 2 2 Total 9 9 9 9 EXPENDITURES: Expenditures Budget FY13 FY14 FY15 FY16 FY15/FY16 Increase/ Category Actual Actual Approved Proposed +/- Decrease Personnel Services $483,989 $512,401 $592,853 $647,865 $55,012 9.39% Operating Expenses $114,229 $137,194 $95,497 $203,681 $108,184 113.3% Capital Outlay $14,954 $31,797 $50,000 $25,000 -$25,000 -50.0% Debt Service $0 $0 $0 $0 $0 0% Grants & Aids $0 $0 $0 $0 $0 0% Other Uses $0 $0 $0 $0 $0 0% Total $613,172 $681,392 $738,350 $876,546 $138,196 18.7% ACCOUNTS: FY14 FY15 FY16 FY15/FY16 Increase/ Code Category Approved Approved Proposed +/- Decrease 10 SALARIES & WAGES $415,440 $459,603 $492,567 $32,964 7.2% Filled previously advertised and vacant positions 20 BENEFITS $120,733 $133,250 $161,361 $28,111 21.1% Increase due to all employees on County Health Insurance 34 CONTRACT SERVICES $1,000 $1,000 $86,000 $85,000 8500.0% 2015-16 State-mandated photo project (3 year cycle) 40 TRAVEL & PER DIEM $2,500 $4,250 $4,500 $250 5.9% 41 COMMUNICATIONS SERVICES $7,500 $7,000 $7,000 $0 0% 42 FREIGHT & POSTAGE $150 $150 $200 $50 33.3% 44 RENTS & LEASES $1,000 $1,500 $1,500 $0 0% 45 RISK MANAGEMENT ALLOCATION $6,265 $7,003 $6,090 -$913 -13.0% 46 REPAIR & MAINTENANCE $53,164 $50,528 $52,156 $1,628 3.2% Computer equipment replacement (ESRI, plotter); software upgrades 47 PRINTING & BINDING $200 $200 $200 $0 0% 49 MISCELLANEOUS CHARGES $0 $950 $0 -$950 -100.0% 51 OFFICE SUPPLIES $1,000 $1,500 $2,500 $1,000 66.7% Furniture additions for relocation to new Administrative Building 52 OPERATING SUPPLIES $14,885 $17,416 $21,535 $4,119 23.7% Backup devices, external hard drives, Web GIS plugins, SQL Server virtualization 54 BOOKS/PUBS/SUBS & MEMBERSHIPS $500 $500 $500 $0 0% 55 TRAINING & EDUCATION EXPENSES $4,000 $3,500 $4,000 $500 14.3% 60 CAPITAL OUTLAY $30,000 $50,000 $0 -$50,000 -100.0% Packet Pg. 54 Single vehicle replacement for telecom field operations TOTAL $658,337 $738,350 $840,109 $101,759 13.8% Packet Pg. 55  BOARD OF COUNTY COMMISSIONERS OKALOOSA COUNTY, FLORIDA SERVICE AREA: GENERAL GOVERNMENT DEPARTMENT/PROGRAM: INFORMATION SYSTEMS/ SYSTEMS & NETWORKS PROGRAM DESCRIPTION: The Systems and Networks Division maintains technical communication architecture utilizing the County Fiber Wide area network and local area networks to ensure proper functioning of network topology and routers. This Division also configures and maintains the County Internet and Intranet/Email servers, while supporting over 90 servers and 800 clients that continually access various applications. REVENUE: Information Systems is funded within the General Fund. Supporting revenue of the General Fund are ad valorem taxes, state shared revenue, licenses, permits, charges for services, interest, other miscellaneous revenue and transfers from other funds. MAJOR ACCOMPLISHMENTS THIS PAST YEAR: Ø Expanded and upgraded the current VMWare cluster to include 2 new hosts for growth and redundancy. Ø Replaced and upgraded approx. 30 servers to Windows 2008 or above by physical or virtual means. Ø Expanded and Upgraded CWP’s 911 platform. Shut down all PSAP connections from Century Link. Ø Replaced BCC and OCPLC firewalls and Barracuda appliances. Ø Live on new Backup and Disaster Recovery disk platform system. Ø Extended fiber network and VoIP to Elder Services, OCT, Guardian Ad Litem, and remote OCSO locations. Ø Performed major upgrades at OCPLC, Fleet Operations, ECCC and SAN enterprise applications, including Blackberry, Support Central, Sophos and MSSQL 2012. Ø Upgrade Exchange email and Microsoft Office scheduled for summer. PROGRAM GOAL: Provide a secure, reliable network along with skilled, competent, professional and courteous technical support to all Okaloosa County network and application users enabling BCC employees and partners to better serve the citizens of Okaloosa County through efficient technical initiatives. KEY OBJECTIVES: 1. Put in place formal IT security measures and perform audits and tests to ensure the BCC network integrity. 2. Save communication dollars spent by BCC through utilizing fiber and VoIP. 3. Continue to replace aging network infrastructure to keep up with current technology. 4. Keep all legacy hardware and software applications current with updates and patches. Replace as necessary. 5. Continue to train staff on all relevant technologies to ensure proper support of the infrastructure. Packet Pg. 56 PERFORMANCE MEASURES: Actual Estimated Adopted Performance Measures FY13/14 FY14/15 FY15/16 Full Time Personnel 7 7 8 Input Total Operating expenditures 821,278.00 858,757.00 991,258.00 SAN Helpdesk Ticket Entries 7,129 6,584 7,000 Output SAN Logged Tech Hours per Day 7.05 6.6 7 Avg. Duration Days of Help Desk Ticket 1 .6 .5 Efficiency Ratio of Helpdesk Tickets to SAN Staff 1,188 1,097 1,160 Effectiveness Percentage of Positive Survey Results 98.0 99.0 100 Percentage of Server Availability 98.0 98 100 Percentage of Network Availability 99.3 99.9 99 HISTORICAL STAFFING SUMMARY: Category FY13 FY14 FY15 FY16 Full-time Management & Professional 7 7 7 8 Total 7 7 7 8 EXPENDITURES: Expenditures Budget FY13 FY14 FY15 FY16 FY15/FY16 Increase/ Category Actual Actual Original Approved +/- Decrease Personnel Services $450,635 $460,318 $469,758 $564,927 $95,169 20.3% Operating Expenses $70,658 $124,227 $297,759 $331,959 $34,200 11.5% Capital Outlay $1,077 $164,690 $85,000 $70,000 -$15,000 -17.6% Debt Service $0 $0 $0 $0 $0 0% Grants & Aids $0 $0 $0 $0 $0 0% Other Uses $0 $0 $0 $0 $0 0% Total $522,371 $749,236 $852,517 $966,886 $114,369 13.4% Packet Pg. 57 ACCOUNTS: FY14 FY15 FY16 FY15/FY16 Increase/ Code Category Approved Approved Approved +/- Decrease 10 SALARIES & WAGES $375,769 $379,738 $428,069 $48,331 12.7% Add Security Analyst position 20 BENEFITS $88,150 $90,020 $136,858 $46,838 52.0% Increase due to all employees on County Health Insurance 31 PROFESSIONAL SERVICES $5,000 $20,000 $40,000 $20,000 100.0% Security consultant; IT audits 40 TRAVEL & PER DIEM $1,500 $1,500 $1,500 $0 0% 41 COMMUNICATIONS SERVICES $4,400 $4,400 $5,800 $1,400 31.8% Replacement cellular phones and accessories as required 42 FREIGHT & POSTAGE $100 $100 $100 $0 0% 45