John Y

AI Automation & RAG Systems Developer

Lorenz Commerce • Freelance

Dec 2025 - Present • 5 mos

Develop and deploy enterprise-grade AI automation systems using n8n, vector databases, and LLM integration for SaaS platforms serving multiple business clients. Key Projects & Achievements: LORENZ COMMERCE - Multi-Tenant AI Consultant System: - Built complete RAG (Retrieval-Augmented Generation) architecture using Weaviate vector database - Implemented multi-tenant data isolation with tenant_id filtering ensuring secure data boundaries - Developed AI Agent with professional consultant persona using system-level prompt engineering - Created automated data ingestion workflows (Phase 1) and intelligent query systems (Phase 2) - Integrated OpenAI API, Slack notifications, and cross-departmental analysis capabilities Technical Implementation: - Chain-of-thought reasoning in AI responses - Source citation and formatted structured answers - Opportunity/risk analysis automation - Scenario forecasting capabilities - Conversation summarization with context retention - Anti-hallucination safeguards and tenant boundary enforcement Infrastructure & Security: - Managed production VPS deployment on Hetzner (157.90.168.45) - Handled critical security updates (n8n CVE vulnerabilities from 2.1.4 to 2.5.2+) - Ensured zero-downtime updates across complex workflow systems - Configured HTTPS exposure on port 443 with proper security hardening Technologies: n8n, Weaviate, OpenAI API, Slack API, Docker, VPS Management, RAG Architecture, Multi-Tenant Systems