James VanAuken



Data Architect - Modeler - Oracle BI Implementer / Developer


Twenty years of IT expertise as BI Data Architect, Developer and Solutions Architect.   Refer to my web site for additional background details (www.jvanauken.com).   Technical lead on many projects, mentor and instruct client staff in all aspects of data warehouse and data modeling through the entire SDLC cycle.  Technical skills encompass entire life cycle of BI build.  Successful design and implementation of multiple conceptual, logical and physical data models.  Expert in agile development from initial requirements to implementation of complete BI system.


Master Degrees in both Business & Computer Information Systems (see last page).

Security Clearance:  SECRET (active)



Oracle Data Integrator ODI 12c , Oracle Analytical Workspace Manager AWM for OLAP DML, Oracle Warehouse Builder 11.2, Informatica v.9.5.


Oracle 12c Rel 2/, SQL Server, DB2, Sybase, Teradata


OBIEE 12c/, Oracle Reports/Answers/BI Publisher, Tableau 10, Business Objects Developer Suite 5.1/6.0 , SQL Developer, Cognos.

Job Scheduling Tools

Oracle Workflow, OEM, Control M

Data Modeling

Oracle SQL Developer/Data Modeler, Erwin/ModelManager, Sybase Power Designer V12


Oracle WebCenter/Weblogic-Oracle OBIEE 12c and Oracle Dashboard and Administrator of OBIEE environment including Catalog and Security set up and administration.


MDM Master Data Management, XML

Database Other Apps

TOAD, SQL Developer, Hummingbird V9, SAP R3, PeopleSoft V8 and many others for Data Warehouse.



Achievements – Data Architect – Solutions Architect - Oracle OBI EE

Consulting Assignments


March 2015 – Present          Sawdey Solution Services      Senior Solutions Architect/Systems Engineer

Clients: Dept of Defense, Under Secretary of Defense, Comptrollers Office, Pentagon, Washington, D.C. 

Provide technical oversight for complete replacement of legacy financial systems.  Work with the Project Management Office to provide the optimal solution involving technologies including; Pentacho, OBIEE 12c, Rapid Minor to enable new enhanced capabilities.

Data Modelling techniques using Kimball dimensional were provided (used ERwin) and implemented.

Feb 2015 – Feb 2016                       Infojini Consulting          Data Architect / Data Modeler/ETL

Clients: Maryland Higher Education Commission, Baltimore, MD and State of North Carolina, Raleigh, NC  

Rehired as Consultant to continue work refer to resume item below dated March 2012 – June 2013 for details.

In addition to continuing my data model development (Kimball Approach) and solutions architecture migrating the ETL from OWB to ODI.  My end to end development with the OBIEE RPD and results in dashboards I developed using OBIEE 12C, for samples go to following:

http://mldscenter.org/ - using Google browser click: ‘Charter Schools’

Also configured and produced a proof of concept demo using the Tableau 9.0 tool as alternative to OBIEE, this was due to concern with higher cost of Oracle licenses.  

Migration of all development work completed with OWB 11G to new ODI 12C.

Converted Oracle Discoverer reporting system (no longer supported by Oracle) to OBIEE 12c and trained staff to use.

June 2014 – Jan 2015                                                      Data Modeler/Data Architect

Client:  Merck, NJ     Agency:  Cognizant Inc.

Data architect working both new and enhancements to data models to support Merck international commerce.


Feb 2014 – June  2014                                                    Data Architect

Client:  Aramark, Philadelphia, PA

Data Architect and ETL development .  Data Warehouse assessment and performance review.

Note:  This is short term assignment is continuation of same as performed at NYISO see below.


October 2013 – Jan 2014                                         Tech Lead/Data Architect

Client:  Rackspace  (the Open Cloud Company), San Antonio, TX.

This assignment is to use Erwin / Model Mart Rel. 7.3 to build a Conceptual / Logical Model.  Rackspace has expanded rapidly and the systems need to be unified to enable an efficient end to end process for product assembly and customer support.

·         Legacy systems migration for unification of business areas to integrated Oracle Product Hub.

·         MDM – Master Data Management implementation for implementation of product hub.

July 2013 – Sept 2013                                               Data Architect/ Senior Oracle BI Consultant

Tailwinds Agency – short term rehire at NYISO (previously worked during 2004).

Client:  New York Independent System Operator (NYISO), Rensselaer, NY. 12180

This is short term assignment to guide to upgrade to latest version of Oracle Warehouse Builder (OWB) Version 11G R2.  In addition:


March 2012 – June 2013                                Oracle OBIEE Solutions Architect

Client: Maryland Higher Education Commission, Baltimore, MD

Eighteen new education data systems with associated Oracle BI implementations.

