Involved in moving the data from flat files to staging area tables using SQL loader.Used ref cursors and collections for accessing comPLex data resulted from joining of a large number of tables.
Built complex queries using SQL and wrote stored procedures using PL/SQL.Involved in updating procedures, functions, triggers, and packages based on the change request.Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.Creation of database objects like tables, views, synonyms, materialized views, stored procedures, packages using Oracle tools like PL/SQL developer.
Created technical design for the back end PL/SQL based on business requirement documents and the functional system design. Wrote Unix shell scripts to process the files on a daily basis like renaming the file, extracting the date from the file, unzipping the file and remove the junk characters from the file before loading them into the base tables. Created and modified several Unix shell scripts according to the changing needs of the project and client requirements. Coordinating with the front-end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data. Creating indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries. Wrote SQL, PL/SQL, SQL PLus programs required to retrieve data using cursors and exception handling. Developed and modified triggers, packages, functions and stored procedures for data conversions and PL/SQL procedures to create database objects dynamically based on user inputs. 
Created and modified SQL PLus, PL/SQL and SQL Loader scripts for data conversions.Designing logical and physical data models for star and snowflake schemas using Erwin.Involving in the full development cycle of PLanning, analysis, design, development, testing, and implementation.
0 kommentar(er)
