Description
PROFESSIONAL SUMMARY * Oracle SQL, PL/SQL Developer with over 7 years of experience in Analysis, Design, Data Modeling (logical and physical) and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS). * Experience in all phases of database design including conceptual design, logical design, and physical design, implementing star-schema, snow-flake schema and building facts and dimensions. * Exposure to ETL development. * Strong knowledge on Oracle architecture and database design. * Effectively wrote complex SQL queries using joins, sub queries and inline views to retrieve data from database. * Proficient in Oracle Database design with relational models and very good experience in entity and attribute identification and developing the Entity-Relationships. * Extensively involved in Query Level Performance tuning using Optimizer Hints, partitioning tables and Indexes. * Tuned SQL queries and performed refinement of the database design leading to significant improvement in system response time and efficiency. * Extensively worked in Client-Server application development using Oracle 9i, 10g/11g, PL/SQL and SQL*PLUS. * Extensive experience in writing PL/SQL Packages, Functions, Procedures and Triggers to implement the business logic. * Experienced in developing Forms and Reports using Forms 10g, Reports 10g. * Expert in maintaining data integrity using various constraints and database triggers. * Knowledge in Test Scripts, Test Cases, and SQL QA scripts to perform Unit testing, System testing and Load testing. * Expertise in using PL/SQL Wrappers to protect the PL/SQL procedures or packages for security purpose. * Developed PL/SQL procedures and used SQL*Loader for transforming data from legacy systems. * Experienced in data exchange technologies like XML, XSD, XSL, and Web Services. * Experience with Oracle Application Development tools like Report Builder, Form Builder, TOAD, SQL*Loader, XML Publisher/BI Publisher. * Experienced in scheduling and monitoring UNIX shell scripts to administer all the environments. * Strong analytical, Inter-personal, Communication and Leadership skills.
Accomplishments
Highlights:
Keywords
