Anantha Chary Erroju

Experience

• 

  ITC Infotech

  Sept 2008 - Feb 2012

  Associate IT Consultant

   Developed and modified Oracle PL/SQL code based on requests raised by changes in business logic, norms and standards Coordinating with users, analyzing the defects and making the necessary code changes. Wrote complex SQL queries for analyzing issue raised by end user. Rebuild Indexes and ran Gather Status for improving performance Responsible for timely client deliverables Worked on the Remedy/Triole tickets and provided the solutions based on the priority of the problems reported by the customer. Involved in unit testing, peer-reviews, functional testing, and documentation. Show less

• 

  Tech Mahindra (formerly Mahindra Satyam)

  Feb 2012 - Aug 2014

  Senior Software Engineer

   Analyzing & Impact study for the existing system and proposing various alternative solutions to the client/customer. Creation, modification of database objects such as Procedures, Functions, Packages for new and existing functional requirements Analyzing the defects, debugging and making the necessary code changes Prepare SQL queries to extract the data upon request by user periodically Responsible for timely deliverables to the client Analyze and resolve if data uploading failed from Informatica to Database Resolving production problems for the application and ensure all support level agreements are met.Involved in unit testing, peer-reviews, functional testing, and documentation Show less

• 

  Ness Technologies India (pvt) Ltd

  Sept 2014 - Oct 2022

  Sr Software Engineer

   Involving in Requirement gathering with clients/customers Analyzing user requirements and proposing various alternative solutions to the client/customer. Creating database objects such as Procedures, Functions, Packages for functional requirements Used Indexes, Materialized Views, Bulk Collect and Bulk Bind to improve the performance Developed Informatica and UI related database objects Using Informatica Power Center Designer extracted data from oracle database and flat files and staged into a single place and applied business logic to load them in the central oracle database Monitoring and solving issue in Informatica Power Center Analyzing existing applications databases(legacy system) and Sync up data to newly developed database Analyzing the UAT defects, debugging and making the necessary code changes Involved in unit testing. Show less

• 

  S&P Global

  Jul 2019 - Mar 2023

  Senior Software Engineer Technical Lead
• 

  Tech Mahindra

  Feb 2023 - now

  Technical Lead