Berkeley, CA · English + Spanish

Luis I. Chavez / Operations & Programs

I bring structure
to work that
matters.

I build useful systems, simplify complex processes, and help community-focused teams deliver. Explore my work in program operations, compliance, and process improvement.

Luis I. Chavez
Thoughtful systems. Reliable follow-through.
8+ yearsAdministrative &
program experience
3 hr → 10 minWorkflow improved
with Excel & VBA
18% → 96%Compliant case files
within 12 months

Selected work / 01—04

The work behind
the results.

Tools I built, processes I improved, and people I helped. Open a case study to see the challenge, my contribution, and the outcome.

01 / Process improvementEBMUD

One project. A whole batch of forms.

I built an Excel/VBA tool that replaced a connection-by-connection workflow for preparing water service forms.

Read case study

The challenge

Infrastructure projects required a form for each water service connection. Staff looked up individual connection records, populated the forms, and printed them one at a time. Repeating those steps across a project took roughly three hours.

What I built

I created the Excel workbook and VBA automation that handled the forms as a project-wide batch.

How it worked

  1. A staff member entered a project number instead of repeatedly entering individual connection numbers.
  2. The workbook retrieved the associated connection data and used formulas and macros to populate the required forms.
  3. The automation batch-printed the completed forms, replacing the repetitive preparation and printing steps.

The outcome

The workflow went from approximately three hours to about 10 minutes. The improvement earned recognition for process efficiency.

Microsoft ExcelVBAWorkflow designBatch processing
02 / Compliance systemsFamily Builders

A clearer path to audit readiness.

I built an expiration tracker and standardized audit checklists to turn missing documentation into specific follow-up actions.

Read case study

The challenge

Family and child case files needed to meet California Community Care Licensing requirements. Staff needed a clear way to identify missing or expired documentation and know exactly what to correct.

What I built

I personally created an Excel compliance tracker with conditional formatting, along with standardized audit checklists that identified specific deficiencies.

How it worked

  • The tracker used document-expiration status to flag records needing attention: current, approaching expiration, or expired.
  • I reviewed files against licensing requirements and translated gaps into corrective checklists for social workers.
  • Follow-up and quarterly audits helped monitor whether documentation had been brought into compliance.

The outcome

The share of compliant case files increased from 18% to 96% within 12 months. The tools made requirements and outstanding corrections easier to see and act on.

Microsoft ExcelConditional formattingAudit checklistsDocument control
03 / Grant operationsFirst 5 Alameda County

Turning grant requirements into action.

I coordinated administrative operations for a $650,000 portfolio spanning nine organizations, with centralized tracking and practical guidance.

Read case study

The challenge

Funded organizations had overlapping contracting, insurance, reporting, budget, and submission requirements. Program and fiscal teams needed dependable follow-up across those moving parts.

My contribution

I maintained centralized trackers and served as a primary contact for nine organizations, resolving documentation, grant-system access, reporting, invoicing, and submission issues.

How the tracking worked

  • Tracked contracts, certificates of insurance, system access, reporting requirements, deadlines, and outstanding actions in one coordinated process.
  • Used status tracking to identify incomplete items and direct follow-up with organizations and internal teams.
  • Reviewed budgets, expense reports, and invoices for accuracy and created step-by-step HIGH5 guidance for account access, reporting, invoicing, and submissions.

The scope

Administrative coordination across a $650,000 portfolio of nine organizations, connecting program requirements with the day-to-day work of completing them.

Compliance trackingHIGH5Budget reviewStakeholder coordination
04 / Bilingual outreachFirst 5 Alameda County

Helping providers take the next step.

Persistent outreach, application support, and Spanish-language communication helped reconnect providers with the grant application process.

Read case study

The challenge

Eligible childcare providers needed help understanding application requirements, resolving submission problems, and gathering documentation. Some had not responded to earlier outreach.

My contribution

I served as the primary Spanish-language contact for eligible providers and completed 212 outreach calls in English and Spanish.

How I approached it

  • Provided phone, email, and in-person assistance to answer questions and troubleshoot application issues.
  • Reviewed required documentation and followed up on the steps providers still needed to complete.
  • Translated outreach materials and communications into Spanish and used site visits and persistent follow-up to re-engage providers.

The outcome

Approximately 35 previously non-responsive providers were re-engaged, helping them complete application requirements.

Bilingual technical assistanceOutreachApplication supportFollow-through

Visuals illustrate workflows and do not display employer records or client information.

A little about how I work

Good operations
are about people, too.

Across nonprofit and public-sector roles, I’ve worked where detailed requirements meet real people’s needs. I’m most useful when a team needs someone to organize the moving parts, make a process understandable, and keep the work moving.

I bring a social services background, practical technical skills, and professional fluency in English and Spanish.

University of California, BerkeleyBA Social Welfare · BA Sociology
01

Make complexity manageable

Program coordination, documentation, deadlines, and stakeholder follow-up.

02

Build tools people can use

Excel, VBA, practical trackers, checklists, and step-by-step guidance.

03

Connect across teams

Bilingual support, clear communication, and coordination with program and fiscal staff.

04

Keep the details dependable

Confidential records, compliance review, budgets, reporting, and office operations.

The full professional picture.

Download my November 2026 resume for experience, education, and skills.

Download resume · PDF

Let’s connect

What could we
make work better?

I’m open to administrative, program coordination, and operations opportunities. Let’s talk about what your team needs.