 Over 3.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). 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. Coordinate with Business Analysts and customers to develop business requirements and specifications documents. Generate reports for internal and external customers for business performance monitoring and business decision making. Conduct training programs and knowledge transfer sessions to junior developers when needed. Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques. Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views and Query Re-Write  Strong experience in Data warehouse concepts, ETL. Good knowledge on logical and physical Data Modeling using normalizing Techniques. Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based). Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL. Developed materialized views for data replication in distributed environments. Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables. Loaded Data into Oracle Tables using SQL Loader. Partitioned large Tables using range partition technique. Experience with Oracle Supplied Packages such as DBMS_SQL and UTL_FILE. Created Packages and Procedures to automatically drop table indexes and create indexes for the tables. Worked extensively on Ref Cursor and Collections. Expertise in Dynamic SQL, Collections and Exception handling. Experience in SQL performance tuning using Cost-Based Optimization (CBO). Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS.