Avnish Yadav

Full-Stack Software Engineer with 4+ years of experience building and optimizing enterprise applications using .NET, SQL Server, and modern JavaScript frameworks. Strong expertise in performance tuning, debugging complex systems, and modernizing legacy applications. Experienced in end-to-end development, from database design to frontend implementation. Currently building AI-driven automation solutions using LLMs and agent-based systems.

Software Engineer at Aloha Technology (2022-01 – Present)

Designed and maintained enterprise applications using C#,.NET, and JavaScript.

• Led root cause analysis for critical production issues, reducing system downtime by 20% and improving overall production stability.
• Optimized SQL queries and stored procedures, improving performance by up to 30%.
• Refactored database schema, achieving ~20% faster query execution.
• Contributed to modernization by building React-based features alongside legacy systems.

Project — Make the Dot

Worked on a full-stack application with a frontend built using Angular and a backend implemented in JavaScript, enabling seamless user interactions and efficient data processing.

• Implemented RESTful communication between client and server, improving data flow reliability and performance.
• Debugged and addressed cross-component issues, enhancing stability and user experience.
• Built and maintained key features across both frontend and backend, ensuring smooth integration and consistent functionality.

Current Projects — EleVia Platform (Present)

Working across two enterprise projects within the EleVia platform, contributing to both legacy maintenance and modernization initiatives.

• Developing and supporting frontend features using Sencha Ext JS (legacy system), handling complex UI flows, validations, and production issue fixes.
• Contributing to modernization efforts by building new features using React, improving user experience, and maintaining the code.
• Writing and optimizing SQL Server stored procedures, queries, and database logic to improve performance and reliability.
• Investigating and resolving production issues across the full stack, including UI, APIs, and database layers.
• Refactoring legacy modules and improving validation logic to reduce defects and improve system stability.
• Performing root cause analysis for timeout issues, data inconsistencies, and workflow defects.
• Ensuring smooth integration between legacy Ext JS modules and newer React components with the shared backend.

Master of Computer Applications in Computer Applications – AKTU (2020-01 – 2022-01)

Bachelor of Computer Applications in Computer Applications – CSJMU (2017-01 – 2020-01)