Darren Fish

Business Intelligence/Data Warehouse Architect

Ewa Beach, HI 303-***-**** acug8f@r.postjobfree.com

QUALIFICATIONS SUMMARY

Senior Business Intelligence Architect with more than 20 years of experience with OLAP/reporting tools and data warehouse technologies. Led the successful completion of end to end global BI projects in various industries ranging from automotive manufacturing to hospitality and gaming. More than a decade of experience with the Cognos suite of tools, including BI, several years with the Siebel Analytics/OBIEE platform and analytics packages as well as working knowledge of MS/BI and SAP BO/BI/BW. Experienced with Qlik, Tableau, Talend. Experience with modeling tools such as Oracle Data Modeler, ERWin, ER/Studio.

Known for adherence to, and promotion of, SDLC best practices, using Waterfall and Agile methodologies.

TekSystems

Solution Architect (Summit Materials) Nov 2015 – Mar 2016

Assist in the creation of RFPs for Business Intelligence Platform

Lead the technical architecture and design for Phase 1 of the Business Intelligence/Data Automation program

Provide subject matter knowledge of best practices for BI/DA

TekSystems

Data & Integration Architect (HECO) Apr 2015 – Oct 2015

• Assisted in the creation of RFPs for ESB & EDW to support Smart Grid

• Drove the expansion of ARB influence in IT

• Designed “best-practice” architecture for Information management including ETL/ELT, data models and front-end delivery

• Developed effective metrics and Key Performance Indicators for various business segments

• Advised on staffing, migration and implementation activities

Technologies: Business Objects, Oracle, IBM Websphere IIB & MQ, Tableau

Arrow Electronics, Inc.

BI/DW Architect Oct 2014 – Apr 2015

• Performed current state assessment of BI infrastructure and processes

• Created strategy and roadmap for BI re-platform effort

• Designed “best-practice” architecture for Information management including ETL (Informatica & ODI), data models and front-end

• Developed effective metrics and Key Performance Indicators for various business segments

• Advised on staffing, migration and implementation activities

Technologies: Business Objects, Oracle, OBIEE, Informatica, ODI, Tableau

Charter School Growth Fund (Slalom)

Information Management Architect April 2014 – July 2014

• Defined and designed a data warehouse for consolidation of several data sources to enable analysis and scorecarding

• Established analysis approach and actions (Metrics, KPIs, detail analysis, issues resolution)

• Designed and built all ETL, metadata models and reports

• Designed “best-practice” architecture for Information management

Technologies: MySQL, Tableau, Talend Open Studio

Leprino Foods (Slalom)

Information Management Architect Nov 2013 – March 2014

• Stabilized the existing SAP BW BI platform

• Performed current state assessment of BI infrastructure and processes

• Created strategy and roadmap for BI re-platform effort

• Designed “best-practice” architecture for Information management

Technologies: SAP BW, Business Objects, Tableau

Vail Resorts (Slalom)

Information Management Architect Mar 2013 – Sept 2013

• Stabilized the existing Cognos BI platform

• Performed current state assessment of BI infrastructure and processes

• Created strategy and roadmap for BI re-platform effort

• Designed “best-practice” architecture for Information management

Technologies: SQL Server, Cognos 8.4, SSIS, SSRS, SSAS

Pacific Gas & Electric (Slalom)

Information Management Domain Architect Aug 2012 – Dec 2012

• Created enterprise strategy and reference architectures for Business Intelligence and Analytics

• Worked with business portfolio architects to socialize the new architectures

• Assisted in the roll-out of decision frameworks to solution architects

• Provided direction and guidance on several projects, including POCs for new tool selection

• Evaluated enterprise utility data model for use within all business units

Technologies: Oracle, SAP, Business Objects, SQL Server, Informatica, Teradata, Tableau

Cigna (Slalom)

Solution Architect, OBIEE Implementation Oct 2011 – Jun 2012

• Created overall solution architecture and design for Operational Intelligence

• Designed flexible and extensible data model to accommodate multiple disparate data sources

• Designed custom metrics, KPIs

• Created process and staffing recommendations to establish implementation and support teams.

• Managed client and consultant resources

Technologies: Oracle, OBIEE, ODI, Informatica, OBIA

ProBuild (Hitachi Consulting)

Architect, OBIEE Implementation May 2011 – Sep 2011

• Identified and designed solutions for several key architectural issues.

• Implemented OBI Applications Procurement and Spend Module

• Designed additional custom metrics, KPIs

• Updated and re-built ETL process using ODI/Informatica

• Created process and staffing recommendations to stabilize the existing implementation and support teams.

• Managed client and consultant resources

Enterprise Products (Hitachi Consulting)

Architect, OBIEE Implementation Jan 2011 – May 2011

• Implemented OBIA HR and Finance Analytics packages

• Designed and implemented architecture and infrastructure recommendations

• Managed client resources

Key Energy Services (Hitachi Consulting)

Tech Lead, Cognos Stabilization, OBIEE Implementation Jan 2009 – Nov 2010

• Provided technical assistance in the stabilization of a multi-version Cognos BI, Planning and Finance environment

• Delivered best-practice solutions to unresolved issues.

• Implemented OBI Applications and custom OBIEE reporting packages

Quest (Hitachi Consulting)

Tech Lead, Churn Analytics Aug 2008 –Dec 2008

• Acted as the technical lead for a complex ETL development work stream.

• Managed and mentored several resources in parallel work efforts.

• Provided SDLC best practices to the client.

Wynn Resorts (Hitachi Consulting)

Lead Solution Architect Mar 2007 – Jul 2008

• Implemented an Enterprise Customer Value system consolidating data from multiple source systems.

• Architected and implemented data marts and reporting/analysis systems for several business units, including Hotel, Gaming and Human Resources

• Created data marts pulling data from several source systems. Also supported the data modeling and migration effort to Teradata

• Designed and built several cubes and complex reports to support analysis and reporting requirements, as well as providing an ad-hoc reporting environment. Implemented and managed complex custom security models.

Abbot Laboratories (Hitachi Consulting)

Lead BI Architect, Supply Chain Apr 2006 – Mar 2007

• Designed and implemented sales record adjustment processing

• Created development processes for all existing and future ad-hoc reporting requests

• Acted as lead architect, managing several on and offshore resources, on a major data process/reporting project

• Designed and built several cubes and complex reports to support analysis and reporting requirements. Implemented and managed complex custom security models.

Microsoft (Hitachi Consulting)

Tech Lead, Marketing BI Sep 2005 – Mar 2006

• Tech lead for several BI and DB developers on an iterative sales & marketing BI project.

• Provided SDLC best practices to the team and client, dramatically reducing system flaws and increasing customer acceptance

Ford Motor Company

Lead BI Architect, System Architect Aug 1998 – Aug 2005

• Architected and implemented an intranet web portal to present a consolidated view of the key performance metrics, including warranty, customer satisfaction and sales/service satisfaction. The portal had an enterprise wide audience of over 10,000 users.

• Architected and created several cubes to provide analysis capabilities for multiple global business units, using data from multiple sources. This system had approximately 6,500 users in 38 countries.

• Managed the migration process for several major software upgrades.

• Created the methodologies and processes used to support all the systems in this portfolio.

• Managed the team responsible for the automation of several manual data extraction and reporting functions

• Led the development effort to produce a standard reporting interface. These reports were the standard for all quality metrics used by the assembly plants for internal reporting.

Contact this candidate