UMAMAHESWARI BOYA

Serving as an IT Analyst at Tata Consultancy Services, responsibilities encompass data extraction, transformation, and loading processes while ensuring data integrity and performance optimization. The role demands a strong grasp of SQL and PL/SQL to manage databases effectively. Engaging in root cause analysis and application enhancements according to the client's specifications is a fundamental aspect of this position.

• Developed SQL code to extract and validate data, followed by loading it into databases efficiently.
• Optimized SQL queries and implemented indexing strategies, reducing average query execution time by 50% and improving report generation speeds.
• Led root cause analysis for 100+ high-priority incidents, reducing recurring issues by 40% and improving system uptime.
• Fixing the data issues within the table using PL/SQL code.
• Performed root cause analysis, identifying issues, and implementing enhancements as required.
• Optimized data retrieval performances by creating indexes on tables.
• Managed many incidents and service requests via ServiceNow with a 98% SLA compliance rate, enhancing customer satisfaction and resolution time.
• Clarified/Fixed the user queries in application level.
• Collaborated with cross-functional teams to resolve application-level issues, resulting in a 25% faster resolution rate for critical defects.