Ramesh

SUMMARY

·     Over all 5+ Years of work experience in Oracle PL/SQL and Postgresql.

·     Extensive experience in writing queries,Joins, PL/SQL stored procedures and functions.

·     Using TOAD to write query and analysis data and perform basic DML and DDL operations in the Oracle Database.

·     Created Oracle Tables, Sequence, Synonyms, wm_concat, pivot & UN pivot, Index and Views .

·     Having good knowledge on Analytical functions like Rank, Dense_rank,Lead and Lag.

·     Having experience in load the data from Excel file into table and Table into excel file Using TOAD.

·     Effectively made use of Dynamic SQL , Ref cursor and Cursors ,Triggers and Records.

·     Developed PL/SQL Procedures to populate the data by applying business logic.

·     Created Packages for populated the data step by step into master tables.

·     Created UTL procedures for extracting large data into csv file..