Overview We are building a custom CRM platform for a multi-location children’s sports franchise. A working operational prototype already exists using automation tools (Power Automate, Excel, Twilio, Outlook, etc.). Your role is to rebuild this properly as a unified web application with a structured database, authentication, role permissions, and API integrations. This is not a basic contact manager. It is an operational CRM covering bookings, attendance, payroll logic, reporting, automation, messaging and more. The website is currently being redesigned. The CRM must integrate cleanly with the website booking system. Core Requirements The CRM must support: 1. Multi-Tenant Structure - HQ view - Individual franchisee view - Role-based permissions 2. Customer & Child Management - Parent profiles - Child profiles - Venue allocation - Purchase history - Lifetime value tracking - Renewal tracking 3. Booking & Payments - Integration with website booking forms - Payment integration (Stripe or similar) - Term/session tracking - Discounts and royalty calculations 4. Coach Management - Coach profiles - Session assignments - Session tracking - Automated payroll calculations - Invoice generation logic 5. Attendance System - Session-based attendance lists - Trial child logic (auto-add and remove) - Attendance reporting 6. Messaging Integration - Email integration (Outlook/Gmail API) - WhatsApp integration (Twilio API) - Automated workflows - Context-based messaging view 7. Reporting & Dashboards - Revenue dashboards - Profit per venue - Term performance - Renewal % - LTV reporting - Sales breakdown (daily/weekly/monthly) 8. Automation Layer - Workflow triggers - Follow-up sequences - Approval flows - Notification systems - Technical Expectations You should have experience with: - Modern web stack (React / Next.js or similar) - Backend development (Node / Python / similar) - Database design (PostgreSQL preferred) - Authentication & role-based access - API integrations - Stripe integration - Twilio integration - Clean scalable architecture - Production deployment Bonus: - Experience building SaaS or multi-tenant systems - Experience with automation-heavy platforms - Integration Requirement The CRM must integrate with the main website. We need: - Booking forms to push data into CRM via API - Or CRM booking engine embedded into website - Clean data sync between website and CRM - Secure and scalable structure The website is being redesigned in parallel, so coordination will be required. Project Scope Phase 1: - Architecture design - Core CRM build (parents, children, venues, bookings, payments) Phase 2: Payroll, attendance, messaging Phase 3: Reporting dashboards Advanced automation AI chatbot integration Engagement Structure We are open to: - Fixed-price proposal for full build - Or phased milestone-based contract Please include: - Examples of similar SaaS/CRM systems built - Stack you would recommend - Rough timeline estimate - Rough budget estimate - Your availability Important This is not a simple website project. We are building a structured operational system for a growing franchise network. We are looking for someone who understands business logic, data architecture, and scalability — not just frontend UI work. The product logic is mapped. We need someone who knows how to engineer it correctly.