Project Overview

We conducted a project to develop a new system to replace the sales management system that the client had been using for many years, aiming to significantly improve operational efficiency.
To address complex business requirements that the legacy system could not handle and to move away from obsolete technology, we rebuilt the system tailored to the latest operating environment. Additionally, we achieved seamless data integration with the vehicle dispatch system and accounting system, which had previously operated independently, thereby optimizing the entire business process.

Tech Stack and Development Tools

• Programming Language: VB.net
• Back-end Framework: .NET Framework
• Database: Oracle
• Task Management Tool: Backlog
• Communication Tool: Backlog
• Other Tools: GrapeCity Spread, Active Reports

Client Challenges

• Reduced operational efficiency due to the gap between business requirements and the current system

  Due to long-term operation, the current sales management system could no longer keep up with actual workflows and increasing requirements. Manual tasks to supplement the system’s deficiencies were increasing, becoming a burden on the staff, making it urgent to revamp the system to fit current business processes.

• Decreased maintainability due to technological obsolescence

  The technologies used in the current system were outdated, making modifications and function additions difficult. It was necessary to avoid the risk of the system becoming a “black box” and to establish a sustainable operational structure.

• Redundant data entry effort due to lack of data integration with peripheral systems

  The sales management system was not integrated with other internal systems such as the vehicle dispatch system and accounting system, resulting in fragmented data. This caused the effort of entering the same data into multiple systems and the risk of transcription errors, making automation through system integration a major issue.

Client Requirements

The client requested a system reconstruction using a new technology stack that is highly maintainable and capable of stable operation in the future, allowing for flexible response to future business expansion and changes. Specifically, they requested function implementation and integration mainly from the following three perspectives:

• Integration of processes from order processing to logistics

  To systemize order receipt, order placement, and incoming/outgoing shipment processing, and to integrate data with the existing vehicle dispatch system, thereby streamlining the entire logistics operation.

• Advancement and efficiency of management operations

  To implement credit management functions for each business partner and master data management functions, as well as to build functions for automatic creation/output of monthly reports and payment request management, thereby reducing management costs.

• Seamless integration with the accounting system

  In the final stage of business, accounting processing, to automatically integrate journal entry data into the accounting system, realizing an accounting workflow free from input errors and manual effort.

Our Solution and Approach

• Strict adherence to detailed design and reliable implementation to ensure quality

  Based on the detailed design documents provided by the client, we faithfully carried out program development and unit testing. By accurately translating each requirement into code, we guaranteed the operation exactly as the client imagined. Especially for parts with complex business logic, we created comprehensive test cases to drive the project with a structure that minimizes the risk of defects after release.

• Proposal for performance optimization to meet requirement standards

  During the development process, we verified the program’s performance. For areas where processing speed was judged not to meet the requirement standards, we proactively proposed and implemented optimization measures. We did not just create functions but also improved code and logic to ensure a comfortable response speed for users.

• Design review and correction proposals for complex requirement definitions

  Since this system had diverse and complex business requirements, confirming consistency at the initial design stage was essential. We reviewed the design content in detail from the implementer’s perspective and presented correction proposals to make specifications more rational and consistent. By refining specifications at the design stage, we prevented rework and realized system operations that the client truly desired.