Principal architect · Hana System Limited · Jan 2020 — Apr 2026

Custom ERP for a bicycle manufacturer producing 200,000+ units a year

A custom ERP for a bicycle manufacturer producing more than 200,000 units a year, built on Clean Architecture with CQRS and MediatR using ASP.NET Core and Angular.

Scope

  • Modules covered Sales Order, Purchase, Production Planning, BOM Management, SKU Tracking, and Export.
  • Acted as principal architect using Clean Architecture with CQRS and MediatR on ASP.NET Core and Angular.

Results

  • Purchase-order processing reduced from three days to 40 minutes through automated BOM calculations.
  • Removed financial penalties from incorrect parts orders and enabled a zero-inventory policy that resolved chronic overstock.
  • EF Core query and SQL Server indexing optimisation achieved sub-300 ms response times on all critical API operations.
  • Real-time inventory tracking across four warehouses in Bangladesh and China, eliminating 15+ hours of manual reporting per week and reducing stock discrepancies by 12%.

StackC#, ASP.NET Core, Angular, SQL Server, EF Core, Clean Architecture, CQRS, MediatR

More case studies