James VanAuken

 

Solutions/Data Architect - Oracle BI

Summary

Twenty years of IT expertise in Database Modeling and Warehouse technology. Extensive knowledge of Data Modeling / Architecture, Data Conversions, specialization in Oracle BI (OBI EE).

 

Data Architect with 18 plus years of experience.  Technical lead on projects, mentor and instruct client staff in all aspects of Business Intelligence solutions.   

 

The result is successful implementations, no failures.  Recent assignments involve implementation of Oracle “Rapid Application Development” for development.  I successfully finish all projects.

 

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

Security Clearance: SECRET (status active till 6/14/13)

 

ETL

Oracle Warehouse Builder 11.2 with Oracle Data Integrator ODI , Oracle Analytical Workspace Manager AWM, Informatica v.9.5. 

RDBMS            

Oracle 12c Rel 1,11.2.0.2, DB2, Sybase, Progress and others.

Reporting

OBIEE 11G, Oracle Reports/Answers/Publisher, 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

Portal

Oracle OBIEE 11.1.1.5 and Oracle Dashboards

Metadata

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

------------------------------------------------------------------------------------------------------------

Feb 2014 – Present                                                  Data Architect

Client:  Aramark, Philadelphia, PA

Data Architect and ETL development to upgrade OWB v10 to OWB v11.2.  Data Warehouse assessment and performance review.

Note:  This is continuation of this same type assignment performed at NYISO see below.

 

October 2013 – Jan 2014                                        Data Architect

Client:  Rackspace  (the Open Cloud Company), SanAntonio, 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.

 

July 2013 – Sept 2013                                             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 Department of Education, 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.  My work resulted in the a public link that went to production as of January 14, 2013 –  access is: MLDSCenter.org

 

Sept 2011- Feb 2012                                      Oracle ERP/OBIEE Solutions Architect

Client: US Air Force, Dayton, Ohio

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 11.1.3.3.3.  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 11.1.3.3.3 – Oracle Warehouse Builder 11.2.0.1, 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. 10.1.3.3.3 – Oracle Warehouse Builder 10G

 

May 2008 – May 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                             

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

Client: US Marine Corps. – Global Combat Support System 

 

January 2007 – July 2007                 Oracle Enterprise Data Architect               

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

 

2006 Consulting Assignments

------------------------------------------------------------------------------------------------------------

August 2006 – December 2006                     Enterprise Data Architect Consultant

(5 month assignment - all consultants terminated by management due to change of strategy)

Contract to Circuit City Stores Inc., 9954 Maryland Drive, Richmond, VA.

 

February 2006 – June 2006                           Data Architect Consultant

(5 month assignment – replaced a consultant who left early and finished the OWB wrok)

Contract to N.Y.S. Office of the Attorney General, 200 Broadway Street, Troy, NY.

 

2005 Consulting Assignments

 

September 2005 – January 2006                  Senior Data Warehouse Consultant

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

 

May 2005 – August 2005                               Senior Data Warehouse Consultant

Computer Horizens Corporation  in Pittsburgh, PA. in support of a Data Warehouse for Federal Home Loans Savings Bank, Pittsburgh, PA..  

 

January 2005 – April 2005                                        Data Architect

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

 

1999 to 2004 Consulting Assignments

 

April 2004 – April 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 Lead 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.                                      

·        Business Objects tech lead (Business Objects Version 5).  

·        Dimensional Data Marts, modeled in ERwin and creation & use of metadata. 

·        Evaluation of Extraction, Transportation and Loading Tools (Informatica).

·        Database performance tuning with remodel of reporting database structure.    

 

Dec 1996- Dec 1999:             Manager and Chief Data Architect – Full time employee

Ocwen Financial Corp, West Palm Beach, FL.                                                         

·        Establishment/management (7 employees and consultants) of 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.  .

 
Education

v    MASTER OF C.S./INFORMATION SYSTEMS    Florida Institute of Technology    Melbourne, FL.

v    MASTER OF BUSINESS ADMINISTRATION     Golden Gate University   San Francisco, CA.

v    BACHELOR OF SCIENCE                                       Marist College   Poughkeepsie, N.Y.