Customer Order Management System

The Customer Order Management System upgrade project was initiated to modernize the company’s internal application ecosystem and improve the maintainability of legacy business systems.

The system supports core business functions such as order quotation, order management, and order inquiry. The original platform was built with .NET and SQL Server, with most of the business logic implemented through complex stored procedures. Over time, this architecture became difficult to maintain, harder to extend, and more prone to errors, which increased development costs and impacted system performance.

To address these challenges, the project focused on refactoring the legacy system, migrating key business logic to a modern Java-based architecture, and decoupling complex stored procedure logic into maintainable service-layer modules. The upgrade improved system scalability, code readability, maintainability, and long-term development efficiency.

Project Background

The legacy Customer Order Management System had accumulated a large amount of business logic inside database stored procedures. This made the system difficult to debug, test, and enhance when business requirements changed.

The modernization project aimed to:

Improve system maintainability and reduce dependency on database-side business logic.
Refactor complex order-related workflows into clearer backend service modules.
Improve performance and stability for order quotation and order management processes.
Establish a more standardized backend architecture for future feature expansion.
Reduce development risks caused by tightly coupled legacy logic.

System Architecture

The upgraded system adopted a Java-based backend architecture with Spring Boot, Redis, RabbitMQ, MyBatis Plus, SQL Server, and Docker. The architecture helped separate business logic from database procedures and improved the maintainability of the overall system.

My Role

In this project, I was responsible for analyzing the refactoring workload, creating the development task plan, coordinating implementation progress, and guiding junior engineers during the development process.

I also participated directly in core module development, technical issue resolution, documentation preparation, and system delivery support.

Personal Contributions

Customer Order Quotation Module

Implemented the Customer Order Quotation Module as one of the core business modules of the upgraded system.
Refactored quotation-related business logic from legacy stored procedures into backend service-layer code.
Improved the readability, maintainability, and testability of quotation workflows.
Supported order quotation data processing, business rule validation, and backend API implementation.

Project Planning and Task Coordination

Analyzed the refactoring scope and estimated the development workload.
Created development task plans based on business priorities and technical dependencies.
Assigned tasks to team members and tracked overall project progress.
Helped ensure that development work was delivered according to the planned schedule.

Technical Guidance and Issue Resolution

Provided technical guidance to junior engineers during implementation.
Reviewed development issues and helped resolve problems related to business logic, backend APIs, data processing, and system integration.
Supported troubleshooting during development, testing, and integration phases.

Documentation

Prepared API documentation to support frontend and backend integration.
Created test documentation to validate business workflows and system behavior.
Prepared system architecture documentation to support future maintenance and knowledge transfer.

Technical Highlights

Legacy system modernization from .NET-based architecture to Java-based backend services
Refactoring complex SQL Server stored procedures into maintainable service-layer modules
Customer order quotation workflow implementation
Backend API development with Java and Spring Boot
Redis-based caching support
RabbitMQ-based asynchronous processing
SQL Server integration with MyBatis Plus
Docker-based deployment support
Team coordination and junior developer mentoring
Technical documentation for API, testing, and system architecture