• 8 years of data warehouse experience and over 6 years of experience as Oracle Business Intelligence and Applications Consultant with successful track record in gathering user requirements, designing, developing and supporting different Business Applications. • Experienced in customizing Intelligence Dashboards/Score cards with drill-down capabilities using global and local Filters Analytics Security Setup (groups, access / query privileges), Metadata Objects and Web Catalog Objects (Dashboards, Pages, Folders and Reports). • Over 4 years of experience as an BI Publisher 10g/11g / XML Publisher 5.6.3/5.6.2 (E- Business Suite) Report developer in developing Custom Reports. • Expert level Knowledge in Developing OBIEE Reports using 10G/11g. • Well versed with using SQL and PL/SQL for BI Publisher and XML Publisher. • Expertise in Oracle BI Publisher, Oracle BI Answers, BI Interactive Dashboards and Oracle BI Server. • Experience in data warehousing such as dimensional modeling, star and snowflake schemas, data marts, fact and dimension tables identification, and OLAP. • Experience in providing end-to-end business intelligence solution by dimensional modeling design, developing and configuring OBIEE Repository (RPD), Interactive Dashboards, OBIEE Answers, security implementation, Analytics Metadata objects, Web Catalog Objects (Dashboard, Pages, Folders, Reports). • Good knowledge of XML language and XPATH/XSLT coding. • Expertise in RTF templates design using advanced XPATH/XSLT functions for BIP reports. • Knowledge of Tableau visualization tool. • Able to understand customer’s data and propose business relevant data visualizations • Experience in supporting the production system and handling day-to-day issues. • Experience in training business users on OBIEE Answers and Dashboards and educating technical super users and administrators on repository and web catalog migrations procedures with Oracle best practices. • Ability to learn and adapt to new technologies, good team player in dynamic work group environments and also self-motivated to work independently with excellent communication skills. • Migrated Repository and Web Catalog from one environment to another environment. • Devised strategy for refreshing reports Query caching. Optimized database indexes and run statistics process for enhancing query performance. • Very proficient in SQL tuning and optimization of queries • Hands-on experience in modifying ODI Knowledge Modules like, LKM, IKM and JKM, CKM to work according to the requirement. Skills: BI Tools Oracle Business Intelligence Enterprise Edition (OBIEE) 11.1.1.x/ 10.1.3.x , ,BIApps 7.9.6.x/7.9.5.x , BI Publisher and Smart view ERP Oracle EBS ETL Tools ODI ,Informatica 9.1/9.5/8.x/7.x RDBMS Oracle 11g/ 10g/9i/8i/7.x,Netezza Utilities SQL Developer,Aginity Netezza Workbench, TOAD, SQL*PLUS Scripting Languages Unix Shell scripts, K shell, C shell. Languages SQL, PL/SQL, XML,NZ SQL,XQUERY,XSLT,XPATH. Operating System Sun Solaris, Unix, Linux, Windows NT/XP/2000/98.