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
Case Study

Structuring the Analytics Backbone of a National Loyalty Program

Decathlon FranceRetail & Marketing

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

RFM segmentationBehavioral segmentationETL design & pipeline structuringA/B testing & holdout logicFraud pattern analysisExecutive performance steering

Stack

Redshift, Amazon QuickSight, Tableau

Case Study

Transforming Field Operations Through Structured Production & Payment Intelligence

myAgroAgriculture & Development

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

Operational data modelingWorkflow redesignDynamic prioritization logicPayment segmentationProduction quality monitoringBehavioral communication structuring

Stack

Dataiku, Tableau, CommCare, Turn.io

Case Study

Technical Foundations & Early Engineering Experience

Sopra SteriaPublic Sector & Enterprise

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