Resume

Sign in

Data Engineer

Location:
Huntley, IL
Posted:
October 25, 2019

Contact this candidate

Resume:

**NOTE: As of October ****, **-**% of Hadoop ecosystem Big Data projects are failing

Introduction

Proven leader, guide, developer and mentor of Enterprise Solutions

in data systems and analytics for more than two decades

Expert in Data Warehouse and Business Intelligence with focus on Supply Chain

Delivers superb results to organizations that need to build and deliver analytics solutions nationally and across the globe.

Role variety experience with proven success (Business Owner, Sales,

Pre-Sales, Manager, Senior Solutions Architect, and Developer)

Architect of the world’s first Data Lake- NOAA Deep Water Horizon Biological and Environmental Damage Scientific Study (Healthcare in a different domain)

Key Accomplishments:

Enterprise Sales Engineer success in the South-Central Region with OTE and MBO accomplishments across multiple companies.

NOAA’s Deep-Water Horizon Oil Spill environmental impact study (provided leadership and management expertise in the Data Warehouse / Data Lake Platform design and analytics for the study)

H.E.B Grocery’s supply chain analytics (architecture, direction and development)

Sulzer Medica (Now Zimmer)’s Global Supply Chain (Architecture and Direction)

Symantec analytics (led the offshore direction and development)

Teradata vertical successes (through Senior Solutions Architect role) Retail Specialty

On-shore, Off-shore (international Leadership and Accountability) experience

Background:

University of Texas at San Antonio alum - studied Management Information Systems

Currently holds certifications in MapR Administration, Pentaho, Talend, Business Objects and Data Science Essentials from John’s Hopkins

Member in good standing of the Association for Supply Chain Management - ASCM

Proud Veteran of the United States Navy Reserve; through which attended Advanced Electronics School and led a team of sixty (60)

Experience

TechUSA- Camping World November 2018 – January 2019

Data Warehouse Engineer / Analyst

Short project to make recommendations on the Data Warehouse with regard to best practices, standards, and business processes and install, configure and develop in PowerBI on a mix of SQL Server, Oracle, Oracle X-Center, X-Store, and Cognos to deliver Financial Reports for the Gander Outdoors Acquisition. Project also included review and modification of SSIS packages.

Secondary piece of the project was to advise on the upcoming Big Data Implementation.

YETI Coolers May 2017 – July 2017

Interim Manager, Data Operations

Brought in to align Data and BI Teams on the process and procedures necessary for Enterprise Data in the Global Supply Chain.

-Reported, advised and forecasted team spend; efforts resulted in $450k in savings for the balance of calendar 2017

-Organized team efforts to align with corporate objectives

-Implemented changes at all phases of the Enterprise Data layers to improve policies, procedures, and practices. These changes drove the following results:

i.Consistency across all employee inputs yielding a stronger data story

ii.Enterprise-ready data alignment that crosses all leading data players

iii.Increased speed in data analysis allowing the business leaders to respond to market changes faster.

iv.Designed the SAP R4 on HANA data flows and incorporated Marketo marketing data into the data warehouse.

MapR Technologies August 2016 – February 2017

Sales Engineer- Big Data

Position resulted in the addition of a municipality and, a financial institution resulting in a confidential amount in licensing revenue across Q4 and Q1. 115% of quota and MBO objectives.

- Departed for personal reasons.

Dataholistics, Inc. March 2016 – April 2016

Consultant- Data Operations

·Brought more than 300 excel reports and government data feeds into a PostGIS database for spatial / GIS analysis.

·Architected the data feeds from the hosted PostGIS to Salesforce for customer tracking.

·BI-layer utilizing Tableau.

Project resulted in savings of man hours for targeted marketing and contact efforts.

Computer Sciences Corporation August 2015 – December 2015

Senior Solutions Architect (Pre-Sales)

-Built out proof-of-concepts for end-clients entering or expanding their needs in the in Big Data Cloud.

-Other responsibilities included:

·Writing SOW’s

·RFP’s / RFQ’s / RFI’s,

·Pricing- cloud and services

-Departed due to company split.

DataHolistics Inc.

Project - Digital Media Provider June 2015 – August 2015

Big Data Solutions Architect / Analytics Team Lead

Project Overview: Designed a Big Data solution for this company’s next generation advertising platform. Led a team to deliver an end-to-end solution for the extremely complex cable television advertising environment.

Some of the notable milestones include:

·Did a vendor comparison of Hortonworks, Cloudera and MapR

·Advised on consolidation two Big Data instances from Cloudera and Hortonworks to the new MapR chosen platform, as well as recommended moving to Microsoft

·Designed the integrations from existing databases (Teradata, Oracle, Cloudera HDFS, MapR FS) to Hortonworks

·Designed and built HIVE / Hbase structures for reporting layer access

Cannot report any metrics on this for competitive reasons.

Project – Fortune 50 Large Consumer Products Company March 2015 – May 2015

Senior Solutions Architect

