LOKESH RAPURU

Experienced IT professional with over 12 years in Technical Support and Development, currently positioned as Associate Consultant Engineer at RateGain. Expertise in Core Java, Spring MVC, JSF, and ASP.NET C#, complemented by extensive database management skills in MySQL, SQL Server, and PostgreSQL. Skilled in performing comprehensive root cause analyses (RCA) for production issues while guiding L1–L3 support teams through mentorship, process enhancements, and cross-functional collaboration to achieve high-quality, reliable solutions.

• Incident resolution and automation: Led the development of a self-service application to automate the handling of frequent database requests, significantly reducing the manual workload for DBAs while enhancing system security and operational efficiency
• Customer satisfaction: improved customer experience by implementing streamlined support processes and targeted training initiatives, resulting in higher satisfaction levels through timely issue resolution and proactive communication
• Cross-functional collaboration: facilitated weekly coordination meetings with development, process, and product teams to address complex technical issues, manage support requests, and ensure seamless service delivery, and system reliability
• Team leadership and mentorship: Successfully led and mentored L1, L2, and L3 support teams, enhancing their technical capabilities, and contributing to stronger first-call resolution performance
• Cost optimization: executed cost-efficient support strategies that reduced resource consumption while maintaining high service quality and operational standards

OSS - Xpressbees (2022-2024) 

About the application: - 

OSS is a self-service tool designed to help ground operations quickly identify and resolve issues without needing technical support, by inputting key details, users can view the exact problem and recommended actions directly from the system

Responsibilities:

• Developed the application using ASP.NET C#, connecting to both MS SQL and PostgreSQL databases
• Built features to allow dynamic issue lookup and resolution through a user-friendly interface
• Integrated Keycloak for managing user and admin-level access securely
• Automated frequent database request tasks using Quartz Scheduler, reducing manual work
• Wrote complex queries to fetch and analyze operational data
• Collaborated with stakeholders to gather requirements and implement key features
• Handled production issues, performed root cause analysis (RCA), and ensured long-term fixes

DBAS3 - Xpressbees (2022-2024) 

About the application: 

DBA S3 is a self-service application that allows teams to run database queries independently, reducing the workload on the DBA team, and it ensures better security, access control, and transaction logging

Responsibilities:

• Developed the application using ASP.NET C#, connecting to both MS SQL and PostgreSQL databases
• Implemented role-based access control (RBAC), allowing only admins to manage user access
• Restricted access to specific tables to enhance database security
• Added transaction logging for all database activities to track and debug issues
• Allowed admins to manage table access without needing code changes
• Enabled the application to build queries based on user input via a UI with dropdowns and checkboxes, making it easier for users to interact with the database

AmES WorkFlow - Amnet (2022-2024)

About the application: - 

AmES handles various services provided by Amnet, managed by different production teams, and the system allows configurable creation of production titles for existing and future services, along with customizable workflows The workflow involves input files undergoing specific production activities Using a skill set matrix, tasks are assigned to employees based on their competencies. Employees claim and complete tasks through the AmES portal, which tracks time spent and monitors efficiency as part of resource management The system also records employee proficiency for each skill set, helping calculate efficiency based on task complexity.

Responsibilities:

• Analyzed and gathered requirements to understand project needs, and ensure accurate development
• Managed different modules and screens, contributing to the overall system architecture and design
• Developed code in Java (Spring MVC, Spring JDBC) using Eclipse
• Participated in Unit Testing to ensure the changes met functional and quality standards.