Over 6 years of progressive experience in the IT industry with prime focus on analysis, modeling, design, development, implementation, testing, documentation, and maintenance of various Business Analytics in an effective way to deliver leading edge software solutions. Involved in all phases of Design, Development, Implementation and system integration/User Acceptance Testing of business intelligence applications. Proficient in developing OBIEE Repository (.rpd) at three layers (Physical Layer, Business Model and Mapping Layer & Presentation Layer), configuring metadata. Proficient in using Answers, Delivers, Dashboards/ Reports with drill-down & drill-across capabilities using global & local Filters, Security Setup (Groups and Access Privileges), Web Catalog Objects and scheduling iBots. Areas of expertise include business analysis, dimensional modeling and implementing business intelligence analytics solutions using Oracle BIEE 11g and also in using the ETL tool ODI 11g. Experience in implementing and providing solution for HR, Financial, Sales, Manufacturing business intelligence module. Worked on 2 complete life cycles for development on ODI 11g and 4 life cycles on OBIEE 11g. Hands on experience on working with BI-Publisher in OBIEE 11g. Expert in configuring the delivers and scheduling the reports using the OBIEE Delivers. Experience in multiple user development (MUD) environment. Strong knowledge in using Oracle Data Integrator 11g to perform the ETL. Expertise with all ODI tools – Topology, Security Manager, Designer and Operator. Creating variables, sequences, user functions, scenarios, procedures, interfaces and packages in ODI. Extensively experience in development of E-LT and ETL Mapping in Oracle Data Integrator (ODI). ETL jobs creation & customization using Oracle Data Integrator (ODI). Experience in using Oracle Data Integrator Designer (ODI) to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database. Analyzed the Business requirement for Oracle Data Integrator and mapped the architecture and used ODI for reverse engineering to retrieve metadata from data storage and load it to the repository. Worked on slowly changing dimensions (SCD), Change data capture (CDC) as part of data warehousing concepts. Specialized in developing stored procedures, functions, packages and database triggers using Oracle SQL and PL/SQL to improve query performance. Experienced in using TOAD and SQL Developer. Experienced in configuring the security settings in OBIEE Administration Tool to set up Groups, Access Privileges and Query Privileges using LDAP and external database authentication. Experienced in Installation, configuration, upgrade, migration and administration of OBIEE and ODI. Extensively worked on databases like Oracle, SQL, and PL/SQL to write stored procedures, functions, package and triggers. Excellent communication skills along with analytical, problem solving skills and ability to follow through with projects from inception to completion. Reporting Tools OBIEE 11g/10.1.3.4 (Oracle BI Administration, Oracle BI Presentation, Oracle BI Answers, Oracle BI Dashboards, Oracle BI Delivers, Oracle BI Publisher, Catalog Manager), Scheduler (iBots), OBIW, Crystal reports ETL ODI 11g Databases Oracle 11g/10g, SQL Server 2005/ 2008, MS Access 2000 ERP EBS R12/11.5.10.2, Seibel CRM Query Tools TOAD, SQL*PLUS, SQL Developer and SQL Loader Testing tool Test Cases(Unit, System, Performance, Regression, User Acceptance) Others/ Languages SQL, PL/SQL, XML, C#, JavaScript, Java, Web logic, static HTML Operating System Unix, Linux, Windows 7/Vista/XP/2003/2000