Senior Replenishment & Forecasting Analyst

Andrea DeRouen

Email: ********@*****.*** Phone: 479-***-****

LinkedIn linkedin.com/in/andrea-derouen-2ab39618

Location: Rogers, AR

Professional Summary

Analytical and results-driven Replenishment, Forecasting & Sales Analyst with over 20 years of experience in category management, demand forecasting, and data analytics within consumer product environments. Recognized for transforming complex data into clear, actionable insights that support sales growth and customer engagement. Proven ability to collaborate across Sales, Marketing, Demand Planning, and Finance teams to enhance forecasting accuracy, optimize inventory, and support strategic decision-making. Skilled in leveraging syndicated tools and advanced analytics to identify trends and deliver impactful business presentations.

Core Competencies

Replenishment using sales systems and store specific orders.

Demand Forecasting & Sales Planning

Category Management & Consumer Trends

Advanced Analytics & Data Visualization

Cross-Functional Team Collaboration

Sales & Inventory Optimization

Syndicated Data Analysis (Nielsen, IRI)

Retail Systems (Retail Link, Scintilla, ProSpace)

Microsoft Excel, PowerPoint & Reporting Tools

Professional Experience

Mattel, Inc.

Forecasting Specialist / Senior Forecasting & Sales Analyst

Dec 2013 – Feb 2025

Delivered category and consumer insights using Retail Link, Scintilla, and syndicated data to support Walmart sales strategies.

Developed daily, weekly, and ad hoc reporting tools, improving business visibility and enabling data-driven decision-making.

Initiated strategic product enhancements, such as repositioning small accessories into standalone items, boosting innovation and sales.

Partnered with Sales and Demand Planning teams to ensure forecast accuracy across multiple categories and maintain optimal inventory levels.

Led initiatives that contributed to a $4MM sales overachievement with major accounts through effective data analysis and actionable recommendations.

Education

Bachelor of Fine Arts

Texas Tech University – Lubbock, TX

Contact this candidate