HC
Healthcare
9 deploymentsMulti-site operations work spanning payroll engines, turnaround-time analytics, compensation dashboards, and reference tooling. Several systems process multi-million row datasets per cycle across siloed source systems.
Op Code
System
Stack
Status
HC-01
Multi-Site Payroll Automation Engine
Dual Power Automate flow architecture unifying roster, schedule, premium-pay, on-call, and time-tracking sources into a single payroll-ready output for organizations operating across multiple practice locations. Schema-agnostic intake handles different upstream data shapes; the working dataset spans tens of thousands of providers and shift records per cycle, with the underlying source tables routinely exceeding several million rows.
Multi-Million Row Pipeline
Microsoft 365 · Power Automate · Office Scripts · DAX
In Production
HC-02
Performance Analytics Dashboard Suite
Operational performance dashboards delivered on a recurring schedule across multiple hospital systems, departments, and facilities. Same underlying architecture is redeployable per business line. Backing data tables routinely exceed several million records.
Multi-Million Row Pipeline
Chart.js · Power Automate · Power BI · Microsoft 365
In Production
HC-03
Imaging Backlog & Modality Dashboard
Daily-refreshing analytical dashboard with matrix tables, cross-filtering, and slice-by drilldowns across modality, site, and reading provider. Power BI DAX query backend feeding Power Automate-rendered HTML.
Power Automate · Power BI · DAX · HTML / JS
In Production
HC-04
Compensation Pool & Cost-per-RVU Dashboard
Director-facing multi-tab dashboard ingesting monthly compensation pool reports across multiple practices into a unified master database. Trend analysis at monthly, quarterly, and YTD granularity. Architecture scales to N practices without per-practice rebuild.
Power Automate · DAX · Master DB · Chart.js
In Production
HC-05
Provider Reading-History Reference Tool
Self-contained HTML reference tool combining historical reading volume with live shift-schedule data. Refreshed daily via Power Automate using the Excel Table API for sub-30-second batch merge operations on cell counts in the hundreds of thousands.
525K+ Cell Daily Refresh
Office Scripts · Power Automate · Excel Table API
In Production
HC-06
Configuration-Driven Compensation Engine
Replaced flat-rate compensation arrays with per-shift rate and target configuration sourced from a central config workbook. Editable RVU totals, dynamic pay-card generation, and per-provider HTML shift reports.
HTML / JS · Excel · Custom Config
Shipped
HC-07
Centralized PTO Tracker with Co-Authoring
Excel-native tracker using Data Validation and SUMPRODUCT formulas designed specifically for OneDrive co-authoring compatibility — no Power Automate or external tooling needed. Supports concurrent edits across a small team.
Excel · OneDrive · Data Validation
Sustained
HC-08
Cross-License BI Export Platform
PowerApps architecture giving users on free or limited Power BI licenses access to the same underlying data exports as Pro license-holders. Removes a recurring license-cost blocker for non-analyst users.
PowerApps · Power BI · SharePoint
Shipped
HC-09
Practice Scorecard Distribution Workflow
Power Automate flow distributing practice-specific performance scorecards on demand or on schedule. Pulls from Power BI exports, applies practice-level filtering, and packages a branded report per recipient.
Power Automate · Power BI · OneDrive
Sustained
LE
Law Enforcement
10 deploymentsDaily-updating analytical dashboards, intelligence reporting platforms, geospatial review tools, and recurring records-reporting automation. Built around CJIS-conscious architecture — most run on-premises or inside agency-controlled tenants with no third-party cloud exposure.
Op Code
System
Stack
Status
LE-01
Crime Analytics Dashboard (Daily)
Daily-updating analytical dashboard showing call volume, hot-spot density, beat-level trends, and customized roll-up reports for command staff. Time-driven trigger ingests CAD and records-management exports automatically.
Apps Script · Chart.js · Time-Driven Triggers
In Production
LE-02
Analyst Collaboration & Subject-Report Platform
Internal platform giving analysts the ability to generate subject reports, communicate in-context, and coordinate quick-response data sharing across units. Self-hosted inside existing organizational infrastructure with role-based access.
HTML · Apps Script · APIs · Role-Based Access
In Production
LE-03
Monthly Internal Newsletter Dashboard
Twelve-iteration production tool generating a fully interactive sidebar-navigated monthly recap from a single Excel input. Sections cover arrests, dispatches, cases, traffic stops, citations, warrants, and more. Cross-filtering, PDF export, and section-level deep links.
Python · ApexCharts · Tailwind · Google Sites
In Production
LE-04
Supervisor Monthly Report
Supervisor-facing variant of the monthly newsletter — same data source, different audience, focused on unit-level performance and staffing patterns.
Python · ApexCharts · Tailwind
In Production
LE-05
Quarterly Newsletter Dashboard
Quarterly compilation with stat aggregation, trend analysis, and roll-up across all monthly inputs. Engineered to stay under Google Sites' 17M character hosting limit through targeted JSON capping and modal de-duplication.
Python · ApexCharts · Optimized Output
Shipped
LE-06
CompStat-Style Crime Analytics Dashboard
Three-tab dashboard: an Overview surface, a Hot Zones tab using Leaflet heatmaps, and a Response Times tab with priority breakdowns, hourly and day-of-week trends, and distribution histograms.
Python · Leaflet (heat) · ApexCharts
Shipped
LE-07
Monthly Arrest Booking Report
Newsletter-style HTML transforming raw arrest exports into a stats-card overview, time-of-day / day-of-week / age / charge-type charts, and individual card-view records for each booking. Time-driven generation per month.
Python · Chart.js · BeautifulSoup
Shipped
LE-08
Quarterly Arrests Report Aggregator
Multi-month rollup with trend analysis, comparative bar charts, and quarter-over-quarter delta calculations. Reads multiple monthly HTML exports and produces a single consolidated quarterly view.
Python · Chart.js · HTML Parsing
Shipped
LE-09
Operational Verification Platform
HTML report cross-referencing telemetry from multiple agency systems against geospatial movement data. Map-based investigative review tool rendered with embedded Leaflet maps.
Python · Leaflet · Geospatial Cross-Reference
Shipped
LE-10
Public Records Request Data Processing
Structured intake and processing platform for public records requests with widely varying source formats and scopes — a few hundred records in one request, hundreds of thousands in the next. Built to normalize whatever a requesting agency or attorney hands over (CSV, multi-tab Excel, raw HTML exports, PDFs of structured tables) into a single queryable, filterable workbook ready for downstream analysis or production.
Varying Dataset Sizes & Shapes
Python · Excel · Data Normalization · Multi-Format Intake
Sustained
GOV
Government
Under NDAActive government engagement involving centralized inter-agency case data infrastructure and tenant-level platform work for a federal grant-funded program. Details cannot be disclosed publicly while the engagement is finalized. Reach out directly if relevant — deeper context can be shared under a mutual NDA.
// CLASSIFIED · PENDING DISCLOSURE
Engagement under NDA
Capabilities demonstrated in this sector include cross-agency database design with access-control modeling, validation pipelines for structured intake from partner organizations, and platform-level migration work between commercial and government cloud environments. Technical details available upon request.
CN
Construction
2 deploymentsA start-to-finish construction project management platform built for the firms that can't justify enterprise-tier per-seat licensing on platforms like ProCore. Same capabilities — project tracking, financial management, document generation, photo documentation — at a fraction of the per-month cost, owned and operated by the firm itself.
Op Code
System
Stack
Status
CN-01
Full-Lifecycle Construction Project Management Platform
A ProCore-class platform without the ProCore-class price tag. End-to-end project tracking covering the full lifecycle: budget vs. actual financial tracking, contract and amendment history, change-order log, PCO / COR / ROM status tracking, milestone timelines, daily-spend analytics, pay-application reconciliation, photo documentation, and director-facing reporting. Handles 18+ active projects per cycle from a single master workbook, with per-project routing and per-site sub-folders for photos and supplemental data.
18+ Projects Per Cycle · Full Project Lifecycle
Python · HTML / PDF · openpyxl · ApexCharts · Photo Pipeline
In Production
CN-02
Project Documentation & Billing Suite
The paperwork layer of the platform: branded service agreements, scope-of-work documents, project cost sheets, retainer agreements, and invoicing with consistent numbering. All generated from structured project metadata, all designed to match the firm's identity, all under version control.
Python · ReportLab · Branded Templates
Shipped
SB
Small Business / Wellness
2 deploymentsCustom websites, content-management systems, branded asset kits, and the operational back-office tooling that owner-operators have been managing in their heads or in scattered spreadsheets.
Op Code
System
Stack
Status
SB-01
Editorial Website + Content Management Build
Custom dark-editorial website with a content-management back end for editing pages, articles, and assets without touching code. Includes a Writing section with dynamic article pages, full design system (typography, color tokens, layout grid), and an accompanying PDF document kit for client-facing collateral.
Custom Design System · CMS · Dynamic Pages · PDF Kit
Shipped
SB-02
CodeWarrior Brand & Identity System
Internal brand identity for CodeWarrior, LLC — logo system, color palette, typography, document kit (agreements, invoices, cost sheets with consistent invoice numbering), and this very website. Used as a reference build for what's possible at the small-business tier.
Visual Identity · Custom HTML / CSS · PDF Kit
In Production
Open for new engagements
Have a workflow that
should run itself?
If anything above resembles what you're up against, let's talk. Direct reply within 24 hours, scoping call if it's a fit, or an honest "not my lane" referral if it's not.
Start a Project