Software Engineering graduate (B.Eng, Mae Fah Luang University, GPAX 3.76/4.0) and Google-certified Data Analyst based in Bangkok.

I build things that turn raw, messy data into clear insights — from automated ETL pipelines to analytical dashboards. My background spans data engineering, digital analytics, and statistical analysis, with a long-term goal of becoming a Data Engineer.

profile = {
    "name"        : "Htoo Pyae Shan",
    "location"    : "Bangkok, Thailand",
    "education"   : "B.Eng Software Engineering · Mae Fah Luang University · Graduated 2026",
    "certification": "Google Data Analytics Professional Certificate · 2025",
    "currently"   : "Seeking Junior Data Analyst roles in Bangkok",
    "goal"        : "Data Analyst → Data Engineer",
    "languages"   : ["Burmese (Native)", "English (Fluent)", "Thai (Elementary)", "Chinese (Basic)"]
}

Data Analysis

Visualization & BI

Pipeline & Infrastructure

Power BI DAX Power Query Star Schema data.go.th World Bank API

4-page interactive Power BI dashboard analyzing Thailand's international tourism recovery from 2015–2023, using real government (data.go.th) and World Bank data. Designed a star schema data model with a custom DimDate calendar table and DAX time intelligence (SAMEPERIODLASTYEAR, CALCULATE, FILTER/ALL). Built 9 DAX measures identifying China's post-COVID recovery gap as Thailand's largest unrealized tourism opportunity, across Executive Overview, Market Analysis (with drillthrough), Seasonality & Composition, and Recovery Opportunity pages. Delivered via GitHub with README, walkthrough GIF, PDF export, and the .pbix file.

Python Pandas SQLite Google Search Console API Docker Chart.js

End-to-end ETL pipeline that extracts Google Search Console data via API, transforms with Pandas, stores in SQLite, and visualizes in an interactive browser dashboard. Solves Google Search Console's 16-month data retention limit — data grows indefinitely. Containerized with Docker.

Google Apps Script Telegram Bot API Google Drive OCR Google Sheets PropertiesService

Personal finance automation system: a Telegram bot reads Thai bank payment slip photos via OCR, extracts amount/date/bank/memo automatically, then logs structured records into a relational Google Sheets database. Features split transaction detection, multi-step conversational flows via server-side session management, and Thai Buddhist Era date parsing.

Python Pandas NumPy Matplotlib Seaborn

Data preparation project for NYC TLC fare prediction (Google Advanced Data Analytics Certificate capstone). Cleaned 22,699-row dataset, engineered trip_duration_minutes and avg_speed_mph features, removed 192 anomalous records (0.847%). Confirmed trip_distance correlation of 0.94 with target variable via EDA.

R Tidyverse ggplot2

EDA and visualization of FitBit fitness tracker data (30 users, 1,397 records) for BellaBeat, a wellness consumer brand. Discovered users average 993 min/day sedentary vs 19.7 min/day very active. Delivered product engagement recommendations via ggplot2 visualizations.

• 🔍 Seeking Junior Data Analyst roles in Bangkok
• 📊 Building more analytics and BI projects
• 🎓 Graduate — B.Eng Software Engineering, Mae Fah Luang University
• 🌐 Portfolio: hpsgh.github.io