GSPANN developed the entire solution and created a microservices-based service layer that interacts with order data in various databases. The solution fetches the information from various tracking portals and renders the required information over the Angular 2.0-based user interface.
We built the service layer using Spring Boot and deployed it on the internal OpenShift cloud. We used Spring Batch for writing batch jobs to read source CSV files (that may have 500K+ records sent via FTP to the staging table) and merged them to the main table in the new tracking database.
To improve the performance, we partitioned source files and read them simultaneously via a multi-threaded program. We inserted them into the staging table and implemented SSO using SAML (IDP-based approach).
The user-friendly dashboard allows in-store employees to search order details from varied sets of keywords—like email, order/tracking ID, etc.—and get corresponding tracking details. The solution is extremely modular and can be extended as per the requirement. For instance, code can be enhanced to fetch order details via service instead of the database.
The in-store executives can now deliver better customer experience by promptly replying to the customer queries regarding their order status. The custom dashboard improved the overall efficiency of business operations.