Project Overview: Designed a solution for migrating a segment of customer data to Amazon Redshift. Project entailed designing a solution utilizing Talend ETL for fast delivery of managed processes, procedures and testing on the Talend platform.

MarkLogic September 2014 – February 2015

Senior Sales Engineer- Pre-Sales Big Data

Developed and presented POC’s for MarkLogics’ big data NoSQL solution. 130% quota attainment.

Claraview / Teradata 2012 -2014 Solutions Architect / Sales Engineer - Big Data Center of Excellence

Tapped for my extensive, Big Data and lead experience for customer facing support of sales, architecting and designing big data and data pipeline solutions for clients. Point person activities up to and including presentations of the product, case studies and proof of concepts against use cases and key performance indicators. Wrote and revised SOW’s for client engagements, typically in the $1M+ range or more. Petabyte scale + (plus).

Verticals: Retail, Banking, e-Tail, Enterprise Software, and Utilities

DataHolistics, Inc. 2012

Project- Large Publishing Company

Architected and built the financials’ data warehouse for this large publishing company, using the Pentaho BI Suite, to build out the Order to Cash reporting.

Efforts resulted in streamlined efficiency of analytics by reducing license cost fees from large vendors.

Pentaho 2010 – 2011

Sr. Consultant and Technical Acct Mgr.

Senior Consultant charged with developing new and existing client base utilizing the Pentaho BI Suite and best practices in BI / DW. Tapped as the Technical Account Manager to assist clients with a single point of contact for deep technical issue identification and resolution.

Highlights included:

·NOAA- Analytics Lead - led a geographically dispersed development team of fifteen; provided guidance on User Stories, decomposed Epics to sprint ready components; and ran the estimation & planning meetings

oArchitected the data model, ETL and Reporting responsibility, and provided oversight to Geo-spatial (GeoKettle, GeoMondrian) efforts

oOriginal Lead Architect for the world’s first Data Lake

·Modified an end to end BI / DW solution for a 400 Store Retail Client using Pentaho (PDI) to pull and measure temperature sensor data from Vectorwise, modified and created analyzer and reporting and created or modified new. xactions.

·Clickstream Analytics Company- combined salesforce.com and Omniture data for targeted marketing using PDI and Analyzer

Knowvolution, Inc. 2001 to 2010

Principal Partner and Business Strategist- Management Consultant

Data Warehousing / Supply Chain

Directly responsible and accountable for:

·P&L

Verticals: Computer Processing, Data Preparation and Processing, Telecom (Mediation), Non-Profit, Insurance, Advertising (Search Engine and Keyword Analytics), Mortgage, Customer Service (Analytics), Enterprise Software (Financial Analytics), Grocery (Supply Chain)

Partnered with PWC

SenseCorp 2001- 2002

Principal Consultant- Data Warehouse: Financials

Verticals: Oil and Gas, Medical Manufacturing, Supply Chain (Enron, Shell, Zimmer). Partnered with PWC.

Concero / PSW 1999 -2001

Principal Consultant

Project - Internal PeopleSoft HR Integration

Project Overview: Map and Integrate current systems and databases to PeopleSoft HR for Accounting

Technologies: Oracle 7.x, Oracle 8i, SQL Server 7.0, and Ceridian Payroll, PL/SQL, Informatica

Role Description: Integration Architect

·Mapped and integrated source systems to PeopleSoft HR

·Databases and systems included Oracle 7.x, Oracle 8i, SQL Server 7.0, and Ceridian Payroll. Utilized PL/SQL scripts for loading.

Project - Cobalt Group Automotive

Project Overview: Build of a web portal for Automotive Dealers to get up to the minute information on sales, and customer touch points

Technologies: Oracle, SunOS, ERWin

Role Description: Data Mart Lead

·Designed and deployed a Data Mart in support of reporting for a new online application.

·Architected specific subject (dimensional) areas.

·ERWin utilized as the modeling tool.

Project - Good2CU

Project Overview: Build of a web portal for a consortium of Credit Unions for Customer Account Information and Product Marketing

Technologies: Oracle, SUN Solaris, SunOS, Vignette

Role Description: Lead Data Architect

·Designed Business processes involved with (OLTP) transactional system interfaced with Vignette. Architected the OLTP data model. Delivered a robust OLTP

·Managed all aspects of administration and performance tuning of developer queries

·Trained development team on advanced queries and performance-focused development

Project - Ann Taylor

Project Overview: - Design and Build Cognos OLAP cubes on top of Tivoli Service Desk for Customer Service business performance

Technologies: Cognos, PERL, Tivoli Service Desk, PL/SQL

Role Description: OLAP Developer

·Designed and implemented a customer support center using Tivoli Service Desk on Oracle 8.x, Architected OLAP Cubes on top of OLTP using Cognos to support the reporting requirements. Performed performance tuning and customization to the Service Desk platform with PL/SQL.

Previous Work History 1994 - 1997

CompuNet Systems – Data Base consultant

Multicom – SQL Server dBA

GolfSmith International, Inc. – Network Administrator / dBA Oracle Re-compute- Austin, TX - Inside Sales

