SINDHU V

Objective:

• To work in a dynamic organization in the field of IT that provides me generous opportunities to Explore &outshine while accomplishing personal, professional as well as organizational goals.

Professional Summary:

• Having 3.7 years of professional experience in Oracle as a PL/SQL Developer.
• Extensive RDBMS experience using oracle 11g SQL and PL/SQL. Strong technical expertise in creating and modifying database objects like Tables, Views, Indexes, Triggers, Sequences and Synonyms.
• Experience in writing complex SQL queries like Joins, Sub queries, Set Operators, Analytical Functions and Group Functions.
• Extensive Experience in developing PL/SQL Procedures, Functions, Packages, Collections (Nested Tables), Cursors, Exceptions, Dynamic SQL, DBMS Scheduler and Ref cursor.
• Proficient in Oracle utilities and tools such as SQL DEVELOPER, SQL PLUS, TOAD.
• Expertise in Performance Tuning using various types of Hints, Indexes, Joins and Bulking Techniques.
• Strong Experience in loading data from flat file to table using SQL Loader.
• Having Good knowledge in Table Partitioning, GTT, Materialized View, External Tables and Application Tuning.
• Involved in all phases of Software Development Life (SDLC) from collecting the requirements, analyze, design, development, testing and maintenance.
• Accomplish project goals consistently with elegant scalable code. Works great with team members under Agile methodology.

PROJECTS:

Domain : Banking Domain.

• In this Project i developed Procedures, Packages and Functions to implements the business Requirements using PL/SQL.
• Created/Modified database objects like Tables, Views, Indexes, Triggers, Sequences and Synonyms.
• Written complex queries using Sub queries, Joins and Set Operators to retrieve data from the multiple tables.
• Extensively used Cursors, Bulk Collect with Bulk Bind statements for manipulating the large amount of data and enhance performance.
• Created Dynamic SQL script in PL/SQL to build SQL statements dynamically at run time.
• Used Explain Plan, Hints for performance tuning of SQL and PL/SQL queries.
• Used DBMS Scheduler to automate the PL/SQL programs.
• Created Indexes on the tables for faster retrieval of the data to enhance database performance.
• Handled errors using System Defined Exceptions and User Defined Exceptions.
• Optimized and enhanced the existing procedures and SQL statements for the better performance.
• Using SQL Loader in order to load data from flat files into oracle tables.
• Coordinated with front end team provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Managed unit testing of the PL/SQL Programs.
• Worked with Production Support team to immediately resolve failures in production data processing.
• Attended walk through, code review and Status meeting to discuss the status of the project.

• Father's Name: Velmurugan. R
• Date of Birth: 01/03/89
• Marital Status: Married