Business Services — CleanPowerSF Sfpuc Commission, January 7, 2022

Business Services Proposed Budget
FY 2022-23 and FY 2023-24
Ron Flynn, Chief of Staff
January 7, 2022
1 • Business Services Background and Vision
• Looking Ahead: Business Services Priorities
• Budget Themes
• Business Services Budget Proposals
• Budget Summary
• Questions and Contacts
Agenda
2 SFPUC Business Services
Customer Services
• Business & Systems
Support
• New Service Installations
• Capacity Charge Program
• Billing & Collections
• Meter Reading
• Field Inspections
• Customer Contact Center
Information Technology
Services
• Business Applications
• Enterprise Systems &
Database Mgmt
• SCADA
• Technical Operations
• Cybersecurity
• Radio Project
Financial Services
• Accounting Services &
Financial Reporting and
Analysis
• Accounting Operations
• Assets, Grants and Debt Acct
• Financial Reporting & Analysis
• Finance & Business Projects
• Purchasing
• Financial Planning
• Budget
• Financial Planning
• Debt Management
• Fleet Management
Strategy, Innovation &
Change
• Strategy & business
planning
• Project leadership and
change management
• Risk Management
106 FTEs 67 FTEs83 FTEs 5 FTEs
Audit
• Assurance
• Internal Controls
3 FTEs
This FTE count is for FY 21-22.

Business Services Vision
• Impeccable stewardship
Accountable to customers, ratepayers and
other stakeholders for how we manage
their resources
• Excellent service
Focused on understanding customer
needs and delivering valuable solutions
• Financial sustainability
Long-term financial health is critical to
continued, high-quality utility service
delivery
• Culture of inclusion, equity and
excellence
We are an engaged, inclusive,
accountable, high-performing team
4 Prior Biennial Budget Cycle Themes:

Addressing Increasing Demands & Driving Efficiencies
• Meet the demands of an increasingly complex agency
• CleanPowerSF, delivering large capital investment programs • Increasing operational complexity, demands on all Bureaus to support operations and customers • Innovating on assistance programs for low-income customers • Develop the team to meet these demands
• Planning for succession, growing effective leaders, enhancing employee engagement • Building capacity for business planning, performance management, and management of cross - functional projects
• Manage debt services costs—largest cost of agency
• Regular analysis of debt re-financing
• Aggressive pursuit of alternative financing—estimated $444.5 million in debt service savings vs fixed-rate revenue bonds
5 • COVID-19 Pandemic response – Complete Re-alignment of BizServ Priorities • Financial Resiliency Plan (budgets, forecasts), Business Continuity Plan, Customer Assistance • DSW deployment, emergency cost recovery, assistance with City-wide public health efforts • Deployed remote IT work solutions, moved majority of BizServ staff to remote working • Growing cyber-security risks
• Emergency Response – Wildfires, Drought
• DOC deployments and increasing participation in emergency management activities • FEMA and insurance cost recovery, managing higher risk exposures and impacts on insurance • Public Integrity Response
• Secured clean audit opinion on Audited Financial Statements and Annual Financial Report • Developed immediate risk assessment and mitigation plan • Collaborated with CON-CSA to develop audit plan to address public integrity initiatives • Navigating changing procurement requirements, enhanced internal controls, etc. • Racial Equity
• Contributed to SFPUC REAP, developed BizServ REAP, kicked off BizServ RE projects Seismic Shifts: Response from Business Services
6 Employee Engagement is High
• Employee engagement is defined as the level of an
employee's commitment and connection to an
organization; and is measured by the SFPUC routinely
• The 2021 SFPUC Employee Voice Survey revealed that
Business Services had:
 The highest survey response rate in the
organization (82% vs. 61% PUC-wide)
 An engagement index of 70%, an improvement of 10%
compared to the 2018 survey, and the highest in the
agency
• Despite the challenges of the past 18 months, Business Services effectively fostered a high level of employee engagement within our teams 7 • Culture of Inclusion, Equity and Excellence
• Ensuring effective leadership transitions and succession • Supporting our workforce as workload increases
• Strong focus on racial equity, employee engagement and inclusivity
• Excellent Service
• Modernizing customer services technology
• Continuous improvement of cyber security
• Meeting the technology demands of the organization
• Financial Sustainability
• Institutionalizing the management and administration of external funding
• Focus on customer affordability and access
• Impeccable Stewardship
• Ensuring impeccable stewardship and restoration of public trust
Looking Ahead: Business Services Priorities
The Business
Services Vision
continues to drive
our priorities
within the new
PUC context
8 Culture of Inclusion, Equity and Excellence
• Ensuring effective leadership transitions and
succession
• Supporting our workforce as workload increases
• Strong focus on racial equity, employee engagement
and inclusivity
Excellent Service
• Modernizing customer services technology
• Continuous improvement of cyber security
• Meeting the technology demands of the organization
Financial Sustainability
• Institutionalizing the management and administration
of external funding
• Focus on customer affordability and access
Impeccable Stewardship
• Ensuring impeccable stewardship and restoration of
public trust
SFPUC’s Budget Themes and Objectives
The Business Services priorities
align with the themes of this
Biennial Budget Cycle:
• Responsible Management
• Access and Affordability
• Supporting People and
Communities
9 SFPUC Business Services Budget Breakdown
Bureau Total FY 21-22 Expenditure in Millions
Information Technology Services (ITS) $34.7
Financial Services (Fin) $18.4
Customer Services Bureau (CSB) $18.1
COWCAP $6.7
Strategy, Innovation & Change (SIC) $1.1
Administration $0.7
Total $79.6
ITS , 44%
Fin, 23%
CSB, 23%
COWCAP, 8%
SIC, 1% Adm, 1%
All Business Services Expenditures by
Bureau, FY21-22
Personnel,
61%
10%, Interdepartmental
Services
29%,
Non-
personnel
All Business Services Expenditures Breakdown,
FY21-22
Budget Proposal Summary
11 The Business Services budget proposals feature investments critical to forwarding our new priorities -- an increase of approximately $1.6M per fiscal year.

