Skip to content
View MarkPhamm's full-sized avatar
πŸ€“
writing some more SQL
πŸ€“
writing some more SQL

Block or report MarkPhamm

Report abuse

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

Report abuse
MarkPhamm/README.md

Cover For Notion

🌐 Let's Connect

StrataScratch logo


🧠 About Me

"Analytics isn't just my job - it's my obsession. Scroll down and see for yourself"

wakatime Working on Learning visitors


πŸ’Ό Experience

  • Analytics Engineer @ Insurify, Inc. – Marketing Tech & Core Analytics
  • Data Engineer Intern @ Lazard & Co Ltd – Financial Advisory Team
  • Business Intelligence Engineer Intern @ Techsmith Corp – Sales, Marketing & Ops
  • Data Analyst Intern @ Corning Inc. – Global Supply Chain
  • Data Science Analyst Intern @ KPIM – Consulting Team
  • Data Science Analyst Intern @ NAPAS Vietnam – Fraud and Risk Team
  • Admin and Moderator of Xom Data - Vietnam's largest Data learning community (70,000+ members)
  • Builder of xomdata.com (learning platform) & jobs.xomdata.com (Data job board)

πŸ“Š Stats

GitHub Stats

Things I'm working on this week

SQL           7 hrs 16 mins         β–ˆβ–ˆβ–ˆβ–ˆβ–ˆβ–ˆβ–ˆβ–ˆβ–ˆβ–ˆβ–ˆβ–ˆβ–“β–‘β–‘β–‘β–‘β–‘β–‘β–‘β–‘β–‘β–‘β–‘β–‘   51.33 %
Markdown      2 hrs 4 mins          β–ˆβ–ˆβ–ˆβ–“β–‘β–‘β–‘β–‘β–‘β–‘β–‘β–‘β–‘β–‘β–‘β–‘β–‘β–‘β–‘β–‘β–‘β–‘β–‘β–‘β–‘   14.68 %
Other         49 mins               β–ˆβ–’β–‘β–‘β–‘β–‘β–‘β–‘β–‘β–‘β–‘β–‘β–‘β–‘β–‘β–‘β–‘β–‘β–‘β–‘β–‘β–‘β–‘β–‘β–‘   05.87 %
YAML          48 mins               β–ˆβ–’β–‘β–‘β–‘β–‘β–‘β–‘β–‘β–‘β–‘β–‘β–‘β–‘β–‘β–‘β–‘β–‘β–‘β–‘β–‘β–‘β–‘β–‘β–‘   05.73 %
JSON          44 mins               β–ˆβ–’β–‘β–‘β–‘β–‘β–‘β–‘β–‘β–‘β–‘β–‘β–‘β–‘β–‘β–‘β–‘β–‘β–‘β–‘β–‘β–‘β–‘β–‘β–‘   05.27 %

Activity

Activity Graph

WakaTime Activity

Contributions

GitHub Snake Animation
GitHub Profile Details

Coding Challenges

LeetCode Stats

StrataScratch Stats

Pinned Loading

  1. local_warehouse_pipeline local_warehouse_pipeline Public

    A local-first Data Warehouse ELT pipeline that extracts CFPB consumer complaint data, transforms it with dbt into analytics-ready models, and serves interactive dashboardsβ€”all running on your lapto…

    Jupyter Notebook 11 5

  2. Stats-Calculator Stats-Calculator Public

    A user-friendly app for performing various statistical analyses. Easily calculate and visualize key statistics including mean, median, standard deviation, and more. Ideal for quick and accurate dat…

    Python 3 4

  3. consumer_complaint_pipeline consumer_complaint_pipeline Public

    An automated data pipeline for extracting, loading, and analyzing consumer complaint data from the Consumer Financial Protection Bureau (CFPB) database. This production-ready solution enables finan…

    Python 1 1

  4. local_streaming_pipeline local_streaming_pipeline Public

    End-to-end real-time analytics pipeline with Kafka, Spark micro-batch/Spark Streaming/Flink, ClickHouse, and live dashboards.

    HTML 18 1

  5. Xom-Data/skytrax_reviews_extract_load Xom-Data/skytrax_reviews_extract_load Public

    Production-grade EL pipeline that scrapes 160,000+ airline reviews from AirlineQuality.com, stages partitioned data to S3 (Managed by tf), and loads into Snowflake for down stream dbt.

    Python

  6. Xom-Data/skytrax_reviews_transformation Xom-Data/skytrax_reviews_transformation Public

    About Skytrax airline reviews data platform β€” Snowflake, dbt, Terraform, AWS (S3, CloudFront, IAM OIDC), GitHub Actions slim CI/CD with zero-copy cloning, SQLFluff linting, and Kimball star schema …

    HCL