Solutions/Data Architect - Oracle BI
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
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)
Oracle Warehouse Builder 126.96.36.199 and 4 / Oracle Data Integrator ODI ,
Oracle Analytical Workspace Manager AWM, Informatica v.9.5.
Oracle 12c Rel 1,188.8.131.52, DB2, Sybase, Progress and others.
OBIEE 184.108.40.206, Oracle
Reports/Answers/Publisher, Business Objects Developer Suite
5.1/6.0 , SQL Developer, Cognos.
Job Scheduling Tools
Oracle Workflow, OEM, Control M
Developer/Data Modeler, Erwin/ModelManager, Sybase Power Designer V12
Oracle OBIEE 220.127.116.11 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.
Achievements – Data Architect
– Solutions Architect - Oracle OBI EE
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:
- using Google browser click: ‘Featured Data Dashboards’
Also configured and produced a proof of concept demo using
the Tableau 9.0 tool as alternative
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.
- Build data models for Oracle 12c to support Merck
international pricing strategies (iPrice application).
- 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 to upgrade OWB v10 to
OWB v11.2. Data Warehouse assessment
and performance review.
- 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..
Note: This is
short term assignment is continuation of same as performed at NYISO see
October 2013 – Jan 2014
Tech Lead/Data Architect
(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
- Legacy systems migration plan for unification of
business areas to integrated
Oracle Product Hub.
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.
- Define the upgrade process to
Oracle Data Integrator (ODI
11G)/Oracle Golden Gate 11G.
- 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
Client: Maryland Higher Education Commission, Baltimore, MD
Eighteen new education data systems with associated Oracle
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 18.104.22.168 Dashboards (see link above).
- ETL using
Oracle Warehouse Builder 22.214.171.124.
- Oracle Weblogic and Web Center.
Sept 2011- Feb 2012
Oracle ERP/OBIEE Solutions Architect
Client: US Air
Force, Dayton, Ohio
Wright Patterson AirForce Base, Dayton, Ohio, USA, Global
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
Business Analytics Warehouse.
- Solutions architecture to enable data error handling
end to end. Enable data
reconciliation for conversion of data from legacy to EBS.
- Developed 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 solutions.
Oracle OBIEE 184.108.40.206.3 – Oracle Warehouse Builder 220.127.116.11, Oracle 11G
- 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
July 2009 – October 2010
OBIEE Answers and Dashboard Developer
Client: US Army, Pentagon,VA. 22332
Assignment involved implementation development and training
Oracle OBIEE Ver.
10.1.3.3.3 – Oracle Warehouse Builder 10G
- Formulate requirements and translate into data models
- Set up back end and data structures for OBIEE Logical
- 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 Logical Layer.
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:
- Oracle OBIEE -
Oracle Warehouse Builder (Ver. 10.2.0 4 – 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.3.5.0
- Oracle WorkFlow
(Ver. 2.6.3). Built Process Flows
schedule, load and provide error reporting.
August 2007 – April 2008
Oracle Corporation, 18300
Quantico Gateway Drive, Triangle,
Client: US Marine Corps. – Global Combat Support System
- Short term assignment to assist Oracle in a data clean
up and conversion / migration task using
Warehouse Builder 10G Rel. 2, to migrate mainframe legacy to
Oracle eBusiness Suite.
Effectively utilized new features of OWB to perform Data Profiling,
resulting in significant data cleansing.
- Set up OBIEE
portlets using Oracle Answers.
January 2007 – July 2007
Tech Lead/Oracle Enterprise Data Architect
Subcontract to IBM,
MD. – Client: U.S. Department
- 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 a
Star Schema’s and 22 Dimensions for the implementation of client data
the Star Schemas in both ROLAP with MOLAP
capabilities, produced reports using Discoverer Plus.
February 2006 – December 2006
Data Architect Consultant
(5 month assignment – replaced a consultant who left early
and finished the OWB wrok)
N.Y.S. Office of the Attorney General,
200 Broadway Street, Troy, NY.
technical role for the implementation of
Oracle 10G (10.2.01) on
Sun/Solaris Ver. 10 . Data conversion and migration
of legacy DB2
data to Oracle 10G
database. Data modeling
included dimensional models (Kimball Methods) using
capabilities for Cubes and Hierarchies.
September 2005 – January 2006
Senior Data Warehouse Consultant
Consulting, Albany, N.Y., in support of the New York State
Division of the Budget.
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
- Department of the Navy Space and Naval Warfare Systems Center (SSC) in New
and extracted data from the
PeopleSoft Ver 8 Oracle Instance.
ETL team to instruct and ensure “best practices” were implemented.
Oracle Discoverer 10.1.2 (Drake) for potential
access to Analytical Workspace
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
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 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
NYS Dept of Transportation, State Office Complex, Albany, NY.
- 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.. I
- 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 -
August 2001 – June 2002
Data Warehouse Lead Consultant
Boehringer Ingelheim Pharmaceuticals, Inc., Ridgefield, CT.
- 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+).
Teleran to view database utilization. Server Hardware is
HP-Unix Ver.11 (L,N,V Class). Data
Modeling with Erwin Ver. 4.
May 2000 – July 2001
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 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,
& 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.
Bachelor of Science (BS)