Okaloosa County BOCC — July 26, 2016 — Agenda Packet — reading text

Emerge auto-door lock system to a new Master node and controller.  Network infrastructure moved and rewired complexes and Old bethel RD and TDD.  Moved Human Resources, Risk Management and Purchasing staff to Old Bethel RD complex.  Extended BCC fiber network and VoIP to Guardian Ad Litem. Clients absorbed under County IT support.  Performed major upgrades at EM (WEBEOC), OCPLC (Symphony), and SAN enterprise applications, including Avocent, Support Central, and Sophos. Minor upgrades performed at OCPLC Envisionware products and Reservation consoles.  Implement interfaces for EMS and Fire Departments to receive data from 911 CAD for billing, vehicle locating, and call detail.  Implement EMS cardiac monitoring system collects 12 Lead data from ambulance devices via Wi-Fi, stores on server, to fax or email data to hospitals on request.  Replaced over 40 new Client PC’s and laptops including 911 workstations.  Prepare Head End connections by extending single mode to Clerk of Court network Equipment.  Assist Property Appraiser relocating servers and network out of North Head End to County Admin Bldg.  Replaced hardware for network monitoring software and upgraded application (What’s Up Gold).  Deployed new external DNS server.  Prepare for IT Risk assessment to be conducted through the end of May.  Hired a Security Specialist. Packet Pg. 90 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. Move all Operating Systems to the most current supported for security and performance. 3. Save communication dollars spent by BCC through extending fiber and VoIP to al feasible locations. 4. Reduce phone calls into helpdesk by utilizing Support Central’s application ticket submitting process. 5. Continue to replace legacy network infrastructure to keep up with current technology and security measures. 6. Keep all legacy hardware and software applications current with updates and patches. Replace as necessary. 7. Continue to train staff on all relevant technologies to ensure proper support of the infrastructure. PERFORMANCE MEASURES: Actual Estimated Proposed Performance Measures FY14/15 FY15/16 FY16/17 SAN Helpdesk Ticket Entries 6,839 6,614 7,000 Output SAN Logged Tech Hours per Day 6.7 6.7 7.0 Efficiency Avg. Duration Days of Help Desk Ticket .7 1 .6 Ratio of Helpdesk Tickets to SAN Staff 977 945 900 Effectiveness Percentage of Positive Survey Results 99.0 100 100 Percentage of Server Availability 99 100 100 Percentage of Network Availability 99.9 99 99.5 HISTORICAL STAFFING SUMMARY: Category FY14 FY15 FY16 FY17 Full-time Management & Professional 7 7 8 8 Total 7 7 8 8 EXPENDITURES: Expenditures Budget FY14 FY15 FY16 FY17 FY16/FY17 Increase/ Category Actual Actual Approved Proposed +/- Decrease Personnel Services $460,318 $473,503 $564,590 $556,115 ($8,475) (1.5%) Operating Expenses $124,228 $152,749 $331,959 $379,304 $47,345 14.3% Capital Outlay $164,690 $44,491 $70,000 $120,000 $50,000 71.4% Total $749,236 $670,743 $966,549 $1,055,419 $88,870 9.2% Packet Pg. 91 ACCOUNTS: FY15 FY16 FY17 FY16/FY17 Increase/ Code Category Approved Approved Proposed +/- Decrease 10 Salaries & Wages $379,738 $427,777 $441,058 $13,281 3.1% 20 Benefits $90,020 $136,813 $115,057 ($21,756) (15.9%) The decrease is driven by the healthcare elections/opt-out chosen by the employees. 31 Professional Services $20,000 $40,000 $20,000 ($20,000) (50.0%) Provides consulting services for installation of replacement fiber equipment. 40 Travel & Per Diem $1,500 $1,500 $1,200 ($300) (20.0%) 41 Communications Services $4,400 $5,800 $4,800 ($1,000) (17.2%) Reduction is based on current usage trend. 42 Freight & Postage $100 $100 $100 $0 0.0% 44 Rent & Leases $0 $0 $0 $0 0.0% 45 Risk Management Allocation $8,115 $7,703 $7,986 $283 3.7% 46 Repair & Maintenance $249,528 $242,581 $256,435 $13,854 5.7% Provides additional funding for licenses and maintenance of software. 47 Printing & Binding $50 $50 $50 $0 0.0% 49 Miscellaneous Charges $950 $950 $450 ($500) (52.6%) 51 Office Supplies $1,200 $1,200 $1,200 $0 0.0% 52 Operating Supplies $9,016 $29,175 $84,183 $55,008 188.5% Increase is for computer and battery back-up replacements as well as software. 54 Books/Pubs/Subs & Memberships $300 $300 $300 $0 0.0% 55 Training & Education Expenses $2,600 $2,600 $2,600 $0 0.0% 60 Capital Outlay $85,000 $70,000 $120,000 $50,000 71.4% Funding is for fiber equipment replacement and EOC backup network connection firewall. TOTAL $852,517 $966,549 $1,055,419 $88,870 9.2% Packet Pg. 92  BOARD OF COUNTY COMMISSIONERS AGENDA REQUEST DATE: July 26, 2016 TO: Honorable Chairman and Members of the Board FROM: John Hofstad, County Administrator SUBJECT: Applications Administration The attached Applications Administration performance based budget documents Packet Pg. 93  BOARD OF COUNTY COMMISSIONERS OKALOOSA COUNTY, FLORIDA SERVICE AREA: GENERAL GOVERNMENT DEPARTMENT/PROGRAM: INFORMATION TECHNOLOGY/APPLICATIONS & ADMINISTRATION PROGRAM DESCRIPTION: The mission of the Information Systems Department is to create and maintain an information infrastructure that emphasizes data sharing among departments and integrated County computing and network resources as a single enterprise. The Applications Division is the link between the business requirements and technology solutions for application system needs. 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 LAST YEAR:  Human Resources: Implemented Software changes to the Human Resources App. To allow Administrative Personnel to selectively convert BCC Employees Standard Enrolled Training Courses to the New Training Zone Enrolled Courses.  Risk Management: Provided Software Support by implementing additional features to the Risk Manager App. to programmatically capture Monthly insurance data to aid in the creating of the 1095C IRS forms.  Public Works: Implemented Software changes to the Tool Application to Aid in the functionality of the receiving feature of the Application.  Upgraded W&S, Brackin, and Airport Mitel 3300 to a new system.  Reused the old 3300 Mitel system to install in the new County Administration Building.  Served on the Election committee for the acquisition of the new voting equipment. PROGRAM GOAL: The purpose of the Information Systems Department is to provide and maintain an organized, shared information infrastructure that enables the County to share data, services, and reduce duplication of effort. The management of technology and data in a coherent, organized County-wide effort is necessary to insure limited money, resources, and time are wisely allocated and efficiently utilized to provide effective, efficient government in Okaloosa County. KEY OBJECTIVES: 1. Continue to evaluate and leverage more effective and efficient technologies. 2. Monitor and assess future needs for enhanced data management capability through use of computerized information systems. 3. Ensure budgetary, personnel and purchasing functions comply with County policies and procedures. 4. Provide effective and thorough review of all annual department goals. 5. Provide effective response to County Administrator and County Commission needs and requests. Packet Pg. 94 PERFORMANCE MEASURES: Actual Estimated Proposed Performance Measures FY14/15 FY15/16 FY16/17