Challenge
The client encountered various obstacles with their legacy system that hampered the operations across an expensive franchise network.
System Complexity
Overseeing a multi-tenant architecture for numerous locations was notably burdensome, demanding significant effort and time to ensure smooth operations across the expansive network.
Legacy Analytics
The legacy PHP system limited real-time analytics, causing scheduling issues and inaccuracies for guest walk-ins and client appointments.
Inefficient Reporting
Compiling network-wide reports was a manual process fraught with errors, making it unreliable and inefficient.
The client encountered various obstacles with their legacy system that hampered the operations across an expensive franchise network.
System Complexity
Overseeing a multi-tenant architecture for numerous locations was notably burdensome, demanding significant effort and time to ensure smooth operations across the expansive network.
Legacy Analytics
The legacy PHP system limited real-time analytics, causing scheduling issues and inaccuracies for guest walk-ins and client appointments.
Inefficient Reporting
Compiling network-wide reports was a manual process fraught with errors, making it unreliable and inefficient.
Solution
Freshcode deployed a full-stack solution utilizing Elixir/Phoenix and associated tools.
New Reporting Module
Utilizing Elixir and Phoenix for the core development, this module integrates Ecto, Oban, and Broadway for data management, background processing, and handling high-volume data, streamlining operations and cutting costs.
Migration Strategy
Testing against the PHP "gold standard" for reporting accuracy, ensuring a seamless shift to the new Phoenix module, with attention to maintaining data integrity and operational continuity
Real-Time Data Processing
Custom MySQL binlog row replication and Kafka enabled real-time data analytics across numerous database instances.
Lambda Architecture
Combining rapid in-memory analytics with SingleStore, this approach ensured seamless report management and scalability.
Freshcode deployed a full-stack solution utilizing Elixir/Phoenix and associated tools.
New Reporting Module
Utilizing Elixir and Phoenix for the core development, this module integrates Ecto, Oban, and Broadway for data management, background processing, and handling high-volume data, streamlining operations and cutting costs.
Migration Strategy
Testing against the PHP "gold standard" for reporting accuracy, ensuring a seamless shift to the new Phoenix module, with attention to maintaining data integrity and operational continuity
Real-Time Data Processing
Custom MySQL binlog row replication and Kafka enabled real-time data analytics across numerous database instances.
Lambda Architecture
Combining rapid in-memory analytics with SingleStore, this approach ensured seamless report management and scalability.
Results
Advanced Data Management: Introducing low-latency analytics significantly improved large-scale data management, enabling faster and more accurate business insights.
Reduced data latency from 24 hours to just 1 hour
- Cost-Effective Server Setup: A new, more economical columnar data storage solution was implemented, simplifying franchise management.
- 5x Optimized: Downsized from 20 to 4 AWS servers for DB and ETL
- Seamless Migration: The migration to the new Elixir ERP was executed flawlessly, maintaining data integrity and without disrupting daily operations.
- Zero Downtime: Ensured uninterrupted operations during system migration
Client Advantages with the New ERP
- Central Management: Franchise owners can now remotely manage multiple locations and swiftly update prices, services, and other settings across all stores.
- Tailored Reporting: The system generates customized reports through easy search and filtering options, providing detailed insights into clients, memberships, locations, and personnel.
- Online Booking: The new ERP streamlined online booking, reducing no-shows, optimizing walk-in management, and maximizing staff efficiency.
Cut Operational Costs by 35%
Advanced Data Management: Introducing low-latency analytics significantly improved large-scale data management, enabling faster and more accurate business insights.
Reduced data latency from 24 hours to just 1 hour
- Cost-Effective Server Setup: A new, more economical columnar data storage solution was implemented, simplifying franchise management.
- 5x Optimized: Downsized from 20 to 4 AWS servers for DB and ETL
- Seamless Migration: The migration to the new Elixir ERP was executed flawlessly, maintaining data integrity and without disrupting daily operations.
- Zero Downtime: Ensured uninterrupted operations during system migration
Client Advantages with the New ERP
- Central Management: Franchise owners can now remotely manage multiple locations and swiftly update prices, services, and other settings across all stores.
- Tailored Reporting: The system generates customized reports through easy search and filtering options, providing detailed insights into clients, memberships, locations, and personnel.
- Online Booking: The new ERP streamlined online booking, reducing no-shows, optimizing walk-in management, and maximizing staff efficiency.
Cut Operational Costs by 35%