Built in production. Proven at scale.
20 years of enterprise data engineering across ERP, POS, loyalty, ecommerce, supply chain, and marketing platforms — for a nationally operating enterprise with 400+ locations. Every diagram below represents a real system built, deployed, and maintained in production.
From Enterprise Delivery to Autonomous Agent Suites
Twenty years of enterprise delivery across four domains. Each one is now reimagined as an autonomous agent suite — the same expertise, running 24/7 without a team.
Supply Chain Integration Suite
A standardized warehouse interface contract deployed across 5 global nodes — US warehouse, US webstore, UK 3PL, China DC, and international freight forwarder. Every node receives identical master files. Every inbound transaction routes through a common staging schema back to the ERP. Real-time purchase order replication via Azure Synapse → Delta Lake distributing to 4 global logistics partners, replacing nightly FTP batch. Dual-path inventory feeding both operational integration and cloud archive simultaneously.
The same integration patterns, now autonomous. Four agents monitor every layer of the supply chain 24/7 — warehouse reconciliation, PO distribution, freight status, and supplier compliance risk.
Loyalty & Customer Intelligence Suite
A complete loyalty ecosystem for millions of customers — points accrual from raw POS transactions, voucher generation and distribution, customer master profile merging identity across Salesforce, ecommerce, POS, and WMS. RFM scoring and behavioral segmentation feeding Salesforce Marketing Cloud. Email engagement facts from 7 event types across billions of rows, year-partitioned, enriching the golden customer record.
Five agents running continuously — processing transactions, generating rewards, resolving customer identity, enriching engagement data, and keeping segmentation current for marketing campaigns.
Commerce & Catalog Intelligence Suite
End-to-end ecommerce pipeline — product catalog from PLM through multi-hop SSIS staging into the retail item master, then distributed to POS (400+ registers), ecommerce, PIM, and ERP. 13-step web order lifecycle: Salesforce Commerce → fraud detection → OMS → payment settlement → US/UK fulfillment split. MuleSoft dual-path for real-time POS rollups and GL transactional posting. Loyalty promotions synchronized across all channels to registers in real time.
Four agents monitoring every layer of commerce — catalog consistency, order health, inventory risk, and promotion propagation — so nothing falls through the cracks between systems.
Platform Modernization Suite
Full enterprise data platform modernization — all systems unified under a medallion architecture with Loop automation for Bronze ingestion, Materialized Lake Views for Silver transformation, pipeline-driven Gold with star schema, and a lakehouse semantic model with Data Agents and DirectLake Power BI. Migrated 200+ SSIS packages and 15+ integrated systems into a governed, scalable foundation.
Four agents keeping the platform healthy around the clock — monitoring ingestion runs, validating data quality after every transformation, watching upstream sources for breaking schema changes, and ensuring the semantic model stays accurate and performant.
All Four Suites. One Unified Intelligence Mesh.
External Signals
Public Intelligence Layer
Powered by LucidAgent.ai
Your Data Foundation
Enterprise Data Foundation
Domain Agent Suites
Supply Chain
Loyalty
Commerce
Platform
Morning Briefing Agent
One email. 6am. Every anomaly, opportunity, and risk from overnight.
LucidAgent's public data layer feeds risk and market signals into your enterprise foundation. Domain agents run on your clean data. The Morning Briefing Agent synthesizes everything into one daily digest. This is what we build.
The Architecture Behind the Suites
Every domain suite is built on real architecture diagrams from production systems. Explore the technical foundations.
Microsoft Fabric · Metadata-driven medallion pipeline
Fully metadata-driven ingestion pipeline built on Microsoft Fabric. A control table stores source connection strings, schemas, and destination mappings — a ForEach pipeline iterates every entry to load all sources into the Bronze lakehouse without a single hardcoded pipeline per source. Materialized Lake Views transform into Silver. A Copy Data pipeline builds a star schema with surrogate keys into Gold. An enterprise semantic model with DirectLake serves Power BI reports, Data Agents, and natural language chat.
Pattern: Metadata-driven ingestion · Control table ForEach · Materialized Lake Views · Star schema with surrogate keys · DirectLake semantic model · AI agents over data
Enterprise hub-and-spoke ETL
Full enterprise integration architecture for a global multi-channel retailer. 20+ source systems normalized through a central SQL Server data warehouse, serving downstream analytics, Salesforce clouds, and international partner networks.
Pattern: Hub-and-spoke ETL · Central DW · FTP batch ingestion · SSIS pipelines
Multi-warehouse supply chain integration
Designed and maintained a standardized warehouse interface contract deployed across five nodes — internal US warehouse and webstore, UK 3PL warehouse and webstore, China DC, and international freight forwarder. Every node receives identical master file structure (product, location, distributions). Every inbound transaction (receipts, shipments, adjustments, inventory sync) routes through a common SSIS staging schema back to the ERP. The contract is the architecture — adding a new warehouse is a configuration, not a build.
Pattern: ERP-authoritative hub · Standardized interface contract · SSIS staging layer · 5 warehouse nodes · Nightly inventory reconciliation across all nodes
Product item creation pipeline
End-to-end product data integration: from PLM design through staging hops into the retail item master, then distributed to POS, ecommerce, and product content systems. Shows the hybrid moment — legacy SSIS paths running alongside the emerging Azure Data Lake path.
Pattern: Multi-hop SSIS staging · Item master distribution · Hybrid legacy-to-cloud
Purchase order distribution · Lakehouse pattern
Real-time D365 purchase order replication into a Bronze/Silver medallion pipeline via Azure Synapse. Delta Lake as the export hub distributing POs to four global 3PL logistics partners — replacing nightly FTP batch with event-driven distribution.
Pattern: Real-time replication · Bronze/Silver medallion · Delta Lake 3PL export hub · ACID transactions
Full enterprise data platform · Modernized
The complete "after" picture — all 15 enterprise systems unified under Azure Synapse Analytics with a Bronze/Silver/Gold medallion architecture, Delta Lake storage, and a clean serve layer. Replaces point-to-point SSIS integrations with a single governed platform.
Pattern: Azure Synapse workspace · Full medallion · Unified ingestion · Cold archive tier · Serve layer
Retail Data Platform
The complete enterprise retail data platform — 200+ SSIS pipelines integrating loyalty points engine, customer master profile across Salesforce/ecommerce/POS/WMS, RFM segmentation, GL reconciliation pipeline, and email fact enrichment across billions of rows. 10+ years in production. The foundation for both the Loyalty & Customer Intelligence Suite and the Commerce & Catalog Suite.
Pattern: 200+ SSIS solutions · 10+ years in production · Full retail stack integration · Foundation for domain agent suites
Global Supply Chain Integration
Standardized warehouse interface contract deployed across 5 global nodes — US warehouse, US webstore, UK 3PL, China DC, and international freight forwarder. Real-time purchase order replication via Azure Synapse → Delta Lake to 4 global logistics partners, replacing nightly FTP batch. Dual-path inventory simultaneously feeding operational integration and cloud archive.
Pattern: 5-node warehouse interface · Real-time PO distribution · Dual-path inventory · FTP batch replacement
End-to-End Ecommerce Integration
Full ecommerce data integration: product catalog from PLM through multi-hop staging to item master, distributed to 400+ POS registers, ecommerce platform, PIM, and ERP. 13-step web order lifecycle through fraud detection, OMS, payment settlement, and US/UK fulfillment split. MuleSoft dual-path for real-time POS rollups and GL posting. Loyalty promotions synchronized end-to-end.
Pattern: 13-step order lifecycle · Multi-channel catalog distribution · POS sync · MuleSoft dual-path integration
Inventory integration · Dual-path pattern
D365 inventory data simultaneously feeds the primary integration path (SSIS staging → Deck Commerce → Salesforce) and branches to Azure Data Lake Gen2 for cloud archive. A clean example of the dual-path pattern used during modernization transitions.
Pattern: Dual-path: primary integration + parallel cloud archive from same source
Sales transaction pipeline · Hybrid state
POS transaction flow showing three eras running simultaneously: in-store PostgreSQL hardware stack, Azure Service Bus real-time event streaming, legacy SSIS batch analytics path, and the emerging D365/Delta Lake future state — all operating in parallel.
Pattern: Hybrid three-era coexistence · Real-time events + SSIS batch · Salesforce dual role (CX + loyalty)
Loyalty voucher distribution
Voucher data originating in Salesforce Loyalty flows through an Azure SQL staging layer into the central data warehouse, then distributes to Aptos Sales Audit for redemption tracking and Salesforce Commerce Cloud for online application.
Pattern: Bidirectional Salesforce integration · Central DW as distribution hub · Voucher lifecycle tracking
Loyalty customer sync + email fact enrichment
Customer profiles from Salesforce Loyalty and Aptos CRM converge in the central data warehouse. Email engagement facts from Salesforce Marketing Cloud arrive via FTP into a staging SQL instance, enriching customer records before syncing back to Salesforce.
Pattern: Multi-source customer master · Email fact enrichment · Salesforce bidirectional sync
ExactTarget email tracking · Billion-row pipeline
Salesforce ExactTarget pushes 7 email event types via FTP into a SQL repository. Due to volume (billions of rows), EmailFact tables are partitioned by year (2017–2023). At runtime, pre-2023 data is pre-compiled and unioned with the live year, then merged into a single-row-per-address rollup table.
Pattern: High-volume FTP ingestion · Year-based table partitioning · Incremental rollup merge · One row per email address
Web order fulfillment · Current + future state
Full web order lifecycle: Salesforce creates orders → fraud detection → Deck Commerce orchestrates fulfillment → Adyen payment settlement → US/UK split (D365 + GXO). MuleSoft handles 30-minute POS rollups to workforce management. Future state annotations show D365 GL direct posting replacing batch files.
Pattern: 13-step order lifecycle · Fraud + payment integration · US/UK fulfillment split · Current + future state documented
MuleSoft integration · POS sales + promotions
Salesforce Loyalty promotions push to Commerce Cloud and down to Jumpmind POS registers. MuleSoft acts as the integration hub for two concurrent paths: 30-minute POS rollup files to Storeforce workforce management, and transactional GL files to Dynamics 365 via package APIs.
Pattern: MuleSoft dual-path: Storeforce 30-min rollups + D365 GL transactional posting · Promotion lifecycle management
dreamUp.one
A fully custom music experience site featuring a WebGL fBm fractal shader hero, interactive audio player with 4 visualizer modes (Tunnel, Radial, Wave, Orbs), SoundCloud integration, and Focus Mode for full immersive playback. Built on Next.js with a dark teal aesthetic.
Pattern: WebGL fragment shader hero · Canvas audio visualizers · SoundCloud-backed player · Focus Mode immersive playback