Hands on experience with Data warehouse Application Console (DAC) in customizing, designing, executing and monitoring ETL Processes.Hands on experience in Data warehousing development using ETL tools such as Informatica Power Center 9.x/8.x/7.x and developed Informatica Mappings and Workflows with Worklets & Tasks using various Transformations for ETL of data from Multiple Sources to Data Warehouse.Experience in extracting data from Siebel, Oracle EBS, PeopleSoft, OLTP, flat files and integration and loading data to OLAP systems.Expertise in writing, testing and implementing of stored procedures and packages using PL/SQL.Developed KPI, KPI Watch list and Oracle Score Cards which enabled end users to measure the progress of a strategy.Proficient with BI Publisher reports and using various templates to publish the reports as per user requirements.Extensive knowledge in Debugging, Optimizing and Performance Tuning of Oracle BI/Siebel Analytics Dashboards/Reports by implementing Aggregate navigation, cache management and materialized views.Experienced in Data Modeling using Dimensional Data Modeling, Star Schema modeling, Fact and Dimensions tables and Physical, Logical data modeling in the OBI Administration tool.
Experience in implementing security in OBI using Repository Variables, Initialization Blocks, and Session Variables.Implemented Security by creating roles & web groups, checks with External tables & LDAP.Experience in creating requests, adding filters, creating prompts, and creating pivot tables using OBIEE.Worked extensively on OBIEE Administration Tool, OBIEE Answers, OBIEE Intelligent Dashboards, BI Publisher, Delivers and iBots.