Summary:

• Over Seven years of experience in Business Intelligence and Reporting using Dashboards in Weblogic and BI Answers.
• Over 4 years of experience as an OBIEE 11G, and knowledge of BI Publisher 10g/11g / XML Publisher and Oracle E-Business Suite.
• Experience in implementation of Business Intelligence with Star and Snow flake Schemas using Ralph Kimball and Bill Inman Methodologies.
• Worked in developing OBIEE Repository .rpd at three layers Physical Layer, Business Model Presentation Layer .
• Created Time Series Objects, Interactive Dashboards with drill-down capabilities using global local Filters, Security Setup groups, access / query/report privileges .
• Created Alerts using Agent for setting up KPI's in BI Ansers.
• Hands on experience in Authentication and Authorization of OBIEE by using LDAP, Database authentication, External Authentication.
• Have implemented Security Models for Dashboards, Row level, objects Level, Role Level, and Web Level.
• Have worked with ETL Developers and other IT members in troubleshooting and UAT.

Technical Skills:

O/S: Windows XP/2000/NT/98/95, SQL, Power Point

WORK EXPERIENCE:

Confidential

OBIEE Reports Developer

Retail Analytics:

Analyzed and determined merchandise mix and related product performance. Recommended adjustments for location business trends, seasonal selling peaks and physical location capacity. Maintained reporting activities on key analytics and worked effectively with Business Intelligence team to optimize reporting. Partnered effectively with Sales and planning to ensure that most accurate sales plans are captured each quarter. Estimated and calculated Quarterly Incentives for Retail Development team.

Loss Prevention Analytic:

Confidential

OBIEE Contractor: Responsibilities:

• Responsible for all Oracle Business Intelligence solutions and creation of Executive Dashboards and Financial Statements analysis.
• Defined and developed Executive Dashboards and analytics using the OBI RPD and BI Answers
• Imported the custom fact and dimension tables and configured it in the 3 layers of the RPD. Implemented Level Based Metrics in the BMM layer. Created Compound facts in the BMM as per the client requirement.
• Participated in the walkthroughs of the data models, identification of dimensional attributes, Facts and Star Schema to fulfill requirements
• Worked with ETL Developers and other IT members in troubleshooting and UAT.
• Applied dimensional data modeling concepts as they relate to BI methodologies, concepts and designs including: star schemas,
• Created RPDs using Dimensional Modeling and used them for Mapping.
• Created Security Groups for granting privileges to the select users who accessed Dashboards and certain Repository Objects.
• Set up KPI'S for Managers as well as Scorecards to measure performance.
• Created Agent and Alerts for monitoring of loads and errors during the intermittent loads.
• Worked closely with other BI members of the development and support team in order to protect the integrity of the company's data.

Environment: BI Answers, OBIEE 11g/10g, Oracle 11g/10g, SQL, Windows Server 2008.

Confidential

OBIEE Developer: Responsibilities:

• Interacted closely with Functional Analysts and Business Users in the client side, and designed the system accordingly.
• Experience on OBIEE 11.1.1.5, OBIEE 10G/11G
• 3 years experienced in integration of various data sources DB2-UDB, SQL Server.
• Worked extensively on OBIEE Answers to create the Financial Statement reports and Intelligence Dashboards Financials as per the detailed design requirements.
• Extensively used page prompts and dashboard prompts for filtering data values in financial reports.
• Designed and tested Reports in the Dashboards for the Oracle Financial Analytics and created the Ad hoc report according to the client needs.
• Used Table and pivot table to display hierarchical columns for Parent Child and Logical Table Hierarchies.
• Built the Physical Layer /Business Model and Mapping Layer of the Repository by using Star and snowflake Schemas.
• Worked with ETL Developers to create Cache persistence Wizard to efficiently handle cache management.
• Created Logical Table Sources LTS , logical and physical mappings, modeling in all three RPD layers, Physical, BM M and Presentation Layers.
• Worked with properties such as changing the ownership of a folder or viewing the creation date of an object.
• Specified permissions that determine the folders and objects that users can view.
• Sorted data values, applied sorts to members, measures, and rows in views such as tables, pivot tables, graphs, and maps.
• Developed different Dashboards/Reports with different view Calculation, Detailed, Pivot, Charts, and Filters and different intuitive drilldowns, drill-across and drillable charts using the OBIEE Answers.

Environment: OBIEE 11g/10g, Oracle 11g/10g, SQL, Windows Server 2008.

Confidential

OBIEE Contractor: Responsibilities:

• Worked with Business Groups to identify, analyze, and document Business Requirements.
• Prepared Design Specification documents based on functional requirements and also involved in the preparation of Technical Design Documents.
• Defined the Primary, Foreign keys and created Simple and Complex joins between various Dimension and Fact Tables.
• Built the Physical Layer /Business Model and Mapping Layer of the Repository by using Star and snowflake Schemas.
• Defined dimensional hierarchies and associated the proper level of granularity to the fact table.
• Implemented dynamic dashboard prompts to zoom into particular segments of the business in a performance-optimized manner.
• Involved with other Team members in configuring and customizing sources, targets, tasks and execution plans using DAC.
• Participated in Migration from UAT to Dev during the integration process.

Environment: OBIEE, Oracle BI Apps 7.9.6.1, Oracle, Microsoft SQL Server.

Confidential

OBIEE Consultant: Responsibilities

• Collaborated with Business contacts Business Analysts in the analysis and preparation of OBI data requirements.
• Participated in the walkthroughs of the data models, identification of dimensional attributes, Facts and Star Schema to fulfill requirements
• Creating dimensions, aggregations and keys using admin tool. Customizing Physical Layer, BMM Layer and Presentation Layer using OBI Administration tool.
• Designed and tested Reports in the Dashboards for the Oracle Financial Analytics and created the Ad hoc report according to the client needs.
• Creating Users and Groups and managing the object level and data level security.
• Managing the intelligent dashboards by using dashboard, page and report level security.
• Creation of views like Pivot table, Column Selector, Compound layout.

Confidential

OBIEE Developer: Responsibilities:

• Participated in the client installations and integration of OBIEE 10.1.3.3, DAC and Informatica 7.1.2
• Interacted with business representatives for requirement analysis, and to define business and function/technical specifications.
• Created Dimension Hierarchies in the business model and mapping Layer to drill down custom Store and product dimensions.
• Created the new columns in existing fact and dimension tables and creating all together the new dimension and fact tables.
• Imported the custom fact and dimension tables and configured it in the 3 layers of the RPD. Implemented Level Based Metrics in the BMM layer. Created Compound facts in the BMM as per the client requirement.
• Designed Schema using custom fact, dimensions, physical, logical, Alias and extension tables
• Created Dimension Hierarchies in the business model and mapping Layer to drill down custom Store and product dimensions.