Juan
Decastelli
4 years of experience building end-to-end products — from the data model to the interface. I like solving real problems with simple tools.
Technologies I usually work with
Experience
Municipality of Avellaneda
Design and development of internal management systems for various municipal departments, from data architecture to the final interface, integrating AI into service and paperwork workflows.
Featured projects
Municipal RAG
Conversational RAG assistant over municipal procedures and regulations, indexing 210 official documents (ordinances and procedures) in PostgreSQL with pgvector. Every answer cites the exact source fragment, with a PDF viewer that highlights the passage used, and an LLM-based check that avoids answering when the retrieved context falls short.
Personnel Management
Payroll settlement and HR engine for the Municipality of Avellaneda: employee records, leave, attendance and org structure. Generates PDF payslips through JasperReports via an async job pipeline (Redis/RQ), with Active Directory authentication.
Payroll Receipts
Employee self-service payslip portal that unifies the modern HR system with a legacy payroll source into a single view. Resolves PDFs through a cascading JasperReports + disk-cache pipeline, and exposes a custom usage dashboard (logins, downloads, fallback rates).
Inventory System
Multi-warehouse stock control across municipal departments: article catalog with variants, lot/batch traceability with expiration dates, and stock movements (entries, exits and transfers with confirmation) over an immutable ledger. Automatic alerts for low stock and upcoming expirations.