Transforming Data
into Strategic
Insights.

I Engineer End-to-End Data Solutions &
Drive Measurable Businness Impact through Analytics

Subhanu Chamaka

About Me.

I'm Subhanu Liyanage. A Full Stack Data Engineer & Data Scientist with a passion to build end-to-end solutions by combining data, engineering and design. I specialize in building end-to-end Data Engineering solutions across platforms and in generating data driven insights that drive business impact.

I excel as a collaborative team player dedicated to achieving collective goals. I'm committed to continuous learning and delivering solutions that create measurable ROI.

Technologies & Frameworks
I Work With.

AWS AWS
Azure Azure
GCP GCP
Python Python
Pandas Pandas
Scikit-learn Scikit-learn
FastAPI FastAPI
MySQL MySQL
PostgreSQL PostgreSQL
Snowflake Snowflake
BigQuery BigQuery
Apache Airflow Airflow
Power BI Power BI
Tableau Tableau
Looker Studio Looker Studio
Grafana Grafana
Streamlit Streamlit
Google Analytics GA4
n8n n8n
HTML5 HTML5
CSS3 CSS3
JavaScript JavaScript
Chart.js Chart.js
Git Git
Linux Linux
Figma Figma
Postman Postman

Selected Works &
Projects.

Category (Click on a Category to Filter)
Technologies (Filter by Stack)
Bank customer churn prediction model
ML & Data Science

Bank customer churn prediction model

A machine learning solution with a FastAPI backend and interactive frontend to predict and visualize bank customer churn using Random Forest.

Python FastAPI Scikit-learn HTML
Credit Card Fraud Detection
ML & Data Science

Credit Card Fraud Detection

An interactive fraud detection application built with PyCaret's AutoML and Streamlit to identify fraudulent credit card transactions from skewed datasets.

Python Streamlit Pycaret
Telegram Bot for Colombo Stock Exchange
AI

Telegram Bot for Colombo Stock Exchange

An AI-powered Telegram bot providing real-time financial insights and automated market updates for the Colombo Stock Exchange using n8n and LLMs.

n8n
ICC T20 Cricket Big Data Engineering Solution | Azure
Data Engineering

ICC T20 Cricket Big Data Engineering Solution | Azure

A robust end-to-end big data pipeline leveraging Lambda Architecture to process real-time and historical T20 cricket data into interactive dashboards.

Azure Azure Databricks ADF Azure Synapse Azure Stream Analytics Python Power BI
RAG based Chatbot using n8n
AI

RAG based Chatbot using n8n

An agentic RAG workflow using n8n, Pinecone, and LLMs to provide intelligent information retrieval from documents stored in Google Drive.

n8n Python
Enhancing Hotel Revenue Management Through Predictive Analytics
ML & Data Science

Enhancing Hotel Revenue Management Through Predictive Analytics

A predictive analytics tool using Random Forest to classify hotel booking statuses and optimize revenue management for airport and city hotels.

Python Scikit-learn Seaborn Tensorflow Streamlit
End to End Data Engineering Pipeline using Olist Ecommerce Data
Data Engineering

End to End Data Engineering Pipeline using Olist Ecommerce Data

A production-scale data engineering pipeline using AWS, Snowflake, and Power BI to analyze over 100,000 real-world Olist e-commerce records.

AWS AWS Glue AWS Athena S3 Snowflake Power BI
Amazon Prime TV Shows and Movies Data pipeline on Azure (Batch)
Data Engineering

Amazon Prime TV Shows and Movies Data pipeline on Azure (Batch)

An end-to-end batch data pipeline on Azure utilizing a medallion architecture with Databricks and Synapse to process Amazon Prime video metadata.

Azure
UK Online Store - RFM Segmentations & Analysis using BigQuery & Tableau
ML & Data Science

UK Online Store - RFM Segmentations & Analysis using BigQuery & Tableau

A customer segmentation project using BigQuery ML clustering and Tableau dashboards to analyze RFM patterns for a UK-based online retail store.

GCP BigQuery Tableau
Sales Dashboard using Looker Studio
Analytics & Dashboards

Sales Dashboard using Looker Studio

An interactive Looker Studio dashboard designed to provide key sales performance metrics and trend analysis for retail stakeholders.

Looker Studio
Austin Bikeshare Analytics Grafana Dashboard
Analytics & Dashboards

Austin Bikeshare Analytics Grafana Dashboard

A real-time data visualization project using BigQuery and Grafana to analyze and display bike-sharing activities in Austin, Texas.

BigQuery Tableau GCP Grafana
Image Captioning and Visual Question Answering AI using Hugging Face models
AI

Image Captioning and Visual Question Answering AI using Hugging Face models

An AI application built with Gradio and Hugging Face BLIP models that generates image captions and answers visual questions interactively.

Python Gradio Huggingface
AI Powered Code Converter from R to Python
AI

AI Powered Code Converter from R to Python

A Streamlit-based utility powered by the OpenAI API that automatically converts R code into equivalent Python implementations.

Python Streamlit
Predicting Rainfall based on time series data
ML & Data Science