Business Services
Bureau
New
Prop # Title On-going Exp
One-Time
Exp
FY22-23
Total
On-going
Exp
Time
Exp
FY23-24
Total
ITS 56 SFPUC Cyber Security 249,088 80,000 329,088 449,000 449,000 ITS 55 Enterprise Applications 330,000 330,000 311,000 311,000 ITS 57 Radio Project - 393,003 393,003
ITS 58 Data Maturity - ITS - 445,660 445,660 SIC 54 Data Maturity - SIC 340,508 500,000 840,508 - CSB 52 CSB Capacity Charges (49SVN) 198,670 198,670 - CSB 53 CSB Support Tech (Capital Funded) - - - ADM 51 Grant and Loans Manager (Capital Funded) - - - Business Services Total 1,118,266 580,000 1,698,266 1,598,663 - 1,598,663 FY2022-23 Request FY2023-24 Request
Proposal #56: Cyber Security
• System licensing and maintenance costs for ServiceNow & Cyber Security Technology • New 1054 position – Position will also support increasing records requests • All respond to Mayoral Directive
Proposal #55: Applications – Licensing and Maintenance
• C2M electronic billing system hosting fees; stormwater charge system maintenance & operating costs • ITS has absorbed costs for years with no new budget; not absorbable anymore Proposal #57: Radio Project Positions (moving to operations) • 0931 and 7368 positions – request to move temp positions currently charging to projects to permanent Proposal #54 & 58: Data Maturity Initiative (Commission request) • Professional Services to develop baseline recommendation • System implementation and licensing costs
• 0923 and 1053 positions in SIC; additional 1043 in ITS Excludes Offset Proposals
Budget Proposals:

Information Technology Services (ITS)
12 Proposal #52 - SFPUC Capacity Charge Program; staff Resources for the 49SVN Permit Center • Move 4 filled TEMP positions supporting Permit Center to permanent • All positions were approved PCS for FY20-21 but moved to TEMP during COVID-19 • 3 positions off set, only 1 new position impacts operating budget Proposal #53 - CSB Support Technology Proposal ($16M in capital costs over 4 years) • CSB requests capital funding for the customer service and support technology transformation which includes critical improvements to modernize our customer services approach • Request includes critical off budget FTE to manage sizeable transformation effort, consulting and licensing fees
• No impact on operating costs during the 4-year implementation • Maintenance and licensing costs will be needed under the operating budget post -implementation Budget Proposals:

Customer Services Bureau (CSB)
13 Administration
Proposal #51: Grants and Loans Manager
• New 0933 position to institutionalize the management and administration of external funding Finance
Centralizing Payment of Controller’s Office Work Orders (reallocation, not new request) • An additional ~$1M increase to the Finance budget is anticipated to centralize payment for Controllers Office Work Orders
• This reduces the WO cost for the other SFPUC Enterprises and Bureaus Budget Proposals:

Administration & Finance
14 15
Budget | Use of Funds
FY 2022, FY 2023 &
FY 2024

Total Budget | FY 2022, FY 2023, FY 2024
16 ($ Millions) Budget Change $ Change %
FY 2021-22 Adopted 79.6
Labor & Benefits Base COLA Adjustment 1.7
SIC Data Maturity 0.8
Enterprise Applications 0.3
SFPUC Cyber Security 0.3
CSB Capacity Charges (49SVN) 0.2
CSB Support Tech (Capital Funded) -
Grant and Loans Manager (Capital Funded) -
COWCAP adjustment (6.7)
All Other 1.4
FY 2022-23 Request 77.6 (2.0) -3%
Labor & Benefits Base COLA Adjustment 1.5
ITS Data Maturity 0.4
SFPUC Cyber Security 0.4
Radio Project 0.4
Enterprise Applications 0.3
FY 2023-24 Request 80.6 3.0 4%
Total Positions
17 Budget "Operating" "Project" Change %
FY 2021-22 Adopted 264
New Requests 14 8 6
Temporary Salary Reductions (3) (3) -
Offsetting increase in Attrition Savings (1) (1) -
FY 2022-23 Request 274 4 6 4%
New Requests 6 6 -
Offsetting increase in Attrition Savings (3) (3) -
FY 2023-24 Request 277 3 - 1%
Position Type
Questions?
Appendix A:

SFPUC Data Maturity Initiative
November 23, 2021
Background
• Data is corporate currency that needs to be managed and invested in order to maximize its returns/benefits
• SFPUC lacks standardized methods of understanding, accessing and utilizing data for decision strategic making:
• Data is fragmented and shallow
• Data is not holistic
• Data is limited to a few (tribal knowledge)
• Data is not fully understood
Objective
• Increase awareness, understanding and availability of data throughout the organization to support strategic decision making
Background and Objective
Appendix A
• This is not a technology project, rather, it is a strategic business initiative that is supported by technology
• Strong business engagement and change management are essential components for success
• Hence, our recommendation is for a partnership between ITS and SIC:
• SIC to lead and drive the project to define business needs, level of effort and road map • ITS to lead and drive technology decisions, implementation and support • Begin with study to identify & prioritize data/business needs across SFPUC stakeholders. Inventory existing data sources & identify metrics, processes & technologies for data-reliant areas such as:
• Reliable Service & Assets
• Effective Workforce
• Financial Sustainability
Approach
Appendix A
Phase 1: Size Up Effort
Scope: Develop baseline understanding of existing data sources and reporting functionality, define business priorities and requirements, identify resources, level-of-effort and road map, develop governance structure to support & maintain
Timeline: 6-12 months
Resources: • Business Stakeholders
• External consultants
• 0923 – Project Management (new in SIC)
• 1053 – Business Analysis (new in SIC, shared resource with ITS) Cost: Professional/Consulting Services: $500,000
SFPUC Staff: $340,508 $840,508
Appendix A
Phase 2: Execute and Implement
Scope: Identify and select technology, implement/train/support users Timeline: TBD
Resources: • Business Stakeholders
• 0923 – Governance & Change Management (stays in SIC)
• 1053 – Business Analysis/Technology Implementation & Support (transfer to ITS) • 1043 – Technology Implementation & Support (new in ITS) Cost: New Technology: $250,000
SFPUC Staff: $536,168
$786,168
Appendix A
FY22-23 FY23-24
0923: $180,801 1053: $159,707 Professional/Consulting Services: $500,000
$840,508
0923 & 1053 Positions*: $340,508
1043: $262,645 New Technology (software/service): $250,000
$786,168
Budget Request:
* On-going from prior FY, not new request for FY23-24.

