Miguel Marinho portfolio case study

Agentic GenAI Assistant by Miguel Marinho

A portfolio case study by Miguel Marinho on a production Azure Databricks AI agent that unifies document Q&A, live data analysis, and prompt-driven reporting for supply-chain teams.

Summary

Miguel Marinho leads a production-grade AI agent on Azure Databricks that turns supply-chain business requests into governed AI workflows. The system gives teams one natural-language interface for grounded document answers, live SQL analysis, and shareable business reports.

Problem

Supply-chain teams needed one governed assistant for both knowledge retrieval and analytics: trustworthy answers from SharePoint documents, safe access to live Databricks data, and a faster path from business questions to usable reports.

My role

Miguel leads the architecture, delivery, and deployment of the agent, spanning retrieval, Text-to-SQL, natural-language reporting, human-in-the-loop evaluation, LLMOps, least-privilege access, and Azure DevOps CI/CD across SIT, QA, and Prod.

Architecture

  • Knowledge Agent: retrieval-augmented Q&A over curated internal documents, ingested, chunked, and indexed with Mosaic AI Vector Search, returning grounded answers with in-context document images.
  • Text-to-SQL Agent: users ask business questions in plain English; the agent retrieves table and column metadata through vector search, generates Databricks SQL, and executes it against a SQL Warehouse through the Statement Execution API.
  • NL-to-Report Generator: users describe a report in plain language; the agent produces an API-consumable config that a deterministic service compiles into SQL, executes, and serves as a shareable report.
  • Human-in-the-loop evaluation: thumbs-up/down feedback is logged and surfaced in Databricks dashboards for systematic review and targeted quality improvement.
  • Orchestration and LLMOps: agentic routing, evaluation, tracing, lineage, custom deployment, least-privilege access, and CI/CD across SIT, QA, and Prod.
  • AI-augmented development: Cursor agentic coding workflows with repo-aware context, custom rules, SKILL.md procedures, and MCP-connected internal tools.

Outcomes

  • Supply-chain users can move from question to answer, query, or report without jumping between documents, SQL tools, and self-service reporting workflows.
  • The assistant preserves traceability and governance through grounded retrieval, deterministic reporting services, Databricks controls, and least-privilege service principals.
  • The project established a production-ready agent architecture spanning retrieval, analytics, reporting, evaluation, CI/CD, and continuous improvement from user feedback.