Amit Thakur

2× Applause Award recipient at Deloitte USI.

AI & Data Engineer I at Deloitte USI (2024-11 – Present)

• Data Quality, Validation & Root-Cause Analysis: Designed grain-level reconciliation for every pipeline, replaying pipeline filter logic as independent SQL against raw source extracts and matching row counts, values, and derived calculations record by record; profiled data to surface anomalies, root-caused or justified every mismatch ahead of SIT, UAT, and production releases via Azure DevOps (ADO), earning an Applause Award and client sign-off that grew the engagement into a $1M contract.
• Customer 360 — Data Modeling (Snowflake): Developed Silver and Gold tables, views, tasks, and stored procedures unifying 13 structured source systems; designed identity resolution collapsing each customer into one unified ID consumed by all downstream models.
• Salesforce Data Integration (ADF + Snowflake): Built 5 Azure Data Factory pipelines processing 30M+ records from Snowflake / SSMS via multi-view join SQL into downstream Salesforce systems.
• Customer Feedback Analytics (AWS + PySpark): Ingested Qualtrics REST API (JSON) feedback as Parquet batches in S3; client CSV drops auto-triggered event-driven Lambda and Glue PySpark jobs applying client rules to prioritize and flag every record, exposed via Athena with SNS alerting.
• AI-Assisted Development: Authored reusable Claude Skills automating regression test runs and pre-push validation checks (logging coverage, coding standards); instrumented hooks capturing AI adoption and code quality metrics across delivery teams, and ran knowledge-transfer sessions on rollout.

B.Tech in CSE – Siksha 'O' Anusandhan, ITER (2020 – 2024)