● Over 7 years of expertise in all phases of Software Development Life Cycle (SDLC) and having com...
● Over 7 years of expertise in all phases of Software Development Life Cycle (SDLC) and having comprehensive background in End-to-End implementation of Business Intelligence using Oracle Business Intelligence (OBIEE)/BI Publisher. ● Expertise in OLTP/OLAP System Study, Analysis and developing Database Schemas like Star schema, Snowflake schema and Dimensional modeling. ● Installed and configured different versions of OBIEE. ● Strong experience in developing OBIEE Repository (.rpd) – three layers (Physical Layer, Business Model & Presentation Layer). ● Designed and developed the OBIEE Metadata Repository (.rpd) using OBIEE Server Admin tool by importing the required objects (Dimensions, Facts & Aggregates) with Referential Integrity constraints into Physical Layer using connection pool, developing multiple dimensions (Drill-down Hierarchies), Logical & Facts Measure objects in Business Model Layer, and creating Presentation Catalog/Subject Areas in Presentation Layer. ● Hands on experience in customizing analysis, filters and charts in OBIEE Analytics. ● Understand the standard of best practices in BI architectural design. ● Built Reports and Dashboards for Business Users, and Set up Usage Tracking. ● Developed many Reports / Dashboards with different Analytics Views (Drill-down / Dynamics, Pivot table, Chart, Column Selector, View Selector, Narrative, Ticker, static Text, Tabular with local and global filters) using OBIEE Analytics. ● Experience in Configuring Interactive Dashboards with Security Setup (groups, data access/query privileges), Metadata objects and Web Catalog objects (Dashboard, Pages, Folders, Reports). ● Implemented Dynamic Dashboard Prompts using Presentation variables to achieve performance optimization and easy navigation of reports. ● Install, Configure and integrate BI Publisher with OBIEE RPD/Presentation layer. ● Proficient with BI Publisher reports using various templates to publish the reports as per user requirements and in bursting and scheduling BI Publisher Reports. ● Experienced in using OBI/Siebel Delivers which includes configuring Delivery Devices, creating and configuring iBots, and building Alerts. ● Strong expertise in Implementing MUD (Multi User Development) Environment. ● Very good in Debugging, Optimizing and Performance Tuning of Oracle BI Dashboards/Reports by designing Query Caching and Data Caching for Performance Gains. ● Involved in the Upgradation of OBIEE 10g to 11g across all business verticals. ● Experience in using Data warehouse Administration Console (DAC) to schedule, run full and Incremental ETL loads, to schedule the Informatica jobs, and to customize Execution Plans. ● Experienced in SQL, PL/SQL, Stored Procedures, Functions, Packages, DB Triggers, and Indexes. ● Experience in customizing out-of-box reports(Financial, Procurement and Spend, Supply chain, Sales and Marketing Modules) Technical Skills ETL Tools Informatica BI Tools OBIEE 10.1.3.1,10.1.3.4.1,10.1.3.4.2, 18.104.22.168, 22.214.171.124.7 Databases SQL Server , Oracle 10g/9i Data Modeling Toad, SQL Developer Operating System Windows NT/2000/95/98/XP, Windows 2003 server
* Click the button to send an offerSend offer