sqlite>

Running…

name	role	education	core_skills	status
Ujjawal	Data Analyst	B.Tech CSE (2026)	SQL, Python, Power BI	Open to opportunities

// Ujjawal · Data Analyst

I turn messy data into dashboards people can actually read.

SQL · Python · Power BI · Excel — plus a stubborn habit of double-checking every number.

View projects Get in touch

Featured Projects

Internships

Certifications

SQL

Primary Skill

About

I wrapped up my B.Tech in Computer Science in 2026 and pointed it straight at data. Most of my time now goes into SQL, Excel and Power BI, with Python — Pandas and NumPy — for the heavier lifting.

I've done a remote database internship spanning SQL and MongoDB, and taken two projects from idea to something you can actually click: a Power BI sales dashboard built on a sample retail store, and Pardarshita, a railway-booking app backed by a SQL database with its own live dashboard. The part I enjoy most is the unglamorous one — chasing down dirty data until the final numbers are ones you'd trust. I'm looking for my first full-time Data Analyst role.

Skills

Languages & Querying

SQL Python

Data Analysis

Pandas NumPy Data Cleaning Exploratory Data Analysis KPI Reporting Data Quality Checks

Databases

MySQL MongoDB SQL Server

BI & Visualization

Power BI DAX Streamlit MS Excel (Pivot Tables, VLOOKUP, SUMIFS)

Tools

Git GitHub VS Code Jupyter Notebook

Core Competencies

Analytical Thinking Problem Solving Attention to Detail Documentation Communication

Projects

ShopSphere — E-Commerce Analytics Dashboard

Power BI · DAX · Excel

An interactive Power BI report built on a star-schema model, sitting on top of a two-year sample retail dataset — roughly 2,100 orders, 900 customers and ₹7.2 Cr in revenue. Past the usual revenue, orders and region KPIs, it calls out the trouble spots: the category losing the most margin, the most-returned product, and 45 items that had slipped below their reorder point — a short list of exactly where to fix pricing, curb returns and dodge stock-outs.

View Live Dashboard

Pardarshita — Railway Reservation System

Python · Streamlit · SQL

Pardarshita ("transparency") is a railway ticket-booking app I built in Python with a Streamlit front end over a SQL database. It behaves like the real thing: live bookings, plus a first-in-first-out waitlist so seats go out in the exact order people queued — no line-jumping. A separate admin view runs train schedules, seat availability and live PNR status.

GitHub Live Demo

Experience

Jun 2025 – Sep 2025

Database Intern (SQL / MongoDB · Remote)

Tamizhan Skills

A remote internship built around databases — SQL alongside MongoDB, so both the neat tabular world and the messier document one. Day to day I wrote SQL to add, join and pull records, then cleaned and validated the results so the data stayed accurate and consistent.

Jul 2024 – Aug 2024

IT Trainee

ONGC Videsh Ltd. — Delhi

A month of corporate IT training on the plumbing behind a data centre — IPv4/IPv6 addressing, subnetting, VLAN segmentation and firewall setup. Not analytics, but a close look at how enterprise infrastructure actually fits together.

Education & Certifications

Education

B.Tech — Computer Science & Engineering

Chaudhary Devi Lal University (CDLU), Sirsa · 2022 – 2026

CGPA: 7.6 / 10

Certifications

SQL (Intermediate) — HackerRank2026

Python Data Associate — DataCamp2026

Contact Me

Have a role in mind, a question, or a dataset that needs a second pair of eyes? Drop me a line.

khandelwalujjawal39@gmail.com

+91 82879 54832

Delhi, India

Download Resume