Viewing context:Principal Architect

MRW Fusion Mobile Platform

MR Williams

2023 – Present

active

Offline-first mobile platform bridging IBM i (AS400) with cloud services for wholesale distribution. Fully disconnected ordering app with hybrid failover and automatic sync supporting ~$1B in annual orders.

Components

Fusion Services

24+

Reports

132

SQL Scripts

$1B

Orders/Year

Offline-First Architecture

Contribution as Principal Architect

Designed hybrid sync architecture between IBM i and Firebase services
Created failover architecture bypassing cloud when down
Established messaging patterns with RabbitMQ and device sync

Architecture Overview

Failover Architecture:
┌─────────────────┐     ┌─────────────────┐
│   Mobile App    │────▶│   Cloud API     │
│ (SQLite + WatermelonDB) │     │   (Firebase)    │
└─────────────────┘     └────────┬────────┘
        │                        │
        │ If cloud down          ▼
        │              ┌─────────────────┐
        └─────────────▶│   On-Prem API   │
                       │   (IBM Db2)     │
                       └─────────────────┘

Core Capabilities

Offline Ordering

Fully disconnected sales rep ordering workflow

Inventory & Pricing

Master catalog, store pricing, and UPC management

Credits & Aging

Customer credit accounts and aging workflows

Planograms

Shelf layout templates per store/category

Logistics

Route planning, GPS tracking, delivery verification

Failover

On-prem bypass when cloud services are unavailable

Modules & Services

Mobile App

React Native offline-first application

Sync Gateway

On-prem to cloud synchronization

Failover System

Cloud bypass to on-prem when cloud unavailable

Cloud Functions

Event-driven processing and device sync

Customer Portal

Legacy customer portal for ordering and account access

Legacy Reports

24+ Windows reporting applications for operations

ERP Scripts

Legacy ERP scripting for IBM i workflows

Tech Stack

Languages

TypeScriptJavaScriptC#VB.NETPHPSQL

Frameworks

React NativeExpoNode.js 18Express.jsFirebase Cloud Functions.NET Framework 4.8WinFormsPowerHouse/WebSmart

Infrastructure

Google Cloud PlatformFirebaseOn-prem IBM i

Data

Firebase FirestoreIBM i (Db2 via ODBC)SQLiteWatermelonDB

Loading project...

Failover Architecture: ┌─────────────────┐ ┌─────────────────┐ │ Mobile App │────▶│ Cloud API │ │ (SQLite + WatermelonDB) │ │ (Firebase) │ └─────────────────┘ └────────┬────────┘ │ │ │ If cloud down ▼ │ ┌─────────────────┐ └─────────────▶│ On-Prem API │ │ (IBM Db2) │ └─────────────────┘