CRM System
Customer & Student Management Platform for Fondazione Grabovoi
Client
Fondazione Grabovoi
Services
Full-Stack Development / UX Design / API Integration
Year
2024-2025
The Challenge
Fondazione Grabovoi needed a comprehensive platform to manage over 6,600 contacts and students across multiple languages. The system required real-time dashboards, automated payment tracking, bank statement reconciliation, and multilingual Stripe checkout integration—all while maintaining a clean, intuitive interface for non-technical staff.
Key Features
Contact Management
Manage 6,600+ contacts with advanced filters by status, source, and language.
Revenue Projections
Monitor student installment payments with automatic future revenue projections.
Payment Links
Create multilingual Stripe payment links with custom checkout in 5 languages.
Bank Reconciliation
Import Excel bank statements and automatically reconcile transactions with orders.
Internationalization
Full i18n support (Italian/English) with language-specific payment flows.
Real-Time Dashboard
Live metrics on contacts, active students, revenue, and sales trends.
System Screenshots
Dashboard Overview - Real-time metrics and sales trends
Students Analysis - Revenue projections and categorization
Bank Statements - Automated import and reconciliation
Payment Links - Multilingual Stripe checkout integration
Contact Management - Advanced filtering and search
Tech Stack
Frontend
- React 19
- Tailwind CSS 4
- shadcn/ui
- Recharts
- i18next
Backend
- Node.js 22
- Express + tRPC 11
- Drizzle ORM
- MySQL/TiDB
- OAuth 2.0 + JWT
Integrations
- Stripe (Payments & Checkout)
- WooCommerce (E-commerce Sync)
- Emailit (Transactional Emails)
- Amazon S3 (File Storage)
Results
Contacts Managed
Languages Supported
Automation Rate