Pavan Kasetty

• Extensive Business Intelligence experience using Oracle Business Intelligence.
• Have a strong understanding of Data Warehouse concepts - ETL, OLAP, Star Schema, data modeling.
• Expertise in developing Oracle BI Repository (.rpd) at three layers (Physical, Business Model & Presentation Layer), Time Series Objects, Interactive Dashboards with drill-down capabilities, Security Setup both data level and object level (groups, access / query privileges), LDAP, External Tables, configuring Analytics Metadata objects (Subject Area, Table, Column), Web Catalog Objects (Dashboard, Pages, Folders, Reports) and scheduling iBots.
• Expertise in implementing Writeback functionality of OBIEE on the dashboards which provides the ability for the users to insert/update data from the dashboard.
• Involved in creating an IBOT subscription model which will enable users to subscribe / unsubscribe to the available ibots.
• Implemented the ETL processes using OWB 10gR2 to load data from sources schema into the staging / target schema.
• Developed mappings using OWB for data loading. Created Process flow, scheduled & monitored session.
• Good database experience using Oracle 9i/10g, SQL, PL/SQL*Loader, Stored Procedures, DBMS Packages, TOAD, Ref Cursors, Constraints, Triggers, Indexes, Views, Inline Views, Materialized Views, Database Links.