Harshdeep Saiyam

Multi-tenant B2B SaaS for consignment & resale stores  |  Next.js 14 · TypeScript · Supabase · QStash · Vercel AI SDK

• Architected a hybrid bulk-upload pipeline that bypasses Vercel's 4.5 MB payload limit: client uploads directly to Supabase Storage, a Next.js API enqueues one QStash job per image, and parallel workers run Gemini classification to create draft products — enabling 50+ concurrent uploads.
• Designed an AI price-prediction engine combining Tings retail-data API with progressive fallback queries, outlier filtering, and an LLM fallback — wired into product create/edit and bulk flows with debounced re-pricing and Open Graph image fetching.
• Built a real-time progress system on Supabase Realtime (WebSocket) with a 3-second polling fallback so bulk-upload state stays accurate under flaky networks.
• Shipped tiered consignment splits using JSONB price brackets in PostgreSQL with a five-level resolution waterfall (product → seller flat → seller tier → org tier → org flat) and bulk tier assignment UI.
• Owned the custom-fields system end-to-end — schema (definitions + per-product values, soft-delete, stable Shopify keys), CRUD APIs, drag-and-drop admin UI, AI-search integration, and Shopify metafield sync; 10 unit tests covering serialize/deserialize and upsert paths.
• Built a self-serve POS integration framework that lets store admins configure their own POS connections (Shopify, Square, Zettle, Tellix) by entering API keys and secrets through the UI. Designed reusable config and webhook scaffolding over auth, product sync, and inbound events so adding a new POS becomes a config-and-adapter change rather than a rewrite.

~6 years across web and mobile delivery for clients in the US, NZ, and Canada

• Patra (USA): built event-driven microservices on AWS EventBridge and revamped a Next.js UI codebase, materially improving scalability and load characteristics.
• Realwave (USA): developed reusable React components and integrated cloud-based smart-locking systems for keyless remote door control with real-time monitoring dashboards.
• Truggit (NZ): built a cross-platform React Native marketplace with real-time job listings and Google Maps integration.
• EMS (Payroll): refactored the UI of an Employee Management & Payroll app — cut page-load time by ~30% via Next.js dynamic imports, lazy loading, and tighter state management.
• Platform & Infra: migrated a manual checkout to Stripe for a Canadian e-commerce client; led SQL → PostgreSQL migration and adoption of microservices; published reusable UI packages via AWS CodeArtifact; built a custom Android POS app on React Native tailored to terminal hardware constraints.