Dale Howard

*** *. **** ******, ***** Charles, IL 60174

Cell: 847-***-****

Email: ac86ff@r.postjobfree.com

Education:

Northeastern Illinois University Bachelor of Science (Overall GPA 4.6 on a 5.0 scale)

1st Major: Information Science / 2nd Major: Psychology

Experience Summary:

IT Management 14+ years (total management experience 19+years)

BI / Data integration 20+ years

Database design 20+ years

Job History:

Job Title: Manager, ETL / Data-warehouse Development Jan. 2009 - Current

Company: Crowe (formerly Crowe Horwath)

Overview of basic duties:

Developed ETL solutions for established data warehouse using Microsoft SSIS.

Manage day to day operations

Identified best of breed 3rd party tools to meet emerging business needs

Major Achievements:

Built database load systems for Sharepoint(read/write) and Json(rest)

Plan and implement consolidation of multiple data warehouse environments

Plan and implement process audit and error handling systems.

Designed and implemented DW process logging and exception management systems

Consolidated multiple systems suffering from benign neglect

Established best practices for elt, database management, and exception handling

Formalized documented and streamlined promotion process development to UAT to production

Maintained performance levels equal to or better than original data-warehouse

Developed read write solutions between Sharepoint and the data-warehouse

Developed Rest/Json interface between vendors and data-warehouse

Participated in transition to SAP

Job Title: IT Manager, Data Integration and Analytics Aug. 2008 - Jan. 2009

Company: J. C. Whitney (Whitney Automotive Group)

Overview of basic duties:

Manage 6 developers/report writes, 3 dba(s), 4 in house ETL and data architecture consultants

Manage day to day operations for BI / ETL, reporting group, databases

Oversee environment & licensing for Cognos,Informica,DB2,Oracle,MS Sql Server (Multiple locations)

Major Achievements:

Upgraded multiple systems suffering from benign neglect

Established best practices for elt, database management, and db architecture

Established enterprise wide standards for elt, database management, and db architecture

Reviewed software licensing and enforced compliance

Established long term plan for consolidation on a single database platform

Established long term plan for consolidation of multiple BI environments

Streamlined development cycle utilizing VM and managed test sets

Engaged upgraded & new tools to enhance development cycle

Established standard “development => test/QA => production” development and promotion cycle

Job Title: Manager Business Intelligence and Web Development Jan. 2002-Aug. 2008

Company: Komatsu America

Overview of basic duties:

Managed Business Intelligence Team (Business Objects, SQL Server; staff of 1-3)

Managed Web Development Team (4 web developers)

Interface with senior management in the US, Japan and Europe for global parts system

Oversaw technical aspects of support documents (Cartersville, GA)

Major Achievements:

Headed evaluation team to determine direction of Komatsu's BI initiative, personally trained in Hyperion (Essbase), SAP-BW and Business Objects (version 5).

Set direction for data-warehouse initiative implemented initial data warehouse

Managed and participate in development of Komatsu’s data warehouse:

Design and implemented multiple ETL (ELTL) processes from radically diverse sources using Microsoft DTS tools

Managed concurrent development of multiple projects ranging in size from small to multi-million dollar projects.

Created and/or managed creation of multiple targeted dashboards using Business Objects and Xcelsius

Integrated large scaled data-mart developed by 3rd party into existing EDW

Managed and participated in upgrades for MS, Business Objects report and data systems

Chief architect for global Customer Portal, Global parts search systems

Job Title: IT Director March 1993-Dec. 2001

Company: Login Brothers Book Co/ LPC Group,

Overview of basic duties:

Managed a staff of between 3 and 7 developers, systems administrators and database professionals across a wide variety of projects, platforms and implementation schemes.

Day to day operations for the Chicago office

Major Achievements:

Developed an enterprise data-warehouse using Oracle 7i and Oracle Discover

Developed E-commerce site (www.coolbooks.com) and B2B site (www.lpcgroup.com) using a combination of Cold Fusion, JavaScript, Perl, Oracle,IIS, and Apache

Managed the systems split-up of LPC & Login Brother.

Developed a web based system for creating "on demand" pdf sales materials (catalogs and "Sales Sheets") using Apache FOP (XSL:FO)and reflecting real time data changes.

Created EDI translators in Perl and C for 832,850,855, and 997

REFERENCES: Furnished upon request.

Contact this candidate