Umanath V Email and Phone Number

Over 4+ years of programming experience as an Oracle PL/SQL Developer.Working experience in Software Development Life Cycle (SDLC), which involves Requirements Gathering, Analysis, Design, Development, Implementation, Maintenance and Support.Proficient in creation, modification and effectively use of database objects like Tables, Sequences, Indexes and Views.Expertise in complex SQL queries including sub queries for faster data retrieval from multiple tables.Extensively used SQL joins, Oracle analytical functions, Pseudo Columns and Grouping functions for data analysis.Proficient in developing and maintaining of Packages, Functions, Stored procedures and Triggers.Extensively used Cursors, Composite data type and Collections in writing the backend PL/SQL code.Experience on Autonomous Transaction and Materialized Views.Good knowledge on SQL LoaderExperience in using Bulk collect, Bulk binds and Bulk Exceptions.Experience in UTL_FILE and Exception handling.Used DBMS utilities to extend the functionality of PL/SQL programs, such as UTL_FILE to read and write from database to generate data file.Experience in Database Performance Tuning using Oracle Hints, Explain plan, Table Partitioning, Indexes and Gathering Statistics.Handled errors using Exception Handling extensively for the ease of debugging and displaying the error message in the application.Having Knowledge in UNIX Commends.