Currently, I have been with N.R Group Ltd. as a Team Leader in ORACLE ERP software Development, for making this software Oracle Database 11G & Oracle Developer Suite 10G are being used.Responsibility :-• Requirement gathering from the Business Team.• Convert the functional requirements into technical document as per the business standards.• Worked as per the CR Raised from the end user.• Analyze the Existing code and do the impact analysis.• Created Database Objects like tables, Views, sequences, Synonyms, Stored Procedures, functions, Packages, Cursors, Ref Cursor and Triggers as per the Business requirements.• Involved in modifying various existing packages, Procedures, functions, triggers according to the new business needs.• Wrote SQL Queries using Joins, Sub Queries and correlated sub Queries to retrieve data from the database.• Used SQL Loader to upload the information into the database and using UTL_FILE packages write data to files.• Involved in explain plan for query optimization.• Data validation/Reconciliation report generation.• Involved in peer to peer code reviews.• Code validation as per client requirement.• Testing of code functionality using testing environment.