SUMMARY

• Over nine (9+)years of experience in IT Industry and over Five (5+)years of experience in designing, development and implementation of OBIEE 10.1.3.x/ Siebel Analytics 7.x
• Expertise in full life cycle Business Intelligence implementations and have an understanding of all aspects of an implementation project using OBIEE 10.1.3.x/Siebel Analytics 7.x.
• Experienced in gathering reporting and analysis requirements, documenting the report specifications, implementing the metadata layers including Physical, Business Model and Mapping, and Presentation layer.
• Experienced in up gradation and migration of OBIEE between dev/test/prod environments.
• Expertise in design and development of the three layers(Physical/Business Model and Mapping/ Presentation)of anOBIEE Metadata Repository (.rpd)usingOracle BI Administration Tool.
• Highly skilled at configuring OBIEE Metadata Objects including repository, variables, interactive dashboards, and reports.
• Experienced in designing customized interactive dashboards in OBIEE using drill down, guided navigation, prompts, filters, and variables.
• Expert in using OBIEE Answers to create queries, format views, charts, and add user interactivity and dynamic content to enhance the user experience.
• Experienced in working with Variable Manager to define session and repository variables and initialization blocks to streamline administrative tasks and modify metadata content dynamically.
• Proficient in Installation, configuration, and administration of the OBIEE platform.
• Experienced in developing Dimensional Hierarchies, Level Based Measures, and adding multiple sources to business model objects.
• Skilled at creating and scheduling iBots in Oracle BI Delivers to provide real - time, personalized and actionable intelligence data to subscribers.
• Experienced in configuring and set up of OBIEE Security using LDAP and External Database Tables and configuring object level and database level security.
• Experienced in configuring Usage Tracking and Multiuser Development Environment (MUDE).
• Extensively worked with DBAs and BAs towards performance tuning in OBIEE and Data Warehouse environment using cache management, aggregate tables, and indexes.
• Extensive experience in creating executive reports with BI Publisher integrated with OBIEE.
• Have extensively worked in developing ETL program for supporting Data Extraction, transformations and loading using Informatica Power Center.
• Experience with dimensional modeling using star schema and snowflake models.
• Understand the business rules completely based on High Level document specifications and implements the data transformation methodologies

TECHNICAL SKILLS

Business Intelligence Tool: OBIEE 10.1.3.x, Siebel Analytics 7.x Databases Oracle 9i/10g, MS SQL Server 200x, MS Access Database Tools TOAD, Oracle SQL Developer

ETL tools: Informatica Power Center 7.x/8.x

Languages: SQL, PL SQL, JavaScript, HTML, XML Operating Systems Windows, Unix, Linux

Business modeling Tools: IBM-Rational Requisite Pro, IBM-Rational Rose, Erwin, MS Visio, SmartDraw, MS Project, Oracle-Primavera SureTrack, Unified Modeling Language (UML)

PROFESSIONAL EXPERIENCE

Confidential

Senior OBIEE Consultant

Environment: OBIEE 10.1.3.4, BI Publisher 10.1.3.4, Oracle 10g, SQL, Toad 9.7, Windows XP, HTML, CSS

Responsibilities:

• Worked during the whole life cycle of the project from requirements gathering to deployment.
• Acted as a liaison between business users and BI team to facilitate understanding of business requirements.
• Created Requirements Traceability Matrix and Mapping Document to trace requirements in BI implementation.
• Conducted Functional Requirements review and walk through with BI Architect, Designers, and Stakeholders.
• Analyzed the data and developed Logical Star Schema model with consultation from Data Modelers and Business Analysts.
• Developed metadata repository using OBIEE Administration tool in Physical, Business Model and Mapping, and Presentation Layer.
• Created new logical columns, dimensional hierarchy, calculated measures, and aggregate mappings in the BMM layer as per the business requirements.
• Developed Time Series Objects using Ago and To Date functions for time series comparisons.
• Designed and developed various Interactive Dashboards and reports with drilldowns, guided navigation, filters, and prompts.
• Created various session and repository variables and initialized them in the Initialization Blocks to change metadata dynamically as the environment changes.
• Configured BI Scheduler and Oracle BI Delivers- iBots to deliver alerts and publish updated content to subscribed users as per the schedules and requirements.
• Worked towards the Performance Tuning of Dashboards and Reports with Business Analysts and DBAs.
• Implemented security based on LDAP Authentication.
• Used various cache management techniques for performance tuning including configuring, defining cache parameters, cache persistence time, cache seeding and purging, and event polling.
• Created security settings in OBIEE Administration Tool and set up groups, access privileges and query privileges and also managed security for groups in Answers.
• Integrated BI Publisher with OBIEE to build reports in word, excel and doc format.
• Created various templates, reports, and prompts in BI Publisher.
• Developed test cases and performed Unit Testing and Integration Testing of the Repository and Web Catalogs.
• Provided guidance and support to end users during the implementation and in production.

