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
Security Clearance: SECRET
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/220.127.116.11, SQL Server, DB2, Sybase, Teradata
OBIEE 12c/18.104.22.168, Oracle Reports/Answers/BI Publisher,
Tableau 10, Business
Objects Developer Suite 5.1/6.0 , SQL Developer, Cognos.
OEM, Control M
Oracle SQL Developer/Data Modeler, Erwin/ModelManager, Sybase Power
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
Developer, Hummingbird V9, SAP R3, PeopleSoft V8 and many others for
Achievements – Data
Architect – Solutions Architect - Oracle OBI EE
March 2015 – Present
Sawdey Solution Services
Solutions Architect/Systems Engineer
Clients: Dept of Defense, Under Secretary of Defense,
Comptrollers Office, Pentagon, Washington, D.C.
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.
techniques using Kimball dimensional were provided (used ERwin) and
Feb 2015 – Feb 2016
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
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
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.
- Build data models for Oracle 12c (Kimball Methods)
/ Teradata to support Merck international pricing strategies (iPrice
- Conversion of Teradata databases to Oracle
including MDM strategic implementations.
- Work the ETL processing to ensure models
performance to support Spotfire dashboards.
- Review the entire IT project solution architecture
and data models to provide for business solutions.
Feb 2014 – June
Client: Aramark, Philadelphia, PA
Data Architect and ETL development .
Data Warehouse assessment and performance review.
- Data models developed with Erwin tool.
- Upgrade Oracle database(s) and
Oracle Warehouse Builder to
- Define the upgrade process to
Oracle Data Integrator (ODI 12c).
Built EL-T ODI processes to demonstrate ODI functionality.
- Migration of OWB Mappings to new ODI 12c..
is short term assignment is continuation of same as performed at NYISO
October 2013 – Jan 2014
Tech Lead/Data Architect
(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
Legacy systems migration for unification of
business areas to integrated Oracle
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.
- Define the upgrade process to
Oracle Data Integrator (ODI
11G)/Oracle Golden Gate 11G.
- Develop OBIEE 11 Dashboards
and the Oracle OBIEE RPD for the logical and physical design.
- Advise and implement ‘Best Practices’ for ETL in
complex and multi-developer system including processes for code
migrations and configuration controls.
March 2012 – June 2013
Oracle OBIEE Solutions Architect
Client: Maryland Higher Education Commission,
Eighteen new education data systems with associated
Oracle BI implementations.
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.
- Developed RPD and
OBIEE 22.214.171.124 Dashboards (see link above).
- ETL using
Oracle Data Integrator.
- Oracle Weblogic and Web Center.
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.
Functional/Technical Oracle Apps (Conversions/Interfaces), Legacy systems
to ERP Conversion, Oracle 10g,
Oracle Apps R12 Federal Financials and
Oracle OBIEE 126.96.36.199.3.
Informatica Ver. 8.1.6, PeopleSoft Ver 9 upgrade
implementation of Oracle
Business Analytics Warehouse.
- Solutions architecture to enable data error
handling end to end. Enable data
reconciliation for conversion of data from legacy to EBS.
OBIEE 188.8.131.52 Publisher
reports to enable export in Excel format.
- OBIEE solution implementations for reporting and
conversions exception reports.
Worked OBIEE RPD development and
- Customized Oracle out of box Informatica ETL, used
the DAC to produce and execute Tasks.
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
included: Oracle OBIEE 184.108.40.206.3 – Oracle Warehouse Builder 220.127.116.11,
Oracle 11G OLAP Cube.
- Design and build data model and structures for
OBIEE Logical Layer (implementation of OLAP).
- OWB 18.104.22.168 – for ETL and Data
- Design and build ETL processes (Star Schemas) and
ETL for relational reporting.
- Designed and implemented Oracle Cubes
(multi-terabyte) which sub-second query response timings and drill
through capabilities with ad-hoc reporting.
July 2009 – October 2010
OBIEE Answers and Dashboard Developer
Client: US Army, Pentagon, VA. 22332
Assignment involved implementation development and
Ver. 10.1.3.3.3 – Oracle Warehouse Builder 10G
- Formulate requirements and translate into data
models for reporting.
- Using Oracle APEX developed dashboards for Cost
Analysis to support Army
- Set up back end and data structures for OBIEE
- Developed OBIEE Dashboards
- Optimization of OBIEE - Answers, Delivers, BI
- Oracle Warehouse Builder 11G R2 (OWB)
implementation and training for staff to enable building the OBIEE
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
- Oracle OBIEE - Oracle Warehouse Builder Ver.11.
Source DB2 data on the AS400 migrated using
Oracle Gateway for DB2.
Client was using intensive custom built processes.
My tasks involved everything from OWB and Workflow installation
to the actual data conversion, migration to production, during this
process provided training to staff.
Installed OBIEE and
Oracle Data Integrator 10.1.
- Oracle WorkFlow (Ver. 2.6.3).
Built Process Flows schedule, load and provide error reporting.
August 2007 – April 2008
to Oracle Corporation, 18300 Quantico Gateway Drive, Triangle, VA
Client: US Marine Corps. – Global Combat Support System
- Short term assignment to assist Oracle in a data
clean up and conversion / migration task using
Oracle Warehouse Builder, to migrate mainframe legacy to
Oracle eBusiness Suite.
Effectively utilized new features of OWB to perform Data
Profiling, resulting in significant data cleansing.
OBIEE reports with Oracle
April 2006 – July 2007
Tech Lead/Oracle Enterprise Data Architect
to IBM, Germantown, MD. – Client: U.S. Department of Energy
- Reengineer the Data Warehouse to enable new
capabilities such as Change Data Capture and Partition Exchange for near
real time data access thus enabling updated data warehouse several times
Star Schema’s and 22 Dimensions for the implementation of client data
Implemented the Star Schemas in both ROLAP with MOLAP
capabilities, produced reports using Discoverer Plus.
September 2005 – March 2006
Senior Data Warehouse Consultant
Consulting, Albany, N.Y., in support of the New York State Division of the
Provided an evaluation and Proof of Concept (built a Star Schema using
Oracle Warehouse Builder 10G R1) for the Oracle
Business Intelligence products. Compared and contrasted Oracle BI
solutions with other leading vendors (i.e.,Cognos Ver. 8 ReportNet, Business Objects XI, SQLServer 2005, SAS Ver.9) and
recommended a complete BI solution.
Solutions Architect developed a data architecture for the
agency with technical recommendations for an entire IT architecture with
servers to implement the Data Warehouse / KPI’s and metadata solution.
January 2005 – August 2005
Martin - Department of the Navy Space and Naval Warfare Systems Center (SSC)
in New Orleans.
Analyzed and extracted data from the
PeopleSoft Ver 8
the ETL team to instruct and ensure “best practices” were implemented.
Oracle Discoverer 10.1.2 (Drake) for potential
access to Analytical
data structures, also utilized
Business Object Ver. 6.5.X
for user reporting (ad-hoc included). Set up the
Oracle Portal to
enable viewing of reports by users along with
Single Sign On to avoid multiple
Warehouse Builder. Data Modeling with
Erwin Ver 4.
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
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
NYS Dept of Transportation, State Office Complex,
- Develop financial data mart
Oracle Ver. 9.X Developer Suite
including the ETL tool
Oracle Warehouse Builder 9.2 (OWB),
Oracle Discoverer 9iAS 1.0.2.X
(built EUL’s)/Administrator/Workflow & PL/SQL Developer.
- Source data from
DB2/ UDB 7.1 OS390
/ VSAM migrated to
Oracle Ver. 9.2..
- Developed all dimensional models using
Erwin 4.1 (AllFusion).
July 2002 – March 2003
Enterprise Data Architect
CSX Railroad, 301 West Bay Street, Jacksonville, FL.
- Develop models using
Erwin 4.1 (AllFusion)
for OLTP and data warehouse.
- Implementation with ETL tool Informatica Ver.
6.1. Primary databases modeled were Oracle 8/9 and DB2
UDB Ver 6.1 - IMS.
August 2001 – June 2002
Data Warehouse Principal Consultant
Boehringer Ingelheim Pharmaceuticals, Inc., Ridgefield,
- Used ETL tool (Business
Object/BI Dashboard/Data Integrator) to migrate from
SAP R/3 source to
Oracle Ver. 8.1.6 database target. Generated
ABAP code for
execution at the SAP R/3 source.
Masters certification with Data Integrator.
- Utilize the reporting tool (Cognos
Ver. 7) to enable access for users (500+).
- Server Hardware is HP-Unix Ver.11 (L,N,V Class).
Data Modeling with
Erwin Ver. 4.
May 2000 – July 2001
Data Warehouse Consultant
Citigroup Global Investments, Hartford, CT
Assignment was as a BI Solution Architect:
- Implemented financial data warehouse with over
$150B of financial assets. Scope of project involves all aspects of
Data Warehousing including implementation of reporting tool (Cognos Impromptu – Power Play - UpFront). Utilized
Use Cases and
- Migration of technology from legacy data (Btrieve)
to SQL Server 2000
and migration of code from legacy code (PL/1) to
Visual Basic Ver 6.
Jan 1999- April
Chief Data Architect
Fleet Boston Bank, Albany, N.Y.
- Business Objects tech lead (Business Objects
- Dimensional Data Marts, modeled in ERwin and
creation & use of metadata.
- Evaluation of Extraction, Transportation and
Loading Tools (Informatica).
- Performance tuning with remodel of reporting
database structures to Dimensional.
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/
Master of Computer Science /Information Systems (MS-CS)
Master of Business Administration (MBA)
Golden Gate University
San Francisco, CA.
Bachelor of Science (BS)