Sivaramakrishnan A Email and Phone Number

*Coordinated with the front-end design team to provide them with the necessary stored procedures and packages andthe necessary insight into the data• Worked on SQL*Loader to load data from flat files obtained from various facilities every day• Developed PL/SQL triggers• Created PL/SQL stored procedures, functions and packages• Created scripts to create new tables, views, queries for new enhancement in the application using TOAD• Created indexes on the tables for faster retrieval of the data to enhance database performance• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL andPL/SQL engines• Created PL/SQL scripts to extract the data from the operational database• Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools likeToad, PL/SQL Developer and SQL* plus• Partitioned the fact tables and materialized views to enhance the performance• Created records, tables, collections (nested tables and arrays) for improving Query performance• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages inthe application