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.
