Juan Jose Alvarado Lagunes

From operational workflows to maintainable systems

• C# · .NET · ASP.NET Core · WPF
• SQL · Entity Framework Core
• Architecture · testing · deployment

Engineering decisions

SICE combines a concrete operational problem with decisions that can be discussed at implementation level.

• Consistency: allocate seats atomically when several requests compete for limited availability.
• Separation: API, portal and WPF client over a domain without external dependencies, as documented in the architecture.
• Continuity: SQLite contingency mode, encrypted backups and auditing for the Records Office workflow.

Selected project evidence

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)

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

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.