Viewing context:Principal Architect

Comcast Integration

MDSi → Comcast

Comprehensive bi-directional integration between MDSi ERP systems (AX09 and D365) and Comcast Oracle. 100+ repositories organized into 10 business domains handling sales orders, purchase orders, PO receipts, inventory transfers, shipment notifications, and movement journals. Event-driven microservices architecture processing thousands of transactions daily.

103

Repositories

Function Apps

Cosmos Containers

Service Bus Topics

Integration Architecture

Contribution as Principal Architect

Designed domain-driven microservices architecture with 10 bounded contexts
Created bi-directional Oracle integration patterns with event-driven messaging
Established resilient messaging with dead-letter handling and retry policies

Core Capabilities

Bi-directional Oracle Integration

Real-time data exchange between MDSi and Comcast Oracle ERP systems

Sales Order Pipeline

Receives, validates, and routes Comcast sales orders to appropriate MDSi ERP

Purchase Order Processing

Ingests purchase orders from Oracle for fulfillment in MDSi systems

PO Receipt Posting

Posts receipt confirmations back to Oracle for both standard and inter-org receipts

Inventory Transfer Sync

Synchronizes inter-organization transfers and sub-inventory movements

Shipment Notifications

Posts intransit and issue-to-project notifications to Oracle

Movement Journal Sync

Syncs scrap issuance and transfer journals between D365 and Oracle

Dual ERP Routing

Intelligent routing to AX09 (legacy COMC901) or D365 based on division

Audit & Tracking

Cosmos DB audit trail with full transaction history and status tracking

Real-time Notifications

Slack and email alerts for integration outcomes and error conditions

Modules & Services

Sales Order Ingestion

HTTP entry point for Comcast sales orders with validation and Service Bus publishing

Purchase Order Processing

Receives and processes purchase orders from Comcast Oracle into MDSi

PO Receipts - Standard

Posts standard purchase order receipts from MDSi D365 to Comcast Oracle

PO Receipts - Inter-Org

Posts inter-organization PO receipts for cross-division inventory moves

Inter-Org Transfers

Bi-directional inventory transfer synchronization between MDSi and Comcast warehouses

Misc Receipts & Returns

Return from project and miscellaneous receipt processing from MDSi to Oracle

Issue to Project Notifications

Posts issue-to-project notifications (NE division) from MDSi to Comcast

Intransit Shipment Notifications

Posts intransit shipment notifications (ARC division) to Comcast Oracle

Scrap Issuance Journals

Movement journals for scrap issuance sync from MDSi D365 to Comcast Oracle

Sub-inventory Transfers

Movement journals for sub-inventory transfers between warehouse locations

AX09 ERP Router

Routes COMC901 division transactions to legacy AX09 ERP system

D365 ERP Router

Routes standard division transactions to Dynamics 365 F&O

Tech Stack

Languages

C#SQL

Frameworks

.NET 8.NET Core 3.1Azure Functions v4

Infrastructure

Azure FunctionsAzure Service BusAzure Key Vault

Data

Cosmos DBSQL ServerOracle

Loading project...