Viewing context:Principal Architect

Fusion

Mr. Williams

Mission-critical enterprise software ecosystem for ~$1B revenue wholesale distribution company. 72+ applications spanning mobile sales force automation, IBM iSeries integration, warehouse operations, and delivery logistics. Primary ordering system processing high-volume transactions with offline-first mobile, fault-tolerant sync, and real-time operations dashboards.

138K+

Lines of Code

72+

Applications

Sync Services

~$1B

Client Revenue

Hybrid Integration Architecture

Contribution as Principal Architect

Designed bidirectional sync architecture between IBM iSeries and Firebase with 30-minute sync cycles
Created fault-tolerant failover bypassing cloud when unavailable with direct iSeries access
Architected event-driven messaging with RabbitMQ for decoupled, high-volume processing
Established offline-first mobile patterns with conflict resolution and queue-based sync

Architecture Overview

Enterprise Distribution Architecture:

┌─────────────────────────────────────────────────────────────────────────┐
│                           Mobile Sales Force                             │
│  ┌─────────────────┐                                                     │
│  │  Mobile App     │◄───── Offline-First ─────► Queue-Based Sync        │
│  │  (React Native) │       Full Ordering        Conflict Resolution      │
│  └────────┬────────┘                                                     │
└───────────┼──────────────────────────────────────────────────────────────┘
            │
            ▼
┌─────────────────────────────────────────────────────────────────────────┐
│                        Cloud Sync Layer (Firebase)                       │
│  ┌─────────────┐  ┌─────────────┐  ┌─────────────┐  ┌─────────────┐    │
│  │   Orders    │  │   Stores    │  │   Items     │  │   Credits   │    │
│  │   Sync      │  │   Sync      │  │   Sync      │  │   Sync      │    │
│  └──────┬──────┘  └──────┬──────┘  └──────┬──────┘  └──────┬──────┘    │
│         └─────────────────┼─────────────────┼─────────────────┘          │
│                           │                 │                            │
│                    ┌──────▼──────┐   ┌──────▼──────┐                    │
│                    │  RabbitMQ   │   │  Firestore  │                    │
│                    │  (Events)   │   │  (Storage)  │                    │
│                    └──────┬──────┘   └─────────────┘                    │
└───────────────────────────┼──────────────────────────────────────────────┘
                            │
            ┌───────────────┼───────────────┐
            │               ▼               │ Failover
            │    ┌─────────────────┐        │ (if cloud down)
            │    │   IBM iSeries   │◄───────┘
            │    │   AS/400 (DB2)  │
            │    │   System of     │
            │    │   Record        │
            │    └────────┬────────┘
            │             │
            └─────────────┼─────────────────────────────────────────────┐
                          │                                             │
