Sumit Bansal

Background

About Sumit Bansal

Accomplished Full Stack.NET/Azure Developer with over 12 years of experience delivering innovative, high-performance software solutions for global clients. Specializing in designing and implementing scalable microservices architectures aligned with OOP and SOLID principles, ensuring system efficiency and reliability. Proficient in C#.NET.NET Core, MVC, Azure DevOps, SQL, and CI/CD pipelines to streamline deployment cycles and enhance productivity. Skilled in collaborating with cross-functional teams to deliver impactful, business-critical solutions. Experience with Agile software development methodology using JIRA, Azure DevOps. Experience in developing applications using OO techniques, N-tier applications. Extensive experience in design patterns and SOLID principles. Experience in design and development of client-server and web application using Microsoft.NET framework 4.0, 4.5, 4.7, 4.8, C#.NET 5.0, 6.0, 7.0, 8.0, ASP.NET, MVC.Net Core, WCF, Web API, SQL Server, Web Services, Azure DevOps, Entity Framework, LINQ, Fluent validations. Handsome experience with API authentication using OAuth and JWT. Extensive experience in writing Unit tests with MS Tests, NUnit, XUnit, Moq, SpecFlow, SnapShot tests, Fluent Assertions. Handsome experience in creating and configuring the CI/CD pipelines with YAML (Azure DevOps). Experience in application L3 Production Support including monitoring the production servers, scheduled jobs, incident management and receiving incidents and requests from end-users, analyzing these and either responding to the end user with a solution or escalating it to the other IT teams. Experience in writing complex SQL queries, Stored Procedures, Functions. Prudent understanding of business problems, with the ability to translate them into optimized data solutions. Experienced in working with complex datasets and extracting meaningful insights using SQL Server. Proficient with various SQL functions, subqueries, complex joins, CASE statements, and Common Table Expressions (CTEs). In-depth knowledge of SQL and relational database management systems (RDBMS), with a focus on SQL Server. Skilled at understanding business requirements to craft complex queries and suggest optimization or redundancy reduction. Excellent communication skills, with the ability to interact effectively in a customer-facing role.