Alex Novak

Case studies

Decisions made before writing code: diagnosis, audits, migrations. Client names removed, numbers are real.

Architecture / Billing

Payment and CRM providers became configuration, not code

An online school with 10,000+ students got its own billing and student accounts, synced with the course platform. Switching CRM took 48 hours instead of a rewrite.

Yii2 WordPress REST API WayForPay Fondy Pipedrive Mailchimp
before
6 systems with no sync, changing a provider meant a rewrite
after
CRM switched in 48 h, one codebase for several branded portals
Diagnosis / Production

A CPU profile found the cause, not the timing

An internal analytics dashboard froze for up to two minutes and restarted. Within a day the freeze dropped from 83 to 28 seconds, and the follow-up plan removes it.

Node.js PostgreSQL Docker worker_threads
before
freezes up to 122 s, container restarts
after
28 s the same day, a 3-step structural plan
Audit / Build vs buy

Products went missing, and Adobe wasn't why: auditing a render farm before replacing it

A company wanted to replace an expensive render farm. The audit showed products were lost to five bugs in their own code, which any new tool would have inherited.

AWS Adobe Illustrator / Photoshop SQS Lambda
before
~$6.7k/month, queue waits up to 8.5 h, products going missing
after
a plan with ~$2.5k/month of quick savings and a replacement pilot
Digital Commerce

From 15-minute manual fulfillment to 30-second automated delivery

E-commerce reseller processing 110+ weekly orders across 3 vendor platforms — no public APIs, CAPTCHA-protected portals, race conditions causing duplicate deliveries. Rebuilt as a fully automated pipeline with atomic inventory operations, browser automation, and 5-level retry.

n8n Python Browserless WooCommerce NocoDB
before
27 hrs/week
after
30 sec/order · 99.9% accuracy
Data / Migration

Money fields don't move without a discrepancy report

Money fields were moving from a CRM into the company's own system. A parity check before the switch found 13k discrepancies and ~1.4M changes that would have quietly altered how the system behaves.

Salesforce PostgreSQL GraphQL
before
8 money fields in two systems, discrepancies unknown
after
a report before the switch, a decision for each group of discrepancies
Audit

A pre-launch audit found a breakage already live in production

Before a communication engine opened to a wider audience, I checked everything marked as done. The audit found 17 untracked tasks and 3 critical issues.

PostgreSQL Salesforce Node.js
before
"verifying in production" statuses, risks unknown
after
3 critical issues found before the wider launch
Audit / Architecture

Architecture Review

For business owners who want their current or planned automation checked before they commit time and budget to it.

Current state Failure modes Architecture map
before
Stack accumulated, undocumented
after
Architecture map + risk register
E-commerce / Retail

From dual-system management to a single CRM workspace

Sales team managed products in their CRM but had to separately log into the online store — data drift, orders invisible in CRM without manual entry. Built bidirectional sync with schema translation between incompatible APIs and CRM-controlled publish flags.

n8n Dynamics 365 OData v4 OpenCart NocoDB
before
Dual-system manual sync
after
Orders in CRM within minutes
Own product

Production AI assistant: 12 n8n workflows, hybrid RAG, 9-service infrastructure

Proactive AI partner for SMB owners delivering briefings, deadline pushes, and voice commands via Telegram. Hybrid memory (Redis + PostgreSQL + Qdrant), multi-tenant RAG, AI agent with 10+ tools, queue-based notification system. Shipped in 12 weeks.

FastAPI n8n Qdrant PostgreSQL OpenAI GPT-4o
before
Greenfield SaaS product
after
94 files · 9-service infra · 12 weeks