Case Studies

Each case study follows the same shape: Problem → Architecture → Stack → Interesting decisions → Lessons learned. Built to be cited.

Live demos

Two live examples: one shows a spreadsheet becoming a controlled operations system; the other connects Shopify to revenue, inventory, and team time.

● LiveSQLite + Astro

demo.kamensky.dev

See a 10-tab retail workbook become a searchable, multi-user operations system with reconciled data, change history, and live reporting.

● LiveShopify

polaris.kamensky.dev

See Shopify orders, stock alerts, returns, and fulfillment connected in one workflow. The impact board shows revenue protected, hours saved, and tickets avoided.

★ FeaturedDemonstration project

Taking Over Broken AI-Built Systems: Rescue, Fix, or Migrate

Takeover service for broken, half-finished systems built with AI app builders, Claude/ChatGPT, or 'system builders': audit what exists, back up the data first, then fix, migrate, or rebuild.

Outcome A verdict in days, not months: either a bounded fix with a real price tag, or a migration plan with real numbers — with a full backup of every business record taken before anything is touched.
  • TypeScript
  • Express
  • SQL Database
  • React
★ FeaturedClient project · anonymized

Migrating an AppSheet CRM to Express + Relational Database

Replaced an AppSheet CRM hitting latency and pricing ceilings with a typed Express backend, relational database, and custom React interface — with 100% verified source-record reconciliation.

Outcome Cut manual data-sync from ~6 hrs/week to near-zero; eliminated the daily row-count reconciliation; flattened a per-seat cost line that scaled with headcount.
  • TypeScript
  • Express
  • SQL Database
  • React
  • Vitest
Client project · anonymized

When a Custom CRM Is Cheaper Than Salesforce

A small operations team did not need a six-figure CRM rollout. A focused customer workspace removed spreadsheet handoffs, protected follow-up revenue, and cost less than Salesforce's subscription and implementation burden.

Outcome Replaced recurring spreadsheet reconciliation and a proposed Salesforce rollout with a focused CRM workspace: one customer record, accountable follow-ups, and a lower total cost for the first three years.
  • TypeScript
  • Express
  • SQL Database
  • React

Working with me — risk-free engagement

Hiring an independent consultant you found online is a trust decision. Here is the concrete shape of an engagement — so you know what you are buying before the first call.