Estimates for staff include fringe and 3.5% increase between fiscal years.

Appendix A
Business Services Appendix

Operating
A. Operating Budget by Category & Position Summary
B. Position Change Summary
C. New Proposals

Business Services Appendix

A. Operating Budget by Category & Position Summary

Category
FY 2021‐22
Adopted
FY 2022‐23
Request
FY 2022‐23
versus
FY 2021‐22
FY 2023‐24
Request
FY 2023‐24
versus
FY 2022‐23
Labor 34,858,450 36,700,296 5.3% 38,153,751 4.0%
Mandatory Fringe Benefits 13,740,311 14,342,419 4.4% 14,943,283 4.2% Materials & Supplies 2,283,421 1,830,223 ‐19.8% 1,800,145 ‐1.6% Non‐Personnel Services 12,346,241 14,187,997 14.9% 15,200,935 7.1% Capital Outlay 1,638,707 1,103,759 ‐32.6% 1,038,600 ‐5.9% Services of Other Departments 8,071,226 9,419,493 16.7% 9,458,376 0.4% COWCAP 6,708,933 ‐ 100.0% ‐‐
Grand Total 79,647,289 77,584,187 ‐2.6% 80,595,090 3.9% Category
FY 2021‐22
Adopted
FY 2022‐23
Request
FY 2022‐23
versus
FY 2021‐22
FY 2023‐24
Request
FY 2023‐24
versus
FY 2022‐23
Full‐Time 280.96 291.74 10.78 296.36 4.62 Off‐Budget (6.00) (10.62) (4.62) (10.62) ‐ Total Positions 274.96 281.12 6.16 285.74 4.62 Attrition (17.39) (17.39) ‐ (17.39) ‐
Grand Total 257.57 263.73 6.16 268.35 4.62 *Please note that these numbers represent FTEs vs headcount presented on other materials BUSINESS SERVICES
OPERATING BUDGET BY CATEGORY
POSITION SUMMARY
Appendix A
A1

Business Services Appendix

B. Position Change Summary

Appendix B
Business Services FY 2022‐23 Position Changes
Indicator Position Position Title Accounting Budgets ITS CSB ‐ Admin CSB ‐ Business Center SIC Grand Total
AN 0923 Manager II 11
1054 IS Business Analyst‐Principal 11
1053 IS Business Analyst‐Senior 11
1823 Senior Administrative Analyst 11
5601 Utility Analyst 33
5602 Utility Specialist 11
AR 0923 Manager II ‐11 0
1824 Principal Administrative Analyst 11
1825 Principal Administrative Analyst II ‐1 ‐1
AS 1043 IS Engineer‐Senior 00
1095 IT Operations Support Administrator V ‐1 ‐1
7368 Senior Communications Systems Technician ‐1 ‐1
1044 IS Engineer‐Principal 11
1052 IS Business Analyst ‐1 ‐1
1630 Account Clerk ‐1 ‐1
1652 Accountant II ‐1 ‐1
1654 Accountant III 11
1820 Junior Administrative Analyst 11
1822 Administrative Analyst ‐1 ‐1
1823 Senior Administrative Analyst 11 2
5203 Assistant Engineer 11
AT 0942 Manager VII ‐1 ‐1
0943 Manager VIII 11
1042 IS Engineer‐Journey 00
1043 IS Engineer‐Senior 11
1041 IS Engineer‐Assistant 11
1095 IT Operations Support Administrator V ‐1 ‐1
1054 IS Business Analyst‐Principal ‐1 ‐1
1044 IS Engineer‐Principal 00
1093 IT Operations Support Administrator III ‐2 ‐2
1092 IT Operations Support Administrator II 22
1450 Executive Secretary I ‐1 ‐1
1842 Management Assistant 11
ON 0931 Manager III 11
0933 Manager V 11
1053 IS Business Analyst‐Senior 22
1823 Senior Administrative Analyst 11
B1
Business Services FY 2022‐23 Position Changes
Indicator Position Position Title Accounting Budgets ITS CSB ‐ Admin CSB ‐ Business Center SIC Grand Total
ON 5602 Utility Specialist 11
Grand Total 101093 1 4
AN Operating New Position
ON Off‐budget New Position
AS Operating Position Substitution
AT Position substitution used to identify an existing TX'd position(Operating budget) OT Off‐budget Position substitution used to identify an existing TX'd position(Operating budget) AR Operating Position Reassignment
B2
Appendix B
Business Services FY 2023‐24 Position Changes
Indicator Position Position Title Accounting ITS Grand Total AN 0931 Manager III 11
1043 IS Engineer‐Senior 11
7368 Senior Communications Systems Technician 11
1820 Junior Administrative Analyst 11
1822 Administrative Analyst 11
1824 Principal Administrative Analyst 11
AS 0931 Manager III ‐1 ‐1
0932 Manager IV 11
1822 Administrative Analyst ‐1 ‐1
1823 Senior Administrative Analyst 11
Grand Total 24 6
AN Operating New Position
AS Operating Position Substitution
B3

Business Services Appendix

C. New Proposals

