Hi, I'm Keshav Agrawal
Data Science & AI student who builds |
I'm an undergraduate at CHRIST University, Delhi NCR, and I like turning messy data into answers people can act on: pull it with SQL, wrangle it in Python, dig for the story, and put it on a chart that actually makes sense. If it involves data, a tricky question, and a stubborn bug — I'm in.
class Developer:
def __init__(self):
self.name = "Keshav Agrawal"
self.education = "B.Sc. Data Science & AI"
self.university = "CHRIST University"
self.gpa = 3.4 / 4.0
self.focus = ["Data Science", "Web Dev", "AI"]
def get_status(self):
return "Turning raw data into working products"
keshav = Developer()
print(keshav.get_status())
# Output: Turning raw data into working products
The data analyst toolkit
From pulling data with SQL to wrangling it in Python and putting it on a chart — the languages, libraries, and tools I reach for to turn raw data into answers.
Programming Languages
- PythonAdvanced
- SQLAdvanced
- JavaScriptProficient
- PHPIntermediate
- HTML / CSSAdvanced
- RIntermediate
Web Development
- HTML5 / CSS3Advanced
- Vanilla JavaScriptProficient
- PHP (Vanilla)Intermediate
- FastAPIProficient
- RESTful APIsAdvanced
- Chart.jsProficient
Backend & Databases
- MySQLProficient
- FastAPI BackendProficient
- Schema DesignIntermediate
- User AuthenticationSecure
- Session ManagementStateful
AI & Deep Learning
- LSTM Time-Series ForecastingApplied
- Computer Vision (CNN)Applied
- LLM Integration (Ollama)Hands-On
- Sentiment AnalysisApplied
- Model ValidationWalk-Forward
Data Analysis & Visualization
- PythonAdvanced
- Pandas & NumPyAdvanced
- Scikit-Learn & PytorchProficient
- Matplotlib & SeabornProficient
- ExcelAdvanced
- SQL (Advanced)Querying
- Tableau & Power BIProficient
- Statistical AnalysisStrong
Tools & Methodologies
- Git & GitHubAdvanced
- VS Code / JupyterAdvanced
- ClaudeDaily Driver
- Postman API TestingProficient
- OOP PrinciplesStrong
- Prompt EngineeringAdvanced
Things I've built
Four projects — the data, the models, the backend, and the pixels on top. See GitHub to download the repo.
SmartSIP – AI-Driven Dynamic SIP Accelerator
An intelligent web application that optimizes Systematic Investment Plans (SIP) using deep learning price predictions and real-time news sentiment.
Technical Implementation
- Frontend UI: Complete animated, responsive client utilizing Chart.js for interactive live Nifty 50 price tracking charts, a custom animated SVG market health gauge, and a 30-day sentiment trendline visualization.
- AI-Driven Backend: Fused real-time LSTM market projections and automated news sentiment parsing into 3 FastAPI endpoints to recalculate dynamic monthly multipliers.
- LLM Integration: Connected Llama 3.2 locally via Ollama to generate free plain-English rationales explaining monthly investment adjustments.
- Validation: Verified model performance across 10 years of Nifty 50 data utilizing 5-fold walk-forward validation.
Personal Budget Tracker – Full-Stack Web App
A dynamic, secure expense logging application designed with relational data storage, transactional insights, and modern DOM rendering.
Technical Implementation
- Frontend Engine: Implemented pure Vanilla JavaScript dynamic DOM updates, allowing users to filter transactions and add ledger logs seamlessly without browser refreshes.
- Backend & Logic: Structured robust relational query logic and secure session tokens in vanilla PHP supporting complete transactional CRUD activities.
- Database Schema: Crafted a normalized MySQL database structure linking `users`, `categories`, `transactions`, and `budgets` with strict referential integrity.
- Smart Alerts: Built custom notification flags triggered via CSS transitions when a user's category-wise expenses exceed their set limit.
FaceMask Detection – DL Computer Vision
A high-performance, web-based computer vision tool enabling real-time face-mask usage detection and compliance tracking.
Technical Implementation
- Browser Interface: Configured a responsive client-side layout enabling seamless system Webcam stream access and static image file parsing overlays.
- Bounding Box Rendering: Programmed real-time Canvas rendering loops displaying multi-face detection borders, confidence rates, and status tags (Mask / No Mask).
- Deep Learning Pipeline: Co-trained a high-accuracy Convolutional Neural Network (CNN) leveraging data augmentation techniques inside TensorFlow and Keras.
- OpenCV Processing: Handled camera frames and image standardizations, packaging the application for safety compliance runs inside workspaces.
Credit Risk Modelling – Loan Default Prediction
A binary classification model to predict loan default risks, featuring intensive exploratory data analysis and model comparison.
Technical Implementation
- Pipeline Architecture: Engineered a robust Python classification pipeline parsing borrower parameters (debt ratios, income stability, history, balances).
- Feature Engineering & EDA: Utilized Pandas and NumPy for extensive out-of-distribution tracking, missing data imputations, and outlier thresholding.
- Model Comparison: Evaluated Logistic Regression, Decision Tree, and Random Forest classifier performances against key recall matrices and confusion grids.
- Risk Indicators: Built a scoring utility mapping probabilistic model weights to actionable risk indicators for borrower solvency reports.
Education & credentials
Where I've studied and the certificates I've picked up along the way.
Bachelor of Science (Honors)
CHRIST (Deemed to be University), Delhi NCR, IndiaMajor: Data Science and Artificial Intelligence
A rigorous undergraduate curriculum focusing on quantitative mathematics, machine learning theory, programming methodologies, and data analysis pipelines.
Databases and SQL for Data Science with Python
IBM (via Coursera)Hands-on course covering relational database design and advanced SQL — joins, subqueries, aggregate functions, and views — then querying live databases directly from Python with SQLite, Db2, and pandas.
Verify credential ↗Google Data Analytics Professional Certificate
Google (via Coursera)Nine-course professional program covering the full analytics workflow — preparing, processing, analyzing, and sharing data using spreadsheets, SQL, Tableau, and Python — finished with a hands-on capstone case study.
Verify credential ↗Financial Markets
Yale University (via Coursera)Taken purely out of personal interest — an overview of the ideas, methods, and institutions behind risk management and finance, including behavioral finance, debt, equity, and the role markets play in society.
Verify credential ↗The Complete Full-Stack Web Development Bootcamp
Udemy (Instructor-Led Curriculum)Comprehensive hands-on training spanning layout styling, relational databases, responsive clients, server-side design, session tokens, and complete full-stack project building.
Beyond the keyboard
Things I follow and read about when nothing is due.
Financial Markets
I enjoy following how exchanges, risk, and human behavior shape prices. Completed Yale University's Financial Markets course (Coursera, 2026) purely out of curiosity.
Motorsports
I follow racing across the board — F1, IMSA, WEC, MotoGP, WRC — and live for the endurance classics at Le Mans and the Nürburgring. Strategy, tyre calls, and lap-time data are half the fun.
Data Storytelling
Turning messy datasets into visuals people actually understand — dashboards, charts, and the occasional over-engineered graph nobody asked for.
Poke around the terminal
Ask questions or inspect my portfolio directly via a custom CLI simulator.
Get in touch
Have an interesting project, internship opportunity, or just want to connect? Send me a message!