Ben Fox, Database Engineer and Tableau Developer in Brentwood, CA, United States
Ben Fox

Database Engineer and Tableau Developer in Brentwood, CA, United States

Member since August 6, 2020
Ben is an experienced database administrator and the sole owner/administrator of many clusters and SQL servers. He excels at upgrading indexes, keys, and routines. These improvements and regular upgrades of MySQL server have enabled zero downtime and increased the speed of queries and web services. Ben has a decade of expertise working with and visualizing disparate data sources, expanding his understanding of how businesses use and need their data.
Ben is now available for hire

Portfolio

  • Toptal
    Data Build Tool (DBT), Tableau, PostgreSQL, Bash Scripting
  • Compliance and Risks
    Amazon Web Services (AWS), AWS, Google Data Studio, Terminal, CentOS, R...
  • Health Catalyst
    Qlik Sense, QlikView, SQL Server 2012, Tableau

Experience

Location

Brentwood, CA, United States

Availability

Unavailable

Preferred Environment

Tableau Server, Tableau, Linux CentOS 7, Windows, Data Build Tool (DBT), PostgreSQL

The most amazing...

...multi-node MySQL cluster I established had custom-built monitoring to remove downtime and increase the site and back-ups' speed.

Employment

  • Data Engineer and Data Analyst

    2020 - PRESENT
    Toptal
    • Built a data warehouse from flat files using DBT and daily Bash scripts.
    • Visualized the data in a series of Tableau reports with daily updates.
    • Integrated reports and data with an NCOA platform and Salesforce.
    • Created logging about the process to keep data and reporting up-to-date.
    Technologies: Data Build Tool (DBT), Tableau, PostgreSQL, Bash Scripting
  • MySQL Database Administrator

    2018 - PRESENT
    Compliance and Risks
    • Migrated multiple production MYSQL databases into an InnoDB cluster on both AWS and on premises data with less than a minute of down time.
    • Created an automatic Python process to build and update a data warehouse to give insight into customer actions/relations.
    • Built visualization reports using tools such as Tableau, Logi Analytics, and Google Data studio.
    • Scripted an automatic process to send out emails inquiring about specific problems with the database.
    Technologies: Amazon Web Services (AWS), AWS, Google Data Studio, Terminal, CentOS, R, Python, MySQL
  • Business Intelligence Developer

    2015 - 2018
    Health Catalyst
    • Created data models around healthcare from disparate data sources.
    • Converted complex Qlikview applications to work fluidly in Tableau.
    • Consulted internally and with external clients on the features and limitations of Tableau.
    Technologies: Qlik Sense, QlikView, SQL Server 2012, Tableau
  • Data Engineer

    2011 - 2014
    Ancestry.com
    • Migrated key reports from both a data warehouse change to Columnar storage (SQL to Matrix) and a visualization change (Excel and micro-strategy to Tableau).
    • Built a micro-strategy mobile app from Star Schema to Snowflake using views and all objects and reports within the micro-strategy.
    • Administrated a large Tableau server implementation of 1,400.
    Technologies: SQL Server Integration Services (SSIS), Matrix 9 Pro, Apache Pig, MicroStrategy, Tableau Server, Tableau

Experience

  • Speed Skating Python Web Scraper
    https://github.com/theyoungfox/ISUCapstone

    A Python-based application that hits a Norwegian speed skating website to pull data. This script creates a list of websites from which to request data. It creates a sort of API via the internet. This was requested by US Speed Skating to help them analyze their times.

  • Tableau Public Profile
    https://public.tableau.com/app/profile/benfox

    I created some visualizations to illustrate my Tableau skills. They are mostly for demonstration and educational purposes. I entered a few into the Tableau public contest and have some client-based dashboards I can provide on request.

Skills

  • Languages

    SQL, Python 2, Python, R
  • Tools

    Tableau, DataGrip, Terminal, Qlik Sense, MySQL Workbench
  • Storage

    MySQL, SQL Server 2012, SQL Server Integration Services (SSIS), PostgreSQL
  • Other

    Tableau Server, Data Engineering, Data Visualization, Google Data Studio, AWS, MicroStrategy, Data Build Tool (DBT), Bash Scripting
  • Paradigms

    ETL, Six Sigma
  • Platforms

    Windows, Linux CentOS 7, CentOS, QlikView, Apache Pig, Amazon Web Services (AWS)

Education

  • Master's degree in Information Systems
    2015 - 2016
    University of Utah - Salt Lake City, Utah, USA
  • Bachelor of Science degree in Economics
    2008 - 2011
    Brigham Young University - Provo, Utah, USA

Certifications

  • Tableau Server Associate
    SEPTEMBER 2014 - PRESENT
    Tableau

To view more profiles

Join Toptal
Share it with others