Occupation:Database Designer |
Location:Delray Beach, FL |
Education Level:Bachelor |
Will Relocate:YES |
Description
Professional Summary: A Oracle certified Professional with 9+ years experience in Data modeling, database design, Programming, Development and Implementation of Client-Server Applications & Database systems oracle PLSQL development and UNIX technologies. A Microsoft certified Professional with 5+ years experience using MS SQL Server 2012/2008/2005. * 6+ years of experience in ODI 12c. * 9+ years of software development experience in IT Industry, with 9+ years of hands on experience in Business Requirement Gatherings, Analysis, Design, Data Modelling, Development, Testing and Implementation of Data warehouse/Business Intelligence using OBIEE 10.x and OBIEE 11g. * Ability to write complex SQL queries to analyze the production environment and also to write strong PLSQL procedures, functions, triggers, packages. * Strong experience in performance tuning techniques in coding PL/SQL blocks. * Ability to debug the functions, procedures and packages. * Strong experience in Advanced PLSQL concepts. * Experience in SQL and PL/SQL tuning and query optimization tools like SQL Trace, Explain Plan, and DBMS_PROFILER. * Strong knowledge in Oracle utilities like SQL*Loader, Export/Import and data pump utilities like EXPDP/IMPDP. * Extensively used package like DBMS_STATS, UTL_FILE, DBMS_SCHEDULER and UTL_SMTP. * Strong knowledge with PL/SQL Wrapper to protect the PL/SQL procedures or packages. * Experience in SQL and PL/SQL tuning and query optimization tools like SQL Trace, Explain Plan, and DBMS_PROFILER. * Strong knowledge in Oracle utilities like SQL*Loader, Export/Import and data pump utilities like EXPDP/IMPDP. * Extensively used package like DBMS_STATS, UTL_FILE, DBMS_SCHEDULER and UTL_SMTP. * Extensively used Cubes & Rollups for making cross tabular reports. * Used Oracle Data Integrator Designer (ODI) to develop processes for extracting, cleansing, transforming, integrating and loading data into Data Warehouses. * Experienced in Installing and Configuring Oracle Data Integrator (ODI) software tool in a three-tier environment and performing periodic upgrades, performing source-to-target mappings, storage capacity planning and developing ETL. * Experienced in setting up ODI standalone Agents and J2EE Agents on Web Logic server based on requirements. * Experienced in provisioning users (Security Manager) and setting up/manage source and target system connections (Topology Manager) in ODI. * Hands on experience with the new version ODI 12C. * Extensive experience in OBIEE Administration Tool, BI Answers, Intelligent Dashboards, BI Publisher, Oracle BI Apps, Delivers and Agents (alerts) with OBIEE Applications. * Experienced in designing and developing Data Modelling and Analysis using Dimensional Data Modelling, Star Schema modeling, Fact and Dimensions tables and Physical and Logical data modeling in the OBI Administration tool. * Strong experience in developing OBIEE time series objects, Interactive Dashboards with drill-down capabilities (using global and local filters), dashboard prompts, Web Catalogue Objects (Dashboard, Pages, Folders, Reports). * Experience in managing users and setting up their OBIEE application access in External database table and configure user access by using session variable in RPD. * Expertise in Data Warehousing Concepts, OLAP technologies, Data Modelling and Cache monitor. * Experience in building metadata Repository file (.rpd) consisting of three layers (Physical Layer, Business Model & Mapping and Presentation Layer) * Highly Experienced in Training Resources in OBIEE, Discoverer and creating BI Delivery Kits, OBIEE Learning Material and user guides for OBIEE Workshops. * Adept at all phases of SDLC, which includes Design, Analysis, Coding, Testing, Code Reviews, Implementation and System Support. * Well versed with Agile Methodology, Extreme Programming, Microsoft Patterns and Practices.
Accomplishments
Highlights:
Keywords
