Professional
Automating the TOL application platform
Microsoft 365 pipeline replacing a manual student-application process across 9 universities, with dynamic reporting and GDPR anonymisation.
Context
The TOL (Transnational Online Learning) programme lets CHARM-EU students take courses offered by other partner universities. Applications across the 9 universities were handled through an entirely manual process.
What I did
- Product owner and IT lead of the platform.
- Designed the pipeline: MS Forms → SharePoint list → Power Automate flows → anonymised snapshot + course catalogue.
- Dynamic reports refreshed every 2 hours: enrolments per course and per home university, home × host mobility matrix.
- GDPR compliance: 6-month retention, then anonymisation.
- Power BI prototype dropped in favour of a solution that can be shared without a licence.
- Wrote the user guide for coordinators at partner universities.
- Additional attendance-tracking flow for CHARM MSc students (Forms → SharePoint).
Results
- From a manual process to an automated pipeline.
- ≈ 430 applications, 42 courses and 7 host universities handled by the platform.
- Up-to-date reports available to every partner with no extra licence.