William Alvarez

About William Alvarez

William Alvarez is an industrial engineer with over 20 years of experience in demand, supply, inventory, and logistics operations. His skillsets include excellent analytical capacity and management experience in warehousing, logistics, supply chain management, and finance. His team-oriented approach, along with his problem-solving, negotiation, creativity, and decision-making skills, have been invaluable in the positions he’s held throughout his career.

Alvarez works on a contract basis as an Inventory Control Specialist for JDE Peet’s, the world’s leading pure-play coffee and tea company. He manages lot codes and expiration dates between Peet’s 3PL and internal systems and manually fulfills orders as necessary while prioritizing them based on the company’s business needs. Alvarez also performs ADHOC analysis to determine the root cause of fulfillment failure and communicates his findings to internal and external business partners.

Alvarez also invests in properties and renovates them for sale.

Prior to his contract work with Peet’s, Alvarez was the Inventory Rx Manager at retail giant CVS Pharmacy, Inc., in Woonsocket, Rhode Island. During his three-year tenure with CVS, Alvarez had numerous responsibilities. They included building a data and reporting infrastructure from the ground up using Tableau/BI and SQL to provide real-time insights into the product, marketing funnels, and business KPIs. He also built Operations, Inventory, and Planning processes using SQL scripts to minimize manual interference steps within the process and optimize the accuracy of the output.

Additionally, Alvarez created daily, weekly, monthly, and quarterly reports using existing and/or self-created tables within the SQL Oracle database. He participated in the implementation and data migration to the “Snowflake Interface” to extend the query and analytical tools available to the CVS Pharmacy division’s Inventory and Operational team.

Alvarez also held weekly training meetings with the Inventory Planning team to help them improve their SQL writing scripts and simplify the most common operational queries. He also led weekly S&OP Forecast Consensus meetings to align marketing, operations, and supply planning final forecasts, along with risk assessments and mitigation activities.