Pablo Dev Garrido

Problem: PDF and text invoices are unstructured documents that are difficult to query and integrate with other systems.

Solution: A Python pipeline that extracts key data with LLMs (Groq), stores it transactionally in PostgreSQL, and exposes it through a REST API, with the flow orchestrated in n8n.

Result: API deployed on Azure with CI/CD and public Swagger. Open-source code.

Problem: Much of the business intelligence is trapped in messy PPTX, PDF, and Excel files that cannot be queried.

Solution: A FastAPI REST API that ingests files, cleans them, and passes them through a chain of AI agents (Market Analyst → Brand Analyst). The result is stored in PostgreSQL (JSONB), and n8n generates insight dashboards.

Result: Processing a complete document with 3 chained agents costs less than 0.10 USD.

Problem: Managing employees, branches, shifts, and attendance needs to be centralized in a web system.

Solution: A web system with an authenticated panel, manual and QR-code clock-in, location validation, an attendance dashboard, and PDF-exportable reports.