Appendix C
Business Services New Proposals
FY 2022-23 FY 2023-24
Proposal Operating Off-budget Request Operating Off-budget Request 49 Grants Accounting Analyst - - - 1 - -
50 Finance Project Management Office Manager - - - 1 - - 51 Grant & Loans Manager - 1 - - - -
52 CSB Capacity Charges 4 - 198,671 - -
53 CSB Support Tech - 5 - - - -
54 Data Maturity - SIC 2 - 840,508 - - -
55 Enterprise Applications - - 330,000 - - 311,000 56 SFPUC Cyber Security 1 - 329,088 - - 449,000 57 Radio Project 1 - - 3 - 393,003
58 Data Maturity - ITS - - - 1 - 445,660
Grand Total 8 6 1,698,266 6 - 1,598,663
C1
Budget Request Summary by Proposal
Fiscal Year: 2023-24
Organization: PUB110201 - PUB110201 Accounting (267641) Proposal: 49 - Grants Accounting Analyst
Fund/Dept/Auth/Proj/Act: 27180/267641/10000/10026775/0001 ...

Account Lvl3 Account Base Budget Total Request Change
Labor 50100 Permanent Salaries-Misc. 0 0 0
Labor 0 0 0
Mandatory Fringe Benefits Mandatory Fringe Benefits 0 0 0 Mandatory Fringe Benefits 0 0 0
Summary 0 0 0
Position Change
Organization Proposal Indicator RefCode Position Title Count Total Request
Justification
PUB110201
-
PUB110201
Accounting
(267641)
49 -
Grants
Accounting
Analyst
AN 1822 Administrative
Analyst
1 87,482 SFPUC Accounting Services (AS) manages all financial accounting for SFPUC grants, both as grantee and grantor. The grant portfolio, currently valued at over $1.7 billion, has grown significantly in the past 3-5 fiscal years. The growth is attributed to the addition of traditional utility-related grants; State Revolving Fund (SRF) loans ($484 million and increasing), Water Infrastructure Finance and Innovation Act (WIFIA) loans ($1.2 billion+), and disaster grants (COVID-19, August 2020 wildfires, and Rim Fire wildfire, $25 million+). Grantor programs include Wastewater's Green Infrastructure Grant Program; Community Based Organizations (CBO); and other utility programs supporting low- income, conservation, etc. In FY 2020-21, grant accounting was consolidated to Financial Services Accounting Services to support best practices/internal control. The administration of each grant is nuanced based on the specific terms and conditions of each grant agreement, requiring significant knowledge
and
expertise
to
fully
understand
each
program’s
requirements.

The portfolio is expected to increase (both volume and complexity) in the next cycle. Recent grants such as FEMA for COVID-19 (C19) have required costs to be recorded, monitored, and reported with more detail and granularity. Current C19 Cost Recovery grant accounting is performed primarily in the Controller's Office by 3 FTE. SFPUC's Finance Project Management Office (1 FTE) is currently steering the collection of data, compilation and drafting/administering policy to support cost recovery efforts and submitting data to the Controller's Office. Existing capital grant accounting staff will not be able to fully support this work (as they are also at capacity with existing grant accounting work) and there is significant need for an analytical skillset to work with immediate data received. It is expected SFPUC will be tasked to take over C19 grant accounting in FY 2022-23. In addition, SFPUC is currently pursuing State utility arrearages grants and other debt relief programs for customers impacted by COVID-19. To manage the growing portfolio, which will supplement SFPUC’s revenues to fund its operating and capital needs, SFPUC needs a dedicated Accounting Analyst for grants. The Accounting Analyst will be critical to navigating through the various state/federal programs rules/regulations to maximize SFPUC’s award chances while minimizing the occurrence of disallowance of claimed grant funds.

C2
Budget Request Summary by Proposal
Fiscal Year: 2023-24
Organization: PUB110201 - PUB110201 Accounting (267641) Proposal: 49 - Grants Accounting Analyst
Organization Proposal Indicator RefCode Position Title Count Total Request
Justification
PUB110201
-
PUB110201
Accounting
(267641)
49 -
Grants
Accounting
Analyst
A 9993M Attrition
Savings -
Miscellaneous
0 -87,482
Position Total 1 0
This entry offsets the new requested operating position.

C3
Budget Request Summary by Proposal
Fiscal Year: 2023-24
Organization: PUB110201 - PUB110201 Accounting (267641) Proposal: 50 - Finance Project Management Office Manager Fund/Dept/Auth/Proj/Act: 27180/267641/10000/10026775/0001 ...

Account Lvl3 Account Base Budget Total Request Change
Labor 50100 Permanent Salaries-Misc. 0 0 0
Labor 0 0 0
Mandatory Fringe Benefits Mandatory Fringe Benefits 0 0 0 Mandatory Fringe Benefits 0 0 0
Summary 0 0 0
Position Change
Organization Proposal Indicator RefCode Position Title Count Total Request
Justification
PUB110201
-
PUB110201
Accounting
(267641)
50 - Finance
Project
Management
Office
Manager
AN 1824 Principal
Administrative
Analyst
1 118,030 The Finance Project Management Office (FPMO) is a expanded critical function within the Financial Services Bureau (Accounting Services, Financial Reporting & Analysis, and Purchasing). Its goals and objectives are to lead, manage, and oversee a variety of critical and time-sensitive projects, directives, and initiatives that are complex, strategic, and high-impact across Financial Services functions and the SFPUC Enterprises and Bureaus. Such financial projects are deeply analytical, at times require extensive research and management report development, and include the following:
ongoing PeopleSoft Financials and Supply Chain Management System initiatives (implementations and enhancements of existing modules and system functionality) driven by the Controller's Office and SFPUC needs; new and ongoing emergency cost recovery, accounting and procurement for the SFPUC organization related to the COVID-19 pandemic, August 2020 Wildfires, the 2013 Rim Fire and other department emergency events; Procure to Pay initiatives, SFPUC and Finance Accounting Policies and Guidelines, etc. The FPMO Manager will be a key management team member in Financial Services, who will contribute strategic and advisory inputs to the senior management team in Finance.
50 - Finance
Project
Management
Office
Manager
A 9993M Attrition
Savings -
Miscellaneous
0 -118,030
Position Total 1 0
This entry offsets the new requested operating position.

