Portfolio / CV

HECTOR ARZATE

ENTERTAINMENT ARTIST AI ENGINEER

I build production AI systems — and I design backgrounds, characters, props. Credits on Jurassic World: Chaos Theory, Rick and Morty, and Monster Hunter: Legends of the Guild. Currently shipping multi-tenant RAG products in TypeScript.

scroll

01 / AI & Engineering

Production AI systems, from OCR ingestion to cited answers and automated quotes.

Modular Multi-Tenant AI App

Case study locked AI · RAG · SaaS 2025 — 2026

Multi-tenant AI assistant for construction tenders. Clients upload heterogeneous bid documents (PDF, Word, Excel, DWG, scans); the system parses with an OCR pipeline, indexes with semantic chunking + embeddings (pgvector), and answers in natural language with real citations. Generates fully-priced Excel quotes by matching extracted concepts against the client price catalog.

  • RAG: semantic chunking, Ollama/OpenAI embeddings, pgvector retrieval with MMR re-rank
  • LLM chat with streaming SSE + server-side tool loop (search, full-file read, FTS catalogs, web search)
  • Multi-tenant auth with Postgres RLS + JWT + SSO
  • Parser workers: OCRmyPDF, LibreOffice, Tika — PDF/DOCX/XLSX/DWG/images
  • ~9,500 lines of production TypeScript; pnpm monorepo, Docker, Postgres, Redis, MinIO
  • Real case: 17 PEMEX tender files parsed and indexed in ~45s, quote with ≥70% prices auto-resolved

BearShark OS

SaaS · Coffee Ongoing

Multi-tenant SaaS platform for coffee roasteries and connected specialty coffee shops — inventory, production, B2B sales, contract roasting, and automated reordering between roastery headquarters and retail locations.

  • Roastery: green coffee inventory, contracts, production scheduling, packaging, stock control, B2B orders
  • Coffee shop: point of sale, menu management, sales metrics, automatic reorder from HQ
  • Next.js 14 App Router, Drizzle ORM, PostgreSQL with Row-Level Security
  • Local admin app built with Tauri
  • Per-tenant subdomains with role-based access — owners, managers, staff, baristas
  • Contract roasting workflows and automated replenishment across roastery ↔ retail

Company Portal Platform

Case study locked Full-stack · Platform Ongoing

Company-wide portal system: payments automation, distributor and client management, licensing administration, and embedded SaaS apps — one platform organizing the whole business.

  • Payment automation and billing flows
  • Distributor / client / license management portals
  • Multiple production sites and e-commerce fronts (Ecosoft, OPUS)
TypeScript · Next.js · React · Astro · Tauri Postgres · Drizzle · pgvector · Redis · Docker Multi-tenant SaaS · RAG · LLM tool-use · OCR pipelines

Side builds — made when bored

02 / Entertainment

Visual Development Artist & Matte Painter for film, TV and animation.

Screen credits

IMDb →

Original projects — writer / director / producer

I reused an old project that was inspired by What We Do in the Shadows, but instead of vampires it was about pirate roommates. Then Taika telepathically stole the idea I had stolen first, so I decided to produce something myself and opened a specialty coffee brand to try to recover some of the money.