Selected Work
Case studies from recent consulting engagements
Selected Impact
- —National-scale loyalty analytics system
- —Multi-site field operations intelligence layer
- —Dynamic payment prioritization & workflow redesign
- —Fraud detection & campaign experimentation frameworks
- —Executive-level steering & governance integration
Structuring the Analytics Backbone of a National Loyalty Program
Context
When I joined Decathlon, the loyalty program (Decat'Club) had just been launched. The organization needed more than dashboards — it needed a structured analytics backbone to pilot a multi-channel loyalty ecosystem across online and offline sales. The program integrated purchases, sports activity tracking, product reviews, and point-to-gift-card conversions — creating a complex behavioral data environment.
Strategic Challenge
The core challenge was architectural. How do you transform multiple behavioral signals and transactional streams into a coherent decision system capable of answering:
- —What is the true impact of loyalty on revenue?
- —Which customer segments drive long-term value?
- —How effective are campaigns across channels?
- —Where are operational fraud risks emerging?
Without structured modeling, insights risk fragmentation.
My Approach
I designed and implemented the full analytics framework supporting the program. This included:
- —Structuring the underlying data model across online and offline sources
- —Designing RFM and channel-based behavioral segmentation
- —Building a comprehensive performance dashboard system
- —Analyzing and identifying fraud patterns within in-store loyalty usage
- —Creating ETL pipelines for a campaign POC
- —Designing A/B testing and holdout logic to evaluate campaign impact
I also facilitated a monthly loyalty steering committee with leadership and marketing directors, ensuring analytics translated into structured decision-making.
Outcome
The loyalty program transitioned from reporting-based monitoring to structured performance intelligence. The organization gained:
- —Clear revenue impact visibility
- —Segmented behavioral insights
- —Fraud detection awareness
- —Measurable campaign evaluation
- —A disciplined governance rhythm anchored in analytics
Analytics became embedded into executive steering — not just operational reporting.
Methodologies
Stack
Redshift, Amazon QuickSight, Tableau
Transforming Field Operations Through Structured Production & Payment Intelligence
Context
I joined the poultry program during a phase of growth and scaling. Operations were running on spreadsheets; the opportunity was to add a structured intelligence layer so that production, sales, and payments could be monitored and steered as the program expanded. My role was to design and implement that layer in line with the program's maturity trajectory.
Strategic Challenge
The poultry cycle spans 28 days of production before delivery. To support scale and disciplined execution, the organization wanted structured visibility across:
- —Chick reception and quality control
- —Transport mortality and production monitoring
- —Weight evolution tracking
- —Sales vs production alignment
- —Payment completion before delivery
- —Call center prioritization
Integrating these dimensions into a single system would support planning, allocation, and governance as the program grew.
My Approach
Production Intelligence Layer
I designed a structured data capture framework (initially Google Forms, later transitioned to CommCare) covering:
- —Day-old chick reception quality control
- —Transport mortality tracking
- —Daily mortality logging
- —Weekly production quality monitoring
All data was centralized and visualized to align production capacity with sales commitments.
Call Center Workflow Redesign
I introduced dynamic workforce allocation based on delivery proximity and payment completion levels, alongside the existing geographic structure. A CommCare-based prioritization system was added to generate structured call lists and support allocation decisions.
Client Communication Structuring
I designed a 3-stage WhatsApp communication journey aligned with delivery milestones, differentiating finishers and non-finishers, and adapted for low-connectivity rural contexts.
Outcome
The program gained an integrated operational intelligence system that supports production, sales, and payment operations. Teams now have:
- —Structured production oversight
- —Real-time sales/production alignment
- —Optimized call center allocation
- —Stronger inventory and sales alignment
- —Improved payment completion
- —Digitally enhanced rural communication
Analytics became embedded into field execution — not just reporting.
Methodologies
Stack
Dataiku, Tableau, CommCare, Turn.io
Technical Foundations & Early Engineering Experience
Early in my career, I worked within large-scale data environments supporting senior engineers on ETL and transformation pipelines.
This experience shaped my understanding of data reliability, pipeline discipline, and the importance of clean modeling structures in supporting downstream analytics.
While my role was junior at the time, it built the technical foundation that supports my current hands-on approach to analytics system design.
Note: Projects are anonymized and represent examples of my consulting work. Some details have been adapted for confidentiality.
Have a similar challenge?
Let's discuss how data analytics can support your organization's goals.
Start a Conversation