Services of the San Francisco Public Utilities Commission January 22, 2023
Nancy L. Hom, CFO and AGM Business Services
Business Services
FY 2024-25 and FY 2025-26 Proposed Budget
Business Services Bureaus
2 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 Management
• 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 Strategy
• Budget
• Financial Planning and Rates
• Capital Finance
• Fleet Management
Strategy, Innovation &
Change
• Strategy and
Business Planning
• Project Leadership
and Change
Management
• Risk Management
107 74
90 8
Audit
• Governance & Audits
• Internal Controls
5 This headcount is for FY 25-26 and includes attrition savings Loans & Grants
3 • Federal and state
loans and grants
Business Services Organization
3 Nancy L. Hom
Chief Financial Officer/
AGM Business Services
0955
Jennifer S. Hopkins
Chief Information Officer
0943
90 Vivian Aiyi Chen
Deputy CFO
Accounting & Financial
Reporting
0941
74 Laura Busch
Deputy CFO
Financial Strategy
0941
Deidre Andrus
Customer Services
Director
0941
Tricia Yang
Strategy, Innovation &
Change Director
0941
Alexandra Gunnell
Loans & Grants Director
0933
Irella Blackwood
Audit Director
0933
107 8 3 5
-
20.0 40.0
60.0 80.0
100.0
120.0
FY 2023-24 FY 2024-25 FY 2025-26
Personnel Non-Personnel Costs
Materials & Supplies Equipment
Services of Other Dept Overhead (COWCAP)
Business Services, Budget Growth Overview
4 $91.8M $96.1M $98.4M
COWCAP, 6.9%
AGM, 0.6%
STRATEGY
INNOVATION &
CHANGE, 1.9%
CUSTOMER
SERVICES,
20.4%
ITS, 42.9%
FINANCE,
24.5%
AUDIT,
2.9%
FY 2024-25 Budget by Division
How is Business Services Addressing Budget Priorities
toCreate a Utility of the Future?
5 Affordability
Adopted affordability policy
for Water and Wastewater
Efficient capital planning
Responsible
Management
Addressing Regulatory
Requirements
Financial Sustainability
Workforce: Reducing
vacancies, increasing retention
Accountability: Racial Equity
and Transparency
Responsible management of
our system, maintenance
Investing
Where it
Matters
Contributing to economic
vitality; capital investment and,
job creation
Replacing aging infrastructure
Meeting new customer
demands
Environmental stewardship
Resilience and climate change
Business Services: New Proposals Summary
6 $million FY 24-25 FY 25-26
Labor 5.4 5.4
Non Labor 2.0 2.1
Programmatic (IT) 1.1 2.0
Salary savings (4.8) (6.4)
Total 3.7 3.1
• 12 new positions, 2 of which are off-
budget positions
• 21 TEX to PCS conversions
• 19 substitutions
• Non-Labor requests include
• Capital Finance support
• IT requests including support for
cybersecurity, application upgrades,
server and network maintenance,
SCADA upgrade, disaster recovery
• IT also has $1.4M in capital project
requests
Accounting& Fin. Reporting: New Proposals
7 # $ Explanation
TEX to PCS 5 564,825 To convert core TEX Cat. 18 staff in accounting to permanent roles to promote retention in critical processing roles
New 1657 1 202,781 State and Federal grants, cost recovery – expanded processing/reporting requirements New 1822 1 139,825 Lead Procurement support to liaise with enterprise/bureau divisions and OCA.
New 1824 1 245,051 To support the capital accounting team whose scope and complexity has continue to expand given the growing size of SFPUC’s capital plan
Substitutions 9 183,893 To align with filled class and/or expanded and more complex duties performed Offsetting reductions - (96,547) Increase attrition savings to account for 5 temp-perms, and right-size attrition to account for historic deficit in finance salary budget
Total 1,239,828
Accounting Services, Financial Reporting & Analysis (Vivian Ai Yi Chen) Financial Strategy: New Proposals (cont’d)
8 # $ Explanation
TEX to PCS 2 325,914 To convert core TEX Cat. 18 staff in debt team to permanent to promote retention New 1825 1 222,604 Expanded scope in financial planning, need for senior data analyst for forecasting New 0923 1 203,017 Expanded scope in financial planning, split rates manager responsibilities between 2 staff, one for Power and one for Water/Wastewater
Substitutions 6 (47,153) To align with filled class and/or duties performed Non labor - 325,000 Increased scope for debt advisors (MAs) and purchase of DBC software, industry standard for bond analysis and equipment for fuel monitoring (one time) Offsetting reductions - (312,870)
Increase attrition savings to account for 2 temp-perms and reduction of a further temp position as substitution repurposes existing position to create PCS role, and rightsized attrition
Total 716,512
Budget, Rates, Financial Planning, Capital Finance, Fleet (Laura Busch) Loans & Grants, SIC: New Proposals (cont’d)
9 # $ Explanation
New 0931 1 - OFF BUDGET. needed to support development of in-house bureau, manage existing consultant contract and new 1824.
New 1824 1 - OFF BUDGET. Needed to continue to transition responsibility from consultant to in- house bureau responsible for administering SFPUC's loans and grants.
Total -
Loans and Grants (Alexandra Gunnell)
# $ Explanation
Substitutions 1 24,209 Convert 0933 to 0941
Offsetting reductions - (122,045) Right-size attrition
Total (97,836)
Strategy Innovation and Change (Tricia Yang)
Audit and CSB: New Proposals cont’d
10 # $ Explanation
New 1478 1 111,701 The position will support Hydrant Meter Rules and Regulations Substitutions 1 63,651 Convert vacant 1466 position to needed 1052 Offsetting reductions - (1,733,232) Right-size attrition Total (1,557,880)
Customer Services (Deidre Andrus)
# $ Explanation
New 1823 2 325,914 Expanded scope of Audit Bureau, needed to support workload and deliverables Substitutions 2 58,587 Convert 1823 to 1824 & 0932 to 0933 Offsetting reductions - (147,000) Right-size attrition
Total 237,501
Audit (Irella Blackwood)
ITS New Proposal cont’d
11 FY 24-25 FY25-26
Disaster Recovery 125,000 125,000
Phone Migration 100,000 290,000
Maximo Upgrade 325,000 325,000
Cybersecurity 400,000 400,000
Network/server Maintenance 250,000 250,000
SCADA Infrastructure upgrade 326,337 326,337
Travel and Training 100,000 100,000
Programmatic Request (Phones, SFPUC.gov,
cybersecurity and 525 conference rooms) 1,097,041 897,041 Total 2,723,378 2,713,378
Non-Labor Request
ITS (Jennifer Hopkins)
# $ Explanation
TEX to PCS 14 2,539,243 To convert core TEX Cat. 18 staff in to permanent to promote retention New 7318 1 172,528 This position is to support critical SCADA AWSS, radio, and microwave systems. Currently, there is no backup radio communications person in SCADA New 1825 1 222,604 To support IT projects and related-procurements in the budget such as MAXIMO, SCADA, DBC and Questica
Offsetting reductions - (2,648,128) Increase attrition savings to account for 14 temp-perms and right-size attrition Total 286,247
+ $1.4M in capital
projects for
upgrades to
• SCADA
• Maximo
• Network/Servers
Business Services Growth Drivers
• Major growth drivers
are overall COLA
increases and new
proposals in IT and
Finance
• Most new labor costs
have been offset by
salary savings
adjustments
12 ($ Millions) Total Budget Change $ Change %
FY 2023-24 Adopted 91.8
Labor & Benefits Base COLA Adjustment 1.8
Accounting Staff Support 1.3
Financial Strategy Staff Support 1.0
ITS Staff Support 2.8
Cybersecurity 0.4
Maximo Application 0.3
SCADA Infrastucture Upgrade 0.5
Network and Server Maintenance 0.6
CSB Customer Acct 0.2
Audit Bureau Staff Support 0.4
Offsetting increase in Salary Savings (4.8)
FY 2024-25 Request 96.1 4.4 5% Labor & Benefits Base COLA Adjustment 3.7
Other Requests 0.1
Offsetting increase in Salary Savings (1.5)
FY 2025-26 Request 98.4 2.3 2% Business Position Changes
• 33 new positions, 21 of which are temp-perm conversions and 2 are off budget
• Most position changes are in IT and Finance
13 Total "Operating" "Project" Change %
FY 2023-24 Adopted 300
New Requests 12 10 2
Temporary to Permanent 21 21 -
Offsetting increase in Salary Savings (24) (24) - FY 2024-25 Request 309 7 2 3% FY 2025-26 Request 309 - - 0% Position Type
Q & A
14 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 2023‐24
Adopted
FY 2024‐25
Request
FY 2024‐25
versus
FY 2023‐24
FY 2025‐26
Request
FY 2025‐26
versus
FY 2024‐25
Labor 40,248,821 42,008,579 4.4% 43,748,633 4.1%
Mandatory Fringe Benefits 14,164,090 14,563,333 2.8% 14,974,639 2.8% Non‐Personnel Services 14,317,277 15,801,284 10.4% 16,022,495 1.4% Materials & Supplies 1,800,145 2,217,810 23.2% 2,212,599 ‐0.2% Capital Outlay 1,007,477 1,173,358 16.5% 1,022,425 ‐12.9% Overhead 6,980,503 6,980,503 ‐ 6,980,503 ‐
Services of Other Departments 13,239,387 13,396,619 1.2% 13,396,619 0.0% Grand Total 91,757,700 96,141,486 4.8% 98,357,913 2.3%
Category
FY 2023‐24
Adopted
FY 2024‐25
Request
FY 2024‐25
versus
FY 2023‐24
FY 2025‐26
Request
FY 2025‐26
versus
FY 2024‐25
Full‐Time 299.53 325.64 26.11 332.53 6.89 Off‐Budget (12.00) (12.58) (0.58) (13.00) (0.42) Total Positions 287.53 313.06 25.53 319.53 6.47 Attrition (21.70) (48.92) (27.22) (57.69) (8.77) Grand Total 265.83 264.14 (1.69) 261.84 (2.30) BUSINESS SERVICES
OPERATING BUDGET BY CATEGORY
POSITION SUMMARY
Appendix A
A1
Business Services Appendix
B. Position Change Summary
Appendix B
Business Services FY 2024‐25 Position Changes
Indicator Position Position Title Admin Accounting Budget Fleet ITS
Admin
ITS
Cyber
Security
ITS
App &
System
ITS
Ops Tech
& Inf
Loans &
Grants
CSB
Bus Ctr
CSB
Cust Acct
CSB
Field Svc
CSB
Bus & Sys
CSB
Cust
Contract Audit SIC
Grand
Total
AN 0923 Manager II 1 1
1042 IS Engineer‐Journey 1 1
1044 IS Engineer‐Principal 1 1
1070 IS Project Director 31 4
1092 IT Operations Support Administrator II 1 1
1478 Utility Services Representative 11
1632 Senior Account Clerk 3 3
1634 Principal Account Clerk 2 2
1657 Accountant IV 1 1
1822 Administrative Analyst 1 1 2
1823 Senior Administrative Analyst 2 24
1824 Principal Administrative Analyst 1 1 2
1825 Principal Administrative Analyst II 1 1 2
1844 Senior Management Assistant 1 1
7318 Electronic Maintenance Technician 1 1
7368 Senior Communications Systems Technician 1 1
1091 IT Operations Support Administrator I 3 3
ON 0931 Manager III 1 1
1824 Principal Administrative Analyst 1 1
AR 0922 Manager I 1 ‐10
0941 Manager VI ‐4121 0
1041 IS Engineer‐Assistant ‐32 1 0
1042 IS Engineer‐Journey ‐10 3 7 0
1043 IS Engineer‐Senior ‐21 6 15 0
1044 IS Engineer‐Principal ‐18 10 8 0
1052 IS Business Analyst ‐11 0
1053 IS Business Analyst‐Senior ‐33 0
1054 IS Business Analyst‐Principal ‐715 ‐1
1063 IS Programmer Analyst‐Senior ‐22 0
1070 IS Project Director ‐33 0
1092 IT Operations Support Administrator II ‐22 0
1093 IT Operations Support Administrator III ‐11 0
1094 IT Operations Support Administrator IV ‐55 0
1480 Utility Services Representative Supervisor ‐11 0
1822 Administrative Analyst 1 1
1842 Management Assistant 1 ‐1 0
4310 Commercial Division Assistant Supervisor ‐22 0
5203 Assistant Engineer ‐11 0
5211 Engineer/Architect/Landscape Architect Senior ‐11 0 5212 Engineer/Architect Principal ‐11 0
OR 0931 Manager III ‐11 0
0933 Manager V ‐1 1 0
1053 IS Business Analyst‐Senior ‐22 0
1823 Senior Administrative Analyst ‐11 0
5602 Utility Specialist ‐11 0
AS 0923 Manager II ‐1 ‐1
0931 Manager III 2 2
0932 Manager IV ‐1 ‐1 ‐2
0933 Manager V 1 ‐10
0941 Manager VI 11
1052 IS Business Analyst 11
B1
Indicator Position Position Title Admin Accounting Budget Fleet ITS
Admin
ITS
Cyber
Security
ITS
App &
System
ITS
Ops Tech
& Inf
Loans &
Grants
CSB
Bus Ctr
CSB
Cust Acct
CSB
Field Svc
CSB
Bus & Sys
CSB
Cust
Contract Audit SIC
Grand
Total
AS 1466 Meter Reader ‐1 ‐1
1825 Principal Administrative Analyst II ‐31 ‐2
5602 Utility Specialist ‐1 ‐1
1670 Financial Systems Supervisor 3 3
AT 1632 Senior Account Clerk ‐3 ‐3
1634 Principal Account Clerk 3 3
1652 Accountant II ‐2 ‐2
1654 Accountant III 1 1
1822 Administrative Analyst 1 1 2
1823 Senior Administrative Analyst ‐11 0
1824 Principal Administrative Analyst 1 ‐2 ‐1
1842 Management Assistant ‐1 ‐1
1844 Senior Management Assistant 1 1
Grand Total ‐19 5 ‐1 ‐77 5 37 50 3 ‐7009 ‐12 0 3 3
AN Operating New Position
ON Off ‐budget New Position
AR Operating Position Reassignment
OR Off ‐budget Position Reassignment
AS Operating Position Substitution
AT Position substitution used to identify an existing TX'd position(Operating budget) B2
Appendix B
Business Services FY 2025‐26 Position Changes
Indicator Position Position Title Audit Grand Total
AS 1823 Senior Administrative Analyst ‐1 ‐1
1824 Principal Administrative Analyst 1 1
Grand Total 0 0
AS Operating Position Substitution
B3
Business Services Appendix
C. New Proposals
Appendix C
Business Services New Proposals
Division Proposal Operating Off-Budget Request Operating Off-Budget Request Accounting 30 FS Accounting Right-Sizing Budget 8 - 1,280,011 - - - Financial Strategy 45 FS Financial Planning Team Support 2 - 307,911 - - - 46 FS Capital Finance Team Support 2 - 511,390 - - - Fleet 160 Fuel Hardware System Upgrade - - 165,000 - - - ITS Administration 102 Disaster Recovery - - 125,000 - - - 103 Phone Migration - - 100,000 - - 190,000
104 Travel and Training Increase - - 100,000 - - - 105 Upgrade of Maximo to Maximo Application Suite - - 325,000 - - - 107 Cybersecurity Improvements - - 400,000 - - -
108 Network and Server Maintenance - - 250,000 - - - 109 SCADA Infrastructure Upgrade 1 - 498,865 - - - 112 TEMP to Permanent Conversion 3 - 627,189 - - - 113 TEMP to Permanent Conversion 6 - 885,215 - - - 114 TEMP to Permanent Conversion 6 - 1,249,443 - - - Loans and Grants 47 Loans & Grants Support - 2 - - - - CSB Administation 61 Hydrant Meter Rules and Regulations 1 - 111,701 - - - 50 CSB Business & System Support - - 63,651 - - - Audit Bureau 48 Audit Bureau Support 2 - 349,932 - - - Grand Total 31 2 7,350,308 - - 190,000 FY 2024-25 FY 2025-26
C1
Budget Request Summary by Proposal
Fiscal Year: 2024-25
Organization: PUB110201 - PUB110201 Accounting (267641) Proposal: 30 - FS Accounting Right-Sizing Budget
Fund/Dept/Auth/Proj/Act: 27180/267641/10000/10026775/0001 This proposal is intended to right-size positions within the Accounting Services (AS) and Financial Reporting and Analysis (FRA) operating budget by increasing its base to reflect a combination of TXed
positions,
position
substitutions,
new
positions,
and
temporary
to
permanent
civil
service
positions.
Since the COVID-19 pandemic in FY 2019-20, AS/FRA headcount has remained relatively flat at 50 FTE while the work has significantly increased in both volume and complexity. AS and FRA are involved in every financial transaction that makes up the $1.65 billion adopted operating budget and $1.03 billion capital budget/programmatic projects for FY 2022-23. In the same fiscal year, 9,018 purchase orders were approved worth over $816 million, representing 9.0% and 13.9% of citywide totals, respectively. Further, 39,804 vouchers were processed worth over $1.84 billion, representing
9.1%
and
13.6%
of
citywide
totals,
respectively.
AS and FRA have historically exceeded its budget by over $500K in temporary salaries to meet its operational needs. The proposal is to move away from Temp Salaries and put in PCS positions to ensure retention and stabilization and accurate reflection/rightsizing of actual personnel resources capacity needed to sustain accounting service operations, reduce overtime of all existing permanent staff. Currently, AS has total 7 temp positions, including 5, 1632 Cat 18 positions and 2, 9922 positions. Temp positions have had high turnover. We are requesting to convert all 1632 temp positions to perm for retention and stability.
Account Lvl3 Account Base Budget Total Request Change
Labor 50100 Permanent Salaries-Misc. 0 870,756 870,756
Labor 0 870,756 870,756
Mandatory Fringe Benefits Mandatory Fringe Benefits 0 409,255 409,255 Mandatory Fringe Benefits 0 409,255 409,255
Summary 0 1,280,011 1,280,011
Position Change
Organization Proposal Indicator RefCode Position Title Count Total Request
Justification
PUB110201
-
PUB110201
Accounting
(267641)
30 - FS
Accounting
Right-
Sizing
Budget
AT PUB25130 1823 Senior
Administrative
Analyst
-1 -143,968 This position substitution is to align the working class with the budgeted class to reflect actual job duties performed. The working classes were approved to be TXed up in FY 2022-23 and FY 2023-24 to align with the needs of the division. Accounting Services has expanded in both organization and services to meet the policies and guidelines implemented by the Controller's Office and Governmental Accounting Standards Board (GASB). This requires a higher-level skillset and capacity to support increased complexity and volume of financial transactions, analysis, end- user/peer-to-peer training, reconciliation, and due diligence. 30 - FS
Accounting
Right-
Sizing
Budget
AT PUB25130 1824 Principal
Administrative
Analyst
1 166,701 This position substitution is to align the working class with the budgeted class to reflect actual job duties performed. The working classes were approved to be TXed up in FY 2022-23 and FY 2023-24 to align with the needs of the division. Accounting Services has expanded in both organization and services to meet the policies and guidelines implemented by the Controller's Office and Governmental Accounting Standards Board (GASB). This requires a higher-level skillset and capacity to support increased complexity and volume of financial transactions, analysis, end- user/peer-to-peer training, reconciliation, and due diligence. 30 - FS
Accounting
Right-
AT PUB25132 1632 Senior
Account Clerk
-3 -284,621 This position substitution is to align the working class with the budgeted class to reflect actual job duties performed. The working classes were approved to be TXed up in FY 2022-23 and FY 2023-24 to align with the needs of the division. Accounting Services has expanded in both Dec 22, 2023 1 of 4 10:47:51 AM
C2
Budget Request Summary by Proposal
Fiscal Year: 2024-25
Organization: PUB110201 - PUB110201 Accounting (267641) Proposal: 30 - FS Accounting Right-Sizing Budget
Organization Proposal Indicator RefCode Position Title Count Total Request
Justification
PUB110201
-
PUB110201
Accounting
(267641)
Sizing
Budget
organization and services to meet the policies and guidelines implemented by the Controller's Office and Governmental Accounting Standards Board (GASB). This requires a higher-level skillset and capacity to support increased complexity and volume of financial transactions, analysis, end- user/peer-to-peer training, reconciliation, and due diligence. 30 - FS
Accounting
Right-
Sizing
Budget
AT PUB25132 1634 Principal
Account Clerk
3 321,578 This position substitution is to align the working class with the budgeted class to reflect actual job duties performed. The working classes were approved to be TXed up in FY 2022-23 and FY 2023-24 to align with the needs of the division. Accounting Services has expanded in both organization and services to meet the policies and guidelines implemented by the Controller's Office and Governmental Accounting Standards Board (GASB). This requires a higher-level skillset and capacity to support increased complexity and volume of financial transactions, analysis, end- user/peer-to-peer training, reconciliation, and due diligence. 30 - FS
Accounting
Right-
Sizing
Budget
AS PUB25133 1825 Principal
Administrative
Analyst II
-3 -589,991 The position substitution is to align the budgeted class with actual job duties performed. It represents a $11.4K or 6.1% increase per position. Positions in this role serve as managers reporting to AS/FRA managers. They are responsible for an entire function of one or more enterprise funds with little to no directions. Classifications in this role have not been adjusted since PeopleSoft was implemented in 2017, which increased responsibilities of this role in both complexity and scope. Incumbents are responsible for the financial management information system (PeopleSoft) impact of the areas they manage in addition to the technical aspects of developing/maintaining fiscal policies, procedures, and analyses. The substitution is necessary to acquire and retain top talent, as well as maintain parity with other City departments that have a comparable function/scope. The substitution will allow SFPUC to keep the institutional knowledge cultivated over the years, yielding efficiencies that ultimately results in ratepayer savings. 30 - FS
Accounting
Right-
Sizing
Budget
AS PUB25133 1670 Financial
Systems
Supervisor
3 625,774 The position substitution is to align the budgeted class with actual job duties performed. It represents a $11.4K or 6.1% increase per position. Positions in this role serve as managers reporting to AS/FRA managers. They are responsible for an entire function of one or more enterprise funds with little to no directions. Classifications in this role have not been adjusted since PeopleSoft was implemented in 2017, which increased responsibilities of this role in both complexity and scope. Incumbents are responsible for the financial management information system (PeopleSoft) impact of the areas they manage in addition to the technical aspects of developing/maintaining fiscal policies, procedures, and analyses. The substitution is necessary to acquire and retain top talent, as well as maintain parity with other City departments that have a comparable function/scope. The substitution will allow SFPUC to keep the institutional knowledge cultivated over the years, yielding efficiencies that ultimately results in ratepayer savings. 30 - FS
Accounting
Right-
Sizing
Budget
AN 1632 Senior
Account Clerk
3 219,158 (Cat 18 to perm) This is to convert 3 positions currently appointed as Category 18 to permanent civil service. This is to move away from Temp Salaries and put in PCS positions to ensure retention and stabilization and accurate reflection/rightsizing of actual personnel resources capacity needed to sustain accounting service operations, reduce overtime of all existing permanent
staff.
These positions are critical to accounting operations to ensure that transactions are processed Dec 22, 2023 2 of 4 10:47:51 AM
C3
Budget Request Summary by Proposal
Fiscal Year: 2024-25
Organization: PUB110201 - PUB110201 Accounting (267641) Proposal: 30 - FS Accounting Right-Sizing Budget
Organization Proposal Indicator RefCode Position Title Count Total Request
Justification
PUB110201
-
PUB110201
Accounting
(267641)
timely, accurately, and comply with applicable local, state, and federal guidelines. 30 - FS
Accounting
Right-
Sizing
Budget
AN 1634 Principal
Account Clerk
2 165,077 (Cat 18 to perm) This converts 2 positions currently appointed as Category 18 to permanent civil service. This is to move away from Temp Salaries and put in PCS positions to ensure retention and stabilization and accurate reflection/rightsizing of actual personnel resources capacity needed to sustain accounting service operations, reduce overtime of all existing permanent staff. The positions
are
converted
to
1634
for
parity
with
other
positions
within
Accounting
Operations.
These positions are critical to accounting operations to ensure that transactions are processed timely, accurately, and comply with applicable local, state, and federal guidelines. 30 - FS
Accounting
Right-
Sizing
Budget
AN 1822 Administrative
Analyst
1 95,119 This position is necessary to cultivate a culture of excellence, focusing on consistency, efficiency, and compliance with local, state, and federal guidelines. Procurement is challenging to small divisions and/or divisions who procure on an ad-hoc or infrequent basis because of all the rules, regulations and compliance policies/procedures that must be followed. 30 - FS
Accounting
Right-
Sizing
Budget
AN 1657 Accountant IV 1 137,946 SFPUC is pursuing federal and state grants - emergency grants, state revolving fund (SRF) loans, Water Infrastructure Finance and Innovation Act (WIFIA) loans/grants, and SFPUC managed grants (Green Infrastructure Grant Program) to external recipients to diversity its funding sources and have less reliance on ratepayer funds. The number of grants and grants given to external recipients
have
increased
significantly,
totaling
$2.56
billion.
Each grant has its own administrative and reporting requirements, which makes it challenging to manage in a decentralized organizational structure. Further, SFPUC has experienced continuous and increased federal/state declared emergencies in recent years such as the March 2018 storms, August
2020
wildfires,
COVID-19
pandemic,
and
2023
Winter
Storms
(nearly
60 projects).
30 - FS
Accounting
Right-
Sizing
Budget
AT PUB25270 1652 Accountant II -1 -118,938 This position substitution is to align the working class with the budgeted class to reflect actual job duties performed. The working classes were approved to be TXed up in FY 2022-23 and FY 2023-24 to align with the needs of the division. Accounting Services has expanded in both organization and services to meet the policies and guidelines implemented by the Controller's Office and Governmental Accounting Standards Board (GASB). This requires a higher-level skillset and capacity to support increased complexity and volume of financial transactions, analysis, end- user/peer-to-peer training, reconciliation, and due diligence. 30 - FS
Accounting
Right-
Sizing
Budget
AT PUB25270 1654 Accountant
III
1 143,968 his position substitution is to align the working class with the budgeted class to reflect actual job duties performed. The working classes were approved to be TXed up in FY 2022-23 and FY 2023-24 to align with the needs of the division. Accounting Services has expanded in both organization and services to meet the policies and guidelines implemented by the Controller's Office and Governmental Accounting Standards Board (GASB). This requires a higher-level skillset and capacity to support increased complexity and volume of financial transactions, analysis, end- user/peer-to-peer training, reconciliation, and due diligence. 30 - FS AT PUB25271 1652 Accountant II -1 -118,938 This position substitution is to align the working class with the budgeted class to reflect actual job Dec 22, 2023 3 of 4 10:47:51 AM
C4
Budget Request Summary by Proposal
Fiscal Year: 2024-25
Organization: PUB110201 - PUB110201 Accounting (267641) Proposal: 30 - FS Accounting Right-Sizing Budget
Organization Proposal Indicator RefCode Position Title Count Total Request
Justification
PUB110201
-
PUB110201
Accounting
(267641)
Accounting
Right-
Sizing
Budget
duties performed. The working classes were approved to be TXed up in FY 2022-23 and FY 2023-24 to align with the needs of the division. Accounting Services has expanded in both organization and services to meet the policies and guidelines implemented by the Controller's Office and Governmental Accounting Standards Board (GASB). This requires a higher-level skillset and capacity to support increased complexity and volume of financial transactions, analysis, end- user/peer-to-peer training, reconciliation, and due diligence. 30 - FS
Accounting
Right-
Sizing
Budget
AT PUB25271 1822 Administrative
Analyst
1 123,531 This position substitution is to align the working class with the budgeted class to reflect actual job duties performed. The working classes were approved to be TXed up in FY 2022-23 and FY 2023-24 to align with the needs of the division. Accounting Services has expanded in both organization and services to meet the policies and guidelines implemented by the Controller's Office and Governmental Accounting Standards Board (GASB). This requires a higher-level skillset and capacity to support increased complexity and volume of financial transactions, analysis, end- user/peer-to-peer training, reconciliation, and due diligence. 30 - FS
Accounting
Right-
Sizing
Budget
AN 1824 Principal
Administrative
Analyst
1 128,360 This position will support the capital accounting team whose scope and complexity has, and will continue to expand given the growing size of SFPUC’s capital plan. In addition, this position will support grants accounting and support administration of SFPUC’s SRF and WFIA loans.
Position Total 8 870,756
Dec 22, 2023 4 of 4 10:47:51 AM
C5
Budget Request Summary by Proposal
Fiscal Year: 2024-25
Organization: PUB110202 - PUB110202 Budgets Rates (267642) Proposal: 45 - FS Financial Planning Team Support
Fund/Dept/Auth/Proj/Act: 27180/267642/10000/10026775/0002 Align to filled classifications and shore up financial planning capacity which has to keep pace with increasing complexity of workload and demands for team, as well as providing career paths to encourage retention.
Account Lvl3 Account Base Budget Total Request Change
Labor 50100 Permanent Salaries-Misc. 0 209,463 209,463
Labor 0 209,463 209,463
Mandatory Fringe Benefits Mandatory Fringe Benefits 0 98,448 98,448 Mandatory Fringe Benefits 0 98,448 98,448
Summary 0 307,911 307,911
Position Change
Organization Proposal Indicator RefCode Position Title Count Total Request
Justification
PUB110202
-
PUB110202
Budgets
Rates
(267642)
45 - FS
Financial
Planning
Team
Support
AS PUB25137 0932 Manager IV -1 -207,599 Rates Manager is budgeted as an 0932 but filled as an 0923. Convert to 0931 – still allows promotional path if needed from current level.
45 - FS
Financial
Planning
Team
Support
AS PUB25137 0931 Manager III 1 193,427 Rates Manager is budgeted as an 0932 but filled as an 0923. Convert to 0931 – still allows promotional path if needed from current level.
45 - FS
Financial
Planning
Team
Support
AT PUB25138 1824 Principal
Administrative
Analyst
-1 -166,701 Reflects need to permanently have a lower-level analyst position to create “pipeline” of positions upward.
45 - FS
Financial
Planning
Team
Support
AN 1825 Principal
Administrative
Analyst II
1 151,431 Significantly expanded scope and complexity of analysis for this team over the last several years.
Eg. large-scale comprehensive data analysis for complex capital projects and Power Enterprise, where forecasts need to be daily, if not monthly. Current workload is unmanageable for team and causing burnout issues. Also addresses retention issues by creating new role to allow for upward mobility.
45 - FS
Financial
Planning
Team
AT PUB25138 1822 Administrative
Analyst
1 123,531 Reflects need to permanently have a lower-level analyst position to create “pipeline” of positions upward.
Dec 22, 2023 1 of 2 10:45:46 AM
C6
Budget Request Summary by Proposal
Fiscal Year: 2024-25
Organization: PUB110202 - PUB110202 Budgets Rates (267642) Proposal: 45 - FS Financial Planning Team Support
Organization Proposal Indicator RefCode Position Title Count Total Request
Justification
PUB110202
-
PUB110202
Budgets
Rates
(267642)
Support
45 - FS
Financial
Planning
Team
Support
AT PUB25177 1824 Principal
Administrative
Analyst
-1 -166,701 To align with the filled class (currently approved as a tx) and ensure pipeline of positions in 18-- series within the financial planning team.
45 - FS
Financial
Planning
Team
Support
AT PUB25177 1823 Senior
Administrative
Analyst
1 143,968 To align with the filled class (currently approved as a tx) and ensure pipeline of positions in 18-- series within the financial planning team.
45 - FS
Financial
Planning
Team
Support
AN 0923 Manager II 1 138,107 0923 in Financial Planning will bifurcate the existing rates manager position into an 0923 that administers Power and CleanPowerSF rates and an 0923 that handles Water and Wastewater rates.
This is needed because of the increase scope and complexity of rate setting across the 3 enterprises, which is now too much for a single manager to handle. Both positions will report to the 0933 Director of Financial Planning. For example, the financial planning team is now responsible for setting rates for Hetch Hetchy Power and CleanPowerSF, when previously these were tied to PG&E’s rates. Power rates are extraordinarily complex, requiring analyzing massive amounts of data. As the Power Enterprise’s customer base continues to expand, it is critical that the SFPUC have the capacity to responsibly administer rates given the increased workload and complexity now faced. In addition, the agency is faced with making major strategic financial decisions over a 20-50 year planning horizon that have billions of dollars of impact, and the Financial Planning team is increasingly being asked to provide analysis to support these decisions. For example, the team needs to forecast utility sales volumes to support decisions around what level of capital investments are needed in the long-term horizon to ensure the system meets expected population growth, while balancing the risk of incurring costs for existing customers today for future residents who may not materialize. The impact of this work touches on areas critical to the agency’s success in environmental, financial, and legal areas. Proper staffing and analysis today could save San Franciscans millions of dollars through more efficient and accurate financial strategy and planning.
This new position is to 1) provide additional management capacity for the team to support the expanded scope of work and 2) manage the newly proposed 1825 Data and forecasting manager who will in turn manage an 1824 and 1823. This position is part of an overall reorganization of the team to realign the reporting structure, clarify job responsibilities, and ensure Financial Planning is able to support the agency’s strategic financial planning goals.
Position Total 2 209,463
Dec 22, 2023 2 of 2 10:45:46 AM
C7
Budget Request Summary by Proposal
Fiscal Year: 2024-25
Organization: PUB110202 - PUB110202 Budgets Rates (267642) Proposal: 46 - FS Capital Finance Team Support
Fund/Dept/Auth/Proj/Act: 27180/267642/10000/10026775/0002 Align to filled classifications and convert 2 temporary employees performing core operational functions within the debt team to permanent positions to encourage retention.
Account Lvl3 Account Base Budget Total Request Change
Labor 50100 Permanent Salaries-Misc. 0 239,041 239,041
Labor 0 239,041 239,041
Mandatory Fringe Benefits Mandatory Fringe Benefits 0 112,349 112,349 Mandatory Fringe Benefits 0 112,349 112,349
Non-Personnel Services 52700 Professional & Specialized Svc 0 160,000 160,000 Non-Personnel Services 0 160,000 160,000
Summary 0 511,390 511,390
Position Change
Organization Proposal Indicator RefCode Position Title Count Total Request
Justification
PUB110202 -
PUB110202
Budgets Rates
(267642)
46 - FS
Capital
Finance
Team
Support
AS PUB25136 5602 Utility
Specialist
-1 -179,333 To align with the filled class (currently approved as a tx) 46 - FS
Capital
Finance
Team
Support
AS PUB25136 1825 Principal
Administrative
Analyst II
1 196,664 To
align
with
the
filled
class
(currently
approved
as
a
tx)
46 - FS
Capital
Finance
Team
Support
AN 1823 Senior
Administrative
Analyst
1 110,855 To move the core staff member to a permanent position, addressing retention and reflecting the staffing need of the Capital Finance team (managing $2bn annually in new issuances
and
over
$8bn
portfolio)
to
have
permanent
team
members.
46 - FS
Capital
Finance
Team
Support
AN 1823 Senior
Administrative
Analyst
1 110,855 To move the core staff member to a permanent position, addressing retention and reflecting the need of the Capital finance team (managing $2bn annually in new issuances and
over
$8bn
portfolio)
to
have
permanent
staff
members.
Position Total 2 239,041
Dec 4, 2023 1 of 2 11:10:31 AM
C8
Budget Request Summary by Proposal
Professional Services
Organization Proposal Contractor Hourly Total
Request
Purpose
PUB110202 - PUB110202 Budgets
Rates (267642)
46 - FS Capital Finance
Team Support
TBD 100 99,000 Increased scope and cost of Municipal advisors, reflecting increase in issuance and size of portfolio and DBC
46 - FS Capital Finance
Team Support
TBD 100 61,000 DBC onetime set up costs. DBC is the industry standard software tool for managing and optimizing bonds,
and
is
in
use
by
the
Controller's
OPF.
Professional Services Total 160,000
Dec 4, 2023 2 of 2 11:10:31 AM
C9
Budget Request Summary by Proposal
Fiscal Year: 2024-25
Organization: PUB110203 - PUB110203 Fleet Management (154648) Proposal: 160 - Fuel Hardware System Upgrade
Fund/Dept/Auth/Proj/Act: 27180/154648/10000/10026775/0003 Current EJ Ward fuel hardware systems have reached “End of Life” and is no longer supported. Upgrade includes new web hosted SaaS, Fuel Terminal Hardware and labor including Tank Level Monitoring and Compliance Reporting Modules that communicate using Veeder Root Protocol, new fuel control terminals and 24/7 Call Center Support.
Account Lvl3 Account Base Budget Total Request Change
Capital Outlay 56000 Equipment Purchase 0 165,000 165,000 Capital Outlay 0 165,000 165,000
Summary 0 165,000 165,000
Equipment
Organization Proposal Equipment
No
Equipment
Ind
Item
Title
Quantity Total Accessories
Cost
Total
Request
Justification
PUB110203
-
PUB110203
Fleet
Management
(154648)
160 -
Fuel
Hardware
System
Upgrade
PUC25UB013 N Fuel
hardware
system
upgrade
1 165,000 0 165,000 Current EJ Ward fuel hardware systems have reached “End of Life” and is no longer supported. Upgrade includes new web hosted SaaS, Fuel Terminal Hardware and labor including Tank Level Monitoring and Compliance Reporting Modules that communicate using Veeder Root Protocol, new fuel control terminals and 24/7 Call Center Support. This is so we can better manage and track fuel transactions, so we can electronically monitor fuel inventory via interface to Maximo and link to balance sheet”.
Equipment Total 165,000 165,000
Jan 4, 2024 1 of 1 1:28:03 PM
C10
Budget Request Summary by Proposal
Fiscal Year: 2024-25
Organization: PUB110301 - PUB110301 ITS Administration (267643) Proposal: 102 - Disaster Recovery
Fund/Dept/Auth/Proj/Act: 27180/267643/10000/10026776/0001 Professional services to help implement and support the policies, procedures, and programs that ensure the recovery, security, and integrity of company data, databases, information systems, and technology in the event of a disruption or unanticipated disaster. The IT Disaster Recovery Analyst will also perform risk management analysis and document disaster recovery plans.
Account Lvl3 Account Base Budget Total Request Change
Non-Personnel Services 52700 Professional & Specialized Svc 0 125,000 125,000 Non-Personnel Services 0 125,000 125,000
Summary 0 125,000 125,000
Professional Services
Organization Proposal Contractor Hourly Total Request Purpose PUB110301 - PUB110301 ITS Administration (267643) 102 - Disaster Recovery Technology Store Contract 200 125,000 Disaster Recovery & Continuity of Operations Professional Services Total 125,000
Dec 4, 2023 1 of 1 11:47:21 AM
C11
Budget Request Summary by Proposal
Fiscal Year: 2024-25
Organization: PUB110301 - PUB110301 ITS Administration (267643) Proposal: 103 - Phone Migration
Fund/Dept/Auth/Proj/Act: 27180/267643/10000/10026776/0001 Current phone system is end of life and needs to be replaced with a nimble solution that can support SFPUC operations across all sites and counties. AT&T provides a Direct Route managed service that allows SFPUC to replace legacy infrastructure with cloud-based telephony services. These can be leveraged for 1:1 replacement of physical extensions, as well as facilitate the use of soft-phones,
which
should
help
reduce
costs
in
the
long-term.
AT&T
also
provides
Services
for
assessment
and
design
services,
to
determine
actual
number
of
extensions,
site
capabilities,
etc.
FY23 will consist of the assessment and design process, as well as deploymet to pilot sites (estimate around 200 extensions). Formal migration of all sites is planned to initiate in FY24 and complete
in
FY26.
Professional Services are being requested to ensure SFPUC has a technical point of contact to assist in the migration from legacy Avaya PBX to AT&T managed phone service. Services include coordination of efforts between AT&T, DT, DT consultants, and SFPUC technical teams, help perform site assessments, end-user training, and operationalization of new solution. These services should
ideally
be
absorbed
by
the
SFPUC
Technical
Operations
team
after
FY25.
In
order
to
leverage
AT&T
managed
phone
service,
Microsoft
Phone
System
Licensing
is
required,
and
will
most
likely
require
G5
licensing
in
order
to
maximize
savings.
At the end of the proect, SFPUC should expect savings from reduced DT work order spend, including usage fees, PBX maintenance and support and circuit charges. These savings will depend on assessment
details,
reduction
of
unused
lines,
as
well
as
level
of
adoption
of
soft
phones.
All
numbers
provided
are
estimates
and
will
likely
need
updates
once
assessment
is
complete.
Note, these costs do not include potential improvements to our infrastructure (network cabling, bandwidth, etc.) that might be identified during assessment process. These are strictly assessment and design services, along with service enablement.
Account Lvl3 Account Base Budget Total Request Change
Non-Personnel Services 53500 Other Current Expenses 0 100,000 100,000 Non-Personnel Services 0 100,000 100,000
Summary 0 100,000 100,000
Other Objects
Organization Proposal Account Total
Request
Justification
PUB110301 -
PUB110301
ITS
Administration
(267643)
103 -
Phone
Migration
535960
Software
Licensing
Fees
100,000 Current phone system is end of life and needs to be replaced with a nimble solution that can support SFPUC operations across all sites and counties. AT&T provides a Direct Route managed service that allows SFPUC to replace legacy infrastructure with cloud-based telephony services.
These can be leveraged for 1:1 replacement of physical extensions, as well as facilitate the use of soft-phones, which should help reduce costs in the
long-term.
AT&T
also
provides
Services
for
assessment
and
design
services,
to
determine
actual
number
of
extensions,
site
capabilities,
etc.
Subscription
costs:
-AT&T
Teams
Direct
Route
User
Profile
-MS
Teams
Phone
System
Licensing
(G3/G1
license
required)
-e911
Services
-e911
EndPoint
-e911
ERS
VPN
Tunnel
Pair
Dec 4, 2023 1 of 2 11:47:54 AM
C12
Budget Request Summary by Proposal
Fiscal Year: 2024-25
Organization: PUB110301 - PUB110301 ITS Administration (267643) Proposal: 103 - Phone Migration
Organization Proposal Account Total
Request
Justification
-C435
Desk
Phone
Lease
-C455
Desk
Phone
Lease
-Conference
Phone
Lease
-C450
Expansion
Module
Lease
Other Objects Total 100,000
Dec 4, 2023 2 of 2 11:47:54 AM
C13
Budget Request Summary by Proposal
Fiscal Year: 2025-26
Organization: PUB110301 - PUB110301 ITS Administration (267643) Proposal: 103 - Phone Migration
Fund/Dept/Auth/Proj/Act: 27180/267643/10000/10026776/0001 Current phone system is end of life and needs to be replaced with a nimble solution that can support SFPUC operations across all sites and counties. AT&T provides a Direct Route managed service that allows SFPUC to replace legacy infrastructure with cloud-based telephony services. These can be leveraged for 1:1 replacement of physical extensions, as well as facilitate the use of soft-phones,
which
should
help
reduce
costs
in
the
long-term.
AT&T
also
provides
Services
for
assessment
and
design
services,
to
determine
actual
number
of
extensions,
site
capabilities,
etc.
FY23 will consist of the assessment and design process, as well as deploymet to pilot sites (estimate around 200 extensions). Formal migration of all sites is planned to initiate in FY24 and complete
in
FY26.
Professional Services are being requested to ensure SFPUC has a technical point of contact to assist in the migration from legacy Avaya PBX to AT&T managed phone service. Services include coordination of efforts between AT&T, DT, DT consultants, and SFPUC technical teams, help perform site assessments, end-user training, and operationalization of new solution. These services should
ideally
be
absorbed
by
the
SFPUC
Technical
Operations
team
after
FY25.
In
order
to
leverage
AT&T
managed
phone
service,
Microsoft
Phone
System
Licensing
is
required,
and
will
most
likely
require
G5
licensing
in
order
to
maximize
savings.
At the end of the proect, SFPUC should expect savings from reduced DT work order spend, including usage fees, PBX maintenance and support and circuit charges. These savings will depend on assessment
details,
reduction
of
unused
lines,
as
well
as
level
of
adoption
of
soft
phones.
All
numbers
provided
are
estimates
and
will
likely
need
updates
once
assessment
is
complete.
Note, these costs do not include potential improvements to our infrastructure (network cabling, bandwidth, etc.) that might be identified during assessment process. These are strictly assessment and design services, along with service enablement.
Account Lvl3 Account Base Budget Total Request Change
Non-Personnel Services 53500 Other Current Expenses 0 190,000 190,000 Non-Personnel Services 0 190,000 190,000
Summary 0 190,000 190,000
Other Objects
Organization Proposal Account Total
Request
Justification
PUB110301 -
PUB110301
ITS
Administration
(267643)
103 -
Phone
Migration
535960
Software
Licensing
Fees
190,000 Current phone system is end of life and needs to be replaced with a nimble solution that can support SFPUC operations across all sites and counties. AT&T provides a Direct Route managed service that allows SFPUC to replace legacy infrastructure with cloud-based telephony services.
These can be leveraged for 1:1 replacement of physical extensions, as well as facilitate the use of soft-phones, which should help reduce costs in the
long-term.
AT&T
also
provides
Services
for
assessment
and
design
services,
to
determine
actual
number
of
extensions,
site
capabilities,
etc.
Subscription
costs:
-AT&T
Teams
Direct
Route
User
Profile
-MS
Teams
Phone
System
Licensing
(G3/G1
license
required)
-e911
Services
-e911
EndPoint
-e911
ERS
VPN
Tunnel
Pair
Dec 4, 2023 1 of 2 11:56:05 AM
C14
Budget Request Summary by Proposal
Fiscal Year: 2025-26
Organization: PUB110301 - PUB110301 ITS Administration (267643) Proposal: 103 - Phone Migration
Organization Proposal Account Total
Request
Justification
-C435
Desk
Phone
Lease
-C455
Desk
Phone
Lease
-Conference
Phone
Lease
-C450
Expansion
Module
Lease
Other Objects Total 190,000
Dec 4, 2023 2 of 2 11:56:05 AM
C15
Budget Request Summary by Proposal
Fiscal Year: 2024-25
Organization: PUB110301 - PUB110301 ITS Administration (267643) Proposal: 104 - Travel and Training Increase
Fund/Dept/Auth/Proj/Act: 27180/267643/10000/10026776/0001 This proposal is a request to increase to Travel and Training budget to address staff education and development.
Account Lvl3 Account Base Budget Total Request Change
Non-Personnel Services 52200 Training 0 100,000 100,000 Non-Personnel Services 0 100,000 100,000
Summary 0 100,000 100,000
Other Objects
Organization Proposal Account Total
Request
Justification
PUB110301 - PUB110301 ITS Administration
(267643)
104 - Travel and Training
Increase
522000 Training -
Budget
100,000 Increase to Travel and Training budget to address staff education and development
Other Objects Total 100,000
Dec 4, 2023 1 of 1 11:46:48 AM
C16
Budget Request Summary by Proposal
Fiscal Year: 2024-25
Organization: PUB110303 - PUB1103 Applications & Systems (267645) Proposal: 105 - Upgrade of Maximo to Maximo Application Suite (MAS) Fund/Dept/Auth/Proj/Act:
Maximo is used by all SFPUC Operating Divisions for asset and maintenance management. We are currently on Maximo 7.6.1.2 and IBM has announced end-of-support for Maximo 7.6.1.x in September 2025. We must upgrade to Maximo Application Suite (MAS), the new version of Maximo, in order to stay current and compliant. We will be upgrading and migrating our current on- premise instance of Maximo to Maximo Application Suite (MAS) in the Cloud. This proposal is for professional services and annual cloud hosting to support the upgrade.
Professional Services for the upgrade from Maximo to MAS include interface conversion, data migration, system upgrade, testing, administration & end-user training, and deployment.
Maximo Application Suite (MAS) Hosting & Managed Services to be provided by 3rd party vendor.
Account Lvl3 Account Base Budget Total Request Change
Non-Personnel Services 53500 Other Current Expenses 0 325,000 325,000 Non-Personnel Services 0 325,000 325,000
Summary 0 325,000 325,000
Other Objects
Organization Proposal Account Total
Request
Justification
PUB110303 -
PUB1103
Applications &
Systems
(267645)
105 - Upgrade of
Maximo to
Maximo
Application Suite
(MAS)
535960
Software
Licensing
Fees
325,000 The SFPUC is currently on Maximo 7.6.1.2 and IBM has announced end-of-support for Maximo 7.6.1.x in September 2025. We must upgrade to Maximo Application Suite (MAS), the new version of Maximo, in order to stay current and compliant. We will be upgrading and migrating our current on-premise instance of Maximo to Maximo Application Suite (MAS) in the Cloud. This is for annual hosting and managed service for MAS.
0 325,000
Other Objects Total 325,000
Dec 4, 2023 1 of 1 11:35:11 AM
C17
Budget Request Summary by Proposal
Fiscal Year: 2024-25
Organization: PUB110302 - PUB1103 Cybersecurity (267644) Proposal: 107 - Cybersecurity Improvements
Fund/Dept/Auth/Proj/Act:
This
proposal
is
for
the
upgrade
and
replacement
of
critical
Cybersecurity
infrastructure
to
address:
- Secure DNS - The SFPUC has DNS Servers; however, we do not leverage a solution that provides secure DNS. We need the External DNS features our current provider does not provide for the
.gov
transition.
-
Managed
Logs
Aggregation
&
SIEM/UEBA
-
Centralized
Log
Managment
Solution
that
can
be
leveraged
for
SIEM
/
UEBA
technolgies.
-
Privileged
Access
Managment
(BeyondTrust)
-
Deploy
the
the
Beyondtrust
PAM
solution
Agencywide.
-
Access
Management
Auditing
-
Agencywide
deployment
of
Audit
Plus
from
Manage
Engine
in
alignment
with
DT.
- Mobile Malware Protection - Extend Crowdstrike to PUC-owned iPhones.
Account Lvl3 Account Base Budget Total Request Change
Non-Personnel Services 53500 Other Current Expenses 0 400,000 400,000 Non-Personnel Services 0 400,000 400,000
Summary 0 400,000 400,000
Other Objects
Organization Proposal Account Total
Request
Justification
PUB110302 -
PUB1103
Cybersecurity
(267644)
107 -
Cybersecurity
Improvements
535960
Software
Licensing
Fees
400,000 Implementation, upgrade, and replacement of critical Cybersecurity functions: - Secure DNS - The SFPUC has DNS Servers; however, we do not leverage a solution that provides secure DNS. We need the External DNS features our current provider does not provide for the .gov transition. - Managed Logs Aggregation & SIEM/UEBA - Centralized Log Managment Solution that can be leveraged for SIEM / UEBA technologies. - Privileged Access Managment (BeyondTrust) - Deploy the the Beyondtrust PAM solution Agencywide. - Access Management Auditing - Agencywide deployment of Audit Plus from Manage Engine in alignment with DT. - Mobile Malware Protection - Extend Crowdstrike to PUC-owned iPhones.
Other Objects Total 400,000
Dec 4, 2023 1 of 1 11:36:50 AM
C18
Budget Request Summary by Proposal
Fiscal Year: 2024-25
Organization: PUB110304 - PUB1103 Ops Tech & Infra (267646) Proposal: 108 - Network and Server Maintenance
Fund/Dept/Auth/Proj/Act:
This
proposal
is
for
materials
and
supplies
for
the
replacement
of
critical
networking
infrastructure:
Network
and
Server
Misc.
and
Accessories
for
Data
Center
(525GG
&
SFO)
and
switches
Account Lvl3 Account Base Budget Total Request Change
Materials & Supplies 54900 Other Materials & Supplies 0 250,000 250,000 Materials & Supplies 0 250,000 250,000
Summary 0 250,000 250,000
Other Objects
Organization Proposal Account Total
Request
Justification
PUB110304 - PUB1103 Ops
Tech & Infra (267646)
108 - Network and
Server Maintenance
549250 Minor Data
Processing Equipmnt
250,000 Network and Server Misc. and Accessories for Data Center (525GG & SFO). Fiber Modules, Fiber cables, Copper
cables,
Fiber
Cleaner,
Switch
Power
Supplies,
Cubicle
Switches
Other Objects Total 250,000
Dec 4, 2023 1 of 1 11:41:26 AM
C19
Budget Request Summary by Proposal
Fiscal Year: 2024-25
Organization: PUB110304 - PUB1103 Ops Tech & Infra (267646) Proposal: 109 - SCADA Infrastructure Upgrade
Fund/Dept/Auth/Proj/Act: 27180/267646/10000/10026776/0006 This
proposal
is
for
the
upgrade
and
enhancements
of
critical
Water
SCADA
infrastructure:
- Radio Upgrades for Master Sites, AWSS component upgrades, core switch upgrades, firewalls, storage replacements, hypervisor upgrades/replacements, Radio system upgrades, and PLC component
upgrades,
replacements,
and
spares.
Account Lvl3 Account Base Budget Total Request Change
Labor 50100 Permanent Salaries-Misc. 0 117,366 117,366
Labor 0 117,366 117,366
Mandatory Fringe Benefits Mandatory Fringe Benefits 0 55,162 55,162 Mandatory Fringe Benefits 0 55,162 55,162
Materials & Supplies 54900 Other Materials & Supplies 0 150,000 150,000 Materials & Supplies 0 150,000 150,000
Non-Personnel Services 53500 Other Current Expenses 0 176,337 176,337 Non-Personnel Services 0 176,337 176,337
Summary 0 498,865 498,865
Position Change
Organization Proposal Indicator RefCode Position Title Count Total Request
Justification
PUB110304 - PUB1103
Ops Tech & Infra
(267646)
109 - SCADA
Infrastructure
Upgrade
AN 7318 Electronic
Maintenance
Technician
1 117,366 This position is to support critical SCADA AWSS, radio, and microwave systems. Currently, there is no backup radio communications person in SCADA.
Position Total 1 117,366
Other Objects
Organization Proposal Account Total
Request
Justification
PUB110304 - PUB1103
Ops Tech & Infra
(267646)
109 - SCADA
Infrastructure
Upgrade
535960 Software
Licensing Fees
176,337 EndPoint Protection and Management for SCADA endpoints, cybersecurity, Certificates, Assets, Patch Management, Application
deployment,
Device
Encryption,
Performance
Monitoring.
Monarch licensing and support for SCADA OSI system upgrade beginning FY23/24. This will help ensure our SCADA systems are kept up to date with the latest software releases and improves functionality, reliability and security. (HHW, Upcountry)
109 - SCADA
Infrastructure
549250 Minor Data
Processing
150,000 SCADA thin clients, laptops, printers, backup power, power supplies, monitors, accessories, equipment, cables, wiring, switches, routers, radios.
Jan 2, 2024 1 of 2 10:08:19 PM
C20
Budget Request Summary by Proposal
Fiscal Year: 2024-25
Organization: PUB110304 - PUB1103 Ops Tech & Infra (267646) Proposal: 109 - SCADA Infrastructure Upgrade
Organization Proposal Account Total
Request
Justification
PUB110304 - PUB1103
Ops Tech & Infra
(267646)
Upgrade Equipmnt
Other Objects Total 326,337
Jan 2, 2024 2 of 2 10:08:19 PM
C21
Budget Request Summary by Proposal
Fiscal Year: 2024-25
Organization: PUB110302 - PUB1103 Cybersecurity (267644) Proposal: 112 - TEMP to Permanent Conversion
Fund/Dept/Auth/Proj/Act:
Request to convert three temp positions to permanent positions within the Cybersecurity group Account Lvl3 Account Base Budget Total Request Change
Labor 50100 Permanent Salaries-Misc. 0 426,659 426,659
Labor 0 426,659 426,659
Mandatory Fringe Benefits Mandatory Fringe Benefits 0 200,530 200,530 Mandatory Fringe Benefits 0 200,530 200,530
Summary 0 627,189 627,189
Position Change
Organization Proposal Indicator RefCode Position Title Count Total Request
Justification
PUB110302 - PUB1103
Cybersecurity (267644)
112 - TEMP to
Permanent Conversion
AN 1070 IS Project Director 1 167,689 Temp to Perm conversions. Current incumbent: Shashi Ganjam. eMerge #: 10696 - 01153700
112 - TEMP to
Permanent Conversion
AN 1824 Principal
Administrative
Analyst
1 128,360 Temp to Perm conversions. Current incumbent: Adedayo Oyewole.
eMerge
#:
10865
-
01154144
112 - TEMP to
Permanent Conversion
AN 1042 IS Engineer-
Journey
1 130,610 Temp to Perm conversions. Current incumbent: Shakil Ahamed. eMerge
#:
10659
-
01153470
Position Total 3 426,659
Dec 4, 2023 1 of 1 11:36:21 AM
C22
Budget Request Summary by Proposal
Fiscal Year: 2024-25
Organization: PUB110304 - PUB1103 Ops Tech & Infra (267646) Proposal: 113 - TEMP to Permanent Conversion
Fund/Dept/Auth/Proj/Act:
Request to convert six temp positions to permanent positions within the OP Technology & Infrastructure group.
Account Lvl3 Account Base Budget Total Request Change
Labor 50100 Permanent Salaries-Misc. 0 602,187 602,187
Labor 0 602,187 602,187
Mandatory Fringe Benefits Mandatory Fringe Benefits 0 283,028 283,028 Mandatory Fringe Benefits 0 283,028 283,028
Summary 0 885,215 885,215
Position Change
Organization Proposal Indicator RefCode Position Title Count Total Request
Justification
PUB110304 - PUB1103 Ops
Tech & Infra (267646)
113 - TEMP to
Permanent Conversion
AN 7368 Senior Communications
Systems Technician
1 141,804 Temp to Perm conversion. Incumbent has a start date of 10/16/23. eMerge #: 01143169
113 - TEMP to
Permanent Conversion
AN 1044 IS Engineer-Principal 1 176,190 Temp to perm conversion. Position has recently become vacant on 7/1/23.
113 - TEMP to
Permanent Conversion
AN 1091 IT Operations Support
Administrator I
1 68,069 Temp to perm conversion. Current incumbent: Catrina Huang.
eMerge
#:
10752
-
01153859
113 - TEMP to
Permanent Conversion
AN 1091 IT Operations Support
Administrator I
1 68,069 Temp to perm conversion. Current incumbent: Janel Molejona.
eMerge
#:
10754
-
01153860
113 - TEMP to
Permanent Conversion
AN 1091 IT Operations Support
Administrator I
1 68,069 Temp to perm conversion. Current incumbent: Helen Haile.
eMerge
#:
10753
-
01153858
113 - TEMP to
Permanent Conversion
AN 1092 IT Operations Support
Administrator II
1 79,986 Temp to perm conversion. Current incumbent: Irene Cen. eMerge
#:
9634
-
01148232
Position Total 6 602,187
Dec 4, 2023 1 of 1 11:40:05 AM
C23
Budget Request Summary by Proposal
Fiscal Year: 2024-25
Organization: PUB110301 - PUB110301 ITS Administration (267643) Proposal: 114 - TEMP to Permanent Conversion
Fund/Dept/Auth/Proj/Act: 27180/267643/10000/10026776/0001 Request to convert five temp positions to permanent positions within the Administration group Account Lvl3 Account Base Budget Total Request Change
Labor 50100 Permanent Salaries-Misc. 0 849,961 849,961
Labor 0 849,961 849,961
Mandatory Fringe Benefits Mandatory Fringe Benefits 0 399,482 399,482 Mandatory Fringe Benefits 0 399,482 399,482
Summary 0 1,249,443 1,249,443
Position Change
Organization Proposal Indicator RefCode Position Title Count Total Request
Justification
PUB110301 -
PUB110301 ITS
Administration
(267643)
114 -
TEMP to
Permanent
Conversion
AN 1822 Administrative
Analyst
1 95,119 Temp to perm conversion. Current incumbent: Rosemary Brooks. Emerge #: 10800 - 01153938
114 -
TEMP to
Permanent
Conversion
AN 1844 Senior
Management
Assistant
1 100,344 Temp
to
perm
conversion.
Current
incumbent:
Katie
Li.
Emerge
#:
10744
-
01153132
114 -
TEMP to
Permanent
Conversion
AN 1070 IS Project
Director
1 167,689 Temp
to
perm
conversion.
Current
incumbent:
Fahim
Saidzada.
Emerge
#:
9588
-
01146001.
114 -
TEMP to
Permanent
Conversion
AN 1070 IS Project
Director
1 167,689 Temp
to
perm
conversion.
Current
incumbent:
Traci
Young.
Emerge
#:
10876
-
01154142
114 -
TEMP to
Permanent
Conversion
AN 1070 IS Project
Director
1 167,689 Temp to perm conversion. Currently working on interviews. 114 -
TEMP to
Permanent
Conversion
AN 1825 Principal
Administrative
Analyst II
1 151,431 This position is needed to support projects due to increased scope and complexity for this team, planned IT projects and related procurements in the budget such as MAXIMO, SCADA, DBC and Questica. The position will service as a project lead/manager for the implementation of new IT projects.
Dec 22, 2023 1 of 2 10:54:02 AM
C24
Budget Request Summary by Proposal
Fiscal Year: 2024-25
Organization: PUB110301 - PUB110301 ITS Administration (267643) Proposal: 114 - TEMP to Permanent Conversion
Organization Proposal Indicator RefCode Position Title Count Total Request
Justification
Position Total 6 849,961
Dec 22, 2023 2 of 2 10:54:02 AM
C25
Budget Request Summary by Proposal
Fiscal Year: 2024-25
Organization: PUB1104 - PUB1104 Loans & Grants (210834) Proposal: 47 - Loans & Grants Support
Fund/Dept/Auth/Proj/Act: 27180/210834/10000/10026772/0015 Loans and Grants is a new bureau in Business Services, that was previously supported through professional services consultant contracts. In FY 2022-23, an 0933 Loans and Grants Director was hired and budgeted under PUB1101 Business Svc Admin. This budget proposal continues the transition from being predominantly consultant supported to an SFPUC staffed program. The successful acquisition of low interest financing since 2014, estimated to save SFPUC $1.4B over 30-year revenue bond financing, far offsets the cost to implement the L&G program. With 14 executed agreements for 19 projects totaling $2.4B in low-cost financing, plus another 8 loans anticipated to be executed in the next 2 years for 22 projects totaling $1.4B, conservatively estimated to save more than $410M, the L&G bureau will need resources to implement ongoing administration, ensuring compliance with all funding agreements. Though a new professional services contract will be available to provide consultant support from October 2023 - June 2028, continued administration of existing loans and grants, pursuit of new funding, engagement in development of new funding opportunities, and L&G program administration that will be needed well beyond the 5-year consultant contract. The L&G program has matured from the initial goal in 2014 of 5 loans totaling $500M, to becoming a vital component of SFPUC's financing strategy, whose success is equally reliant on cooperative planning with SFPUC Financing, collaborative work with External Affairs for strategic advocacy and development of funding partnerships, and rigorous compliance and administration work implemented together with Infrastructure. It is time for SFPUC
to
work
towards
shifting
the
program
to
an
in-house
function
that,
in
the
future,
would
only
rely
on
consultants
for
as-needed
augmentation.
Partnership development is also a critical component of L&G success. While most day-to-day collaboration and meetings can be done electronically and through virtual platforms, there is no substitute for in-person relationship building. This requires L&G to retain strong engagement with industry associations and agencies that are responsible for administration of funding programs.
This proposal includes a travel budget for attendance at two conferences and one in-person meeting in Washington, DC for each fiscal year.
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
PUB1104 - PUB1104
Loans & Grants
(210834)
47 - Loans &
Grants
Support
ON 0931 Manager III 1 148,939 L&G Manager is a new position that is needed to support development of in-house bureau,
manage
existing
consultant
contract
and
the
new
L&G
Analyst
II.
47 - Loans &
Grants
Support
ON 1824 Principal
Administrative
Analyst
1 128,360 L&G Analyst II is a new position that is needed to continue to transition responsibility from consultant to in-house bureau responsible for administering SFPUC's loans and grants.
47 - Loans &
Grants
Support
A 9997M Non-Operating
Position Offset
-1.54 -277,299
Position Total 0.46 0
Jan 2, 2024 1 of 1 10:10:45 PM
C26
Budget Request Summary by Proposal
Fiscal Year: 2024-25
Organization: PUB110803 - PUB110803 CSB Customer Accts (267653) Proposal: 61 - Hydrant Meter Rules and Regulations
Fund/Dept/Auth/Proj/Act: 27180/267653/10000/10026773/0003 Support of Hydrant Meter Rules and Regulations
Account Lvl3 Account Base Budget Total Request Change
Labor 50100 Permanent Salaries-Misc. 0 75,987 75,987
Labor 0 75,987 75,987
Mandatory Fringe Benefits Mandatory Fringe Benefits 0 35,714 35,714 Mandatory Fringe Benefits 0 35,714 35,714
Summary 0 111,701 111,701
Position Change
Organization Proposal Indicator RefCode Position Title Count Total Request
Justification
PUB110803 - PUB110803 CSB Customer Accts
(267653)
61 - Hydrant Meter Rules and
Regulations
AN 1478 Utility Services
Representative
1 75,987 Hydrant Meter Rules and
Regulations
Position Total 1 75,987
Dec 4, 2023 1 of 1 11:53:05 AM
C27
Budget Request Summary by Proposal
Fiscal Year: 2024-25
Organization: PUB110804 - PUB110804 CSB Field Services (267654) Proposal: 50 - CSB Business & System Support
Fund/Dept/Auth/Proj/Act: 27180/267654/10000/10026773/0005 To Convert a vacant 1466 Meter Reader position to a 1052 Business Analyst. This position will be an Analyst for our new AMI program (Advanced Meter Infrastructure system) Account Lvl3 Account Base Budget Total Request Change
Labor 50100 Permanent Salaries-Misc. 0 43,300 43,300
Labor 0 43,300 43,300
Mandatory Fringe Benefits Mandatory Fringe Benefits 0 20,351 20,351 Mandatory Fringe Benefits 0 20,351 20,351
Summary 0 63,651 63,651
Position Change
Organization Proposal Indicator RefCode Position Title Count Total Request
Justification
PUB110804 -
PUB110804 CSB Field
Services (267654)
50 - CSB
Business &
System Support
AS PUB25140 1466 Meter
Reader
-1 -93,542 We want to convert a vacant 1466 Meter Reader position to a 1052 Business Analyst.
This position will be an Analyst for our new AMI program (Advanced Meter Infrastructure system)
50 - CSB
Business &
System Support
AS PUB25140 1052 IS
Business
Analyst
1 136,842 We want to convert a vacant 1466 Meter Reader position to a 1052 Business Analyst.
This position will be an Analyst for our new AMI program (Advanced Meter Infrastructure system)
Position Total 0 43,300
Dec 4, 2023 1 of 1 11:54:29 AM
C28
Budget Request Summary by Proposal
Fiscal Year: 2024-25
Organization: PUB1109 - PUB1109 Audit Bureau
Proposal: 48 - Audit Bureau Support
Fund/Dept/Auth/Proj/Act: 27180/210813/10000/10026772/0014 Introduction:
The purpose of this proposal is to present a justification for an increased budget for the upcoming budget cycle for the Audit Bureau. As an essential component of maintaining financial integrity and ensuring compliance, conducting a thorough audit is crucial for the SFPUC. However, due to evolving regulatory requirements, expanding business operations and services, and the need for enhanced
cybersecurity,
it
is
imperative
to
allocate
additional
resources
to
perform
comprehensive
audit
activities
effectively.
1. Regulatory
Compliance:
In recent years, there has been a significant increase in regulatory requirements from the SF Controller’s Office and the Budget Legislative Analyst . Compliance with these regulations is vital to avoid consequences and maintain stakeholder trust. With an increased budget, we can allocate funds to specialize in our audits, invest in advanced software tools, and conduct in-depth research in
each
bureau
to
ensure
compliance
with
all
applicable
regulations.
2. Expanding Business Operations: SFPUC has experienced substantial growth in operating load and expanding legal requirements. As a result, the complexity and scale of our operations have increased, requiring a more extensive audit process. By allocating additional resources, we can engage auditors with expertise in specific areas, such as risk management, to thoroughly assess the
new
business
ventures
and
ensure
accurate
financial
reporting.
3. Enhanced CyberSecurity: In today's digital landscape, Cybersecurity is a top priority. The Audit Bureau needs to assess the effectiveness of internal controls, identify potential vulnerabilities, and provide recommendations for risk mitigation. With an increased budget, we can invest in robust cybersecurity measures, conduct penetration testing, and employ data analytics tools to detect
anomalies
and
address
any
potential
security
loopholes.
4. Technological Advancements: Technology continues to advance rapidly, impacting the audit process. Investing in audit-specific software and tools can streamline data analysis, improve accuracy, and enhance efficiency. By allocating additional funds, we can acquire cutting-edge audit software, provide training to auditors on utilizing these tools effectively, and facilitate smoother
information
exchange
between
auditors
and
the
organization's
systems.
Conclusion:
An increased budget for the Audit Bureau is essential to accommodate the evolving landscape of regulatory compliance, expanding business operations, enhanced data security requirements, and technological advancements. By allocating additional resources, we can ensure a thorough and effective audit, maintain compliance, and provide actionable insights to the organization's management,
contributing
to
its
long-term
success
and
sustainability.
Account Lvl3 Account Base Budget Total Request Change
Labor 50100 Permanent Salaries-Misc. 0 238,049 238,049
Labor 0 238,049 238,049
Mandatory Fringe Benefits Mandatory Fringe Benefits 0 111,883 111,883 Mandatory Fringe Benefits 0 111,883 111,883
Summary 0 349,932 349,932
Position Change
Organization Proposal Indicator RefCode Position Title Count Total Request
Justification
PUB1109 -
PUB1109
48 -
Audit
AN 1823 Senior
Administrative
1 110,855 1823
to
assist
with
special
deliverables
for
Audit
Bureau
including
*Tracking
audit
costs
throughout
the
SFPUC
for
external
reporting
Jan 8, 2024 1 of 2 4:00:18 PM
C29
Budget Request Summary by Proposal
Fiscal Year: 2024-25
Organization: PUB1109 - PUB1109 Audit Bureau
Proposal: 48 - Audit Bureau Support
Organization Proposal Indicator RefCode Position Title Count Total Request
Justification
Audit
Bureau
Bureau
Support
Analyst *Examine
financial
transactions,
processes
and
systems
to
ensure
accuracy
and
reliability
*Communicate with stakeholders about closing recommendations in AuditShare from oversight bodies
such
as
City
Services
Auditor
*Stay updated on regulations in auditing and accounting with the citywide accounting operations and
the
Institute
of
Internal
Auditors
*Proactively identify opportunities to enhance the internal audit function, streamline processes and implement best practices to contribute to the SFPUC's overall effectiveness 48 -
Audit
Bureau
Support
AS PUB25272 0932 Manager IV -1 -207,599 To align the position to the appropriate work classification of duties being performed. 48 -
Audit
Bureau
Support
AS PUB25272 0933 Manager V 1 223,938 To align the position to the appropriate work classification of duties being performed. 48 -
Audit
Bureau
Support
AN 1823 Senior
Administrative
Analyst
1 110,855 Significant increase in scope and complexity for SFPUC’s Audit Bureau in recent years. This request supports SFPUC’s commitment to transparency and accountability. 2 1823’s Senior Audit Analysts are
needed
to
assist
with
agency-wide
deliverables
for
Audit
Bureau
including
-
Tracking
audit
costs
throughout
the
SFPUC
for
external
reporting
-Examine
financial
transactions,
processes
and
systems
to
ensure
accuracy
and
reliability
-Communicate with stakeholders about closing recommendations in AuditShare from oversight bodies inclusive of City Services Auditor, Budget & Legislative Analyst, Revenue Bond Oversight Committee,
CA
State
Department
of
Finance,
and
others.
-Stay updated on regulations in auditing and accounting with the citywide accounting operations and
the
Institute
of
Internal
Auditors
-Proactively identify opportunities to enhance the internal audit function, streamline processes and implement
best
practices
to
contribute
to
the
SFPUC's
overall
effectiveness
Position Total 2 238,049
Jan 8, 2024 2 of 2 4:00:18 PM
C30