raw_events · unformatted, unfiltered, unmistakably me · Colombo, Sri Lanka

Engineering data for better decisions.

I'm Ruwan Pathirana, a cloud data engineer with experience designing, supporting, and optimizing analytics solutions on Microsoft Fabric and Azure. I enjoy solving data challenges and building scalable pipelines that deliver trusted insights.

See the work Get in touch
PROFILEprofiled 1 record

I started in data on the reporting side building dashboards that business teams actually depend on and gradually moved upstream as I became more involved in understanding and fixing data issues closer to the source.

Today I work as an Associate Consultant in Data & AI, where I split my time between developing Power BI solutions and supporting Azure-based data platforms for enterprise clients across multiple regions. The role combines building, maintaining, and troubleshooting production data systems to keep analytics reliable and trusted.

Outside of client work, I explore machine learning and generative AI to deepen my understanding of how end-to-end data and AI systems behave in real scenarios.

df.describe()
current_roleAssociate Consultant, Data & AI
educationB.Sc(Hons) IT & Mgmt
institutionUniversity of Colombo
certifications3X Microsoft Certified
core_stackAzure · Fabric · Power BI
TRANSFORM3 tasks · DAG order
Associate Consultant - Data & AI
Fortude
Dec 2024 — Present
RUNNING
  • Design and optimize Power BI semantic models, dashboards, and reports that enable data-driven business decisions.
  • Build, maintain and troubleshoot enterprise data pipelines across Microsoft Fabric, Azure Data Factory and Azure Databricks.
  • Provide managed services for Azure-based analytics platforms, investigating production issues, performing root cause analysis and delivering long-term solutions for global enterprise clients.
  • Support and enhance analytics solutions built on Microsoft Fabric ensuring reliable data integration, transformation, and reporting performance.
  • Maintain and support Infor BI ERP analytics solutions, collaborating directly with customers to resolve technical issues and improve reporting capabilities.
upstream: Intern Data Scientist @ Epic Lankafeeds_into: current
Trainee - Data Scientist
Epic Lanka Technology
Nov 2023 — Nov 2024 · 1yr
SUCCESS
  • Engineered end-to-end Azure ETL pipelines using Azure Data Factory, Databricks, and Azure Synapse to transform and integrate enterprise data.
  • Designed interactive analytics dashboards in Power BI, Tableau, and D3.js for banking and financial reporting.
  • Developed AI-powered document processing solutions with Document Classification and OCR, including optimization of an eKYC OCR engine recognized as the AI Technology of the Year 2024 at National ICT Awards.
  • Built machine learning pipelines for loan default prediction and credit card payment risk analysis, exposing models through FastAPI.
  • Created intelligent chatbots using modern NLP techniques for business information retrieval and database interaction.
upstream: Trainee @ Bank of Ceylonfeeds_into: Associate Consultant @ Fortude
Trainee
Bank of Ceylon
Feb 2019 — July 2019 · 6mo
SUCCESS
  • Provided customer service by assisting clients with banking inquiries and day-to-day financial services.
  • Developed strong communication and customer relationship skills through direct customer interactions.
  • Supported loan processing activities and gained hands-on experience with banking operations.
  • Built a solid understanding of the banking and fintech industry, including core financial products and workflows.
  • Collaborated with branch staff to ensure efficient service delivery and maintain operational accuracy.
upstream: none - source nodefeeds_into: Trainee Data Scientist @ Epic Lanka
CURATED4 tables · self-directed
gold.ms_fabric_end_to_end
end-to-end
problem
Wanted real, production-shaped experience with Microsoft's unified analytics platform — not just the parts covered on the certification exams.
approach
Ingested data from an external API straight into OneLake, transformed it with PySpark, then built the reporting layer on top in Power BI.
stack
Microsoft Fabric, OneLake, PySpark, Power BI
status
Complete — full ingest-to-dashboard path, self-directed.
gold.fraud_gan_balancer
prototype
problem
Credit card fraud datasets are heavily imbalanced, which quietly sabotages model performance on the cases that actually matter.
approach
Built a Generative Adversarial Network to synthesize realistic fraudulent transactions, balancing the training set with real and generated samples.
stack
Python, TensorFlow / Keras, GANs
status
Working prototype, portfolio project.
gold.sem_image_classifier
prototype
problem
Scanning Electron Microscopy images need classification, but off-the-shelf models don't generalize well to specialized lab imagery.
approach
Built a feature-driven pipeline: extracted a diverse set of features from labeled SEM images, then trained classical ML models on top of them.
stack
Python, Scikit-learn, feature engineering
status
Working prototype, portfolio project.
gold.voice_emotion_shift
research
problem
Most emotion recognition treats a clip as one static label — but emotion shifts mid-conversation, and that transition itself carries signal.
approach
Applying deep learning and clustering techniques to identify where and how one emotion transitions into another within continuous audio segments.
stack
Python, deep learning, clustering
status
Ongoing research.
VALIDATE5 / 5 checks passed
✓
Power BI Data Analyst Associate
PL-300 · Microsoft Certified
PASSED
✓
Fabric Data Engineer Associate
DP-700 · Microsoft Certified
PASSED
✓
Fabric Analytics Engineer Associate
DP-600 · Microsoft Certified
PASSED
✓
Supervised Machine Learning
DeepLearning.AI
PASSED
✓
Machine Learning with Python
LinkedIn Learning
PASSED
ORCHESTRATE7 layers
LANGUAGES & QUERYING
PythonSQLR
CLOUD & ANALYTICS
AzureMicrosoft FabricDatabricksPySparkSnowflakeInfor BISSAS
INTEGRATION
Azure Data FactoryInfor DWDFivetran
DATABASES
PostgreSQLMySQLMS SQLMongoDB
VISUALIZATION
Power BITableauInfor Office PlusExcelJasper Studio
AI & ML
TensorFlowScikit-learnKerasOCR
TOOLING
GitHubBitbucketAzure DevOpsJIRASysAidFreshDesk
SERVE200 OK

Open to new opportunities, Microsoft Fabric and Power BI projects, and conversations about data engineering, analytics, and AI. Feel free to reach out.

GET /contact
200 OK · 12ms
{
"email": rpathirana836@gmail.com,
"linkedin": in/ruwanpathirana,
"github": github/ruwanpathirana,
"location": Colombo, Sri Lanka
}