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.

A state agency managing 1,200–1,400 employee grievance cases a year was running on email threads and spreadsheets. They'd spent three years securing funding. We had six months. 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

Three years to get the budget. We had six months.

The agency managed employee grievances and disciplinary appeals across multiple state departments. 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.

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. Some things the agency thought they needed turned out to matter less than they 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.

Training was where the feedback changed our approach most. Early assumptions about how to onboard staff turned out to be 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.

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 for security credentials, flexibility, and long-term sustainability — the agency would own a system on a widely-supported platform, not a proprietary black box.

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
On the first day, the scheduler used the drag-and-drop interface and loved it. On the first day.

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 had capped how many conferences the team could schedule per day — gone. The hours intake specialists spent re-typing data — redirected to actual case review. The manual report compilation — replaced by a dashboard click.

We also planned for the end from the start. Complete documentation, role-based user guides, administrator training. Any Salesforce partner can support future development. The agency owns this — they don't depend on us to run it. That independence was always the goal.

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