Skip to content
Fahima Mokhnache
FR

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.