PROFESSIONAL EXPERIENCE:

Confidential

Role: Sr.OBIEE Developer

Roles and Responsibilities:

• Participated in User meetings, gathering requirements, discussing the issues to be resolved.
• Identify Source tables OLTP and Target tables OLAP for Data mapping.
• Involved in Creating and Administering the Physical Layer, Business Model Mapping Layer and Presentation Layer using Oracle Business Intelligence Admin tool.
• Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository.

• Imported Physical tables from Oracle database and defined relations between Physical tables at the Physical and Logical Layer
• Created Dimensional Hierarchy, Level based Measures in BMM layer.
• Managed security privileges for each subject area and dashboards according to user requirements.
• Developed custom reports/Ad-hoc queries using Oracle Answers and assigned them to application specific dashboards.
• Developed different types of Reports pivots, charts, tabular using global and local Filters.
• Managed Oracle Delivers, Scheduler iBots.
• Worked closely with business users in the client side and designed the system accordingly
• Involved in designing the dimensional model and suggested as per the reporting requirements.
• Unit testing the reports, debugging and fixing the errors for Right reports.
• End to End testing of Reports for data and functional behavior.
• Providing support and fixing issues related to Data on Reports, Dashboards etc.
• Co-ordinated offshore ETL and OBIEE team with onsite team.

Confidential

OBIEE 11.1.1.6, OBIA 7.9.6, Toad for Oracle, SQL Developer, MS Office

Confidential

SrOBIEE Consultant

Roles and Responsibilities:

• Involved in the detailed design of the data model and reports/dashboards.
• Migrating Repository and Web Catalog files from Development to Test and Production environment.
• Managed Security in Admin Tool like Data level and Object level.
• Gathered the requirement from business users, completed the proof of concept,Designed, Developed and Tested Physical Layer, Business Layer and Presentation Layer of OBIEE
• Created Dimensions in the Business Model and Mapping Layer.
• Developed different Reports, Filters and Dashboards.
• Involved in Unit Testing of Reports.
• Coordinated the Analytics RPD and Web Catalog objects migration from DEV environment to QA environment and to the Production environment
• Performed Unit, Integration testing to validate report and worked closely with the users and QA team to resolve the ongoing production Issues.
• Deployed OBIEE 11g RPD and Web Catalog by using Web logic Enterprise Manager.
• Implemented Object Level Security by creating roles web groups using web logic console.
• Co-ordinated offshore ETL and OBIEE team with onsite team.

Environment:

OBIEE 11.1.1.6, Informatica 9.0.1, DAC 11g, SQL Developer, Toad for Oracle, MS Office

Confidential

OBIEE, Business Intelligence Oracle BI Developer

Roles and Responsibilities:

• Created Users, Groups and giving the permissions in OBIEE Administration Tool and verifying the Permissions of the users in Presentation services.
• Defined the Dimensional Hierarchy and created the Dimensional Levels for each of the dimensions in the BMM layer for Drilldowns.
• Created the Foreign key and complex joins in the Physical layer for the new design being implemented.
• Customized the repository and created new requests using Answers.
• Created Session variable, Repository variable in RPD and used the same for role based security and Dynamic calculation in OBIEE answers.
• Built Time-Series calculations using AGO and TODATE functions on BMM Business mapping and modeling layer of repository.
• Developed several dashboards and reports which are used by managers to identify most profitable customers and analyze revenue trends by customer to identify opportunity/risk.
• Used Filters global and local and provided customized Prompts to avoid excessive data showing up in the reports.
• Created Global/Local Prompts, Narrative Views, Filters, Charts, Pivot Tables, Compound layouts to design the dashboards.
• Implemented Time Comparison and Calculation measures in the business model using Time series Functions.
• Created session variables for users to provide row- level data level security and used the session variable in OBIEE answers to build the query
• On each dashboard, created Narrative report to understand the Business.
• On dashboard specific column value filtered using prompt and Presentation variable.
• Worked with functional and technical leads, business groups to identify, analyze, and document business requirements

Environment:

OBIEE 10.3.4.1, Mainframes, Toad for Oracle, BI Publisher 10g, MS Office

Confidential

OBIEE, Business Intelligence Oracle BI Developer

Roles and Responsibilities:

• Modeled the Logical Layer based on the Business requirements in the Business Mapping and Modeling Layer and Developed the necessary Star Schemas.
• Extensively used Oracle BI Administration Tool for customizing and modifying the physical, business and presentation layers of the metadata repository.
• Identified the Facts and Dimensions based on the design specification.
• Created Presentation catalogs, and Folders in Presentation Layer, and Performed Global Consistency Check in Oracle BI Administration Tool.
• Extensively worked on Answers, Dashboards and Security for users. Worked on creating complex reports.
• Created various Static and Dynamic variables for different report and Security requirements.
• Creating new measures as well as modifying the existing measures at RPD levels.
• Imported the Physical Meta Data from Various Data marts into the Physical Layer by defining the connection pool settings.
• Defined the Primary, Foreign keys and created Simple and Complex joins between various Dimension and Fact Tables.
• Worked on Aggregates, Hierarchies, Calculation wizard in the Logical Layer.

• Creating and enhancing pivot, chart reports using BI Answers.

• Configuring ODBC connectivity for new instances and clients
• Worked on the Time Series Wizard and implemented time comparison measures

• Expertise in Object level security Web Catalog folder/group permissions and Data Level Security
• Guided Navigation, Dimension creations for drill downs
• Actively involved in the Design and development of the STAR schema data model.

Environment:

OBIEE 10.3.4.1, Siebel, Toad for Oracle, Oracle EBS, MS Office

Confidential

SQL Developer

Responsibilities:

• Responsible for writing and modification of PL/SQL stored procedure, functions and Database triggers
• Created new Tables, Indexes, Synonyms and Sequences needed as per new requirements
• Created materialized views, Inline Views normal views where business requirements needed
• Tune the SQL queries and complex procedures to improve performance
• Created database triggers for data security Consistency
• Performance tuning of Oracle Databases and User applications
• Used Timestamp and Time zone functions Loading Database
• Extensively Used JOINS writing views in the Database
• Configuring ODBC connectivity for new instances and clients
• Wrote PL/SQL backed stored procedures for database access and tuned them efficiently
• Worked in Production Support Environment testing for projects, work orders, maintenance
• Interacted with Business Analysts and Users in requirement gathering Built complex queries
• Using SQL and wrote stored procedures using PL/SQL
• Introduction of OBIEE to end Users and Provided Documentation with Advantages and Disadvantages to it
• Created Basic reports, Pivot Tables and Dashboards Using OBIEE.
• Design and developed Metadata repository .rpd that consists of physical layer, business model / layers with aggregates dimensions, presentation layers with catalogs folders

Environment: Oracle 10g, TOAD, SQL, OBIEE 10.1.3.4.1, MS Office Suite, Windows 2003.