BANDARU HEMANTH KUMAR

Results-driven IT professional with 1.4 years of experience in PL/SQL support and a solid understanding of Oracle technologies. Proven track record of delivering exceptional PL/SQL support, utilizing SQL queries, joining tables, and employing analytical functions. Detail-oriented and organized with effective communication skills, able to meet tight deadlines.

• Resolved existing performance issues in the database which optimized the system
• Within months, I was selected as a module lead in the service.

Project Title   : Dealer Management System(DMS)
Client              :  Mahindra and Mahindra, India.
Environment: Oracle 10g, SQL, PL/SQL.
Duration         : 09/01/22 - 12/01/23.

Description:
To develop a web-enabled solution using the existing Wipro Framework
which will standardize and automate M&M Dealer Operations in the
following areas. The Dealer Management System is a system in place at
the client's dealer offices and manages their day-to-day business in an
effective way.

• Thoroughly understand the Requirements and Design and discussion
  with Leads and BA as well as customers.
• Involved in production applications support to clients & end-users,
  day-to-day support tasks like Issue resolving usage.
• Modify the existing program units (Packages, Stored procedures,
  Functions) for Bug fixing and follow the best practices and coding
  standards by implementing Normalization in Table design.
• Worked in Error handling and tracking, by handling the exceptions and
  inserting the errors into log tables.
• Preparing the Health Check queries for every Bug and finding the total
  cases in the same scenario.
• Providing technical support and defect fixes during system integration
  testing and UAT.
• Providing solutions to technical issues, and responsible for meeting
  development Schedules and ensuring the delivered solution meets the
  technical specifications and design requirements.
• Developing reusable DB components such as packages, procedures,
  composite types, etc. using PL/SQL, Where Business logic is mostly
  handled from the DB side .
• Bug fixing, and automation of manual/repeated processes.

I hereby declare that the information furnished above is true to the best
of my knowledge and belief.
(Hemanth Kumar Bandaru)