We provide IT Staff Augmentation Services!

Obiee Developer And Administrator Resume Profile

4.00/5 (Submit Your Rating)

Cleveland, OH

Professional Summary:

  • Proficient in Debugging, Optimizing and Performance Tuning of Oracle BI Dashboards/
  • Experience with Authentication through LDAP and Authorization to the external tables.
  • Experience in Implementing and Installation/ Configuration of Oracle Business Intelligence Enterprise Edition OBIEE , BI Apps entire stack on Windows and Unix/Linux environments.
  • Dedicated IT Professional with 8 years of IT experience in Analysis, Design, Development and Implementation of data warehousing which includes extensive experience in OBIEE, BI APPS, Siebel Analytics, BI Publisher, ODI and ETL Informatica reporting tools.
  • Experience in interacting with the Business Users to analyze the business process and gathering requirements.
  • Experience in Educational, Pharmaceutical, Banking, Financial and IT industries.
  • Expertise in OBIEE Metadata Repository .rpd using OBIEE Admin Tool by importing the required objects Dimensions, Facts Aggregates into Physical Layer using Connection Pool, developing multiple dimensions drill-down Hierarchies Logical Facts Measure objects in Business Model Layer, and creating Presentation Catalog in the Presentation Layer.
  • Hands-on Experience in configuring Interactive Dashboards with drill-down capabilities using Filters and Dashboard Prompts, OBIEE Security Setup groups, access privileges , Metadata objects and Web Catalog objects Dashboard, pages, folders, and reports .
  • Experience in setting up Security and architecture with OBIEE 11g by using web logic admin console and enterprise manager
  • Configured and scheduled Intelligence Agents iBots to send real-time alerts to the end users using Delivers and created reports using BI Publisher.
  • Creating variables, sequences, user functions, scenarios, procedures, interfaces and packages in ODI.
  • Experience with Oracle BI Applications, specifically Industry Analytics Health Care and Higher Education and CRM analytics.
  • Siebel Analytics Dashboards/Reports by implementing Aggregate navigation, Cache
  • Management and materialized views.
  • Exported reports into various formats like XML, PDF, HTML, EXCEL, and WORD for users.
  • Ability to work in groups as well as independently and initiative to learn new technologies, tools quickly.
  • Good Communication and Interpersonal skills. Technically sound, Result-Oriented with strong Problem solving skills. Innovative efficient.
  • Flexible and versatile to adapt to any new environment with a strong desire to keep pace with latest technologies.

Technical Summary:

Reporting Tools

OBIEE11.1.x, 10.1.x, Siebel Analytics 7.8/7.7/7.5, Oracle Health Sciences Clinical Development Analytics CDA 2.1 , Spectrum 2.1.2.

ETL Tools

Informatica Power Center 9.1/8.6/8.1/7.1/6.2, Oracle Data Integrator ODI

Databases

Oracle 11g/10g

Scheduling Tools

Data warehouse Administration Console DAC

Operating Systems

Windows, UNIX,LINUX

SQL Tools

SQL Plus, SQL Developer, TOAD, SQL Loader.

Applications

BMC Remedy Application, HPQC

Work Experience:

Confidential

Role: OBIEE Developer and Administrator

Confidential is implementing CRM Business Intelligence project as a suite of business intelligence tools, including CRM and business analytics. Overall, these tools will provide insights and data to allow users to gain knowledge about business performance and to understand progress toward goals, including state of the art referral, prospect and pipeline management, access to data and information related to the existing book of business, streamlined and centralized access to consistent data across the user base and the identification of potential trends.

Responsibilities:

  • Interacted with Subject Matter Experts SME , Business Analysts and Users for gathering the business and reports / dashboards requirements.
  • Significantly worked on the RPD, Reports and Dashboards development.
  • Developed Presentation Catalogs in the Presentation Layer.
  • Created Aggregations and Logical Based Measures in Business Model and Mapping Layer.
  • Created Analytical Views Compound Layout, chart, pivot etc. and Global/Local Prompts to design the Dashboards.
  • Created Application Roles using Oracle Enterprise Manager assigned different permissions on dashboards and reports.
  • End users/ functional issues resolution and management.
  • Troubleshooting production support issues, identify the root cause and migrate fixes.
  • Develop reporting standards and best practices to ensure data standardization and consistency.
  • Perform platform administration for Development, test, QA and Production environments.
  • Oracle patch applications across BI environments.
  • Working on Change requests to implement changes.
  • Usage tracking and Performance tuning of OBIEE reports and dashboards.
  • Perform BI releases for the web catalog and RPD migrations from lower environments to higher environments.
  • Perform on-call duties for the production support issues and outages occurring across different environments.

