COIT Budget & Performance Subcommittee
Regular Meeting March 6, 2020
1
1 Dr. Carlton B. Goodlett Place, City Hall, Room 305 San Francisco, CA 94102
COIT Budget & Performance Subcommittee Regular Meeting March - - PowerPoint PPT Presentation
COIT Budget & Performance Subcommittee Regular Meeting March 6, 2020 1 Dr. Carlton B. Goodlett Place, City Hall, Room 305 San Francisco, CA 94102 1 Agenda Call to Order by Chair Roll Call Approval of Meeting Minutes
1
1 Dr. Carlton B. Goodlett Place, City Hall, Room 305 San Francisco, CA 94102
2
Action Item
3
4
5
6
FY 2020-21 FY 2021-22 Annual Allocation 15.5 17.1 Major IT Allocation 24.7 27.2
Total 40.2 44.3
Note: All figures in $ millions.
7
Number of Requests FY 2020-21 GF Requests FY 2021-22 GF Requests Annual Allocation 57 38.8 26.6 Major IT 4 24.0 32.5
All COI T Submissions 62 62.8 59.1
Note: Financial figures in $ millions.
8
FY 16-17 FY 17-18 FY 18-19 FY 19-20 FY 20-21 Total Number
110 149 77 116 62
Total GF Request
39.9 48.8 44.2 58.6 62.8
9
Note: All figures in $ millions. FY 2020-21 FY 2021-22 Major IT Allocation 24.7 27.2 Budget Requests 24.0 32.5
Difference 0.7 (5.3)
10
Title FY 2020-21 GF Request FY 2021-22 GF Request
Property Assessment & Tax System 15.1 4.1 Radio Replacement 4.4 3.8 Computer Aided Dispatch 21 19.2 Telecom Modernization 2.6 5.4
Total
24.0 32.5
11
Note: All figures in $ millions. FY 2020-21 FY 2021-22 Annual Allocation 15.5 17.1 Budget Requests 38.8 26.6
Difference (23.3) (9.1)
12
Theme Number of Projects FY 2020-21 GF Request FY 2021-22 GF Request
Customer & Case Management 15 7.3 1.6 Digitization & Records Mgmt 2 0.65 0.2 Infrastructure 8 13.8 9.2 Major IT 4 24.0 32.5 Residential Digital Services 5 1.4 0.2 Resource Management 10 1.8 1.0 Risk Management 7 3.9 3.8 Staff Collaborative Tools 8 5.8 6.5 Business Specific 3 3.9 4.1
Total 62 59.1 59.1
13
Budget Intake January 17 Dept Interviews February/ March
Budget Hearings March/April Final Approval May
14
15
DATE EVENT
March 6 Enterprise Department Presentations March 27 General Fund Departments Presentations April 3 General Fund Departments Presentations April 10 General Fund Departments Presentations April 16 COIT - Budget Review May 1 COIT - Final Review & Approval
16
1
Airport Mission | We provide an exceptional airport in service to our communities. IT Vision | To be the most technologically empowering airport in North America.
Situation | Our analysis of the Airport’s situation.
2
Theme Description Persistent Security Threats
Professional technology services and solutions for a safer and more secure Airport.
Asset Utilization
Recognize Airport’s virtual assets as a viable source of revenue and value alongside
Resource Optimization
Use automation to promote better workforce efficiently and effectiveness.
Modern Service Model
Airport as platform for tenant & concessionaire technology services, including Common Use replacement.
Disruptive Innovative
Working with tech innovators to find and harness the next wave of disruptors.
Theme Description Persistent Security Threats Upgrade core security systems. MSSP ( 3bn / 5 ). Procure SMS, mobile P.139 and Notice of Violation solutions. Achieve international cyber-security standards accreditation (ISO27001). Asset Utilization Establish Airport Data Portal, the exchange hub for all Airport data with airlines and partners. Implement airfield vehicle and terminal asset tagging. Door to Gate API. Rolled out new people processing (FLEX). Resource Optimization Airport Building Information Management. Landside services automation (TNC, Taxi, Shuttle Bus). Implement Single Sign-On, Airport Operations App (SFO CoPilot) and Document Management System. Modern Service Model Expand and improve SFO FREE WIFI, Operational Wi-Fi, core tenant fiber (SONET) network. Early adopter of WiFi 6 in Terminal 2. Upgrade Common Use 2.0 in International Terminal Building (ITB) and deploy in Terminal 1. Implement Airport Data Hub and Microservices Platform. Pilot Advanced Security Lanes (ASLs), biometrics and RFID. Disruptive Innovative Whitepaper on Generic airport location-based services using an integrated indoor positioning system. Partner with Silicon Valley leaders to prototype new solutions.
Actions | Our policies direct our technology priorities.
3
Projects Previously Approved | Actions including the following projects
4
Description 8968 Network Security 9134A IT Security Mitigation 11157 Single Sign On Implementation 11217 Managed Security Upgrade 10674 Airport Information Integration Solution (AIIS) 11158 Data Analytics Compute Processing 11222 SFO Data Storage Program 8399A Property Management and Billing System (PMBS) Phase 2 8411A Sharepoint ERP Phase 1, Integrated Time and Labor Accounting (ITA) Program 9044 Document Management System (DMS) 9051 Operating Budget System (OBS) 10401 CIP Programmatic Support 10501 Contract Management Compliance System (CMCS) 10535 Capital Planning System (CPS) Phase III 11104 Virtual Design & Construction Implementation Program 11161 Building Information Technology Upgrade 11433 Contract Management Compliance System (CMCS) Phase II – New 8410 Distributed Antenna System (DAS) 8590 Telecommunication Infrastructure Airport Wide 9169 Network Expansion 9170 Network Improvements 9304 Public WiFi – Terminals 9304A Public WiFi – Rental Car Center 10622 Operational WiFi Improvements 10648 Long Term Parking Guidance and Security System 10678 Avaya Communication Manager Upgrade 7.0 11139 Dense Wavelength Division Multiplexing (DWDM) Transport 11149 Access Layer Refresh 10 Gbps 11153 Internet Hardware Upgrade 10674 Airport Information Integration Solution (AIIS) 11155 Mobile Application Development and Delivery 9171 Network Monitoring & Management 11130 Multi-Use Flight Information Display Upgrade 11132 Digital Signature Software System Enhancement 11154 ITIL/ISO Certification 11156 Comprehensive Support Plan 11211 Terminal Management System Upgrade 11216 ISO27001 Information Security Management System
Projects in Red indicates that it is part of the Airport’s Strategic Plan.
New Projects | Actions including the following projects
5
Description FY 2020-21 Costs FY 2021-22 Cost 11433 Contract Management and Compliance System (CMCS) Phase II $750,000 $225,000
Accomplishments | Highlights in 2019-2020
6
Description Accomplishment SFO CoPilot App
SFO made app available in the Apple and Google app store. (March 2019)
Passenger Processing
SFO implemented SITA’s new passenger processing application FLEX in Terminal 1. (June 2019)
WiFi 6
SFO implemented in Terminal 2, International Terminal and other areas. SFO is an early adopter of the capability. (January 2020)
U.S Patent
SFO earns U.S. Patent for system that Tracks App-Based Ground Transportation. (January 2020)
Airport Maps
SFO shipped the first Airport terminal maps to United Airlines (UAL) as part of the recently signed Map Agreement with United. (February 2020)
Thank you
7
Confidential
COIT March 6, 2020
2000 2019
1 8
2000 2019
2000
when faced with service disruptions and gaps
KEEP THE CUSTOMER INFORMED THROUGHOUT THEIR JOURNEY
Milestone Project Requirements Gathering Request for Information Research & Internal Stakeholder Engagement Procurement Request for Proposals Proposals Evaluation Contract Negotiations Project Planning Project Design Implementation Phase I: 1-for-1 replacement of current signs New Mobile App Trip Planning, Quotes, Multi-Modal, Payment Phase II: Feature and functional enhancements Crowding, Alternate route, traffic, re-routes real time. Solar Signage where no power, …
Project Milestones
We are here
Public Outreach
External Stakeholder Examples
+
21
research to identify customer requirements for the new system
implementation
Quantitative Comprehensive Survey
(Available in English, Chinese and Spanish;
5,700+ complete responses; ±1.3% margin
Qualitative Concept Testing Stakeholder Interviews Ride-alongs
311 SF Board of Supervisors BART and other transit agencies SF Travel Chamber of Commerce SFMTA Citizens’ Advisory Council (CAC) Chinatown Community Development Center (CCDC) SFMTA Multimodal Accessibility Advisory Committee (MAAC) Chinatown Tenants Association SFMTA Policy and Governance Hotel Council SFUSD-Access Independent Living Resource Center Senior Action and Disability Network Lighthouse for the Blind SF Transit Riders Rebuild Potrero Transbay Joint Powers Authority Save Muni Youth Commission
Public Outreach - Research Findings
+
dramatically influence transit mode share across all income levels
Coordination with Other Projects
Coordinate new signage in conjunction with major transit projects and the Muni Service Equity Strategy
2 4
Surface Vehicle Locations
Gathers vehicle locations from CAD/AVL System
Underground Locations
Gathers vehicle locations from Automatic Train Control System
System Software
Generates real-time vehicle predictions, monitors system status through a System Administration Tool, and displays information
Management System
Analytics Platform Provide insights and continual improvement of SFMTA services Mobile Platform & Website
Delivers travel information in mobile and
enhanced Trip Planner
On-Board Digital Signage
Provides back-end capability to display service updates, transfer connection times and other information on separately-procured
Stationary Digital Signage
Displays real-time arrivals, alternatives and other valuable info at rail stations, transit shelters and selected transit stops without power
Automatic Passenger Counters
Gathers real-time ridership loads
25
25
inputs
departures, transfers, trip planner itineraries, route alternatives, etc.
interfaces
system
to customer interfaces
Existing System
and lead time to communicate temporary service changes
messages
Next Generation System
planned and unplanned service changes
common (e.g., closing Market Street) and large-scale disruptions (e.g., Bay to Breakers) for future use
27
27
shelters
platforms
install new LCD signs at Central Subway stations (~30 total)
Stationary Digital Signage Next Generation System
Liquid Crystal Display (LCD) screens with ability to display:
routes
languages Durable to the elements and resistant to vandalism
Existing System
Light Emitting Diode (LED) screens
Existing Powered Signage
Future Solar-Powered Signage
30
30
discretion
ticketing and provides trip planning functionality
31
31
receive feedback
32
32
System Software
escalator outages
Stationary Digital Signage
On-Board Digital Signage
transit stops and for connecting routes
Mobile Platform & Website
accessibility preferences (e.g., elevator access, ramps, maximum grade)
customer needs
33
33
to enhance the customer experience
Provide insights and continual improvement of SFMTA services.
34
Performance Management
Customer Engagement
Service and Operational Planning
Customer Experience
35
35
transfer connections) for display on future signs
System Features Current Future System Software Predictions Engine (improved) Crowding Level Alerts x Alternative Route Suggestions x Real-Time Temporary Service Changes (limited) Connections with other systems x Stationary Digital Signage Powered Shelters (LED) (LCD) Unpowered Shelters & Stops x On-Board Digital Signage (back-end) Stop Announcements Connection Times x Service Delay & Reroute Alerts x Mobile Platform & Website Mobile App (primarily mobile ticketing) (enhanced capabilities) Accessible Itineraries x Analytics Platform Usage Trends & Analytics (limited) (enhanced capabilities)
36
System Features
MTAB April, 2020 BOS April, 2020 NTP May, 2020 Begin Sign Replacement May, 2020
Begin Backend Set up May, 2020 Plan Milestone Delivery May, 2020
Design April, 2020 Outreach Begins April, 2020
Plan Milestone Delivery May, 2020
Projects Currently Approved via Capital Improvement Program Budgeting Trapeze Platform
Paycode Sign In Terminal – Cable Car Workers Comp CapID
Video Modernization Phase 2
Rail Expansion Tunnel Expansion Mobile Stream TOLE Expansion
Train Control Platform
West Portal Crossover Activation Central Subway Integration Support New System RFP - 2020
Radio-CAD/AVL Platform
Virtualization New updates to MDT Clipper Integration CIS Integration Central Subway Integration Support
39
39
40
CUSTOMERS WANT A BETTER ENROUTE INFO EXPERIENCE
"Have signs that work at every stop, update outages and line delays, and provide visual information on board vehicles to show transfers available at each stop...bring this very dated system into the 21st century. We live in a city of innovation...utilize it!” "On board screens that show arrival times of connecting bus, MuniMetro, BART and Caltrain lines would be helpful. Sometimes it's not always convenient to check times on a phone when standing on a crowded bus or holding bags/handrails/kids, etc. ” “I do not own a smartphone. Please do not make the system so dependent
“Announce expected arrival times of intersecting routes at each stop.”
Public Outreach - Research Findings
41
SFPUC Strategy
The SFPUC Strategic Plan identified the following six goals, each with its own set of objectives:
IT Strategy is mapped to the business strategy
42
SFPUC Reliable Service and Assets
Objective: “Formalize our asset management approach across SFPUC” Maximo Asset Management System:
Division and Power Field Operations
Key Performance Indicator
End user satisfaction with Maximo > 85% (currently at 77%)
43
Reliable Service and Assets and Financial Sustainability
Objectives: “Ensure SFPUC can mitigate, respond to and recover from threats and disasters” and “Formalize enterprise risk management across SFPUC” Continuously build out the SFPUC Systems Continuity of Operations capability.
Key Performance Indicator
Critical systems availability > 99.95% (Currently exceeding this goal)
44
Reliable Service and Assets and Financial Sustainability continued
Objectives: “Ensure SFPUC can mitigate, respond to and recover from threats and disasters” and “Formalize enterprise risk management across SFPUC” Continuously improving Information Security Program:
45
Operational Excellence
Objective: “Improve Operational Efficiency through Technology” Majority of recent solutions are cloud based and on prem systems moving to the cloud. Current projects include:
Communications
46
Operational Excellence continued
Key Performance Indicators:
the Agency > 87.5% (Currently at 93%)
?’s
Port of San Francisco Jerry Burdick
47
03/06/2020
Recent Accomplishments
Windows 10, OneDrive, & SharePoint Team Sites
Collaborative Engagement with DT Cybersec Team
48
Draft Technology Strategic Plan
feedback loop.
Current Challenges
Storage Management & Data Recovery
49
Collaboration: demand exceeds supply of expertise
Telephony
What to do about Accela?
Longer Term Goals
Move Storage and Systems from On-Prem to Cloud
50
Better align what we “own” and what we “consume”
integrations, devoted training to systems and tools.
Telephony
Highlights
stakeholders.
Champion and Sponsors engaged. He’s the “cool Uncle.”
questions and issues – processes, asset policies and hierarchy, functional requirements, reporting.
51
Next Steps
business processes, identifying reporting and integration needs, and finalizing functional and technical requirements for a new system.
requirements and to select a new system. Publish second RFP for system procurement and implementation services.
52
Port of San Francisco Jerry Burdick
53
54