Josh Carrillo
Sr. Manager Customer Service · Spectrum Brands HHI
Huntington Beach, CAWork Experience
Sr. Manager Customer Service
Spectrum Brands HHI2022 – Present
• Oversee 4 Supervisors and 32 customer service representatives (inclusive of an offshore department based out of India) and 1 CS analyst- Providing leadership in all aspects of the end-to-end customer/sales experience • Department Order Management of $1.4B annually (128K Manual orders processed / 105K Annual EDI orders processed / 53K calls taken annually) in QAD (MFG PRO) • Delivering on all CS metrics: CS WIP below $4.0M / Backlog maintained at $34M /Past Dues Orders / Past Dues = 98%, Order entry turnaround time 24 hours) • Provide Customer Service Sr. Director with reporting and analytics for all customer related data (use of Excel-vlookups, sum if statements, if/then statements, pivot tables, Powerpoint presentation development) • Publish weekly Bookings Score carding and ad hoc business reporting for CS functional area- data extracts from BI tool. • Weekly executive service report outs • Maintain a positive work culture and ensure safe working environment for all team members • Investment in the team- Training, career development, on time performance management process, One Team Events
Manager Customer Service
Spectrum Brands HHI2018 – 2022
* Project led an outsourcing initiative of CS activity to Infosys, Pune India during Covid shutdowns. Project implemented 100% remotely, via Microsoft Teams meetings * Business leader for ERP enhancements (QAD system) in Customer service * Assist with project management in Customer Service as point person for Business Initiative Improvements * Prioritize and assist IT with implementation of customer EDI onboarding (850,810,855) * Assist Customer Service Director with reporting and analytics for all customer related data
Project Manager
Spectrum Brands HHI2014 – 2018
* Successfully led an ERP transition for the order to cash function from QAD to SAP ECC * Project phases included Project Preparation, Business Blueprint (As Is / To Be) and process maps, Realization, Final Preparation, Go Live, Post Production Support * Documentation Development: Business Blueprint, Process Mapping, Creation of Training Documents, Business Process Procedures documents * Led ERP implementation of SAP for Canada business * Led ERP implementation of SAP for Mexico Business (Mexicali/Nogales) * Led ERP implementations of SAP for Xiamen China portions of our APAC businesses * Led ERP implementation of SAP for Denison TX production plant
Manager Customer Service/Demand Planning
Spectrum Brands HHI2012 – 2014
* Customer Service and Demand Planning support FY sales projection of $40M for National Accounts category * Residential Access Security (RAS) customer service management for FY sales $20M * Manage team of 4 resources for Kwikset National Accounts Customer Service * Manage 1 demand planner, forecasting for Kwikset National Accounts
Customer Service Supervisor
Stanley Black & Decker2011 – 2012
* Supervise 12 customer service representatives supporting all aspects of the end-to-end customer/sales experience. Manage customer service activities for most brands in the Stanley Black and Decker network: Kwikset, Weiser, K2, Stanley, National Hardware * Manage customer and sales relationships for National Accounts (ACE, True Value, Do-it-Best, HD Supply), Retail accounts (Home Depot, Lowes, Menards, Amazon) and Other Retail accounts as part of organizational Net Sales plan of $1B FY. * Led the Retail and National accounts team, targeting customer accounts order fill service levels on average between 95% to 98% * Service Levels tracked through scorecards developed to measure customer specific performance. * Monthly Scorecard generation and report out on top Customers for Stanley National brands. * Service Levels, Lead Times (warehouse/drop ship), key highlights for the month. * Through effective scheduling, providing product and problem/resolution training, led the Stanley National CS team to experience customer phone call service levels of 98%, less than 15 second wait times, averaging 3 dropped calls. * Key player involved in transitioning all aspects of the customer service functions from IL office to CA office. Significant contributor: systems testing, product training, process streamlining, scheduling of staffing and resources from pre-transition to current state CS management. * Collaboration with Supply Chain Team to minimize disruption to customer order delivery expectations. * MDI participation on top misses, customer concerns, upcoming customer events
Demand Planning Analyst
Stanley Black & Decker2008 – 2011
* Billing Estimate- Beginning of month collaboration with Sales/Marketing to generate top line Sales estimates using historical data, Promotional events, new product introductions, Sales targets, Organizational Goals (FAB), Market Trends * Demand Planning: Demand plan generation and business support totaling annual sales +$71M (FY): Weiser Lock, K2 Commercial Hardware, Safe Lock, Kwikset * Monthly Development Using JDA forecasting software at sku level using historical data, known customer demands, future promotions, seasonality trends, new product launches. * Monthly reconciliation of forecast variations due to history spikes, one-time buy's, un-forecasted market changes, obsolescence/discontinuance * Monthly forecast locked at item level, passed off to supply planners. * Forecast accuracy and accountability tracking. * Weekly Forecast vs. Actuals tracking to ensure any variations are addressed. * Open Order reviews, Past Due/Backlog order management * SOIP-Monthly Presentation/Verbal report out to executive leadership team in large group setting: monthly billing performance, service metrics, project updates, accuracy * Ad-Hoc presentations in cross functional meetings with Supply Planning, Sourcing, Manufacturing, Engineering, Customer Service and Sales as needed. * Monthly Scorecard /Collaboration with Top Customers- Fill Rate / LT review, forecast vs. Estimate performance, Inventory Turns, Product mix changes, Quality updates. * Use of internal information system for customer sales order review, report generation, forecast loads, item level inventory balances, Planning data set up (items, site, SS, PO sites) * Extensive use of Microsoft Excel- Familiarity of common functions: Vlookup, Pivot Tables
Supply Chain Rotational Analyst
Stanley Black & Decker2007 – 2008
* Gained insight into Black and Decker's: Global supply Chain Strategy, Culture, Various business functions, Team Building initiatives. * Successful completion of three rotational assignments during first year of employment * Supply Planning, Manufacturing and Materials Management, Strategic Sourcing * Upon Completion of rotations, I was approached by 5 departments showing interest in having me join their team in a permanent role. * Nogales Direct Ship- Developed/Implemented process to ship finished goods direct from manufacturing (Mexico) to Distribution Center (Canada), elimination of unnecessary steps to reduce lead times on customer orders. * Supply Planning- Weekly Replenishment ordering. Management of Inventory levels to desired targets, analyze spikes in demand (collaborate with Demand Planning), E&O inventory reduction, new product introduction management (item set up, inventory build plans) * Component Forecasting- Spent three months in Mexico developing/Implementing a component forecasting model to help give visibility to a MTO type of Production site. MRP training, Forecasting Software familiarity. * Strategic Sourcing- Management of the Packaging Commodity by way of price analysis, Supplier Negotiations, Standard Cost roll-up, Supplier Agreement and Contract set ups, Purchase Order development and Maintenance.
Warehouse Lead
The Home Depot Supply2003 – 2007
* Point person for Distribution Center responsibilities taking place in a high volume, pick, pack and ship type of environment. * Supervision of daily operations to ensure all processes were complete and all standards were met (inbound and outbound functions) * Customer Service- Will Call order fulfillment, Reconciled customer returns, Processed Credits and RTV's * Cycle counts- Managed daily cycle counting responsibilities to ensure inventory imbalances were resolved. * Training of new hires and periodic evaluations for new/existing associates
Education
College of Liberal Arts and Sciences, Arizona State University
B.S.
W.P. Carey School of Business, Arizona State UniversityB.S.