roy.levy

Proof of work

Case studies

The thinking, trade-offs, and results behind the work.

  • Building NichePressa: An AI Publishing Engine for Catalog-Based Websites

    AI-assisted publishing workspace for niche sites, catalog-driven blogs, affiliate projects, and small content teams that need repeatable publishing workflows without turning every article into a blank ChatGPT session.

    AI Publishing SaaS · June 2026

    Workspace onboarding, voice analysis, catalog imports, structured content planning, multi-model AI generation, MDX components, GitHub publishing, Stripe billing, and Postgres RLS tenancy.

    Read case study

  • The Migration Finished. The Dashboard Still Said Zero.

    When row counts and foreign keys looked fine but the executive dashboard lied—closing the gap between what the database stored and what the business meant.

    Fighting Online Antisemitism · May 2026

    Working directly with management: ETL (Azure Postgres → Neon), schema and model work, SQL read models, BI semantics, and Next.js where it sits in the product stack.

    Read case study

  • Sniffo.ai

    Full-stack SaaS that turns Reddit threads, competitor pages, and market signals into scored, actionable opportunities.

    Market Intelligence SaaS · May 2026

    Reddit monitoring, competitor tracking, pricing-change signals, opportunity scoring, AI reply drafts, notes, statuses, and usage-aware plan limits.

    Read case study

  • Raith Rovers Scouting Platform

    A high-performance full-stack web application for football club operations, combining tactical squad management with a deeply customizable, data-heavy scouting engine.

    Raith Rovers Football Club · June 2025

    Data-heavy scouting workflows, weighted ranking, and faster search across large player datasets.

    Read case study

  • Collective Memory

    AI-powered social mobile MVP with image tagging and vector-based discovery

    Social content platform · October 2024

    Mobile MVP backed by a custom Node.js/Express API, MongoDB, and a Vertex AI pipeline for tagging, embeddings, and related-image discovery.

    Read case study