RYAN HAYES
Business Administration Graduate
Columbus, OH · r.hayes@email.com · (555) 330-8842
Summary
Recent business administration graduate with hands-on experience through two internships in retail operations and consulting case work. Skilled in data analysis, Excel modeling, and cross-functional teamwork; seeking an entry-level business or operations analyst role.
Experience
Business Operations Intern · Target Corporation
Jun 2025 - Aug 2025
- Analyzed inventory data across 15 stores and built a restocking dashboard that reduced out-of-stock incidents by 11%
- Partnered with 4 department managers to streamline the weekly reporting process, saving 5 hours per week
- Cleaned and standardized 9,000 rows of SKU data in Excel using Power Query for weekly reporting
Consulting Case Intern · PwC
Jan 2025 - May 2025
- Supported a 3-person team on a client cost-reduction study, researching 20+ vendor contracts
- Built a PowerPoint deck presented to senior partners summarizing $180K in identified savings opportunities
- Modeled 3 pricing scenarios in Excel to compare vendor consolidation options for the client
Student Office Assistant · Fisher College of Business, The Ohio State University
Sep 2023 - Dec 2024
- Processed 60+ student records per week in Workday and corrected 300 duplicate entries
- Answered roughly 40 front-desk and phone inquiries daily during peak registration periods
- Maintained a shared Google Sheets room-booking calendar covering 12 seminar rooms
Education
B.S. Business Administration — The Ohio State University · 2026
Skills
Microsoft Excel, PowerPoint, Data Analysis, Market Research, CRM (Salesforce), Financial Modeling Basics, Communication, Project Coordination, Google Workspace, Problem Solving
Certifications
Microsoft Office Specialist: Excel Associate, Microsoft
Google Data Analytics Professional Certificate, Google
Bloomberg Market Concepts, Bloomberg
Projects
Capstone Market Study - surveyed 210 students to size a campus delivery service
Student Investment Fund - co-managed a $25K equity sleeve tracked in Google Sheets