Confidential

Senior OBIEE Consultant

Environment: OBIEE 10.1.3.4, BI Publisher 10.1.3.4, Oracle 10g, SQL, Toad 9.7, Windows XP, HTML, CSS

Responsibilities:

• Interacted with Subject Matter Experts and Business Analysts for reporting requirements analysis and to define business and functional specifications.
• Monitored and documented change requests in requirements and ensured modified requirements are met during BI development.
• Interviewed SMEs, asking detailed questions regarding reporting requirements to refine BRD and FRD.
• Developed metadata repository and configured metadata objects in all three layers using Oracle BI Administration tool.
• Build repository by importing the data, defining keys and joins, creating business model, defining complex joins, mapping columns and sources, creating measures, and developing subject areas.
• Developed various Reports, Interactive Dashboards with drill-down capabilities, with various charts and views, and tables using global and local Filters.
• Developed Reports and Dashboards with different Analytics Views including Pivot Table, Chart, Gauges, Column Selector, and View Selector with global and local Filters using Oracle BI Presentation Services.
• Used OBIEE Web Catalog to set up groups, access privileges and query privileges.
• Configured schedulers and used iBots to generate and deliver reports based on business requirements.
• Created dimension hierarchies, aggregation criteria and multiple logical sources in the BMM layer.
• Involved in performance tuning of the dashboards with DBAs and BAs using cache management and aggregate tables.
• Created schedules to seed and purge cache for cache management.
• Implemented security by creating roles and web groups, and defined Object Level and Data Level Security.
• Developer templates and reports in Oracle BI Publisher in rtf format.
• Attended JAD and White Boarding Sessions with Users and Business Analysts to keep business synchronized with the progress.
• Create Test Plans, Test Cases and performed unit and integration testing
• Participated in designing, coordination and execution of User Acceptance Testing (UAT) with QA, BA and selected business users.

Confidential, Cypress - CA

Senior OBIEE Consultant

Environment: OBIEE 10.1.3.4, Informatica 8.6, Oracle 10g, SQL, Toad 9.0, Windows XP.

Responsibilities:

• Interacted with business representatives and business analysts for requirements analysis and to define business and functional specifications.
• Analyzed the Reporting Requirements and participated in the documentation of Business Requirements.
• Developed Oracle BI Metadata repository using BI Administration tool.
• Developed interactive Dashboards and Reports in Oracle BI Answers as per the reporting specifications.
• Defined and created Initialization Blocks, Repository and Session Variables for generating filters and defining security.
• Created Hierarchies, Levels, and implemented Business Logic by creating level based measures in OBIEE business model & mapping layer.
• Developed measure for time comparison using time functions, ToDate and Ago.
• Used Filters and provided Prompts appropriately to make interactive reports and to avoid excessive data showing up on Reports.
• Customized/Created presentation layer catalog folders, to show different views of the business model to different users and assigned group permissions to the catalog folders.
• Performed the Performance Tuning of Dashboards and Reports and made required changes to repository and database in consultation with DBA.
• Implemented security based on LDAP Authentication.
• Configured Measures in the Business Model Layer and mapped to multiple logical table sources.
• Created schedulers and developed iBots to deliver reports and dashboards to the subscribers as per the schedules and alerts.
• Created report prototypes and presented them to users to get approval.
• Attended weekly meetings with BA and Stakeholders for project status updates.
• Performed unit and integration testing of reports and dashboards.

Confidential

OBIEE Developer

Environment: OBIEE 10.1.3.3, Informatica Power Center 8.1, Oracle 10g, OBIA 7.9.x (Oracle Service Analytics), DAC, Toad, SQL, Windows XP

Responsibilities:

• Worked closely with Business Analyst in understanding the BI and reporting requirements and created the business model for generating reports as per the user requirements.
• Worked closely with the data modeler in designing the logical data model in star schema in BMM Layer.
• Configured and created repository using OBIEE Administration Tool.
• Created and administered the Physical Layer, Business Model and Mapping Layer and Presentation Layer in Repository using Administration Tool.
• Developed calculated measures and assigned aggregation levels based on dimension hierarchies.
• Managed security privileges for each subject area and dashboards according to the requirements.s
• Developed various kinds of request queries using BI Answers and assigned them to specific Dashboards.
• Configured iBots to deliver BI content to subscribers based on schedule and events.
• Created Security settings in OBIEE Administration Tool to set up groups, access privileges and query privileges and also managed security for groups in Answers.
• Developed intuitive and user friendly Dashboards by appropriately including guided navigational links, prompts, and drilldowns.
• Used the Catalog manager and maintained the Oracle BI web catalog to manage Dashboards, Answers.
• Involved in unit testing, integration testing of the reports generated by OBIEE.