C4
Budget Request Summary by Proposal
Fiscal Year: 2022-23
Organization: PUB110101 - Business Services Admin
Proposal: 51 - Grant & Loans Manager
Fund/Dept/Auth/Proj/Act: 27180/263641/10000/10026772/0004 As a result of an increasing number of emergency grants due to wildfires and the emerging opportunity to access Federal Infrastructure funding for capital projects, the SFPUC is facing a quickly growing need for development of grant management and low-cost project financing efforts across the organization. Grant management and development activities are currently diffuse across finance teams, external affairs, and supported by consulant staff. A united function will allow PUC to streamline efforts and enable our organization to be more proactive in the pursuit of grant and
low
cost
project
financing
opportunities.

We
recommend
an
off-budget
position
potentially
funded
by
capital
projects.

The scope of this position would include managing the negotiation, coordination and facilitation of a low-cost project financing loan funding agreements with federal, state and local agencies; ensuring compliance with and timely completion of all monitoring and accounting requirements; facilitating the completion of reports on expenditures and outcomes; and ensuring the compliance of all grant and loan agreements managed by SFPUC with external parties.

Account Lvl3 Account Base Budget Total Request Change
Labor 50100 Permanent Salaries-Misc. 0 379,512 379,512
50500 Temp Salaries-Misc. 0 -244,362 -244,362
Labor 0 135,150 135,150
Mandatory Fringe Benefits Mandatory Fringe Benefits 0 63,520 63,520 Mandatory Fringe Benefits 0 63,520 63,520
Summary 0 198,670 198,670
Position Change
Organization Proposal Indicator RefCode Position Title Count Total Request
Justification
PUB110802 -
PUB110802 CSB
Business Center
(267652)
52 - Capacity
Charges & Project
Review Program
Staffing
AN 5602 Utility
Specialist
1 122,974 Add one (1) new PERM 5602 Utility Specialist to assist the existing PERM 0922 Manager I
52 - Capacity
Charges & Project
Review Program
Staffing
AN 5601 Utility
Analyst
3 256,538 Convert the existing three (3) TEMP 5601 Utility Analyst positions to PERM FTEs (2-5601 assigned to the Project Review Program and 1-5601 assigned to the Capacity Charges program), which were postponed due to the COVID-19 pandemic.

Position Total 4 379,512
Other Objects
Organization Proposal Account Total
Request
Justification
PUB110802 - PUB110802 CSB
Business Center (267652)
52 - Capacity Charges & Project
Review Program Staffing
505010 Temp-
Misc-Regular
-244,362 The offset from temporary salaries for Class 5601 - Utility Analyst positions that support the SFPUC Capacity Charge program.

Other Objects Total -244,362
C6
Budget Request Summary by Proposal
Fiscal Year: 2022-23
Organization: PUB110802 - PUB110802 CSB Business Center (267652) Proposal: 53 - Customer Service & Support Technology
Fund/Dept/Auth/Proj/Act: 27180/267652/10000/10026773/0002 ...

(1) Transition
to
an
Oracle
CC&B
Cloud
SaaS
solution
(CCS)
(2) Implementation
of
a
new
Digital
Self-Service
(DSS)
(3) Transition to a Cloud Contact Center (CCC)
53 - Customer
Service & Support
Technology
ON 1823 Senior
Administrative
Analyst
1 98,737 To support the customer service and support technology transformation project, which
includes:

(1) Transition
to
an
Oracle
CC&B
Cloud
SaaS
solution
(CCS)
(2) Implementation
of
a
new
Digital
Self-Service
(DSS)
(3) Transition to a Cloud Contact Center (CCC)
53 - Customer
Service & Support
Technology
ON 1053 IS Business
Analyst-
Senior
2 217,289 To support the customer service and support technology transformation project, which
includes:

(1) Transition
to
an
Oracle
CC&B
Cloud
SaaS
solution
(CCS)
(2) Implementation
of
a
new
Digital
Self-Service
(DSS)
(3) Transition to a Cloud Contact Center (CCC)
53 - Customer
Service & Support
Technology
A 9997M Non-
Operating
Position
Offset
-5 -571,620
Position Total 0 0
C7
Budget Request Summary by Proposal
Fiscal Year: 2022-23
Organization: PUB1110 - PUB1110 Strategy, Innovation and Change (140644) Proposal: 54 - Data Maturity Initiative
Fund/Dept/Auth/Proj/Act: 27180/140644/10000/10026772/0009 To increase awareness, understanding and availability of data throughout the organization to support strategic decision making. This proposal is not a technology project, rather a strategic business initiative that is supported by technology and geared for strong business engagement and change management that are essential components for Agency-wide success. The recommendation is for SIC to lead and drive the project (partnering with ITS) to define business needs, level of effort and road map. Technology decisions, implementation and support will then be led and driven by ITS. This approach will begin with a study to identify & prioritize data/business needs across SFPUC stakeholders. Inventory existing data sources & identify metrics, processes
&
technologies
for
data-reliant
areas
such
as:

* Reliable
Service
&
Assets
* Effective
Workforce
* Financial
Sustainability
A
continuation
of
funding
is
requested
for
FY
2023-24
under
the
ITS
Bureau
to
assist
identifying
best
selected
technology
while
training
and
supporting
Agency-wide
end
users.

Account Lvl3 Account Base Budget Total Request Change
Labor 50100 Permanent Salaries-Misc. 0 231,638 231,638
Labor 0 231,638 231,638
Mandatory Fringe Benefits Mandatory Fringe Benefits 0 108,870 108,870 Mandatory Fringe Benefits 0 108,870 108,870
Non-Personnel Services 52700 Professional & Specialized Svc 0 500,000 500,000 Non-Personnel Services 0 500,000 500,000
Summary 0 840,508 840,508
Position Change
Organization Proposal Indicator RefCode Position Title Count Total Request
Justification
PUB1110 -
PUB1110 Strategy,
Innovation and
Change (140644)
54 -
Data
Maturity
Initiative
AN 0923 Manager
II
1 122,994 This position will lead the assessment of existing data sources and reporting functionalities, define business priorities and requirements across SFPUC stakeholders, identify resources, level-of-effort and implementation road map, and develop governance structure to support & maintain new data systems and processes long term.
54 -
Data
Maturity
Initiative
AN 1053 IS
Business
Analyst-
Senior
1 108,644 This position will assist with the assessment of existing data sources and reporting functionalities, define business priorities and requirements across SFPUC stakeholders, identify resources, level-of- effort and implementation road map, and develop governance structure to support & maintain new data systems and processes long term.

