Skip to content
View MarkPhamm's full-sized avatar
🤓
writing some more SQL
🤓
writing some more SQL
77 followers · 30 following

Achievements

Achievement: Pair Extraordinairex4Achievement: Pull Sharkx3Achievement: YOLOAchievement: StarstruckAchievement: Quickdraw

Achievements

Achievement: Pair Extraordinairex4Achievement: Pull Sharkx3Achievement: YOLOAchievement: StarstruckAchievement: Quickdraw

Block or report MarkPhamm

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.

Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. Markdown is supported. This note will only be visible to you.
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          4 hrs 32 mins         ███████▒░░░░░░░░░░░░░░░░░   29.06 %
Other        3 hrs 42 mins         ██████░░░░░░░░░░░░░░░░░░░   23.66 %
Markdown     3 hrs 28 mins         █████▓░░░░░░░░░░░░░░░░░░░   22.22 %
Python       2 hrs 9 mins          ███▒░░░░░░░░░░░░░░░░░░░░░   13.83 %
YAML         1 hr 4 mins           █▓░░░░░░░░░░░░░░░░░░░░░░░   06.90 %

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 8 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 17 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