Upgrade Post project
DB

diwakar bandapali

chittoor
available

Last update: 06.09.2022

OBIEE/ODI/OAC/BIAPPS Consultant

Graduation: Computer science and Information Technology
Hourly-/Daily rates: show
Languages: English (Native or Bilingual)

Keywords

Skills

Having strong experience in Data Warehousing in Software Design and Development, which includes Customization of various Oracle BI Applications using OBIEE10g /11g/12C/OAC and ODI 11g/12c.
 Experience in OBIA 7.9.6.x/11g, BICS (Business intelligence Cloud Services), Visual Analyzer, and BI Publisher.
Good Knowledge in 11g/ODI 12c, Tableau and Informatica power center9.x.
Good Knowledge on Procurement and spend analytics/HR/Fianance Analytics.
Strong experience in creating complex OBIEE reports using Answers, Dashboards, IBots.
Experience in creating different types of views such as Pivot tables and charts, Narrative view, Tree maps, Word Cloud, Scatter etc. as per the requirements.
Experience in creating Aggregate tables.
Experience in working with physical, BMM, Presentation layer of Repository.
Experience in Creating dimension hierarchies, Measures, Time series functions and Implementing the business logic and level based measures.
Implemented OBIEE security at the Data and Object levels.
Experience in creating Users, Groups, Application roles, Catalog Groups.
Experience in RPD Merging, Upgrade/Down Grade of PRD.
Experience in working with IBOTS and Job manager and Catalog manager.
Experience in Performance tuning of the reports.
Experience in handling Administration Activities.
Experience in migration of code between the environments.
 Experience in data warehousing modeling like Star schema, Snowflake schema, and implementing the relationship between Fact/ Dimension tables.
 Experience in identifying the data issues that occurs in both OBIEE and Oracle Data Integrator
Experience in Oracle 10g/11g/12c.
Worked on Informatica Mappings.
Having strong knowledge in mappings using Designer, Created Tasks, Sessions and Workflows using Workflow Manager and used Workflow Monitor to monitor the Workflows.
Having strong knowledge in ODI mappings.
Having strong knowledge in mappings using Designer, topology.
 Having good knowledge on Knowledge modules.
Having good knowledge on ODI 12c components.
Having good experience in administration activities.

Project history

03/2017 - Present
Solution Architect

Environment:  OBIEE 11g/12c, BI Publishers, ODI 11g/12c, Oracle11g/12c.

 Project Summary:

This project involved the implementation of BIApps 11g for Finance and HR module for the client. The scope of the project includes configuration and delivery of HR/Finance modules customization of OBIA according to client requirement.They also have mutiple sources where we have to implement the custom design for SPP /MSAP and PPP data. 

Roles and Responsibilities:

  • Creating Technical and functional design documents as per the client requirements.
  • Doing a peer review of technical designs and provide an approval for the same.
  • Building new model / customization of OBIA Repository/Metadata.
  • Creating Physical, Business and Presentation layers in the Repository.
  • Created physical joins and complex joins in Physical and BMM Layer.
  • Created Dimensions Hierarchies and Level base Metrics, Time series functions for various business needs.
  • Performance tuning of the reports.
  • Configuring aggregate tables for the existing BI Apps tables.
  • Implemented OBIEE security at the Data and Object levels.
  • Presentation layer – Create folders /sub-folders.
  • Experience in creating Users, Groups, and Application roles.
  • Create complex reports using Table, Chart, and Pivot and Narrative views and publish them in dashboards using Answers & Dashboards.
  • Unit testing of the RPD code and Reports.
  • Documentation of various activities in the project.
  • Interacted with users for and provide resolution for the issues/ incidents.
  • Migration of objects from one environment another environment.
  • Working on Admin activities.
  • Create Publisher reports as per the business requirements.
  • Identifying the data issues that occurs in both OBIEE and Oracle Data Integrator
02/2015 - 02/2017
Senior Consultant

Environment               : OBIEE11g, Informatica 9.x, Oracle11g. Duration                : Feb 2015 Feb 2017

 

Project Summary:

 

INC Research is leading healthcare company with a broad spectrum of innovative medical solutions. INC is implemented sales force and EBS for their Sales and Marketing Divisions to increase productivity, physician relationships, and decreased downtime and drive times, leading to higher employee and customer satisfaction and increased revenues.

 

