Skip to content
View MarkPhamm's full-sized avatar
🤓
writing some more SQL
🤓
writing some more SQL
91 followers · 31 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

May 2022 - Sep 2022



KPIM
Data Science Intern 		➔ May 2022 - Sep 2022



NAPAS
Data Analyst Intern 		➔ Jan 2023 - May 2023



Corning Inc.
Data Analyst Intern 		➔ Jan 2024 - May 2024



TechSmith Corp
BI Engineer Intern 		➔ May 2024 - Aug 2024



Lazard
Data Engineer Intern 		➔ May 2025 -



Insurify
Analytics Engineer 		➔ May 2025 -



Xóm Data
Builder

🛠️ Techstack & Ecosystem

image

🛠️ Tech Stack & Reference Logos

🏢 Data Warehouse Snowflake Redshift BigQuery
🌊 Data Lakehouse Databricks DuckDB MotherDuck Iceberg Delta Lake Trino PrestoDB Pinot Hive HDFS
🔄 Data Processing & Transformation Apache Spark Spark Structured Streaming Flink Alteryx Kafka Kinesis CDC dbt Core
📥 Data Integration & Reverse ETL Airbyte Fivetran dltHub Hightouch
⚙️ Orchestration Apache Airflow Astronomer Prefect Mage Dagster Orchestra
📊 BI & Analytics Mode Hex Power BI Tableau Looker Studio Streamlit Visivo Lightdash Superset Datadog
🚀 DevOps & Cloud Terraform Docker Kubernetes Git GitHub Actions AWS GCP
🤖 AI Tooling Claude Code Cursor Codex MCP servers (dbt, Asana, Slack)

📊 Stats

GitHub Stats

Contribution Cityscape GitHub Stats

Top Languages

Line Divider

Things I'm working on this week

SQL          3 hrs 33 mins         ████████▓░░░░░░░░░░░░░░░░   35.05 %
Other        2 hrs 7 mins          █████▒░░░░░░░░░░░░░░░░░░░   20.89 %
YAML         1 hr 11 mins          ███░░░░░░░░░░░░░░░░░░░░░░   11.83 %
Python       1 hr 11 mins          ███░░░░░░░░░░░░░░░░░░░░░░   11.77 %
Markdown     1 hr 7 mins           ██▓░░░░░░░░░░░░░░░░░░░░░░   11.15 %

Activity

Activity Graph

WakaTime Activity

Contributions

GitHub Streak Stats GitHub Profile Details

Coding Challenges

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