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.
Key Results
The Transformation
The Challenge
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
Our Approach
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
The Outcome
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
What the Client Says
Working with Clarivant transformed how we use data at AFAL. They built our entire modern data stack from the ground up—Snowflake, dbt, automated pipelines, governance frameworks. For the first time, we have a single source of truth across our 100+ Carl's Jr locations, and our executives have real-time visibility into supply chain operations. The technical rigor was exceptional—exactly what we needed for our digital transformation roadmap.
Federico Gonzalez Lutteroth
Director of Digital Transformation, Grupo AFAL (Carl's Jr)
Want similar results for your organization?
Get in touchYou May Also Like
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.
Read case studyEcommerce Data Foundation for Digital-Native Brand
Data stack powering omnichannel growth.
Read case studyAutomated Replenishment Reports Saved 120+ Hours Monthly
Cutting analysis time from days to minutes — boosting in-stock rates across Walmart Canada.
Read case studyReady to turn data into decisions?
Let's discuss how Clarivant can help you achieve measurable ROI in months.