Internal Operations Platform — Behavioral Solutions of Mississippi
Transforming a fragmented, spreadsheet-dependent intake process into a centralized, database-driven operations portal — built entirely by an EA with a vision.
BSOM relied on fragmented spreadsheets to manage referrals, parent interviews, assessments, treatment plans, and service readiness across multiple clinics. Bottlenecks were invisible. Workflows were inconsistent. Intake coordination was a daily exercise in manual effort — and every gap in data was a gap in care.
I designed and built a modular internal operations portal from the ground up — connecting a live Supabase database to a clean, responsive interface with real-time lifecycle tracking, operational dashboards, and role-based access. No external vendor. No budget for a SaaS tool. Just vision, resourcefulness, and code.
The result: a system that gave clinic leadership actual visibility into their pipeline for the first time — and gave staff a single source of truth for every referral.
Each referral moves through a defined lifecycle, tracked in real time against a Supabase backend. Staff can see exactly where every client stands — eliminating the follow-up emails, the missed steps, and the manual status checks that previously consumed hours each week.
Connected directly to a Supabase backend — every intake entry, status update, and pipeline change reflected in real time across all devices.
Operational dashboards give leadership a live view of intake volume, bottlenecks, and referral progression — no spreadsheet formulas required.
Different views for different staff roles — intake coordinators, BCBAs, and clinic leadership each see what's relevant to their work.
Built with a modular interface that can expand as the organization grows — new operational modules can be added without rebuilding from scratch.
Fully optimized for desktop and mobile use — staff can check intake status from anywhere, not just a desktop workstation.
Built-in theme support for accessibility and user preference — a small detail that reflects the care put into every aspect of the interface.
Responsive interface built without heavyweight frameworks — clean, fast, and maintainable.
Live PostgreSQL backend with real-time subscriptions powering the intake pipeline.
Zero-cost hosting with version control built in — deployed and iterable from day one.
Leveraged AI tools throughout development to accelerate building and problem-solving.
Supabase PostgreSQL enforces RLS policies directly at the database layer — ensuring each user role can only read and write the records they're authorized to access.
All client-database communication is routed through encrypted HTTPS endpoints. Referral data never travels over an unsecured connection.
The system stores operational intake workflow data — not clinical treatment records. This deliberate data scoping reduces HIPAA surface area while fully supporting staff coordination and reporting needs.
Built to support the people who run the clinic — not to store what happens inside it. Operational data lives here; clinical records stay where they belong.