Environment: OBIEE 11.1.1.7, Oracle 11g, SQL server 2008, Windows 7.

Confidential

Role: OBIEE Developer Consultant

The Project is to develop reports and dashboards and provide production support for the citywide performance reporting project.

Responsibilities:

  • Interacted with business users to gather business report requirements.
  • Hands on experience in RPD and Web catalog Migrations.
  • Created Application Roles using Oracle Enterprise Manager assigned different permissions on dashboards and reports.
  • Involved in OBIEE Production support for different Application teams.
  • Created Shell scripts to start and stop the OBIEE instances in Linux environments.
  • Designed and Built Oracle BIEE Repository at 3 layers i.e., Physical Layer connecting Data sources import schema , Business Model / data mapping create Logical tables data source mapping and Presentation Layer level create presentation catalogs , create presentation folders, test and validate the model.
  • Extensively used Presentation Hierarchy/Hierarchical Column to drill deeper into the data, to view more detailed information.
  • Configured and integrated Map Viewer.
  • Used/Suggested Views, Indexes, and Aggregated Tables to improve performance of reports/dashboards
  • Responsible for the design, setup, deployments and maintenance of both the production and non-production environments.
  • Provided production support and maintained OBIEE servers up and running.
  • Performed Administration tasks such as migrating RPD and web catalog across environments and working on production releases.
  • Troubleshooting production issues, identify root cause and migrate fixes. Develop reporting standards and best practices to ensure data standardization and consistency.
  • Implemented Oracle BI Apps CRM analytics to provide a better customer service experience.
  • Monitoring and resolving issues related to data through Informatica and DAC.
  • ETL jobs creation customization using ODI console to manage scenarios and Load plans, monitor sessions and load plan runs, and manage the content of the error tables generated by ODI.
  • Modifying existing ETL jobs in Oracle Data Integrator ODI .
  • Created Proactive Agents /iBots using Delivers delivered using Scheduler services.
  • Create, maintain and manage documentation for all data warehouse and reporting development efforts.
  • Provide on-call support and worked with onsite and offshore teams.

Environment: OBIEE/OBIA 10g/11g 11.1.1.6.2 , Informatica 9.1, Oracle 11g, ODI, Remedy, DAC, SQL Server 2008, Siebel Analytics.

Confidential

Role: OBIEE Developer Consultant

The project is to develop BI reports and dashboards in oracle health sciences clinical development analytics OBIEE 11.1.1.5.5 and provide technical support to the production issues.

Responsibilities:

  • Knowledge on the right fax integration with BI publisher.
  • Performance tuning of reports which have considerably longer durations of returning results for both newly developed as well as those in production as part of production support.
  • Built RTF template reports using BI Publisher reporting.
  • Experienced in using BMC Remedy Application tool for updating the incidents and problem tickets and tracking the issues.
  • Configured Security groups and users using LDAP External Tables in EM/Console.
  • Migrated Repository Web Catalog from Development to QA, Break-Fix Production server using Oracle Enterprise Manager/Catalog Manager.
  • Significantly worked on the RPD development.
  • Documented Configuration and design specific documents, Report request and report development specification documents for the new reports and for the enhancements made to the existing reports and dashboards.
  • Implemented the Direct database SQL in escalation tool reports for better performance of the report.
  • Implemented Write back functionality and deployed analytics res in Web logic.
  • Life-cycle support for migration efforts from development to QA to production analytics.
  • Performed deployments from break-fix to production environment for APEX-CODA reports.
  • Created, modified and formatted reports/dashboards, using different views i.e. pivot table, charts, and filters in analysis. Built new reports as per business needs.
  • Development experience with Oracle BI Apps Industry Analytics Health Care , implemented the Clinical Development Analytics CDA and Oracle clinical Health sciences Clinical Development Analytics for developing the reports and dashboards as per the business requirements.
  • Designed and Built Oracle BIEE Repository at 3 layers i.e., Physical Layer connecting Data sources import schema , Business Model / data mapping create Logical tables data source mapping and Presentation Layer level create presentation catalogs , create presentation folders, test and validate the model.
  • Development of reports according to the report request in Spectrum clinical trial management system and CDA and designing the respective report design specifications document.
  • Interacted with Subject Matter Experts SME , Business Analysts and Users for gathering the business and reports / dashboards requirements.
  • Coordinate with the offshore team.

