Aveek Das

Data Engineer, Cloud Data Architect, Thinker, Traveler, Amateur Photographer. Enjoys short walks for hot chocolates. Blogs @ https://datacloudmag.com

Aveek is an experienced Data Engineer and Business Intelligence professional with around five years of expertise in cloud platforms like AWS and Azure. He helps clients build data pipelines using data integration tools, uncover insights from their own data, and recommend actionable items. He has successfully done projects in various sectors, such as retail, insurance, leisure, and RSA.

Aveek likes to work on projects which revolve around cloud data technologies such as AWS and Azure. He is well versed with AWS services like Glue, Redshift, Lambda, SQS, Kinesis, RDS, QuickSight, and Azure services like Data Factory, Synapse Analytics, SQL Database, etc. He takes on projects that cover the entire life cycle of a data engineering project: ETL architecture, design, and development of the Data Warehouse, development of an OLAP/analytics data model (Redshift / Analysis Services), and finally designing the presentation layer in QuickSight, Power BI, Qlik Sense or Tableau. For designing data warehouses, Aveek is well versed in the Kimball methodology, star, and snowflake schemas, however, he also has a background in Data Vault and Data Lakes. He has worked with different versions of databases such as MySQL, PostgreSQL, SQL Server.

In addition to this, Aveek is also loves working on personal and open-source projects. He is involved in developing a chatbot that uses Natural Language from customers to answer questions about their data. It’s based on Microsoft Bot Framework coupled with Cognitive Services as a utility to interact with customers using various channels, such as Slack, Skype, etc. Recently, he is also developing and maintaining an open-source project, which is under incubation and dwells around version control and migration for Amazon QuickSight.

Over the years, Aveek has developed expertise using the following tools:

  • AWS Glue, Data Pipeline, Azure Data Factory, Integration Services (SSIS).
  • Streaming Data Processing using AWS Kinesis, Apache Kafka.
  • AWS Redshift, Azure Synapse Analytics, Analysis Services (SSAS Multidimensional and Tabular); also, well versed in writing MDX and DAX queries.
  • Data Visualization (Amazon QuickSight, Power BI, Qlik Sense, QlikView, Tableau)

In his leisure, he likes to keep his skills sharp by completing certification programs, writing articles on his blog, and also for SQLShack and SQLServerCentral. He is also an amateur photographer and hops around to do photography, mostly street and still life. While at home, he likes to cook and watch television series.


How to use AWS IAM Roles and Policies

Learn the underlying concepts of using AWS IAM Roles and Policies.

Introduction to Layers in AWS Lambda

AWS Lambda is one of the most popular serverless services that allows users to run custom functions. Learn how to work with layers in AWS Lambda Functions.

An introduction to sharing content on LinkedIn using REST APIs and Python

Learn how to use LinkedIn REST APIs and share content programatically. This article uses Python to post content to LinkedIn profile.

An overview of Power BI Incremental Refresh

This article describes how to setup and configure Power BI Incremental Refresh.

Overview of Power BI Time calculations

This article provides and overview of Power BI Time Calculations. Learn how to implement Power BI Time Calculations.

Set up a Machine Learning environment using R and R Studio

Learn how to set up a machine learning environment using R and RStudio.

Use Cloud Formation Templates to spin up MySQL instances on RDS

Learn how to deploy MySQL on Amazon RDS using CloudFormation templates.

Solving the Gilded Rose Refactoring Kata

Gilded Rose Kata in Python This is a refactoring exercise based on the famous GildedRose-Refactoring-Kata repository maintained by Emily Bache. This kata contains simple code...

Installing Docker Desktop on Mac

Learn how to install Docker Desktop on MacOS.

Getting started with Amazon Athena and S3

Learn how to connect to Amazon S3 using Athena.