Designed and developed a robust invoice management system to streamline the tracking of client invoices, automate reminders for pending payments, and facilitate Excel-based invoice operations. This system improves financial workflow efficiency and reduces manual overhead through automation and seamless data handling.
Key responsibilities included developing multiple RESTful API endpoints using Spring Boot. These endpoints enabled custom searches to fetch invoice details, retrieve pending invoices (individually or in bulk), update invoice statuses, and add new client invoices. A critical feature involved triggering automated email reminders for pending invoices, ensuring timely follow-ups and improved payment cycles.
To support bulk operations, implemented functionality for uploading invoice data from Excel sheets using MultipartFile and Apache POI. This allowed clients to efficiently submit multiple invoices at once by adhering to a standard template. Additionally, developed a download endpoint to provide a sample invoice sheet, guiding clients in correctly formatting their bulk uploads.
This project demonstrates a strong grasp of backend development, file handling, and real-world application of Java-based technologies, along with a practical understanding of client-oriented feature design and API integration.