Environment: OBIEE 11.1.1.5.5, CDA 2.1, SPECTRUM 2.1.2, Oracle 10g 11g, SQL server 2008, LINUX, Windows 7, BI Publisher.

Confidential

Role: Sr. OBIEE Developer Consultant

The Confidential system information services department is engaged in the effort of upgrading OBIEE 10g dashboard and reporting toolset and Oracle BI publisher 11g reporting tool along with other software packages supporting its Business Intelligence.

Responsibilities:

  • Configured the BI Delivers scheduler to schedule reports.
  • Worked on migrating objects like Forms, Reports and PL/SQL procedures.
  • Developed different levels of Security set-up for the entities of the application on both Repository file and the Web Catalog File using OBIEE 11g.
  • Developed ad hoc reports as per the business requirements.
  • Created Analytics Reports including Charts and Pivot tables using OBIEE Analytics for the end users.
  • Developed Dynamic / Interactive Dashboards with drill-down capabilities, charts, tabular using global and local Filters and also using different Analytics Views.
  • Worked on OBIEE metadata development, Configured Repository Physical layer, BMM Layer and Presentation Layer and Migration of Reports and Dashboards.
  • Participated in complete life cycle of the project from project initiation, to development, to production support and maintenance.
  • Responsible for full life cycle implementation of OBIEE
  • Interacted with Subject Matter Experts SME , Business Analysts and Users for gathering the business and reports / dashboards requirements.
  • Involved in the migration of OBIEE 10g to OBIEE 11.1.1.6.2.
  • Developed Performance Tuning Strategies for optimizing the performance.
  • Performed unit testing and system testing of all components of OBIEE Analytics.
  • Involved in setting up the environments for Development, Unit Testing, System Testing and Production for the developers and testing teams.
  • Created an initialization block to retrieve allowable values.
  • Involved in GAP Analysis and requirements gathering of the various work streams by meeting with the Business Analyst and Business Users and base lining the details.
  • Performed OBIEE upgrade, testing and UAT.
  • Organized testing schedules and test scripts. Managed execution and sign-off tests and also played an active role in product rollouts.
  • Coordinated with offshore team and handled the situations very well.
  • Attended daily review meetings and weekly status meetings.

Environment: OBIEE 10.1.3.4 11.1.1.6.2, Oracle 10g 11g, Informatica 7.1.3, SQL server 2008, LINUX, Windows 7.

Confidential

Role: Sr. OBIEE Developer Consultant

Confidential is a pharmaceutical service company offering clinical, commercial, consulting and capital services. The project involved in the management of the clinical trials, data, projects providing the customers with sales force, product and brand solutions. Provided the required data- driven recommendations to the users in creating strategic partnerships through financing and operational solutions.

