Hi, I’m Ashley Volans.

Turning messy data into clear decisions — Power BI, Excel/VBA, SQL, Python, SharePoint.

Ashley Volans headshot

Selected Projects

Comparator Clinical Supply Dashboard (Power BI)

Analyzed 500+ global comparator orders, set a 99-day baseline lead time, and launched a new performance management process to improve supplier OTD and data accuracy.

Power BISQLOperations Analytics

Case study coming soon • Code to be published later

Savings Visualization Tool (Excel + VBA)

Built a VBA tool that visualized $2M budgeted vs. actual savings to enable real-time storytelling for leadership.

ExcelVBAVisualization

Case study coming soon • Code to be published later

SharePoint Cleanup & Standard Work

Streamlined 7,500+ documents using Lean tools (VoC, stakeholder plan, SoW), reducing broken links/docs by 50% and enabling a smooth handoff for 100 global team members.

SharePointLeanProcess Design

Write-up coming soon

IBP Forecasting & Portfolio Insights (Power BI)

Unified 20+ datasets to clarify forecasting, segmentation, and variance; helped drive leadership decisions and supported a Lean Six Sigma Yellow Belt certification.

Power BIIBPStorytelling

Case study coming soon

Experience

Clinical Supply Intern — Johnson & Johnson Innovative Medicine

Horsham, PA • May 2025 – Aug 2025

  • Built a Power BI dashboard for 500+ orders; established a 99-day baseline lead time and kicked off a supplier OTD program.
  • Designed an Excel/VBA savings tool visualizing ~$2M; enabled real-time narrative reporting.
  • Streamlined 7,500+ SharePoint docs with Lean methods, cutting broken links/docs by ~50%.
  • Analyzed 420k+ inventory rows across 10+ warehouses; supported destruction/savings process.
  • Led a 10-person intern team to deliver a 50+ attendee philanthropic event.

Integrated Business Planning Intern — Johnson & Johnson Innovative Medicine

Titusville, NJ • May 2024 – Oct 2024

  • Recommended delisting 11 of 80 SKUs; approved and yielded multi-million-dollar cash-flow impact.
  • Consolidated 20+ datasets into a single Power BI tool for forecasting and segmentation.
  • Earned Lean Six Sigma Yellow Belt; organized Credo & engagement initiatives.

Employer Relations & Events Intern — Smith School of Business

College Park, MD • Jan 2024 – Present

  • Coordinated recruiting events for 75+ students and top employers; liaison between teams.
  • Managed schedules, comms, and resources for coaching staff.

Education

University of Maryland — College Park (Robert H. Smith School of Business)
BS Double Major: Supply Chain Management, Operations & Business Analytics; Minor: Sustainability • GPA: 3.8 • Anticipated May 2026

Relevant Coursework
  • Data Modeling in Business (RStudio regression)
  • Information Systems (Excel, Python, Tableau)
  • Intermodal Transportation SCM • IANA Intermodal Conference (discussed and learned from transportation professionals in security, AI, and logistics) • IANA Case Competition
  • Supply Chain Management (JIT, ERP, EVMI case)

Skills & Awards

Awards: U-21 Leading Change Sustainability Credential; Lean Six Sigma Certificate

Contact

Philadelphia, PA • ashleyvolans14@gmail.com

LinkedIn GitHub Resume (PDF)

Resume

Download Resume (PDF)