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

Achievements

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

Achievements

Achievement: Pair Extraordinairex3Achievement: 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 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
MarkPhamm/README.md

Cover For Notion

Typing SVG

🌐 Let's Connect

StrataScratch logo

🧠 About Me

“If there’s one thing to know about me: I build data systems that turn noise into clarity - and I’ll outwork anyone to get there.”

wakatime Working on Learning visitors

Github Stats

Things I'm working on this week

SQL           3 hrs 18 mins         ████████░░░░░░░░░░░░░░░░░   31.50 %
Markdown      2 hrs 24 mins         █████▓░░░░░░░░░░░░░░░░░░░   22.95 %
Python        1 hr 42 mins          ████░░░░░░░░░░░░░░░░░░░░░   16.28 %
TypeScript    1 hr 8 mins           ██▓░░░░░░░░░░░░░░░░░░░░░░   10.89 %
CSV           46 mins               ██░░░░░░░░░░░░░░░░░░░░░░░   07.45 %

Activity Graph

WakaTime Activity

---

💼 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

📊 Stats

GitHub Snake Animation
GitHub Profile Details
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 7 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 15 1

  5. skytrax_reviews_extract_load skytrax_reviews_extract_load Public

    Forked from vietlam2002/british_airways_extract_load

    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 2

  6. skytrax_reviews_transformation skytrax_reviews_transformation Public template

    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 dimens…

    HCL 1 3