PROFESSIONAL SUMMARY

• Over 6 years of experience in IT Industry, experienced in designing, development and implementation of OBIEE 10.1.3.4x, 2 years experience in 11g.
• Experienced in OBIEE 11.1.1.7,Oracle BI Applications 7.9.6.x, Siebel Analytics 7.x which include building and configuring repository, creating and managing oracle/Siebel Intelligent Dashboards, oracle/Siebel Answers, oracle/Siebel Delivers and oracle/Siebel iBots ETL Informatica, Reporting-Siebel Analytics, Scheduling-DAC .
• Experienced in OBIEE solution architecting OBIEE 11g OBIEE10g and have a strong understanding on OBIEE 11g capabilities with Web logic 10.3.5 as an Application server.
• Experienced in gathering reporting and analysis requirements, documenting the report specifications, implementing the metadata layers including Physical, Business Model and Mapping, and Presentation layer. Experienced in working with Oracle Fusion Web Logic.
• Experienced in designing and developing Data Modelling and Analysis using Dimensional Data Modelling, Star Schema modelling, Fact and Dimensions tables and Physical and Logical data modelling in the OBI Administration tool.
• Highly skilled at configuring OBIEE Metadata Objects including repository, variables, interactive dashboards with Map viewer/Big Maps/Google Maps, reports and three tier OBIEE architecture.
• Experienced in Installing and Configuring OBIA Financial, HR, Sales, Supply Chain and Order Management, Marketing Analytics, etc.
• Experienced in writing, testing and implementation of Stored Procedures and Packages at database level using PL/SQL, Database designs Methodologies.
• Expert in configuring, designing, development, implementation and using Oracle pre-build RPD's Financial, HR, Sales, Supply Chain and Order Management, Marketing Analytics, etc. and ETL Mappings according to business requirements. Experienced in EBS Techno-Functional.
• Performed end to end technical analysis right from RPD layer and to source systems
• Provided technical solutions for business requirements to enhance the analytics capability
• Expert in building repositories using star schema, developing Subject Areas, and applying security group, access / query privileges at object and data level in Administration Tool. Hands on experience in customizing reports, filters and charts in Oracle BI Answers, Interactive Dashboards, BI Publisher and Delivers. Expert knowledge of report development execution in a complex environment.
• Comprehensive knowledge in general accounting principles, business functions of general ledger, treasury accounting, accounts payable, asset management, billing, and receivables. Experienced in financial reporting including treasury accounting reporting and cash flow statements.
• Experienced in OBIEE 11G, OBIA 7.9.6.4 and OBI Dashboards. Integration experience with Oracle EBS order management.
• Experienced in Simplifying Migration Process - Changing environment specific variables in RPD development, administration, analysis report.
• Created and scheduled iBots using delivers to send alerts, run reports, and deliver reports to the users. Experienced in supporting performance tuning and process tuning at all levels.
• Proficient in using the time-series functions to support historical time comparison analysis and creating requests, adding filters, creating prompts, and creating pivot tables using OBI.
• Experienced in configuring Usage Tracking and Multiuser Development Environment MUDE .
• Experienced in designing customized interactive dashboards in OBIEE using drill down, guided navigation, prompts, filters, and variables.
• Experienced in translating business requirements into a business dimensional model, key subject areas, dimensions, hierarchies, attributes and measures.
• Expert ability to troubleshoot and prioritize issues.
• Excellent interpersonal and communication skills for efficient client interaction.

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Confidential

OBIEE Consultant

Description:

The objective is to extract data stored in different databases and to load into the data warehouse, which is in Oracle enabling to build interactive reports.

Responsibilities:

• Actively involved with Business Users for gathering the Reports / Dashboards requirements and to define business and functional specifications
• Designed and developed the OBIEE Metadata Repository .rpd using OBIEE Analytics Admin tool by importing the required objects Dimensions and Facts with integrity constraints into Physical Layer using connection pool
• Interacted with Systems Engineering team to design - Facts Dimensions for Repository .rpd
• Prepared Detail Design Document for Repository .rpd
• Created measures in Administration tool for the requirements using expression builder and calculation wizard
• Developed multiple Dimensions Drill-Down, Hierarchies Logical Facts / Measures objects in Business Model Layer, and creating the Presentation catalogs in Presentation Layer
• Designed and developed Business Intelligence reports and dashboards using Oracle Enterprise Edition BI Answers and BI Interactive dashboards
• To design and implement database indexes and partitions to improve application and dashboard performance
• Extensively used dashboard prompts and formatted the reports, result and pivot sections according to the end user requirements
• Configured Financial and worked on the customizations of Financial Analytics to meet the reporting requirements of the client
• Worked extensively on security for users and groups based on the individual and group responsibilities
• Developed simple complex mappings using Informatica to load Dimension Fact tables as per STAR schema techniques
• Developed Informatica Mappings to load data from relational and flat file sources into the data warehouse
• Worked with Workflow manager and validated the workflow
• Scheduled and ran Extraction, Loading processes and monitored sessions using DAC Data Warehouse Application Console

