Pavan Kumar Bachu

Software Engineer

Cognizant Technology Solutions

12.2020 - Current

Analyzed business requirements and designed appropriate software solutions using C#, ASP.NET, MVC, SQL Server and AWS.
Proficient in SQL database management, designed and implemented complex SQL queries for data extraction and Implemented stored procedures, triggers,functions and scheduling Jobs.
Designed and implemented automated solutions for 3+ applications using ASP.NET to streamline repetitive tasks, resulting in a 30% increase in operational efficiency.
Provide 24/7 production support for .Net applications, ensuring optimal performance and availability.
Developed and maintained robust APIs to support various client applications, ensuring adherence to RESTful principles and best practices using .NET, facilitating seamless communication between the front-end and back-end components.
Experienced in handling L2 and L3 incidents, demonstrating the ability to troubleshoot, diagnose, and resolve issues promptly to minimize downtime and ensure application reliability.
Optimized existing queries for better performance using SQL query tuning techniques and Designed complex reports using SQL Server Reporting Services.
Achieving an impressive 95% customer uptime by rapidly resolving production issues, incidents, and service requests collaborating with development, testing, and infrastructure teams.
Led Root Cause Analysis (RCA) efforts for critical incidents, identifying underlying issues and implementing preventive measures to reduce recurrences.
Developed ASP.NET web application using C#, HTML, JavaScript and CSS which uploads bulk files to AWS S3 bucket which reduced the manual work by 25%.
Debugged existing code written in C# to identify and fix errors or bugs.
Performed unit testing on various modules of the application to ensure quality assurance standards were met prior to deployment.
Deployed new versions of software releases in production environment following established release management process.
Resolved customer issues by establishing workarounds and solutions to debug and create defect fixes.
Established and monitored Service Level Agreements (SLAs) for incident response and resolution times, consistently meeting or exceeding performance targets.