FeaturedStreamlining Seminar Management Workflow
About this Project
Automated Seminar Intelligence System An end-to-end data pipeline and automation system that extracts, cleans, and standardizes chaotic spreadsheet data across 6 academic departments. It transforms passive data into a 24/7 digital assistant, delivering real-time Telegram alerts and Google Calendar integrations to eliminate scheduling bottlenecks.
Details
Overview
At ITERA, students are required to attend numerous seminars before graduation, but schedule information was historically siloed, poorly formatted, and distributed via word-of-mouth. I developed an automated intelligence system to solve this administrative bottleneck, turning messy, passive Google Sheets into a proactive digital assistant.
Technical Architecture & Highlights
Smart Parsing & Data Cleaning: Engineered a custom parser capable of handling highly unstructured data, including over 15 distinct date/time formats, human typos, and multi-row entries. It effectively extracts and standardizes complex information (like nested Student IDs) into clean, machine-ready datasets.
Idempotent State Management: To prevent notification spam and maintain user trust, I implemented an FNV-1a hashing algorithm. The system generates unique event IDs and cross-references a state sheet to ensure only strictly new or modified schedules trigger an alert.
Scalable Builder Pattern: Avoided maintenance nightmares by designing a modular Plugin System. Adding a new academic department only requires updating a simple configuration file, allowing the system to scale dynamically without manual workflow reconstruction.
Multi-Platform Delivery: Integrated the clean data pipeline with Telegram and Google Calendar. The system pushes rich-text alerts (containing thesis titles, supervisors, and links) and automatically populates digital calendars, including sending an automated daily digest at 5:30 AM.
Impact
This project demonstrates the real-world value of data engineering and automation. By successfully taming "messy data" and building a reliable 24/7 pipeline, it completely eliminated a major administrative headache, allowing students to focus on their core academic goals.