Charith De Mel, Developer in Leicester, United Kingdom
Charith is available for hire
Hire Charith

Charith De Mel

Verified Expert  in Engineering

Microsoft Power BI and Azure Developer

Location
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

PepsiCo - Omnichannel
Microsoft Power BI, SQL, Python, Apache Airflow, Dashboards, Reports...
SalesLogs
Azure, Microsoft Power BI, TypeScript, React, Azure SQL
Wiley Global Technology, Pvt Ltd
Microsoft Power BI, Qlik Sense, Snowflake, Netezza, SQL, Python...

Experience

Availability

Full-time

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

Power BI Developer

2021 - 2022
PepsiCo - Omnichannel
  • Developed front-end reporting applications using Microsoft Power BI, and SSRS.
  • Conducted both functional and non-functional testing to verify aspects such as reliability, performance, and usability.
  • Corrected errors in software to fix performance issues and improve usability.
Technologies: Microsoft Power BI, SQL, Python, Apache Airflow, Dashboards, Reports, Data Engineering

Power BI Developer

2020 - 2021
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.
Technologies: Azure, Microsoft Power BI, TypeScript, React, Azure SQL

Senior Analytics Engineer

2019 - 2021
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).
Technologies: Microsoft Power BI, Qlik Sense, Snowflake, Netezza, SQL, Python, Data Build Tool (dbt)

Business Application Consultant, Data

2014 - 2019
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.
Technologies: Microsoft Power BI, Azure Data Factory, SQL, Azure, SSAS

PROFAB | MAS Fabrics

I delivered operational intelligence to the heads of the operation of a manufacturing facility with 1,600 knitting machines.

Technologies: SQL, Azure Data Factory, Power BI

SSI (Similar Setting Identification in the Textile Industry) | MAS Fabrics

MAS Fabric is a textile manufacturing company and needed to Identify designs with similar machine settings (a machine could use 32,000 needles and have more than 350 settings) to reduce design change-over time.

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

SalesLogs is a web-based application in facilitating auto dealership operations. I implemented the reporting platform for the SalesLogs application with Power BI which provides real-time analytics to end-users

Performance Reporting | PepsiCo Omnichannel

I built an interactive executive and business unit click-through dashboard with the IRI and retail channel data to help US PepsiCo leaders to make informed decisions. The project aims to build a self-service integrated business reporting and analytics platform to provide timely insights based on underlining data.
2017 - 2019

Master's Degree (Reading) in Computer Science

University of Moratuwa - Moratuwa, Sri Lanka

2009 - 2013

Bachelor's Degree in Science, Statistics, and Operations Research

University of Peradeniya - Peradeniya, Sri Lanka

DECEMBER 2022 - DECEMBER 2023

Microsoft Certified: Azure Data Engineer Associate

Microsoft

APRIL 2021 - APRIL 2024

AWS Certified Cloud Practitioner

Amazon Web Services Training and Certification

Libraries/APIs

React, D3.js

Tools

Microsoft Power BI, Visual Studio, Qlik Sense, SSAS, Apache Airflow

Languages

SQL, Python, C#, TypeScript, Snowflake, Power Query M

Paradigms

ETL, Azure DevOps

Frameworks

.NET

Platforms

Azure, Azure SQL Data Warehouse, Microsoft BI Stack, Windows, Dedicated SQL Pool (formerly SQL DW), Amazon Web Services (AWS)

Storage

Azure SQL Databases, Azure SQL, SQL Server DBA, SQL Server Integration Services (SSIS), Netezza

Other

Azure Data Factory, Computer Science, Science, Dashboards, Reports, Data Engineering, Data Build Tool (dbt)

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring