Published inPlumbers Of Data ScienceFortifying Your Database Migration: A Journey Towards Secure Transitions!As a database developer/architect, one of my most critical challenges is ensuring data security during database migrations. These…Mar 21, 2024Mar 21, 2024
From On-Prem Microsoft SQL Server to AWS Serverless — Migrating Business Intelligence, Application…IntroductionApr 10, 2023Apr 10, 2023
Guide to Creating a Secure and Efficient Personal AWS Account in 2023: Best Practices for…ContentApr 4, 2023Apr 4, 2023
Data Engineering Project-AWS Stream and Batch Processing Pipelines for Credit Card TransactionsSome weeks ago I started to build a data engineering project in AWS Cloud. As a Datawarehouse/ETL professional with more than 6+ years of…Sep 14, 20211Sep 14, 20211
Populating Amazon Redshift DWH from S3 & QuickSight ReportingIn one of previous blog posts here in medium I modeled an OLAP system (Star Schema)for credit card transactions kaggle dataset as below. In…Sep 12, 2021Sep 12, 2021
Amazon QuickSight Dashboard for S3 CSV Data using Redshift Spectrum / Glue CrawlerIn this article I would like to write about creating a Amazon QuickSight Dashboard for the data in a csv file located in Amazon S3 sing…Sep 11, 2021Sep 11, 2021
Amazon QuickSight Dashboard for S3 CSV Data Using Amazon Athena / Glue CrawlerIn this article I would like to write about creating a Amazon QuickSight Dashboard for the data in a csv file located in Amazon S3.Sep 11, 2021Sep 11, 2021
Building a Grafana Dashboard in AWS on Serverless Aurora RDSIn my previous article here in Medium, I built a simple stream processing pipeline in AWS which writes credit card transactions data into…Aug 16, 2021Aug 16, 2021
Bulk Import from AWS S3 Bucket into RDS Aurora Serverless using AWS Cloud9In this article, I am writing about loading the .CSV file data in bulk from AWS S3 bucket into RDS Aurora Serverless using AWS Cloud9. At…Aug 7, 2021Aug 7, 2021
Building a Stream Processing Pipeline in AWSIn my earlier article here in Medium, I took a kaggle credit card transaction dataset and modeled it for the OLTP and OLAP databases as…Aug 1, 20211Aug 1, 20211
