Summary

• Developed many Reports / Dashboards with different Analytics Views Drill-down / Dynamics, Pivot table, Chart, Column Selector, View Selector, Narrative, Ticker, static Text, Tabular with local and global filters using OBIEE Analytics.
• Built Reports and Dashboards for Business Users, and Set up Usage Tracking.
• Understand the standard of best practices in BI architectural design.
• Hands on experience in customizing analysis, filters and charts in OBIEE Analytics.
• Designed and developed the OBIEE Metadata Repository .rpd using OBIEE Server Admin tool by importing the required objects Dimensions, Facts Aggregates with Referential Integrity constraints into Physical Layer using connection pool, developing multiple dimensions Drill-down Hierarchies , Logical Facts Measure objects in Business Model Layer, and creating Presentation Catalog/Subject Areas in Presentation Layer.
• Installed and configured different versions of OBIEE.
• Expertise in OLTP/OLAP System Study, Analysis and developing Database Schemas like Star schema,Snowflake schema and Dimensional modeling.
• Over 7 years of expertise in all phases of Software Development Life Cycle SDLC and having comprehensive background in End-to-End implementation of Business Intelligence using Oracle Business Intelligence OBIEE /BI Publisher.
• Experience in Configuring Interactive Dashboards with Security Setup groups, data access/query privileges , Metadata objects and Web Catalog objects Dashboard, Pages, Folders, Reports .
• Implemented Dynamic Dashboard Prompts using Presentation variables to achieve performance optimization and easy navigation of reports.
• Install, Configure and integrate BI Publisher with OBIEE RPD/Presentation layer.
• Proficient with BI Publisher reports using various templates to publish the reports as per user requirements and in bursting and scheduling BI Publisher Reports.
• Experienced in usingOBI/Siebel Delivers which includes configuring Delivery Devices, creating and configuring iBots, and building Alerts.
• Strong expertise in Implementing MUD Multi User Development Environment.
• Very good in Debugging, Optimizing and Performance Tuning of Oracle BI Dashboards/Reports by designing Query Caching and Data Caching for Performance Gains.
• Involved in the Upgradation of OBIEE 10g to 11g across all business verticals.
• Experienced in SQL, PL/SQL, Stored Procedures, Functions, Packages, DB Triggers, and Indexes.
• Experience in customizing out-of-box reports Financial, Procurement and Spend, Supply chain, Sales and Marketing Modules

Technical Skills

ProfessionalExperience

Confidential

Sr. OBIEE Developer

• Worked closely with the business users and developers to make sure that Business Requirements are correctly translated into database schemas and ultimately into the application.
• Responsible for supporting and enhancements of OBIEE.
• Installed and configured complete suite of OBIEE 11.x in test and development environments.
• Mapped different data sources to the Physical Layer and created the Business Model and Mapping Layer design of hierarchies, dimensions, and aggregates .
• Created connection pools, imported physical tables and defined joins in the physical layer of the repository.
• Analysis of existing OLTP system and Identification of required dimensions and facts from the Database.
• Created materialized views and aggregates in the BMM layer to improve performance.
• Implemented security by creating users groups, setting up External Table Authentication, creating Session Variables and Initialization Blocks and associated catalog objects and Web modules with the created groups.
• Used Essbase Cubes to develop RPD in order to build custom OBIEE dashboards.
• Created and customized various Reports and Dashboards for various user groups using complex SQLFilters.
• Designed various reports as per the requirements for user interface design like Drill Down, Pivot, Chart, Break down Reports, Union reports, Narrative and Nested reports in Answers.
• Created Dashboards with local/global Dashboard prompts and Master Detail linking.
• Implemented write back functionality.
• Used Oracle Delivers for sending real-time, personalized alerts via intelligence agents iBots to intelligence dashboards for subscribed users.
• Applied Optimization techniques of the reports such as caching and building summary tables.
• Performed Validation of data in the reports and dashboards using SQL Tuning to improve performance.
• Unit, integration and system testing for all components in OBIEE. Test cases have been prepared and documented the results.
• Documented the designs for intuitive understanding and future reference.
• Trained End Users to Build Ad Hoc Reports using OBIEE.

