Data Architect - Modeler - Oracle BI
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.
Successful design and implementation of multiple conceptual, logical and physical data models. Expert in Agile development from initial requirements to implementation of BI system.
Master Degrees in both Business & Computer Information Systems (see last page).
Security Clearance: SECRET
Oracle Warehouse Builder 220.127.116.11 and 4 / Oracle Data Integrator ODI , Oracle Analytical Workspace Manager AWM, Informatica v.9.5.
Oracle 12c Rel 1/18.104.22.168, SQL Server, DB2, Sybase, Teradata
OBIEE 22.214.171.124, Oracle Reports/Answers/Publisher, Tableau 9.0/Business Objects Developer Suite 5.1/6.0 , SQL Developer, Cognos.
Job Scheduling Tools
Oracle Workflow, OEM, Control M
Oracle SQL Developer/Data Modeler, Erwin/ModelManager, Sybase Power Designer V12
Oracle WebCenter/Weblogic-Oracle OBIEE 126.96.36.199 and Oracle Dashboards
MDM Master Data Management, XML
Database Other Apps
TOAD, SQL Developer, Hummingbird V9, SAP R3, PeopleSoft V8 and many others for Data Warehouse.
Feb 2015 – Present Data Architect / Data Modeler/ETL
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 data model development and solutions architecture 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: ‘Charter Schools’
Also configured and produced a proof of concept demo using the Tableau 9.0 tool as alternative to OBIEE. Another alternative due to high cost of Oracle license and maintenance was MS SQL Server with SSIS. This option I am building a strategy to migrate to, due to MS discounts for educational entities.
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 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.
· 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
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 188.8.131.52.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 184.108.40.206.3 – Oracle Warehouse Builder 220.127.116.11, 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
Assignment was as a BI Solution Architect:
Jan 1999- April 2000 Chief Data Architect
· 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