David Cervantes is a Distribution Analyst at SEPHORA. They is proficient in English and Spanish.
-
Distribution AnalystSephoraSan Francisco, Ca, Us -
Distribution PlannerWilliams-Sonoma, Inc. Mar 2024 - Aug 2024San Francisco Bay Area• Led demand and distribution planning activities for Outlet division inclusive of home basics and hardware/partials. • Conducted annual merchandise and inventory planning inclusive of pre-season and in-season forecasting, open-to-buy management (tops down and bottoms up), SKU ranking, purchase order management, and profitability analysis.• Developed tools that streamlined operations and created scalable and repeatable processes, which significantly enhanced efficiency and resulted in cost savings. Utilized Power BI, Tableau and Excel in the creation of these tools. • Led weekly performance review meetings with leadership, highlighting risks, concerns, and opportunities to align Outlet strategies with the forecast. Provided recommendations on end-of-month (EOM) Inventory Plans and Sales Plans.• Analyzed store-specific sales patterns and sales trends to ensure inventory levels were in alignment with end-of-month (EOM) targets or Outlet specific strategies. Influenced replenishment to Outlet stores through these analyses. • Collaborated with cross-functional teams to develop Outlet assortment roll-up plans at both top-down and SKU levels, ensuring optimal inventory balance for core business while aligning with Outlet sales and merchandising strategies.• Executed quarterly corporate hindsight, reviewed Outlet performance, target achievement and forecast accuracy. -
Distribution AnalystWilliams-Sonoma, Inc. May 2018 - Mar 2024San Francisco Bay Area• Analyzed stock-to-sales ratios and adjusted store parameters to optimize product flow, partnering with cross-functional teams to develop distribution strategies aligned with budget, forecasts, visual standards, and payroll targets.• Developed allocation strategies and store/floor targets, leveraging JE and Excel to maximize optimal inventory turns.• Collaborated with planning, pricing and distribution teams to effectively develop effective allocation strategies.• Coordinated with 3PL and DC partners in transportation of made-to-order items, Outlet POs, CSIs, and liability products. • Monitored transport of goods via trailer number, BOL, Manifest, Pick Sheet and adjusted forecast accordingly.• Enhanced existing tools and developed new reporting solutions to eliminate distribution inefficiencies. Key tools included the Master Comp SKU Search, Allocation Detail Report, In-Stock %, Single SKU Cost Analysis, and New-Store SMIR, driving more effective inventory and cost management. Utilized Power BI, Excel and created macros to streamline updates. • Managed and developed monthly Outlet store load plans, ensuring alignment with receipt needs and targets.• Oversaw DC transfers of single component items to minimize shrink and effectively meet store demand requirements.• Conducted ad hoc analyses on store performance, inventory ownership, sell-down forecasts, % committed. -
Allocation AnalystCost Plus World Market Nov 2017 - Apr 2018San Francisco Bay Area• Managed store parameters, Min/Max, ranking/tiering and distribution rules for both Personal Care, Bed and Bath.• Collaborated with planning and merchant team to gain alignment of allocation strategies with forecasted needs.• Reviewed inventory metrics, including % committed, in-stock %, lateness and % to target, and reported to leadership.• Built and maintained allocation strategies to maximize sell-through of seasonal and core items, driving revenue growth.• Analyzed SKU and program efficiency to ensure inventory turn goals are met, applying tiered assortment strategies. -
Supply Chain Fulfilment AnalystSalesforce Oct 2016 - Nov 2017San Francisco Bay Area• Supported and managed Infra Ops project buildouts, overseeing negotiation, quoting, purchase requisitions, approvals, PO creation, and invoicing, including RFI, RFQ, RFP, and SOW processes. Reconciled inventory and resolved discrepancies.• Monitored transportation of POs for Infra Ops in service center buildouts, escalating issues based on project priority.• Negotiated with global vendors on cost, minimum order quantities (MOQ), capacity, and prioritization.• Led projects to measure, improve, and report on effectiveness of new and existing procurement processes. -
Inventory Planning AnalystGap Inc./ Banana Republic Jun 2016 - Sep 2016San Francisco, Ca• Supported in-season management of department and class level plans including ongoing assessments and updates.• Assisted in the development of department and class allocation strategies – early release, pre-allocation and final.• Managed replenishment strategies in pre-packs, size and inventory balancing for Women’s Wovens and Suits/Separates. • Developed reporting: stock status, % complete, in-stock %, lateness, size profiles, distro strategy and pricing strategy. -
Import Product AnalystLiving Direct Mar 2015 - May 2016Austin, Texas Area• Performed demand planning duties per assigned categories and evaluated portfolio / promotion performance. • Managed and created spare parts for all products in category. This included SKU / Kit creation and demand planning. • Managed and maintained all customs documentation – BOLs, Certifications, Transfers, Invoicing, Performa Invoice, etc. • Assisted in new product development by through collateral, certifications, forecasting, vendor management and setup. -
Supply Chain AnalystBig Red, Inc. Jul 2013 - Feb 2015Austin, Texas Area• Forecasted production quantities through regression and forecasting models. Generated purchase orders per forecast.• Maintained both inbound and outbound FG inventory in both USA and CAN. Monitored all raw materials inventory.• Generated inventory documentation to support demand per regional sales and distributor locations. • Developed new forecasting models, trackers, freight analysis and managed bill of materials of all products.• Received purchase orders and inventory in Sage and produced finished goods per warehouse for consumption.
David Cervantes Education Details
-
Supply Chain Management
Frequently Asked Questions about David Cervantes
What company does David Cervantes work for?
David Cervantes works for Sephora
What is David Cervantes's role at the current company?
David Cervantes's current role is Distribution Analyst.
What schools did David Cervantes attend?
David Cervantes attended The University Of Texas At Austin, The University Of Texas At Austin.
Who are David Cervantes's colleagues?
David Cervantes's colleagues are Aleksandra Isakovic, Paige Eddings, Henry Hernandez, Michelle Jay Feliciano, Fabienne Charpentier, Jiselle Martinez, Helen Hunt.
Not the David Cervantes you were looking for?
-
David Cervantes
Colorado Springs, Co2elevationscu.com, wellsfargo.com -
David Cervantes
Tulsa, Ok4vpxsports.com, mac.com, go-dev.com, aimconsulting.com -
-
David Cervantes
San Francisco, Ca2yahoo.com, svb.com3 +141567XXXXX
-
1treasury.gov
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial