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