Environment: OBIEE 11g/10g, Informatica 9.0.1/8.6.1, Oracle 11g/10g, DAC 10.1.3.4.1, SQL Developer

Confidential

OBIEE Consultant

Description:

The project was aimed at Purchasing and Supply chain implementation. The main objective was to build ODS, Datamart and Data warehouse for its Parts/Supplier chains around the nation. The purpose of project was to prepare reports for analysis of order entry through OBIEE Reporting system.

Responsibilities:

• Used simple to complex analytical SQL queries against the source databases to identify and analyze the authenticity of the data before importing to build the OBI repository

• Involved in laying out a strategy with senior management and technical team for building the metadata that presents the business model to support the business requirements
• Involved in creating POC's proof of concepts for the repositories and business functionalities with the architect team and business users
• To design and implement database indexes and partitions to improve application and dashboard performance.
• Identified the appropriate facts, metrics, hierarchies, and territories to structure the initial conceptual model of the business from the requirement documentation
• Created a repository using OBI Administration tool by importing tables into the physical layer and created the business and mapping model to incorporate the business logic
• Add calculated measures that involve operations on existing columns
• Created presentation catalog which allows exposing the business model to users in Oracle BI Answers so that users can build requests to analyze the data
• Created presentation folders and test with Answers
• Created Dashboard Pages, Created a New Interactive Dashboard Page by using answers from presentation catalog.
• Created Prompts to Filter Interactive Dashboard Data
• Perform unit testing and create test plans for reports built in Oracle Answers
• Identify causes of performance issues and helped to resolve the same.
• Worked on BI Publisher reports in generating the templates Word, PDF, and HTML as required.
• Prepared Detail Design Document of the complete implementation of Business modules

Environment: OBIEE 11g, Informatica 9.0.1, Oracle 11g, SQL Developer, SQL Server 2008

Confidential

OBIEE Consultant

Project Description:

Confidential was established in April 2002 with the mission to provide top quality TPA services to Health Insurance policyholders and be the most preferred Confidential . I was involved in Designing and developing database packages, procedures, functions and involved in various other modules.

Responsibilities:

• Gathered Business Requirements by interacting with IT and documented them unambiguously as System Requirements Specifications SRS combination of FR/NFR .
• Created High level Design Documents HLD according to the Business System Requirements FR/NFR
• Analyzed the HLD created by me and Source System to create the Application Design Documents.
• Worked as an Application Designer for Mapping Designing RPD and ETL development.
• Documented Application Design Mapping ETL Mapping, which helps Developers to implement ETL and RPD.
• Designed and Developed Custom Business Intelligence Solutions Metadata and Dashboards/Reports using OBIEE platform.
• Developed the OBIEE Metadata repository .rpd model with the necessary logic that involved creating the Physical, BMM layers with aggregates, dimensions time series functions, Presentation layer with catalogs folders and external table security using Siebel Server Admin tool. Also created hierarchies, variables, and event poll strategies in the repository.
• Developed Dashboards for each of Metrics by embedding Reports and providing intuitive drilldowns and links to exploit the full benefit of Analytics in providing summary and detail reports.
• Implemented Dynamic Navigation to allow the system to pass parameters from the summary dashboards to the details dashboards.
• Implemented Groups and Hierarchy Level Based security to dashboards based on Role.
• Configured and automated iBots to deliver daily and weekly reportsbased on schedule.
• Performance Tuning of Reports by implementing the aggregate navigation, Cache and Oracle Materialized Views.
• Worked on DAC, Pharma Analtics for creating Auto Execution and Scheduling Tasks.
• Involved in developing Informatica Mappings Mapplets during enhancements.

Environment:Oracle 9i, Oracle Enterprise Manager, Oracle Developer 6.0/6i, SQL Loader, SQL Plus, PL/SQL, Windows 2000, UNIX Sun Solaris , TOAD, PL/SQL Developer.