Confidential

OBIEE Developer

Environment: OBIEE 10.1.3.3./11 g, BI Apps 7.9.6, Informatica 8.0, Oracle 10g, SQL, PL/SQL, DAC, TOAD, SQL* Plus, Windows XP

Responsibilities:

• Full project life cycle implementation for Oracle Business Analytics Warehouse (OBAW)
• Performed Project Scoping, Project Organization and Management including Business & IT Requirements, Priorities, Project Execution Plan and Resource Plan.
• Created Custom SDE Adaptors and built new Subject areas and Execution Plans in DAC for new customized subject area.
• Expertise with Siebel Base tables and EIM workflows.
• Used the OBIEE 10.1.3.4 Administration tool to develop and enhance Data Model.
• Configured and created OBIEE Repository, Involved in modifications of the physical, the BMM, and the presentation layers of metadata repository using OBIEE Administration Tool.
• Designed schema using KPIs, Fact, Dimensions, Physical, Logical, Alias and Extension tables. Built Business Model and established relationships & Foreign Keys (Physical & Logical) between tables
• Identified the aggregate levels for measures and created dimension hierarchy sources for each level of aggregates for performance enhancement.
• Created executive level Reports and Dashboards catering to provide insight into the sales / marketing data.
• Developed custom reports/Ad-hoc queries using Answers and assigned them to application specific dashboards.
• Developed BI Consumer reports using OBIEE 11g.
• Expertise in segmentations and scheduled programs on daily basis.
• Expertise in SQL check and List pulls.
• Developed new Informatica mappings for enhancement and bug fixes for various brands as per various requirements.
• Worked on Informatica Performance tuning methods like various ways of using lookup caches depending on the size of source and lookup tables.
• Added new facts and Dimensions to the OBAW and created new execution plan in DAC for dial load into these table.
• Proficient in working with HP Service center and Quality center.
• Worked in production support and seen through the phase of the developments in the production and done various bug fixes.
• Worked with Siebel EIM tables and tweaked the batch file (.ifb) to process more no. of rows at a time.

Confidential

OBIEE Developer

Environment: OBIEE 10.1.3.4, Informatica Power Center 8.1, Oracle 10g, TOAD, SQL, PL/SQL, Unix Shell scripts.

Responsibilities:

• Gathered Business requirements by interacting with the business users defined subject areas for analytical data requirements.
• Designed and Customized Metadata repository using Siebel Analytics Server Admin tool.
• Configured measures in the Business Model Layer and mapped to multiple logical source tables.
• Extensively used Siebel applications (Siebel Answers, Dashboards & Delivers).
• Developed custom reports/Ad-hoc queries using Siebel Answers and assigned them to application specific Dashboards.
• Created Dashboards by embedding Reports and providing intuitive drilldowns, interactive flash-based drillable charts and links to exploit the full benefit of Analytics.
• Responsible for monitoring sessions that are running, scheduled, completed and failed.
• Responsible for Unit, System and Integration Testing and Performed Data Validation for all the reports that are generated from Siebel Analytics.
• Trained End Users to build Ad Hoc Reports using Siebel Analytics.

Confidential

OBIEE developer

Responsibilities:

• Develop, implement and deploy data warehousing and business analytical solutionsInstall, upgrade and configure database solutions through OBIEE tools
• Develop data access queries through Oracle BI tools
• Develop and design dashboards, reports, ad hoc queries and analysis
• Work in collaboration with data analysts, business analysts, other technical teams and business teams
• Involve in ETL applications, data feeding, cleansing, archiving and re-modeling
• Prepare documentation and give project performance feedback to the clients and the senior management

Confidential

ETL Developer

Environment: Informatica 7.1, Oracle 9i, SQL, PL/SQL, Windows 2003, Unix

Responsibilities:

• Installed and configured Informatica Server and Power Mart.
• Created Repository, Folders, and User accounts using Power Mart Repository Manager.
• Created database objects like tables, views, synonyms, indexes and sequences.
• Designed and developed mappings using Power Mart Designer.
• Used all Transformations such as Expression, Filter, Joiner, aggregator, Lookup and Router, to load consistent data into Warehouse Database.
• Used Server Manager to create database connections, sessions to run the mappings.
• Wrapped the sessions with pre-session and post-session UNIX shell scripts.
• Created and scheduled batches for the daily load of the data.
• Used various performance tuning methods to make the loads more efficient.
• Tested the Informatica mappings and creating QA Test Plans.
• Developed the documentation on the complete data mart ETL process.
• Supported the data mart in Production.