Position Total 2 231,638
Professional Services
C8
Budget Request Summary by Proposal
Fiscal Year: 2022-23
Organization: PUB1110 - PUB1110 Strategy, Innovation and Change (140644) Proposal: 54 - Data Maturity Initiative
Organization Proposal Contractor Hourly Total
Request
Purpose
PUB1110 - PUB1110
Strategy, Innovation and
Change (140644)
54 - Data
Maturity
Initiative
TBD 100 500,000 This request is to support a study to assess the SFPUCs overall data maturity, identify & prioritize data/business needs across SFPUC stakeholders and build a robust recommendation for modernizing the SFPUC business intelligence approach long term to support decision making. (1-time)
Professional Services Total 500,000
C9
Budget Request Summary by Proposal
Fiscal Year: 2022-23
Organization: PUB1103 - PUB1103 ITS (267662)
Proposal: 55 - Enterprise Applications
Fund/Dept/Auth/Proj/Act: 27180/267643/10000/10026776/0001 Managed service costs of billing systems for electric billing (C2M and Stormwater).

Account Lvl3 Account Base Budget Total Request Change
Non-Personnel Services 53500 Other Current Expenses 0 330,000 330,000 Non-Personnel Services 0 330,000 330,000
Summary 0 330,000 330,000
Other Objects
Organization Proposal Account Total
Request
Justification
PUB1103 - PUB1103 ITS
(267662)
55 - Enterprise
Applications
535960 Software
Licensing Fees
330,000 C2M hosting fees, annual cost of 330,000, contract 1000012182 Managed Services contract with ESC Partners. Ongoing
Other Objects Total 330,000
C10
Budget Request Summary by Proposal
Fiscal Year: 2023-24
Organization: PUB1103 - PUB1103 ITS (267662)
Proposal: 55 - Enterprise Applications
Fund/Dept/Auth/Proj/Act: 27180/267643/10000/10026776/0001 Managed service costs of billing systems for electric billing (C2M and Stormwater).

Account Lvl3 Account Base Budget Total Request Change
Non-Personnel Services 53500 Other Current Expenses 0 311,000 311,000 Non-Personnel Services 0 311,000 311,000
Summary 0 311,000 311,000
Other Objects
Organization Proposal Account Total
Request
Justification
PUB1103 -
PUB1103 ITS
(267662)
55 -
Enterprise
Applications
535960
Software
Licensing
Fees
311,000 The Stormwater Capital project will be completed and the new system will go live. This is to cover the annual maintenance costs. SDMS (Stormwater Data Management System) maintenance. This includes 24x7 hosting, all patching, all licenses (Microsoft, Oracle, Esri etc), security
updates
etc.

It also supports operational tasks like receiving and consuming City parcel maps, Assessors files, aerial photography and NDVI analysis etc.

Contract # 1000017310 (ongoing)
Other Objects Total 311,000
C11
Budget Request Summary by Proposal
Fiscal Year: 2022-23
Organization: PUB1103 - PUB1103 ITS (267662)
Proposal: 56 - SFPUC Cyber Security
Fund/Dept/Auth/Proj/Act: 27180/267643/10000/10026776/0001 This work is to support the SFPUC's security team and improve overall security of the PUC's systems and assets. Many of the requests are in response to the Mayor's Office directives and/or the CISO's security plan. These requests also respond to areas for increasing maturity based on the Gartner assessments.

Account Lvl3 Account Base Budget Total Request Change
Labor 50100 Permanent Salaries-Misc. 0 135,434 135,434
Labor 0 135,434 135,434
Mandatory Fringe Benefits Mandatory Fringe Benefits 0 63,654 63,654 Mandatory Fringe Benefits 0 63,654 63,654
Non-Personnel Services 52700 Professional & Specialized Svc 0 130,000 130,000 Non-Personnel Services 0 130,000 130,000
Summary 0 329,088 329,088
Position Change
Organization Proposal Indicator RefCode Position Title Count Total Request
Justification
PUB1103 -
PUB1103
ITS
(267662)
56 -
SFPUC
Cyber
Security
AN 1054 IS
Business
Analyst-
Principal
1 135,434 Position is to support the CISO. Currently the security team is staffed by the CISO and 1 1042, this will allow the work to be done without taking resources from TechOps. Provide support on records request - both internal and sunshine requests. This position will support External Affairs and enterprises in gathering information for Records Requests. This resource will help drive the organization to meeting its impeccable stewardship goals and maintain service levels. The current Security team for the PUC is 2.0 FTE - this is not sufficient.

Position Total 1 135,434
Professional Services
Organization Proposal Contractor Hourly Total
Request
Purpose
PUB1103 -
PUB1103
ITS
(267662)
56 -
SFPUC
Cyber
Security
Technology
Store
Contract
200 80,000 With the increasingly complex business environment and threat landscape, it has become essential to identify, assess and manage risks more holistically. Risk is inherent as organizations deal with products, services, processes, systems, technologies, vendors, people and more. Risks arising from any of these can cause business disruption, impacting strategic objectives and resulting in financial losses and reputational
damage.

Risk
Management
(ServiceNOW)
--Implementation
Services
(one-time)
56 -
SFPUC
Technology
Store
200 50,000 Web browsers and email clients are very common points of entry for attackers because of their direct interaction with users inside an enterprise. Content can be crafted to entice or spoof users into disclosing credentials, providing sensitive data, or providing an open C12
Budget Request Summary by Proposal
Fiscal Year: 2022-23
Organization: PUB1103 - PUB1103 ITS (267662)
Proposal: 56 - SFPUC Cyber Security
Organization Proposal Contractor Hourly Total
Request
Purpose
PUB1103 -
PUB1103
ITS
(267662)
Cyber
Security
Contract channel to allow attackers to gain access, thus increasing risk to the enterprise. Since email and web are the main means that users interact
with
external
and
untrusted
users
and
environments,
these
are
prime
targets
for
both
malicious
code
and
social
engineering.

