SUMMARY

• 7 years of experience on OBIEE 11g & OBIEE 10.1.3.x,in designing Dashboards, Answers, Administration Tool, and Analytics RPD.
• Experience in the Siebel Analytics/OBIEE RPD metadata i.e.
• Customized Siebel Analytics Repository, defined Physical Data Layer, developed Business Model and Presentation Layer using Siebel Analytics Administration Tool
• Data modeling experience using Dimensional Data modeling, Star/Snow flake schema, Fact and Dimension tables, Physical and logical data modeling.
• Experience using Informatica Power Center 9.1/8.6
• Extensive Experience on Workflow Manager Tools - Task Developer, Workflow & Worklet Designer
• Good hands on experience in using BI Publisher to create reports from BI Answers, BI server.
• Strong working experience in using OBI/Siebel Delivers which includes configuring Delivery Devices, creating and configuring iBots, and building Alerts.
• Experienced in using pl/sql, sql developer tools like TOAD, pl/sql developer
• Extensively used different transformations like Source Qualifier, Expression, Aggregator, Filter, Sorter, Update Strategy, Lookup, Joiner and Sequence Generator.
• Expertise in Data Warehousing, Data Analysis, Reporting, ETL, ODI, Data Modeling, Development, Maintenance, Testing and Documentation.
• Worked extensively on Dimensional modeling, Data cleansing and ETL Processes (also developed ETL processes for a OBIEE project using ODI)
• Experience in Oracle 10g- design and developing Stored Procedures/Packages, Database Triggers, Cursors using SQL, PL/SQL.
• Good knowledge of SQL*Loader for extraction of Data from legacy databases.
• Good Knowledge in Performance Tuning of Dashboards and on database side.
• Excellent communication, leadership, organizational, analytical and problem solving skills.

TECHNICAL SKILLS

Databases: Oracle 11g/10g/9i/8i, MS SQL Server 7.0,Sybase

ETL Tools: Informatica Power Center 9.1/8.6

Data Modeling: Star-Schema, and Snowflake Modeling, ERwin, MS Visio

Languages: PL/SQL, HTML

Tools: OBIEE 10.1.3.x,11.1.1.x,Toad 9.6.1.1,SQL Developer, SQL*Plus, SQL*Loader

Operating Systems: Windows XP / Vista/ 7, Linux, UNIX

PROFESSIONAL EXPERIENCE

Confidential, Providence, RI

Sr. OBIEE Developer (OBIEE 11g)

Responsibilities:

• Worked closely with the business users to identify various KPI's and designed solutions to enhance business decision-making.
• Worked on Oracle BI EE Administration tool for customizing the Physical layer, Business layer, Presentation layer and modifying it according to the business requirements.
• Worked on Informatica- Source Analyzer, Warehouse Designer, Mapping Designer & Mapplet, and Transformation Developer.
• Applying most of the transformations such as the Source Qualifier, Expression, Aggregator, Filter, Connected and Unconnected Lookups, Joiner, update strategy and stored procedure.
• Worked with the physical layer to create Connection pools and imported physical tables and defined joins.
• Developed and customized some of the existing multiple Dimensions (Drill-Down Hierarchies) & Logical objects in Business Model Layer, and creating the Presentation catalogs in Presentation Layer.
• Created Global/Local Prompts, Narrative Views, Filters, Charts, Pivot Tables, Compound layouts to design the dashboards.
• Created Security settings in Oracle Administration Tool to set up groups, access privileges and query privileges and also manages security for groups in BI Answers.
• 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.
• Dashboard development with version 11.1.1.x.
• Worked in creating Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Participated in complete life cycle of the project from project initiation, to development, to production support and maintenance.
• Designed Star schema for fact & dimensional tables and created alias for the dimensional tables when necessary
• Enhance performance of Reports/Dashboards by implementing the Aggregate tables, Table execution path by making use of hints, Creation/Re-building of Indices and Cache Management.
• Created comprehensive and easy-to-understand Documentation of the complete implementation of the Customer Sales Business modules (Reports, Dashboards, Security and Star schema).
• Build test cases and tested the Reports / Dashboards by comparing the SQL Output on the Data warehouse to the values in the Reports/Dashboards, documented the test results.

Environment: Oracle 11g, OBIEE, Informatica 9.1, SQL, Toad, Cygwin, UNIX Shell Scripting

Confidential, Boston, MA

Oracle Business Intelligence Consultant

Responsibilities:

