Summary:

• 10 Years of experience in designing and developing Business Intelligence solutions in Data Warehousing/Decision Support Systems.
• Good understanding of Data warehousing concepts/methodologies- Involved in architectural design, Data Modeling Star Schema, Snowflake , Designed Dimension, Fact and Aggregate tables and slowly changing dimensions.
• Interpreted high-level business requirements into Logical Business Models Facts, Dimensions .
• Proficient in configuring the physical/logical/presentation layers of the OBIEE Administration Tool.
• Upgrade and deployment experience from Siebel Analytics 7.8 to 10g and 10g to 11.1.7.1
• Expertise in designing the report layout templates in the BI Publisher
• Designed/Developed complex reports in OBIEE Answers/Dashboards and trained the Business/ Power users to create reports in OBIEE
• Good knowledge in Datawarehouse Application Console DAC and Informatica Architecture.
• Expertise in implementing complex business rules by creating robust mappings, mapplets, and reusable transformations using Informatica PowerCenter 7.x/8.x/9.1.
• Configured iBots to deliver Analytics content based on schedule, automated iBot queries to obtain weekly reports and updates.
• Proficiency in object level and data level security management of all aspects of OBIEE.
• Responsibilities included using various performance tuning techniques to decrease the response time of query requests.
• Hands On experience integrating OBIEE with Oracle E-Business Suite and PeopleSoft Applications.
• Used OBIEE RPD and dashboard best practices.
• Ability to produce well-documented designs and code.
• Enthusiastic and Goal-Oriented team player possessing excellent communication, interpersonal skills and leadership capabilities with high level of adaptability.

Technical skills expertise: -

Professional Overview

Confidential

OBIEE BI Lead/Administrator

• Participated in the requirements gathering based on business needs.
• Migrated existing AP, AR, GL and Order Management reports in Cognos cubes to OBIEE.
• Customized Late Payments, Unapplied Cash Receipts, Balance Sheets, P L reports in Finance Modules as per business requirements.
• Customized BI Apps 7.9.6.4 Finance, SCOM, HR and Manufacturing OOB reports.
• Implemented BI Publisher reports for Cost Accounting and SCOM Modules for real time data scenarios.
• Created Custom Subject Areas for FDM Financial Data mart and Clinical Reporting applications
• Configured new application roles and session initialization blocks as part of 11g upgrade.
• Setup Data level security and Web Catalog object security for various user roles.
• Implemented Canonical Time Dimension concept and gave the users the flexibility to report on Non Confirming Dimensions.
• Trained the junior team on the importance of setting up OBIEE Aggregate content level settings.
• Engaged prospective users by conducting training sessions to increase the awareness and benefits of BI.
• Improved the performance of query requests by using effective Performance Tuning Techniques.
• Administrative tasks included migrating RPD and web catalog from DEV, UAT to Prod clustered environment.
• Configured Agents to deliver Analytics content based on schedule, automated iBot queries to obtain daily and weekly reports.
• Trained the operations and technical teams on reports and dashboards usage.

Environment: OBIEE 11.1.7.1, OBIA 7.9.6.4, Oracle EBS R12

------------------------------------------------------------------------------------------

Confidential

Sr. OBIEE Developer

• Worked closely with Business user in understanding the OBIEE reporting needs from target user groups.
• Extensively worked with Data Analyst and Business Analyst to understand the business model for designing the Meta data Repository
• Extensive experience in working with Multi User Development Environments
• Deployed the RPD from MUDE to DEV, QA and production environments
• Expertise in developing the Subject Area with Physical Layer Objects Database, Connection Pool, Catalog, Schema, Table , Business Layer Objects Logical Table, Dimensions, Joins, Facts, Initialization Blocks, Repository Dynamic Variables , Presentation Layer Objects Table, Columns
• Created various logical columns based on existing logical/physical tables as sources
• Identified Facts, Dimensions, Levels / Hierarchies of Dimensional Modeling
• Created session and repository variables and initialized them in the Initialization blocks to change metadata dynamically as the environment changes.
• Implemented data level security for intelligence dashboards based on Business Requirement.
• Developed test cases and performed Unit Testing and Integration Testing of the Repository and Web Catalogs.

Environment: OBIEE 11.1.1..6.10, Teradata, Oracle 11g

Confidential

Sr.HR Analytics OBIA Lead

