Modern Data Foundation for Restaurant Franchise: From Oracle Chaos to Governed Analytics
Built enterprise-grade data infrastructure from scratch for Carl's Jr franchise—delivering complete supply chain visibility and single source of truth across 100+ locations.
Clarivant built a complete modern data stack from the ground up for Grupo AFAL (Carl's Jr Mexico), migrating Oracle EBS data to Snowflake, implementing dbt-based transformation pipelines, and delivering production-grade Tableau analytics that became the single source of truth for supply chain operations across the entire franchise network.
Resultados Clave
La Transformación
El Desafío
Grupo AFAL's supply chain analytics were fragmented and manual:
- Critical metrics scattered across Oracle EBS, spreadsheets, and manual reports with no centralized data warehouse—analysts querying production databases directly
- Supply chain KPIs calculated inconsistently across 100+ Carl's Jr franchise locations with manual reporting processes taking days
- No data governance framework—metrics definitions varied by department blocking digital transformation initiatives
- IT lacked modern data stack expertise (Snowflake, dbt, cloud pipelines) to build foundation internally
Nuestro Enfoque
Clarivant designed and implemented a complete modern data infrastructure for AFAL:
Data Warehouse Foundation:
- Architected data warehouse in Snowflake from scratch (database/schema design, access controls) with Fivetran pipelines for automated Oracle EBS extraction
- Partnered with AFAL IT to build HVA (High Volume Agent) connection for high-throughput Oracle data loads
Transformation & Governance Layer:
- Built comprehensive dbt project: 134 staging models, 47 intermediate models, 34 marts with 3-layer architecture for strict data governance
- Established automated daily refresh schedules with 231 documented data quality tests
Analytics & Dashboards:
- Created unified analytics platform delivering 360° supply chain visibility—from supplier delivery to restaurant inventory
- Built governed KPI framework ensuring consistent metrics across every dimension with role-based access controls in Tableau
El Resultado
The modern data foundation transformed AFAL's supply chain operations:
Infrastructure & Governance:
- Centralized data warehouse eliminating direct Oracle queries with automated daily pipelines replacing manual extraction
- 231 automated data quality tests catching errors before dashboards with governed metric definitions ensuring consistent KPIs across all Carl's Jr franchise locations
Business Impact:
- Complete analytics platform became "single source of truth" for all supply chain metrics with real-time visibility for AFAL executives across entire franchise operation
- Reporting time reduced from days to minutes (live dashboards) eliminating human error in manual calculation processes
- Strong dashboard adoption among franchise operators and supply chain teams
Technical Excellence:
- 6 optimized Tableau models supporting comprehensive analytics workbook with sub-3-second dashboard load times on complex supply chain queries
- Foundation architected for future AI forecasting initiatives with data governance framework ready for enterprise-wide expansion
Lo Que Dice el Cliente
Trabajar con Clarivant transformó cómo usamos datos en AFAL. Construyeron todo nuestro modern data stack desde cero—Snowflake, dbt, pipelines automatizados, frameworks de gobernanza. Por primera vez, tenemos una fuente única de verdad en nuestras más de 100 ubicaciones de Carl's Jr, y nuestros ejecutivos tienen visibilidad en tiempo real de las operaciones de supply chain. El rigor técnico fue excepcional—exactamente lo que necesitábamos para nuestra hoja de ruta de transformación digital.
Federico Gonzalez Lutteroth
Director de Transformación Digital, Grupo AFAL (Carl's Jr)
¿Quieres resultados similares para tu organización?
HablemosServicios Utilizados
También Te Puede Interesar
Analytics Platform Modernization: 377 Legacy Objects to 51 dbt Models in 45 Days
From 377 legacy objects to 51 automated models under 45 days—navigating Okta authentication constraints and platform license expiration with 606% Year 1 ROI.
Leer caso de estudioEcommerce Data Foundation for Digital-Native Brand
Data stack powering omnichannel growth.
Leer caso de estudioAutomated Replenishment Reports Saved 120+ Hours Monthly
Cutting analysis time from days to minutes — boosting in-stock rates across Walmart Canada.
Leer caso de estudio¿Listo para convertir datos en decisiones?
Hablemos de cómo lograr ROI medible en meses.