SUMMARY:

• Solution oriented IT Professional with broad based knowledge in Systems Design and Development, implementing and integrating cost - effective, high performance technical solutions to meet challenging business needs.
• Excel in strategic planning, implementing best practice methodologies and consistently improving delivery times and service levels while reducing costs.
• 9+ years’ experience in Oracle Business Intelligence Enterprise Edition 11G, as well as Knowledge on ETL tool using ODI to complement the OBIEE skills for integrated OBI Apps.
• Experience in extraction of data from various Heterogeneous sources (Relational database, Excel) to load into data warehouse/data mart targets.
• Worked extensively on OBIEE Administration Tool involving all the 3 layers namely Physical Layer, BMM Layer and Presentation Layer.
• Extensive experience in OBIEE security models implementation and OBIEE Environment administration (MUDE creation, configuration and Support).
• Strong in OBIEE Metadata development including (Projects, Migration, Deployment, Applying patches, Maintenance etc.)
• Excellent aptitude in translating high-level business requirements into logical business dimensional model, building business models, configuring metadata, Answers, Delivers / iBots, creating reports, Dashboards, cache monitor.
• Expertise in Business Model development with various functionalities like Dimensional Hierarchies, Measures, Aggregation Rules, Time Series and other functions.
• Skilled with Caching & Mapping, data-level and object-level security, MUDE, Integration Variables/Initialization Blocks configuration.
• Highly skilled in building Interactive Reports / Dashboards with different Analytics Views, Drill-down & Drill-across capabilities using global & local Filters, Business rules with User Identity & Roles, Profiles & Personalization
• Knowledge of implementing the Oracle BI Security Setup (groups, data access), Metadata Objects (Subject Area, Table, and Column) and Web Catalog Objects (Dashboard, Pages, Folders, Reports).
• Debugging, Optimizing and Performance Tuning of OBIEE Reports and Dashboards to improve performance at Database.
• Proficient in working on production and development environment in different RDBMS in Oracle 11g.
• Excellent communication skills with an ability to technically express complex business concepts, Good organizational skills, outgoing personality, Self-motivated, hardworking, ability to work independently with little or no supervision or cooperatively in a team, sincere, eager to learn, ability to grasp quickly.

TECHNICAL SKILLS:

Applications / Modules: OBIEE 10g/11g, BI Publisher 10g/11g, ODI 11G/ Tableau 8.3.5

Languages: SQL, HTML, XML, Java Script Strong hands on experience with OBIEE 11g

Operating Systems: MS Windows

Software: Microsoft Office Suite, including MS Project, XML, Web Services

Databases / Tools: Oracle SQL Developer, Toad, SQL Plus

OBIEE Versions: 11.1.1.9.0 , 11.1.1.7, 11.1.1.5.0 , 10.1.3.4.1

PROFESSIONAL EXPERIENCE:

OBIEE DEVELOPER / OBIEE ADMINISTRATOR

Confidential, Miami, Florida

Responsibilities:

• Gathered technical requirements, Developed and Supported corporate financial dashboard for business insight and multi-dimensional analysis to deliver timely and accurate financial results and key performance indicators
• Worked extensively on all 3 layers of RPD to make modifications and add value based on the user’s requirements.
• Supported and created new application roles within OBIEE as well as provisioning and revoking access to new and terminated users.
• Worked as first line support between the Business and the BI team
• Periodically trained new and old users on the functionality of OBIEE
• Acted as the gatekeeper for Production and all lower environments of OBIEE, ODI and all Databases assigned to the BI Team and some business Analysts.
• Was Responsible for all RPD and Catalog migration to production and lower environments
• Monitored the operational status of the Oracle BI (OBIEE) application, including usage statistics, query data access patterns, and query response time and worked weekends and after hours as needed to install patches or trouble shooting issues within OBIEE
• Analyzed, Investigated, and provided resolution to end-user reported ad hoc query and standard report issues
• Analyzed, Investigated, and provided resolution to data integrity and validation issues
• Developed new OBIEE reports and dashboards to meet end-user business requirements

OBIEE Developer

Confidential, Jefferson city, Missouri

Responsibilities:

