Software Projects

Hi, I'm Shivam Tewari!

Welcome to my personal site, where I showcase my background, projects, and contact information.

Summary

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. 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 focus on implementing AI agents, tracing their behavior, evaluating performance, and integrating LLMs to enhance software applications. It's this mix of creativity, problem-solving, and intelligent systems that keeps me motivated. Feel free to check out my work and reach out!

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. The app offers several dashboards and charts that help users understand wait time distributions, compare locations, and determine the best times to visit a DMV based on historical data.

  DMV Dashboard Features

  • XML Data Pipeline: Parses and imports DMV data from raw XML files using a custom processing function.
  • Clean Data Workflow: Raw XML files are cleaned and normalized before being stored in a structured SQLite database.
  • Django Models: Custom model designed for DMV records based on provided XML structure.
  • Dashboard Navigation: Unified dashboard with navbar linking all major views and tools.
  • Summary View: Displays total number of DMV entries.
  • Wait Time Buckets: Bar charts group average wait times into 10-minute intervals.
  • Top/Bottom DMV Comparison: View and filter top and bottom 20 DMVs by average wait time, location, or proximity.
  • Address Input: User can input their address to sort DMVs by nearest location (uses Google Maps API).
  • Hourly Wait Analysis: For a selected DMV, shows hourly wait trends in EST and suggests best visit time (excludes closed hours).
  • Geocoding: Google Maps API with OpenCage fallback used to verify and update DMV coordinates.
  • Timezone Handling: Timestamps stored in UTC and displayed in EST.
  • Normalized DB Schema: SQLite database includes dmvdistrict, dmvlocation, and waittimeentry tables.
  View on GitHub See Wait Times
  
  
  

• 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.

  View on GitHub View Course Certificate
  
  
  

• 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.

Contact Me