SUMMARY:

• IT professional /OBIEE Developer, with expertise in gathering Business Requirements, System Analysis, Design Data Modeling, Development, configuration and deployment.
• Five years of experience in RPD Development of Oracle Business Intelligence Enterprise EditionOBIEE) - Oracle
• 11g/ and Data warehousing.
• 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

TECHNICAL SKILLS:

Modeling Tools: Oracle SQL Developer.

Databases: Oracle, MySQL.

EXPERIENCE:

Confidential, Ft Worth, TX

Developer

Responsibilities:

• 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 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/ SQL, SQL Developer

Confidential, Seattle, WA

Business Intelligence Consultant

Responsibilities:

• 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.
• 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, tableCustomized presentation layer catalog folders, to show different views of the business model to different users and assigned group permissions to the catalog folders.
• Worked extensively on OBIEE Answers to create the reports as per the client requirements (including compound views, table, and charts).
• Created and configured Interactive dashboards to alert the employees as per the requirements.
• Worked extensively on performance tuning including creating aggregate tables, caching and usage tracking.
• Used the Catalog manager and maintained the Analytics web catalog to manage Dashboards, Answers and Delivers.

Confidential, Park Ridge, NJ

OBIEE Developer/Business Analyst

Responsibilities:

• Worked with Business Groups to identify, analyze, and document Business Requirements.
• Gathered requirements for GAP Analysis, translated them into technical design documents and worked in making recommendations to close the GAP.
• Experience in Preparing 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- ptimized manner.
• Trained the users on how to use the Dashboards and Answers and also modify the stored reports in Answers.
• Involved in Query Tuning to maximize the performance of reports and Dashboards.
• Involved in Performance Tuning of reports by identifying the indexes required on the backend tables and also from the data available in the Cache.
• Involved in customizing out of the box reports to support the business requirements.