Joshua Madriz
Next Level Apparel, Demand Planner · Planning Production
In My Own Words
Meticulous and detailed Demand and Sales Analyst, who enjoys developing data information that will ultimately benefit not
only the organization, but most importantly the customer. Adept at data warehouse query views, creating custom spreadsheet and
working closely with all levels of cross functional teams.
The following skills and strengths per the above roles:
? Proficient in Outlook, Advanced MS Excel, MS Word, MS PowerPoint
? Proven strategies, analytics and tactics which capitalize sales and profit growth
? Understanding business from raw materials and manufacturing to retailing of diverse merchandise categories
? Excellent analytical, problem-solving, and decision-making skills; able to distill data into key findings that drive
action
? Knowledgeable of AS400, STS, Web PDM, Envue, Just Enough, SAP, APO, Tableu, NetSuite, SAGE, Power BI,
SQL, Logility, D365 ERP
Demand Planning Skills
- Sales Analysis and Reporting - Monthly Consensus - Establish NPL Guideline - Retail Math -
- Inventory Management - S&OP - Trend Forecasting - Attainment
Work Experience
Next Level Apparel, Demand Planner
Planning Production2020 – Present
• Maintain and release Global Planning Master Schedule • Create Forecast Error % KPI report and release on a weekly schedule (Lag 1,3,6) • Identify Backorder by creating spreadsheet detailed • Proactively track sales vs forecast to ensure any under/over shipments are highlighted and root caused with correct cross functional partners • Proficient in Excel: VLookup, XLookup, Concatenate, SumIf, SumIfs, Large, Subtotal • Lead ERP System Updates on challenges and updates to the system, as well as validating data • Scheduled planning of finished goods out 12 weeks, with first 4 weeks locked-in and the fifth week as issued to schedule. Spot buy & Production. • Planning and considering Factory capacity, in addition to capacity run by weekly/monthly plan
Demand Planner
Sugarfina2020 – 2020
* Forecast and planned for all Wholesale Accounts with support of 3 Sales Directors * Created Seasonal and ongoing new launch demand process: applied pipeline and forward forecast to end of year with an emphasis on the first four months * Maintained great communication with sales directors
Demand Planner
Smith-Cooper International2018 – 2019
* Support the Planning team in building and executing an S&OP function * Reduced demand and supply uncertainty, resulting in $30M profit growth in the last two months * Improve forecast accuracy by identifying and developing remedies for common root causes * Develop and maintain strong, collaborative relationships across the Inventory, Sales, Operations, and Finance * Monitor performance via key metrics, analyze discrepancies, and develop and execute remedial action plans for fill rates, service levels, inventory turns, inventory dollar investment, and excess inventory. Maintain a working dashboard and identify additional key metrics as necessary.
GLAMGLOW Cosmetics, Manager, NA Demand Planning
Estee Lauder Co2016 – 2017
* Oversee demand planning and management processes for new and existing products of $70M (saleable/non-saleable) * Develop demand forecast based on demand patterns and business trends * Calling out notable trend changes to the brand when developing demand forecast to existing products and new launch * Ensure demand plan is reconciled to the latest estimate in injunction with sales and finance leads, to maintain +/- 3% target and increase the 38% growth rate from prior year * Drive the weekly attainment process with sales and operation teams to determine inventory availability driven by forecast as well as to maximize service levels from actual shipped & open orders * Manage 12-month roll-out forecast on unit level for all SKUs across all channels * Develop NPL unit based shipment and sell-thru forecast quantity by channel based on guidelines provided by Global Marketing * Conduct monthly consensus meeting with the NA sales and finance leads to align on forward plan, opportunities and/or challenges we encountered the prior month * Execute pre-season and in-season strategies for category selling, inventory, markdown strategies, and corporate objectives * Compile and publish new launch sell-thru recap and MOB sell-thru * Ensure demand plan reflects current discontinuations, cannibalization and halo rates (preventing excess/shortage inventory) * Provide root cause content as well as action taken when identifying total forecast error from the WFA report on top forecast error * Led a multi-functional team and executed the lean strategy from operation down to logistic to support our biggest accounts, which successfully maintained our plan by coming in flat to the quarter
Urban Decay Cosmetics, Sales Analyst
L'Oreal Co2013 – 2014
Update raw reports from North America and International Accounts - Sephora, Ulta, SiJCP, HOF, Macy's, Shoppers, Beauty.com, Debenhams, Sephora Middle East * Provide individual account reports such as; Weekly Retail Sales, Weekly Tracking, North America Weekly Retail Sales Summary, month end Top 25 Producing Door, and month end World Wide Retail Summary report * Identify - sales growth or decrease (by week, MTD, and YTD), % penetration, and comp TY/LY * Identifying sales trend (performance vs. budget) to set goals by doors - Ulta and Sephora
BCBG Max Azria, Assistant Buyer
BCBGeneration, LOLA, TEX by Max2012 – 2013
* Oversees and manages Accessory business including Footwear, Jewelry, and Handbags in BCBG Final Cut for the following brands: BCBG Max Azria, BCBGeneration, LOLA, TEX by Max * Assists in maintaining Final Cut Apparel inventory from warehouse to store for LOLA and BCBGeneration * Accountable for creating and analyzing weekly sales reports by department and presenting findings to the Senior Buyer * Develop and maintains working relationship with vendors and identify new business opportunities consistent with both short and long term business strategies * Manages the timely placement and maintenance of purchase orders in order to demonstrate financial responsibility success of the business * Collaborate with Visual Team in order to execute product presentation that reflects the overall business goals * Maintain working relationship with Distribution Center to process merchandise systematically for allocation purposes
Assistant Corporate Planning/Clerk
Update Late Adds, Corp2007 – 2011
* Liaison between Buying, Design, and Production to finalize costing * Update Late Adds, Corp OTS Re-order, and Change Management on a weekly basis
Education
Associates
East Los Angeles College2023
Associates
Associates
The Art Institute of Hollywood2009
Associates