Joel Borrero Email & Phone Number

New York, New York

Senior Supply Chain AnalystPlace purchase orders as well as track shipments from our factories in Asia to our warehouses and customers across the world.Analyze forecasts for sample as well as order samples based on those forecasts on a monthly basis.Work with our facilities and freight forwarders to expedite shipments and make sure they arrive on time and intact.Manage the inventory at our warehouses in LA and New Jersey.

Greater New York City Area

• Forecasted for all OTC SUN/OHM generic brand drugs by analyzing historical data based on past customer sales and orders as well as seasonality.• Developed a 12 month forecast for all OTC drugs on a monthly basis contingent on said analysis as well as any information from sales with regards to possible promotions or discontinuation.• Created an NDR (Net Demand Requirement) Report for production based on the forecast, available inventory, and open orders in order to determine the… Show more • Forecasted for all OTC SUN/OHM generic brand drugs by analyzing historical data based on past customer sales and orders as well as seasonality.• Developed a 12 month forecast for all OTC drugs on a monthly basis contingent on said analysis as well as any information from sales with regards to possible promotions or discontinuation.• Created an NDR (Net Demand Requirement) Report for production based on the forecast, available inventory, and open orders in order to determine the volumes to be produced each month by production.• Kept track of the current month's shipping commitments from production that were created based on the NDR provided to them and made sure these commits were met and shipped on time.• Maintained and updated a daily supply tracker that illustrated what needed to be shipped, what was physically in transit or in QM (quality management) , what was on back order, and what was officially delivered and cleared out of our DC.• Managed the inventory control of expiring inventory by working with sales to determine what batches of stock were still sellable.• Spearheaded a monthly meeting with sales and production to discuss any tentative commits, products requiring allocation due to short supply, new items, operational issues (if any), pending artworks, transportation delays, etc. Show less

White Plains, New York

• Responsible for coordinating the order fulfillment process for the Heineken USA portfolios.• Interface with distributors, the demand point managers & the commercial team to ensure distributors receive the correct product delivered in an optimal manner as well as minimize Supply Chain costs whenever possible.• Identify any brewery or logistics issues with direct loads & communicate issues within the team to facilitate resolution. • Manage & minimize stock movements between Demand… Show more • Responsible for coordinating the order fulfillment process for the Heineken USA portfolios.• Interface with distributors, the demand point managers & the commercial team to ensure distributors receive the correct product delivered in an optimal manner as well as minimize Supply Chain costs whenever possible.• Identify any brewery or logistics issues with direct loads & communicate issues within the team to facilitate resolution. • Manage & minimize stock movements between Demand Points as well as minimize Supply Chain costs whenever possible.• Work closely with HUSA’s Breweries, customs broker & transportation company to address & resolve any service interruptions & ensure seamless deliveries.• Serve as the primary contact with managed demand point(s) to resolve operational issues (i.e. service issues, error reports, on-time shipments, & delivery changes).• Managed orders for New Products & seasonal promotional packages to ensure product is in and out of the market within the established time frame. Show less

Greater New York City Area

• Entered BOMs (Bill of Material) for new lines of products such as candles, lotions, body wash, etc. into the Blue Cherry system as well as created cost sheets for said BOMs in order to calculate total cost and profit margin.• Created purchase orders as well as received them into the Blue Cherry system once BOLs were received and signed for by our various filling locations. • Ran and costed monthly inventory reports for all of our Nest copackers and fill sites via Excel• Created… Show more • Entered BOMs (Bill of Material) for new lines of products such as candles, lotions, body wash, etc. into the Blue Cherry system as well as created cost sheets for said BOMs in order to calculate total cost and profit margin.• Created purchase orders as well as received them into the Blue Cherry system once BOLs were received and signed for by our various filling locations. • Ran and costed monthly inventory reports for all of our Nest copackers and fill sites via Excel• Created different style codes for new items as well as UPC codes.• Worked with logistics to coordinate routing of various purchase and sales orders in order to meet delivery deadlines for major customers such as TJ Maxx and Marshals. Show less

Greater New York City Area

