Engineer Data

Summary:

I am a highly skilled data engineer with over 12 years of industry experience in data quality, data manipulation, data integrity and reporting. I am well versed in the Ralph Kimball data warehouse methodologies. I work in big data open platform environments using technologies like HDFS, Java, Informatica, SQL, Oozie, Avro, Spark. Understanding data is where I create solutions.

Work Experience:

CDK Global / Automatic Data Processing / Cobalt Seattle, WA Jan 2007 – Present

Sr. Data Engineer / Sr. ETL Developer / Software Engineer III

Accomplishments:

oClickstream workflow that processing 20m clicks a day for over 10k websites

oSales, inventory, service, and parts workflows for over 5000 car dealerships

oReputation Management workflows integrating 3 separate sources into one reporting tool

oSEO workflows measuring the viability of how your keyword and creative usage is working for over 1000 individual car dealerships, numerous dealership groups, and on national and regional levels for BMW, GM, Kia, Hyundai, and Volkswagen.

oHelped in building a very complex and sophisticated test environment that runs 100+ workflows in over 700 database tables running 6000+ unit tests every night

oHelped in production of a Java/Spring ETL template that runs on a Docker grid, utilizing ETL best practices and operates in a plug n play fashion.

Job Tasks:

oCreate data loading processes, applications, and workflows that utilize Informatica, Java, Oozie, HDFS, Hive, Spark, Camus, Avro, Perl, and Unix Bash

oInterpret requirements into viable business solutions

oAnalyze data and determine discrepancies and potential metrics

oSource data in databases, XML, Flat File, and JSON format.

oProduction support

oMentor team

Expeditors International of Washington Seattle, WA Jun 2005 – Jan 2007

Data Warehouse Engineer

Accomplishments:

oCreated 4 projects from start to finish with being technical lead on 3 of them.

oRedesigned and tuned an existing data mart for better efficiency and accuracy.

oDesigned a web based dashboard, having used standard bar graphs, line graphs, scatter plot graphs, links to data folders, and scales for percentage measures

oDesigned a data mart from start to finish

oReverse engineered an undocumented database into an ERD (entity relational diagram) that will be used in current and future projects concerning the data mart

Daily tasks:

oUse Informatica to build ETL load strategies

oUse MicroStrategy to build BI Reports

oProduction support

Restaurant Appliance Service Seattle, WA Jun. 1996 – Dec. 2004

Parts Technician

United States Marine Corps Camp Pendleton, CA Jul 1991 – Oct 1995

MMC (Marine Corps Integrated Maintenance Management Chief)

Skills:

Database:

oPostgreSQL / Greenplum, Oracle, DB2, SQL Server,

oMongoDB

oHDFS / Hive / Hadoop

Programming:

oJava utilizing Spring Boot

oPerl / UNIX Shell Scripting

oPL/SQL / PSQL

oApache Spark

oSQL

Data Loading

oInformatica, Oozie

oXML, JSON, Avro

Agile Development Techniques

oJira, Crucible

Big Data

Perforce, Git, Stash

Database Modeling, Theory, and Design

Data warehousing, data analysis, strategies and methodologies

SDLC

Software Testing Procedures

Leadership / Management

Volunteering:

Youth football coach for 6 seasons of football – Head Coach for 1 season

Board Member and Webmaster for Lake Stevens Youth Football

Education:

Edmonds Community College Edmonds, WA Jan 2004 – Dec 2005

Computer Information Systems –Associates of Technical Arts

Graduated with honors

Contact this candidate