Obiee Consultant resume example

• Managed the releases for the BI Platform and the Custom BI enhancements, worked in developing & customizing BI solutions using OBIEE, Informatica and Oracle DAC.
• Monitoring daily ETL runs and troubleshooting for any issues.
• Experience in ETL analysis for performance tuning.
• Co-ordinates in Migration related activities across various instances, Customer Acceptance Testing and Production release.
• Involved in major configuration tasks and testing of WebLogic Patch Upgrade for OBIEE, Single Sign on & Exalogic Implementation on various environments.
• Active participation in the discussions on Process Improvement and Optimization of BI Platform tools.
• Extensively worked as an Onsite-Offshore Coordinator, managed a team at offshore and team at client location.
• Reporting: As Project lead work on providing effort estimation, Status tracking, Status Reporting to CAB meeting, Daily Status Report, developed Monthly OPS metrics Presentation.
• Involved in actively coordinating with business team and functional team to gather business requirements and doing fit-gap analysis and lead the offshore team on project deliverables on time.
• Worked in design and developing new reports based on user requirements and making sure the development effort is compliant with the requirements and its time lines Involved in data modeling and translating them to design in RPD.
• Worked on providing the RICEF / Report design document for various projects and enhancements.
• Extensively worked on Project management activity such as providing the BI Track reports on all list of enhancements & bug fixes and report the exact status & project metrics to Client leadership team.
• Involved in creating Change Request Tracker to consolidate all list of changes after the initial requirements have been frozen.
• Reviews and evaluates the testing requirements and developed proposal to update/redesign present testing strategy in order to continue & meet quality verification and validation needs.

Project: OBIEE Upgrade 

• Extensively worked on upgrade of OBIEE 10g to OBIEE 11g which involve both RPD and Catalog reports.
• Design and develop new reports based on user requirements.
• Performed Installation of Repository Creation Utility and OBIEE 11.1.1.3 on Windows Server 2003 Environment.
• Upgraded RPD and Catalog from OBIEE 10.1.3.4.1 to OBIEE 11.1.1.3 by using ua.bat file.
• Worked in data modeling and translating them to design in RPD.
• Real good experience in Installation of OBIEE 10g and OBIEE 11g on Linux and Windows Platform.
• Worked with functional team for requirement gathering from business users and provided technical design solutions based on their requirements.
• Extensively worked in analysis of existing (10g) RPD and catalog objects in development environment and consolidation of the existing 10g report objects.
• Gap Fit Analysis between Production and Development environments in both 10g and 11g and identified the objects that needed careful upgrade from 10g to 11g.
• Gathered in consolidation of Physical DSNs, related Physical layer- Business Model and Mapping (BMM) layer and Presentation layer objects.
• Troubleshoot and fix issues during the upgrade of RPD and catalog objects.
• Work experience in BULK INSERT and BCP functions for data migration between SQL server databases.
• Works with Functional Team to determine the risk associated with the requirements for developing the Risk Assessment Matrix.
• Establish a release mechanism and timing for transporting implemented fixes and enhancements to production system.
• Knowledge and exposure with all ODI tools - Topology, Security Manager, Designer and Operator and ODI packages, variables, procedures and scenarios using interfaces.
• Experience in various RPD merge options like Full Repository Merge and Patch Merge.

Project: Trilogy - Enhancements

• Implemented end to end-customized application for business.
• Maintained and designed complete documentations such as BPR, issue trackers, training manuals for end users.
• Integrated multiple source system using OBIA OOTB ETL framework using Informatica & DAC and Implemented Financial, Procurement and Spend Analytics.
• Customized various OOTB ETL mappings and built custom DAC tasks, subject areas & execution plans as per business requirements including configuring domain values and transaction types.
• Worked on incremental and full load of data through Data Warehouse Administration Console (DAC) and Informatica.
• Developed the Incremental ETL processes i.e., Mappings & Mapplets using various transformations and Workflows with Sessions/tasks for data extraction from E-Business suite.
• Created Catalog Groups and set permissions for items in the presentation catalog and privileges and rights to users and groups.
• Developed different kinds of reports (pivots, charts, tabular) using global and local Filters.
• Worked in developing Custom SQL Codes for the reports.
• Customized interfaces to load the data from flat files, and other sources to stage and from stage to Oracle HUB.
• Created PL/SQL Packages and Procedures to automatically drop table indexes and create indexes for the tables.
• Involved in migrating DAC repository objects from one environment to another using import & export feature of DAC metadata.
• Developed Ad-hoc and standard Reports/Dashboards with various KPIs, different Analytics Views (Drill-Down, Pivot Table, Chart, score cards, Column Selector and Tabular with prompts, global and local Filters), contextual navigation, business rules with user identity and roles within the OBIEE suite.
• Involved in Implementing the single sign on (SSO).
• Involved in Performance Tuning of reports by identifying the indexes required on the backend tables and also from the data available in the Cache.

