About 11+ years of experience in Software Engineering and Information Technology involving Requirement analysis, design, development and implementation of Data warehouse, Business Intelligence applications, RDBMS and Client Server applications, under various Architectures/Modules/Environments. Ability to interact effectively with clients, Understanding their requirements and providing optimum solution and production support. Extensive experience on OBIEE / Siebel Analytics Administration Tool, Presentation Services / (OBIEE / Siebel) Analytics Web Answers, OBIEE / Siebel Interactive Dashboards, OBIEE Delivers / IBOTS, Cache Management, OBIEE / Siebel Scheduler Configuration. Proficient in building three layers (Physical Layer, Business Model & Mapping and Presentation Layer) of OBIEE / Siebel Analytics Repository using Siebel Analytics. Expertise in translating high-level business requirements into logical business dimensional model. Expertise in handling all phases of Quality Assurance Life Cycle and Software Development Life Cycle(SDLC) of the BI Projects. Hands on experience in defining key metrics, dimensions, hierarchies and attributes, Aggregate Navigation, Aggregates based on dimension, Level Based Measures, Variables, Initialization blocks, Cache Management. Experience in configuring Interactive Dashboards with drill-down capabilities using global and local Filters, OBIEE / Siebel Security Setup (groups, access/query privileges), Metadata Objects and Web Catalog Objects (Dashboard, Pages, Folders, Reports). Expertise in complete life cycle of Design, Development, Maintenance and Documentation of various functionalities of Data Warehouses including Testing and Code Migration. Experienced in Configuring and publishing the iBots to deliver analytics content based on schedule, automated iBots queries to obtain daily & weekly transactions to all the departments in the organization by Emails Experience in working with various modules of Oracle Apps such as AP, AR, OM, GL and Install Base service contracts. Proficient in building analytical repository, business models, generating reports, and creating dynamic Dashboards using OBIEE. Experienced in Installation and configuration of Siebel Analytics Applications (HR, Sales, Financial), Data warehouse Application Console (DAC) and Informatica (ETL) Applications. Experience in using custom internal ETL tools for several clients. Experienced in migrating the Web catalog developments by using the Catalog manager and Repository developments to Production from the Test environment. Hands on data warehousing experience using Informatica powermart, Informatica Power center(Source Analyzer, Data Warehousing Designer, Mapping Designer – data transformation and mapping issues, Mapplet, Transformations). Extensive exposure in using Informatica Designer, Repository Manager, Workflow Manager and Workflow Monitor. Experienced in working on SQL based modifications for ETL. Hands on experience with performance tuning of mappings and sessions Hands on experience in requirements gathering through close interactions with the business analysts and managers to understand their needs and documenting the report requirements. Widely experienced in debugging queries using TOAD Hands on experience in Oracle 9i/8i, SQL Server 2000, design and developing Stored Procedures/Packages, Database Triggers, Cursors using SQL, PL/SQL Operating System experience with Windows NT/95/2000/XP, UNIX, Sun Solaris Excellent communication and presentation skills. TECHNICAL SKILLS: BI Tools: OBIEE 11G/10.1.3, Siebel Analytics 7.8/7.7/7.5, Hyperion ESSBASE 9.3.1, Oracle Financial Analyzer 11i (6.4)/6.3.1/6.3.2/6.3.3, Tableau 9 / 8 / 7 / 6 ERP Packages: Oracle Applications/Oracle E-Business Suite: R11i, R11, R10.7, R10.6 ( AP,AR,GL,OM ,Install Base Service contracts) ETL Tools: Informatica Power Center 8.1.1/7.1.1/6.2/5.1.2, ODI, Pentaho, Custom ETL Databases: Oracle 10g/9i/8i, MS SQL Server 2005/2000, Teradata, DB2, MS Access Languages: C, C++, C#, Java, J2EE, VB, SQL, PL/SQL Operating Systems: Windows XP/00/NT, Linux Red Hat, UNIX AIX, Solaris Packages: SQL *PLUS, Query Analyzer, PeopleSoft, ERWIN, SAS, Oracle EBS, CRM Web Technologies: HTML, DHTML, CSS, XML, Oracle SOA Applications: MS Word, MS Excel, Outlook, FrontPage, Data Modeling, PowerPoint Utilities: Toad 9.0/8.5.1, SQL *Loader, Putty, APEX, SQL Navigator 4.4, BI Publisher. GUI: Forms6i, Reports6i, OBIEE, Discoverer, XML/BI Publisher, Business Objects(BO)