James VanAuken                    

                                            

Solutions/Data Architect - Oracle BI

Summary

Twenty years of IT expertise as BI Data Architect, Developer and Solutions Architect.   Refer to my web site for additional background details.   Technical lead on many projects, mentor and instruct client staff in all aspects of data warehouse and data modeling through the entire SDLC cycle.   

 

Successful design and implementation of multiple conceptual, logical and physical data models.  Experienced in all aspects of this development from initial requirements through implementation of reporting data marts.

 

The result is successful implementations, no failures.  Recent assignments involve implementation of Oracle “Rapid Application Development” for development to meet critical schedules.

 

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

Security Clearance: SECRET (in active on 6/14/14)

 

ETL

Oracle Warehouse Builder 11.2.0.3 and 4 / Oracle Data Integrator ODI , Oracle Analytical Workspace Manager AWM, Informatica v.9.5. 

RDBMS            

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

Reporting

OBIEE 11.1.1.9, 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.9 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 2015 – Present - Oracle OBIEE Solutions Architect

Client: Maryland Higher Education Commission, Baltimore, MD

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

 

In addition to continuing my solutions architecture and development I am migrating the ETL from OWB to ODI.  My end to end development results in dashboards, for samples go to following:

http://mldscenter.org/ - using Google browser click: ‘Featured Data Dashboards’

Also configured and produced a proof of concept demo using the Tableau 9.0 tool as alternative to OBIEE.

 

June 2014 – Jan 2015                                                                        Senior Manager/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 to upgrade OWB v10 to OWB v11.2.  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), 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.

·       MDM – Master Data Management implementation to support  product hub.

 

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 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

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

 

January 2007 – July 2007                                         Tech Lead/Oracle Enterprise Data Architect                   

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

 

February 2006 – December 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.

 

 

September 2005 – January 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 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 1998:                                                Manager and Chief Data Architect

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 Computer Science /Information Systems (MS-CS)     FIT, Melbourne, FL.

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