Data Engineer and Data Analyst2020 - PRESENTToptal
Technologies: Data Build Tool (DBT), Tableau, PostgreSQL, Bash Scripting
- 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.
MySQL Database Administrator2018 - PRESENTCompliance and Risks
Technologies: Amazon Web Services (AWS), AWS, Google Data Studio, Terminal, CentOS, R, Python, MySQL
- 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.
Business Intelligence Developer2015 - 2018Health Catalyst
Technologies: Qlik Sense, QlikView, SQL Server 2012, Tableau
- 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.
Data Engineer2011 - 2014Ancestry.com
Technologies: SQL Server Integration Services (SSIS), Matrix 9 Pro, Apache Pig, MicroStrategy, Tableau Server, Tableau
- 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.