About Skills Experience Projects Education Contact
Open to Opportunities · Ahmedabad, GJ
Data Science & AI Engineer

Turning Raw Data into Intelligence.

Hi, I'm Dhruval J. Rana — a Data Analyst & AI/ML Engineer from Ahmedabad, Gujarat. I build predictive models, intelligent chatbots, and beautiful data dashboards that solve real business problems.
MSc BI & Analytics · CGPA 9.3 · 2+ yrs experience.

Scroll to explore
PythonMachine LearningPower BIDeep Learning DjangoNLPData VisualizationLangChain SQLComputer VisionYOLOv8TensorFlow RAG ChatbotsLangGraphTableauStreamlit PythonMachine LearningPower BIDeep Learning DjangoNLPData VisualizationLangChain SQLComputer VisionYOLOv8TensorFlow RAG ChatbotsLangGraphTableauStreamlit PythonMachine LearningPower BIDeep Learning DjangoNLPData VisualizationLangChain SQLComputer VisionYOLOv8TensorFlow RAG ChatbotsLangGraphTableauStreamlit

Analyst.
Builder.
Problem Solver.

I'm a Data Science professional currently pursuing MSc in IT (Business Intelligence & Analytics) at JG University with a 9.3 CGPA. I've spent the last two years extracting meaning from messy data and building intelligent systems.

At TechnoAdviser Technologies, I deliver AI/ML solutions — RAG chatbots, travel planners, and automation pipelines and full-stack analytics platforms. Previously at Nautics Technologies(2 years), I honed my skills in data mining, campaign optimization, and lead generation.

My philosophy: data has a story — I help it speak clearly and act decisively.

When I'm not coding, you can find me hiking, experimenting with AI art, or sharing insights on LinkedIn.

I'm passionate about leveraging data and AI to drive impactful solutions. Always eager to connect with fellow data enthusiasts, so feel free to reach out!

Beyond work, I run personal data visualization projects, experiment with emerging AI tools, and occasionally win hackathons.

Core strengths: Data Analysis, Machine Learning, Deep Learning, NLP, Computer Vision, Data Visualization, RAG Chatbots, Full-Stack Development.

9.3
CGPA – MSc IT
6+
Projects Shipped
2+
Years Experience
🏆1st
Hackathon Runner-Up

The Tools I Wield

🐍 Languages & Core Libraries
PythonSQL NumPyPandas Scikit-learnStatsmodels
🤖 AI / ML / DL
TensorFlowKeras YOLOv8LangChain LangGraphOpenCV RAGCNN
📊 BI & Visualization
Power BITableau PlotlyMatplotlib SeabornDAXPower Query
🌐 Web & Backend
DjangoDjango REST StreamlitGunicorn HTML/CSS/JS
🗄️ Databases & Big Data
MySQLPostgreSQL MongoDBSQLite Oracle 11gHadoop HiveQLHDFS
⚙️ Tools & Platforms
DockerGit AzureJupyter RazorpayCloudflare AI Google GeminiHugging Face MATLAB

Where I've Built Things

Feb 2026 – Present
Python Developer (AI/ML)
TechnoAdviser Technologies Pvt. Ltd. · Ahmedabad
  • Delivering AI/ML solutions — RAG chatbots, analytics platforms, and travel planners — improving automation and user engagement
  • Built GAANDIV: RAG-based chatbot using Llama 3.1 via Cloudflare Workers AI, TF-IDF retrieval, and PDF/HTML knowledge ingestion
  • Developed Trip-Z: AI travel planner with personalized itineraries, PDF export, and Razorpay subscription billing
  • Designed and implemented a full-stack AI analytics platform that transforms raw CSV/Excel files into interactive dashboards with natural language querying
Dec 2023 – Dec 2025
Data Mining Executive
Nautics Technologies Pvt. Ltd. · Ahmedabad
  • Conducted data mining and extraction from structured and unstructured sources at scale
  • Implemented data-driven lead generation strategies, significantly improving targeting efficiency
  • Validated, cleaned, and optimised large datasets to enhance campaign performance
  • Improved email campaign conversion rates through analytical modelling and A/B test insights

Projects That Matter

Six projects across AI, computer vision, full-stack web, and data analytics — each solving a real problem with precision-engineered code. Scroll through to explore each one.

DashNexus AI Analytics Platform
Analytics · AI Dashboards
01 — Flagship Project

DashNexus

An AI-powered analytics platform that transforms raw CSV/Excel files into interactive dashboards in minutes. Upload your data — DashNexus automatically cleans it, runs feature engineering, generates AI insights, and builds charts. Explore results through a conversational chat interface, voice queries, or direct editing. Built as a full production SaaS with subscription monetization.

