SUMMARY:

• Over8+yearsof experience in IT Industry including implementation of Siebel Analytics/Oracle Business Intelligence, ETL Tools, DAC and RDMS OBIEE Projects.
• Expertise in full life cycle Business Intelligence implementations and have an understanding of all aspects of an implementation project using OBIEE .
• Experienced in gathering reporting and analysis requirements, documenting the report specifications, implementing the metadata layers including Physical, Business Model and Mapping, and Presentation layer.
• Expertise in design and development of the three layers (Physical/Business Model and Mapping/ Presentation)of OBIEE Metadata Repository (.rpd) using Oracle BI Administration Tool.
• Highly experienced with repository development, configured metadata objects (Subject Area, Table and Column) and Web Catalog objects (Dashboards, Pages, Folders, Reports).
• Highly skilled at configuring OBIEE Metadata Objects including repository, variables, interactive dashboards, and reports .
• Experience in implementing object level security at repository level as well as presentation level of WebCatalog objects.
• Developed different analytical reports like Table, Chart, Pivot, column selector and Narrative views and publish them in dash board using answers.
• Proficiency in creating BI Publisher reports
• Good Knowledge on OLTP, OLAP, Dimension Models like Star schema & snowflake schema, Galaxy schema, OBIEE Architecture and Data ware housing concepts.
• Have experience on Oracle Managed Cloud Services(OMCS).
• Experience on OBIEE Admin related tasks like Installation, configuration and Migrations.
• Hands on experience in Installation and Configuration of OracleBI Apps 7.9.6.
• Involved in unit testing and validating the repository.
• Having good exposure in Oracle9i/10g/11g
• Experience in Performance Tuning Analytics Dashboards / Reports and Data Warehouse database.
• Knowledge in extracting data from Siebel CRM, Oracle EBS, PeopleSoft, OLTP, flat files and integration and loading data to OLAP systems.
• Having good Knowledge on BIApps Financial Analytics & Procurement & Spend Analytics.
• Having extensive working knowledge on oracle ApplicationsR2 (App, AR).
• Knowledge and work experience in RDBMS concepts, Views, Triggers, Stored Procedures, Indexes, and Constraints.
• Good in Oracle PL/SQL (Packages, Procedures, Functions, Triggers, DML, DDL etc.).
• Having Good Knowledge in Creating transformations (Expression, Aggregator, Lookup, Router, Rank, Update Strategy, and Filter) and developing Mappings using Informatica.
• Knowledge in designing Business Objects universes, complex BO reports both full client and Web Intelligence Reports, Web Intelligence and Crystal Reports to develop and publish thin client reports.
• Extensive Knowledge on Business Objects Architecture & Administration. Created Users and Groups and setting the rights on them using Central Management Console (CMC). Scheduled Crystal Reports in CMC on Daily, Monthly, Weekly basis

TECHNICAL SKILLS:

OLAP Tools: Oracle Business Intelligence Enterprise Edition 11.1.1.7.0 , Oracle BI Apps 7.9.6.4

ETL Tool: INFORMATICA 9.0, DAC 11g

Languages: SQL/PL SQL

Data Base: Oracle 9i/10g/11g, Oracle EBS, SQL Server

Operating Systems: Windows XP, 2000 Professional, Linux, UNIX

Office Tools: Ms - Word, Ms-Power Point, Ms-Excel

ERPs: Siebel CRM, Oracle APPS (AP, AR, GL& PO)

PROFESSIONAL EXPERIENCE:

OBIEE & Informatica consultant

Confidential - HRA Hopkins, MN

Responsibilities:

• Developing the dashboards and reports for the users based on the requirement.
• Designed and developed reports and dashboards on Patient Metrics, Readmissions, HC Physician scorecard, Health care insurance, DR Scorecard, Patient satisfaction reports, HR Analysis, Average wait time KPI.
• Created RTF's and Reports for the new releases of Helpdesk and MTM data.
• Developed BI Publisher reports for upper management to view their associate profiles for decision making purpose, and bursting reports using it.
• Configuring the client tools of DAC, Informatica, OBIEE on the remote machine.
• Check out RPD based on the requirement and import new tables and accommodate with BMM layer and Presentation layer for the reporting purpose.
• Modified RPD to add new tables and join to the existing schema.
• Created Dashboards and Reports for the new releases of Helpdesk and MTM data.
• Modified existing Informatica Mappings for the changes based on the requirements.
• Modified the complete payroll related mapping to add new grade to the data.
• Developed Sessions and workflows for Full load and Incremental load for Helpdesk and MTM data.
• Involved in modifying the existing data model and changing as per business needs.
• Created new subject areas in DAC for the MTM load.
• Created new execution plan in DAC for the MTM data load.
• Performance tuning in DAC to findout the unused indexes and dropping them.
• Parallel hints option is used in DAC for the long running tasks to reduce the run time.
• Interacting with the client for the new enhancements.
• Used Tivoli tool to make the changes to the job streams over daily and weekend.
• Monitoring the jobs in DAC .
• Clearing the issues in the support queue in HPSM tool.

