it_user290082

Big Data / Business Intelligence / Datawarehousing at DWgrain (Client Health BIS)
Has 10+ Years Of Experience

Badges

75 Points10 YearsTop 20

User Activity

Over 8 years ago

Is your business a disconnected business Aren't the legacy systems being synchronized? Is your cloud systems not being synchronized with on premisses-legacy systems? Does your business already have transactional systems such as ERP, CRM in the cloud? And you need to push…

Over 8 years ago

Commented on The topology gives me total freedom in switching between technologies / ETL agents.

I totally agree with the points you mentioned.

Over 8 years ago

Commented on It allows us to create scripts and share them across multiple data load processes.

In response to "reviewer746463 Item#1 - For all main objects in ODI, such as PKG, Interface/Mappings, Procedures, variable, KM there is a "version" tab/ kind of property of the object. Once you navigate in there, you will be able to see the following: "Created By"…

Over 9 years ago

Commented on All our systems can be widely integrated by ODI, such as transactional systems, our data warehouses, and B2B integration.

You can find more about the ODI history on the link : http://www.oracle.com/us/corporate/press/016802_EN

Over 9 years ago

Commented on If it doesn't connect out-of-the-box to a specific technology, we can add a new technology into it

Hi Rodrigo That is good to know those limitations on integrating ODI with EPM applications . In terms of the main RDBMS in the market I think ODI is quite good in providing the native drivers, when they don't we can find it and place on the ODI drivers folder and works but…

Over 9 years ago

Commented on I have used it to improve run-times of many corporations' overall integration run-times.

Hi Brian, it is a nice review About the room for improvement I saw you mentioned the error handling, in that aspect we handle that in packages when exceptions happens during the data flow / load for example, someone changes a column name in one of the table sources then…

Over 9 years ago

Commented on Comparison of SAP BO, Tableau, QlikView, Cognos, Microsoft, OBIEE and Pentaho

I would like to add another comment about how hard it is to find documents and manuals on SAP BI products if you don't have a support account, or even a simple document or if you need to do an evaluation, a proof of concept of the product you need to pay, whereas if you…

Over 9 years ago

Commented on ODI makes data transfer easy. Improved reconciliation and external authentication would be helpful.

ODI Infrastructure wise I think it comes down to the infrastructure and network team understanding what are required to run the tool smoothly , also having a proactive and helpful DBA who really understands the nature of a database for DW, essentially the difference and…

Almost 10 years ago

Commented on ODI is a flexible tool that can adapt to fit your business, not the other way around.

But one of the beauties of ODI is exactly that flexibility in integrating several different platforms/technology, for example, say you have a data source on SQL server database and your target database is Oracle and you want to apply a sql server function, in your interface…

Almost 10 years ago

Contributed a review of Oracle OBIEE: End-users can cross the data from dimensional models with external Excel spreadsheets.

Almost 10 years ago

Commented on It allows us to create scripts and share them across multiple data load processes.

Which platform/ Technology are you using as a target ?

Almost 10 years ago

Commented on It provides good integration with other Oracle products.

That is true!! the integration with other Oracle products is great and enable several business functionalities, some of the examples I have seen and worked on are the integration of OBIEE and BPEL(SOA) with ODI, for example, when you have OBIEE in your environment one of…

About 10 years ago

Contributed a review of Oracle Data Integrator (ODI): All our systems can be widely integrated by ODI, such as transactional systems, our data warehouses, and B2B integration.

Projects

Over 10 years ago

Large ETL/ Data Integration Project for one of

Large ETL/ Data Integration Project for one of the largest Airline Companies in Brazil, project(Loyalty Program Air points) IBM, Data Integration (from Sales Force to Oracle DW)

Experience

Other Skills

Oracle Database/ Data Modeling (Relational, Dimensional and Object oriented)

Reviews

Almost 10 years ago

Oracle OBIEE

End-users can cross the data from dimensional models with external Excel spreadsheets.

About 10 years ago

Oracle Data Integrator (ODI)

All our systems can be widely integrated by ODI, such as transactional systems, our data warehouses, and B2B integration.

Answers

Over 8 years ago

Cloud Data Integration

Oracle ICS vs ODI

Comments

Over 8 years ago

Data Integration

The topology gives me total freedom in switching between technologies / ETL agents.

Over 8 years ago

Data Integration

It allows us to create scripts and share them across multiple data load processes.

Over 9 years ago

Data Integration

All our systems can be widely integrated by ODI, such as transactional systems, our data warehouses, and B2B integration.

Over 9 years ago

Data Integration

If it doesn't connect out-of-the-box to a specific technology, we can add a new technology into it

Over 9 years ago

Data Integration

I have used it to improve run-times of many corporations' overall integration run-times.

Over 9 years ago

BI (Business Intelligence) Tools

Comparison of SAP BO, Tableau, QlikView, Cognos, Microsoft, OBIEE and Pentaho

Over 9 years ago

Data Integration

ODI makes data transfer easy. Improved reconciliation and external authentication would be helpful.

Almost 10 years ago

Data Integration

ODI is a flexible tool that can adapt to fit your business, not the other way around.

Almost 10 years ago

Data Integration

It allows us to create scripts and share them across multiple data load processes.

Almost 10 years ago

Data Integration

It provides good integration with other Oracle products.

About me

Big Data / Business Intelligence / Data Warehousing Solution Architecture and development.
Data Warehouse best Practices, DW optimization and performance enhancement (Slowly Changing Dimensions, Change-data-capture, Materialized views, partitioning techniques, Oracle database administration), Dimensional, relational and Object-Oriented data modeling.
Data Base performance tuning.
ETL process: Oracle Data Integrator(ODI 10g, 11g, 12c), Informatica Power Center, Microsoft SSIS
Data visualization: Oracle Business Intelligence Enterprise Edition(OBIEE 10g, 11g, 12c) and Microsoft Power BI

Certifications

Oracle Business Intelligence Foundation Suite 11g Certified Implementation Specialist
Oracle Business Intelligence Foundation Suite 11g PreSales Specialist

Employers

Health BIS
Vodafone
Accident Compensation Corporation (ACC)
Housing New Zealand Corporation
Stellar Consulting
Trustpower
CDS /PRODESP (Data processing Company of São Paulo State) Public Company
Odebrecht Realizações Imobiliárias
Keyrus / Net Services (Brazil´s largest Cable TV operator with revenues around US$ 500 million )
Complex IT Services
IBM (Brazil)
Politec / PRODESP (Data processing Company of São Paulo State) Public Field Company
Politec/ ETF- Itaú(Largest´s Brazil private bank)
INAC SISTEMAS ( Private Company, Partnership with Hotels )
Teletech Brazil/Chatter Communications (cabo TV, internet provider and Phone) in USA
Nestle

Education

TDWI
Caldwell Community College and Technical Institute
Faculdade Impacta de Tecnologia
CETAX
Oracle University
Faculdade Sao Luis

Interesting Projects and Accomplishments

Over 10 years ago

Large ETL/ Data Integration Project for one of