LMS Administrator & Academic Records Officer (ARO)
Great Lakes Institute of Management · Jul 2025 – Jul 2026
- Analyse attendance, grade, and assessment data for 600+ students using Pivot Tables, VLOOKUP, XLOOKUP, INDEX/MATCH, and SUMIFS, delivering weekly and term-end reports to academic leadership.
- Built an interactive Excel dashboard with slicers tracking attendance %, grade submission status, and at-risk students across 5 programmes, reducing manual reporting time by 40%.
- Clean and validate 5,000+ academic records per term using data validation, conditional formatting, and lookup checks, maintaining 99%+ accuracy for transcripts and audits.
- Administer the LMS for 600+ students and 50+ faculty, managing 80+ courses per term, assignment workflows, and assessments with 100% deadline adherence.
- Track and categorise 150+ LMS support queries per month to identify recurring issues, cutting average resolution time from 24 to 8 hours.
- Prepare 500+ transcripts, certificates, and audit-ready reports per year with zero compliance issues.
- Coordinate with 6 academic departments on examination data and academic reporting.