• The project involved the implementation of OBIEE 11g and creation/enhancement of existing BI reports.
• With thorough understanding of Oracle R12 modules such as Supply Chain, Project Accounting and Finance developed POCs working with BAs and the Client BI team.
• Worked on design and development of various custom BI solutions for OBIEE reports and ETL strategy using Informatica. Created Multiple Hierarchies and created complex Drilldown Analysis in OBIEE 11g.Enhanced performance by creating aggregate tables and Indexes.
• Traceability document was created to capture all requirements and their corresponding solutions, test cases and deployment.
• Performed administration tasks related to the development and configuration of User roles for BI reports.
• By using Static, Session and Request variables, configured Multiple Currency metrics for various analytics and Performance dashboard.
• Implementation of the Security Setup by creating the Users, Groups, Web Groups in RPD and Web Catalog.
• By updating the NQSconfig.INI file, enabled Usage Tracking and Dashboards to track performance.
• Strong skills in both OBIEE repository and report architecture/development.
• Perform troubleshooting and debugging of defects and production issues in the areas of Informatica, DAC and OBIEE.
• Involved in PMO activities- Estimated the project milestones and their timelines for new RFPs and enhancement requests.
• Extended support given during CAT (Customer Acceptance Testing) done by both BAs and Business Users.
• Involved in tuning the long running reports and improving its performance.
• Made recommendations to improve technical practices.
• Extensively worked in Onsite Coordination for the offshore team and provided support on Ticket management on various applications.

Project: EIM Enhancements

• Used Informatica Mapping Designer to create/update mapping using different transformations required to move data into data warehouse.

• Configuration of out-of-the box and custom Data Analytics of Order Management and Supply Chain.
• Continuously monitor systems & active participation in system capacity planning and optimization strategy to eliminate performance issues.
• Monitoring ETL run times, CPU and I/O times, report execution times, number of users vs report run times and preparing time profiling chart to identify the bottle neck in the various processes.
• Adopt tuning techniques to remove the performance barriers.
• Knowledge in architecture of OBIEE, Informatica tools helped in thorough analysis of backend log files and trace files to troubleshoot any application errors / issues.
• Migration of ETL objects, SQL scripts using Kintana and ClearCase and also migrated OBIEE objects using catalog manager Worked extensively in creating OBIEE reports with Guided navigations, Drill down function, Conditional formatting, Summary detail views, external web links, HTML and CSS formatting options.
• Responsible for creation of Design Documents, Test plan and Test cases, Traceability Matrix with Implementation notes and Back out Plan.
• Involved in Performance Tuning of the various reports.
• Created new Reporting and ETL data models as well as done enhancements to the existing OBIEE reports.
• Developed new dashboards on the business needs, implemented dynamic column naming.
• Configured OBIEE iBots to deliver analytics content based upon schedule and used automated iBot queries to obtain daily and weekly reports.
• Addition of new Tags into the OBIEE 11.1.1.3 instanceconfig.xml file to resolve issues such as default row displays and non-responsiveness of graph engine.
• Created Service Requests (SR's) for RPD and Reports issues and coordinated with Oracle support team for resolution of the Issues Creation and Mapping of Application Roles and Policies using Fusion Middleware Control.
• Migrated Catalog and RPD from OBIEE 10.1.3.4.1 QA Environment to OBIEE 10.1.3.4.1 PROD Environment.
• Deployed OBIEE 11g RPD and Web Catalog by using Web logic Enterprise Manager.
• Resolve RPD Merge issues by apply patch.
• Responsible for the migration of ETL objects and Reports across various instances.

Project: SC Reporting

• Developed RPD Subject Areas by importing metadata into Physical Layer, applied Business rules in the Business Modeling and Mapping layer and created customized user views in the Presentation layer.

• Developed RPD Subject Areas by importing metadata into Physical Layer, applied Business rules in the Business Modeling and Mapping layer and created customized user views in the Presentation layer.

• Implemented Multiuser Development Environment (MUDE) Using Oracle BI Administration Tool.
• Migrated Analytics RPD and Web catalog from one environment to another.
• Created Catalog Groups and set permissions for items in the presentation catalog and privileges and rights to users and groups.
• Designed and Tested Reports in the Dashboards for the Oracle Financial Analytics modules like GL, AP, AR and created the Ad-hoc reports according to the client needs.
• Configured Interactive Dashboard with drill-down capabilities using Filters, Metadata Objects and Web Catalog Objects.
• Applied Cascading Prompts and Multi-Level Prompts on Dashboards.
• Identified issues, performance bottlenecks and optimized the Business Intelligence Dashboards and Reports.
• Deployed OBIEE 11g RPD and Web Catalog by using Web logic Enterprise Manager.
• Responsible for monitoring the Scheduled ETL tasks and Scheduled Dashboards.
• Report and Track Performance Issues to the respective stakeholders.
• Developed different kinds of reports (pivots, charts, tabular) using global and local Filters.
• Wrote Custom SQL Codes for the reports.
• Raised Service Requests (SR's) of various critical status for Reports and RPD issues and coordinated with Oracle support team for resolution of the Issues Applied Optimization Techniques for the better performance of the reports.
• Created ad hoc reports for End Users.
• Knowledge and experience in all the objects configuration & implementation during Production migration.
• Used external tables to Transform and Load data from Flat files into target tables.
• Fixed RPD Merge issues by apply patch and resolving inconsistency errors.
• Trained End Users and Pilot Users about OBIEE Tools.