I have managed a large database of students, classes and mentors. This included processes like application handling, contract signature, class assignment, exam evaluation, class payments, attendance tracking, lecture & workshop planning, pricing configurations, hiring & placement.
Potential students fist arrived in ActiveCampaign CRM where their application status was tracked. If successful, they were sent to Airtable. In Airtable there was an automated process to assign them to the right class and once a contract was signed, they were moved to Students table.
A lot of complexity followed:
- Attendance
- Exam evalutation & result tracking
- Project assignment
- Payment tracking
- Graduation process
- Placement process
Besides that I handled integration with different Invoicing software and exports from banks to create cashflow dashboards.
The Airtable workspace consisted of over 50 tables and many interfaces and automations. In the end it eliminated a ton of manual sync of data from different systems and manual repeated creation of many types of spreadsheets, all of which could potentially be fault to human error.
Airtable provided structure for operations and project management and Slack messages informed key people when it was their turn to move the process forward.
