KEVIN J. GAFFNEY
BUSINESS ANALYST- | - | Clarendon Hills, Illinois 60514
PROFILE
Results-driven Business Analyst with expertise in business analysis, developing BI solutions, and process optimization. Seeking a role focused on delivering actionable insights to enhance strategic decision-making, improve operational efficiency, and drive long-term profitability
EXPERIENCE
Supply Chain Business Intelligence Analyst January 2023 - January 2025
Suntory Global Spirits, Chicago, IL
Developed automated Python scripts that accessed, transformed, and uploaded inventory and allocation information for 16 individual states which resulted in saving over 100+ manual work hours per month
per location
Spearheaded the transition of all internal- and external-facing reporting from Tableau to Microsoft PowerBI, this enabled leadership to make more effective, data-driven decisions in real time through
live data integration
Assisted in the development and implementation of new inventory management strategies that generated a 10% year-over-year increase in volume of sales and increased in-store capacity per location
Business Analyst > Senior Business Analyst June 2019 - January 2023
Topco Associates LLC, Elk Grove Village, IL
Co-led a team to develop a transformative cost collection process, automating multiple aspects of RfP creation and reducing turnaround time of new side-by-side analyses by over 50%
Managed cost expansion projects for Topco member grocery chains by opening new store and warehouse locations across the U.S., optimizing product mix placement to improve shipping and storage efficiency by 12% per location
Conducted RFPs on highest-volume categories within Center Store area that resulted in cost savings upwards of 15%
Performed in-depth research on new private label brands, creating 1-2 year consumer supply and demand forecasts that optimized inventory allocation and drove an increase in sales performance of upwards of 10%
STUDENT CONSULTANT August 2021 - December 2021
SAP, Chicago, IL
Wrangled large datasets in R to develop quantifiable insight to assess physical events' impact on lead generation and customer journeys in the SAP ecosystem; presented recommendations to leadership that influenced post-pandemic virtual event strategy
SKILLS & TOOLS
DATA ANALYSIS – Python, R, SQL
DATA VISUALIZATION – Tableau, Tableau Prep, Microsoft Power BI
MICROSOFT OFFICE – Excel, PowerPoint, Word, Access
EDUCATION
Master of Science in Business Analytics | University of Notre Dame, Chicago, IL | May 2022
Bachelor of Science in Business Administration | Babson College, Wellesley, MA | May 2019