Environment: OBIEE 10.1.3.4.1/ OBIEE 11.1.1.5(Repository RPD 11.1.1.5), Oracle 10g/11g,, Oracle EBS, Informatica Power Centre 8.6, Oracle BI Publisher, Windows Server 2007, PL/SQL Developer, EXCEL, TOAD.

Confidential, San Jose, CA.

Sr. OBIEE-Consultant

Roles and Responsibilities:

• Involved in requirements gathering (Reports/Dashboards/Delivers), analysis, design, used various data sources, development and implementation of the project.
• Involved in project planning, architecture, analysis, design and implementation.
• Requirement study from Functional Leads, interacting with Process Owners and development of flows of application and effectiveness of the proposed solutions. Analyse the Business Processes, process flow and Key Performance Attributes.
• Experience in developing Physical Layer, Business Model & Mapping and Presentation Layer using Oracle BI Administration Tool (RPD) .
• Importing physical tables and columns in to physical layer and establishing relationship between them.
• Customized the logical table source in the business model and mapping layer based on the business requirement.
• Worked on Dimensional Hierarchies (Drill down& Drill up), Level Based & Share Measures and Time series functions based on Business Requirements.
• Involved in Organizing Presentation layer in a format that is easy for end users to use as basis for reporting
• Designed Schema/Diagrams using Fact, Dimensions, and Physical, Alias and Logical tables.
• Created Drill down Hierarchies and implemented Business Logics for Facts .
• Implemented Aggregate tables for better performance.
• Created Oracle BI Publisher reports based on Oracle BI Answers request and designed using Microsoft Word.
• Utilized various building blocks like calculation measures, time series measures, initialization blocks, session and repository variables, fact tables, dimension tables, dimension hierarchies using RPD Admin tool.
• Developed report with filters, presentation variables, prompts, column selector, view selector, charts, narrative, gauge views, pivot table and other views.
• Adding new additional data fields in existing reports and publishing reports in dashboards.
• Analysed reporting requirements for dashboard reports and adhoc reports.
• Developed Reports, Dashboards with different Analytics Views (Drill-Down / Dynamic Pivot Table Chart, View Selector).Reduced the number of reports using Column Selectors and View Selectors.
• Unit testing the reports and testing navigation links in reports.
• Involved in Admin related tasks like installations, migrations and up gradations of all components of OBIEE.
• Proficiency in admin tasks like deployments from different environments (Dev to Prod).
• Created and distributed ibots to subscribed users.
• Involved in implementing OBIEE upgrade from 10g to (11g RPD& Catalog) and customizations in 11g.
• Proficiency in in extracting data from Siebel CRM, Oracle EBS, PeopleSoft, OLTP, flat files and integration and loading data to OLAP systems
• Involvement with ETL (Extract-Transform-Load) development team to communicate the Specification for the required dimensional, aggregate and indexed data tables. Responsible for create the ETL for Data Extraction, Data Mapping and Data Conversion using informatica Power Centre 8.1.
• Involved in developing the incremental ETL process i.e. Mappings and Mapplets using various Transformations and Workflows with Sessions/Tasks.

Environment: OBIEE 10.1.3.4.1/ OBIEE 11.1.1.5(Repository RPD 11.1.1.5), Oracle 10g/11g,, Oracle EBS, Informatica Power Centre 8.6, Oracle BI Publisher, Windows Server 2007, PL/SQL Developer, EXCEL, TOAD.

Confidential

OBIEE (OBIA) Developer

Roles and Responsibilities:

• Involved in requirements gathering (Reports/Dashboards/Delivers), analysis, design, used various data sources, development and implementation of the project.
• Has design logical data model based on the source system tables.
• Worked with Oracle BI Apps, Oracle BI Server, Presentation Server, Oracle BI Administration
• Worked on Dimensional Hierarchies (Drill down& Drill up), Level Based & Share Measures and Time series functions based on Business Requirements.
• Configured Physical & BMM layer-import tables, Identifying facts, dimensions, created physical tables, join the tables, creating the logical tables and logical columns.
• Worked on Repository Variables and Session Variables.
• Implemented Security by creating users, roles, groups, data level security, object level security.
• Involved in managing appropriate security privileges on subject areas and dashboards according to business requirements.
• Implemented Aggregate tables for better performance.
• Created Alias Tables and Opaque views for easy reporting and better performance.
• Enhance performance by managing Cache management in OBIEE.
• Worked on Answers, Dashboards, Delivers and BI Publisher.
• Developed report with filters, presentation variables, prompts, column selector, view selector, charts, narrative, gauge views, pivot table and other views.
• Created Dashboards prompts, pages, links, images, embedded content, text folders and guided navigation links.
• Created pivot tables in many dashboards for providing the ability to rotate rows, columns, and section headings to obtain different perspective of the same data.
• Has integrated different reports in to dashboards and has set access permissions accordingly based on user needs.
• Configure pre-packaged reports/dashboards for Financial Analytics and Procurement and Spend Analytics.
• Has configured the job manager for working with OBI Delivers, created iBots and scheduled them to display alerts as well as to send the reports to the inbox of users.
• Created different reports like Standard, Dynamic and Ad-hoc reports
• Perform unit testing and validating the repository.
• Involved Data Warehouse Administration Console (DAC), for loading and monitoring of the Oracle Business Analytics Warehouse.
• Used DAC to schedule and run the full incremental ETL loads and to schedule the informatica jobs in Oracle Business Analytic Warehouse.

