Skip to content
LucidDataMind
AGENTS I BUILT24 LIVE

Data engineering and intelligence practice

Your data is scattered across systems. I turn it into intelligence your team can actually use.

Customer masters, RFM segmentation, campaign-ready audiences, operational pipelines — built for you, run by me, always yours to export.

Twenty years in enterprise data engineering · 200+ data integration solutions

Engagements from $2,500 audits to full platform builds from $25K.

One customer master and what it feedsA single resolved customer master at the centre, with lines drawn out to RFM, campaign audiences, dashboards, segments and loyalty processing.ONE MASTERRFMAUDIENCESDASHBOARDSSEGMENTSLOYALTY
SCHEMATICONE CUSTOMER MASTERYOURS TO EXPORT
OFFERINGS

What the work actually is.

  • 01MASTER

    Customer Intelligence

    A unified customer master with identity resolution and dedupe, RFM scoring and behavioral segments — delivered as audiences your marketing team can use the day they arrive.

    IDENTITY RESOLUTION · RFM · AUDIENCES

  • 02COMMERCE

    Commerce & Supply Chain

    Catalog, purchase orders, ASNs, receipts, allocations and inventory moving cleanly between systems that were never designed to talk to each other.

    CATALOG · ORDERS · INVENTORY · GL

  • 03REPORTING

    Business Intelligence

    KPI and dimensional models under the dashboards, with automated refresh pipelines that keep executive reporting current instead of stale.

    KPI MODELS · DASHBOARDS · REFRESH

  • 04PIPELINES

    Data Integration

    System-to-system pipelines, API and file-based feeds, and partner data exchange on standardized interface contracts — with validation and orchestration around them.

    CONTRACTS · VALIDATION · ORCHESTRATION

  • 05AI

    Applied AI

    Agents for repeatable analysis, natural-language questions over your own data, and automated briefs. On top of the pipeline, never instead of it.

    AGENTS · NL Q&A · BRIEFS

  • 06RUN

    Platform Operations

    Managed hosting, scheduled refresh, monitoring and incident response — so the model stays current instead of rotting after launch.

    HOSTED · MONITORED · KEPT CURRENT

  • ANYTHING

    What you need

    Doesn’t fit a box above? Most real problems don’t. If the data exists, I’ll build what it takes — pipeline, model, integration, or platform.

    COMMON SHAPES, NOT THE LIMIT

Delivered from the systems you already run — CRM, POS, ERP, e-commerce, email platforms, spreadsheets, APIs.

SELECTED WORK

13 PLATES · 16 ENTRIES

Twenty years of enterprise delivery.

Every plate is a production architecture, sanitized for confidentiality. This is the foundation the agent work stands on.

  • Enterprise Lakehouse Modernization

    Microsoft Fabric medallion architecture migration for a multi-system enterprise. Loop automation for Bronze ingestion, Materialized Lake Views for Silver transformation, pipeline-driven Gold with a lakehouse semantic model and Data Agents.

    Confidential

  • Customer & Loyalty Data Platform

    The complete enterprise data platform — 200+ data integration pipelines integrating loyalty points engine, customer master profile across CRM/e-commerce/POS/WMS, RFM segmentation, GL reconciliation pipeline, and email fact enrichment across billions of rows. The foundation for both the Loyalty & Customer Intelligence Suite and the Commerce & Catalog Suite.

    Confidential

  1. PL. 01Loyalty customer sync + email fact enrichment
  2. PL. 02Loyalty voucher distribution
  3. PL. 03Email engagement tracking · Billion-row pipeline
  4. PL. 04Customer & Loyalty Data PlatformEnterprise hub-and-spoke ETL
  5. PL. 05Microsoft Fabric · Metadata-driven medallion pipeline
  6. PL. 06Full enterprise data platform · Modernized
  7. PL. 07End-to-End Ecommerce IntegrationWeb order fulfillment · Current + future state
  8. PL. 08ESB integration · POS sales + promotions
  9. PL. 09Sales transaction pipeline · Hybrid state
  10. PL. 10Inventory integration · Dual-path pattern
  11. PL. 11Product item creation pipeline
  12. PL. 12Multi-warehouse supply chain integrationSupply Chain Integration
  13. PL. 13Purchase order distribution · Lakehouse pattern

