Archade

Full-stack architect responsible for the complete platform. Designed 50+ table relational schema modeling project-contributor-company-product attribution graphs. Built percentage-based hotspot coordinate system enabling clickable product discovery within images. Integrated OpenAI API for ARQ AI material visualization engine generating photorealistic renderings. Implemented collaborative filtering recommendation algorithms processing 2.3M monthly interactions. Created multi-tenant RBAC with 4 permission tiers (owner/admin/member/guest) across 3 entity types. Optimized query performance with LRU cache (1000 item capacity), TTL-based invalidation (5-60min), and category-specific strategies reducing DB load by 70%. Built PWA with service workers handling 20MB offline data and background sync queuing.

Designed attribution graph handling 50+ interconnected tables with circular dependency management using PostgreSQL constraints and FK cascades. Created percentage-based hotspot system (x:y coordinates as decimals 0.0-1.0) stored in JSONB, rendering with CSS calc() for responsive images across all breakpoints. Integrated OpenAI DALL-E 3 API with prompt engineering for material-to-photorealistic conversion, handling 400ms average latency with fallback strategies. Built brand inquiry tracking system with email webhooks processing 200+ inquiries daily. Implemented collaborative filtering using PostgreSQL vector similarity (cosine) with user-behavior matrices, updated real-time via Supabase triggers. Optimized cache hit ratio to 82% using multi-layer strategy: Redis (hot data, 5min TTL), PostgreSQL cache tables (warm data, 30min TTL), CDN edge (static, 24h). Built full-text search with tsvector columns and PostgreSQL trigram indexes, supporting 10K+ documents with <100ms query time. Architected multi-tenant isolation using Row Level Security policies with 15+ dynamic predicates checking org/team/project membership. Implemented PWA with IndexedDB storing 20MB offline-first data, workbox service workers with stale-while-revalidate for instant loads. Created analytics pipeline processing 2.3M events/month using window functions for trending scores, engagement rates, and cohort analysis with <2s dashboard load time across all metrics.

Created the first social platform solving AEC's attribution problem with verifiable project-product relationships. Built interactive hotspot system allowing architects to click images and discover exact materials used—transforming 50K+ project-product connections into interactive discovery. Enabled brand manufacturers to showcase products in actual projects, with inquiry tracking converting to 15% lead-to-opportunity rate. Achieved viral growth with 85% DAU (daily active users), 2.3M monthly page views across 2,500+ professionals, and 100K+ monthly social interactions. Platform processing 500+ brand inquiries/month with $15K MRR potential as sole developer.