I turn customer, sales and network data into decisions that move revenue — building the data, analysis and models behind them, and following through until the business acts on the results.
- Telecom, Thailand — mobile, home broadband and retail channels, in Customer Value Management
- End to end — data engineering (ETL, star schemas, SQL on Vertica / Netezza / SQL Server), analysis, dashboards, and ML when it earns its place
- Business first — every project starts from a business question and ends with a number that changed
These are real work projects. Figures are rescaled or synthetic to protect confidential data; the patterns, rankings and conclusions are unchanged.
| Project | What it does | Impact |
|---|---|---|
| Sales Monitoring Dashboard · ▶ live demo | Python ETL → SQL Server star schema → in-browser metric engine. 3 dashboards (desktop + mobile) for 7-11 and retail channels, click-to-filter, tests and CI | Drove 5 sales game plans: +10% to +15% growth in focus stores |
| Digital Product Analytics | MAU, ARPU uplift and cohort-survival reporting for digital products; root-cause deep-dive on why OTT buyers churn | Sales guardrails predicted to increase OTT customer retention by 3% |
| 5G Customer Analytics | 5G flags in the High Value report with point-in-time joins; provisioning framework joining subscribers to their most-used cell site | Prioritised customer groups and areas: who to provision first, where to build, where 5G fails |
| Home Broadband Device Analytics | Turns router Wi-Fi logs into a household device profile for ~2.5M homes and finds the upsell gaps | 3 sized upsell use cases (Mesh Wi-Fi, CCTV, TV box), 575K–730K homes each |
| Project | What it does | Result |
|---|---|---|
| Telecom Alarm Grouping (GNN) · ▶ live demo | Groups network alarms into incidents with a GATv2 graph neural network trained on weak labels, average-linkage clustering, a live 5-minute engine and a 3-D incident view | 12.1% of tickets merged into incidents at 81.7% precision |
Data & SQL — Vertica · Netezza · SQL Server / T-SQL · star-schema modelling · ETL design Python — pandas · data pipelines · graph neural networks (GATv2) · clustering · unit tests Visualisation — JavaScript dashboards (Chart.js, Leaflet) · interactive 3-D views · PowerPoint for management Delivery — Git & GitHub Actions · GitHub Pages · Cloudflare