• Worked with management team to draft business requirements and ensure all the proper metrics and performance requirements were in place to ensure maximum efficiency of the resulting design.
• Performed gap analysis and feasibility study for the given requirement.
• Worked on Workforce, Learning and Recruitment Modules in OBI Apps 7.9.3.
• Created custom HR Subject Areas based on business requirements.
• Customized the OTB HR Analytics SDE/SILOS Informatica mappings, RPD objects according to the reporting needs of the business users
• Localized the metadata names In RPD and implemented translation lookup tables for Multilingual Data Support as part of Global Integration Project.
• Customized OTB HR Row Level Security
• Resolved data issues in reports by backtracking from OBIEE report level to PeopleSoft source data.
• Taking sign off for all functional and technical design documents and being responsible for further changes in the design.
• Trained the operations and technical teams on reports and dashboards usage.

Environment: OBIEE 11.1.1.5, Oracle 11g, OBIA 7.9.6.3, PeopleSoft 9.1, Informatica 9.1, DAC 10.1.3.4.1

------------------------------------------------------------------------------------------

Confidential

Sr. OBIA Lead

• Responsibility includes gathering business requirements, functional analysis, gap analysis, design, data modeling, development, client interaction, and compiling specifications from client, modification testing, documentation and delivery
• Customized the Order management OTB SDE/SILOS Informatica mappings, RPD and reports according to the reporting needs of the client.
• Identified Facts and Dimensions with levels hierarchy and requested changes to the Data Warehouse as per gaps.
• Played a key role in installing and configuring OBIA 7.9.6.2 for Oracle Supply Chain Analytics on Windows 2008 Platform
• Integrated OBIEE 11g with EBS Oracle Supply Chain Management.
• Upgraded Siebel Analytics 7.8.4 to OBIEE 10.1.3.4.1 in Clustered Environment.
• Improved the performance of query requests by effective Performance Tuning Techniques.
• Define ibots/delivers for various departments as per business requirements

Environment: OBIEE 10.1.3.4.1, Oracle 11g, AIX 5.3, Windows 2008, OBIA 7.9.6.2, Informatica 9.1, Oracle EBS 11i

------------------------------------------------------------------------------------------

Confidential

Sr. OBI Apps /Informatica Developer

• Client requirement gathering, understanding business objectives and analysis
• Developed the repository model for the different work streams with the necessary logic that involved creating the Physical, BMM and the Presentation layer, customized the existing OTB model and also build new models which were not accomplished by OTB models.
• Created Calculation Measures, Time Dependent Measures, Initialization Blocks and Repository Variables.
• Improved the performance of query requests by effective Performance Tuning Techniques.
• Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping Mapplet Designer and Transformation Designer.
• Resolved Production OLAP data issues by backtracking from OBIEE report level to Siebel CRM OLTP Data.
• Set up Conditional iBots to send custom reports when a data alert condition was triggered that threatened specified Rail Road Car numbers
• Trained the operations and technical teams on reports and dashboards usage.

Environment: Siebel Analytics 7.8.4, OBIEE 10.1.3.4.1, OBIA 7.9.6.2, Informatica 8.6.1, Siebel 8.1.1

Confidential

OBIEE developer

• Interacting with Client and Users and gathering the requirement based on their business prospective.
• Used OBIEE Best Practices for creating OBIEE Repositories and Dashboards.
• Was responsible for creating, validating and testing the repository objects before delivering it to the users.
• Improved the performance of query requests by effective Performance Tuning Techniques.
• Setup Usage tracking option to monitor frequently run reports in order to provide caching for the reports and perform database optimization by analyzing query performance.
• Created report prototypes mockup of reports in excel and presented to user to get approval.
• Created Repository Groups and Web Groups and assigned users to configure security in the OBIEE
• Transition Knowledge and train developers.

Environment: Oracle BI 10.1.3.3, Teradata, Sql, Windows Server 2003

Confidential

OBIEE Developer

• Identified customer requirements, wrote functional designs, reviewed technical designs, developed test schedules and reviewed testing plans, documented development and results of these plans.
• One on One meeting with SME to understand the business scenario and process flow.
• Created/Modified/ Customized Metadata repository .rpd and Configured Metadata Objects using Siebel Analytics Server Admin tool.
• Diagnosed the reasons for slowly running reports using Usage Tracking dashboards and NQQuery.log Files
• Developed several Interactive Dashboards with drill-down capabilities, pivot tables, charts, and tabular reports using OBIEE Answers.
• Worked closely with Users, Developers and Administrators to resolve ongoing Production Problems by reviewing design changes made to production systems.
• Created custom JavaScript and HTML templates for implementing additional web interface to OBIEE Dashboards.

Environment: OBIEE 10.1.3.2, Oracle, SQL, PL/SQL, Toad 8.5, Windows 2003 Server