Skip to content
View harley130613's full-sized avatar

Block or report harley130613

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.

Content in all repositories owned by your account will be closed.
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
harley130613/README.md

Trần Thị Cẩm Loan

Data Analyst  ·  Marketing, CRM & Customer Analytics

typing


🖥️ about me

$ cat about_me.txt

I'm Cẩm Loan (Harley) - a Data Analyst at an app-based driver service platform in Vietnam. I dig into 500K+ trips and 400K+ users to find where customers drop off, why they don't come back, and which campaigns actually pay off. I build dashboards, design CRM & voucher programs, and automate reporting so the team can move faster. Currently open to Data Analyst roles in Marketing, CRM and Customer Analytics.



📂 featured projects

Project Key result
🧲 New-Customer Promotion Program — milestone-based vouchers + cohort dashboard 50% R0, 30% R30, +10.4 pp vs baseline
🔁 Reactivating Dormant Customers — CRM segmentation + voucher A/B tests 38% CVR, 30.02% redemption on 10K vouchers
📱 Paid Ads Attribution (Airbridge) — ROAS & CAC Index across 4 ad channels Apple Search 8.42x vs Facebook 0.69x ROAS
📈 BI Dashboard & Demand Forecasting — Gradient Boosting by day & region MAPE 26.75%, 13.35 pp better than baseline
🎟️ Voucher Conversion Optimization — targeting, expiry, timing, allocation Data-backed uplift plan
🚗 Ride-hailing Marketplace Analysis — funnel, campaign ROI, driver supply End-to-end SQL + Python

🏆 wins

🥇 2025 — Outstanding Contribution Employee of the Year
⭐ 2026 — Recognized for Positive Contribution through Analytical Reporting
📊 +33.5% YoY trips  ·  −50% cancelled trips  ·  +40% new-user conversion  ·  +20% return rate


let's talk data.

📍 Ho Chi Minh City, Vietnam

Pinned Loading

  1. Bi-demand-forecasting-project Bi-demand-forecasting-project Public

    BI dashboard + Gradient Boosting trip-demand forecast by day and region: MAPE 26.75% (13.35 pp better than baseline)

    Python

  2. MKT-voucher-conversion-optimization MKT-voucher-conversion-optimization Public

    SQL + Python diagnosis of low voucher conversion for a designated-driver service — segment targeting, expiry, discount value, push timing, and province allocation, with a data-backed 3.5x uplift ba…

    Jupyter Notebook

  3. new-user-promotion_program_project new-user-promotion_program_project Public

    Redesigned a new-user voucher program with behavioral milestones & cohort tracking: 50% activation (R0), 30% retention (R30)

    Python

  4. oracle-bus-ticket-management-db oracle-bus-ticket-management-db Public

    Database quản lý bán vé xe khách (Oracle PL/SQL) - đồ án học phần Hệ quản trị CSDL 2. Trigger, procedure, function, package, view, phân quyền user/role. Tổ chức lại + sửa lỗi từ bản gốc, kèm tài li…

  5. paid-ads-attribution-analytics paid-ads-attribution-analytics Public

    Paid ads attribution on MMP Airbridge: ROAS & CAC Index across Google, Apple Search, TikTok, Facebook Ads vs Organic

    Python