Data Analyst & Scientist | E-commerce | SQL, Python, GCP by Ahrum Han

Data Analyst & Scientist | E-commerce | SQL, Python, GCP

Ahrum Han

Contact for pricing

About this service

Summary

📊 Are you struggling with these?

Your sales are growing, but profit margins are shrinking

You’re spending on ads but don’t know which channels drive loyal customers

You don’t know why customers churn—or who your real VIPs are

❌ Before

Running ads with poor conversion, but unsure where the funnel breaks.

✅ After

Funnel analysis revealed a 53% drop-off from Install to Signup.

After fixing that step, conversion improved by 1.5x.

Hi! I'm a business-minded data analyst with 5+ years of experience helping e-commerce brands turn complex data into clear, actionable insights.

I’ve worked with startups and growing businesses to improve customer retention, optimize marketing performance, and automate reporting processes. From LTV and cohort analysis to ROAS optimization and funnel insights, I deliver results that drive growth.

💡 Recent Results

+9pp new user retention through funnel + email strategy

+22% ROAS via ad & inventory data sync

1.5x conversion uplift after diagnosing a 53% drop-off from Install → Signup

-90% reporting time via automated Tableau dashboards

⚙️ Tools I Use

Visualization: Tableau, Power BI, Looker Studio Data Engineering: GCP,

BigQuery, SQL, Python, ETL scripting * eCommerce Frameworks: AARRR

metrics, LTV modeling, cohort & funnel analysis

What's included

1. Analysis
Sales & Profit analysis that explain why profit isn't growing despite rising sales | Customer segmentation, RFM, LTV modeling, and retention analysis | Marketing funnel diagnostics (CTR, ROAS, CAC, CPA, etc.) | Cohort & AARRR for growth tracking | Marketing Channel Comparison | Inventory & Fulfillment Analytics | KPI Trend Tracking | Custom KPI Frameworks
2. Report
- Executive Summary Report (1–2 pages)
3. Predictive Analytics
- Predictive Modeling (ML / Time Series)
4. Data Pipeline Setup & Management
Cloud-based pipeline setup (GCP / Azure) | Data preprocessing | Output-ready formats | Moderate data cleanup | Flexible integrations

Example projects