profile-pic

ABHISHEK KUMAR

I’m a Backend Engineer with over 2.5 years of experience designing and building scalable, high-performance systems. With a foundation in Electronics and Communication Engineering (ECE) from NIT Jalandhar, I bring a strong analytical mindset and a structured approach to solving complex engineering problems. Currently, I work at HCL Technologies (HCLTech), contributing to backend and data-driven solutions for Microsoft. I design and develop robust backend services, build and optimize APIs, and manage end-to-end system workflows using technologies such as C#, .NET, Azure Synapse, Azure Data Factory, Azure DevOps, Microsoft Fabric, SQL (SSMS), and Data Lake architectures.

  • Role

    Senior Consultant, Data Engineer

  • Years of Experience

    2.8 years

Skillsets

  • ELT
  • window functions
  • SSMS
  • Spark SQL
  • PySpark
  • Power BI
  • Performance Tuning
  • Notebook
  • MS Fabric
  • Medallion Architecture
  • Joins
  • Excel
  • ETL
  • Python
  • DevOps
  • Delta Lake
  • Databricks
  • Data Warehousing
  • Data Visualization
  • CTEs
  • azure pipelines
  • ADF
  • Git
  • Data Modeling
  • SQL

Professional Summary

2.8Years
  • Mar, 2026 - Present 4 months

    Senior Consultant, Data Engineer

    Citrin Cooperman
  • Oct, 2023 - Mar, 20262 yr 5 months

    Technical Lead, Data Engineer

    HCL Technologies

Applications & Tools Known

  • icon-tool

    Azure Synapse

  • icon-tool

    Power BI

  • icon-tool

    Azure DevOps

  • icon-tool

    Azure Data Factory

  • icon-tool

    GitHub Actions

  • icon-tool

    MySQL

  • icon-tool

    SSMS

  • icon-tool

    Python

  • icon-tool

    Spark SQL

Work History

2.8Years

Senior Consultant, Data Engineer

Citrin Cooperman
Mar, 2026 - Present 4 months
    Design and maintain cloud-based data solutions and end-to-end ETL/ELT pipelines across 3+ enterprise engagements, transforming raw data into business-ready datasets for analytics and reporting. Architect and orchestrate data pipelines using Azure Data Factory, PySpark, and notebooks with Medallion Architecture (Bronze, Silver, Gold), cutting data processing time by 30%. Rebuilt customer retention metrics (GRR/NRR) and reconciled revenue from raw billing data, resolving a 10+ point reporting gap flagged in client review. Perform data ingestion, cleansing, validation, and data modeling on structured and unstructured data, building reusable frameworks that improve data quality and reduce manual effort by 40%.

Technical Lead, Data Engineer

HCL Technologies
Oct, 2023 - Mar, 20262 yr 5 months
    Built Azure Data Factory (ADF) and Synapse pipelines plus Python/SQL ETL frameworks for multi-source ingestion and data validation, improving processing efficiency by 35% and cutting manual errors by 50%. Engineered PySpark notebooks, pipelines, and dataflows with Delta Lake in Microsoft Fabric Lakehouse, accelerating data migration and transformation by 30% while improving business data freshness. Streamlined reporting workflows and automated refreshes that cut report turnaround time for business teams by 15%, enabling faster data-driven decisions. Replaced legacy SPLA-based Excel processing with reusable Common Notebook Functions in Databricks/Fabric, eliminating dependency on external Excel ingestion and reducing manual maintenance effort by 70%. Supported production pipelines and CI/CD deployments, delivering key Microsoft projects with strong accuracy, service uptime, and client satisfaction.

Achievements

  • AIR 4778 in JEE Mains 2019
  • AIR 12k in JEE Advance 2019
  • OND'23 Star Performer Employee
  • Winners Award

Major Projects

2Projects

Cloud Notebook Application

    Developed a full-stack cloud-based note-taking application using the MERN stack, enabling users to create, edit, and organize notes through an interactive and responsive UI. Implemented secure data handling using REST APIs and MongoDB, ensuring structured storage and reliable note management.

Food Delivery Website

    Created a full-stack food delivery web application featuring restaurant browsing, menu exploration, order placement, and order history management. Developed backend RESTful services using Node.js and Express to manage users, restaurants, and orders with efficient NoSQL data modeling in MongoDB.

Education

  • B.Tech in Electronics and Communication

    National Institute of Technology, Jalandhar (2023)

Certifications

  • Az 900

  • Pl 300

  • Data engineering certified by msft

  • Nvidia generative ai with diffusion models

  • Nvidia data science certificate