LOGAN VONGUNDEN
Bellefonte,PA
Summary
Information Sciences and Technology student at Penn State University (A.S., May 2026) with hands-on experience spanning data analytics, IT infrastructure, and systems administration. Proven ability to build SQL Server databases, Power BI dashboards, and Python-based forecasting tools while also deploying and managing virtualized enterprise environments using VMware, Windows Server 2022, and Active Directory. Currently pursuing CompTIA Network+ and Security+ to formalize a foundation in networking and information security. Seeking an IT or data-focused role where a hybrid analyst-technologist background can contribute across both domains.
Overview
5
5
years of professional experience
Work History
Data Analyst & IT Intern
Supply Chain Process Improvement (SCPI)
01.2026 - Current
- Design and maintain SQL Server databases and stored procedures supporting multi-scenario transportation modeling and route optimization across hundreds of service locations.
- Build and deploy Power BI dashboards and KPI reports, translating complex operational datasets into client-ready visualizations for major utility and logistics clients.
- Develop demand forecasting and inventory optimization models using Python and Excel, applying statistical methods to improve supply chain decision-making.
- Provide IT support across Microsoft 365 environments including Teams, OneDrive, and SharePoint; troubleshoot network connectivity and hardware issues in coordination with on-site support teams.
- Perform data wrangling, cleansing, and validation pipelines to ensure integrity of large-scale datasets across client projects.
Self-Directed Infrastructure Project
IT Home Lab
01.2026 - Current
- Built and maintain a virtualized enterprise-like network environment using VMware Workstation Pro, simulating real-world IT infrastructure at small-business scale.
- Configured Windows Server 2022 as a Domain Controller with Active Directory, DNS, DHCP, organizational units, group policies, and user account administration.
- Deployed Ubuntu Server 24.04 LTS as a secondary node with inter-VM networking configured for cross-platform communication and service testing.
- Integrating Microsoft Entra ID (Azure AD) via free Azure tenant to explore hybrid identity management and cloud-joined device workflows.
- Developing a GitHub portfolio of PowerShell automation scripts for user provisioning and administrative task automation.
Relief Manager / Bartender
Axemann Brewery
04.2021 - Current
- Oversee daily operations including staff coordination, cash management, and end-of-day financial reconciliation (Manager role, Mar 2025 – Present).
- Train and mentor new hires on service standards, POS systems, and operational procedures; supervise a team of servers and bartenders.
- Develop seasonal menus and collaborate on new product offerings to drive revenue and customer engagement.
- Maintain health, safety, and compliance standards in a high-volume, fast-paced environment.
Education
A.S. - Information Sciences and Technology
Pennsylvania State University
University Park, PA05-2026
Skills
- Data & Analytics: SQL Server, Python, Power BI, Microsoft Excel, ETL/Data Wrangling, Demand Forecasting, Inventory Modeling
- IT Infrastructure: VMware Workstation Pro, Windows Server 2022 (Active Directory, DNS, DHCP, GPO), Ubuntu Server 2404 LTS, PowerShell
- Cloud & Identity: Microsoft Entra ID (Azure AD), Microsoft 365 Administration, SharePoint Online, OneDrive, Teams
- Languages & Tools: Python, SQL, Java, JavaScript, HTML/CSS, Git/GitHub, Microsoft Office Suite (Excel, Word, PowerPoint)
- Certifications: CompTIA Network (in progress), CompTIA Security (planned)
Websites
Timeline
Data Analyst & IT Intern
Supply Chain Process Improvement (SCPI)
01.2026 - Current
Self-Directed Infrastructure Project
IT Home Lab
01.2026 - Current
Relief Manager / Bartender
Axemann Brewery
04.2021 - Current
A.S. - Information Sciences and Technology
Pennsylvania State University