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

City Services Auditor Fiscal Year 2018-19 Work Plan Overview for CGOBOC CITY & COUNTY OF SAN FRANCISCO Office of the Controller City Services Auditor Peg Stevenson | Tonia Lediju 08.13.2018

Charter Mandates 2 Overview of CSA’s Mandates 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.

Resources 3 Overview for Fiscal Year 2018-19 CSA receives two-tenths of one percent (0.2%) of the City’s budget by fund. Funding Staffing Preliminary Estimated Amounts:  Approximately 68 full-time  Annual Operating Budget: $19M equivalent staff  Capital Budget: $2M (varies by  This includes both City Audits bond issuance) and City Performance

Resources 4 Fiscal Year 2018-19 Work Order Budgets: Large Departments Amount Department/Work Order (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

Organization 5 CSA Comprises Two Units Audits City Performance  Performance audits: operational,  Standards, performance measures, construction, compliance, benchmarking information technology,  Financial and operational analysis continuous monitoring and implementation  Financial and mandated audits  Technical assistance and  Whistleblower investigations professional contracting  Citywide and multi-departmental projects

Work Planning 6 Overview of CSA’s Work Planning Process  CSA’s work plan is driven by Charter and Administrative Code requirements o Limited risk analysis o Mayor, Board, leadership, and department requests o  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 of priorities

City Performance 7 Fiscal Year 2018-19 Programs Performance LEAN Data Academy • Performance Scorecards • Lean Leaders three-day • Build on success of 2018 – training with cohort model over 1,000 attendees • Expanded benchmarking starts in the fall; 9 • Deliver core training in • Citywide performance departments, 22 participants Microsoft BI, Tableau, Excel database: updates, data • Lean 101 every quarter validation, reports to Mayor’s • Grow new training in Office, Board of Supervisors, • Lean projects at Rec & Park, statistical skills and software: stakeholders, and public Human Services, MTA, Public R, probability, and statistics Library • Dashboards for transparency • Expand training in design and public information • Rapid Improvement Event thinking and tools (RIE) model in use citywide Parks & Streets Standards Nonprofit Program • Lean website and tools, Lean practitioners group, and lunch • Park Standards - Ongoing • Citywide joint monitoring presentations help build a evaluation, analysis, reporting • Training and technical citywide Lean culture • Streets Standards – A review assistance program to CBOs and update of the City’s street • New guidance on indirect standards is underway cost and cost allocation

City Performance 8 Fiscal Year 2018-19 Major Projects  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

Audits 9 Fiscal Year 2018-19 Highlights Construction Citywide Performance Audits Compliance Audits • GO Bond Expenditures Audits • P-Card Continuous Audit • DPH Environmental Health o 2014 Earthquake Safety & Program Audit Emergency Response • Nonprofit Provider Audits • Inspection Programs Audit o 2014 Transportation • Cash Collection and • Shelter Operations Audit o 2015 Affordable Housing Disbursement Audits o 2016 Public Health • Sheriff’s Staffing Audit • Payroll Risk Assessment and • MTA Capital Programs and • Citywide IT Procurement Audits Construction Division Audit Audit • Procurement Risk Assessment • Contract Closeout Audits • DPH City Option Program • Contract Compliance Audits Audit • Capital Project Risk Assessment • Inventory Audits • PUC Real Estate Division Audit • Other Construction • Eligibility Compliance Audits • Divisional and Operational Performance Audits Audits, Assessments, and • Mandated Audits Reviews (Concessions, Political Activities, Franchise Fees)

Audits 10 Fiscal Year 2018-19 Highlights IT & Systems Whistleblower Other Audits Investigations Activities • Ongoing Systems Security • Ongoing Whistleblower • Recommendations Follow-up and Information Technology Program Investigations • Enterprise Risk Assessment Controls Audits and Reviews • Outreach and Education • Audit Support for Police • New Financial System Post- Activities Department, Department of Implementation Services Police Accountability, Ethics Commission • Disaster Cost Recovery

11 Thank you. Questions?