Book Market Data Analytics Platform
2026. Built an end-to-end analytics pipeline to scrape, clean, transform, and analyze 1,000+ books across 50 categories using Python and Pandas. Designed a normalized PostgreSQL database with primary/foreign keys, constraints, and indexes, and loaded the processed dataset programmatically. Performed advanced SQL analysis using JOINs, aggregations, CTEs, subqueries, CASE, HAVING, and window functions to analyze pricing, ratings, and category trends. Conducted EDA with Pandas and Matplotlib to identify price distributions, rating patterns, category-level statistics, and potential outliers.
Smart Recruitment Analytics Platform
2026. Built a Python Flask microservice that trains and serves a scikit-learn logistic regression model to score and classify candidates, integrated with the main platform via REST calls. Designed a Node.js/Express/PostgreSQL backend with role-based access control separating admin and recruiter permissions. Implemented candidate CRUD workflows and a Chart.js dashboard visualizing recruitment pipeline stages and hiring metrics.
LinkPulse – Smart URL Shortener & Analytics Platform
May 2026 – Jul 2026. Built a full-stack URL management and analytics platform enabling users to create short links and track engagement. Designed a PostgreSQL-backed analytics engine capturing click events to generate insights on traffic sources, devices, browsers, and referrers. Architected a modular Node.js/Express backend with JWT authentication, bcrypt password hashing, input validation, and protected API routes.