• Participated in user meetings to understand the requirements.
• Written Shell script to change the format of a column in all the reports of a particular subject area in the web catalog.
• Developed 3 layers of repository Physical layer, BMM layer and Presentation layer in Oracle BI Admin tool.
• Worked on Informatica- Source Analyzer, Warehouse Designer, Mapping Designer & Mapplet, and Transformation Developer.
• Applying most of the transformations such as the Source Qualifier, Expression, Aggregator, Filter, Connected and Unconnected Lookups, Joiner, update strategy and stored procedure.
• Extensively used time series functions AGO and TODATE
• Extensively used repository variables and session variables and initialization blocks.
• Implemented LDAP security.
• Created tables and views in the database.
• Data loading using Toad.
• Worked on Answers, Dashboards and Delivers.
• Configured web catalog objects.
• Implemented Security by creating roles & web groups, checks with External tables and LDAP.
• Performance Tuning of Dashboards/Reports and made recommendations for changes to database by implementing the materialized views, partitions, re-building of indexes, overwriting the SQL.
• Implementation of different views of report i.e. Pivot table, Titles, Graph, Filters etc.
• Developed many Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Cascading Style Sheets, Pivot Table, Chart, View/Column Selector, Tabular with global and local Filters) using Presentation Services/Siebel Analytics Web.
• Created dashboard prompts and column prompts to filter the selection criteria.
• Developed Dashboards,reports using different views (pivot table, charts, graphs, table, view selector, column selector).
• Configured permissions to restrict the access of users to the dashboards.
• Performed unit testing of reports.

Environment: Oracle 10g, OBIEE 10.1.3.4, Informatica 8.6.1, SQL, Toad, Cygwin, UNIX Shell Scripting

Confidential, Dallas, TX

Sr. Oracle Business Intelligence Consultant

Responsibilities:

• Responsible for full life cycle implementation of OBIEE
• Participated in user meetings to understand the requirements
• Developed Metadata repository (.rpd) that consists of Physical, BMM and Presentation layer using Oracle BI administration tool.
• Created Alias Tables, Views and Dimensional Hierarchies.
• Developed Calculated Measures and assigned these Aggregation levels based on Dimension Hierarchies.
• Implemented external table security with session variables, tested and validated the business model and repository level calculations using Oracle BI Administration tool.
• Extensively used Repository Variables, Session Variables and Initialization Blocks for Configuring the Data and User Security.
• Worked extensively on Answers, Delivers, and Interactive Dashboards for Procurement and Spend Analytics.
• Developed customized reports with different views, filters, variables, prompts and selectors.
• Implemented dynamic dashboards prompts to zoom into particular segments of the business in a performance-optimized manner.
• Created Complex Mappings using Lookup, Sorter, Aggregator, and Router transformations for populating Target Table in Efficient manner.
• Created Mapplet and used them in different Mappings.
• Used Filters (Global and Local) and provided customized prompts to avoid excessive data showing up in the reports.
• Created Time Series measures Year ago, Month Ago, Year-to-date measures using AGO and To Date functions.
• Developed Dashboards / Reports using different Views (Table, Pivot Table, Chart and Column Selector), with guided navigation and dashboard and page prompts.

Environment: Oracle 10g, SAP BW, OBIEE 10.1.3.4, Oracle BI Apps(Supply chain Analytics), BI Publisher, ODI 10.1.3.5, SQL Developer, UNIX

Confidential, San Fransico, CA

OBIEE Consultant

Responsibilities:

• Participated in User Meetings to understand the requirements.
• Worked closely with the data modeler in creating logical data model (Star Schema).
• Built the OBIEE repository/metadata (Physical Layer, Business Model and Mapping Layer and Presentation Layer) and created the subject area where reporting and analysis are centered around.
• Developed calculated measures and dimension hierarchies in the Business Model and Mapping Layer
• Configured web catalog objects (Dashboards, Pages, Folders, Reports)
• Implemented data level and object level security.
• Created Complex Mappings using Lookup, Sorter, Aggregator, and Router transformations for populating Target Table in Efficient manner.
• Performance Tuning using optimization efforts such as re-organizing the data, aggregate navigation, Cache Management, indexes, Oracle materialized views and reports changes
• Worked on OBIEE Answers to build Interactive Dashboards with drill-down capabilities based on organization’s and product’s hierarchies
• Extensively used time series functions AGO and TODATE
• Extensively used repository variables and session variables and initialization blocks.
• Implemented different views of report i.e. Pivot table, Titles, Graph, Filters etc.
• Created dashboard prompts and column prompts to filter the selection criteria.
• Also participated in developing ETL design using Informatica, used Transformations like Aggregator, Joiner, Update, Filter, Lookup, Sorter.

Environment: Oracle 10g, Informatica 8.1.1, OBIEE 10.1.3.2, BI Publisher,Toad, SQL,SQL*Loader, PL/SQL Procedures, Windows 2000.

Confidential

Database Developer

Responsibilities:

• Wrote several stored procedures/triggers in Oracle (PL/SQL) for the enterprise portal application and data merge.
• Involved in daily, weekly and monthly load of data from mainframe data set to Oracle database.
• Worked on very large database environment in terabytes and tuned queries for performance.
• Created and maintained parallel queries for very large datasets.
• Creating temporary tables and indexes for loading and updating data.
• Worked on queuing for sending XML data to the calling java APIs.
• Developed customized reports with different views, filters, variables, prompts and selectors.
• Implemented dynamic dashboards prompts to zoom into particular segments of the business in a performance-optimized manner.
• Imported/exported several databases through various environments
• Developed and maintained lot of batch scripts for the production, like scheduled data loading, Create, databases, Tuning and backup and Recovery.

Environment: Oracle8i, SQL, PL/SQL, XML, SQL*Loader