Skip to content

Projects

Projects

The systems I've built. The ones with a case study cover the problem, the constraints, the decisions and what I'd do differently today.

Projects

  • Entre Ríos Education Council · 2023–2025

    Verifiable

    Family Allowance Certificate Upload and Validation System (Salario Familiar)

    Province-wide: used by all school staff in Entre Ríos — teachers, principals, administrative and support staff. Upload, validation and tracking with full auditing and traceability, integrated with SAGE, the province's school management system. It includes a file-upload security layer written from scratch in plain PHP, with no external libraries due to a technical constraint set by the agency.

    Cut the average processing time from 4 months to 5 weeks. 20,000 to 30,000 requests per annual cycle and close to 50,000 files. Eliminated paper forms at every school. Presented at an official event in April 2024.

    Santiago Carrattini presenting the system in the Education Council's auditorium, with the application projected behind him
    Presenting the system at an official event — Entre Ríos Education Council, April 2024.

    Press

    The agency's official article (in Spanish) credits me as “programador y creador del sistema”.

    Se presentó la nueva modalidad de carga de documentación de asignaciones familiares

    Consejo General de Educación de Entre Ríos · 04/04/2024

    Read the case study

    • PHP 7
    • SQL Server
    • JavaScript
    • Bootstrap
  • Entre Ríos Education Council · 2023–2025

    Case File, Procedure and Internal Memo Management Platform

    Covers virtually every case file the Council receives that is tied to payroll processes: thousands of case files, more than 10 departments and around 60 people. It isn't a case-file CRUD — it models the administrative workflow as a state machine, with its own authorization layer separate from SAGE's and managed from a dashboard, plus configurable departments, roles and workflow behavior for whatever changes with day-to-day operations.

    Replaced a workflow built on paper and informal knowledge with an explicit flow of states, owners, permissions and traceability.

    Internal agency system — no repository or public demo

    Read the case study

    • PHP 7
    • Apache
    • SQL Server
    • PDO/ODBC
    • JavaScript (jQuery, AJAX)
    • Bootstrap
  • 2026

    This portfolio and its chatbot

    The chatbot injects the full profile as context, with no RAG: the corpus fits in the context window, so retrieval would be over-engineering at this scale — more moving parts, more latency and a new failure mode in exchange for nothing. The decision is documented in the README. The LLM provider sits behind a swappable interface, with hard rules in the prompt, guardrail evals, rate limiting and a kill switch.

    Public, auditable repo. Zero-cost infrastructure.

    Read the case study

    • Next.js
    • TypeScript
    • Tailwind CSS
    • Zod
    • Vercel
  • Apr 2022 – Apr 2023

    XSports — E-commerce for a gym

    Training project: catalog, cart and checkout for a gym, with Passport authentication and Mercado Pago payments. Structured with Clean Architecture and managed with Scrum and Trello.

    Closed project — no repository or demo

    • Node.js
    • Express
    • TypeScript
    • React
    • Chakra UI
    • PostgreSQL
    • Prisma
    • Passport
    • Mercado Pago