Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic
Prateek Khandelwal

Prateek Khandelwal

New Delhi

Summary

Adept Technical Lead with a proven track record at HCL, leveraging SQL expertise and machine learning to drive data-driven decision-making and enhance user productivity. Excelled in developing advanced ML models and frameworks while showcasing strong analytical abilities and collaborative skills. Demonstrated success in optimizing processes and implementing innovative AI solutions for scalable impact.

Overview

2
2
years of professional experience
1
1
Certification

Work History

Technical Lead

HCL
New Delhi
08.2022 - Current

SQL DEVELOPER

  • Developed stored procedures, functions, and triggers to support application requirements in SQL Server (SSMS).
  • Optimized stored procedures for improved performance using advanced SQL query tuning techniques in SQL Server.
  • Designed and implemented user roles and permissions, ensuring data security and controlled access.
  • Developed custom SQL reports for business users, providing real-time insights and supporting data-driven decision making.

ML/AI developer

  • Developed a comprehensive ML framework aimed at enhancing user productivity through actionable recommendations, utilizing machine learning models such as Linear Regression, Decision Trees, Random Forest, and Gradient Boosting for output and productivity prediction.
  • Implemented end-to-end data preprocessing steps, including imputation, encoding, feature maximization, and normalization.
  • Designed and optimized ML pipelines for training, validation, and deployment, ensuring robust performance through systematic hyperparameter tuning and model selection based on best metrics.
  • Integrated large language models (LLMs), specifically LLaMA 3.1, into the framework to enhance recommendation generation and improve user interaction through a chatbot interface.
  • Developed a Retrieval-Augmented Generation (RAG) system within the framework, enabling enhanced contextual responses and tailored recommendations for specific use cases.
  • Collaborated cross-functionally to ensure alignment between UI/UX, API development, and ML functionality, improving overall usability and effectiveness of the platform.
  • Utilized Python and relevant ML libraries (such as scikit-learn, pandas, NumPy, and Flask) for model building, deployment, and API integration, ensuring scalability and modularity of the ML framework for future enhancements

Education

B.Tech - Electrical Engineering

Delhi technolgical University
Delhi, India
11.2024

Diploma - Electrical Engineering

Pusa Institute of Technology
delhi, India
06.2018

High School -

Manvi Public School
Delhi, India
04.2015

Skills

Programming languages: Python, SQL, Pandas, NumPy, Scikit-learn, Matplotlib, Seaborn, Flask, HTML, and CSS

Machine Learning Techniques: Logistic Regression, XGBoost, Decision Trees, Random Forest, Linear Regression, and Decision Tree Regression, Data Preprocessing (Imputation, Encoding, Feature Engineering, Normalization)

Additional Skills: JIRA, Git, Process Development, Statistical Modeling, Data Analytics, Analytical Abilities, Statistics, Big Data, Data Visualization, Predictive Modeling

AI Skills: Skills: Natural Language Processing (NLP), Machine Learning, Deep Learning, Large Language Models (LLMs), Text Generation, Sentiment Analysis, Conversational AI, Transfer Learning, Retrieval-Augmented Generation (RAG), Reinforcement Learning, TensorFlow, PyTorch, and API Development for AI Solutions

Certification

  • Python, Coursera
  • Data structure and algorithms, Coding Ninja
  • Front end web developer, Coursera
  • Machine learning, through company portal
  • LLM Basics, through company portal
  • SQL

Timeline

Technical Lead

HCL
08.2022 - Current

B.Tech - Electrical Engineering

Delhi technolgical University

Diploma - Electrical Engineering

Pusa Institute of Technology

High School -

Manvi Public School
Prateek Khandelwal