ROSIE V2 System Design
ROSIE V2 ISD review
Sheet 1
fx
Present
CITY OF EUGENE · ISD SYSTEM DESIGN REVIEW · OCTOBER 2026

ROSIE V2: proposed
system design

A short walkthrough of where ROSIE is today and what we propose, then open discussion of ISD's questions.

ISDMicrosoftLaunchFlowEWEB

ROSIE, and why we're rewriting it

A companion to EWEB's SAP billing system. It works out how each property should be billed for stormwater and wastewater.

Today's goal: start the workflow redesign

Each step unlocks the next. The request to change EWEB's export waits on the redesign.

ROSIE setup today

Our earlier diagram merged them into one box. The AI prototype only ever touched QA.

ISD provides the environment. We run what's inside.

We recommend a VM with Docker Compose.

Where ROSIE V2 runs, step by step

A self-hosted workspace in the City's cloud runs old and new ROSIE side by side while we build.

ROSIE AI can propose. Only people can change data.

Three safe ways to approve. In each, the AI can only stage or propose. A person commits.

Let's discuss

Decisions to make together, and where each ISD question is answered.

PLATFORM AND HOSTING

REQUIREMENTS AND AI

ONGOING SUPPORT

If it comes up:
EXTRA

Phase 2 showed what ROSIE AI can do

It's a search tool that checks every record, so staff find issues in minutes instead of weeks.

Monthly split-report gap between EWEB and the City

After ROSIE AI found the billing-adjustment edge cases

Worst months Worst months: over $150k over $150k Before Before: about $35k a month ~$35k / mo After After: about $3k a month ~$3k / mo $0$50k$100k$150k

Tracing a $50k misbill across 12k installations

EWEB IT team EWEB IT team: over a month over a month ROSIE AI ROSIE AI: 15 to 30 minutes 15–30 minutes, same result 01 wk2 wk3 wk4 wk
EXTRA

Why build ROSIE V2 on the platform

Shared tools replace custom code, so the build and the upkeep cost less.

Compared with the original quote

Build cost vs. original quote~30%
Support cost vs. original quote25–50%
ROSIE custom codeup to 80% less
EXTRA

Linux or Windows for the VM

ROSIE's containers are Linux containers. On Windows they need an extra Linux layer underneath.

EXTRA

Foundry and Microsoft 365 Copilot reach the same models

The difference is who controls everything around them.

ROSIE's sign-in, now and later

Staff sign in with Microsoft Entra ID at every step.

ROSIE V2 · Slides

← → to navigate · M for slides · Esc to close