Predicting Rainfall based on time series data

A time series forecasting project using Facebook Prophet to predict future rainfall probabilities based on historical climate data.

Python Seaborn Prophet Matplotlib Streamlit
Adidas Sales Analysis Dashboard
Analytics & Dashboards

Adidas Sales Analysis Dashboard

An interactive Power BI dashboard analyzing Adidas sales performance, product margins, and regional trends across the United States.

Power BI
Data Science Job Data Analysis Dashboard
Analytics & Dashboards

Data Science Job Data Analysis Dashboard

A comprehensive Power BI dashboard providing insights into data science job market trends, salaries, and experience levels.

Power BI
Human Resources Dashboard using Tableau
Analytics & Dashboards

Human Resources Dashboard using Tableau

An interactive Tableau dashboard offering a detailed analysis of HR workforce metrics, including demographics, salary distributions, and headcount trends.

Tableau
Internal Company Policy Bot
AI

Internal Company Policy Bot

An AI-powered RAG chatbot using FAISS and Llama 3 to provide employees with instant, context-aware answers to internal company policy questions.

Python FAISS Gradio Langchain
Enerja - Concept Website
UI/UX & Web

Enerja - Concept Website

A fully responsive, single-page concept website for a Sri Lankan energy drink brand, designed and developed using Tailwind CSS and Figma.

JS HTML Tailwind CSS CSS3 Figma
ClimateChngLK - Web Dashboard to surface data insights related to Climate Change & Sri Lanka
Analytics & UI/UX

ClimateChngLK - Web Dashboard to surface data insights related to Climate Change & Sri Lanka

A multi-page web dashboard using to visualize global and local climate change impacts, emissions trends, and mitigation strategies in Sri Lanka.

JS Chart js HTML CSS
Centsible - Finance Tracker UI
UI/UX & Web

Centsible - Personal Finance Tracker UI Prototype

A vibrant and sleek UI prototype for a personal finance tracker designed in Figma, featuring expense analytics, fully interactive with 2 distinct white/black themes.

Figma

GitHub Activity

Subhanu's GitHub Contributions

Professional
Experience.

Fintech Officer (Analytics & AI)

Dec 2025 – Present

Dialog Finance PLC

Junior Data Analyst

Sep 2025 – Nov 2025

Data Analytics Intern

Feb 2025 – Aug 2025

Torch Labs Software LLC

Academic
Background.

BSc.(Hons) in Data Science

NSBM Green University

2022 – 2026

GPA: 3.71

Activities:

  • AIESEC in NSBM (2022-2024)
  • Treasurer - Data Science Association (2023–2024)
  • Member - Toastmasters International (2022)

G.C.E. Advanced Level - Commerce

Royal College, Colombo

2019 – 2022

Results: 3B, A

G.C.E. Ordinary Level

Dharmapala Vidyalaya, Pannipitiya

Until 2018

Results: 9As

Organizations &
Volunteering.

AIESEC in Sri Lanka

Team Leader - Customer Relations

2023 – 2024

OC Vice President (Public Relations) - Inception 4.0

Team Member - Business Development & Innovations

Sep 2022 – Jan 2024

SLAAS

Sri Lanka Association for the Advancement of Science

Member - Section E3 (Computer Science)

Certifications &
Courses.

I always try to stay on the edge of the latest trends, below are few certifications I've completed to stay current and turn new ideas into practical results.

Data Engineering on AWS - Foundations

AWS • Dec 2025

Verify ↗

Snowflake Key Concepts and Architecture

Snowflake

Verify ↗

Data Analytics Essentials

Cisco • Jun 2024

Verify ↗

SQL Intermediate Certification

HackerRank

Verify ↗

Databricks Fundamentals Accreditation

Databricks

Verify ↗

Google Analytics Certification

Google • Feb 2025

Verify ↗

Introduction to Probability and Data with R

Duke University • Mar 2024

Verify ↗

Agile Project Management

HP LIFE • Oct 2024

Verify ↗

Cloud Computing Fundamentals

IBM • Jul 2024

Verify ↗

Data Modeling for Power BI - Workshop

Pragmatic Works

Verify ↗

Intro to SQL

Kaggle • Mar 2024

Verify ↗

Excel Pro: Advanced Techniques for Data Analysis

Udemy

Verify ↗

Introduction to Data Science

Cisco • Feb 2024

Verify ↗

Data Visualization

Kaggle • Feb 2024

Verify ↗

Data Architecture 101

Udemy

Verify ↗

Foundation Course in Human Resource Management

CIPM Sri Lanka • Jun 2022

Verify ↗

Intro to Graphic Design with Photoshop

Great Learning

Verify ↗

Big Data Foundations - Level 1

IBM

Verify ↗

Data Manipulation in Python (Pandas/NumPy)

Udemy • Jan 2024

Verify ↗

Python for Beginners

University of Moratuwa • Feb 2023

Verify ↗

Web Design for Beginners

University of Moratuwa • Jan 2023

Verify ↗

A Few
Highlights.

Get in
Touch.

Have a project in mind or just want to chat? Feel free to reach out through any of these platforms.