Ashley Free

Ashley Free

Sr. Analyst Excel Trainer · Excel by Ashley

Cardiff-by-the-Sea, CA

In My Own Words

I am highly analytical with experience in building and presenting reports around product performance, sales, and inventory for apparel and sports brands. My experience across sales, sales operations, planning, and analytics has given me an understanding of multiple parts of the business which grants me a big picture outlook while maintaining great attention to detail. I pride myself in my leadership, organization, and prioritization. I have transformed each role that I’ve held by streamlining processes to improve efficiency so we can make data informed decisions. I have a passion for learning and mastering BI systems in order to make data more accessible to stakeholders.

Check out my website, excelbyashley.com, to view my free guides and improve your Excel skills!

Work Experience

Excel Guru

Excel by Ashley

2019 – Present

● Written Excel guides with video click through tutorials ● Personal Excel tutoring and troubleshooting ● Consulting for personal and business reporting

Senior Analyst

La Jolla Group

2024 – Present

Analytics & Reporting ● Delivered ad hoc analyses and actionable insights to drive strategic business decisions across multiple objectives. ● Developed a dashboard to analyze e-commerce returns, uncovering common return reasons and high freight costs to inform product design and merchandising strategies. ● Extracted, cleaned, and transformed data from various sources to ensure accuracy in reporting. ● Ensured accuracy of automated reports by validating fields, metrics, and data integrity. ● Developed and managed KPIs across business units to track performance and identify trends.

Forecasting & Sales Planning ● Created long-range forecasts for each brand using ForecastX software, aligning cross-functional teams on future projections. ● Managed the sales planning process by building and maintaining monthly sales forecast templates. ● Analyzed data trends and provided strategic recommendations to improve business performance. ● Supported the planning team with tool development, data management, and analytical services, including open-to-buy analysis, buy plans, markdown schedules, and bulk inventory management.

Training & Collaboration ● Provided training and mentorship to new hires on tools, systems, and processes, ensuring seamless onboarding. ● Trained and supported stakeholders in reporting tools and dashboards to maximize data accessibility and utilization. ● Contributed to and validated team Wiki by documenting data dimensions, metrics, and definitions for terms and acronyms used across the company. ● Contributed as a member of the Culture Committee, fostering a positive and collaborative workplace environment.

Analyst

La Jolla Group

2021 – 2024

Process Improvement & Tools ● Audited the BI report suite for relevance, accuracy, and usage metrics, informing strategic decisions for the next generation BI rollout. ● Developed and maintained a buy file template to rank products, analyze bookings vs. inventory, calculate buy quantities based on trends, and consolidate data into actionable summaries. ● Created an Excel-based template leveraging PowerQuery to allocate production buys by size scales, channel, product type, and VAS requirements based on historical data. ● Designed Line Plan, Demand Plan, and Supply Plan templates adaptable for multiple brands and hierarchy levels.

Inventory Management ● Implemented a flagging process to identify and address obsolete inventory, reducing stagnant bulk and channel holdings to optimize ATS and accelerate sell-through. ● Oversaw drop ship inventory volumes by analyzing sell-through rates and inventory positions, reducing excess and obsolete inventory at season close.

Sales Analyst

REEF, a Rockport Company

2018 – 2021

Analytics & Reporting ● Evolved sell-through reports using SPS Commerce and Action Watch to track collection performance weekly, YTD, and YOY. ● Reported on bookings growth, cancellations, shipments, bulks, and returns by channel, account, rep, and category to support assortment planning, account meetings, and forecasting. ● Organized and merged historical booking data during acquisition and data migration to ensure accurate YOY reporting during the transition.

Process Improvement & Tools ● Increased at once orders by creating custom ATS reports tailored for individual retailers. ● Tracked SMU product sell-in and managed SKU level account blocks and permissions in SAP. Collaboration & Committees ● Served as a member of the Diversity & Inclusion Committee, promoting initiatives to foster an inclusive workplace environment.

Sales Operations Specialist

Callaway Golf

2017 – 2018

● Analyzed trends, inventory, and aging orders in BI, SAP, and Excel. ● Collaborated with Vendor Compliance to analyze current chargebacks and created new processes to be more efficient and profitable; reduced occurrences by 3-10% each week. ● Processed $500K+ in weekly Amazon POs. ● Increased the in-stock rate from 40% up to 92% for DSG drop ship within 6 months. ● Managed bulk orders for accurate forecasting and inventory control.

Sales Operations Specialist/Dealer Sales Support

ElliptiGO

2015 – 2017

● Provided daily sales and sell-through reports by revenue and units. ● Responsible for customer service duties for 200+ dealers. ● Analyzed inventory to trigger more availability and QC checks. ● Set up dashboards and trained new hires on NetSuite and processes.

Key Accounts Representative

R.W. Smith & Co.

2013 – 2015

-Processed orders through email, phone, EDI, website, or fax including new restaurant openings -Mentored new hires in order entry using SX Enterprise ERP -Acted as department lead for rollout of new CRM system: Tour de Force

Education

High School Diploma

Hemet Senior High School

Liberal Studies

San Diego State University

2008 – 2012

Specialty in Mathematics

Skills

Sales MetricsSales AnalysisQuarterly ReportingWritingOnline TutoringBusiness Intelligence (BI)QlikViewBusiness InsightsSAP BusinessObjectsData PresentationAd Hoc ReportingData CleaningBusiness ReportingTeam LeadershipContinuous ImprovementData AnalysisCustomer-focused ServiceBusiness SystemsBusiness ProcessData SystemsPresentationsIRIData AnalyticsCritical ThinkingSales ProcessesReporting & AnalysisRelationship BuildingProblem SolvingIdentifying TrendsKey Performance IndicatorsAnalyticsAnalytical SkillsWritten CommunicationTraining MaterialProject ManagementInterpersonal SkillsBusiness AnalysisAttention to DetailCustomer ServiceMicrosoft OfficeSalesData EntryMicrosoft WordSales OperationsMicrosoft ExcelCommunicationMicrosoft PowerPointMicrosoft OutlookGoogle SheetsGoogle Docs

Activity

See all

Ashley Free liked Chad Mihalick's post · 2024-12-17

Today's date is a fun one - 12+12=24

8 likes

Companies I Follow

See all