PinnedRajat Roy·Aug 8, 2025“The AI-Powered Defect Workflow State Machine: MCP Meets n8n, Render, and WhatsApp/Slack”AI-driven decision-making, workflow automation, and multi-platform integration.
Rajat Roy·Feb 12Serverless AI-Powered Document Intelligence System on AWSFrom Email Ingestion to Vector Search using Textract, Bedrock & OpenSearch.
Rajat Roy·Jan 11Building an MCP‑Powered Autonomous AI Agent with Git, Render, and Microsoft Copilot StudioAWS Assistant — Simple idea evolved into a fully deployed, MCP‑powered AI agent running on Render, integrated with Git, and orchestrated…
Rajat Roy·Jan 5Kappa Architecture (Multiple local sink): Kafka with PySpark, Postgres, and Delta LakeIn this article, I’ll share how I built a real-time data pipeline on my laptop using Kafka, PySpark Structured Streaming, Postgres, and…
Rajat Roy·Dec 24, 2025The Evolution of a Data Warehouse: From Star to Galaxy at Vehicle ShowroomThis article focuses solely on how changing OLAP business requirements necessitate fundamental shifts in the data model’s design.
Rajat Roy·Dec 20, 2025True Streaming: Building Change Data Capture with DebeziumSelf managed CDC where every insert, update, or delete often needs to flow downstream — into analytics systems, data lakes, or operational…
Rajat Roy·Dec 10, 2025Cost-Effective, Modern Data Pipeline for Insurance Analytics Using AWS DMS and DatabricksAfter several years of professional work in Insurance domain, people talks about how quickly, easily we can get the transactional data into…
Rajat Roy·Nov 9, 2025Real-Time Motor Insurance Fraud Detection System Using Databricks LakehouseGoal in this project was to detect those patterns, score claims based on fraud likelihood, and explain to investigators why a claim looks…
Rajat Roy·Sep 14, 2025Insurance Product Media Maker: Agentic AI with LLMs, Multi-Agent Orchestration, MCP, and Media…I often see in todays insurance industry we faced unprecedented pressure to personalize offerings, deliver content faster, and engage…