Context

I designed and built a web-based platform from scratch that connects clients, primarily eCommerce stores, with their ERP systems (specifically Advarics).

The platform allows clients to upload sales data, products, pricing, and other operational information, which is then processed, analyzed, and integrated seamlessly into the ERP system. In addition, the system generates and exports files to SharePoint for downstream analytics in Power BI.

I was responsible for the full lifecycle: architecture, backend, frontend, integrations, and DevOps/maintenance.

Challenge

The project presented several technical and operational challenges:

• Massive historical data spanning the last 8+ years
• High-volume batch and streaming data processing
• Complex data mapping across multiple entities: sales, products, customers, inventory
• Need for flexible ERP integration to support future systems beyond Advarics ERP
• Continuous feature expansion requiring frequent refactoring
• Ensuring reliable, fault-tolerant processing pipelines

The platform had to scale, remain maintainable, and handle large datasets without performance degradation, while also remaining extensible for future integrations.

What I Did

• Designed and implemented the full system architecture from scratch
• Developed backend pipelines for batch and streaming processing of high-volume sales and product data
• Built data transformation and mapping logic for seamless integration with Advarics ERP
• Enabled automated file generation and exports to SharePoint for analytics
• Developed frontend interfaces for client uploads, monitoring, and error handling
• Created extensible abstractions to allow easy integration with additional ERP systems
• Maintained and refactored the platform continuously as new features were added
• Oversaw DevOps: deployment, monitoring, and maintenance of production systems
• Ensured reliability, performance, and data integrity across all processing pipelines

Operational Impact

• Enabled clients to upload, process, and integrate historical and ongoing sales data efficiently
• Streamlined ERP data flows, reducing manual work and errors
• Supported analytics by preparing data for Power BI reporting
• Provided a scalable, maintainable platform capable of adapting to new ERP integrations
• Reduced operational friction for eCommerce clients while ensuring system reliability and performance