Matias Guajardo

Worked on mission-critical institutional systems with high data integrity and operational continuity requirements.

• Developed REST APIs using NestJS with ~99% OpenAPI/Swagger documentation, implemented JWT-based authentication and real-time communication with Socket.io. Integrated Oracle DB using 70+ triggers and PL/SQL sequences for accreditation and institutional planning modules, transforming manual processes into traceable digital workflows.

• Migrated and optimized Oracle schemas from 11g to 19c, implementing 70+ triggers and sequences across systems. Ensured full historical data integrity during both transitions with zero data loss in production environments.

• Refactored two large-scale institutional systems in production: migrated ~80% of an accreditation system from PHP to Angular/NestJS, and ~60% of a planning system from PL/SQL to a modern architecture, significantly reducing technical debt and improving operational stability.

• Translated business requirements from academic and administrative stakeholders into concrete technical specifications under Scrum methodology, acting as a bridge between end users and the development team.

End-to-end development of a monetized e-learning platform for a digital content business.

• Built an e-learning platform using WordPress and WooCommerce, including online course delivery, integrated payment gateway, membership management, and protected content access.

• Deployed the platform on AWS Amplify and configured Cloudflare for endpoint protection, including domain setup, SSL, and security rules to ensure availability and secure access.

• Collaborated with an international technical team to define system architecture and implement DDoS mitigation strategies on AWS. Managed real production incidents under sustained attacks, restoring service availability and ensuring platform continuity.