Having 7 years of total IT Experience in the Business Requirements Analysis, Application Design, Development and Implementations of Data Warehousing and web Based Applications.

EXPERIENCE SUMMARY:

• Proficiency in OBIEE 10.1.x/OBIEE 11.1.x which includes Oracle BI Server, Oracle BI Dashboards, Oracle BI Analytics, Oracle BI Delivers, Catalog Manager, Oracle BI Publisher.
• Experience with OBIEE Installation and configuring components (BI Analytics, BI Publisher).
• Involved in SDLC phases like Requirement gathering, Designing, Development and Testing.
• Excellent skills in design and development of the three layers (Physical, Business Model & Mapping and Presentation) of an OBI Metadata Repository (RPD) using Oracle BI Administration Tool.
• Expertise in business model development with Dimensions, Skipped and Ragged-level Hierarchies, Measures, Aggregation Rules and Time Series.
• Experienced in implementing Row Level Security and Object level security in OBIEE.
• Extensive experience in setup and working in a Multi-user Development environment (MUDE).
• Good knowledge on Data Warehousing concepts like Star Schema, Snowflake Schema.
• Experienced in Code Migration from development stage to testing stage and production stage.
• Experience in creating out of the box, attractive, user specific and customized OBI Answers, Reports, and Interactive Dashboards using different views available.
• Experienced in configuring iBots/Agents using OBIEE Delivers to deliver Analytics and weekly/daily reports.
• Experienced in testing OBIEE Answers, Dashboards, Reports, KPIs and Scorecards.
• Strong experience in Oracle database and fluent in SQL, PL/SQL (Store Procedures and Functions).
• Excellent Communication and Documentation skills, ability to learn and adopt new ideas and technologies, Self-motivated and result-oriented.

TECHNICAL SKILLS:

Reporting Tools : OBIEE 11g/10g (Administration Tool, Catalog Manager, Answers,

Dashboards), XML/OBI Publisher 11.1.x/10.x

ETL Tools : Data warehouse Administration Console (DAC), Informatica Power Center 9.x,

8.1x.7.x (Designer, Manager, Workflow Manager/ Monitor)

Database System : Oracle 11g/10g

Tools : MS office, SQL developer, TOAD

Operating Systems : MS Windows 7/Vista/XP/2000/98/95, Unix/Linux (Shell Scripts).

Languages : C, .NET, SQL

Web Technologies : HTML, HTML 5, XML, CSS, Java Script

PROFESSIONAL EXPERIENCE:

OBIEE Developer/ Admin

Confidential , Boston, MA

• Involved in analysis, requirements gathering, function/technical specifications, development, deploying and testing.
• Involved in communicating with client to understand/clarify requirements and suggest enhancements.
• Designed Star schema for fact & dimensional tables from the current OLTP and created alias for the dimensional tables when necessary.
• Developed Physical Layer, Business Model & Mapping and Presentation Layer using Oracle Business Intelligence Administration Tool.
• Specified dimensional hierarchy, aggregate levels for the dimensions.
• Set up a Multi-User Development Environment (MUDE) for the convenience of the company’s on-shore and off-shore teams.
• Developed different dimensional level Analysis, Filters and Prompts using Oracle Business Intelligence Answers.
• Designed and configured Intelligent Dashboards in Analytics using KPIs and Scorecards for different groups of users which include business users from various parts of the world.
• Developed customized and attractive Analysis/ Dashboards/ Reports with different Analytics Views (Pivot Table, Chart, Tabular, Ticker, Column Selector and View Selector), Alerts, Guided Navigation, and Dynamic / Interactive Dashboards with drill-down capabilities using global and local Filters.
• Created Time Series Measures, Hierarchies, Level Based Measures, Session and Repository Variables, Initialization Blocks.
• Created Agents to alert the business users.
• Use Upgrade Assistant to upgrade metadata and schemas from 10g (RPD, Web Catalog, BI Publisher Repository, and BI Publisher Schema).
• Manually migrated the Custom Style/ Skin/ XML Messages/ Java scripts. Did the changes to instanceconfig.xml, NQSConfig.INI
• Implemented object level security for different web groups based on responsibilities.
• Improved the performance of the Reports by moving huge calculations to the Database and by using the Aggregate tables and Cache management.
• Installed and configured Informatica PowerCenter 9.0 to be used as ETL engine to load data into the Data Warehouse.
• Checked data consistency using SQL and PL/SQL queries in SQL Developer.

Environment: OBIEE 10g/11g, Informatica 9.0, Oracle 11g, SQL Developer, PL/SQL

OBIEE Developer

Confidential Boston, MA

Responsibilities:

• Involved in Analysis, Study and Design of the Application.
• Identified Facts and Dimensions (with levels & hierarchy) and developed OBIEE Repository at 3 layers i.e., Physical Layer, Business Model / data mapping (created Logical tables & data source mapping) and Presentation Layer level (created presentation catalogs), created presentation folders, tested and validated the model.
• Configured and administered existing subject areas and created new subject areas to include new Star Schema information.
• Extensively used repository variables, session variables and presentation variables.
• Specified aggregate levels for each source and created dimension sources for each level of aggregates.
• Developed many OBI Answers using different Analytics Views (Pivot Table, Chart, and Column Selector), Dynamic / Interactive Dashboards with drill-down capabilities, charts, tabular using global and local Filters.
• Extensively used OBIEE Delivers and iBots to deliver reports (layout templates in RTF) to mobile users.
• Used Filters and provided customized prompts appropriately to avoid excessive data showing up in BI answers.
• Developed many complex Informatica mappings and reusable mapplets to build key interfaces using transformations and reusable transformation units ( Update Strategy, Filter, Router, Expression, Lookup, Aggregator) for loading data into Data Warehouse.
• Used Workflow Manager for creating, validating, testing and running the sequential and concurrent sessions and scheduled them to run at specified time with required frequency.
• Used Workflow Monitor to monitor the performance of the Jobs.
• Explore prebuilt ETL metadata, including Informatica workflows and mappings, and DAC metadata.
• Use the Data Warehouse Administration Console (DAC) to configure, manage, and load the Oracle Business Analytics Warehouse.
• Loaded consolidated data using SQL *Loader in parallel and direct mode.
• Developed detailed test plans, implemented all related test cases and created a detailed documentation of the above test process.

Environment: OBIEE 10.1.3.4, Informatica PowerCenter 8.1, DAC, Oracle 9i, SQL Developer, SQL*Loader, Windows XP.

OBIEE Developer

Confidential

Chennai, India

Responsibilities:

• Developed the OBIEE repository definition (physical layer, BMM layer and presentation layer) file using OBIEE Admin tool.
• Designed dashboard pages like Overview, Payments Due, Payment Performance, and Supplier and Customer report in using OBIEE UI.
• Developed detailed test plans, implemented all related test cases and created a detailed documentation of the above test process.
• Involved in implementing the authentication and authorization security model in OBIEE 10g.
• Created Level based measures and dimension hierarchies in the BMM layer of OBIEE .rpd file.
• Involved in testing the OBIEE reports / dashboards and security set up on these analysis.
• Identified Facts and Dimensions (with levels & hierarchy) and developed OBIEE Repository at 3 layers i.e., Physical Layer, Business Model / data mapping (created Logical tables & data source mapping) and Presentation Layer level (created presentation catalogs), created presentation folders, tested and validated the model.
• Extensively used repository variables, session variables and presentation variables.
• Specified aggregate levels for each source and created dimension sources for each level of aggregates.
• Developed many OBI Answers using different Analytics Views (Pivot Table, Chart, and Column Selector), Dynamic / Interactive Dashboards with drill-down capabilities, charts, tabular using global and local Filters.
• Used Workflow Manager for creating, validating, testing and running the sequential and concurrent sessions and scheduled them to run at specified time with required frequency.
• Used Workflow Monitor to monitor the performance of the Jobs.
• Explore prebuilt ETL metadata, including Informatica workflows and mappings, and DAC metadata.
• Loaded consolidated data using SQL *Loader in parallel and direct mode.

Environment: OBIEE 10.1.3.4, Informatica PowerCenter 8.1, DAC, Oracle 9i, SQL Developer, SQL*Loader, Windows XP.

OBIEE Developer

Confidential

Chennai, India

Description:

The consumer goods Confidential consists of the group of companies that manufacture and sell consumer goods products as well as the account customers to whom they sell. These products may include food PREMIUM, MINTS, Medicines, GUM and etc. Account customers in this industry include retailers and wholesalers who sell to each other and to consumers. For day-to-day business operations, consumer goods companies use general business processes that fall across industries such as sales, marketing, and order management. They also use business processes that are specific to the industry such as trade promotions, trade planning, and trade budgeting.

Responsibilities:

• Actively involved with business team to gather user requirements.
• Installed and configured OBIEE Admin tool and web components including Intelligence Dashboards, answers, and requests.
• Used admin tool to creation of repositories by using physical layer, business model and mapping layer and presentation layers.
• Worked on BMM layer to customize the tables, hierarchies, dimensions and aggregations and calculations.
• Involved in performance tuning of the dashboards using cache management.
• Tested and validated the unit test cases
• Organized and customized the presentation layer in a format that is easy for end user to use as basis for reporting
• Worked on creation of repository variables and session variables.
• Worked with the Security settings in OBIEE Admin Tool to set up users, groups, access privileges.
• Designed and developed interactive navigational drill down reports in OBIEE Answers, requests and Intelligence Dashboards using various reporting features and functionalities such as formulas, filters, charts, pivot tables.
• Using the Presentation Variable in prompts Report filters.

Environment: OBIEE 10.1.3.4, OBI Publisher, Informatica 8.1, Oracle 9i, SQL, PL/SQL, UNIX.