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, with 3 specialized chunking pipelines matched to each document type's real structure (procedures, ordinance articles, appendix tables) over a corpus of 43 official documents indexed in PostgreSQL with pgvector. Before generating, an explicit LLM check decides whether the retrieved context is actually sufficient to answer, and every citation is reconstructed by code — not by the model — to avoid risking the exact data. Quantitatively evaluated with RAGAS (0.73 faithfulness, 0.77 relevancy), with a PDF viewer that highlights the exact passage used and a full corpus browser.
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.