Dynamic Company Dashboard

Developed a custom company dashboard that includes:

• Seasonal & date-based decorations (adds festive elements dynamically)
• Data-driven insights for internal use
• Real-time business performance tracking

Fleet Data Entry Form

Created a secure online form for fleet users to submit field metrics. Key features:

• Microsoft Authenticator integration (verifies devices registered to our domain/AD)
• SMTP functionality (sends reports automatically)
• User-friendly interface for data input

Arachnoid-Style Blox Breaking Game

Created a brick-breaker game in Python, using the Turtle module. Built as an executable (.exe), it features:

• Custom audio tracks & sound effects
• High score tracking system
• Game mechanics inspired by classic arcade games

Highway Segment Plotter

Developed a mapping tool that utilizes the Google Maps API & Directions API to create highway segments (1-2 miles each). Features include:

• Excel import/export functionality
• Custom segment plotting
• Generic data creation for related fields

Internal Trash Collection Summary

Built a data-filterable web tool that tracks the number of bags of trash collected, filtered by sponsor name. Used for marketing and reporting purposes.

Arizona DOT Fleet UI

Designed a real-time fleet tracking interface for Arizona's Department of Transportation. It integrates:

• Samsara API for fleet locations
• Google Maps API for interactive mapping
• Web-based user interface for quick monitoring

Power BI Reports for Administrative Insights

Developed nearly 20 interactive Power BI reports, hosted online and embedded into our company's SharePoint site. These reports provide real-time business intelligence and include:

• Advanced filtering options (allowing users to dynamically adjust data views)
• Help popups for better user experience and guidance
• Complex data filtering & calculations for deep insights
• Live connections to SQL Server for real-time data updates
• Custom-built visuals & dynamic dashboards for data analysis

These reports empower various departments by automating data retrieval and improving decision-making through interactive dashboards.

VBA Call Center Tally Script

Developed a VBA script that styles and tallies incoming calls for a 4-person call center team. This automation improved efficiency by tracking answered calls and formatting the data for easy reporting.

• Dynamically scores recipients
• Categorized calls, filtering withing normal business hours
• Color coded formatting