Open to Data Analyst & Data Engineer Intern Roles
DATA ANALYST | DATA ENGINEER

Hi there, I’m
Ao Minh Tâm

IT undergraduate focused on Data Analytics and Data Engineering. I use SQL, Python, Power BI, and modern cloud data tools to transform raw data into reliable datasets, actionable insights, and business recommendations.

📍 Ho Chi Minh City, Vietnam • Updated Nov 2026
AT
DA · DE

ABOUT ME

I am a Third-Year Information Technology undergraduate at Ho Chi Minh City University of Natural Resources and Environment (HCMUNRE), with a strong interest in Data Analytics and Data Engineering.

I enjoy exploring data, identifying meaningful patterns, and building reliable data workflows that support business decision-making. Through hands-on personal projects, I have worked with SQL, Python, Power BI, AWS, Snowflake, Apache Airflow, and dbt, developing practical experience in data analysis, dimensional modeling, and cloud-based ELT pipelines.

I am currently seeking an opportunity to apply my technical skills, strengthen my analytical thinking, and grow as a Data Analyst or Data Engineer Intern.

Languages: Native Vietnamese | Intermediate English.

EDUCATION

2024 – Expected 2028

Ho Chi Minh City University of Natural Resources and Environment (HCMUNRE)

Third-Year IT Undergraduate — Bachelor of Science in Information Technology

Focused on Database Management Systems, SQL Querying, Dimensional Data Modeling, Cloud ELT Pipelines, and Quantitative Business Analytics.

TECHNICAL SKILLS

Data Analytics & BI

SQL, Python & Storytelling

Hands-on
Python (Pandas, NumPy, EDA) SQL (Joins, CTEs, Window Functions) Plotly, Seaborn & Matplotlib
Working Knowledge
Power BI (DAX, Star Schema) Microsoft Excel (Pivot, Power Query) mlxtend (Apriori) & squarify
Applied in: Customer RFM 360, Conversion Funnel, Cohort Retention, Sankey Flow, Market Basket & Pareto ABC

Cloud & Data Warehousing

AWS Infrastructure & Storage

Hands-on
AWS S3 (Versioning, Lifecycle) AWS SQS + Dead-Letter Queue Amazon Redshift Serverless
Working Knowledge
AWS CloudFormation (IaC) CloudWatch Alarms, SNS & IAM Snowflake Data Cloud
Applied in: AWS E-Commerce Event-Driven ELT (V5.0.1) & Snowflake Cloud ELT Pipeline

Orchestration, Modeling & CI

Pipelines, Testing & DevOps

Hands-on
Apache Airflow 3 (AssetWatcher, Cosmos) dbt Core (Incremental, Schema Tests) Kimball Star Schema & Medallion
Working Knowledge
Docker & Ubuntu WSL2 GitHub Actions CI (Ruff, cfn-lint) Unit Testing (Unittest / Pytest)
Applied in: Two-Phase Atomic Swaps, Audit Ledger Safe ACK, dbt Marts & 3-Job CI Pipelines

FEATURED PROJECTS

Showing 4 featured flagship projects (2 DE + 2 DA). Expand below to view all 9 case studies or filter by role.

FLAGSHIP PIPELINE • DATA ENGINEERING • V5.0.1 (OCT – NOV 2026)

AWS E-Commerce Modern Data Pipeline (Event-Driven ELT) ↗

  • Business Outcome: Automated ingestion and validation of 99,441 Olist orders (~120 MB) into analytics-ready warehouse marts while eliminating scheduled empty runs and keeping idle AWS compute at $0.
  • Technical Implementation: Provisioned CloudFormation IaC (15 core resources), S3 → SQS (20s Long Poll) + DLQ alerting (4 CloudWatch Alarms + SNS), Airflow 3 AssetWatcher, Two-Phase Redshift swaps, and incremental dbt Star Schema marts.
  • Verification & Testing: Release 5.0.0 passed live AWS E2E checks (17/17 tasks, 11 dbt schema tests, DLQ Redrive); release 5.0.1 passes 21/21 Python unit tests, 3 DAG tests, and offline dbt parse in CI.
