I'm a final-year BSc IT (Hons) student at SLIIT, currently working as a Database Administrator at VS Information Systems, Colombo — where I maintain high-availability production Oracle banking databases, automate monitoring workflows, and perform SQL-based analysis to identify performance bottlenecks.
My passion is bridging the gap between operational DBA work and modern data engineering: designing streaming pipelines with Kafka & Spark, building Medallion architectures, and turning raw data into real business insights. I'm actively growing toward a Senior Data Engineer role.
Name : Lahiru Niroshan Sathsara
Role : DBA → Data Engineer
Company : VS Information Systems 🏦
Degree : BSc IT (Hons) · SLIIT · Final Year
Base : Moratuwa, Sri Lanka 🇱🇰
Focus : Streaming · SQL Analytics · Cloud
Open to : Data Engineering Opportunities ✅| 📥 INGEST | ⚙️ PROCESS | 🗄️ STORE | 📊 SERVE | |
|---|---|---|---|---|
| Tools | Kafka · NiFi · REST APIs | Spark SS · PySpark · ETL/ELT | Cassandra · PostgreSQL · DuckDB | Power BI · Superset · Streamlit |
| Pattern | Event Streaming | Medallion Architecture | Dual-Store Strategy | Real-Time Dashboards |
| Infra | Docker | OCI · AWS · Azure | BigQuery · MongoDB | Tableau · Matplotlib |
⚡ Data Engineering & Streaming
🗄️ Databases
🧑💻 Languages & Analytics
📊 Visualization & BI
☁️ Cloud & DevOps
Hierarchical data reconciliation engine simulating core banking → reporting replica drift detection · Schema, aggregate, partition, and hash-based row fingerprinting · 100% precision/recall on labeled fault injection · 2.3x–6.4x faster than naive full outer-join comparison
📊 DataGuard Insights — BI Dashboard (Live)
Business-facing BI dashboard built on DataGuard Core's output · SQL window functions for integrity trends and cohort ranking · Translates row-level discrepancies into dollar exposure and affected-account risk · Data-driven executive summary generated from live query results
📊 Uber Eats SL — Marketplace Analytics (Live)
End-to-end analytics system simulating Uber Eats marketplace data · SQL KPIs (conversion rate, revenue/eater, demand patterns) · Pricing elasticity model · Churn prediction for restaurant partners · Interactive Streamlit dashboards · Automated weekly reporting
High-volume streaming pipeline · Kafka producers & consumers for data ingestion · Dual-store strategy (Cassandra + PostgreSQL) · Real-time dashboards via Apache Superset · Fully containerized with Docker
End-to-end ride event architecture · Spark Structured Streaming for real-time processing · Dual-storage strategy optimized for low-latency queries · Fully containerized pipeline with Docker
Complex EHR data cleaning & transformation with Pandas · Loaded to PostgreSQL & BigQuery for KPI insights · Interactive Power BI dashboards · Identified patterns to improve operational efficiency
Automated Reddit API scraper (100+ job discussion sources) · Medallion Architecture (Bronze/Silver/Gold) · 50,000+ records analyzed · Interactive Power BI dashboards for KPI monitoring
| Certification | Issuer | Year |
|---|---|---|
| 🔶 OCI 2025 Certified Foundations Associate | Oracle | 2025 |
| 🤖 OCI 2025 AI Foundations Associate | Oracle | 2025 |
| 🧠 Oracle Fusion AI Agent Studio Foundations | Oracle | 2025 |
| ☁️ AWS SimuLearn: Computing Solutions | Amazon | 2025 |
| 🐍 Python for Beginners | Uni. of Moratuwa | 2024 |
| 🔷 Introduction to Azure Virtual Machines | Microsoft | 2024 |
"Data is not information, information is not knowledge — I build the systems that bridge that gap."
