Skip to content
AUKTContact me
Navigation.

Aghar Usman K TFull-stack developer

From the first clickto the database.

I’ve built an architecture studio’s website, Flask APIs, and an assistant that turns plain-English questions into SQL.

DATAAPIUI
Kerala, IndiaView tech stack
01 /Stack

Tools I build with.

Frontend, backend, data, and machine learning.

Frontend

ReactNext.js
  • TypeScript
  • JavaScript
  • HTML5
More tools (4)
  • CSS3
  • Tailwind CSS
  • Motion (Framer Motion)
  • GSAP

Backend & APIs

PythonFlask
  • FastAPI
  • REST APIs
  • Token-based auth
More tools (1)
  • Rate limiting

AI & machine learning

LLM IntegrationText-to-SQL
  • Prompt Engineering
  • Ollama
  • Llama 3
More tools (6)
  • Mistral
  • Claude
  • HuggingFace
  • TensorFlow
  • PyTorch
  • OpenCV

Databases & data

PostgreSQLMSSQL
  • MySQL
  • SQLite
  • SQL
More tools (4)
  • ETL Pipelines
  • Pandas
  • NumPy
  • Data Validation

Tools & cloud

Git/GitHubDocker
  • Linux
  • GCP
  • CI/CD
More tools (1)
  • Vercel

Languages

PythonTypeScript
  • JavaScript
  • Java
  • C
More tools (1)
  • SQL
02 /Experience

Experience.

APIs, automation, and data work.

Text-to-SQL example

Which orders are pending?

See how a plain-English question becomes a database query.

Feb 2025 – May 2025

Team Thai

Intern

Calicut, Kerala

Contributions

  1. Built an ERP assistant that turns plain-English questions into SQL Server queries using Llama 3 and Mistral. Added model fallback, retries, and time-limited caching.

  2. Cut response time by about 35% on a Flask API by caching results and fetching records in batches. The API supports concurrent requests, pagination, and CSV export.

More contributions (2)
  1. Restricted generated queries to SELECT statements and checked for seven SQL injection patterns.

  2. Built a PostgreSQL pipeline that loads records into a 22-column schema in batches of 100. It normalizes timestamps, retries failed loads, and reports failed records.

03 /Projects

Selected projects.

An architecture website, this portfolio,
and a plant disease detector.

SU·EN Studio

SU·EN Studio

SU·EN Studio homepage with its architecture portfolio introduction and a Kerala home
Open live website ↗
02 /2026

Personal Portfolio

This site

  • Next.js
  • TypeScript
  • Tailwind CSS
  • Motion
  • GSAP
  • Vercel

Built this single-page portfolio in Next.js and TypeScript. Its sections share one content file.

How I built it
  • Built a GSAP sequence that connects the hero illustration to each section as you scroll, with a reduced-motion view.
  • Deployed on Vercel.
03 /2024 – 2025

AgriLeaf Pro

Plant disease detection and soil monitoring

  • Python
  • TensorFlow
  • Flask
  • OpenCV
  • ThingSpeak
  • GCP

Trained a five-layer CNN to identify 19 diseases across four crops. It reached 85%+ accuracy and ran inference in under 100 ms on test hardware.

How I built it
  • Built a Flask API that preprocesses photos with OpenCV and returns treatment recommendations. The API uses token-based authentication.
  • Connected six soil measurements to ThingSpeak and displayed seven days of readings.
04 /Background

Education.

Degree, coursework, and hackathon work.

EducationAug 2021 – May 2025

Malnad College of Engineering

B.E. in Information Science and Engineering

Hassan, Karnataka

CGPA 7.81 / 10 · First Class with Distinction

View coursework (12)
  • Data Structures and Applications
  • Design and Analysis of Algorithms
  • Database Management Systems
  • Object Oriented Programming using Java
  • Software Engineering
  • Operating Systems
  • Computer Networks
  • UNIX and Shell Programming
  • Artificial Intelligence
  • Machine Learning
  • Big Data Technologies
  • Information Storage and Management

Achievements

  1. Placed second at a state-level hackathon. I led a team of four and built the backend for a working product we delivered in six hours.