Hi, I'm Keegan...

Experience

2023 ➟ Present

Walmart ❯ Senior Data Analyst

Build and maintain executive reporting to support business-critical transformation initiatives and product analytics. Take end-to-end ownership of data engineering and analytics processes, including architecting, building, and maintaining production data pipelines in a cloud data warehouse. Apply data modeling principles to design optimized, analytics-ready datasets. Research, scope, and implement emerging technologies to advance team capabilities.

Python
SQL
GCP
Linux
Git
DBT
Tableau
PowerBI

2022 ➟ 2023

PAM Transport ❯ Systems Analyst

Design and develop core semantic data models using Power BI/Power Query to enable operational, financial, and executive reporting. Build and maintain ETL pipelines to aggregate and cleanse data from diverse sources, ensuring accuracy and availability. Collaborate with leadership to define analytic needs, requirements into actionable insights within the Business Analytics team. Evaluate and optimize existing technologies and processes to drive continuous improvement.

SQL
Data Modeling
PowerBI
Power Automate

2021 ➟ 2022

PAM Transport ❯ Associate Systems Analyst

Developed and maintained operational reporting solutions for Fleet Maintenance and Operations using Power BI and Excel. Designed and optimized complex DAX measures and leveraged SQL to extract and transform data from on-premise SQL Server and MySQL databases. Managed and enhanced core semantic data models to support organization-wide reporting and data-driven decision-making.

SQL
Excel
PowerBI
Power Query

Projects

Web Development ❯ This Website!

Docker containerized Next.JS application using TailwindCSS to manage styling. Hosted on Heroku, using Github Actions for CI/CD deployment pipeline.

Typescript
React (Next.JS)
Docker
CI/CD

 

Web Development ❯ Branch Library

Cooperative Web App for Text Editing, written in Flask. Collaborative version control system for users. Rich text editing.

Python
Flask
SQL
HTML/CSS
Data Modeling

Data Engineering ❯ Dark Oura

Self Service Analytics Pipeline for Oura Biometric Tracker.

Python
Streamlit
Data Viz

Data Science ❯ Thrasher Webscraping NLP Pipeline

Scrape, Process, and store data from ThrasherMagazine for NLP sentiment analysis.

Selenium
DBT
Apache Airflow
Postgres

App Development ❯ GoQuery

GCP BigQuery connection app to export full query resultsets to csv. Written in Go.

Golang (Go)
Fyne
GCP (BigQuery)