Responsibilities:

  • Strong Knowledge on forms, Reports and PL/SQL procedures.
  • Attended defect review meetings and weekly status meeting.
  • Extensively involved in performance tuning.
  • Implemented, Configured and Tested Data security and Dashboard security in OBIEE 11g.
  • Configured the BI Delivers scheduler to schedule reports.
  • Dashboards Implemented were for Financial Analytics, Procurement and Spend Analytics, Supply Chain Analytics. Some minor customization was done on the Dashboard level.
  • Performed Order Management and Inventory Analytics.
  • OBIEE BI Apps packaged analytics installation for demonstration purpose configuring DAC, setups and running processes .
  • Created comprehensive and easy-to-understand Documentation of the complete implementation of the Customer Sales Business modules Reports, Dashboards, Security and Star schema .
  • Build test cases and tested the Reports/Dashboards by comparing the SQL Output on the Data warehouse to the values in the Reports/Dashboards, documented the test results.
  • based on various data sources.
  • Integrated OBIEE and BI Publisher and Scheduling BI Publisher reports and Created BI publisher reports
  • Created Database Report Layouts Using BI Publisher Desktop Template Builder in MS Word.
  • Enhanced the performance of Reports/Dashboards by implementing the Aggregate tables.
  • Created Security Settings in Oracle Administration Tool to Provide Access Privileges and Query Privileges and also managed security for Groups in BI Analysis.
  • Configured clusters on WebLogic using the WebLogic Console.
  • Knowledge on creating Informatica workflows.
  • Experience in creating dimension table type1 and type 2 mappings.
  • Created Analytical Views Compound Layout, chart, pivot etc. and Global/Local Prompts to design the Dashboards.
  • Created Aggregations and Logical Based Measures in Business Model and Mapping Layer.
  • Developed Presentation Catalogs in the Presentation Layer.
  • Developed and customized some of the existing Dimensions Drill down Hierarchies Logical Objects in Business Model and Mapping Layer.
  • End to End repository creation, reports creation, prompts, dashboards and data modeling in OBIEE 11g on Oracle 11g database.
  • Worked extensively on OBIEE Repository, that includes Physical Layer, Business Model layer and Presentation Layer using OBIEE Administration Tool.
  • Organized testing schedules and test scripts. Managed execution and sign-off tests and also played an active role in product rollouts.

Environment: Oracle Business Intelligence Enterprise Edition OBIEE 10.1.3.4 11g, Oracle 10g 11g, Informatica 8.6, DBI 8 with EBS R12,Oracle e-Business Suite R12,Data Warehouse administration Console DAC , Oracle BI Publisher, Oracle Delivers, SQL, PL/SQL, and TOAD 6.3/7.0, Windows XP, UNIX/LINUX.

Confidential

Role: OBIEE Developer Consultant

Confidential is a multinational financial services company, known for its best credit card, charge card and travelers check business, and the highest of any card issuer. The project objective is to extract data stored in different databases such as Oracle SQL Server and to finally load it into the data warehouse repository. OBIEE/Siebel Analytics was used to build interactive reports, responsible for the design, development and implementation of data models.

Responsibilities:

  • Configured and created repository using OBIEE 10.1.3 Admin Tool.
  • Created numerous executive level reports. Dashboards were generated to provide insight into the marketing and financial data.
  • Designed schemas using the fact, dimension and extension tables, by creating logical joins in the physical layer.
  • Created groups and users to manage the security privileges for each subject area in RPD and dashboards according to user requirements.
  • Analyzed and validated the Oracle BI repository by performing consistency check as per the oracle best practices.
  • Designed and customized RPD's, Oracle Answers, Dashboards and Cache.
  • Generated various Analytics Reports like formulary report and Direct Sales Report using global and local filters.
  • Created different types of Customized Reports Drilldown, Aggregation to meet client requirements.
  • Developed custom reports/Ad-hoc queries using OBIEE Answers and assigned them to application specific dashboards.
  • Created saved several BI Publisher reports by selecting an Analysis request as Data Source.
  • Involved in managing appropriate Security privileges on subject areas and dashboards according to business requirements.
  • Created proactive agents iBots and interactive Dashboards to alert the Marketing team about business changes.

Environment: OBIEE/ Siebel Analytics 10.1.3.1/7.7.1 BI Answers, BI Dashboards, BI Scheduler , Peoplesoft data source, Oracle BI apps DAC , Informatica Power Center 8.6.1, Oracle 10g, SQL, PL/SQL, and TOAD 6.3/7.0, Windows XP.

Confidential

Role: OBIEE Developer

Confidential based in Confidential, manages the nation's largest database of workers compensation insurance information. The purpose of this project is to create and maintain a central data warehouse and to create reports for the financial group for further business analysis. Siebel analytics was implemented for the generation of the reports.

