Charith De Mel
Verified Expert in Engineering
Data Engineer and Data Analytics Developer
Leicester, United Kingdom
Toptal member since June 24, 2020
Charith is a seasoned data enthusiast who loves to learn and always accepts a challenge. His career thus far in the data sphere has been in research publishing, education, manufacturing, and strategy, but he's always looking to explore other areas of data and analytics. Charith has a demonstrated history of being a dependable employee and a hard worker with solid problem-solving and technical skills.
Portfolio
Experience
- Microsoft Power BI - 8 years
- SQL - 8 years
- Python - 6 years
- ETL - 6 years
- Azure - 6 years
- Azure Data Factory (ADF) - 5 years
- Snowflake - 2 years
Availability
Preferred Environment
Microsoft Power BI, Windows, SQL, Azure
The most amazing...
...solution I’ve made scraped data from fabric-knitting machines and delivered OI management to a manufacturing facility using Data Factory and Power BI.
Work Experience
Senior Power BI Consultant (via Toptal)
Kagome Inc.
- Contributed to system integration and data migration. Ensured seamless integration of the new business intelligence platform with the upgraded Microsoft Dynamics system. Established data pipelines and ensured data consistency and accuracy across both platforms.
- Worked on platform development and customization. Developed and customized the BI content to meet specific business needs. Designed dashboards and created reports that aligned with organizational requirements.
- Focused on performance optimization and testing. Identified and resolved potential bottlenecks, ensured high system performance, and conducted user acceptance testing to validate that the integrated solution meets business objectives.
Power BI Developer
PepsiCo - Omnichannel
- Designed and implemented market share reports covering 35+ brands across omnichannel using Microsoft Power BI and SSRS to provide comprehensive and accurate insights for C-level management.
- Integrated data from multiple sources, including IRI, into the reporting platforms. Ensured data accuracy, consistency, and reliability to support strategic decision-making at the management level.
- Executed comprehensive performance optimization and quality assurance for reports. Detected and addressed potential bottlenecks, guaranteed optimal system performance, and conducted detailed testing to ensure reports met specific requirements.
Power BI Developer
SalesLogs
- Integrated Power BI embedded report objects to SalesLogs (multi-tenant SaaS) application with RLS-based data isolation in Power BI.
- Designed and developed data extraction, modeling, and created reports and dashboards with custom-made visuals in Power BI.
- Developed custom visuals for Power BI using Power BI custom visual tool kit (pbiviz) and React.
- Configured deployment pipelines for Power BI artifact on Azure DevOps.
Senior Analytics Engineer
Wiley Global Technology, Pvt Ltd
- Transformed an enterprise data warehouse from Netezza to Snowflake and reimplemented an old Informatica-based pipeline using a Python-based in-house built ETL tool.
- Developed and supported applications in Power BI/Qlik or other similar analytics tools and applications that required web integration across analytics and data platforms.
- Contributed to the inception and idealization of new efforts (prototyping and POCs).
Business Application Consultant, Data
MAS
- Developed and maintained an ETL process to pump data to Azure Data Lake from various data sources through Azure Data Factory.
- Designed and developed a data warehouse to cater to the requirements of various business users ( analysts, data scientists/analytics engineers).
- Helped business users derive insights from the processed data through Power BI.
- Managed a team of four developers to develop and maintain a data platform for the company.
Experience
PROFAB | MAS Fabrics
Technologies: SQL, Azure Data Factory, Power BI
SSI (Similar Setting Identification in the Textile Industry) | MAS Fabrics
My team developed a data-driven application to identify design with similar settings through a mathematical model and I acted in the lead developer role.
Technologies: SQL, Python, C#
Implementing Power BI Embedded Reporting to SalesLogs
Performance Reporting (PowerBI) | PepsiCo Omnichannel
Education
Master's Degree (Reading) in Computer Science
University of Moratuwa - Moratuwa, Sri Lanka
Bachelor's Degree in Science, Statistics, and Operations Research
University of Peradeniya - Peradeniya, Sri Lanka
Certifications
Microsoft Certified: Azure Data Engineer Associate
Microsoft
AWS Certified Cloud Practitioner
Amazon Web Services Training and Certification
Skills
Libraries/APIs
React, D3.js
Tools
Microsoft Power BI, Microsoft Excel, Visual Studio, Qlik Sense, SSAS, Apache Airflow
Languages
SQL, Python, C#, TypeScript, Snowflake, Power Query M
Frameworks
.NET
Paradigms
ETL, Azure DevOps, Testing, Business Intelligence (BI), Requirements Analysis
Platforms
Azure, Azure SQL Data Warehouse, Microsoft BI Stack, Windows, Dedicated SQL Pool (formerly SQL DW), Amazon Web Services (AWS), Microsoft Dynamics 365, Microsoft Power Automate
Storage
Azure SQL Databases, Azure SQL, SQL Server DBA, Data Pipelines, SQL Server Integration Services (SSIS), Netezza, Microsoft SQL Server, Redshift
Other
Data Analysis, DAX, Excel 365, Azure Data Factory (ADF), Data Engineering, Data Analytics, Data Visualization, APIs, Data Warehousing, Data Modeling, Azure Databricks, Reporting, Computer Science, Science, Dashboards, Reports, Data Build Tool (dbt), BI Reporting, SAP ERP, Data Science
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring