Skip to content
View andresaragon's full-sized avatar

Block or report andresaragon

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Content in all repositories owned by your account will be closed.
Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. This note will only be visible to you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
andresaragon/README.md

Santiago Andrés Aragón Guzmán

Español

AI Engineer & Senior Database Architect | Applied AI Systems (RAG, AST Firewalls, Multi-Agent Orchestration) · Enterprise Databases (Oracle PL/SQL, PostgreSQL)

🌐 Explore my interactive portfolio

About me

Senior Backend & Data Engineer at Open Intelligence with 5+ years building and optimizing mission-critical PL/SQL and Oracle systems for payment collection automation and debt negotiation. Analyzed and tuned 70+ complex execution plans, optimizer hints, and index structures on batch workloads, and standardized migration models and API exchanges to minimize integration defects. I apply this database foundation to applied AI solutions, including Text-to-SQL assistants with RAG, LLM pipelines, and multi-agent orchestration with Claude Code. Based in Cali, Colombia, and available for international remote roles as a contractor or EOR.

Key highlights

  • 5+ years in enterprise database architecture and query optimization across Oracle PL/SQL and PostgreSQL.
  • 1,085 automated tests passing (89 skipped) in the flagship text-to-sql-rag pipeline.
  • 245+ adversarial security test cases validated against a deterministic AST semantic firewall.
  • Multi-agent orchestration workflows using the Maker-Checker protocol and Orca ADE.

Projects

  • text-to-sql-rag: Text-to-SQL assistant with schema RAG (pgvector) and an AST SQL firewall (sqlglot) that supports PostgreSQL 16 and Oracle 23c Free; its deterministic AST firewall validates 245+ adversarial security test cases, and fail-fast unreachable database response dropped from 138.5s to 4.0s. The pipeline has 1,085 passed, 89 skipped tests; Python, FastAPI (MIT license). Measured, not assumed: what an Oracle firewall has to catch and an A/B benchmark of Postgres vs Oracle vs transpiled SQL.
  • plsql-lens: PL/SQL analysis in Python: inventory and call graph, review rules with SARIF output, utPLSQL test generation, a seeded benchmark, and Oracle-to-PostgreSQL migration findings and rewrites checked against both databases; Python, Typer (MIT license). Its reports include what does not hold, for example five inputs that break the parser's "never raises, quickly" claim.
  • job-autoapply: Next.js and Supabase job application platform with a job aggregator, hybrid AI (Ollama, Claude, Gemini), ATS form autofill, a Chrome extension, and n8n and Telegram webhooks (TypeScript, MIT license).
  • mrgames-web: e-commerce store for video games and subscriptions built with Next.js and Supabase, in production: https://mrgames.com.co
  • FinanzasIA: personal finance project with AI built with TypeScript (MIT license).

Private projects

  • TrueGuard (private repo): native Android app (Kotlin and Jetpack Compose) for call spam blocking with a Supabase backend.
  • orquestador-plugin (private repo): Claude Code plugin that acts as a technical lead and delegates code to worker CLIs with maker-checker review.
  • AI video pipeline (private repo): produces videos for the active YouTube channels Founder Digital and The Silicon Auditor, with Gemini scripts, Whisper subtitles, and n8n orchestration with human approval.

Contact

Pinned Loading

  1. FinanzasIA FinanzasIA Public

    Personal finance app for Colombia: manual expense tracking with monthly summaries by category. Expo, React Native, TypeScript and Supabase.

    TypeScript

  2. job-autoapply job-autoapply Public

    AI-assisted job application platform: job aggregator, tailored resumes and cover letters with hybrid AI (Ollama, Claude, Gemini), ATS autofill and a Chrome extension. Next.js and Supabase.

    TypeScript

  3. text-to-sql-rag text-to-sql-rag Public

    Text-to-SQL API with schema RAG (pgvector) and an AST SQL-safety firewall (sqlglot) for PostgreSQL and Oracle targets. FastAPI, local LLMs via Ollama, read-only execution with timeouts, and a measu…

    Python

  4. plsql-lens plsql-lens Public

    PL/SQL analysis in Python: inventory and call graph, review rules with SARIF output, utPLSQL test generation, a seeded benchmark, and Oracle-to-PostgreSQL migration findings and rewrites checked ag…

    PLSQL