City Services Auditor Fiscal Year 2018-19 Work Plan Overview for - - PowerPoint PPT Presentation

CITY & COUNTY OF SAN FRANCISCO

Office of the Controller City Services Auditor

Peg Stevenson | Tonia Lediju 08.13.2018

City Services Auditor Fiscal Year 2018-19 Work Plan

Overview for CGOBOC

The City Services Auditor (CSA) was created through Charter Appendix F, which San Francisco voters approved in 2003. Under the Charter, CSA is mandated to:

• Serve as the City’s internal auditor by conducting financial and

performance audits.

• Evaluate the quality and quantity of city services, compare, benchmark,

and provide public information and transparency.

• Measure and report on the City’s performance to standards for streets,

parks, and sidewalks.

• Evaluate city management and employment practices.
• Oversee contracting procedures and RFP standards.
• Operate a whistleblower hotline and website and conduct

investigations.

2

Overview of CSA’s Mandates Charter Mandates

CSA receives two-tenths of one percent (0.2%) of the City’s budget by fund.

Overview for Fiscal Year 2018-19

3

Funding

Preliminary Estimated Amounts:

• Annual Operating Budget: $19M
• Capital Budget: $2M (varies by

bond issuance)

Staffing

• Approximately 68 full-time

equivalent staff

• This includes both City Audits

and City Performance

Resources

4

Fiscal Year 2018-19 Work Order Budgets: Large Departments Resources

Department/Work Order Amount

(In Millions)

General Fund Departments $4.40 Department of Public Health 4.10 Municipal Transportation Agency 2.40 Human Services Agency 1.65 Airport 0.98 Public Utilities Commission 0.88 Homelessness and Supportive Housing 0.46

CSA Comprises Two Units

5

Organization

Audits City Performance

• Performance audits: operational,

construction, compliance, information technology, continuous monitoring

• Financial and mandated audits
• Whistleblower investigations
• Standards, performance measures,

benchmarking

• Financial and operational analysis

and implementation

• Technical assistance and

professional contracting

• Citywide and multi-departmental

projects

• CSA’s work plan is driven by
• Charter and Administrative Code requirements
• Limited risk analysis
• Mayor, Board, leadership, and department requests
• CSA compiles a list of potential projects and audits for the

upcoming fiscal year based on budgets, mandates, & analysis

• CSA prioritizes projects and audits in consultation with the

controller, leadership, and departments, and considers risk

• CSA balances resources to allocate staffing and funding in light
• f priorities

6

Overview of CSA’s Work Planning Process Work Planning

7

Fiscal Year 2018-19 Programs City Performance

Performance

• Performance Scorecards
• Expanded benchmarking
• Citywide performance

database: updates, data validation, reports to Mayor’s Office, Board of Supervisors, stakeholders, and public

• Dashboards for transparency

and public information

LEAN

• Lean Leaders three-day

training with cohort model starts in the fall; 9 departments, 22 participants

• Lean 101 every quarter
• Lean projects at Rec & Park,

Human Services, MTA, Public Library

• Rapid Improvement Event

(RIE) model in use citywide

• Lean website and tools, Lean

practitioners group, and lunch presentations help build a citywide Lean culture

Data Academy

• Build on success of 2018 –
• ver 1,000 attendees
• Deliver core training in

Microsoft BI, Tableau, Excel

• Grow new training in

statistical skills and software: R, probability, and statistics

• Expand training in design

thinking and tools

Parks & Streets Standards

• Park Standards - Ongoing

evaluation, analysis, reporting

• Streets Standards – A review

and update of the City’s street standards is underway

Nonprofit Program

• Citywide joint monitoring
• Training and technical

assistance program to CBOs

• New guidance on indirect

cost and cost allocation

• Department of Public Health – Electronic health records

assistance with new system, ongoing work on data usage, revenue maximization, and improving patient flow

• Municipal Transportation Agency – Capital program delivery
• Support to Citywide Capital Planning and Services – New

permit center, Civic Center, Hall of Justice, and safety facilities

• Performance Program Development – New benchmarking

reports, improvements to scorecards and interactive sites

• Data Academy & Training – Lean for SF city government is

now well-developed and will be offered to more users

• Department of Homelessness and Supportive Housing –

Support to interagency work on homelessness

8

Fiscal Year 2018-19 Major Projects City Performance

9

Fiscal Year 2018-19 Highlights Audits

Construction Audits

• GO Bond Expenditures Audits
• 2014 Earthquake Safety &

Emergency Response

• 2014 Transportation
• 2015 Affordable Housing
• 2016 Public Health
• MTA Capital Programs and

Construction Division Audit

• Contract Closeout Audits
• Capital Project Risk

Assessment

• Other Construction

Performance Audits

Citywide Compliance

• P-Card Continuous Audit

Program

• Nonprofit Provider Audits
• Cash Collection and

Disbursement Audits

• Payroll Risk Assessment and

Audits

• Procurement Risk Assessment
• Contract Compliance Audits
• Inventory Audits
• Eligibility Compliance Audits
• Mandated Audits

(Concessions, Political Activities, Franchise Fees)

Performance Audits

• DPH Environmental Health

Audit

• Inspection Programs Audit
• Shelter Operations Audit
• Sheriff’s Staffing Audit
• Citywide IT Procurement

Audit

• DPH City Option Program

Audit

• PUC Real Estate Division Audit
• Divisional and Operational

Audits, Assessments, and Reviews

10

Fiscal Year 2018-19 Highlights Audits

IT & Systems Audits Whistleblower Investigations Other Activities

• Recommendations Follow-up
• Enterprise Risk Assessment
• Audit Support for Police

Department, Department of Police Accountability, Ethics Commission

• Disaster Cost Recovery
• Ongoing Whistleblower

Program Investigations

• Outreach and Education

Activities

• Ongoing Systems Security

and Information Technology Controls Audits and Reviews

• New Financial System Post-

Implementation Services

11

Thank you.

Questions?