Skip to content
View alhankeser's full-sized avatar
6 followers · 6 following
Block or Report

Block or report alhankeser

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Please don't include any personal information such as legal names or email addresses. Maximum 100 characters, markdown supported. This note will be visible to only you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
alhankeser/README.md

Analytics / Data Engineer

Actively working on:

🧹 looker-janitor: Utility script to keep your Looker project tidy

looker, lookml

  • When trying to keep large Looker projects organized, Looker Janitor helps keep consistency and order across LookML files.

👓 looker-label-viewer: VS Code extension to see localized lookml label values

looker, localization

  • When working on big Looker projects with a lot of localization, it's helpful to be able to quickly see the label associated to a dimension or measure.

Recent:

💰 borsa: dbt and DuckDB transformations for day trading bot

dbt, DuckDB, python

  • A complete rewrite of my previous bot, created in 2019
  • Implementing a new API (switching from TD Ameritrade to TradeStation)
  • Exploring using sql (dbt + DuckDB) for transformations instead of purely pandas
  • Looking for ways to improve performance/concurrence of backtesting strategy ideas

Learn more

🦎 tcx-extract: fast, simple data extraction

zig, python

  • A speed-optimized extractor for .tcx (XML) files from Garmin.
  • Example implementation here.

🚴 antren: personal training analysis dashboard

airflow, python, docker, google-cloud-run, bigquery, dbt, hex

repo role deployment description
antren-app extract Dockerized python app running as Google Cloud Run Job connects to Garmin API to get latest bike rides/runs, converts tcx to tabular parquet learn more
antren-orchestration orchestrate + load Airflow webserver + scheduler (local) orchestrates the various steps of data pipeline, including triggering writing to BigQuery using training parquet files in Google Bucket learn more
antren-dbt transform Dockerized dbt-core running as Google Cloud Run Job transforms raw training data in BigQuery to make it useful for me! learn more
hex app visualize Hex app (aka a dashboard) visualizes training progress over time with ability to filter and customize layout

Pinned

  1. looker-janitor looker-janitor Public

    Clean-up utility scripts for LookML files. Being OCD about LookML has never been easier.

    Python

  2. looker-label-viewer looker-label-viewer Public

    VS Code extension to see localized labels in lookml files without having to open the localization file.

    JavaScript

  3. tcx-extract tcx-extract Public

    Speed-optimized data extractor for .tcx (Garmin) files.

    Zig

  4. borsa borsa Public

    Trading bot that relies on dbt and DuckDB for data transformations

    Python

  5. antren-dbt antren-dbt Public

    SQL 2

  6. antren-orchestration antren-orchestration Public

    Python 1