My Projects
FlashSale Concurrency Engine
High-concurrency backend API that prevents inventory overselling during flash sales. Implements ACID transactions and Pessimistic Locking (SELECT FOR UPDATE) to solve database race conditions.
- FastAPI
- MySQL
- SQLAlchemy
- Threading
Netflix Content Analysis
Analyzed Netflix's catalog using Python (Pandas, Seaborn) to uncover insights about content trends, genres, and ratings.
- Python
- Pandas
- Seaborn
FastAPI Book Manager API
Developed a high-performance RESTful API for book management (CRUD operations). Integrated with MySQL using SQLAlchemy ORM and utilized Pydantic for data validation.
- FastAPI
- SQLAlchemy
- MySQL
Shopping Mall Sales Dashboard
Power BI dashboard showing revenue breakdown by age group, gender, payment method, and location.
- Power BI
- Excel
Sales Analysis Dashboard
A dynamic Power BI dashboard analyzing sales performance, product-wise revenue, and regional breakdown.
- Power BI
- Excel
Movie Ticket Booking System
Developed a desktop-based ticket booking system using Python (Tkinter) and MySQL. Handles seat booking, movie listings, and user data storage.
- Python
- MySQL
- Tkinter
Sentiment Trends & Social Media Analysis
An interactive Power BI dashboard visualizing emotional trends, popular hashtags, and user engagement by sentiment across social platforms. Built using cleaned Excel data and custom DAX metrics.
- Power BI
- DAX
- Excel
About Me
Hi, I’m Muhammad Roshaan a Computer Science 3rd year student with hands-on experience in backend development and data analytics. Skilled in FastAPI, Python, SQL, MySQL/MongoDB, and Power BI. Seeking an internship or junior role to contribute to backend or data-driven projects while gaining industry experience.
Download Resume