•Experience in Architecting and Developing Business Intelligence and Data warehousing solutions using Oracle Fusion Middleware, OBIA, OBIEE 11g, Informatica, DAC and Oracle database.
•Experience in leading and managing teams
•Experience in implementation & customization of OBI-Apps, Oracle Business Intelligence Applications using Oracle’s OOB- Out of the Box/ Pre built metadata solutions including Sales Analytics, Service •Analytics, Marketing Analytics, Financial Analytics, Supply Chain & Order Management Analytics, •Manufacturing, Inventory, and Procurement & Spend Analytics.
•Experience in Platform/Application version upgrade for DAC, Informatica, OBIEE & OBI Apps.
Knowledge in the Data warehousing concepts & implementation level experience of building Enterprise •Data Warehouse using Kimball’s methodology.
•Knowledge of SDLC (System Development Life Cycle) Process of Data Warehousing & OBIEE/Siebel •Analytics Projects including JAD/RAD/Agile/Waterfall techniques.
•Knowledge of various Data Modeling (ER, Dimensional) techniques & Tools (Erwin)
•Knowledge of Oracle Architecture, OLAP features (Merge, Multi table insert, External Table, SQL Loader, •Star Transformation, Materialized Views, Dimension Hierarchy, Cubes, Indexes, Partitioning etc.) and development methodologies including hands on experience on PL/SQL (created stored procedures, functions, triggers, packages, cursors etc.)
•Knowledge on Sales Process (Lead-Opportunity-Order-Cash), Service (Customer-Service Request-Field •Rep Assignment-Resolve), Marketing (Initiative-Program-Campaign-Offer-Budget-ROI), Order Management etc.
•Experience in OBIEE/OBIA Upgrade from 10g to 11g and BI Apps version upgrade.
•Experience of Oracle Weblogic Application-Server Administration.
•Experience in OBIEE 11g Administration using Weblogic Administration console and Oracle Enterprise Manager Fusion Middleware Control.
•Experience of Integrated security setup with multiple Ldap providers (Oracle Internet Directory OID, MS ADS etc.) aligned with fusion middleware architecture.
•Experience on Installation, Configuration, Integration and Administration of BI Publisher.
•Experience of Integrating BI Presentation Services with Java web applications using various integration techniques i.e. Go-URL, Post method and web services.
•Experience in BI/ETL performance tuning methods
•Experience on integrating Hyperion Essbase cubes with OBIEE.
•Experience in Oracle Geo Spatial Analysis and BI Maps integration.
•Knowledge on Oracle OLAP (Analytic Workspace Manager) integration with OBIEE