Gourav Das

• Developed stored procedures, functions and triggers to support application requirements.
• Created and maintained database objects including tables, views, indexes, and triggers to ensure data integrity and performance efficiency.
• Optimized existing queries for better performance using SQL query tuning techniques.
• Implemented debugging programs to determine vulnerabilities and issues in software.
• Designed complex reports using SQL Server Reporting Services.

Project 1: YESBANK [JLG] Role: API Design, SQL Database Optimization Tools: Angular, .NET Core API, SQL Server 2019.

• Designed and developed a web application and APK to facilitate joint loans for women in rural areas.
• Optimized SQL databases to enhance performance and scalability.
• Collaborated with stakeholders to align technical solutions with business needs.

Project 2: YESBANK [MFI] Role: Web Application Maintenance, SQL Query Debugging Tools: ASP.NET Web Forms, ASP.NET API, C#, SQL Server 2016.

• Debugged and optimized complex SQL queries to improve system performance and reliability.
• Implemented intricate database business logic to meet critical application requirements.
• Enhanced file upload functionalities, ensuring secure and efficient data handling.