Environment: OBIEE 11.1.1.7.0, Oracle 11g, BI Publisher, TOAD, DAC 10.1.3.4, Sql plus, PL/SQL.

Confidential

Sr. OBIEE Developer

• Gathered user requirements, reporting requirements and prepared the requirement specifications document.
• Designed and developed OBIEE repository at 3 layers i.e., Physical layer connecting to Data sources and import schema , Business Model Mapping Layer create Logical tables and data source mapping and Presentation Layer level create presentation catalogs .
• Customized prebuilt Repository according to the Business requirements with necessary logic that involved creating the physical, BMM and the presentation layer. Also created hierarchies, variables, and poll strategies in the repository.
• Implemented DYNAMIC column naming.
• Implemented security at the data and object levels as per the business user requirement.
• Administered various OBIEE environments with large number of users and provided optimum system uptime and performance. Designed security matrix, configured Authentication and Authorization architecture, and provided permissions to users according to their role.
• Created dimensional hierarchies and multiple dimensional hierarchies and various set levels in the Business Model Layer and Mapping Layer of Repository implementing drill down, Aggregation and Sum over columns.
• Used appropriate filters, column filters, prompts, dashboard prompts and calculations in reports.
• Developed Reports and Dashboards in different Analytical Views ticker, narrative, column selector, view selector, legend, funnel Pivot Table, Chart to visualize data in different perspectives using OBIEE Answers.
• Used Variable Manager in OBIEE Administration tool to define various Repository Session variables.
• Designed and developed BI- Publisher Reports Layouts using BI-Publisher Desktop using sample Xml data source Answers request as data source and Deployed on to the BIP server.
• Performance Tuning of dashboards/Reports and made recommendations for changes to database by implementing the materialized views and aggregate tables.
• Implemented dynamic dashboard prompts to zoom into particular segments of the business in a performance optimized manner.
• Created presentation layer catalog folders, to show different views of the business model to different users and assigned group permissions to the catalog folders.
• Used column formatting functions in Oracle BI Answers.
• Responsible and assisted in migrating the web catalog and RPD from different environments.

Environment: OBIEE 11.1.1.6, OBIEE Publisher, Oracle 10g/11g, Windows 2003, Linux, TOAD.

Confidential

Sr. OBIEE Developer

• Associated with in the Analysis, functional and technical specifications, development, deployment and testing of the project.
• Implemented Security by creating users, groups throughexternal table authentication.
• Gathered business needs by Interacting with the business users for analytical data requirements.
• Build prototype reports from excel spreadsheet during the requirement phase to visualize the reports and clarify requirements.
• Requirement validation of the reports and drilldowns.
• Designed repository based on business requirements, followed design best practices for the RPD and Dashboard designs.
• Performed full Loads with the help of DAC and Monitoring the Same.
• Involved in designing the ETL loads, developed and implemented ETL process for executive management reporting.
• Worked on the design of logical data model.
• Created connection pools, imported physical tables and defined joins in the physical layer of the repository.
• Created dimension hierarchies, aggregates, and keys in the BMM layer.
• Concerned on repository and session variables.
• Created materialized views and aggregates to improve performance.
• Customized Claims, Holdings and Service requests star schemas.
• Generated Reports and Dashboards by using Report features like Pivot tables,chartsand view selector.
• Fabricated proactive agents iBots and interactive Dashboards to alert the financial team about business changes.
• Scheduled the reports in Oracle BI Publisher Enterprise.
• Performed Performance Tuning of Dashboards / Reports by aggregate navigation, cache management, Oracle materialized views and making changes to reports.
• Communicated project status and escalated issues as needed.
• Participated in complete life cycle of the project from project initiation, to development, to production support and maintenance.

Environment: OBIEE 10.1.3.4, Oracle BI Publisher, Oracle 10g, DAC 10.1.3.4 , TOAD, Sql Plus, PL/SQL.

Confidential

OBIEE Developer

