Sumit Kushbaha

About Sumit Kushbaha

Working on ETL, Data warehouse project, mapping the columns and analyzing the Data and design the dimension modelling for ETL after that provide the reports. • Extensive experience in SQL Server Database, developing complex T-SQL queries, stored procedures, functions, CTE and Views using SQL Server 2008R2,2012.• Good knowledge in Datawarehouse concept.•Experience of developing ETL for supporting Data Extraction, Transformation and Loading using SQL Server Data Tools and SSIS tool.•* Led a team of 20–30 members, overseeing sprint planning, capacity management, and technical delivery.* Acted as a pseudo-lead and later dev lead, managing aggregations and framework enhancements.* Created onboarding kits and documentation to streamline new member integration.* Designed robust ingestion frameworks for batch and streaming using Azure Synapse, Databricks, PySpark, and ADX.* Delivered generic solutions for datetime transformation and partitioning across feeds.* Built parameterized frameworks for batch and streaming processes, reducing manual effort and improving scalability.* Created database projects and CI/CD pipelines for object and metadata deployments.* Optimized performance by restructuring feed execution strategies and partitioning logic.* Managed deployment planning, branching strategies, and validation processes for multiple environments.* Proactively identified risks and implemented mitigation strategies to ensure timely delivery.* Developed an AI-powered chat application leveraging Azure AI Search and Azure Foundry, enabling intelligent, context-aware responses from enterprise data.* Implemented Retrieval-Augmented Generation (RAG) pattern and fine-tuning techniques to optimize model performance and relevance.* Designed and executed a robust chunking strategy and integrated embedding models to enhance semantic search capabilities.* Built intelligent AI agents using Copilot Studio, enabling task automation and dynamic user interactions across business scenarios.

Experience

1. Senior Data Engineer Consultant

   Microsoft

   Mar 2025 — Present · Hyderabad, IN

   Led a team of 20–30 members, overseeing sprint planning, capacity management, and technical delivery.* Acted as a pseudo-lead and later dev lead, managing aggregations and framework enhancements.* Created onboarding kits and documentation to streamline new member integration.* Designed robust ingestion frameworks for batch and streaming using Azure Synapse, Databricks, PySpark, and ADX.* Delivered generic solutions for datetime transformation and partitioning across feeds.* Built parameterized frameworks for batch and streaming processes, reducing manual effort and improving scalability.* Created database projects and CI/CD pipelines for object and metadata deployments.* Optimized performance by restructuring feed execution strategies and partitioning logic.* Managed deployment planning, branching strategies, and validation processes for multiple environments.* Proactively identified risks and implemented mitigation strategies to ensure timely delivery.* Developed an AI-powered chat application leveraging Azure AI Search and Azure Foundry, enabling intelligent, context-aware responses from enterprise data.* Implemented Retrieval-Augmented Generation (RAG) pattern and fine-tuning techniques to optimize model performance and relevance.* Designed and executed a robust chunking strategy and integrated embedding models to enhance semantic search capabilities.* Built intelligent AI agents using Copilot Studio, enabling task automation and dynamic user interactions across business scenarios.

Education

• CET-IILM-AHL

  B-tech, CSE

  2008 — 2012

• National Public School

  Intermediate, P.C.M

  2006 — 2007

Skills

• Sql
• T-Sql Stored Procedures
• Asp.net
• Sql Server Management Studio
• Database Replication
• Ado.net
• Azure Data Factory
• Extract, Transform, Load (Etl)
• Html
• Devexpress Report
• C#
• Oop
• Css
• Ssrs
• Visual Studio
• Microsoft Office
• Etl
• Azure Sql Dw
• Javascript
• Requirements Analysis
• Software Engineering
• Requirements Gathering
• Data Warehousing
• Data Modeling
• Ssis
• Microsoft Sql Server
• Datawarehouse
• Azure Sql Db