Hi, I'm Kuntal Data Engineer

Designing reliable cloud data systems with a strong focus on performance, automation, and production-ready delivery across AWS, Databricks, Python, PySpark, and SQL.

10+ Years in Data Engineering
100+ Pipelines Delivered
$20K/mo AWS Savings Delivered

Core capabilities backed by measurable outcomes.

Capabilities

  • Data Pipeline Architecture and Development
  • Process Automation and Workflow Orchestration
  • AI/ML Model Integration and Deployment
  • CI/CD-Driven Deployment and Feature Release
  • Data Governance and Product Ownership
  • Performance and Cost Optimization
  • Team Leadership and Stakeholder Management
  • BI Reporting and Dashboarding
  • Project Planning and Agile Ceremonies

Achievements

  • $20K/month Saved Through AWS Cost and Performance Optimization
  • 15-20 Hours Saved per Run Through Pipeline Redesign
  • 40 hours/month Saved by Automating Validation Workflows
  • 100+ Data Pipelines Built Across AWS, Databricks, Python, PySpark, and SQL
  • 30+ SQL Views and Stored Procedures Migrated from Legacy Platforms to Redshift
  • Re-Architected Data Pipelines for Scale, Reliability, and Reusability
  • Owned End-to-End Design, Development, Deployment, and Operations of a Containerized Cloud Map Server

Technical Skills

Languages and Cloud

  • Python
  • SQL
  • PySpark
  • AWS

ETL and ELT

  • Glue
  • Databricks
  • Kettle
  • Azure Data Factory

Databases and Warehouses

  • Redshift
  • Postgres
  • SQL Server
  • DynamoDB

CICD and DevOps

  • Docker
  • GitHub Actions
  • GitHub
  • CloudFormation
  • CDK
  • Azure DevOps

AI/ML

  • Claude Code
  • GitHub Copilot
  • Genie
  • MCP

Orchestration

  • Step Functions
  • Airflow
Optimization 2025 - 2026

Route Optimization

Automated sales rep scheduling with travel time, mandatory visits, and model-driven route planning for efficient HCP and HCO coverage.

Route optimization architecture
Analytics 2025

Sales Rep Training Analytics

Measured training outcomes to reveal skill gaps, engagement levels, and opportunities for learning improvement.

Analytics Sales Rep Training Analytics
Analytics 2023 - 2024

Sales and Activity Reporting

Delivered insight workflows across sales performance, HCP and HCO effectiveness, payer impact, and drug analytics.

Analytics Sales and Activity Reporting
Automation 2023

Automated Testing Framework

Integrated AWS and Jira to automate test lifecycle, reporting, issue creation, and operational visibility.

Automation Automated Testing Framework
Analytics 2022 - 2023

MiSol D&A

Enabled mileage and fleet analytics to improve tire performance, customer insights, and data-driven decision-making workflows.

Analytics MiSol D&A
Migration 2022

ADW to CDP Migration

Migrated a legacy SAP analytical warehouse to an AWS Redshift-based central data platform for improved performance and decision support.

Migration ADW to CDP Migration
Analytics 2021

TAC Data Lake Setup

Built a scalable AWS data lake to consolidate transportation and logistics data for unified analytics and operational visibility.

Analytics TAC Data Lake Setup
Analytics 2018 - 2021

PLM Data Management and Analytics

Modeled and prepared FlexPLM application data for analytics, improving visibility into product lifecycle attributes, manufacturing workflows, and downstream reporting use cases.

Analytics PLM Data Management and Analytics
Analytics 2017 - 2018

Enterprise Sales D&A

Built ETL workflows for retail sales data to support structured reporting, sales performance analysis, operational reconciliation, and business-ready data delivery.

Analytics Enterprise Sales D&A

IT Analyst

Tata Consultancy Services

Oct 2021 - May 2023 Kolkata, India
  • Implemented CDC pipelines using AWS DMS, Lambda, S3, and Glue.
  • Built ETL and ELT workflows into Redshift with BI support.
  • Automated alerts and infrastructure deployment with CloudFormation.
  • Migrated SAP HANA warehouse assets to AWS Redshift.

Associate Projects

Cognizant Technology Solutions

Nov 2018 - Oct 2021 Bangalore, India
  • Delivered PLM data management and analytics workflows using SQL, Oracle 13c, AWS S3, and Glue.
  • Designed data flows and ETL support for manufacturing analytics use cases.
  • Supported delivery coordination through Git and Jira-based development workflows.

Associate IT Consultant

ITC Infotech

Feb 2017 - Oct 2018 Bangalore, India
  • Delivered enterprise sales analytics using SQL Server, Pentaho Kettle, and REST integrations.
  • Built ETL solutions and supported reporting workflows for sales operations.
  • Worked across data integration, reporting support, and issue resolution for business users.

Support Engineer

Hewlett Packard Enterprise

Feb 2016 - Feb 2017 Bangalore, India
  • Supported vendor order data management workflows using SQL Server, MySQL, and HPSM.
  • Handled operational support, issue tracking, and data quality follow-ups for enterprise processes.

Analyst

Cognizant Technology Solutions

Nov 2014 - May 2015 Kolkata, India
  • Worked on vendor master data stewarding processes using Siebel CRM.
  • Supported data accuracy, business process compliance, and master data maintenance activities.

Academic Background

  • Bachelor of Technology, 2014 Electronics and Communication Engineering West Bengal University of Technology
  • Higher Secondary, 2009 Science Nirmal Hriday Ashram, West Bengal
  • Secondary Education, 2007 General Education Ramkrishna Mission Vidyabhawan, West Bengal

Start a Conversation for Consulting and Collaborations