• Worked closely with Business Analysts in understanding the Analytics requirements and created Business Models for generating Reports as per the requirements.
• Created and Administered the Physical Layer, Business Model and Mapping Layer and Presentation Layer in Analytics Repository .rpd using Oracle BI Administration Tool.
• Developed many Reports/Dashboards with different Analytics Views Drill-Down Drill-Across, Pivot Table, Chart, View Selector, and Column Selector, with global local Filters using Oracle BI Analytics Web.
• Developed Accounting and Collection Time Series Object Oracle BI Time-Series Functions for comparing the Billings, Collections and Adjustments.
• Created Users, Groups and giving the permissions in Siebel Analytics Administration Tool and verifying the Permissions of the users in Siebel Analytics web.
• Worked on OBI Delivers and Configured iBots to deliver Analytics content based on a schedule.
• Created Filters and provided customized prompts appropriately to avoid excessive data.
• Worked extensively on Oracle BI Publisher and provided the capability to download the reports in the user defined formats.
• Customized the look and feel Skins Styles for OBIEE products Answers Login Page, Banners, CSS files, etc. as per company specific standards.

Environment: OBIEE 10.1.3.4, Oracle 10g, SQL.

Confidential

OBIEE Developer

• Developed OBIEE Repository per user requirements and available information in DW.
• Extensively used OBIEE Admin tool to import the required objects Dimensions and Facts with integrity constraints into Physical Layer using connection pool
• Developed multiple Dimensions Drill-Down Hierarchies and Logical and Facts / Measures objects in Business Model Layer, and has successfully created the Presentation catalogs in Presentation Layer.
• Developed Dashboards such as Default Dashboard for the users when after login directed to a default dashboard based on the department they work.
• Successfully developed row based calculations in a pivot table for the reports based on sales RPD.
• Created session variables for users to provide row-level data level security and used the session variables in OBIEE answers to build the query.
• Had developed chart and tabular reports for the total sales for Quarterly, half-yearly and annually using global and local filters.
• Scheduled iBots and seeded server cache using Delivers to improve system performance.
• Developed and debugged Dashboards/ reports visibility with respect to user's responsibility and web groups in an integrated environment.
• Coordinated the Analytics RPD and Web Catalog objects migration from Dev environment to QA environment and to the Production environment.
• Conducted meetings with Project Managers, Business Users and Business Analysts during testing and deployment stage of the application development lifecycle.

Environment: OBIEE 10.1.3.4, Windows XP, Oracle 10g/11g.

Confidential

Siebel Analytics Developer

• Imported Physical Tables and defined relations in Physical Layer in Siebel Analytics.
• Created Business Facts Dimensions and defined Logical relation between them in BMM layer.
• Created Drill down Hierarchies and implemented Business Logics for Facts.
• Analyzed and validated the business model in Siebel Administration Tool by performing consistency check, validating logical source tables, logical columns, and also validating repository level calculations done in the business model layer.
• Created Reports using different Analytics Views Pivot Table, Chart, Column Selector, Table
• Created Pivot Tables and manipulated Init Blocks for report analysis
• Created mappings using PL/SQL packages to implement business rules while loading data.
• Performed performance tuning by optimizing Target, Source, Mapping and Session.

Environment

Siebel Analytics 7.X, Oracle 8i, Informatica Power Center 6.2, MS-Access, Windows 2000.

Confidential

• Studied and analyze the business requirements.
• Generated SQL and PL/SQL scripts to install create and drop database objects including: tables, views, primary keys, indexes, constraints, packages, sequence, grants and synonyms.
• Wrote Stored Procedures to encapsulate Business processes
• Wrote procedures, Database Triggers, functions and package using PL/SQL,
• Formatted the reports with different fonts dynamically using SRW Package.
• Optimized the SQL queries for improved performance.
• Used SQL loader to import data from large flat files and Excel sheets to Oracle tables.
• Prepared test plans for various modules.
• Design and implementation of Reports.
• Added the triggers in form level, block level and Item level.
• Prepared user manual and technical support manuals.

Environment

Oracle 8i, SQL Loader, PL/SQL, Windows 2000.