Apr 2023 – Present · 3 yrs 2 mos

• Contributed to the integration of additional features in the Nomination and Accounts Payable (AP) portal
• to improve functionality and user experience.
• Created an end-to-end state flow for nominations in the Nomination app, implementing a state
• based workflow to control tasks and activities based on the nomination's current state.
• Developed upload functionality that allowed users to download an Excel template, upload an
• Excel sheet, and validate the data, with successful and failed records displayed on the UI for quick
• feedback.
• Upload functionality enabled bulk AP invoice creation, allowing users to create up to 1000
• invoices at a time, reducing manual invoice creation time by 80% (from 10 minutes per invoice to
• couple minutes).
• Completed numerous hotfixes in production to address urgent issues following new deployments,
• improving system stability, and customer satisfaction.
• Followed up with stakeholders to gather data on additional requirements, missing features, and
• testing needs, ensuring the solution met business needs and was thoroughly tested.
• Integrated external APIs with the application and built wrapper REST APIs to fetch data from Redis,
• instead of repeatedly calling the external APIs. This reduced response time by 70-80% and
• improved overall application performance.
• Designed the Redis repository to support multi-attribute keys, enhancing flexible data access
• and retrieval, making the system more adaptable to business needs.
• Applied data compression before storing data in Redis, reducing the storage size by 30-40%,
• optimizing storage efficiency, and reducing costs.
• Developed a scheduler and generic REST API to regularly update Redis data, ensuring data
• consistency and reliability across services.
• Leveraged Spring Security to secure sensitive API endpoints and ensure data privacy.

Jun 2022 – Mar 2023 · 9 mos

• Migrated legacy PL/SQL queries to a REST API-based architecture using Spring Boot, JPA, and
• Hibernate, creating a scalable backend for the TGS-IR application.
• Designed a microservices architecture with separate servers to handle write and read requests,
• optimizing performance and resulting in improved response times by 20%.
• Redesigned the database schema in MySQL for the new Spring Boot application, creating new
• tables and relationships, and streamlining interactions through JPA and Hibernate.
• Leveraged materialized views, indexed tables, and implemented pagination to reduce query
• response times, resulting in a 40% performance improvement for high-frequency data requests.
• Conducted unit testing with JUnit and Mockito, achieving 80-85% code coverage, and used Sonar
• to track code quality and ensure high-quality code.