AWS CloudFormation S3 / SQS + DLQ Redshift Serverless Airflow 3 (AssetWatcher) dbt Core CloudWatch & SNS Docker
CLOUD ELT • DATA ENGINEERING • JUN 2026

Automated End-to-End Cloud ELT Pipeline (Snowflake & dbt) ↗

  • Business Outcome: Replaced manual SQL scripts with a reproducible containerized ELT workflow producing clean, BI-ready Kimball dimensional tables on Snowflake TPC-H data.
  • Technical Implementation: Modeled Medallion Staging (stg_tpch_orders) and pre-joined Star Schema marts (fct_orders) using modular dbt SQL and dbt_utils to reduce repetitive BI joins.
  • Verification & Orchestration: Integrated Astronomer Cosmos inside an isolated dbt_venv to generate dynamic Airflow task groups and run automated primary/foreign-key schema tests.
Snowflake dbt Core Apache Airflow (Cosmos) Docker Python SQL
CUSTOMER INTELLIGENCE • DATA ANALYTICS • SEP 2026

Customer 360 & Dynamic RFM Segmentation Analysis ↗

  • Business Outcome: Found that top 2 tiers (<29% of 17,415 customers) contribute >53% of revenue ($3.45M+), while 833 churn-risk Cant-Lose accounts hold 10.0% historical sales ($653k).
  • Technical Method: Segmented 51,290 line-items (25,728 distinct OrderIDs, 2020–2023 simulated dataset) into 8 RFM tiers via pd.qcut (snapshot 2024-01-01) and built Customer 360 demographic profiles.
  • Action & Measurement: Proposed a 70/30 win-back budget pilot and dormant outreach suppression, evaluated via 90-day repeat purchase rate, retention, and incremental revenue.
Python Pandas NumPy Seaborn squarify
CONVERSION DIAGNOSTICS • DATA ANALYTICS • SEP 2026

Product Performance & Conversion Funnel Analysis ↗

  • Business Outcome: Pinpointed why Love Bear attracts only 10.0% of catalog views despite converting 55.6% PDP-to-Cart (vs. Mr. Fuzzy at 62.2% / 43.0%), alongside a ~66% cart-to-order drop-off bottleneck.
  • Technical Method: Built sequential unique-session Plotly funnels (/products → PDP → /cart → /thank-you-for-your-order) across 261,231 catalog sessions (472,871 total sessions; 32,313 orders) and computed Net Revenue After Refunds.
  • Action & Measurement: Proposed A/B tests for Love Bear cross-sell placement and 1h/24h cart-recovery reminders, tracked via Cart-to-Order completion and Net Revenue per Session.
Python Plotly (Funnel) Pandas NumPy Seaborn
BEHAVIORAL ANALYTICS • DATA ANALYTICS • SEP 2026

Cohort Analysis & Customer Retention Dynamics ↗

  • Business Outcome: Diagnosed an early 1%–3% Month-1 retention baseline alongside recurring B2B restock bumps (5%–6% at Months 5 and 8) across 51,290 simulated transactions (2020–2023).
  • Technical Method: Modeled B2B/B2C cohort retention heatmaps and eliminated left-truncation bias by anchoring FirstPurchaseDate globally before filtering 2022 cohort windows.
  • Action & Measurement: Proposed Day 20–25 nurture campaigns and Month 4/7 B2B CRM alerts, measured through cohort holdouts on Month-1 and Month-3 retention rates.
Python Pandas NumPy Seaborn Matplotlib
NETWORK VISUALIZATION • DATA ANALYTICS • SEP 2026

