• Implemented advanced caching mechanisms in the inventory microservice using Spring Boot, resulting in reduced API call frequency, minimized network overhead, and improved system efficiency by 30%.• Optimized database performance by 30% through targeted view breakdowns and query optimizations using global temporary tables,specifically for securities lending.• Improved reporting microservice with robust exception handling, detailed error logging, and automated notifications for empty reports, ensuring operational stability and system reliability.•Addressed issues in batch processing by logging row numbers for data access exceptions, enhancing error detection and debugging capabilities for large data files.