SUMMARY:

• Worked extensively on OBIEE/Siebel Analytics Administration Tool involving all the 3 layers namely Physical
• Layer, BMM Layer and Presentation Layer.
• Extensive experience in OBIEE11g/10g Presentation Services including Answers, Interactive Dashboards,
• Delivers/IBOTS, Cache Management, Scheduler Configuration, BI Publisher.
• Excellent aptitude in translating high - level business requirements into logical business dimensional model, building business models, configuring metadata, Answers, creating reports / Dashboards, cache monitor
• Expertise in Business Model development with various functionalities like Dimensional Hierarchies, Measures,
• Aggregation Rules, Time Series and other functions.
• Highly skilled in building Interactive Dashboards with drill-down capabilities using global & local Filters, Business
• Rules with User Identity & Roles, Profiles & Personalization.
• 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.
• A team player with excellent mentoring skills and technical instructor experience.
• Used Oracle SQL for various data operation including but not limited to Data Definition Data Manipulations, Data Query, and Administration

PROFESSIONAL EXPERIENCE:

Confidential, Ft Worth, TX

Developer

• Gather business requirements from the user community.
• Convert functional requirements into technical requirements.
• Identify the granularity level of data required to be available for analysis.
• Develop/configure Metadata repository (.rpd) and Web Catalog Objects as per business requirements using OBIEE
• Admin tool and BI Analytics.
• Work on OBIEE Answers to build Interactive Dashboards with drill-down capabilities.
• Use prompts in reports and dashboards to help users quickly answer business questions.
• Use conditional formatting in reports with a lot of coloring, per business requirements.
• Create action links in reports to expose detail information and answer more business questions.
• Design the business model conforming to functional mapping, defined logical and complex joins for the dimension tables.
• Create/configure hierarchies in the BMM layer.
• Work with time series models such as Month Ago gross profit, Year To Date (YTD) revenue.
• Import tables from DB, created star schemas, and used them to create reports using BI Analytics according to the business requirement.
• Use Filters and provided Customized prompts appropriately to avoid excessive data showing up Reports.
• Experience in creating reports with different views (pivot tables, charts, column selectors, view selectors) allowing clients to analyze the business from different perspectives.
• Experience in configuring the NQSConfig.INI and instance config files.
• Experience in creating comprehensive and easy-to-understand Documentation of the complete implementation of
• Analytics that includes (RPD, Reports and Dashboards, Security).
• Manage security functionality by creating users and assigning them to their respective groups.
• Manage performance by use of cache management, and aggregate tables.

Environment: Oracle 11g, OBIEE 11g, SQL, SQL Developer, Windows 7.

Confidential,Dallas, TX

Business Intelligence Consultant

• Gathered requirements from senior finance managers/users through meetings,.
• Configured security permissions for various application roles to restrict access to specific subject areas and web catalog objects (Dashboards and reports).
• Used the OBIEE Admin Tool to develop the three layers in the Repository.
• The Physical, Business Model and Mapping layer and Presentation layer (RPD) analytics.
• Migrating reports /dashboards between different environments.
• Used the expression builder utility to create new logical columns in the BMM layer and created various calculation measures.
• Added required dashboard pages per senior management requirements.
• Added relevant projects in the Company RPD for new subject areas, and developed the star schemas using the OBIEE Administration Tool.
• Created connection pools, physical tables and defined Primary key, foreign key joins, complex joins in the physical layer of the repository.
• Created and modified logical tables, logical columns and defined Foreign-keys and complex joins.
• Used the expression builder utility to create new logical columns in the BMM layer and created various calculation measures.
• Worked on OBIEE Analytics to create the reports as per the client requirements (including compound views, table, charts, drill downs) for the Global Organization.
• Used the OBIEE Admin Tool to develop the three layers in the Repository. (RPD).
• Redesigned an existing model by examining and reconfiguring the joints on the star schema to improve report performance.
• Worked with Oracle Business Intelligence Enterprise Edition 11.1.1.9. Created Complex Joins, Alias Tables.
• Created Logical dimensions with Level Based Hierarchies in BMM layer using.
• Worked on OBIEE Answers to create the reports as per the client requirements (including compound views, table, Charts).
• Data Sources: Oracle 11g Enterprise Data Warehouse, Operational Data Store (ODS).
• Customized presentation layer catalog folders, to show different views of the business model to different users and assigned group permissions to the catalog folders.