User Journey & Traffic Flow Sankey Analysis ↗

  • Business Outcome: Traced multi-touch acquisition and repeat-purchase flows across 1.18M+ pageviews (32,313 orders), exposing heavy mobile drop-off and Mr. Fuzzy → Love Bear cross-sell patterns.
  • Technical Method: Filtered 211,640 single-page bouncers to isolate 261,231 engaged sessions, resolved circular Plotly Sankey crashes with chronological .rank() prefixes, and trimmed join memory via usecols.
  • Action & Measurement: Recommended a mobile checkout UX audit and 14-day post-purchase cross-sell triggers, measured via mobile Cart-to-Order rate and 30-day repeat purchase lift.
Python Plotly (Sankey) Pandas NumPy
ALGORITHMIC MINING • DATA ANALYTICS • AUG – SEP 2026

Market Basket Analysis & Product Bundling Strategy ↗

  • Business Outcome: Uncovered Home Spa & Wellness co-purchase ecosystems across 25,728 baskets, surfacing cross-category affinities up to 4.25 Lift and 45% confidence.
  • Technical Method: Tuned Apriori min_support to 0.005 (≥129 orders) to prevent combinatorial OOM failures and deduplicated basket items via .unique() before TransactionEncoder.
  • Action & Measurement: Designed a 10%-discounted 4-item bundle pilot to test via 50/50 checkout A/B testing on Incremental Gross Profit per Order and AOV Lift.
Python mlxtend (Apriori) TransactionEncoder Pandas Seaborn
PROFITABILITY & BUDGET AUDIT • DATA ANALYTICS • SEP 2026

Customer Profitability Segmentation via Pareto ABC Analysis ↗

  • Business Outcome: Audited a 500-gift appreciation budget across 17,415 customers, finding 2,254 Group A accounts (12.94%) generate 80% of cumulative profit (dataset Profit field)—exposing a 1,754-account gap.
  • Technical Method: Executed IQR outlier scanning across 51,290 transactions (25,728 orders), aggregated transaction profitability, and segmented ABC tiers via cumulative sums.
  • Action & Measurement: Proposed physical gifts for Top 1–500 VIPs and digital rewards for Ranks 501–2,254, validated against holdout controls on 90-day retention and reward ROI.
Python Pandas NumPy Seaborn Matplotlib
REVENUE CONCENTRATION • DATA ANALYTICS • SEP 2026

E-Commerce Revenue Contribution Analysis (Pareto 80/20) ↗

  • Business Outcome: Quantified SKU revenue concentration across 32,313 orders (Maven Fuzzy Factory), showing 3 core SKUs drive ~82% of net revenue with 45.2% reliance on a single flagship SKU.
  • Technical Method: Deducted item-level refunds to compute Net Revenue After Refunds and Gross Margin (price_usd - cogs_usd) before descending Pareto cumulative sorting.
  • Action & Measurement: Proposed safety-stock buffers for top 3 SKUs, tail-SKU bundling, and ROAS-monitored ad allocation tests evaluated via Inventory Turnover and Incremental ROAS.
Python Pandas NumPy Matplotlib Seaborn

CREDENTIALS & TRAINING

dbt Labs
Verified Credential

dbt Fundamentals — Verified Credential

Issued by dbt Labs (Credential ID: daf3523f)

Demonstrates core competency in building, testing, and documenting modular SQL transformation pipelines and dimensional models using dbt Core & Cloud.

Data Modeling dbt Tests Jinja & Macros Documentation
ASEAN Foundation • LinkedIn
Certificate of Completion

AI Career Readiness Training

ASEAN Ahead • Issued Nov 21, 2026 (ada.aseanfoundation.org)

Completed structured training organised by ASEAN Foundation and supported by LinkedIn covering practical AI fluency, prompt workflows, and digital career readiness.

AI Fluency Prompt Workflows Career Readiness

GET IN TOUCH

Open to Data Analyst and Data Engineer Intern opportunities, as well as data architecture and analytics discussions.