Secure
Messaging
--Extend
Controls
to
MS
Teams
--Email
(DMARK,
DKIM,
SPF)
SFPUC
Control
#9
-
CIS
Top
20/NIST
Alignment
City-wide
Alignment
(DT's
Avanan
Solution)
Extend
Cyber
Security
Controls
to
MS
Teams
Anticipate: City-wide Requirement: DMARK, DKIM, SFPUC (ongoing) Professional Services Total 130,000
C13
Budget Request Summary by Proposal
Fiscal Year: 2023-24
Organization: PUB1103 - PUB1103 ITS (267662)
Proposal: 56 - SFPUC Cyber Security
Fund/Dept/Auth/Proj/Act: 27180/267643/10000/10026776/0001 This work is to support the SFPUC's security team and improve overall security of the PUC's systems and assets. Many of the requests are in response to the Mayor's Office directives and/or the CISO's security plan. These requests also respond to areas for increasing maturity based on the Gartner assessments.

Account Lvl3 Account Base Budget Total Request Change
Non-Personnel Services 52700 Professional & Specialized Svc 0 15,000 15,000 53500 Other Current Expenses 0 434,000 434,000
Non-Personnel Services 0 449,000 449,000
Summary 0 449,000 449,000
Professional Services
Organization Proposal Contractor Hourly Total
Request
Purpose
PUB1103 - PUB1103
ITS (267662)
56 - SFPUC
Cyber Security
Technology
Store Contract
200 15,000 Dragos
Neighborhood
Watch
--Continues
Monitoring
&
Alerting
--WWE
DCS
(Enhance
DB-126
Project)

SFPUC
Control
#13
-
CIS
Top
20/NIST
Alignment
Support
Executive
Directive
21-02
(Cyber
Security)
--#2
Continues
Monitoring
&
Alerting
--Mayor's
Top
3 Cyber
Security
Priorities
Support
President
Joe
Biden
--Executive
Order
14028
on
Improving
Nations
Cyber
Security
--Cyber
Security
Critical
Infrastructure
Control
System
Bill
(ongoing)
We cannot rely on network defenses to be perfect. Adversaries continue to evolve and mature, as they share, or sell, information among their community on exploits and bypasses to security controls.

Professional Services Total 15,000
Other Objects
Organization Proposal Account Total
Request
Justification
PUB1103 - PUB1103
ITS (267662)
56 - SFPUC
Cyber Security
535960 Software
Licensing Fees
434,000 154K
-
licensing
(ongoing)
costs
for
ServiceNOW
asset
management
and
performance
analytics
80K - A complete software inventory is a critical foundation for preventing attacks. Attackers continuously scan target enterprises
looking
for
vulnerable
versions
of
software
that
can
be
remotely
exploited
Software
Asset
Management
(ServiceNOW)
--Licenses
Performance
Analytics
(ServiceNOW)
C14
Budget Request Summary by Proposal
Fiscal Year: 2023-24
Organization: PUB1103 - PUB1103 ITS (267662)
Proposal: 56 - SFPUC Cyber Security
Organization Proposal Account Total
Request
Justification
--Licenses
Software
Asset
Management
(ServiceNOW)
--Implementation
Services
SFPUC
Control
#2
-
CIS
Top
20/NIST
Alignment
--Manage
Obsolete
Software
(End
of
Life)
--Manage
Procured,
but
unused
Software

(portion
is
ongoing)
A complete software inventory is a critical foundation for preventing attacks. Attackers continuously scan target enterprises looking
for
vulnerable
versions
of
software
that
can
be
remotely
exploited.
200K
-
Dragos
Platform
--Transition
Neighborhood
Keeper
->
Platform
--Dept.

Energy
Subsidy
Ends

Other Objects Total 434,000
C15
Budget Request Summary by Proposal
Fiscal Year: 2022-23
Organization: PUB1103 - PUB1103 ITS (267662)
Proposal: 57 - ITS Positions True-Up
Fund/Dept/Auth/Proj/Act: 27180/267643/10000/10026776/0001 ITS admin budget position to provide support in the development and management of the budget and DT work order. ITS manages the DT workorder for all of the SFPUC. Add as an off budget position. Truing up 3 temp positions that are currently performing work that will be a part of SFPUC operations related to ITS budget work and the Radio project that will need long-term staffing to support. ITS has centralized IT procurement for all of SFPUC to ensure purchases are made in support of the organization as a whole. There have been added burdens in eSettlements invoicing, vendor cyber risk assessments and processes from OCA. More equipment has software embedded increasing the volume of IT procurements. ITS also does the IT related contracting for PUC. The radio project will be complete -moving from a project staff of 3 to an ongoing staff of 2 to keep the system operational.

Account Lvl3 Account Base Budget Total Request Change
Capital Outlay 56000 Equipment Purchase 0 71,736 71,736 Capital Outlay 0 71,736 71,736
Labor 50100 Permanent Salaries-Misc. 0 0 0
Labor 0 0 0
Mandatory Fringe Benefits Mandatory Fringe Benefits 0 0 0 Mandatory Fringe Benefits 0 0 0
Non-Personnel Services 53000 Rents & Leases-Buildings & Str 0 -71,736 -71,736 Non-Personnel Services 0 -71,736 -71,736
Summary 0 0 0
Position Change
Organization Proposal Indicator RefCode Position Title Count Total Request
Justification
PUB1103 -
PUB1103 ITS
(267662)
57 - ITS
Positions
True-Up
AN 1823 Senior
Administrative
Analyst
1 98,737 ITS admin budget position to provide support in the development and management of the budget and DT work order. ITS manages the DT workorder for all of the SFPUC. Add as an off budget position.
57 - ITS
Positions
True-Up
A 9993M Attrition
Savings -
Miscellaneous
0 -98,737
This entry offsets the new requested operating position.

