Real Time Supplier Chain Management

About Client

It is an application for real time supplier chain management. Purchase row materials related to agriculture and manufacture final product fertilizer which helps to improve growth and productiveness of plants. Also provide transportation of final product through the ships. Applications contains full details of purchase row materials, manufacturing final fertilizer product, composition of different substances, location details, live tracking of ship, planning of shipment, storage area planning, routing of transportation, supplier details, sales details, scheduler jobs to generate & send reports, import & export data for performance & history management etc.

Requirements

Started work in the application which development is ongoing.

Challenges

Client want to stop cheating in manual auction.

Solutions

Prepared analysis and solution document, shared.

Purposed the solution with following technology stack

Backend: Java 11, Spring Boot with Apache Siro oAuth2, Spring Data JPA, Spring AOP, Apache Camel, Thyme Leaf
Database: PostgreSQL, Liquibase & Metabase (Reporting purpose only).
Fronted: HTML, CSS, JavaScript, jQuery, Ajax, Syncfusion components, Bootstrap and other jQuery & bootstrap based plugins
Cloud: AWS EC2 Instance

Main Entities

Admin, Marketer, Terminal User, Logistic User, Inventory Controller, Operational User & General. In the application:

Admin

User Details, Location & Shipment Details, Dashboards(Inventory, Operational), Planning, Supplier & Contracts, Vessel Tracking etc.

Marketer

Planning area, Sales information & Warehouses.

Terminal

Shipment handling, Reports generation & planning details.

Logistic

Warehouse capacity planning, Inventory transactions.

Inventory

Manages inventory & stock details.

Operational

Manages shipping & vessel tracking details.

General

View details & generate reports for bottom level.

Results

It was difficult to implement because of support required to operational teams of business. Implementation was done phase by phase.

Phase 1: It was required to provide training & guide to operational teams, technical teams and continue monitoring on system. Transferred manual work to computer based management system.
Phase 2: Added fixes in system for the issues which were found after phase 1 implementation, added new systems and extended features of existing servers as per need.
Phase 3: Applied fixes, extended existing features and added new reports for management to take decision from history of data.
Phase 4: Added features in existing reports generating, updated reconciliation feature for operational & management teams and delivered system successfully.