Environment: OBIEE 10.1.3.4.1/ OBIEE 11.1.1.5(RPD), Oracle BI Apps 7.9.6, Oracle 11g, Siebel CRM, Oracle BI Publisher, Oracle Delivers, Windows XP, TOAD, DAC.

Confidential, Dallas, TX .

OBIEE-Consultant

Roles and Responsibilities:

• Understanding the requirements of the client, business scenario(s) and the application and prepare the design documents.
• Designing the logics to be implemented at the RPD level.
• Using OBIEE Administration tool to develop and enhance Meta data to build Business Model and established relationships.
• Involved in Organizing Presentation layer in a format that is easy for end users to use as basis for reporting.
• Implementation of different views of report i.e. Pivot table, Titles, Graph, Filters etc.
• Extensively used variables (repository and presentation) in the process of making the reports
• Implementation data and Object level security.
• Generated OBIEE reports using OBIEE answers, dashboards, filters and Prompts.
• Created guided navigation links to help files within the dashboards to help the end users.
• Performed Pre and post implementation testing of Dashboard, Answers and validating Repository.
• Configure the Scheduler to deliver the reports to the Business using Ibots.
• Creating the Dashboard and Page level prompts.
• Displayed BI Publisher reports in BI Answers.
• Enhanced existing Business Models & created customized Dashboards.
• Fine-tuned the long running reports by re-organizing the data, re-building of indexes
• Build Informatica SDE mapping using JDE Enterprise One as a source and build SIL mappings to load data from staging table to target table.

Environment: OBIEE 10.1.3.4, Oracle 10g, Windows 2003,Informatica Power Centre 8.6, SQL Query Analyser, BI publisher, TOAD.

Confidential

OBIEE/ETL Developer

Responsibilities:

• Worked with functional and technical project leads, marketing, sales, finance, and other business groups to identify, analyze, and document business
• Enhanced existing business models & created customized dashboards using Webcatalog for various reports.
• Performed the detailed design of reports and dashboards using OBIEE Answers and Webcatalog.
• Developed custom reports using OBIEE Answers and assigned them to application specific dashboards.
• Included guided navigational links and drilldowns for maintaining the effectiveness in creation of dashboards.
• Developed different kinds of reports, with different views such as narrative view, pivot table, chart, view/column selector and tabular view using global and local filters.
• Setup the visibility of dashboards to employees with respect to their responsibilities.
• Managed security privileges for each subject area and dashboards according to user requirements.
• Administered Nqsconfig.ini and Instanceconfig.xml configuration files.
• Design and present the various scenarios for implementing organization and position based data security in OBIEE.
• Implemented Prompts to provide dynamic filter condition to end users.
• Unit Testing of Analytics reports, along with data validations using queries for the correctness of data.
• Worked on various Informatica mappings as per business requirement.
• Worked with Mapping Designer, Repository Manager, Workflow Manager and Workflow Monitor.

Environment: OBIEE 10.1.3.2, Informatica Power Center 6.0, Oracle 9i/10g, SQL,SQL *Plus, PL/SQL, TOAD, Windows 2000.

Confidential

Siebel Analytics/SQL Developer

Roles and Responsibilities:

• Gathered user requirements and created the business requirements documents.
• Maintain, update and monitor the existing database on daily basis.
• Plan, design, and implement application database code objects, such as stored procedures and views.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Using SQL to query Databases Performing various validations and mapping activities.
• Loaded the data using the SQL loader, Imports & UTL files based on file formats.
• Involved in loading the data from MS Excel to Oracle Table and Oracle table to MS Excel.
• Generated SQL and PL/SQL scripts to install create and drop database objects including: tables, views, primary keys, indexes, constraints, sequences, grants and synonyms.
• Designed and developed specific databases for collection, tracking and reporting of data.
• Performed the detailed design of reports and dashboards using Siebel Answers and Web catalog.
• Developed custom reports using Siebel Answers and published them to application for specificdashboards.
• Involved extensively in Siebel Answers, Siebel Delivers and Siebel Intelligent Dashboards withSiebel Analytics Integrated implementation.
• Involved in writing complex SQL queries for validating the data against different kinds of reports and involved in back-end testing and worked with data quality issues.
• Worked on optimization of SQL queries for database performance .
• Managed performance and tuning of SQL queries and fixed the slow running queries in production with utilities like Explain, Trace, and Stored Outlines.
• Produce SQL needed indexes for data analysis purposes.
• Involved in development, documentation, testing phases of the project.

Environment: Siebel Analytics 7.7,Oracle 8i,SQL,SQL*PLUS,PL/SQL, Toad, Windows NT, UNIX.