Casandra Romo Email & Phone Number

● Developed an innovative sales forecast system using MS VBA/Macros which increased efficiency in merchandise planning by 70%● Implemented forecast controls to reduce MAPE by 60% and improved BIAS by 26%● Incorporated excel skills to analyze trends in data to create rolling 52 week demand plan● Established 95% in stock rate on high grossing brands● Influenced AOPs and demand plan creation at a unit level and a revenue level● Initiated a monthly S&OP process with cross functional teams● Developed capacity model for production plans to reduce over-utilization by 5%● Applied SQL knowledge to pull and manipulate demand data for KPI analytics● Implemented SQL queries to segment forecasted demand by region and product category; resulting in a time reduction of 65%

San Francisco Bay Area

● Designed, configured, and deployed software to help assist companies with supply chain needs● Facilitated clients in creating an inventory management team, improving procurement processes and forecasting future needs

Tampa/St. Petersburg, Florida Area

● Controlled On Time Shipment Metrics for two facilities which boosted OTS to 98% weekly ● Implemented an automated PO creation system that had yearly cost savings of $75k ● Generated monthly and yearly sales forecasts at item levels and total facility sales level using sales analytics● Orchestrated the overhaul of supply planning procedures, integrating real-time data analytics to optimize purchasing decisions which reduced stock-outs by 40%.

Greater Memphis Area

● Generated item level forecasts for financial planning and production planning● Owned capacity planning for three plants● Directed monthly S&OP processes for products and drove consensus on the plan across the organization● Ensured that an achievable Master Schedule was in place to support both customer requirements and revenue projections● Built planning tools for production, procurement, and capacity to maximize capacity utilization, minimize spend and reduce changeovers ● Streamlined short order reports using excel macros to help achieve on time shipment and on time delivery metrics (OTS/OTD)● Contributed to the build of the annual operating plan at a financial and production capacity level● Guided sales schedules with analyzed inventory positions in both plants and maintained low excess and obsolete inventory at a finished goods level● Increased the OTS/OTD metrics from 60% to 95% ● Led weekly scorecard meetings with corporate teams to review on time shipments, MAPE/BIAS metrics as well attainment and adherence to production

Greater Memphis Area

● Created a daily production plan and drove the manufacturing process to ensure completion● Maintained the capacity model in to provide the head count and lines needed to fulfill customer demand● Assessed the materials sizing of all the customer orders placed to ensure the proper commitment or identify constrained items● Accountable for measuring and tracking planning metrics: OTD, MPS Performance, MPS Execution, and MPS Alignment

Memphis, Tn

● Implemented Gmail to a 300 user base plant – Conversion from Outlook Servers to Gmail and provided trainings and help desk support before and after implementation● Implemented IT 5S stations across the plant to minimize IT response time to critical line down situations● Executed an MRB system install with 50 end point users