Responsibilities:

  • Created presentation layer catalog folders, to show different views of the business model to different users and assigned group permissions to the catalog folders.
  • Customized and developed repository, configured metadata objects Subject Area, Table, Column and Web Catalog Objects Dashboard, Pages, Folders, Reports .
  • Configured measures in the Business Model Layer and mapped to multiple logical source tables.
  • Worked on Siebel Answers to build Interactive Dashboards with drill-down capabilities.
  • Assisted in creation of pivot table request allowing manager to analyze the business from different perspectives.
  • Created templates for presenting results and Analytics and modified the Siebel Dashboard using cascading style sheets.
  • Built Repository at 3 layers Physical Layer connecting Data sources import schema , Business Model data mapping create Logical tables data source mapping Presentation layer level create presentation catalogs , create presentation folders, test and validate the model.
  • Design Customize Siebel Answers Views charts, Create save Filters, Create Charts Tables in Siebel Answers.
  • Created Users and user groups in Siebel Analytics web.
  • Configured published iBots to deliver analytics content based on schedule, automate iBot queries to obtain Daily weekly Transactions to all Departments in Organization by Email.

Environment: OBIEE 10.1.3.4, Informatica Power Center 8.1, Power Mart, Oracle10g, DAC, SQL, PL/SQL, UNIX, HTML, Windows XP.

Confidential

Role: OBIEE Developer Consultant

Confidential is one of the nation's largest international insurance and financial services operations and is a leading provider of automobile and homeowners coverage's commercial property and casualty insurance, investment products, employee benefits.

Responsibilities:

  • Interacted with Case Services Management business representatives for gathering the Reports/ Dashboards requirements and to define business and functional specifications.
  • Identified the GAP's by analyzing the CS Data Mart instance and provided alternative solutions as well recommended changes to database.
  • Designed and developed the OBIEE/Siebel Analytics Metadata Repository .rpd using OBIEE/Siebel Analytics Server Admin tool by importing the required objects Dimensions, Facts Aggregates with integrity constraints into Physical Layer using connection pool, developing Multiple Dimensions Drill-Down Hierarchies Logical Facts / Measures objects in Business Model Layer, and creating the Presentation catalogs in Presentation Layer.
  • Developed many Reports / Dashboards with different Analytics Views Drill-Down / Dynamic, Cascading Style Sheets, Pivot Table, Chart, View/Column Selector, Tabular with global and local Filters using Presentation Services/Siebel Analytics Web.
  • Configured iBots to deliver Analytics content based on schedule, automated iBot queries to obtain daily and weekly reports.
  • Implemented Security by creating roles web groups, checks with External tables and LDAP.
  • Debugged reports and Dashboards visibility with respect to user's responsibility and web groups in an integrated environment.
  • Performance Tuning of Dashboards/Reports and made recommendations for changes to database by implementing the materialized views, partitions, re-building of indexes, overwriting the SQL execution path by making use of hints etc.,
  • Performed Unit, Integration, and Regression testing of various Dashboards / Reports and Repository.
  • Worked closely with Users, Developers and Administrators to resolve ongoing Production Problems by reviewing design changes made to production systems and made corresponding changes to OBIEE/Siebel Analytics Repository.
  • Performing the benchmark for up gradation process from OBIEE/Siebel Analytics to Oracle Business Intelligence.

Environment: OBIEE 10.1.3.2, Oracle ware house builder 10g, Informatica Power Center 7.8, Oracle 10g, Windows XP.

Confidential

Role: Siebel Analytics Developer

The project was in the sales department to develop and provide better decisions in the sales analysis and developing reports for measuring sales activity of products. The project involved customizing sales application by implementing reporting system by using Siebel Analytics, Informatica and Oracle database.

Responsibilities:

  • Gathered requirements, functional and technical specifications and interacted with business managers and end users.
  • Used Metadata Design Principles to design Repository .rpd based on business requirements and followed Best Practices.
  • Localized Siebel for business users to support globalization for deployment.
  • Set up Analytics Multi-User Development environment for developers.
  • Built the Physical Layer /Business Model and Mapping Layer/ Presentation Layer of a Repository by using Star Schemas.
  • Configured facts, dimensions and Hierarchies.
  • Implemented aggregate tables for better analytics performance.
  • Implemented reporting cache to faster response time.
  • Developed custom dashboards and reports using Siebel Answers.
  • Scheduled the developed reports according to client requirements.
  • Created proactive agents called iBots to alert the related team to notify about the business changes.
  • Tested and validated the repository, reports and dashboards.

Environment: Siebel Analytics7.7, Informatica 7.1, Oracle 9i, TOAD, UNIX, Windows XP.

We'd love your feedback!