Juan Jose Alvarado Lagunes

Frontend and data, connected thoughtfully

• React · Next.js · TypeScript
• APIs · PostgreSQL · Supabase · RLS
• Validation · testing · GitHub/Netlify

From forms to data

My work connects what the user sees with the information workflow supporting the product.

• CECATI: SI-01 enrollment, local validation and document submission connected to the school system.
• Instinto Guardián: React/Next.js interfaces, Supabase data with RLS and local capabilities through IndexedDB and Service Worker.
• Delivery: applications on real domains, with documented GitHub/Netlify deployment and HTTPS.

Selected project evidence

Instinto Guardián

Published personal project. Animal protection and human safety PWA with Next.js, React, strict TypeScript and Supabase. Deterministic offline assistant, RLS permissions and deferred sync.

Documented testing: 403 unit tests, 53 E2E tests and axe audits. PWA architecture and GitHub/Netlify deployment.

Technical case study (ES)Live application

CECATI 106

Published institutional site with a six-step SI-01 enrollment flow, course catalog and assistant. HTML, CSS and vanilla JavaScript connected to Supabase.

Documented CURP validation, file signature checks, Canvas compression and RLS policies.

Technical case study (ES)Live application

SICE · CECATI 106

Institutional enrollment and student records system. .NET API, Razor Pages portal and WPF/MVVM desktop client over PostgreSQL, with SQLite contingency mode. Atomic seat allocation and auditing.

Portfolio documentation: 52 endpoints and 47 xUnit tests. AES-256 backups. Private repository; technical review on request.

Technical case study (ES)

Testing figures are documented in the existing portfolio. The source repositories and their test reports are private; these figures are not a new independent test run or a guarantee of complete coverage.

Quality Engineering & Testing

Testing complements my development work: Vitest for unit tests, Playwright for end-to-end workflows, xUnit for .NET, axe-core for automated accessibility checks and strict TypeScript for static checks.

• Instinto Guardián: documented unit, E2E and accessibility testing, plus CI/CD.
• SICE: automated .NET testing; atomic reservation is a documented implementation, not an independently verified concurrency test.
• CECATI: input and file validation, with CURP checks and binary signatures. No test suite count is claimed for this site.

Experience

• SICE · CECATI 106, 2026–present: institutional software and enrollment workflows.
• Instinto Guardián: published personal full-stack project.
• Auralis · Visualizer Studio, 2025–present: own Windows audio and video tools.
• 2024–present: personal projects and freelance software development.

GitHub · Private code review

View GitHub profile · The work repositories remain private.

My work repositories are private. During recruitment, I can arrange controlled access to review implementation, architecture and testing without exposing confidential information. The public evidence is the live applications and the case studies above.