University of Guelph.
- Role
- App Developer (Contract)
- Duration
- Sep 2023 - Jul 2024
- Location
- Guelph, Ontario
Engineered enterprise web applications, automated administrative workflows, and led security remediation projects. Built data migration pipelines and developed internal tools serving 15K+ users across university systems.
A/Key achievements
- 01
Engineered enterprise web applications using ASP.NET MVC (C#), Oracle Database (PL/SQL), and JavaScript, implementing role-based access control and RESTful APIs serving 15K+ users, improving page load times by 42% and reducing server costs by $6K/year
- 02
Built automated data migration pipeline using Python (Pandas), Toad for Oracle, and SSIS, orchestrating 5M+ record transfers across Oracle, MySQL, and SQL Server with zero data loss, reducing manual migration time from 3 weeks to 2 days
- 03
Developed internal admin tools suite with Java Spring Boot and React, automating 12+ daily workflows, eliminating 60% of manual errors and saving 25 hours/week across 8 administrative teams
- 04
Spearheaded security remediation project, patching critical ColdFusion vulnerability, conducting OWASP audits across 40+ applications, implementing automated scanning (Snyk), achieving 100% compliance and preventing breach affecting 50K+ student records