Biennial Budget October 2, 2018 Presented by Thomas Fichtner IT - PowerPoint PPT Presentation

2019/20 Proposed Biennial Budget October 2, 2018 Presented by Thomas Fichtner IT Manager

Organizational Overview Thom as Fichtner IT M anager B rian P earso n Jason D an ielle Erik E arle Stacey C urry IT Sup erviso r IT A rchitect IT A nalyst IT Technician 2 System s & H elpdesk W eb, A pp Security G IS G IS VA C A NT Xiao G u o IT A nalyst IT Technician 2 System s U ser Support 7.0 FTE

Regional Representation • Valley Communications • SCORE • C3 (Community Connectivity Consortium) • Safe City • ACCIS

2017/2018 Accomplishments • Completed Washington State Patrol CJIS Triennial Audit • Annual replacement of major hardware • Replace the server room battery backup/UPS • Police Spillman (Records Management System) Server upgrade • Upgraded the City’s Laserfiche Document Management System

2017/2018 Accomplishments Cont. • Improved JustWare Case Management System • Upgraded the City’s ArcGIS system from 9.3 to 10.6.1; added a new GIS public portal • Enhanced public WiFi system: FWWireless • Setup all IT systems for PAEC • Website and E-Newsletter improvements

2017/2018 Accomplishments Cont. • Digital display boards at the Community Center, Dumas Bay, and Municipal Court • RecTrac Implementation for Parks Department • Implemented Mimecast spam & email archiving system • Completion of IVR system upgrade

2017/2018 Accomplishments Cont. • Community Center AV upgrade • Dedicated one FTE for CD’s LEAN process • Implement BlueBeam Plan Review • GIS fiber mapping for Public Works • Safe City upgrade

2017/2018 Accomplishments Cont. • Equipment surplus (1,660 sq. ft.)

Budget Highlights & Changes Item 2018 2019 2020 19 Prop./18 Adj. Adjusted Proposed Proposed $ - Change (108,444) 1 Salaries & Wages $750,872 $642,428 $653,613 Benefits $257,776 $229,706 $233,955 (28,070) Supplies $66,056 $66,056 $66,056 - 20,000 Services & Charges $837,530 $857,530 $837,530 Intergovermental $134,278 $134,278 $134,278 - Capital Outlay $574,711 $451,323 $375,851 (123,388) Internal Services $33,427 - - (33,427) Total Expenditures $2,654,650 $2,381,321 $2,301,283 (273,329) 1 Salary & wage reduction in 1.5 FTE that was never hired in 2018

Funded New Program Requests • 2019 • 2020 – $451,323 (capital) – $375,851 (capital) • Desktop & laptop PCs • Desktop & laptop PCs • Printers, copiers • Printers, copiers & scanners • Police radios • Police • Server, storage & – Radios backup system – Vehicle routers – $20,000 – TotalStation • Security audit – SECTOR equipment

Unfunded Needs - Staffing Program 2019 2020 1 FTE - IT Helpdesk Technician 84,548 88,351 1 FTE - IT Application Analyst 100,472 104,992 1 FTE - IT Systems Analyst 100,472 104,992 1 FTE - IT Admin Assistant 59,794 62,483 Temporary Help 70,200 70,200 Total 415,487 431,019

Federal Way Historical IT Staffing Levels IT Staffing Level 12 10.6 10 9.6 10 9 8.5 8 7 7 7 7 7 6 6 4 2 0

City vs. IT Staffing Comparison Total City FTE IT FTE 1600 60 1400 50 1200 40 1000 800 30 600 20 400 10 200 0 0

City FTE Per One IT FTE Comparison 60 49.8 50 39.0 40 30.6 29.8 27.5 30 25.7 22.8 22.4 20 10 0 Bellevue Kent Auburn Sea Tac Burien Renton Tukwila Federal Way

Additional Unfunded Needs Program 2019 2020 PD Unbudgeted Applications 18,100 18,100 PD Contract Services Increases 31,300 31,300 PD 800 MHz Radio Service Increase (King County) 9,000 9,000 Cellular Service Increases 17,800 17,800 IT/City Increased Contracted Services 28,000 28,000 Adobe Creative Cloud Subscriptions 10,000 10,000 Laserfiche Document Automation 60,000 60,000 Network Management/Security Software 50,000 50,000

Additional Unfunded Needs Program 2019 2020 Fiber Tester 10,000 Cisco WebEx Subscription 8,000 8,000 GIS ELA (Site License) 30,000 30,000 Offsite Disaster Recovery 175,000 30,000 Website Maintenance 20,000 20,000 Total (including previous slide) $467,200 $312,200

2019/2020 Anticipated Projects • City-wide security assessment • Storage system (SAN) replacement/upgrade • Backup software replacement • Replacement of major hardware/equipment • Replacement of vehicle routers • Upgrade server software as needed • City-wide upgrade of Windows & Office

Key Challenges • Staffing & staff retention – competing with private sector and neighbor agencies • Institutional knowledge risk; no depth • Reactionary “fire fighting”, not proactive, burnout • Behind the scenes • Interdepartmental support • Lack of training

SEPTEMBER 21, 2018 XBASH MALWARE PACKS DOUBLE PUNCH: DESTROYS DATA AND MINES FOR CRYPTO COINS RANSOMWARE WILL BE TOP THREAT FOR YEARS YOUR BUSINESS SHOULD BE MORE AFRAID OF PHISHING THAN MALWARE phish·ing GOVPAYNOW.COM LEAKS noun 14M+ RECORDS the fraudulent practice of sending emails purporting to be from reputable companies in order to HEALTHCARE LAGS OTHER induce individuals to reveal INDUSTRIES IN PHISHING personal information, such as passwords and credit ATTACK RESILIENCY RATE card numbers.

Key Challenge: SECURITY • March 2018: “Atlanta ransomware attack may cost another $9.5 million to fix”… after the initial $2.6M • September 2018: “ Port of San Diego victim of cyberattack” • August 2017: Yarrow Point phishing scam

Questions?