Summary

Highly accomplished and solutions oriented IT Professional with broad based knowledge in Systems Design and Development, implementing and integrating cost-effective, high performance technical solutions to meet challenging business needs. Excel in strategic planning, project management, implementing best practice methodologies and consistently improving delivery times and service levels while reducing costs. 7 years of experience in Oracle Business Intelligence Enterprise Edition OBIEE 10G/11G , Oracle 11g, Informatica 8.6.1/9.01 and Data warehousing BI , Worked extensively on OBIEE/Siebel Analytics Administration Tool involving all the 3 layers namely Physical Layer, BMM Layer and Presentation Layer. Extensive experience in OBIEE/ Siebel Analytics Presentation Services Extensive experience in OBIEE security models implementation and OBIEE Environment administration MUD creation, configuration and Support . Reporting solution design and OBIEE customizations to meet end users reporting requirements. Excellent aptitude in translating high-level business requirements into logical business dimensional model, building business models, configuring metadata, Answers, Delivers / iBots, creating reports / Dashboards, cache monitor. Expertise in Business Model development with various functionalities like Dimensional Hierarchies, Measures, Aggregation Rules, Time Series and other functions. Skilled with Caching Mapping, data- level and object-level security, MUD, Integration Variables/Initialization Blocks configuration. Highly skilled in building Interactive Dashboards with drill-down drill-across capabilities using global local Filters, Business Rules with User Identity Roles, Profiles Personalization Knowledge of implementing the Oracle BI / Siebel Security Setup groups, data access/query privileges , Metadata Objects Subject Area, Table, and Column and Web Catalog Objects Dashboard, Pages, Folders, Reports . Debugging, Optimizing and Performance Tuning of OBI Siebel Analytical Dashboards / Reports to improve performance at Database. Proficient in working on production and development environment in different RDBMS in Oracle 10g/11g . Practical understanding of the Data modeling Dimensional Relational concepts like Star-Schema modeling, Snowflakes modeling, fact and dimension tables modeling of data Very good experience in Onsite offshore development model. Technical Skills

• Applications / Modules: OBIEE 10g/11g, BI Publisher 10g/11g, Informatica, DAC
• Languages: SQL, HTML, XML
• Strong hands on experience with OBIEE 11g
• Methodologies: Oracle AIM, SDLC
• Operating Systems: MS Windows, UNIX
• Software: Microsoft Office Suite, including MS Project, XML, WebServices
• Databases / Tools: Oracle SQL Developer, Toad
• Informatica Power Center.
• OBIEE Versions: 11.1.1.3, 10.1.3.4.1, 10.1.3.2.1 Seibel Analytics

Professional Experience

Role: OBIEE Developer

Confidential

Responsibilities:

• 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.
• Installation and configuration of OBIEE 11g
• Requirement validation of the reports and drill downs with business users.
• Creation and Customization of the OBIEE Repository Physical, Business and Presentation layers
• Creating Data Templates, like RTF and E-text
• Configuring BI Publisher to source data from OBIEE or database
• Configuring bursting and scheduling reports using BI Publisher
• Maintaining and configuring BI Publisher application
• Convert existing analysis into BI publisher reports
• Ensure the necessary data source connections are defined and pointing to the appropriate database.
• Configuring MUDE Multi User Development Environment , OBIEE scheduler, usage tracking.
• Knowledgeable in cache management, Repository migration, overall security, data level and object level security in OBIEE Analytics.
• Performed Business Intelligence reporting in Analytic/dashboard using OBIEE 11g
• Created dimension hierarchies, level based measures, Time Series metrics and derived columns of business metrics in the BMM layer.
• Worked on repository and session variables.
• Customized reporting with OBIEE Analysis and integrated them into the Dashboards.
• Generated Reports and Dashboards by using Report features like Pivot tables, charts and view selector.
• Created dashboards with global prompts, column selectors, navigation, and automatic drill-down.
• Created user level security for intelligence dashboards based on Business Requirement in OBIEE 11g.
• Performed Data Validation of data in the reports and dashboards.
• Performed production support for the project.

Role: OBIEE Consultant

Confidential

Responsibilities:

• Gathered Business requirements by interacting with the Business Analysts and the business users and created mockup reports.
• Customized the Siebel Analytics Repository physical, BMM, and presentation layers .
• Created dimension hierarchies, aggregates, and logical sources in the BMM layer.
• Worked on repository variables and session variables.
• Used the security settings in the Console and Enterprise Manager to setup users, Groups and Access privileges.
• Involved in the upgrade task force as well as verifying the new environment.
• Defined ibots/agents and delivers for various request.
• Generated Reports by using Report features like Pivot tables, charts and view selector.
• Created Dashboards with Dashboard prompts, Charts, Pivot tables in 10g/11g
• Performed Data Validation of data in the reports.
• Performed production support for the project.
• Performed tuning in OBIEE 10g/11g

Role: OBIEE Consultant

Confidential

Responsibilities:

• Gathered Business requirements by interacting with the business users, defined subject areas for analytical data requirement.
• Customized the Siebel Analytics Repository physical, BMM, and presentation layers .
• Created dimension hierarchies, aggregates, and keys in the BMM layer.
• Modified Presentation Layer to add presentation tables and columns to meet the business user needs.
• Worked on repository and session variables.
• Customized reporting with Siebel Answers and integrated them into the Dashboards.
• Generated Reports and Dashboards by using Report features like Pivot tables, charts and view selector.
• Created dashboards with global prompts, column selectors, navigation, and automatic drill-down.
• Created user level security for intelligence dashboards based on Business Requirement.
• Created Dashboards with Dashboard prompts, Charts, Pivot tables.
• Performed Data Validation of data in the reports and dashboards.
• Created iBots to send pre-processed reports using Siebel Delivers.
• Performed production support for the project.

Role: Seibel Quality Assurance Analyst

Confidential

Responsibilities:

• Verified business requirements and functional specifications
• Conducted system functionality testing as well as performance testing: developed and executed test cases, produced problem reports, suggestions, system test logs, and test incidents reports
• Execute the test cases to test the application and evaluate the result
• Analyzed and reported the defects to the developers using Mercury Quality Center
• Reported the bugs, emailed notifications to the developers using the Mercury Quality Center.