Mesa Public Schools CRM

An intelligent automation platform that uses machine learning to identify, optimize, and automate complex business workflows across multiple departments.

Overview

During my internship at Mesa Public Schools, I developed a custom CRM system to support the district’s Work-Based Learning (WBL) program. Career coaches needed a centralized way to manage their partner database, while teachers needed limited visibility into those contacts without risking data integrity. To address this, I built a web-based CRM with contact tracking, email automation, and administrative routing. The system provided a structured workflow that streamlined communication between educators, coaches, and partners.

My Role and Contributions

• •Requirements Gathering: Collaborated directly with career coaches to understand their workflows and translate needs into features.
• •Custom CRM Development: Built the system in Flask with a jQuery front end, balancing simplicity with functionality.
• •Google API Integration: Implemented Google authentication, email sending, and data import/export features for seamless integration into existing tools.
• •Email Automation: Developed automated contact tracking and routing rules so messages reached the right admins and reduced manual follow-up.

Recognition and Results

• •Delivered a working CRM tailored to the unique needs of career coaches and teachers.
• •Created a more efficient process for managing WBL partner relationships.
• •Provided visibility for teachers while ensuring access controls protected sensitive data.

Why This Matters

This project shows my ability to design and implement practical solutions in collaboration with real users. It demonstrates technical depth with Flask, jQuery, and Google APIs, while also highlighting my ability to balance user needs with organizational requirements. The result was a tool that not only worked technically but also meaningfully improved day-to-day workflows for the district’s staff.