KEEGAN
LEACH
I work every room a build passes through — the client call, the Figma review, the data model, the code.
Five rooms of a build
Turning vague requirements into full operational flows and working products.
“The crew logged 60 installs. The dashboard says 47.”
- OPS
Install crew logged 60 units done at Beldon. The dashboard says 47. Which one is wrong?
- KL
Neither. Thirteen are mounted but haven’t sent data. Until a sensor reports, it isn’t protecting anyone, and the owner’s dashboard would say it is.
- KL
Not counted as installed until data has sent.
That sentence became system logic: the install flow won’t count a device until it phones home. 1,265 devices live under that rule.
Rebuilding dense expert work into something anyone can read.
The same research, rebuilt as something a reader can explore.
FROM THE SME'S DECK
MY DECK BUILD · SAME STUDY
PROPERTY OVERVIEWThe same dashboard, rebuilt for the people reading it.
Building data solutions that can deal with human error.
Two products, one naming problem. A thousand devices, sixteen hundred messy plant names: people name things messily. I build the system that keeps one truth.
Designing databases that run real businesses.
51 tables, one schema: the SQL database that runs purchasing and sales for 20+ businesses.
REZYSAVE · DEVICE NAMING
1000.A01.UWDW.2
- 1000the property
- A01building A, unit 01
- UWDWa window sensor on a unit
- 2the second one
1,265 devices across 11 properties, every one findable by its code alone.
STEMWISE · ALIAS RESOLUTION
- “Alocasia Cuprea Red Secret Variegated Super Pink”
- “Alocasia Cuprea Sectoral Albo/Pink”
- “Alocasia Cuprea Pink Varigated”
Alocasia Cuprea Pink Variegated
1,636 messy names → 491 plantsSellers write plant names dozens of ways. The system resolves them into one.
Every dot is a table in Stemwise’s database. Lines show which tables reference each other. Bigger dots carry more of the system.
Turning prompts into production code that holds up.
51 tables, 211 files, one person shipping both.
Every dot is a part of Stemwise’s codebase. Lines show which parts use each other. This is the app the schema powers, written prompt by prompt.
Holding every build to a standard, automatically.
Two workflows, one standard.
Automatic rules and a panel of reviewers check every change before it ships.
Each ask’s final box is always “architect verified in the browser.”
keegan-design/SKILL.md · line 45
FIG. 01 — FIVE ROOMS, ONE SYSTEM
Selected screens
Client Overview
TLP-level account summary
Est. HCAHPS Star Rating
3.8
Engagement
Avg Length of Stay
Readmission Rate
Safety Score
Survey Volume & Response Trend
Trailing 12 months
Facility Opportunity
Product Family Summary
| Product Family | Facilities | Status |
|---|---|---|
| Patient Experience | 2 / 6 | Good |
| Workforce | 1 / 6 | Good |
| Whitespace Reports | 3 / 6 | Good |
| Strategic Consulting | 0 / 6 | Neut. |
Projected Annual Value
$2.74M
If priority gaps close to benchmark.
Visual 1
Series: Surveys sent, Responses received
Visual 2
- Trending better (2)
- Stable (2)
- Trending worse (2)
Table 1
| Facility | Est. Star | Readmission | Safety | Trend |
|---|---|---|---|---|
| E.M. Tolliver Medical Center | 4.1 | 13.8% | 79.0 | Good |
| Haverfield General Hospital | 3.9 | 14.7% | 74.2 | Neutral |
| St. Hedwig | 3.6 | 15.9% | 70.1 | Bad |
| Antelope Springs | 3.5 | 16.4% | 68.4 | Bad |
| Meadowlark West | 4.0 | 14.2% | 76.3 | Good |
| Lodgepole Creek | 3.7 | 15.1% | 71.5 | Neutral |
Table 2
| Product Family | Facilities | Owned | Candidate | Approached |
|---|---|---|---|---|
| Patient Experience | 2 / 6 | Yes | No | Yes |
| Workforce | 1 / 6 | Yes | No | No |
| Whitespace Reports | 3 / 6 | Yes | No | Yes |
| Strategic Consulting | 0 / 6 | No | Yes | Yes |
PROJECTS ARE WON IN THE HANDOFFS. THAT'S WHERE I WORK.
THE STACKS I SHIP WITH
'%3e%3cpath%20d='m19.6%2066.5%2019.7-11%20.3-1-.3-.5h-1l-3.3-.2-11.2-.3L14%2053l-9.5-.5-2.4-.5L0%2049l.2-1.5%202-1.3%202.9.2%206.3.5%209.5.6%206.9.4L38%2049.1h1.6l.2-.7-.5-.4-.4-.4L29%2041l-10.6-7-5.6-4.1-3-2-1.5-2-.6-4.2%202.7-3%203.7.3.9.2%203.7%202.9%208%206.1L37%2036l1.5%201.2.6-.4.1-.3-.7-1.1L33%2025l-6-10.4-2.7-4.3-.7-2.6c-.3-1-.4-2-.4-3l3-4.2L28%200l4.2.6L33.8%202l2.6%206%204.1%209.3L47%2029.9l2%203.8%201%203.4.3%201h.7v-.5l.5-7.2%201-8.7%201-11.2.3-3.2%201.6-3.8%203-2L61%202.6l2%202.9-.3%201.8-1.1%207.7L59%2027.1l-1.5%208.2h.9l1-1.1%204.1-5.4%206.9-8.6%203-3.5L77%2013l2.3-1.8h4.3l3.1%204.7-1.4%204.9-4.4%205.6-3.7%204.7-5.3%207.1-3.2%205.7.3.4h.7l12-2.6%206.4-1.1%207.6-1.3%203.5%201.6.4%201.6-1.4%203.4-8.2%202-9.6%202-14.3%203.3-.2.1.2.3%206.4.6%202.8.2h6.8l12.6%201%203.3%202%201.9%202.7-.3%202-5.1%202.6-6.8-1.6-16-3.8-5.4-1.3h-.8v.4l4.6%204.5%208.3%207.5L89%2080.1l.5%202.4-1.3%202-1.4-.2-9.2-7-3.6-3-8-6.8h-.5v.7l1.8%202.7%209.8%2014.7.5%204.5-.7%201.4-2.6%201-2.7-.6-5.8-8-6-9-4.7-8.2-.5.4-2.9%2030.2-1.3%201.5-3%201.2-2.5-2-1.4-3%201.4-6.2%201.6-8%201.3-6.4%201.2-7.9.7-2.6v-.2H49L43%2072l-9%2012.3-7.2%207.6-1.7.7-3-1.5.3-2.8L24%2086l10-12.8%206-7.9%204-4.6-.1-.5h-.3L17.2%2077.4l-4.7.6-2-2%20.2-3%201-1%208-5.5Z'%3e%3c/path%3e%3c/svg%3e)
'/%3e%3cuse%20xlink:href='%23a'%20transform='rotate(120%201203%201203)'/%3e%3cuse%20xlink:href='%23a'%20transform='rotate(180%201203%201203)'/%3e%3cuse%20xlink:href='%23a'%20transform='rotate(240%201203%201203)'/%3e%3cuse%20xlink:href='%23a'%20transform='rotate(300%201203%201203)'/%3e%3c/svg%3e)
%20scale(1.1436)'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20offset='0'%20stop-color='%23249361'/%3e%3cstop%20offset='1'%20stop-color='%233ecf8e'/%3e%3c/linearGradient%3e%3clinearGradient%20id='b'%20x1='36.156'%20x2='54.484'%20y1='30.578'%20y2='65.081'%20gradientTransform='translate(29.387%2060.096)%20scale(1.1436)'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20offset='0'/%3e%3cstop%20offset='1'%20stop-opacity='0'/%3e%3c/linearGradient%3e%3c/defs%3e%3cpath%20fill='url(%23a)'%20d='M102.24%20186.21c-3.267%204.117-9.904%201.862-9.977-3.397l-1.156-76.906h51.715c9.365%200%2014.587%2010.817%208.763%2018.149z'%20transform='translate(-27.722%20-60.338)'/%3e%3cpath%20fill='url(%23b)'%20fill-opacity='.2'%20d='M102.24%20186.21c-3.267%204.117-9.904%201.862-9.977-3.397l-1.156-76.906h51.715c9.365%200%2014.587%2010.817%208.763%2018.149z'%20transform='translate(-27.722%20-60.338)'/%3e%3cpath%20fill='%233ecf8e'%20d='M53.484%202.128c3.267-4.117%209.905-1.862%209.977%203.396l.508%2076.907H12.902c-9.365%200-14.587-10.817-8.764-18.149z'/%3e%3c/svg%3e)
'%3e%3cstop%20offset='.176'%20stop-color='%230052cc'/%3e%3cstop%20offset='1'%20stop-color='%232684ff'/%3e%3c/linearGradient%3e%3clinearGradient%20id='jira-original-b'%20gradientUnits='userSpaceOnUse'%20x1='16.641'%20y1='15.564'%20x2='10.957'%20y2='21.094'%20gradientTransform='scale(4)'%3e%3cstop%20offset='.176'%20stop-color='%230052cc'/%3e%3cstop%20offset='1'%20stop-color='%232684ff'/%3e%3c/linearGradient%3e%3c/defs%3e%3cpath%20d='M108.023%2016H61.805c0%2011.52%209.324%2020.848%2020.847%2020.848h8.5v8.226c0%2011.52%209.328%2020.848%2020.848%2020.848V19.977A3.98%203.98%200%2000108.023%2016zm0%200'%20fill='%232684ff'/%3e%3cpath%20d='M85.121%2039.04H38.902c0%2011.519%209.325%2020.847%2020.844%2020.847h8.504v8.226c0%2011.52%209.328%2020.848%2020.848%2020.848V43.016a3.983%203.983%200%2000-3.977-3.977zm0%200'%20fill='url(%23jira-original-a)'/%3e%3cpath%20d='M62.219%2062.078H16c0%2011.524%209.324%2020.848%2020.848%2020.848h8.5v8.23c0%2011.52%209.328%2020.844%2020.847%2020.844V66.059a3.984%203.984%200%2000-3.976-3.98zm0%200'%20fill='url(%23jira-original-b)'/%3e%3c/svg%3e)
%20-%20https://sketchapp.com%20--%3e%3ctitle%3ePBI%20Logo%3c/title%3e%3cdesc%3eCreated%20with%20Sketch.%3c/desc%3e%3cdefs%3e%3clinearGradient%20x1='50%25'%20y1='0%25'%20x2='50%25'%20y2='100%25'%20id='linearGradient-1'%3e%3cstop%20stop-color='%23EBBB14'%20offset='0%25'%3e%3c/stop%3e%3cstop%20stop-color='%23B25400'%20offset='100%25'%3e%3c/stop%3e%3c/linearGradient%3e%3clinearGradient%20x1='50%25'%20y1='0%25'%20x2='50%25'%20y2='100%25'%20id='linearGradient-2'%3e%3cstop%20stop-color='%23F9E583'%20offset='0%25'%3e%3c/stop%3e%3cstop%20stop-color='%23DE9800'%20offset='100%25'%3e%3c/stop%3e%3c/linearGradient%3e%3cpath%20d='M346,604%20L346,630%20L320,630%20L153,630%20C138.640597,630%20127,618.359403%20127,604%20L127,183%20C127,168.640597%20138.640597,157%20153,157%20L320,157%20C334.359403,157%20346,168.640597%20346,183%20L346,604%20Z'%20id='path-3'%3e%3c/path%3e%3cfilter%20x='-9.1%25'%20y='-6.3%25'%20width='136.5%25'%20height='116.9%25'%20filterUnits='objectBoundingBox'%20id='filter-4'%3e%3cfeOffset%20dx='20'%20dy='10'%20in='SourceAlpha'%20result='shadowOffsetOuter1'%3e%3c/feOffset%3e%3cfeGaussianBlur%20stdDeviation='10'%20in='shadowOffsetOuter1'%20result='shadowBlurOuter1'%3e%3c/feGaussianBlur%3e%3cfeColorMatrix%20values='0%200%200%200%200%200%200%200%200%200%200%200%200%200%200%200%200%200%200.0530211976%200'%20type='matrix'%20in='shadowBlurOuter1'%3e%3c/feColorMatrix%3e%3c/filter%3e%3clinearGradient%20x1='50%25'%20y1='0%25'%20x2='50%25'%20y2='100%25'%20id='linearGradient-5'%3e%3cstop%20stop-color='%23F9E68B'%20offset='0%25'%3e%3c/stop%3e%3cstop%20stop-color='%23F3CD32'%20offset='100%25'%3e%3c/stop%3e%3c/linearGradient%3e%3c/defs%3e%3cg%20id='PBI-Logo'%20stroke='none'%20stroke-width='1'%20fill='none'%20fill-rule='evenodd'%3e%3cg%20id='Group'%20transform='translate(77.500000,%200.000000)'%3e%3crect%20id='Rectangle'%20fill='url(%23linearGradient-1)'%20x='256'%20y='0'%20width='219'%20height='630'%20rx='26'%3e%3c/rect%3e%3cg%20id='Combined-Shape'%3e%3cuse%20fill='black'%20fill-opacity='1'%20filter='url(%23filter-4)'%20xlink:href='%23path-3'%3e%3c/use%3e%3cuse%20fill='url(%23linearGradient-2)'%20fill-rule='evenodd'%20xlink:href='%23path-3'%3e%3c/use%3e%3c/g%3e%3cpath%20d='M219,604%20L219,630%20L193,630%20L26,630%20C11.6405965,630%201.75851975e-15,618.359403%200,604%20L0,341%20C-1.75851975e-15,326.640597%2011.6405965,315%2026,315%20L193,315%20C207.359403,315%20219,326.640597%20219,341%20L219,604%20Z'%20id='Combined-Shape'%20fill='url(%23linearGradient-5)'%3e%3c/path%3e%3c/g%3e%3c/g%3e%3c/svg%3e)
'%3e%3cg%20transform='matrix(1.8232952,0,0,1.8232952,-597.71681,-124.12247)'%3e%3cg%20transform='translate(0,-91.137241)'%3e%3cg%20fill='%23eb3c00'%20transform='matrix(0.74069815,0,0,0.74069815,98.5698,-8.2505871)'%3e%3cpath%20d='m469.87,671.03,0-28.52,25.229-9.3238,13.711,4.3877,0,38.392-13.711,4.133-25.229-9.0691,25.229,3.0361,0-33.201-16.454,3.8392,0,22.487z'/%3e%3c/g%3e%3c/g%3e%3c/g%3e%3c/g%3e%3c/svg%3e)
By the numbers
20+ business customers run purchasing and sales through it — 12,000+ plants purchased and sold.
A sign-up flaw the team missed. A trend reading the wrong series. What having me on a project catches.