Back to Projects

Enterprise ERP Sync Platform

Enterprise ERP synchronization platform processing $60B+ annually across 196 countries

$60B+

Annual Volume

80%

Workload Reduction

5K+

Global Customers

196

Countries Served

The Challenge

Enterprise payment processing platforms handle billions in transactions, but customers use different ERP systems (NetSuite, QuickBooks, Intacct). Manual data entry was causing:

  • 8+ hours weekly on manual reconciliation per customer
  • 3% error rate in financial data entry
  • 2-day lag in financial reporting
  • Customer churn due to integration friction

The Solution

Built a real-time, event-driven synchronization platform that:

Smart Data Mapping

AI-powered field mapping that learns from user corrections, reducing setup time by 80%

Real-time Sync

Event-driven architecture syncs changes in under 100ms using webhooks and queues

Error Recovery

Automatic retry logic with exponential backoff and dead letter queue processing

Conflict Resolution

Intelligent merge strategies for concurrent updates with audit trail

Technical Architecture

┌─────────────┐     ┌─────────────┐     ┌─────────────┐
│ Enterprise  │     │    Sync     │     │    ERPs     │
│   Events    │────▶│   Engine    │────▶│ (NS/QB/IA)  │
└─────────────┘     └─────────────┘     └─────────────┘
       │                    │                    │
       ▼                    ▼                    ▼
┌─────────────┐     ┌─────────────┐     ┌─────────────┐
│   Webhook   │     │   Message   │     │     API     │
│   Handler   │     │    Queue    │     │   Adapter   │
└─────────────┘     └─────────────┘     └─────────────┘

Tech Stack

Node.jsC#/.NET 8MongoDBRedis 7RabbitMQDockerKubernetesAzure DevOps

Results & Impact

Business Impact

  • ✓ 80% reduction in global payables workload
  • ✓ 25% faster financial close processes
  • ✓ Payment processing to 196 countries
  • ✓ Support for 5K+ global customers

Technical Achievements

  • ✓ Zero-downtime OAuth2 migration
  • ✓ Successful .NET 8 upgrade
  • ✓ Redis 6→7 infrastructure modernization
  • ✓ Enhanced monitoring and alerting

Key Technical Decisions

Event Sourcing over Direct Updates

Chose event sourcing to maintain complete audit trail and enable replay capabilities for debugging

Adapter Pattern for ERP Integration

Built pluggable adapters for each ERP, allowing rapid addition of new integrations

Idempotent Operations

Every operation is idempotent with unique keys, preventing duplicate transactions

My Role

As Tech Lead of the Sync team, I:

  • Led QBO OAuth2 migration including architecture design and zero-downtime implementation
  • Completed .NET 8 migration across multiple services (SyncApp, QBO Service, Intacct Service)
  • Modernized Redis infrastructure from v6 to v7, including breaking changes in node-redis
  • Established engineering best practices with design document templates
  • Enhanced API documentation and improved Swagger specifications
  • Resolved NodeJS security vulnerabilities and implemented performance optimizations