Mayur Vaswani

Nomination and AP Portal Enhancements

Description: Contributed to the integration of additional features in the Nomination and Accounts Payable (AP) portal to improve functionality and user experience.
Responsibilities:

• 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.

Titan SRD Application

Description: Built a high-performance Spring Boot application to integrate with Titan APIs, optimize data retrieval, and ensure efficient caching with Redis.
Responsibilities:

• 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.

TGS-IR Migration Project

Description: 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. Responsibilities:

• 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.