Kirk Crabb

Kirk Crabb

Sr. Data Engineer
United States of America
Portuguese

About Me

Sr. Data Engineer with experience in business intelligence, reporting, SQL, Tableau, MicroStrategy, SAP BODS, Snowflake, RabbitMQ, Teradata, MySQL, and Microsoft Excel. Experienced in creating reports, dashboards, dimens…

Experience

Data Engineer

Doterra
Feb 2017 - Present · 9 years 5 months

● Creating SQL and graphical views for Tableau to access data to the data warehouse.
● Creating basic Tableau reports to transition from an internal reporting platform
● ETL using SAP BODS. This includes migrating users from an InfoTrax (Oracle) system to an SAP system.
● Maintaining an existing RabbitMQ process to obtain real-time data in SAP. This includes refreshes of tables and ensuring data quality.
● Creating dimensional models to transition off SAP and move to Snowflake

Sr. Data Engineer

doTERRA
Feb 2017 - Present · 9 years 5 months

Creating SQL and graphical views for Tableau to access data to the data warehouse.
Creating basic Tableau reports to transition from an internal reporting platform.
ETL using SAP BODS.
Migrating users from an InfoTrax (Oracle) system to an SAP system.
Maintaining an existing RabbitMQ process to obtain real-time data in SAP.
Refreshing tables.
Ensuring data quality.
Creating dimensional models to transition off SAP and move to Snowflake.

Sr. Business Intelligence Developer & Report Strategist

Overstock.com
Apr 2014 - Jan 2017 · 2 years 9 months

Creating business reports for the Merchandising and Marketing department to assist in business strategies using the MicroStrategy and Tableau platforms.
Creating dashboards, charts, and graphs.
Working with the business in the scrum framework to create stories based on reporting needs.
Creating SQL queries based on ad-hoc requests.
Presenting reports in MicroStrategy Visual Insight or through Microsoft Excel.
Participating in the BI Developer Mentoring program as a mentor.

District Manger

MediaOne
Sep 2005 - Jun 2014 · 8 years 9 months

Ensuring newspaper carriers are executing their routes in a timely and accurate manner, meeting the deadline of 6 am.
Filling in for open routes when needed.
Verifying previous complaints to confirm the newspaper was delivered accurately.
Verifying the delivery of newspapers to the depot for carriers to receive is accurate.
Managing complaints throughout the day by arriving at each complaint's home and discussing the issue to be sure it's resolved in the future.
Gathering reports and meeting daily with carriers in a one-on-one basis to discuss how to improve the route and the previous day's complaints.

Billing Analyst/Technical Writer

eBay, Inc.
Mar 2006 - Jan 2014 · 7 years 10 months

Processing refund requests made by members and submitted by CSRs.
Reinstating accounts suspended for non-payment.
Rebalancing accounts for incorrect past-due amounts.
Completing ad-hoc data warehouse reporting requests from customer support and global managers.
Creating and running SQL queries through eBay’s data warehouse environment using Teradata.
Creating and running SQL queries through an internal billing data servers using MySQL.
Writing all the billing email responses used by all customer support agents.
Writing all online billing help pages for customer-facing online help.
Writing all Knowledge Base articles for the billing department for customer support agents to query.

Skills

Big Data Data Repository Amazon Web Services (AWS) Kafka NoSQL Redshift S3 SQL MicroStrategy Tableau HTML Windows Mac OS Microsoft Excel Scrum SAP HANA Studio SAP Data Services SAP BODS RabbitMQ Snowflake Teradata MySQL Oracle Data Warehousing ETL Dimensional Modeling Business Intelligence Dashboarding Reporting Data Analysis
Report this Profile?