About me

I’ve 7+ years of experience architecting and scaling data-intensive systems across database, application, and cloud environments. My core expertise lies in advanced PostgreSQL programming and administration, performance optimization, and building reliable data platforms for high-throughput workloads.

I have hands-on experience designing and managing large-scale relational databases, executing complex migrations, and developing ETL pipelines for data ingestion and transformation. I’ve worked with cloud-native data services across Azure, AWS, and Google Cloud to build scalable and maintainable data workflows aligned with business needs.

Alongside data engineering, I develop backend services using Node.js and Express, enabling efficient data access through well-designed APIs. I focus on building systems that are performant, resilient, and observable, with a strong emphasis on scalability and long-term maintainability.

My Strengths

  • Web development icon

    Data Engineering

    Design and build data pipelines for ingestion, transformation, and downstream consumption. Skilled in handling structured datasets, implementing transformation logic, and ensuring data quality and consistency across workflows.

  • Web development icon

    Cloud Data Platforms

    Hands-on experience with cloud-based data workflows across Azure, AWS, and Google Cloud. Familiar with storage, compute, and orchestration services used in building scalable data systems, including data lakes, and pipeline orchestration tools.

  • Web development icon

    PostgreSQL SME

    Deep expertise in PostgreSQL, including query planning, indexing strategies (B-Tree, GIN), partitioning, and performance tuning. Strong understanding of concurrency, locking, vacuum processes, and diagnosing database issues.

  • Web development icon

    Distributed Database Systems

    Designed and managed high-availability database systems with replication and failover strategies. Executed large-scale database migrations, ensuring performance optimization, and minimal downtime in production environments.

  • Web development icon

    Backend Systems

    Build scalable backend services using Node.js and Express, focusing on efficient data access, REST API design, and system integration. Experienced in designing services that interact with large datasets and support high-throughput workloads.

  • Web development icon

    Technical Leadership

    Led cross-functional initiatives involving database, backend, and data workflows, coordinating with application and infrastructure teams. Responsible for driving technical decisions, ensuring system quality across delivery timelines.

Resume

Education

  1. St. Xavier's College (Autonomous), Kolkata, IN

    Jul 2017 — Jun 2019

    M.Sc. in Computer Science - 7.18 CGPA [First Class]

  2. Vidyasagar College (Calcutta University), Kolkata, IN

    Jul 2014 - Jun 2017

    B.Sc. in Computer Science - 63.75% [Hons. First Class]

Experience

  1. Apprentice Leader

    Mu Sigma Inc.

    Dec 2022 — Present
    • Designed and implemented data marts from a financial data warehouse using PostgreSQL, improving query performance by 75% and reducing ETL pipeline runtime by 40%.
    • Architected and executed a 500GB+ MSSQL → Azure Database for PostgreSQL migration, integrating MongoDB for document storage, ensuring data validation, consistency, and minimal downtime.
    • Built and optimized ETL pipelines using SQL and PL/pgSQL, leveraging scheduled jobs, triggers, and materialized views for near real-time data synchronization.
    • Designed high-availability PostgreSQL deployments on Azure, incorporating read replicas, partitioning, and failover strategies for production workloads.
    • Worked across multi-cloud database environments, with exposure to Amazon RDS and Google Cloud AlloyDB, understanding performance characteristics and deployment patterns for managed PostgreSQL systems.
    • Performed advanced query optimization (execution plans, indexing, partitioning) to support high-throughput applications.
    • Integrated backend services with data platforms via REST APIs (Node.js/Express) for efficient data access and system interoperability.
    • Implemented logging and monitoring practices across database and application layers to improve observability and debugging.
    • Addressed security vulnerabilities and audit findings, strengthening data protection and reducing risk exposure by ~50%.
    • Led a 10-member engineering team, driving delivery across data pipelines, backend services (Node.js, Express), and database systems using Agile practices.
  2. Trainee Decision Scientist

    Mu Sigma Inc.

    Nov 2019 - Nov 2022
    • Designed and optimized relational databases (PostgreSQL, MSSQL) with a focus on normalization, constraints, and query efficiency.
    • Implemented replication and clustering strategies in PostgreSQL, ensuring ~99.5% availability for critical workloads.
    • Developed ETL workflows using SQL-based transformations and scheduled jobs, improving reliability of reporting pipelines.
    • Built RESTful APIs using Node.js and Express, enabling seamless integration between application services and data platforms.
    • Deployed applications in Linux environments using Nginx and Tomcat, supporting production-grade systems.
    • Managed CI/CD workflows and version control using GitLab, ensuring structured development and release processes.
  3. Consultant

    Nielsen India Pvt. Ltd.

    Apr 2019 - Oct 2019
    • Performed data analysis and transformation to generate actionable insights.
    • Automated workflows using Excel VBA, reducing manual effort and improving accuracy.
    • Developed reports and visualizations for stakeholder decision-making.

Certifications

  1. Microsoft Certified: Azure Data Fundamentals, Microsoft

    April 2026View
  2. Data Streaming Engineer Foundations, Confluent

    March 2026View
  3. Microsoft Certified: Azure Fundamentals, Microsoft

    December 2025View
  4. AWS Certified Cloud Practitioner, AWS

    May 2025View
  5. SQL (Advanced) Certification, HackerRank

    Mar 2025View
  6. SQL (Intermediate) Certification, HackerRank

    Mar 2025View
  7. SQL (Basic) Certification, HackerRank

    Mar 2025View

Tech Stack

  1. Database Technologies: PostgreSQL, MongoDB
  2. Cloud Technologies: AWS, Azure, GCP
  3. Programming: Node.Js, Express.Js, Shell scripting
  4. ETL: Pentaho, Apache Hop, CRON
  5. DevOps: Gitlab CI/CD, Docker*
  6. Server Management: Linux, Nginx, Tomcat
  7. Project Management: Agile, OpenProject

Skill Badges

  • Microsoft Certified: Azure Data Fundamentals
  • Confluent Data Streaming Engineer
  • AWS Certified Cloud Practitioner
  • CRUD Operations in Mongo
  • Aggregation Fundamentals in Mongo
  • Query Optimization Techniques in Mongo
  • Vector Search Fundamentals in Mongo
  • RAG with Mongo

Portfolio

  • finance

    Test

    Web development

    Gamified learning website for kids and site contains UNITY games for development of children and having fun while learning.

    • React and Node Js
    • Express.js Server
    • Bootstrap and UNITY
    • MongoDB