Juliana McMillan-Wilhoit
F&T Labs · Custom Development · Salesforce · 2024-2025

Three years to get the budget approved. Six months to build it. One day to win the team over.

The ask was a case management system to replace the agency's email threads and spreadsheets. The real problem was underneath: staff would only adopt something new if the training was built around how they actually worked. On go-live day, a settlement officer said: "To be here at this point, with a functioning system from the 2020s after what we have been stuck with for so long, is incredible."

A State Agency (Employee Appeal & Grievance Division) Mid-Atlantic Salesforce Scrum Custom Dev AI Government
Impact
127
Requirements delivered across 13 feature areas
6 mo
Kickoff to go-live
1,200+
Employee grievance cases processed annually
AI
One-click case summarization built in

The ask: a case management system to replace email and spreadsheets.

The agency managed 1,200-1,400 employee grievances and disciplinary appeals a year across multiple state departments, all of it running through email threads and spreadsheets. Their process: employee emails a form → intake specialist downloads attachment → manually types every field into a tracking spreadsheet. Scheduling a single settlement conference meant checking availability for settlement officers, union reps, management, and conference rooms across chains of emails and phone calls.

Staff spent days on overhead instead of moving cases forward. Backlogs grew. Employees waited longer for resolution. The agency had been living with this for years and had finally secured budget to fix it. My role: Scrum Master. Get it built right, get it built on time, and make sure the people who had to use it every day actually wanted to.

"To be here at this point, with a functioning system from the 2020s after what we have been stuck with for so long, is incredible. And we could not have done it without your knowledge, commitment, and creativity."
Settlement Officer, Go-Live Day

The interviews didn't just surface requirements. They changed them.

Training was where the feedback changed our approach most. Our early assumptions about how to onboard staff were wrong. The interviews told us which roles needed hands-on practice, which needed reference guides, and what "ready to use this independently" actually looked like for each team. We built the training around that, not around a generic rollout plan.

Before any configuration, we conducted structured interviews with intake specialists, schedulers, settlement officers, and supervisors, each role, separately. The goal wasn't to produce a requirements document. It was to understand how work actually moved, where it stalled, and what "fixed" would feel like to the person doing the job at 2pm on a Tuesday.

Those conversations shaped the scope directly too. Some things the agency thought they needed turned out to matter less than expected. Other things, particularly around how cases got routed and how staff communicated with parties, were bigger pain points than anyone had named upfront. The interviews let us cut what wasn't necessary and go deeper where it actually mattered.

Process transformation: manual coordination to automated workflow (before and after comparison)

The before/after: five manual steps replaced by five automated ones

What we built

Built on Salesforce Government Cloud. Chose it because the agency would own a system on a widely-supported platform instead of depending on us to run a proprietary one.

Operated on two-week development cycles with continuous demonstrations of working functionality. Validated design decisions early. Adjusted based on user feedback.

Employee self-service portal: grievances submitted directly, data flows into Salesforce automatically, no manual re-entry
Email-to-case: employees can still submit by email; system creates the case record automatically
Visual drag-and-drop scheduling interface: all settlement officer calendars and pending cases in one view; drag a case to an open slot; Google Meet links generated automatically
Automated notifications: intake confirmations, conference notices, calendar invites, reminders; no manual composition
AI-powered case summarization: one click generates a 2-3 paragraph summary of case details, key issues, and requested remedies; staff review and edit before saving
Role-based dashboards: real-time visibility into case volumes, workload, and processing times for supervisors and staff
Visual drag-and-drop settlement conference scheduling interface

The scheduling interface: pending cases in the sidebar, drag to an available slot. Coordination that used to take hours now takes minutes.

Salesforce case management interface showing grievance record with status tracking

The case record: every detail, status, and history in one place. No more spreadsheet hunting.

Impact
The scheduler used the drag-and-drop interface on day one and loved it.

Settlement officers called the system user-friendly. Intake staff described it as something they loved working in. Staff who had operated on a legacy system for years were enthusiastic about handling conferences, closing cases, and managing escalations through the new platform.

The coordination bottleneck that capped daily conferences is gone. The hours intake specialists spent re-typing data now go to actual case review. Report compilation used to be manual; now it's a dashboard click.

We built in complete documentation and training from day one so the agency wouldn't need us to run it: role-based user guides, administrator training, and full technical documentation. Any Salesforce partner can pick up future development.

Tools & Stack
Salesforce Government Cloud Lightning Web Components Flow Automation Email-to-Case AI Case Summarization Scrum Requirements Traceability Process Mapping Google Meet Integration
Next project
You don't find out what a community needs by sitting at your desk
North Chicago CBPR