DjangoLangGraph LangChainPlotly Google GeminiScikit-learn
  • Automated data cleaning, feature engineering & profiling pipeline
  • AI-powered chart generation from natural language prompts
  • Conversational + voice query interface for dashboards
  • Subscription monetisation — production-ready SaaS architecture
GAANDIV RAG Chatbot
RAG · LLM · Knowledge Base
02 — RAG Chatbot System

Gaandiv

An AI-powered knowledge-base chatbot using Retrieval-Augmented Generation (RAG) to answer domain-specific queries accurately. Built with a custom retrieval pipeline: embedding-based search with a TF-IDF fallback, and Llama 3.1 via Cloudflare Workers AI for response generation. Features multilingual support, session chat history, admin knowledge management, and a glassmorphism UI.

DjangoLangChain Cloudflare AIPostgreSQL TF-IDFRazorpay
  • Custom embedding retrieval pipeline with TF-IDF fallback
  • PDF & HTML document processing for knowledge ingestion
  • Multilingual chat + session-based history + admin panel
  • Glassmorphism UI with markdown rendering & code highlight
Emotion Detection AI
CNN · Computer Vision · FER2013
03 — Computer Vision · Deep Learning

Emotion
Detect

A Django + TensorFlow web application that classifies 7 human emotions in real-time from live webcam feeds or uploaded images. The CNN was trained on the FER2013 dataset using data augmentation and regularisation for improved accuracy. Features global model caching for high-speed inference and a modern glassmorphism UI with animated gradient backgrounds.

TensorFlowKeras OpenCVDjango CNN
  • 7-class recognition: Angry, Disgust, Fear, Happy, Sad, Surprise, Neutral
  • Real-time webcam feed with instant visual feedback overlay
  • Global model caching for high-performance inference
  • Animated gradient glassmorphism frontend design
Trip-Z AI Travel Planner
AI Travel · Itinerary · Razorpay
04 — AI Travel App

Trip—Z

A full-stack Django travel assistant with an AI-driven chat UI that saves sessions, integrates an LLM for personalised travel recommendations, supports PDF export of complete itineraries, and manages subscriptions with Razorpay payments. Built with a layered service architecture: prompt_builder, gemini_service, pdf_service, and razorpay_service.

DjangoGemini APILLM RazorpayPDF Export REST API
  • Persistent chat sessions with LLM-powered travel advice
  • Prompt builder + Gemini service for itinerary generation
  • PDF export of complete trip plans via pdf_service
  • Subscription plans with live Razorpay payment integration
Real-Time Object Detection
YOLOv8 · OpenCV · Real-Time
05 — Real-Time Vision

Object
Detect

A YOLOv8-powered real-time object detection system supporting multiple input sources: live webcam, video files, static images, and UAV dataset batches. Features trajectory tracking with a history deque, direction prediction (Up/Down/Left/Right), live object counting, and a real-time analytics dashboard — all running in a multi-threaded architecture that keeps video playback smooth.

YOLOv8OpenCV MatplotlibPython Threading
  • Webcam, video, image & UAV dataset batch processing pipelines
  • Trajectory tracking with history deque & direction prediction
  • Real-time object counting with time-series chart visualisation
  • Multi-threaded live plotting without blocking the video feed
URL Maliciousness Detector
Cybersecurity · ML · Django
06 — CyberSec · ML Microservice

URL
Maliciousness
Detect

A decoupled Django + ML microservice system for real-time URL maliciousness classification. The Django frontend collects user-submitted URLs and displays detection history, while a separate Python ML service handles feature extraction, model inference (scikit-learn), and exposes a REST API. Results — malicious or benign, with confidence — are stored and visualised.

Scikit-learnDjangoSQLite REST APIDocker Python
  • Decoupled architecture: Django UI + standalone ML service communicating via HTTP
  • Feature extraction pipeline from raw URLs with trained scikit-learn classifier
  • Malicious / Benign output with confidence scoring per request
  • Detection history dashboard stored in SQLite with visual summary

Education & Certifications

Master of Science in IT
Business Intelligence & Analytics
JG University · 2024 – 2026
CGPA 9.3 / 10
Bachelor of Computer Application
Computer Science
Lokmanya College (Gujarat University) · 2021 – 2024
CGPA 6.70 / 10
1st Runner-Up — College Hackathon (Django CMS)

Data Visualization Certification — Tata

Data Analytics Job Simulation

C Programming — C-DAC

Have a Project
in Mind?

Whether it's an intelligent dashboard, a conversational AI, a CV system, or a data pipeline — I'm always open to exciting work, collaborations, freelance projects, and full-time opportunities.