Niromi Perera
Gampaha,12
Summary
Certified Microsoft Fabric Data Engineer with extensive experience in designing and implementing comprehensive data engineering, integration, and analytics solutions within the Azure ecosystem. Proficient in Azure Data Factory, Synapse Analytics, Microsoft Fabric, Power BI, and SQL optimization, with a strong understanding of data warehousing, ETL/ELT pipeline design, and data governance principles. Expertise in building scalable data architectures that facilitate data-driven decision-making across various functions, including finance, HR, sales, and consulting. A tech-savvy innovator dedicated to continuous improvement and adept at leveraging emerging technologies to drive productivity and solve complex business challenges in fast-paced environments.
Overview
4
4
years of professional experience
1
1
Certification
Work History
Software Engineer
IFS
07.2023 - Current
- Designed and implemented scalable data engineering solutions using Azure Data Factory, Microsoft Synapse, and Microsoft Fabric, meeting analytical needs across Finance, HR, Sales, and Consulting departments.
- Managed CI/CD workflows using Azure DevOps, troubleshooting, and maintaining production pipelines to ensure seamless deployment and synchronization of data model changes through DevOps–Fabric integration.
- Developed and optimized ETL/ELT pipelines to integrate data from multiple sources into centralized data models, ensuring high data quality and governance compliance.
- Collaborated with cross-functional stakeholders to gather requirements and deliver data analytical solutions using IFS ERP, leveraging Information Sources, Access Views, Lobbies, and Quick Reports.
- Performed root cause analysis (RCA) to design future-proof data ingestion pipelines and ensure high availability of analytical models for upper management reporting.
- Automated manual financial adjustment processes, developing a Power Pages solution integrated with Dataverse and Power Automate, reducing Finance team workload and manual entry errors.
- Maintained and troubleshoot existing SSIS and SSAS solutions, ensuring continuous operation and data integrity across reporting systems.
- Applied SQL optimization techniques and data modelling best practices to improve query performance and data refresh efficiency in Power BI and Synapse workspaces.
- Guided junior members and collaborated with new joiners to deliver cross functional solutions in a timely manner.
- Collaborated with cross-functional teams to define project requirements and deliver solutions.
- Developed and maintained scalable applications using Java and SQL.
Associate Software Engineer
ITX360
06.2022 - 11.2022
- Built real-time monitoring dashboards using Kibana, integrated with Elasticsearch log monitoring, reducing incident troubleshooting time by 30%.
- Improved system observability and proactive error detection through log analytics and performance trend tracking.
Data Engineer
IPD COLOMBO
12.2022 - 06.2022
- Developed and optimized ETL processes using SSIS, automating data ingestion workflows, and reducing data load times by 35%.
- Delivered 15+ interactive Power BI dashboards for executive and departmental reporting, improving data accessibility and supporting strategic decision-making.
Data Analyst Intern
AKBAR BROTHERS
12.2021 - 05.2022
- Created Power BI dashboards for operational and financial analytics, enhancing data visibility across departments.
- Automated data extraction pipelines from the Colombo Stock Exchange, streamlining integration of stock price data into accounting systems.
- Conducted auction analytics and supply-demand forecasting for the Colombo Tea Auction, increasing planning accuracy by 20%.
Education
MS - Data Science
KINGSTON UNIVERSITY
Kingston, UKBS - Industrial Statistics and Mathematical Finance
UNIVERSITY OF COLOMBO
Colombo, LKSkills
- Cloud & Data Engineering:
- Azure Data Factory Azure Synapse Analytics Azure Data Lake Azure SQL Database ETL/ELT Pipeline Design Data Integration
- Data Modelling & Warehousing:
- Dimensional Modelling Star Schema Design Data Warehouse Architecture Semantic Models SSIS SSAS Optimised Data Ingestion Data Transformation
- Business Intelligence & Reporting:
- Power BI DAX Power Query Dataflows Dashboard Design Dataverse Power Apps Power Automate Self-Service Analytics
- Programming & Databases:
- SQL T-SQL PL/SQL Python (pandas, NumPy) Query Optimization Stored Procedures Data Validation Data Quality Assurance
- DevOps & Automation:
- Azure DevOps CI/CD Pipelines Git Version Control Automated Deployments Pipeline Monitoring Production Troubleshooting
- Data Governance & Quality:
- Metadata Management Data Lineage Data Security Compliance Root Cause Analysis Continuous Improvement
- Professional & Analytical Skills:
- Cross-Functional Collaboration Business Requirement Gathering Problem Solving Agile Methodologies Stakeholder Communication
Affiliations
Toastmasters International Certified Public Speaker
Certification
- Microsoft Certified Fabric Data Engineer Associate – 2025
- Microsoft Certified Fabric Analytics Engineer Associate – 2025
- Microsoft Certified Azure Data Fundamentals – 2023
- Microsoft Certified Azure AI Fundamentals – 2024
- Google Cloud Data Analytics Professional – 2022
Languages
English
Full Professional
Timeline
Software Engineer
IFS
07.2023 - Current
Data Engineer
IPD COLOMBO
12.2022 - 06.2022
Associate Software Engineer
ITX360
06.2022 - 11.2022
Data Analyst Intern
AKBAR BROTHERS
12.2021 - 05.2022
BS - Industrial Statistics and Mathematical Finance
UNIVERSITY OF COLOMBO
MS - Data Science
KINGSTON UNIVERSITY
Communication
Excellent communication skills enable me to collaborate with clients, stakeholders, and cross-functional teams to deliver high-quality results.
Leadership
Mentor junior developers, coordinate project tasks, and implement best practices to ensure timely delivery of high-quality web applications.
Personal Information
Title: Microsoft Certified Data Engineer
Martial Arts
Member of the College Karate team