Hi, I'm Shivam Tewari!
I'm starting my career in IT with a focus on Data Science, Generative AI, and Software Engineering. I earned my Associate’s Degree in Computer Programming & Development from Wake Tech in 2024. Transitioning from a customer service background, I bring strong problem-solving, communication, and teamwork skills to software engineering. What draws me to this field is the balance between logic and creativity. I enjoy breaking down problems, building practical solutions, and designing systems that transform data into insights. I am skilled in Django (Python) and ASP.NET Core (C#, Blazor, Razor) with experience in API integration, database management, UI/UX design, and generative AI development.
My Projects
-
Project 1: NC DMV Wait Time Analysis
DMV Wait Time Analysis is a Django-based web application that aggregates, analyzes, and visualizes DMV wait time data for North Carolina. In addition to interactive dashboards and charts for exploring wait time distributions and comparing locations, the app now features a DMV Chatbot powered by Retrieval-Augmented Generation (RAG) using FAISS, LangChain, and Transformers. This chatbot allows users to ask DMV-related questions and receive intelligent, data-driven answers, with secure, session-based API key storage.
DMV App Features
Click each tab to learn more about the main features of the DMV Wait Time Analysis app.
- DMV Chatbot (RAG): AI assistant using Retrieval-Augmented Generation (RAG) with FAISS, LangChain, and Transformers. Secure session-based API key storage.
- XML Pipeline: Imports DMV data from XML files.
- Clean Workflow: Cleans and normalizes data before storage.
- Django Models: Custom models for DMV records.
- Navigation: Unified dashboard with navbar for all tools.
- Summary: Shows total DMV entries.
- Wait Buckets: Bar charts of average wait times in 10-minute intervals.
- Top/Bottom: Filter top and bottom 20 DMVs by wait time, location, or proximity.
- Address Input: Sort DMVs by nearest location (Google Maps API).
- Hourly Analysis: Hourly wait trends and best visit time suggestions.
- Geocoding: Verifies and updates DMV coordinates (Google Maps & OpenCage).
- Timezone: Timestamps stored in UTC, displayed in EST.
- DB Schema: SQLite database with dmvdistrict, dmvlocation, and waittimeentry tables.
-
Project 2: E-Commerce Sales Analysis
This is a project completed as part of the Google Data Analytics Specialization on Coursera. Analyzed sales data to identify trends, insights, and opportunities for the e-commerce company. Tools used include R Programming, Excel, Tableau, and SQL.
-
Project 3: Video Rental Web Application
This Wake Tech Capstone Group Project is a web application that allows users to rent, return and calculate late fees on a variety of movies. Tools used include Django, Python, SQLite, HTML, CSS, and Javascript.