Technologies included:  Recommended and implemented Oracle BI architecture for Maryland Department of Education to implement OBIEE 11G Dashboards.  Data Model development to support scholastic reporting for pre-school thru higher education of Maryland students.  Data Modeling with Oracle SQL Developer Data Modeler.


Sept 2011- Feb 2012                                        Oracle ERP/OBIEE Solutions Architect

Client: US Air Force, Dayton, Ohio – Short term due to contract cancelled by Air Force.

Wright Patterson AirForce Base, Dayton, Ohio, USA, Global ERP Implementation.

Technologies included:  Oracle 12.0.6. Functional/Technical Oracle Apps (Conversions/Interfaces),  Legacy systems to ERP Conversion,  Oracle 10g, Oracle Apps R12 Federal Financials and Oracle OBIEE  Informatica Ver. 8.1.6, PeopleSoft Ver 9 upgrade implementation of Oracle Business Analytics Warehouse.


November 2010 – August 2011                                  Oracle OLAP Data Architect

Client: Medai, Orlando, Florida

OLAP architect and lead solutions architect and designer to build a complete Oracle BI implementation resulting in new BI product for MEDai (PPQ Pin Point Quality).

Technical planning, design, build, testing, and support of OLAP-based applications used in the delivery of new and improved healthcare analytics service (predictive analysis). As the OLAP architect / engineer ensured development efforts conform to overall strategic direction and methodologies, designs / documents / and implements OLAP-based solutions.  Technologies included: Oracle OBIEE – Oracle Warehouse Builder, Oracle 11G OLAP Cube.


July 2009 – October 2010                              OBIEE Answers and Dashboard Developer

Client: US Army, Pentagon, VA. 22332

Assignment involved implementation development and training using:

Oracle OBIEE Ver. – Oracle Warehouse Builder 10G


May 2008 – June 2009                                    Data Architect and ETL Developer

Mental Health Care - Client: Value Options, 12369 Sunrise Valley Drive, Reston, VA.

Assignment involved both implementation and training using:


August 2007 – April 2008                              Data Architect  

Subcontract to Oracle Corporation, 18300 Quantico Gateway Drive, Triangle, VA

Client: US Marine Corps. – Global Combat Support System 


April 2006 – July 2007                     Tech Lead/Oracle Enterprise Data Architect                       

Subcontract to IBM, Germantown, MD. – Client: U.S. Department of Energy 


September 2005 – March 2006                   Senior Data Warehouse Consultant

Keane Consulting, Albany, N.Y., in support of the New York State Division of the Budget.


January 2005 – August 2005                                         Data Architect

Lockheed Martin - Department of the Navy Space and Naval Warfare Systems Center (SSC) in New Orleans.  


April 2004 – Dec 2005                                     Senior Data Architect Consultant

CSI – The Center for Data Warehousing, 100 Eagle Rock Ave, East Hanover, N.J. 07936

Client:  New York Independent System Operator (NYISO), Albany, NY.

·         Assessment of the Data Warehouse / Business Intelligence environment at NYISO related to utilization of the Business Objects Version 6 capabilities for access to the Oracle Analytical Workspace for MOLAP.

·         Key Data Warehouse technologies at NYISO include Oracle 9i, Oracle 9iAS, Oracle Warehouse Builder 9.2, Business Objects / BI Dashboard, Crystal Reports, Erwin Version 4.X with Model Mart.


 April 2003 – March 2004                                               Data Warehouse Consultant

(11 month assignment which resulted in new Financial Data Warehouse)

NYS Dept of Transportation, State Office Complex, Albany, NY.


July 2002 – March 2003                                                  Enterprise Data Architect 

CSX Railroad, 301 West Bay Street, Jacksonville, FL.


August 2001 – June 2002                                             Data Warehouse Principal Consultant

Boehringer Ingelheim Pharmaceuticals, Inc., Ridgefield, CT.              


May 2000 – July 2001                                       Data Warehouse Consultant 

Citigroup Global Investments, Hartford, CT    

Assignment was as a BI Solution Architect:


Jan 1999- April 2000                        Chief Data Architect    

Fleet Boston Bank, Albany, N.Y.                                      


Dec 1996 - Dec 1998                                                      Manager and Chief Data Architect

Ocwen Financial Corp, West Palm Beach, FL. 

·         Established from beginning a new Data Warehoue group and management (7 employees and consultants) resulting in significant business value for Ocwen.                                         

·         Decision Support System (DSS) used by all levels of upper management, CEO and Board of Directors (Business Objects Version 4) for management of assets in excess of  $3.5B, Web Intelligence 2.0, data mining & web site design/ implementation. 


·         Master of Computer Science /Information Systems (MS-CS)     FIT,   Melbourne, FL.

·         Master of Business Administration (MBA)  Golden Gate University                  San Francisco, CA.