Case studies
Logistics & Warehousing · Japan
Global Warehouse Management System (WMS) Renewal
Converting a desktop warehouse management system (VB.net) into a multilingual, multi-database Java web app, enabling a Japanese client to take its WMS global and improve productivity in loading/unloading, packing and stocktaking.
JavaSpring BootThymeleafJPA/HibernateJasper ReportHTML5CSS3jQueryBootstrapOracle DBAmazon ElastiCache (Redis)HikariCP
Project overview
- Country: Japan (system deployed in Japan and Thailand)
- Industry: Warehouse Management System with EDI integration
- Scale: 80 MM
- Duration: 04/2019 ~ 02/2020
- Project type: System renewal (Desktop App VB.net → Web App Java)
- Scope of work: Requirements definition, Detail Design, Code / Unit test, Integration test, System test, Acceptance test (in collaboration between the client and the project team)
Problem / Challenges
- The client was running a legacy desktop WMS (VB.net) with the main functions: Master, Inbound, Inventory, Outbound, Stocktaking, EDI and User support.
- The platform needed to be migrated to upgrade it into a Global Warehouse Management System.
- The new system had to support multiple languages (Japanese, English) and multiple databases (Oracle, SQL Server, MySQL).
- Productivity in loading/unloading, outbound preparation, packing and stocktaking needed to be optimised and improved.
Solution
- Assigned members with extensive warehouse project experience (BA, Test Lead, PM) to the project.
- Worked with the client to survey and fully investigate the existing business processes of the legacy system.
- Prepared business flow and logic documents (detailed database processing).
- Advised on and proposed a suitable system architecture and technologies for the new system.
- Multi-layer architecture: Web Layer (Thymeleaf views, Controller) → API Layer (REST API) → Domain Layer → Data Access Layer (JPA/Hibernate, HikariCP) on Spring Boot 2, running on a Java EE Application Server; data on Amazon RDS (Oracle DB and other DBs), caching with Amazon ElastiCache.
- Frontend: multilingual GUI with dynamic screen controls configured in the database.
- Backend: API services that execute business flows, acting as the main controller that returns data to the frontend and other systems.
Key features
- Inbound: Advanced Shipping Notice, Import/Manage Inbound Plan, Receipt, Print Plan List, Quality Inspection, Put Away / Cancel Inbound, Feedback on stock, Send Email.
- Outbound: Order management, Import/Manage Outbound Plan, Allocate / Cancel Allocate, Order Picking, Print Picking List, Packing / Cancel Packing, Dispatch, Confirm / Cancel Outbound, Delivery feedback.
- Inventory: Stock Class, Lot Number / Production Date, Inbound Number.
- Stocktaking: Change Location / Class / Quantity, Start / Complete Stocktaking, Re-Import Stock Data.
- Master Data: management of Location, User, Item, Customer.
- EDI Management: Upload Data.
- Support: user support.
Technology
- Java (Spring Boot 2, Thymeleaf, JPA/Hibernate), Jasper Report, HTML5, CSS3, jQuery, Bootstrap.
- Database: Oracle DB (primary), with support for SQL Server, MySQL; Amazon RDS.
- Amazon ElastiCache (Redis) for data caching and higher performance.
- HikariCP – a high-speed JDBC connection pool.
Results
- A new web-based WMS supporting multiple languages and databases, deployed globally in the Japanese and Thai markets.
Have a similar project?
Contact SSD