Position Total 1 0
Equipment
Organization Proposal Equipment
No
Equipment
Ind
Item Title Quantity Total Accessories
Cost
Total
Request
Justification
PUB1103 -
PUB1103 ITS
(267662)
57 - ITS
Positions
True-Up
UC2313 N Ford F-150 (V6, 3.3L) (Gas)1/2
Ton Extended Cab 4x4 Pickup

6.5' Box (SB)
2 71,736 0 71,736 Two (2) 4X4 vehicles for the radio project team. Currently we are renting vehicles for the 0923 and 7368. They each need a vehicle to access radio sites.

C16
Budget Request Summary by Proposal
Fiscal Year: 2022-23
Organization: PUB1103 - PUB1103 ITS (267662)
Proposal: 57 - ITS Positions True-Up
Organization Proposal Equipment
No
Equipment
Ind
Item Title Quantity Total Accessories
Cost
Total
Request
Justification
Equipment Total 71,736 71,736
Other Objects
Organization Proposal Account Total Request Justification PUB1103 - PUB1103 ITS (267662) 57 - ITS Positions True-Up 530000 Rents-Leases-Bldgs&Struct-Bdgt -71,736 ONE TIME SAVINGS - currently funded through rental vehicles.

Other Objects Total -71,736
C17
Budget Request Summary by Proposal
Fiscal Year: 2023-24
Organization: PUB1103 - PUB1103 ITS (267662)
Proposal: 57 - ITS Positions True-Up
Fund/Dept/Auth/Proj/Act: 27180/267643/10000/10026776/0001 ITS admin budget position to provide support in the development and management of the budget and DT work order. ITS manages the DT workorder for all of the SFPUC. Add as an off budget position. Truing up 3 temp positions that are currently performing work that will be a part of SFPUC operations related to ITS budget work and the Radio project that will need long-term staffing to support. ITS has centralized IT procurement for all of SFPUC to ensure purchases are made in support of the organization as a whole. There have been added burdens in eSettlements invoicing, vendor cyber risk assessments and processes from OCA. More equipment has software embedded increasing the volume of IT procurements. ITS also does the IT related contracting for PUC. The radio project will be complete -moving from a project staff of 3 to an ongoing staff of 2 to keep the system operational.

Account Lvl3 Account Base Budget Total Request Change
Labor 50100 Permanent Salaries-Misc. 0 267,349 267,349
Labor 0 267,349 267,349
Mandatory Fringe Benefits Mandatory Fringe Benefits 0 125,654 125,654 Mandatory Fringe Benefits 0 125,654 125,654
Summary 0 393,003 393,003
Position Change
Organization Proposal Indicator RefCode Position Title Count Total Request
Justification
PUB1103 -
PUB1103 ITS
(267662)
57 - ITS
Positions
True-Up
AN 0931 Manager III 1 136,941 ITS Radio Project manager, temp position started January 2021, move from off budget and to on budget.
57 - ITS
Positions
True-Up
AN 7368 Senior
Communications
Systems Technician
1 130,409 TS Radio Project senior technician, temp position started January 2021, move from off budget and to on budget.
57 - ITS
Positions
True-Up
AN 1820 Junior Administrative
Analyst
1 66,521 ITS admin position support CIO and unit on DPL work, CIO assistant, invoicing, back up on procurement - assist in volume of IT procurements, esettlements invoicing 57 - ITS
Positions
True-Up
A 9993M Attrition Savings -
Miscellaneous
0 -66,522
Position Total 3 267,349
This amount reflects offsetting the 1820 Junior Admin position.

C18
Budget Request Summary by Proposal
Fiscal Year: 2023-24
Organization: PUB1103 - PUB1103 ITS (267662)
Proposal: 58 - Data Maturity Initiative
Fund/Dept/Auth/Proj/Act: 27180/267643/10000/10026776/0001 To increase awareness, understanding and availability of data throughout the organization to support strategic decision making. This proposal is not a technology project, rather a strategic business initiative that is supported by technology and geared for strong business engagement and change management that are essential components for Agency-wide success. The recommendation is for SIC to lead and drive the project (partnering with ITS) to define business needs, level of effort and road map. Technology decisions, implementation and support will then be led and driven by ITS. This approach will begin with a study to identify & prioritize data/business needs across SFPUC stakeholders. Inventory existing data sources & identify metrics, processes
&
technologies
for
data-reliant
areas
such
as:

Account Lvl3 Account Base Budget Total Request Change
Labor 50100 Permanent Salaries-Misc. 0 133,102 133,102
Labor 0 133,102 133,102
Mandatory Fringe Benefits Mandatory Fringe Benefits 0 62,558 62,558 Mandatory Fringe Benefits 0 62,558 62,558
Non-Personnel Services 52700 Professional & Specialized Svc 0 250,000 250,000 Non-Personnel Services 0 250,000 250,000
Summary 0 445,660 445,660
Position Change
Organization Proposal Indicator RefCode Position Title Count Total Request
Justification
PUB1103 - PUB1103
ITS (267662)
58 - Data
Maturity
Initiative
AN 1043 IS
Engineer-
Senior
1 133,102 This request is to support the implementation of the data maturity initiative to modernize the SFPUC agency-wide business intelligence approach.

Position Total 1 133,102
Professional Services
Organization Proposal Contractor Hourly Total
Request
Purpose
PUB1103 -
PUB1103 ITS
(267662)
58 - Data
Maturity
Initiative
TBD 100 250,000 This request is to fund the purchase and licensing of business intelligence systems supporting the SFPUC data maturity initiative to modernize the SFPUC agency-wide business intelligence approach. (ongoing) Professional Services Total 250,000
C19

CleanPowerSF Sfpuc CommissionJanuary 7, 2022

CleanPowerSF Sfpuc Commission
January 7, 2022