See the work →

THE AGENT FLEET

24 LIVE · 17 BUILT

Agents I built to carry the repeatable part of the work. I set what they look for and I check what they return — the judgment is not delegated.

StatusAGENTTASKCADENCESTATUS
Customer MasterResolves customer identity across all systemsCadence: DailyBuilt
RFM SegmentationComputes RFM scores and behavioral segmentsCadence: WeeklyBuilt
Hazard WatchMonitors USGS earthquakes, NWS alerts, FEMA disasters, PHMSA hazmat, FRA rail accidentsCadence: Every 15 minLive
Anomaly IntelligenceFlags anomalies and compound signals for reviewCadence: Daily 6amLive
Morning BriefingSynthesizes overnight intelligence into one daily email digestCadence: Daily 6amLive

Live agents run in production. Built agents are finished and deployable per engagement — they are not running until yours is. All 41 are in the agent catalog.

THE FUNDAMENTALSTWELVE RULES

How I work.

These are the rules every deliverable is built on. They are also the reason the numbers survive contact with your own analyst.

  1. Your systems don’t reconcile. I measure exactly how far off they are.

    Operations data and marketing data were never designed to talk to each other. Joining them cleanly — and measuring exactly how cleanly — is where customer intelligence starts. Most organizations have quietly accepted that the two halves of their business tell different stories.

  2. Identity comes out on the way in — unless the work needs it back.

    Personal data is stripped at ingest by default, and everything downstream runs on hashed keys and aggregates. Where the deliverable is an addressable audience, identity is re-joined at the last step and only there, with column-level encryption on anything sensitive at rest. You hold identity where the work requires it and nowhere else.

  3. A rate without a denominator isn’t a number.

    “Underperforming” means nothing until you know capacity. Where the denominator doesn’t exist, I’ll tell you the figure is relative and stop. Where it can be found, the same analysis turns a directional hunch into something you can act on.

  4. Anything that drives a recommendation gets verified against source.

    A clean finding that dies under your analyst’s scrutiny costs more than it was worth. I recompute before I claim — and when something doesn’t hold up, you hear that. It is a stronger position than the finding would have been.

  5. I won’t approximate to fill a gap.

    Where your data can’t support a measure, you get precision about the gap instead: what’s missing, why it matters, what would close it. Those gaps routinely become the sharpest questions an organization has about its own systems.

  6. “Unknown” and “zero” are different facts.

    Conflating them produces confident wrong answers. Unknown stays unknown, every field carries its coverage, and uncertainty arrives as a stated range — not a hidden assumption.

  7. Column names lie. Values don’t.

    Flags that govern nothing. Status fields that mean something other than their label. Indicators that exclude most of what they claim to describe. I classify by inspecting what is actually there, which is why the findings hold.

  8. A control nobody has attacked is a control nobody has tested.

    Privacy floors, validation rules, suppression thresholds — every one gets adversarial review, because a passing test only proves the test passed. That process has caught things no deterministic check could see.

  9. Correctness is built in, not remembered.

    Constraints that make bad data impossible to insert. Tooling that refuses to publish anything diverging from what was verified. Discipline drifts. Enforcement doesn’t.

  10. Aggregate with a floor, and test the arithmetic around it.

    No group below the threshold is ever visible — and the harder work is confirming that published figures can’t be decomposed back below it. Suppression that survives only a mechanical check isn’t suppression.

  11. What I deliver explains itself.

    No walkthrough required. Every view says what it shows, how to read it, and what it can’t tell you — because the person who forwards it isn’t the person who commissioned it.

  12. I find my own mistakes first.

    That is what makes the rest of the numbers worth trusting.

FOR AGENCIES

Built behind the agency.

You own the relationship and the campaign strategy. I handle the customer-data layer behind it — ingestion, identity resolution, segmentation, audience production and intelligence. White-labeled, or introduced as your data partner — both models are laid out on the For Agencies page.

  • YOU KEEP THE CLIENT
  • I STAY BEHIND THE CURTAIN
  • CAPABILITY WITHOUT HEADCOUNT

THE LADDER

I meet you where you are on your data path.

Platform builds are structured as a one-time setup engagement and a monthly platform fee, scoped to your business.