Technical Skills: Databases: Oracle 7.x/8i/9i/10g/11g (SQL, PL/SQL, Stored Procedures, Triggers), MS SQL SERVER 2000/2005/2008, DB2/UDB, Teradata, SAP Tables and MS Access. Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.Įxperience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS.Įxperience in ETL techniques and Analysis and Reporting including hands on experience with the Reporting tools such as Cognos.Ĭreated Shell Scripts for invoking SQL scripts and scheduled them using crontab.Įxcellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.

Worked extensively on Ref Cursor, External Tables and Collections.Įxpertise in Dynamic SQL, Collections and Exception handling.Įxperience in SQL performance tuning using Cost-Based Optimization (CBO). Partitioned large Tables using range partition technique.Įxperience with Oracle Supplied Packages such as DBMS_SQL, DBMS_JOB and UTL_FILE.Ĭreated Packages and Procedures to automatically drop table indexes and create indexes for the tables.

Loaded Data into Oracle Tables using SQL Loader. Good knowledge on logical and physical Data Modeling using normalizing Techniques.Ĭreated Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based).ĭeveloped Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.ĭeveloped materialized views for data replication in distributed environments.Įxcellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.Įxperience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables. Strong experience in Data warehouse concepts, ETL. Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.Įxperience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques.Įxpertise in Client-Server application development using Oracle 11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOAD and SQL*LOADER.Įffectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query ReWrite and Transportable table spaces. Over 7 years of programming experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).

Oracle PL/SQL Developer Resume Professional Summary: 

Oracle pl sql developer resumes