Programming & Scripting
Databases
Data Engineering & Warehousing
Data Analysis & BI
Machine Learning & AI
Dev Tools & Platforms
Cloud Platforms

LeetCode Highlights

HackerRank Profile

• 🧠 End-to-end data analysis of Swiggy sales using SQL Server with Star Schema modeling

• 🧹 Data cleaning & validation (NULL checks,Empty String check, Remove duplicates)

• 📈 dimensional modeling with 1 Fact table and 5 Dimension tables

  • Fact_Order: contains measures like price_INR, rating, rating_count
  • Dim_Date: temporal attributes (year, month, quarter)
  • Dim_Location: geography (state, city, location)
  • Dim_Restaurant: restaurant master
  • Dim_Catagory: category master
  • Dim_Dish: dish master

• 📊 KPIs: Total Revenue, AOV, MoM/QoQ Growth, Top/Bottom cities, Restaurant performance metrics

• 🔎 Business insights: City expansion potential, restaurant dependency, pricing analysis, weekday vs weekend trends

• 🛠 SQL Server • T-SQL • Star Schema • Window Functions • CTE

• 🔗 Repo: Link

• 🧠 Predicts heart disease risk with confidence score using trained ML model

• 🧹 Full pipeline: Data cleaning → Preprocessing → Model training → Streamlit app → Deployment

• 📊 Model comparison: Logistic Regression (87%) vs Random Forest (100% accuracy) — RF chosen for deployment

• 🎯 Features: Real-time prediction, risk level categories (Low/Moderate/High), dark mode UI

• 🛠 Python • Scikit-Learn • Pandas • Matplotlib • Seaborn • Streamlit

• 🌐 Live Demo: Try the App

• 🔗 Repo: Link

• 🧠 A comprehensive student attendance management system that leverages facial recognition technology to automate student attendance tracking.

• 🧹 Student Form for registration

  • student will fill his/her personal information and student face images

  • student informations and enbeddings of students faces are temporarily stored in Google sheet

• 🧹Admin Panel

  • admin can control the opening and cloasing of the student registration form , after filling up the form by all the students admin push the student informations (which are temporarily stored in google sheet) in database personal informations are stored in the supabase(RDB) and embedding are stored inside Qdrant(VDB) , during pushing information student get their enrollment number in thier email (which they give during fill up the form)

  • admin can create new depaertment(dep_id,dep_name,dep_hod_name,dep_hod_mail) , update department information

  • admin can select duration(1-month) and department , during this duration student attendence list with %-of attendence of each student will send to the respective HOD's mail

• 🧹Give Attendence

  • student stand infront of camera it autometically detect face after that generate embedding and search (semantic searching : cosine similarity) in Qdrant database and and show the Student name , deparment name of the closest similer embedding if the student press 'confirm' button then his/he attendence will be recorded , if (face not recognized / other students information retrived) then student should press cancel button and contact with the admin(technical team of college)

• 🛠 Python • Pytorch • Supabase(RDB) • Qdrant(VDB) • Google Sheet • Streamlit

• 🔗 Repo: Link

Badge	Certification	Platform	Year	Proof
	Snowflake Data Warehouse	Snowflake	2025	Link
	Google Advanced Data Analytics Professional Certificate	Coursera	2025	Link
	Advanced Tableau	Corporate Finance Institute	2025	Link
	Deep Learning Specialization	Coursera	2025	Link
	Artificial Intelligence Fundamentals	IBM	2025	Link
	Fandamentals of Agents	Hugging Face	2025	coming soon

"Data is powerful — but only for those who know how to read it."