• Worked closely with the business Analysts, business users and developers to gather business requirements, analyze and implement into project.
• Complete requirement analysis, by helping to capture, document and prioritize the customer’s business and technical needs.
• Participated in the design and implementation of the metadata and reporting end of the solution. This includes testing and at times the deployment of the components.
• Ensure that development activities adhere to the team’s standards and best practices so that overall business intelligence data integrity is maintained.
• Built the RPD within OBIEE, which includes the physical, business and presentation layers following the company’s standards, to meet the business requirements of the project.
• Proactively communicate issues to team to assist in managing defects.
• Testing of the repository, reports and dashboards to make sure they meet business requirements after complete development. create reports using multiple views and also utilizing presentation variables to dynamically change report columns and titles with changes within the dashboard prompts.
• Created Dashboard with dashboards prompts including dashboard objects like, text, action link, embedded contents.
• Created Project home page with navigation links to different dashboards and reports, utilizing HTML context in all the dashboards
• Provided conditional filtering for some columns in the RDP level and for specific columns in the report level.
• Created object level security to dashboard folders and dashboards, including individual reports within certain catalog folders.
• Providing support to other team members on repository, reports and dashboards issues.
• Created Test data and imported into schema tables.
• Scheduled report to deliver to users' emails and dashboards using specify conditions.
• Experience in creating executive reports with BI Publisher integrated with OBIEE.

OBIEE Developer

Confidential, North Brunswick, New Jersey

Responsibilities:

• Involved in translating high-level business requirements into logical business dimensional models.
• Configured Metadata Repository (.rpd) using OBIEE Administration Tool.
• Imported Physical tables from Oracle database and defined relations between Physical tables at the Physical Layer.
• Worked on developing OBIEE repository at three layers- Physical Layer, Business Model and Mapping Layer and Presentation Layer.
• Developed Business Facts and Dimensions and defined logical relationship between them at the Business Model and Mapping Layer.
• Designed and developed BI Apps Metadata for Financial Analytics, Procurement and Spend Analytics.
• Created Dimension Hierarchies, Aggregates and Keys in the Business Model and Mapping Layer.
• Created Repository and Session Variables to achieve desired functionality.
• Created Reports and Dashboards by using Report features like Pivot tables, charts and view selector using Local and Global Filters.
• Worked with Global Prompts, Column Selectors, Automatic Drill-Down and navigation.
• Created Web groups for security purposes with access privileges and also assigned data Level and object Level security to users.
• Worked on customizing Reports' look and feel using Column Formatting and Conditional Formatting.
• Developed interactive Dashboards using OBIEE Answers and interactive reports in BI Publisher using Analytics requests and assign Permissions to those dashboards to users depending on their user group.
• Experience in configuring complex reports and dashboards from multiple subject areas.
• Performed Cache management.

Environment: OBIEE 11.1.1.7.0 , BI Publisher 11.1.1.7 Informatica Power Center 9.0.1, Erwin, Oracle 11g, DAC, Oracle EBS, Windows XP

Oracle BI Developer

Confidential, Dallas, TX

Responsibilities:

• Created reports and dashboards for review by the business users.
• Created metadata repository (.rpd) as per business requirements at three layers in Oracle BI Administration Tool.
• Defined Physical Diagram by defining foreign key Joins and developed Business Diagram in BMM layer to define Business Model and requirements.
• Defined multiple Dimensions (Drill-Down Hierarchies) & Logical & Facts /Measures objects in Business Model Layer, and created the Presentation catalogs in Presentation Layer.
• Developed calculated measures and assigned aggregation levels based on dimension hierarchies in BMM layer.
• Developed and debugged many Reports and intelligence Dashboards using different Analytics Views (Pivot Table, Pie/Bar Chart, and View/Column Selector, Narrative View), Dynamic / Interactive Dashboards with drill-down capabilities using global and local Filters.
• Dynamically used Filters and provided customized prompts appropriately to avoid excessive data showing up reports using variables.
• Worked on the Time Series function and implemented time comparison using To Date and Ago functions.
• Worked with materialized views and aggregates to improve performance.
• Maintained Agents / iBots based on time and conditions to schedule and alert messages and group mails to the business users.
• Administered the Cache parameters and implementing the cache feature for improving the BI Server performance Create users and groups and assigning the security privileges.
• Experienced in BI Publisher, MS Office Plug-in for rich reporting and implemented conditional formatting using OBI Publisher.

Environment: OBIEE 11.1.1.5, 10.1.3.4.1 , BI Publisher 11.1.1.5, Oracle 11g, 10g, OLAP, SQL Developer, PL/SQL, Informatica 9.5.1, 8.6.0, Windows