Professional Summary
JESSICA CLAIRE - 3 years of strong professional experience in Data Base Design, Data ware house, Application Development using Oracle 12c/11g, SQL, PL/SQL, Oracle Data Integration. - Experience in all phases of Software Development Life Cycle (SDLC) including analysis, specification, software and database administration, development, maintenance, testing and documentation. - Excellent proficiency in Data Extraction, Transformation and Loading, Database Modeling and Data ware housing tools and technologies. - Profound Knowledge in Star Schema Modeling and Snowflake Dimensional Modeling (Data Marts, Facts and Dimensions. - Strong technical expertise in creating and maintaining database objects - Tables, Views, Materialized Views, Indexes, Sequences, Synonyms, Database Links and Database Directories. - Extensive experience in developing PL/SQL Stored Procedures, Functions, Packages, Cursors, Collections (Nested tables), Records, Object types and Database Triggers. - Proficient in Oracle utilities and tools - SQL*loader, Export/Import, SQL*plus, SQL Developer and SQL Navigator. - Expertise in Performance Tuning and Query Optimization using various types of Hints, Partitioning, Bulking techniques and Indexes. - Profound experience in Tuning SQL queries using utilities like EXPLAIN PLAN, SQL Trace and TKPROF to improve the performance. - Strong experience in Oracle ETL data loading techniques like UTLFILE, SQL loader, Copy Command and External tables from various business source environments. - Exposure in Oracle Applications 11i Oracle Financials (AR, AP, GL modules of Oracle Applications 11i in multi Org, multicurrency environment. *Hands-on experience with Oracle APEX 5.0.3 (Oracle Application Express).