PROFESSIONAL SUMMARY:

• Over 7+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 BusinessIntelligenceimplementations and have an understanding of all aspects of an implementation project usingOBIEE 11g.
• Experience on OBIEE Admin related tasks like Installation, configuration and Migrations.
• Experienced in gathering reporting and analysis requirements, documenting the report specifications, implementing the metadata layers includingPhysical, Business Model and Mapping, and Presentation layer.
• Expertise in design and development of the three layers (Physical/Business Model and Mapping/ Presentation)ofOBIEE Metadata Repository(.rpd)using Oracle BIAdministrationTool.
• Highly experienced withrepositorydevelopment, configuredmetadataobjects (Subject Area, Table and Column) andWeb Catalogobjects (Dashboards, Pages, Folders, Reports).
• Experience in implementing object level security at repository level as well as presentation level of WebCatalog objects.
• Good experience in Migrating Web Catalog and RPD objects from development environment to higher environments.
• 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
• Involved in unit testing and validating the repository.
• Hands on experience in Installation and Configuration of OracleBI Apps 7.9.6.4
• 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.
• 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 designingBusiness Objects universes, complex BO reports bothfull client andWeb Intelligence Reports, Web Intelligence and Crystal Reports to develop and publish thin client reports.
• Extensive Knowledge onBusiness Objects Architecture & Administration.CreatedUsers and Groups and setting the rights on them using Central Management Console (CMC). Scheduled Crystal Reports in CMCon 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:

Confidential, Long beach, CA

Sr OBIEE-ADMIN

Responsibilities:

• Involved in Admin related tasks like installations, migrations and up gradations of all components of OBIEE 11g.
• Proficiency in admin tasks like deployments from different environments (Dev to Prod) and taking backups of RPD and Webcatalog.
• Installed and Configured OBIEE, DAC and Informatica on Unix/Windows Environment.
• Involved in implementing OBIEE upgrade from 10g to (11g RPD& WebCatalog) and customizations in OBIEE 11g.
• Worked on configuring different repository and webcatalog configuration files.
• Involved in configuring WebLogic server and security parameters using WebLogic console server.
• Experience in giving access to different users like power users, admin users and creating groups.
• Added users and configured security in web logic console of OBIEE 11g.
• Managed security privileges for each subject area and dashboards according to user requirements
• Setup Multi User Development Environment (MUDE) in OBIEE.
• Worked on applying OBIEE patches to support different Internet Explorer browser versions (IE 10, 11).
• Proficiency in deployments of RPD and Catalog from different environments.
• Involved on custom ETL migrations in Informatica, ETL objects (mappings, sessions, and workflows) from Dev to QA.
• Involved on configuring Oracle BI config files in Linux environment.
• Worked on troubleshooting managed servers in application servers of different environments.
• Configured OBIEE 11g Clustering and Scale out BI Instances.
• Configure the Scheduler to deliver the reports to the Business using Ibots.
• Installed BI Apps 7.9.6.4 in windows environment including DAC 11g and Informatica installation
• Based on user security matrix created different application roles.
• Worked with Mapping Designer, Repository Manager, Workflow Manager and Workflow Monitor.
• 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.

Environment: OBIEE 11.1.1.7.0, BI Apps 7.9.6.4, Oracle 10g/11g, Oracle EBS, Informatica Power Centre 9.0, Oracle BI Publisher, Linux Red Hat 6, EXCEL, TOAD.

Confidential, San Jose, CA

Sr. OBIEE-Consultant

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 ofapplication and effectiveness of the proposed solutions. Analyse the Business Processes, process flow and Key Performance Attributes.
• Experience in developingPhysical Layer, Business Model & Mapping and Presentation Layerusing 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
• DesignedSchema/Diagramsusing Fact, Dimensions, and Physical, Alias and Logical tables.
• Created Drill down Hierarchies and implemented Business Logics forFacts.
• 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 likecalculation measures,time series measures,initialization blocks, session and repository variables, fact tables, dimension tables, dimensionhierarchies 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 andData Conversionusing informatica Power Centre 8.1.
• Involved in developing the incremental ETL process i.e. Mappings and Mapplets using various Transformations andWorkflowswith 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 . Durham, NC

OBIEE (OBIA) Developerz

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 inOracle 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

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

Responsibilities:

• Gathered user requirements and created the business requirements documents.
• Maintain, updateand monitor the existing database on daily basis.
• Plan, design, and implementapplicationdatabase 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 queriesfor 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.
• Managedperformance 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.