AI Engineer
Autonomous AI Data Analyst Platform & Multi-Agent Investigation Engine
Built a production-oriented autonomous AI data analyst platform that combines multi-agent orchestration, Text-to-SQL analytics, statistical analysis, cross-modal RAG, LLM routing, and automated executive reporting to investigate complex enterprise business questions.
- Engineered an autonomous multi-agent analytics platform using Python, FastAPI, and LangGraph, orchestrating 8 specialized AI agents for zero-shot intent classification, Text-to-SQL generation, statistical anomaly detection, and cross-modal Vector RAG across 581,718+ (15m+ development) structured business records with sub-300ms pipeline latency.
- Architected a fault-tolerant 4-tier LLM routing architecture spanning local Ollama (Llama 3.2), OpenAI GPT-4o-mini, Google Gemini, authenticated Hugging Face Spaces (Llama-3.2-3B), and offline rule-based fallbacks, dynamically routing analytical workloads across local, cloud, and offline inference paths.
- Built an AST-validated Text-to-SQL pipeline with 100% read-only parse-tree enforcement, schema-aware query generation, and PostgreSQL/SQLite execution across 5 core business entities, enforcing database access guardrails for LLM-generated queries.
- Developed a cross-modal RAG investigation engine linking quantitative SQL results with unstructured operational incident logs through hybrid vector retrieval, successfully connecting Causal Event IDs such as SC-2025-003 and PL-2025-001 with 100% Recall@5.
- Implemented a Critic Fact Validation Agent that independently audits LLM-generated claims against raw database execution results and retrieved evidence, using bounded retry loops and evidence validation to reduce hallucinations and improve the reliability of final analytical responses.
- Developed an automated executive deliverable compiler that transforms autonomous analytical findings into interactive Plotly.js visualizations, ReportLab PDF executive reports, and openpyxl Excel workbooks, delivering multi-format business intelligence directly through the analyst interface.
- Established a 12-metric automated evaluation and observability framework tracking SQL accuracy, AST safety, RAG retrieval performance, hallucination detection, token usage, latency, and agent execution traces, achieving a 100% pass rate across defined target scenarios.
- Built a full-stack ChatGPT-style analytics SPA using FastAPI, WebSockets, asynchronous streaming, persistent chat sessions, benchmark/history navigation, and interactive system architecture tracing, providing an end-to-end interface for autonomous enterprise data investigation and analysis.