I build the system that runs the work your team repeats every week.

For operations teams with work moving by hand between inboxes, spreadsheets, and the software they already use. It runs on a schedule, and every run is logged.

JT Somwaru

Recent work spans marketing analytics, property management, construction, and real estate.

Who I help

Where the first build usually lands

The first build is usually one workflow that runs every week and depends on one person being available.

Recurring work that runs on one person

One person holds the workflow, and it moves when they get to it. I build the version that runs on a schedule, so it stops waiting on someone to be at their desk.

  • Status dashboards
  • Inbox routing
  • Approval queues

Reports someone rebuilds by hand

The completion figure people quote in the meeting came from a cell somebody set by hand, and it went stale the moment the detail underneath it changed. I build the dashboard that works it out from the detail instead.

  • Job dashboards
  • Client dashboards
  • Owner updates

Follow-up that depends on someone remembering

Nothing has complained, so everyone assumes the COI chase is still working. I build the expiration and renewal workflow, and it runs inside your own environment.

  • COI tracking
  • Renewal chasing
  • Audit trails
Client work

What was manual, and what runs now.

Where a figure is missing it is because it was not measured in a way I can hand you.

QA Agent and Client Dashboards

  • Fixed Scope
  • QA
  • Dashboards
  • Paid client work
Problem

A marketing analytics firm needed two client dashboards, a dashboard onboarding playbook agent, and a QA agent, all inside a fixed four-week scope.

What was built

All four, in scope. The QA agent was validated against a controlled test plan written by the client's technical lead.

Independently re-verified by the client's technical lead on client systems before acceptance. Against his test plan the QA agent caught every seeded defect and surfaced real defects in existing production code, which the client confirmed and fixed.

Local-First Property Operations Automation

  • Self-hosted
  • Audit Trail
  • Property Ops
  • Active client work
Problem

A New York City property management firm needed automation around sensitive back-office work without moving financial or resident records into another SaaS layer.

What was built

Self-hosted automation running inside the client's own environment, handling insurance expiration tracking and rent delinquency outreach, with every run logged.

In production with daily insurance tracking and weekly rent delinquency outreach

Construction Progress Dashboard

  • Dashboard
  • Construction Ops
  • Client Work
  • Paid client work
Problem

A construction firm was assembling progress reports by hand before every stakeholder check-in.

What was built

Construction progress dashboard turning field updates into live status visibility and stakeholder reporting.

Live dashboard for active job-site visibility

See all client work

Products

COI Desk

For general contractors and specialty trades.

Renewal chasing depends on someone remembering, and ownership of each certificate is unclear.

COI Desk tracks certificates and expiration dates, sends reminders, escalates follow-up, and flags missing or duplicate records for the person who owns them. A smaller portfolio gets the follow-through of a managed COI service without its yearly minimum.

It does not judge whether coverage is adequate.

Book a COI Reliability Audit call

Delinquency Desk

For self-managed owners and small operators.

The weekly delinquency report arrives, but the notices and follow-up still depend on someone working every row.

Done for you, run for you, and logged. Delinquency Desk reads the delinquency report your property software already exports, checks your Do Not Contact list, sends every remaining qualifying tenant a notice from your own mailbox, copies your managers on every notice, and logs each send.

Live today on AppFolio. Other systems are set up during onboarding. It does not replace legally required notices.

Book a delinquency workflow call

Compliance Deadline Desk

For NYC managing agents and owners with buildings due this LL152 cycle.

Local Law 152 sets a December 31, 2026 deadline for buildings in the gas piping sub-cycle covering community districts 4, 6, 8, 9, and 16, and a building with no gas service still has to file confirming that status.

The LL152 Deadline Sprint confirms your building list, sorts each building into inspection needed, no-gas certification, or exempt, chases the plumber and the super every week with a status email, keeps the owner in the loop only when you want that, and delivers a proof packet per building by December 31.

Your licensed master plumber inspects and certifies. This does not include the inspection, repairs, DOB fees, or a guarantee of DOB acceptance.

Book a Compliance Deadline Desk call
Workflow Audit

Five business days. One named workflow. A clear build decision.

Pick the workflow that costs you the most. I spend five days mapping how it actually runs, not how it is supposed to run. At the end I tell you what to build first, or whether to build at all.

5 days

timeline

1

workflow

30 days

credit window

Fixed audit fee

$1,500, paid on signature and credited to the build if signed within 30 days.

Book a 20-minute workflow call

Workflow map

Which report anyone actually trusts, and where work sits waiting.

Exception inventory

Everything expired, missing, or waiting on an approval, with the reason it stopped and who owns it.

Build-or-do-not verdict

Sometimes the answer is do not build yet. If the inputs are dirty, automation will move the mess faster. I will tell you that.

Fixed-price build scope

If it is ready, you get one build at a fixed price, with what counts as done written down before I start.

  1. 01

    Workflow Audit

    One workflow mapped in five business days, ending in a build decision.

  2. 02

    Fixed-price build

    Quoted after the audit, with what counts as done written down before work starts.

  3. 03

    Monitoring after launch

    Optional monthly support covering heartbeat alerts if a workflow stops, and fixes when something upstream changes.

Internal Workflow Automation

How I work

The first days go into deciding what to build.

  1. 01

    Map the real workflow

    I follow the work. Which file, which inbox, who approves it, and what happens when the data is wrong.

  2. 02

    Rank the bottlenecks

    What it costs to run by hand, and how dirty the inputs are. Some of these will not be worth automating and I will say so.

  3. 03

    Scope the first system

    One build, at a fixed price, with what counts as done written down before I start.

  4. 04

    Build it into production

    Dry runs and logs first. It runs on its own only after it passes testing.

About

I spent six years as a Business Systems Analyst at Spectrum Enterprise, working out how operations teams actually ran and getting the systems changed to match. Most of that job was ownership and exceptions. Who holds each step, what happens when the data is wrong, and which cases everyone had agreed to handle by hand.

I do that same work now and build the system at the end of it. I map the workflow, scope it, build it, and put it into production myself. Nothing gets lost handing the problem from the person who understood it to the person who built it.

The systems run in the client's own accounts and log every run. A workflow only runs on its own after it passes testing, and the cases it must skip are agreed before it goes live. A build I have checked myself is not finished. Somebody else has to be able to check it.

Experience

Independent

AI Implementation Consultant

Sep 2025 to Present

Spectrum Enterprise / Charter Communications

Business Systems Analyst

Jun 2019 to Aug 2025

Northeastern University

Data Analytics Certificate

2019

Ithaca College

BS Sport Management, Minor Legal Studies

2014 to 2018

Client Results

Construction and real-estate client

Built a live AI dashboard for an active construction program, and separately automated a recurring market-research workflow.

Property operations client

Built local-first automation infrastructure for sensitive back-office workflows, with a dedicated workflow machine, an audit trail, daily run summaries, alerts if a workflow stops, and recurring compliance automation.

Tools & Systems

AI & Automation Stack
  • n8n
  • Claude API
  • OpenAI API
  • Salesforce Agentforce
  • AgentScript
  • HubSpot CRM
  • Google Sheets API
  • OpenClaw
Adjacent Technical Fluency
  • Python
  • SQL
  • REST APIs
  • Vercel

Start with one workflow.

Tell me the workflow that costs you the most. I reply within 24 hours with whether it is a fit for an audit and what I would need to map it.

jtsomwaru@gmail.com
Book a workflow call
Response within 24 hours.