Presently on assignment and looking at other opportunities.                                          

James VanAuken

Resume  <- click here   

Solutions/Data Architect specializing in Oracle Business Intelligence.

My new Data Modeling process dated 1/11:   New Thinking

Overall OBI EE Pitch dated 1/10 - The Data Warehouse is the Plumbing     -   OBIEE Power Point Pitch 

OBI EE and Data Warehouse my thoughts - From Data Warehouse perspective

  BI specialist. 

Twenty years of successful experience in the development of data architecture(s) and implementation of Data Models (OLTP) and Data Warehousing - DataMart - ODS with no failures.  Skilled in the full implementation of the end to end solution from ETL to the display of data via a Portal. 

Goal is to establish clients as competitive leaders in the strategic use of information. My business centric approach to data warehousing ensures that the warehouse delivers clear value. Anything less is unacceptable. Whether you’re just getting started, expanding, or realigning with the business, you can count on my services to ensure your success.

Ability to provide an entire Oracle solution for Business Intelligence.  Complexity of the BI solution has increased along with added capabilities.  Recent assignments have provided involved the solutions architecture from the data modeling - ETL and resulting portal implementation.

Each engagement is tailored to address specific client requirements. I will proactively transfer knowledge and skills, leading to client self-sufficiency during project development.  I am very much a team player and will involve the existing IT resources when possible.

  •    Summary of my experience, click here ---------------------------------------    Summary

  •    Note for recruiters, click here-------------------------------------------------      Note

email:    If you would like a phone conversation it is best to email myself with a time.

Other topic:   My wife is fast becoming an accomplished artist go to:  


Business Intelligence Suite Tool Vendors

Experienced with most BI Suites including Oracle 10G and all components, SAS, Cognos Version 8, Business Objects Version XI, Information Builders / WebFOCUS, Microsoft SQL Server 2005, Microstrategy Version 8.

  •     I have been evaluating these tools since 10/2005, for my evaluation go to  ---------        BI Tool Evaluation 
  •     Selection and Evaluation of BI Tools-------------------------------------------------        BI Selection and Evaluation
  •    My explanation of OLAP (as related to Oracle OLAP DML) - ROLAP - MOLAP -        OLAP Explained

  •    An Executive Summary of Portals and their use with BI -------------------------------        Portal Defined

Extract Transform & Load (ETL) Tool Vendors

  • I have evaluated and used many ETL tools.  The specific tool which is best for a particular environment will depend upon databases in utse.  For example an ETL tool for SQL Server will not necessarily be the same as for an environment with Oracle and Sybase.   Trend is for the large database vendors to package the ETL tool with their systems, this can be evidenced by IBM's recent acquisition of DataStage (April 2005), Oracle with OWB and MS SQL Server 2005.
  • Caution is advised in your selection of the ETL tool since the success of the Data Warehouse will depend on this particular tool which is key to loading data in a manner which is dimensional, handles data complexities effectively and maintains history.

This site's purpose is as follows:
  • Provide information helpful to employers considering myself for potential consulting assignment.
  • Publish my professional comments about data warehousing and decision support
  • Add papers as I develop that would be useful to data warehouse professionals.
For a definition of data warehousing, click here . For some suggestions on how to begin to learn about data warehousing, click here . - Good luck with your learning.

This site was last updated on 08/24/2016                                                                            

James VanAuken - Professional Website

Oracle Business Intelligence