┌─────────────────────────▼─────────────────────────────────────────────┴─┐
│                        Operations Layer                                  │
│  ┌─────────────────┐  ┌─────────────────┐  ┌─────────────────┐         │
│  │   Warehouse     │  │   Delivery      │  │   Reporting     │         │
│  │   Dashboards    │  │   Logistics     │  │   Suite (24+)   │         │
│  │   (WebSmart)    │  │   (GPS + SMS)   │  │   (VB.NET/C#)   │         │
│  └─────────────────┘  └─────────────────┘  └─────────────────┘         │
└─────────────────────────────────────────────────────────────────────────┘

Core Capabilities

Offline-First Ordering

Full ordering capability without network. Pre-sync catalog, history, and pricing. Queue-based submission with automatic conflict resolution.

IBM iSeries Sync

Bidirectional sync with AS/400 ERP. Real-time pricing via stored procedures. 22 microservices handling all data domains.

High-Volume Processing

Chunked database queries (200 records/batch). Connection pooling. Async/parallel processing. Primary ordering system for ~$1B company.

Warehouse Operations

Real-time picker productivity dashboards. Tote/container management. Loading board coordination. MVP gamification.

Delivery Logistics

GPS fleet tracking (Nextraq). SMS driver notifications. Scan compliance monitoring. Route optimization.

Fault Tolerance

Cloud bypass to on-prem when Firebase unavailable. Correlation IDs for distributed tracing. Slack alerts for failures. Multi-environment support.

Business Intelligence

True profit analysis by category. Sales rankings by chain. Picker productivity metrics. Expiring inventory tracking.

Standing Orders

Recurring order management. Suggested quantities based on weekly averages, on-hand inventory, and configurable trigger points.

Modules & Services

Mobile Ordering Application

Offline-first mobile app for sales reps with full ordering capability without network connectivity. Pre-syncs catalog, pricing, and store history. Queue-based sync with conflict resolution.

Sync Microservices (22 Services)

Event-driven microservices for bidirectional sync between IBM iSeries and Firebase. Handles stores, items, orders, credits, categories, manufacturers, UPCs, standing orders, and delivery verifications. CRON-scheduled with 30-minute sync cycles.

IBM iSeries Integration Layer

Direct ODBC connectivity to AS/400 DB2 databases (HSDATA42, MRWWHSE, PALMDTA). Stored procedure integration for real-time pricing calculations. Maintains sync with legacy ERP as system of record.

Warehouse Operations Dashboards

Real-time WebSmart dashboards for picker productivity, loading boards, late order tracking, and quality control. Auto-refresh displays for warehouse floor operations. MVP gamification for picker performance.

Delivery & Logistics System

Route management, driver allocation, delivery verification with scan compliance. GPS fleet tracking via Nextraq telematics integration. SMS notifications to drivers via Azure Communication Services.

Desktop Reporting Suite (24+ Apps)

Windows Forms reporting applications for operations analytics: driver scan compliance, category profit analysis, expiring inventory, out-of-stock planograms, picker productivity, and chain-specific sales rankings.

Order Entry Portals

Internal and customer-facing web portals for order entry, special pricing maintenance, and account management. Chain hierarchy support with store-specific pricing.

Regulatory Compliance

Altria/Philip Morris tobacco compliance reporting with state-by-state tax tracking. Automated report generation for vendor requirements.

Tech Stack

Languages

TypeScriptVB.NETC#PHPSQLPython

Frameworks

Node.js 18Express.jsReact NativeFirebase Cloud Functions.NET Framework 4.8WinFormsWebSmart PHP Framework

Infrastructure

Google Cloud PlatformFirebaseGoogle Cloud LoggingOn-prem IBM iSeries

Data

IBM DB2 (AS/400)Firebase FirestoreSQLite

Loading project...

Enterprise Distribution Architecture: ┌─────────────────────────────────────────────────────────────────────────┐ │ Mobile Sales Force │ │ ┌─────────────────┐ │ │ │ Mobile App │◄───── Offline-First ─────► Queue-Based Sync │ │ │ (React Native) │ Full Ordering Conflict Resolution │ │ └────────┬────────┘ │ └───────────┼──────────────────────────────────────────────────────────────┘ │ ▼ ┌─────────────────────────────────────────────────────────────────────────┐ │ Cloud Sync Layer (Firebase) │ │ ┌─────────────┐ ┌─────────────┐ ┌─────────────┐ ┌─────────────┐ │ │ │ Orders │ │ Stores │ │ Items │ │ Credits │ │ │ │ Sync │ │ Sync │ │ Sync │ │ Sync │ │ │ └──────┬──────┘ └──────┬──────┘ └──────┬──────┘ └──────┬──────┘ │ │ └─────────────────┼─────────────────┼─────────────────┘ │ │ │ │ │ │ ┌──────▼──────┐ ┌──────▼──────┐ │ │ │ RabbitMQ │ │ Firestore │ │ │ │ (Events) │ │ (Storage) │ │ │ └──────┬──────┘ └─────────────┘ │ └───────────────────────────┼──────────────────────────────────────────────┘ │ ┌───────────────┼───────────────┐ │ ▼ │ Failover │ ┌─────────────────┐ │ (if cloud down) │ │ IBM iSeries │◄───────┘ │ │ AS/400 (DB2) │ │ │ System of │ │ │ Record │ │ └────────┬────────┘ │ │ └─────────────┼─────────────────────────────────────────────┐ │ │ ┌─────────────────────────▼─────────────────────────────────────────────┴─┐ │ Operations Layer │ │ ┌─────────────────┐ ┌─────────────────┐ ┌─────────────────┐ │ │ │ Warehouse │ │ Delivery │ │ Reporting │ │ │ │ Dashboards │ │ Logistics │ │ Suite (24+) │ │ │ │ (WebSmart) │ │ (GPS + SMS) │ │ (VB.NET/C#) │ │ │ └─────────────────┘ └─────────────────┘ └─────────────────┘ │ └─────────────────────────────────────────────────────────────────────────┘