Supply Planner for Ceramide, Visible Difference and Eight Hour Skin Care brands• Analyze forecasts as well as schedule production and issue purchase orders through JBA software and Manugistics with various external manufacturers and distribution centers.• Firm forecasts for finished goods and components as well as convert suggested worker orders into confirmed work orders with EMs across the country.• Partake in conference calls with EMs to ensure the delivery of bulk and components… Show more Supply Planner for Ceramide, Visible Difference and Eight Hour Skin Care brands• Analyze forecasts as well as schedule production and issue purchase orders through JBA software and Manugistics with various external manufacturers and distribution centers.• Firm forecasts for finished goods and components as well as convert suggested worker orders into confirmed work orders with EMs across the country.• Partake in conference calls with EMs to ensure the delivery of bulk and components as well as production.• Expedite components to meet customer deadlines such as requesting air freight for items with compressed lead times.• Reviewing and approving Change Request Forms (CRF) for forecasts from various international markets due to increases in customer demand by analyzing future forecasts and on hand inventory to determine if requests can be met.• Interact with Marketing on Launch and Promotion activities as needed. Show less

• Analyzed, changed and applied forecast data using various forecasting software such as Futurion, Manugistics and SAP.• Coded various items with IRC, UPC and SKU numbers for both promotional and basic item launches along with descriptions and pricing for brands such as Rimmel Cosmetics, NYC (New York Color), and Sally Hansen using Database management software.• In charge of keeping promotional brand launches recorded and up to date while making any necessary changes in forecasting and… Show more • Analyzed, changed and applied forecast data using various forecasting software such as Futurion, Manugistics and SAP.• Coded various items with IRC, UPC and SKU numbers for both promotional and basic item launches along with descriptions and pricing for brands such as Rimmel Cosmetics, NYC (New York Color), and Sally Hansen using Database management software.• In charge of keeping promotional brand launches recorded and up to date while making any necessary changes in forecasting and making certain the changes align with promotional item logs via Excel.• Communicated with various team members including management in discussing RCA (root cause analysis) for items that were in jeopardy of cutting due to forecasting errors or other unforeseeable circumstances such as volatile customer demand.• Researched and examined any data discrepancies in our various database systems such as inconsistencies in pricing, caught said errors, brought them to management’s attention and made changes accordingly in order to keep our databases with the most current and up to date information. Show less

Brooklyn, Ny

Assist hotel guests, answer phones and provide solutions to any guest requests.Accept, log, and deliver packages for guests whether in house or upon their arrival.Call in wake up calls, set up valet pickups and drop offsMake reservations, check in and check out guests, and process transactions via OPERA Oracle system while providing them with excellent customer service.Inform housekeeping and/or Engineering of any issues affecting the hotel or a guest’s stay.

Englewood Cliffs, Nj

Go To Market Material Planner for Personal Wash Liquids, Face and Body LotionAnalyzed and communicated forecast and inventory targets of weekly production schedules to the material planning team, manufacturers, and raw/packaging suppliersGenerated MRP reports to share with vendors and collaborated with NSM to launch a new process for sharing MRP outputs with key vendorsSaved Unilever approx. $175,000 by proactively consolidating open orders and purchase requisitionsOwned the… Show more Go To Market Material Planner for Personal Wash Liquids, Face and Body LotionAnalyzed and communicated forecast and inventory targets of weekly production schedules to the material planning team, manufacturers, and raw/packaging suppliersGenerated MRP reports to share with vendors and collaborated with NSM to launch a new process for sharing MRP outputs with key vendorsSaved Unilever approx. $175,000 by proactively consolidating open orders and purchase requisitionsOwned the Material Planner Waste Reporting ProcessOrganized and lead monthly meetings with Marketing, GTM Skin Supply Chain Team, and Management Proactively disposed of $1,440,526 of obsolete inventory to decrease inventory costsSaved Unilever $233,365 in potential holding cost Sustained accurate inventory consumption levels and BOMs (Bill of Material) in both InterSpec and SAP databasesDeveloped a Skin-specific Material Planner Day in the Life training manual for the Skin Department Show less

Danbury, Ct

Generated spare part and move orders for medical devices required for service calls or Field Engineer kit replenishmentAnalyzed and consolidated Service Backorder Status reports daily to ensure efficient and prompt delivery Extensive communication with Field Engineers and costumers regarding pricing, spare part orders, and availability of components in stockDeveloped RMAs (return orders) using Oracle database createProcessed credit requests to the Finance Department

Bachelor Of Business Administration (Bba), Business Administration And Management, General

Bachelor Of Business Administration, Supervisory Management

Senior Project: Devised a Professional Business Plan for Small Business Entrepreneurship Related Coursework: Interpersonal Communications.