Some of the activities / responsibilities include:

  • Involved in requirement gathering / Design and development of reports according to client requirements.
  • Building OBI Repository/Metadata
  • Creating Physical, Business and Presentation layers in the Repository.
  • Created physical joins and complex joins in Physical and BMM Layer.
  • Created Dimensions Hierarchies and Metrics for various business needs.
  • Implemented security at the data and object levels.
  • Worked on aggregate tables to improve performance.
  • Created catalog Groups and set permissions for items in the presentation catalog and privileges and rights to users and groups. Set the subject Area permission for the users.
  • Creating Dashboards, Answers and iBots for various needs of Business
  • Performed Repository Testing and validation before exposing Business Models in the Presentation layer.
  • Developed different kinds of reports (pivots, charts, tabular) using Filters.
  • Unit testing of reports.
  • Migration of code from one environment to another environment.
  • Upgrade/Downgrading of RPD.
01/2015 - 12/2015
Senior Consultant

Environment   :  OBIEE 10g/11g, OBIA 7.9.6.4, Oracle 10g/11g.Informatica 8.x/9.x

Duration          :   Jan 2015 to Dec 2015

Project Summary:
one of the leading healthcare company with a broad spectrum of innovative medical solutions. The Pharmaceuticals is implemented Siebel Analytics for their Sales and Marketing Divisions to increase productivity, physician relationships, and decreased downtime and drive times, leading to higher employee and customer satisfaction and increased revenues.

 

Roles & Responsibilities:

  • Building OBI Repository/Metadata
  • Creating Physical, Business and Presentation layers in the Repository.
  • Created Dimensions Hierarchies and Metrics for various business needs
  • Creating Dashboards, Reports  for various needs of Business.
  • Create the reports like Table, Chart, and Pivot and Narrative views and publish them in dashboards using Answers & Dashboards.
  • Implemented security at object/Data levels.
  • Migration of RPD and Web Catalog from one environment to another environment.
  • Set the subject Area permission for the users.
  • Unit Testing of Reports.
04/2014 - 12/2014
BI Consultant

    Environment           :           OBIEE 11g, OBIA, Informatica 8.6, Oracle11g.

      Duration                :           April 2014 to December 2014.

Project Summary:

  • This project involved the implementation of BIApps 7.9.6.4 HR module for the client. The scope of the project includes configuration and delivery of HR module & customization of the module according to client requirement.

Roles and Responsibilities:

  • Building OBI Repository/Metadata
  • Creating Physical, Business and Presentation layers in the Repository.
  • Created physical joins and complex joins in Physical and BMM Layer.
  • Created Dimensions Hierarchies and Metrics for various business needs.
  • Create the reports like Table, Chart, and Pivot and Narrative views and publish them in dashboards using Answers & Dashboards.
  • Configured iBots to deliver analytics content based on schedule to obtain weekly reports and sent notification Alerts
  • Design business model – Perform Dimension modelling, identify fact tables & measures
  • Documentation of various activities in the project.
  • Interacted with users for effective issue resolution.
  • Logical layer-create – Create logical tables/dimensions, columns, set levels to support drill–down, Aggregation/sum over columns etc.
  • Presentation layer – Create folders /sub-folders.
  • Implemented security at the data and object levels.
  • Unit testing of reports.
02/2013 - 03/2014
OBIEE Developer

Environment   :  OBIEE 10g/11g, Informatica power center, Oracle 10g/11g.

Duration          :  February 2013 to March 2014

Project Summary:

This project involved the implementation of BIApps 7.9.6.4 procurement and spend analytics module for the client. The scope of the project includes configuration and delivery procurement and spend analyticsAnalytics module & customization of the module according to client requirement.

Roles & Responsibilities:

  • Created mappings for populating the data into the dimension, facts, and lookup and history tables from sources systems.
  • Worked extensively on Oracle database 10g and flat files as data sources.
  • Developed and fine-tuned SQL to increase the performance.
  • Developing and unit test Cases.
  • Create the reports like Table, Chart, and Pivot and Narrative views and publish them in dashboards using Answers & Dashboards.
  • Configured iBots to deliver analytics content based on schedule to obtain weekly reports and sent notification Alerts
  • Created Dimensions and Hierarchies and Measures.
  • Documentation of various activities in the project.
  • Logical layer-create – Create logical tables/dimensions, columns, set levels to support drill–down, Aggregation/sum over columns etc.
  • Presentation layer – Create folders /sub-folders.
  • Implemented security at the data and object levels.

Local Availability

Only available in these countries: India
Profileimage by diwakar bandapali OBIEE/ODI/OAC/BIAPPS Consultant from chittoor OBIEE/ODI/OAC/BIAPPS Consultant
Register