Projects using Microsoft Excel in IllinoisProjects using Microsoft Excel in IllinoisThis anonymized RevOps mockup shows a renewal forecasting model that combines timing, probability, pipeline value, and cohort renewal performance. The goal is to help teams understand what revenue is committed, what is likely, what is still pipeline, and where retention trends may need attention.
This type of view supports better renewal planning, leadership reporting, and forecast conversations by making upcoming revenue, customer cohorts, and renewal risk easier to review in one place. I drove data-backed decisions across the supply chain, product development, and executive reporting functions. Early on, I conducted comprehensive market and supplier research—building automated pricing models to benchmark vendors and calculate cost variances. When tasked with stepping up to independently manage inventory and vendors, I engineered a suite of automated forecasting tools and dashboards using Excel, Google Sheets, VLOOKUP, and BigCommerce data. These tools visualized real-time production status (W3s), predicted imminent stock-outs using color-coded heatmaps, and tracked high-volume sales. I synthesized this complex operational data into three streamlined, daily dashboards presented directly to the CEO, while also modeling emergency sourcing scenarios to ensure we maintained 100% order fulfillment during production delays. 
