• Around Eight years of experience in Business Intelligence and Transactional applications, Design...
• Around Eight years of experience in Business Intelligence and Transactional applications, Design and Implementation of Data Warehouse/Data Mart, Gathering Business User Requirements, System Analysis, Design and Data Modeling. • Experience in Business Intelligence and Transactional applications, Design and implementation of Data Warehouse/Data Mart, Gathering Business User Requirements, System Analysis, Design and Data Modeling. • Expertise in complete lifecycle Implementation of Business Intelligence with Star and Snow flake Schemas using Ralph Kimball and Bill Inmon Methodologies. • Very strong experience in developing OBIEE Repository (.rpd) at three layers (Physical Layer, Business Model & Presentation Layer), Time Series Objects, Interactive Dashboards with drill-down capabilities using global & local Filters, Security Setup (groups, access / query/report privileges), configured Analytics Metadata objects (Subject Area, Table, Column), Web Catalog Objects (Dashboard, Pages, Folders, Reports) and scheduling iBots. • Hands on experience in Authentication and Authorization of OBIEE by using LDAP, Database authentication, External Authentication and also implemented Single Sign on (SSO). • Expertise in implementing Security Models for Dashboards, Row level, objects Level, Role Level, and Dashboard Level. • Experience in creating Aggregate tables or materialized views using Aggregate Persistence wizard. • Expert in converting Functional specs to Technical Specs and implementing OBIEE Best practices. • Expertise in configuring Interactive Dashboards with drill-drown capabilities using global and local filters, Security setup (groups, access/query privileges), metadata objects and web catalog objects (Dashboard, Pages, Folders, Reports). • Expertise in implementing Oracle BI Apps in all phases like implementing Out of order Box prebuilt mappings, Designing ETL, metadata management using DAC, Creating Oracle provided Data Warehouse ,OBIEE RPD development, OBIEE reports and Dashboards. • Expertise in Data Warehouse Administration Console (DAC) to configure, monitor and schedule ETL. • Experienced in Installation, Configuration, Upgrade, Migration and Administration of OBIEE, Oracle BI Apps, Informatica Power Center. • Strong experience in developing and customizing Reports using OBIEE 10.1.3.4.1/10.1.3.4.0/10.1.3.3/10.1.3.2, Oracle Reports 6i/4.5/2.5 Discoverer 10g/4i/3i, XML Publisher 5.6.3/5.6.2. • Worked on Supply chain – Oracle ACPP Sales and Operations planning and supply chain analysis dashboard pages • Extensively Worked on Informatica Mappings using corresponding Source, Targets and Transformations like Source Qualifier, Sequence Generator, Filter, Router, Joiner, Lookup, Expression, Update Strategy, and Aggregator. • Extensively worked on several FDDs (Functional Design Documents and TDDs (Technical Design Documents) according to the application of the project Databases/RDBMS: Oracle 11g/10g/9i, MS Access, SQL Server 7.x, 2000, Teradata V2 R6 ETL Tools: Informatica Power Center 9.1, 9.0.1, 8.1.1, 7.1, DAC 11g/10.1.3.4.1/7.8.5v, ODI Oracle Applications: Oracle Financials E-Business suite R12/11i (Order Management, Inventory, Purchasing, General Ledger, Accounts Receivables, Accounts Payables, Fixed Assets, Cash Management, AOL, System Administrator). PeopleSoft 9.1/9.0(Financials, HR) Developer Tools: OBIEE 11g/10g, DAC 11g/10g, Oracle Reports 10g/6i/4i, Oracle BI Apps 11g/7.9.x, Oracle Forms 10g/6i/4i, Discoverer 10g/6i/4i, BI Publisher 10g/11g, Oracle ACPP, Oracle Endeca, TOAD 9.7.3/8.x, SQL*PLUS, Data Loader, SQL*Loader, SQL Developer. Languages & Tools: SQL, PL/SQL, C, C++, C#, HTML, XML, Teradata SQL, Toad Operating Systems: Windows NT/XP/2000/98, UNIX, IBM/AIX 5.30, Red Hat Enterprise Linux
* Click the button to send an offerSend offer