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
Built and automated VBA/Access solutions that eliminated manual workflows and saved approximately 10 staff hours per week.
Improved system performance and security by splitting databases, enforcing role-based access controls, and reducing recurring errors.
Designed and deployed automated production-floor monitor solutions using PowerShell, PC Sticks, and intelligent web/PDF switching logic.
Developed and tested Power BI reports and dashboards for operational visibility and future automation opportunities.
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
Learning Outcomes
- Mastered VBA programming and Access database design for creating automated business solutions
- Developed proficiency in C# and .NET Framework for application development
- Learned PowerShell scripting for system automation and server management
- Gained expertise in Power BI for data visualization and business intelligence
- Improved database design, security, and optimization skills through real-world implementation
- Developed strong troubleshooting and problem-solving abilities across diverse technical systems
- Enhanced ability to translate business requirements into technical solutions
- Practiced professional communication and technical documentation for knowledge transfer