Venkatesh Ch

Oracle Pl Sql Developer @Wells Fargo

CA, US

Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.• Worked on SQL*Loader to load data from flat files obtained from various facilities every day.• Created and modified several UNIX shell Scripts according to the changing needs of the project and client requirements. • Wrote Unix Shell Scripts to process the files on daily basis like renaming the file, extracting date from the file, unzipping the file and remove the junk characters from the file before loading them into the base tables.• Involved in the continuous enhancements and fixing of production problems.• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.• Developed PL/SQL triggers and master tables for automatic creation of primary keys.• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.• 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.• Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE. TKPROF and AUTOTRACE.• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.