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 10/11G, and knowledge of BI Publisher 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 Answers.
• 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 in UAT.

Technical Skills:

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

Education Certifications:

Associates in Sciences Major in Finance from Richland College in TX Oracle

Financial Analytics and Data Base from Oracle University

WORK EXPERIENCE:

Confidential

OBIEE Reports Developer

• Designed document report specifications for BI Answers Dashboards
• Implemented metadata layers including physical, business model, and presentation layers in RPD.
• Created custom dashboards, KPI, and scorecards Designed unit test, and deployment of custom reports during Integration
• Participated in UAT for the Loss Prevention and Basket Analysis
• Developed interactive Dashboards for the HR Department and Retail Stores for Savers Village
• Provided technical support of BI systems and software to HR, Loss Prevention and Retail Users.
• Created Smoke Tests for Loss Prevention functional testing during UAT.tes
• Prepared test scripts and ran smoke tests during UAT.
• Merged Dev and QA environments in RPD
• Performed presentations and workshops with Business Sponsors and Users.

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
• 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.
• Worked with ETL Developers to create Cache persistence Wizard to efficiently handle cache management.
• 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.