"The best way to predict the future is to create it."
💡 Data Engineer & .NET Developer from Colombo, Sri Lanka 🇱🇰. I build data platforms and ETL pipelines on Databricks, Azure and Snowflake, and scalable web apps with ASP.NET MVC, Web API and C#. Creator of dcvpg, an open-source tool that stops bad data before it reaches production.
| Details | |
|---|---|
| 🏢 Current Role | Data Engineer @ AffixCon (6+ months, ongoing) |
| 💼 Previous Role | Software Developer Trainee @ AlgotechSys |
| 🎓 Education | BSc. Information Technology @ UCSC · BBM (Hons) Accounting Information Systems @ University of Kelaniya |
| 🔭 Focus | Data Engineering & ETL · Databricks Lakehouse · C# / ASP.NET · Azure Cloud · AI & Automation |
| 🌱 Learning | Microsoft Fabric Analytics Engineer · SnowPro Associate · Advanced Azure · Data Engineering at Scale |
| 🛡️ Open Source | dcvpg: Data Contract Validator & Pipeline Guardian |
| 🏛️ Memberships | Institute of Analytics (Student Member, ID: 2507B17750) · CA Sri Lanka (Corporate Level Student) |
⚡ What I'm Up To Right Now (click to expand)
- 🏢 Working as Data Engineer at AffixCon (6+ months and continuing)
- 🔧 Building production data pipelines, lakehouse architectures and ETL workflows
- 🎓 Studying IT at UCSC & Accounting Information Systems at UoK
- 🔨 Developing ASP.NET applications and cloud-based solutions on Azure
- 📊 Analyzing business data with Power BI, SQL, and Python
- 🤖 Creating AI automation workflows using N8N and Azure services
- ☁️ Deploying solutions on Azure, AWS, and Google Cloud
- 📚 Preparing for Microsoft Fabric Analytics Engineer certification
- 🛡️ Maintaining dcvpg, an open-source data contract & pipeline guardian
- 🏆 Achieved 1st Runner-Up at SDG Youth Challenge 2025
- 🤝 Contributing to the FOSS Community and university tech organizations
- 💻 Managing projects with Agile/Scrum, Azure DevOps and Git
| Role | Company | Duration | Highlights |
|---|---|---|---|
| Data Engineer | AffixCon | 6+ months · Present | Building and maintaining data pipelines, ETL workflows and analytics solutions in production |
| Software Developer Trainee | AlgotechSys | 1 year | ASP.NET MVC & Web API development, SQL Server, Azure cloud services |
Catch schema drift, quality violations, and freshness SLA breaches before they reach production.
| Feature | What it does |
|---|---|
| 🔍 Schema Drift Detection | Catches column additions, drops & type changes automatically |
| ✅ Data Quality Validation | Asserts nullability, ranges, regex patterns & referential rules |
| ⏰ Freshness SLA Monitoring | Alerts when pipeline data goes stale beyond defined thresholds |
| 🚦 Pipeline Gate Integration | Blocks bad data at the source, before it poisons downstream |
| 📋 Data Contract as Code | Define and version your data contracts in YAML/JSON |
⭐ If dcvpg saves your pipeline, drop a star. It helps more data engineers find it!
A complete, production-style Data + AI + BI platform built entirely inside the Databricks Data Intelligence Platform.
Models a restaurant chain with 5 UAE locations, 500 customers, ~8,000 historical orders, live streaming orders and thousands of reviews. Ingestion, transformation, AI sentiment analysis, orchestration and dashboards all on one platform.
| Capability | Implementation |
|---|---|
| 📥 Real-Time Ingestion | Azure Event Hub (Kafka surface) streaming via Spark Declarative Pipelines |
| 🔄 CDC Batch Ingestion | Lakeflow Connect from Azure SQL Database with change data capture |
| 🏗️ Medallion Architecture | Landing → Bronze → Silver → Gold on Unity Catalog & Delta Lake |
| ⭐ Star Schema Modeling | 3 fact tables + 3 dimension tables with data-quality expectations |
| 🤖 AI in SQL | Mosaic AI ai_query() for review sentiment & issue categorization |
| ⚙️ Orchestration | Databricks Workflows: daily master job chaining all pipelines |
| 📊 AI/BI Dashboards | Chain Performance & Review Insights dashboards, no external BI tool |
| Project | Tech | Description |
|---|---|---|
| 🛡️ dcvpg | Python YAML Data Contracts |
Catch schema drift, quality violations & freshness SLA breaches before production. Data contracts as code. |
| 🍽️ Restaurant Analytics on Databricks | Databricks Delta Lake Azure Spark |
End-to-end lakehouse: streaming + CDC ingestion, medallion architecture, star schema, Mosaic AI sentiment analysis & AI/BI dashboards. |
| 🤖 LocalGPT | Python LLM Privacy-First AI |
Run a GPT-powered assistant fully offline on your own machine. No cloud, no data leaks. |
| 💰 Payroll Management System | ASP.NET SQL Server C# |
End-to-end payroll with employee management, salary calculation, deductions & automated payslips. |
| 🌐 Web Scraper Tool | Python AWS Lambda Claude AI |
GUI-powered scraper for SEO metrics & structured content, with a serverless AWS Lambda backend. |
| 🔬 Tech Stack Advisor | Python Docker ML |
ML-powered advisor that recommends the best tech stack for a project. Dockerized ML app reference. |
| 🔄 DoE ETL Pipeline | Python Jupyter ETL |
Production-ready ETL pipeline with automated extraction, cleaning & loading of energy data. |
| 🛒 SmartCart | Dart Flutter AI |
AI-powered shopping cart with automated checkout, product recognition & payment integration. |
| 📚 Library Management System | ASP.NET SQL Server |
Book cataloging, member management, borrowing system & automated notifications. |
| 📊 DataCamp Portfolio | Python SQL Power BI |
Crime in LA · NYC School Scores · Netflix Movies · Motorcycle Sales · Student Mental Health · HR Analytics |
|
|
|
|
- 🥈 1st Runner-Up at SDG Youth Challenge 2025 (ICBI 2025, University of Kelaniya)
⚡ Quickdraw · 🦈 Pull Shark ×2 · 🎯 YOLO · 🤝 Pair Extraordinaire
| Certification | Provider | Status |
|---|---|---|
| Certified Associate Data Analyst | DataCamp | ✅ Completed |
| Data Analyst in SQL | DataCamp | ✅ Completed |
| Certified Python Data Associate | DataCamp | ✅ Completed |
| SnowPro Associate: Platform Certification | Snowflake | 🔄 In Progress |
| Microsoft Fabric Analytics Engineer Associate | Microsoft | 🔄 In Progress |
- The Institute of Analytics: Student Member (ID: 2507B17750)
- Chartered Accountants of Sri Lanka: Corporate Level Student
|
IT Coordinator Organizing Committee |
PR & Marketing Coordinator Organizing Committee |
Active Member University of Kelaniya |
const pasindu = {
title: "Data Engineer & .NET Developer",
currentCompany: "AffixCon (Data Engineer, 6+ months, ongoing)",
previousCompany: "AlgotechSys (Software Developer Trainee)",
education: {
primary: "BSc. IT @ UCSC",
secondary: "BBM (Hons) AIS @ University of Kelaniya"
},
openSource: {
flagship: "dcvpg - Data Contract Validator & Pipeline Guardian",
mission: "Catch schema drift & quality violations before production"
},
technologies: {
dataEngineering: ["Databricks", "Spark", "Delta Lake", "Kafka", "Snowflake",
"Airflow", "Azure Data Factory", "dbt", "Hadoop"],
backend: ["C#", "ASP.NET MVC", "Web API", "Node.js"],
frontend: ["React", "Angular", "Flutter", "JavaScript"],
dataAnalytics: ["Power BI", "Tableau", "SQL", "Python", "Excel"],
cloud: ["Azure", "AWS", "Google Cloud", "Docker"],
databases: ["SQL Server", "MySQL", "PostgreSQL", "MongoDB", "Supabase"],
automation: ["N8N", "Azure Functions", "Lambda"],
ai: ["OpenAI", "Claude AI", "LangChain", "LocalGPT", "Mosaic AI"]
},
githubStats: {
repos: 47,
achievements: ["Quickdraw", "Pull Shark x2", "YOLO", "Pair Extraordinaire"]
},
currentFocus: [
"Production Data Pipelines @ AffixCon",
"dcvpg - Open Source Data Quality Tool",
"Databricks Lakehouse Architecture",
"Microsoft Fabric Analytics"
],
achievements: {
competition: "1st Runner-Up - SDG Youth Challenge 2025",
memberships: ["Institute of Analytics", "CA Sri Lanka"]
},
funFact: "I build data pipelines by day, guard them by night with dcvpg! 🛡️"
};I'm always excited to connect with fellow developers, data enthusiasts, and tech professionals!
Open to: 💼 Full-time Data Engineering & .NET roles · 🤝 Open-source collaborations (especially dcvpg!) · 💡 Tech discussions · 🚀 Freelance & consulting
"The best way to predict the future is to create it." Building the future, one commit at a time.
