Viewing context:Principal Architect

Cox Integration

MDSi → Cox Communications

Comprehensive bi-directional integration between MDSi ERP systems (AX09 and D365) and Cox Communications procurement APIs. 27 repositories organized into 3 core business domains: Item Master synchronization, Purchase Order processing, and PO Receipt management. Event-driven microservices architecture with dual ERP routing and Apigee OAuth authentication.

Repositories

Function Apps

Cosmos Containers

Service Bus Topics

System Design

Contribution as Principal Architect

Designed event-driven architecture with Service Bus orchestration
Created dual ERP routing patterns for seamless legacy/modern coexistence
Established carrier-agnostic integration framework reused across Comcast, Segra

Core Capabilities

Dual ERP Support

Routes transactions to AX09 or D365 based on division and business rules

Item Master Sync

Bi-directional customer cross-reference synchronization with Cox

Purchase Order Processing

Receives Cox POs and creates in appropriate MDSi ERP with acknowledgments

PO Receipt Submission

Polls both ERPs for receipts and submits to Cox procurement APIs

Apigee OAuth Integration

Secure API authentication with Cox enterprise gateway

Comprehensive Audit Trail

Cosmos DB logging for compliance and troubleshooting

Modules & Services

Item Master Sync

Customer cross-reference synchronization from Cox. Receives item master updates and syncs to both SQL Server and D365 with success/failure processing and notifications.

Purchase Order Ingestion

Receives purchase orders from Cox via Apigee API. Routes to appropriate ERP (AX09 or D365) based on business rules, with PO acknowledgment responses.

PO to AX09 Router

Creates purchase orders in legacy AX09 ERP system for applicable divisions with acknowledgment processing.

PO to D365 Router

Creates purchase orders in Dynamics 365 F&O for modern ERP divisions with full acknowledgment workflow.

PO Receipts from AX09

Timer-based polling of AX09 for new PO receipts, staging data for transformation and submission to Cox.

PO Receipts from D365

Retrieves PO receipts from D365 F&O for processing and submission to Cox procurement system.

Receipt Processing Pipeline

Transforms and validates PO receipts from both ERP systems, preparing data for Cox API submission format.

Cox Receipt Submission

Submits processed receipts to Cox via Apigee OAuth-authenticated API with success/failure handling.

Audit Trail & Logging

Comprehensive Cosmos DB audit trail for all integration transactions with success/failure tracking.

Notification Services

Slack and email notifications for integration status, failures, and alerts across all business domains.

Tech Stack

Languages

C#SQL

Frameworks

.NET 8Azure Functions v4 (Isolated Worker)

Infrastructure

Azure FunctionsAzure Service BusAzure Key Vault

Data

Cosmos DBSQL ServerD365 F&O

Loading project...