Mariano

Backend & Database Developer & QA (AI-Augmented Delivery)

Overseeing end-to-end data pipelines, backend logic, quality assurance (automated and manual), and deployments across multiple concurrent client accounts.. Applying AI-assisted development workflows: mapping functional requirements to DBML schemas, AI-guided generation of SQL migrations, environment provisioning and synchronization (local stack to Supabase Cloud via CLI), and dual pre-production validation through automated suites and manual QA across web UIs and CLI environments.. Medical Imaging Diagnostic SaaS — Clinical & Financial Workflow: Architected the relational schema in PostgreSQL (32 tables), decoupling clinical workflows (medical orders and DICOM ingestion) from financial-accounting engines (procedures, pricing, and billing batches).. Implemented database-level state machines for reception/billing, strict fee resolution with date-range validity, and persistent PostgreSQL job queues for asynchronous report generation.. Executed comprehensive manual QA across the admin SPA and patient portal: validated role-based navigation, multi-procedure intake, cash register closeouts, and cross-tenant data isolation.. Conducted technical triage and Root Cause Analysis (RCA) correlating UI errors with backend logs/DevTools (detecting PostgREST re-read inconsistencies and API contract discrepancies).. Authored automated pgTAP suites to enforce monetary precision, lifecycle state transitions, and multi-tenant RLS isolation.. Managed database lifecycles and environment provisioning, promoting versioned migrations from containerized local environments to Supabase Cloud via Supabase CLI.. Constructora Soriano — Real Estate ERP (Uruguay): Designed the relational model in PostgreSQL 17 (30 tables) managing immutable SQL migrations for zero-downtime continuous delivery.. Modeled business logic for real estate CRM/ERP with strict multi-currency handling (preserving USD/UYU transaction origin without uncontrolled conversions).. Led functional manual testing via CLI/Docker: direct terminal (psql) validation of state machines (unit allocations, reservation down payments, dossiers) and RBAC security gates (403).. Verified end-to-end UI/UX lead prequalification flows and WhatsApp conversation routing, auditing real-time alert triggers and database validation constraints.. Authored automated pgTAP suites and Deno tests for Supabase Edge Functions integrated into GitHub Actions CI/CD pipelines.. Administered schema deployment and versioning workflows, synchronizing immutable migrations from local Docker stacks to Supabase Cloud via the CLI.. Rolly Oficial — B2B Wholesale Marketplace: Designed a 21-table relational schema supporting multi-vendor stores, multi-currency catalogs, and SKU product variants with strict referential constraints.. Built idempotent RPC functions for split multi-vendor checkouts and Mercado Pago transactional webhooks, guaranteeing ACID integrity during payment reconciliation.. Optimized the security model, consolidating high-performance Row-Level Security (RLS) policies with rigid role-based data isolation.. Developed unit and integration suites using Vitest and Python, validating OpenAPI schemas and stress-testing race conditions under high-concurrency checkouts.. Containerized services using multi-stage Docker builds, orchestrating decoupled infrastructure (public API, workers, admin SPA) on VPS via Coolify.. Pactum — Online Legal Mediation Platform: Modeled the core relational schema from scratch (22 entities) integrating delegated authentication through Supabase Auth.. Architected multi-layered security via role-scoped RLS policies and hardened SECURITY DEFINER functions with revoked public execution privileges.. Designed concurrency-safe monetization transactions using atomic FOR UPDATE row locking, alongside an append-only audit trail with protective anti-tampering triggers.. Automated 85+ Python integration tests and managed self-hosted Supabase VPS deployments via Coolify with automated backup and support scripts.. Provisioned and synchronized development and staging environments, guaranteeing parity between local containers and cloud databases through migration pipelines with Supabase CLI.. Refrigeración Lucciarini S.A. — Manufacturing & Inventory Management System: Engineered and maintained the relational model across 60+ evolutionary SQL migrations, encapsulating manufacturing and inventory logic directly inside PostgreSQL.. Developed and tuned transactional RPC functions for plant assembly flows, automated stock replenishment, and idempotent JSONB purchase order verification.. Built modular Python ETL pipelines for extracting, cleaning, normalizing, and loading industrial vendor catalogs and Bills of Materials (BOM).. Expanded automated pgTAP coverage to safeguard referential integrity, sequential workflow stages, and fine-grained permissions per plant division.