Junior Software Developer

Lakeside Book Company

Overview and Summary

Worked on development, automation, and database enhancement projects to improve internal tools, reporting, and production visibility. Quickly learned and applied C#, VBA, PowerShell, and Power BI while supporting multiple business-critical systems, including the Harrisonburg Intranet, Training Database, customer-facing databases, and production-floor monitoring tools.

Recognized for initiative, rapid learning, and problem-solving, I was invited to continue part-time after my internship to provide ongoing development support during the academic year.

Key Features

VBA/Access Automation

Built and automated VBA/Access solutions that eliminated manual workflows and saved approximately 10 staff hours per week.

Database Design and Security

Improved system performance and security by splitting databases, enforcing role-based access controls, and reducing recurring errors.

Production Monitoring Solutions

Designed and deployed automated production-floor monitor solutions using PowerShell, PC Sticks, and intelligent web/PDF switching logic.

Power BI Reporting

Developed and tested Power BI reports and dashboards for operational visibility and future automation opportunities.

System Troubleshooting and Support

Troubleshot data connections, reporting errors, and UI issues across internal systems, improving reliability and usability.

Technologies and Skills

Backend Development

C#, VBA/Access, PowerShell

Database Management

Microsoft Access, SQL, Database Design

Business Intelligence

Power BI, Data Visualization, Reporting

Web and Frontend

HTML, CSS, JavaScript

Implementation Highlights

VBA Automation System Design
Architected comprehensive VBA/Access automation solutions that eliminated manual data entry and processing tasks. Designed intuitive user interfaces and error handling to ensure staff could maintain systems without technical expertise.
Production-Floor Monitoring System
Designed an innovative automated monitoring solution using PowerShell scripts and PC Sticks that dynamically switched between web interfaces and PDF documents based on system status and alerts, providing real-time production visibility.
Multi-System Technical Support
Provided reliable technical support across multiple critical business systems including the Harrisonburg Intranet, Training Database, customer databases, and monitoring tools. Diagnosed and resolved data connection, reporting, and UI issues to minimize downtime.

Learning Outcomes