U.S. Long Distance (Qwest) – Network Administrator / Programmer - Analyst

Training

·MapR- Big Data Converged Data Platform

Title

Enrolled

Status

Completed

ADM 200 - Install a MapR Cluster (MapR v5)

2016-Jun-05

View certificate

2016-Jun-06

ADM 201 - Configure a MapR Cluster (MapR v5)

2016-Jun-06

View certificate

2016-Jun-06

ADM 202 - Data Access and Protection (MapR v5)

2016-Jun-20

View certificate

2016-Jun-20

ADM 203 - Cluster Maintenance (MapR v5)

2016-Jun-20

View certificate

2016-Jun-20

Apache HBase Bulk Loading, Performance, and Security

2016-May-25

0 of 9 tasks

--

Apache HBase Data Model and Architecture

2016-Jun-02

View certificate

2016-Jun-05

Apache HBase Schema Design

2016-Jun-05

View certificate

2016-Jun-05

DA 410 - Apache Drill Essentials

2016-Oct-13

2 of 10 tasks

--

DEV 301 - Developing Hadoop Applications

2016-Jun-07

6 of 21 tasks

--

DEV 360 - Introduction to Apache Spark (Spark v1.6)

2016-Jun-07

View certificate

2016-Jun-07

Developing Apache HBase Applications: Basics

2017-Feb-14

0 of 9 tasks

--

Introduction to MapR Event Store

2016-Jul-25

0 of 4 tasks

--

MapR Data Platform Essentials

2016-Sep-08

View certificate

2017-Aug-14

MCCA Study Guide - MapR Certified Cluster Administrator (v5)

2016-Jun-04

Completed

2016-Jun-04

MCCA Study Guide - MapR Certified Cluster Administrator (v5)

2018-Mar-12

Completed

2016-Jun-04

zzz-ARCHIVE HDE 100 - Apache Hadoop Essentials Q2 2016

2016-Jun-07

View certificate

2016-Jun-07

·Business Objects WEBI

·Teradata Certification

·Pentaho Data Integration, Pentaho Analyzer, and Pentaho Reporting

·HP Yotta Fundamentals, HP Neoview Performance Tuning, HP NeoView Architecture, and HP Neoview Fundamentals, MySQL Administration, and MySQL Performance Tuning

·Callidus Truecomp 4.x Fundamentals, Workshop, Administration, and Datamart/ ETL Foundations (Informatica)

·TWDI- Data Warehouse Fundamentals, Advanced Concepts, and Modeling

·Oracle

·Microsoft Certified Systems Engineer (MCSE)

·Oracle Data Base Administrator Classes

Education

John’s Hopkins Carey School of Business- Data Science Essentials 2015

University of Texas at San Antonio- Management Information Systems 1994-1997

University of Hawaii at KCC- Computer Science Degree Plan 1991-1992

United States Naval Reserve- National Defense Service Medal. 1990-1997

U.S. Navy School of Electronics, Great Lakes, IL- Associate Level EE. Top five. 1990-1991

Skills Matrix

Business / Finance/ Compliance Functions

Order to Cash, Demand, Fulfillment, Supply Chain, Planning, Procurement, WMS, Chart of Accounts, G/L, SOX, GDPR and HIPPA, among others

Big Data

Hadoop, HDFS, Hive, Pig, YARN, Hbase, MapReduce, Oozie, Sqoop, Spark, Storm, Hortonworks, Cloudera, MapR.

Hortonworks Certified, MapR Certified

Concepts / Methodologies

Kimball, Inmon, Hybrid, Agile, SCRUM, RUP, Star, Snowflake, CDM, LDM, PDM, OLAP, Multidimensional Analysis, Cubes, CMMI,

BI Tools

Power BI, SSAS, Business Objects, Pentaho, Cognos, Qlikview, Tableau

Databases

HANA, MarkLogic NoSQL, Oracle, Teradata, SQL Server, Informix, Vectorwise, MySQL, PostGres, Netezza, DB2, Greenplum, Sybase, MS Access, Redshift

Modeling Tools

ERWin, Power Designer, VISIO, MySQL Workbench, Toad Data Modeler

ETL Tools

SAP Data Services, Informatica, Pentaho, DataStage SSIS, Snaplogic, Talend,

Programming Languages

Python (new), PL/SQL, SQL, MDX, DAX, Perl, Java, Java Script, JVM, R, XQuery / XML, PHP, HTML, COBOL, Pascal

Industries and Specializations

Retail, Banking, Transportation, Manufacturing, Telecom, Entertainment, Oil &Gas, Utilities, Mortgage, Finance, HR

Cloud/ Web / API / Other

Google / G-Suite, Salesforce (Multiple Projects and actual use), Azure (*1), AWS (Since 2012), iCloud,

Semantics, Triples, XSLT, XSD, REST

Networking

OSI, Web, Domains, Protocols, x.25,

OS(s)

OSX, Linux, Ubuntu, HP-UX, CentOS, Windows, Windows Server



Contact this candidate