PT XYZ is an e-commerce company that applies free shipping services. Every month the company will receive a
shipping transaction invoice from third-party logistics, in the Excel file. The operational division will perform a manual validation process between distance and price with data in the Excel file. With manual processes, several problems arise, such as long processing time and errors caused by human factors.
The validation system will use batch processing to process extensive data without interruption and will be executed using
the Spring Batch framework. The programming language used
is Java with a Spring Boot framework. The system can accept
an Excel file that contains a collection of invoice notes and then
process them, resulting in a report. The average amount of data
an employee can do per day with a time of two hours is 500 data.
After the system is implemented, the validation process takes
120 seconds for 500 data. The percentage for time reduction is
98.33%.