SUMMARY

• Aboutsevenyears' experience ofin the Business Requirements Analysis, Application Design, Data Modeling, Development, and Testing of Data Warehousing and Database business systems and Implementations.
• Seven years of experience in Analytics and Dashboards OBIEE in, eBusiness verticals in Sales and Marketing Analytics.
• Sevenyears' experience in Oracle Database server 10g RDBMS and Programming concepts. Strong skills in SQL.
• Extensive Data Modeling experience in Star Schema/Snowflake schema design, Fact and Dimensions tables, Physical and logical data modeling.
• Gathered Business requirements by interacting with the business users.
• Performed gap analysis and feasibility study for the given requirement.
• Created mock up reports and dashboards for review by the business users.
• Performed Data Validation of data in the reports and dashboards.
• Extensively used SQL Tuning to improve performance.
• Design, Development and Documentation of the ETL strategy to populate the Data Warehouse from the various source systems.
• In depth knowledge on Data Mapping, Data Conversion, and Data Cleansing.
• Experience in performance tuning of Oracle Data Integrator mappings and sessions, Analytics Reports and SQL query.
• Extensive experience in Analytics/OBIEE repository Physical, Business Model and Mapping and Presentation layers for both Stand-Alone and Integrated OBIEE Analytics implementations.
• Extensively worked in creating hierarchies and aggregates in the BMML.
• Excellent proficiency in data and object level Security in Analytics/OBIEE.
• Extensive experience in customizing Siebel Analytics/OBIEE dashboards and reports.
• Extensive experience in Repository and Reports performance tuning.
• Performed unit, integration and system testing for all components in OBIEE Analytics.
• Created design, development, and testing documentation.
• Extensive experience using Oracle,and SQL Assistant.
• Enthusiastic team player, with excellent communication and interpersonal skills.

Technical Skills

Data Warehouse: Oracle Data Integrator, SQL Loader.

Business Intelligence:OBIEE10.1.3.2, Siebel Answers/Delivers.

Databases: SQL Server 2000, Oracle10g/11g, 11i, MS Access.

Operating Systems: Windows 2003, XP.

Languages: SQL.

Data Modeling: SQL Assistant

Software: Autosys, MS Project, Office.

Experience

Confidential

OBIEE Consultant

Responsibilities:

• Worked on repository and session variables.
• Modified Presentation Layer to add presentation tables and columns to meet the business user needs.
• Created dimension hierarchies, aggregates, and keys in the BMM layer.
• Created connection pools, imported physical tables and defined joins in the physical layer of the repository.
• Created mockup reports and dashboards for review by the business users.
• Performed gap analysis and feasibility study for the given requirement.
• Gathered Business requirements by interacting with the business users, defined subject areas for analytical data requirements.
• Customized the OBIEE Repository physical, BMM, and presentation layers .
• Used the security settings in Siebel Analytics Admin tool to setup users, Groups and Access privileges.
• Created materialized views and aggregates to improve performance.
• Customized Activity and Revenue star schemas.
• 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.
• Customized reporting with OBIEEAnswers and integrated them into the Dashboards.
• Created Analysis to send pre-processed reports using OBIEE Delivers.
• Extensively used SQL Tuning to improve performance.
• Performed Data Validation of data in the reports and dashboards.
• Created Dashboards with Dashboard prompts, Charts, Pivot tables.
• Customized and Developed OBIEE Analytics ReportsAccount Activity, Revenue on business segmentation, Actual Vs Forecast Response rates, and Segment and Offer responses.
• Created user level security for intelligence dashboards based on Business Requirement.
• Created dashboards with global prompts, column selectors, navigation, and automatic drill-down.
• Generated Reports and Dashboards by using Report features like Pivot tables,chartsand view selector.
• Unit, integration and system testing for all components in OBIEE. Test cases have been prepared and documented the results.
• Worked on evaluation of Oracle BI Enterprise Edition and its new utilities including BI Server, Answers, Delivers and Publisher.
• Documented the design for intuitive understanding and future reference.
• Performed production support for the project.

Environment:OBIEE 10g/11g, Windows XP.

Confidential

OBIEE Consultant

Responsibilities:

• Extensively used SQL Tuning to improve performance.
• Performed Data Validation of data in the reports and dashboards.
• Created dashboards with global prompts, column selectors, navigation, and automatic drill-down.
• Worked on repository and session variables.
• Modified Presentation Layer to addpresentation tables and columns to meet the business user needs.
• Created hierarchies based on the territory level for territorial level sales and contact reports.
• Worked on role-based dashboards in Fiscal Management.
• Created connection pools, imported physical tables and defined joins in the physical layer of the repository.
• l Expert in cache management, Repository migration, data level and object level security in OBIEE Analytics.
• l Responsible for creating users and maintaining visibility privileges using Analytics administration on the repository side.
• l Creation and Customization of the OBIEE Repository Physical, Business and Presentation layer .
• l Analysis of existing system and Identification of required dimensions and facts from the Database.
• l Requirement validation of the reports and drill downs with business users.
• l Interacted with end users and developers to validate the data model.
• l 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.
• Created materialized views and aggregates to improve performance.
• 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.
• Customized reporting with OBIEEAnalyticsand integrated them into the Dashboards.
• Generated Reports and Dashboards by using Report features like Pivot tables,chartsand view selector.
• Created user level security for intelligence dashboards based on Business Requirement.
• Created Dashboards with Dashboard prompts, Charts, Pivot tables.
• Unit, integration and system testing for all components in OBIEE. Test cases have been prepared and documented the results.
• Worked on evaluation of Oracle BI Enterprise Edition and its new utilities including BI Server, Answers, Delivers and Publisher.
• Documented the design for intuitive understanding and future reference.
• Performed production support for the project.

Environment:OBIEE10g, Oracle 11g, Windows.

Confidential

Responsibilities

• l 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.
• l Interacted with end users and developers to validate the data model.
• l Required validation of the reports and drill downs with business users.
• l Analysis of existing system and Identification of required dimensions and facts from the Database.
• l Creation and Customization of the OBIEE Repository Physical, Business and Presentation layer .
• l Responsible for creating users and maintaining visibility privileges using Analytics administration on the repository side.
• l Expert in cache management, Repository migration, data level and object level security in OBIEE Analytics.
• Created connection pools, imported physical tables and defined joins in the physical layer of the repository.
• Worked on role-based dashboards in Fiscal Management.