Gabriel Benavides Canales Email & Phone Number

Monterrey, N.L., Mx

Austin, Texas, Us

Designed and optimized datasets using SQL and DOMO Analyzer, leveraging functions like GROUP BY, JOINS, and FILTERS to build dynamic dashboards for real-time cost tracking and forecasting.Implemented cost control processes through Excel and DOMO, conducting weekly event assessments to identify key cost drivers and enhance team communication, reducing overspending risks with proactive operational adjustments.Resolved discrepancies in Salesforce Rolling Cost Forecasting formulas, resulting in a Forecasting to Actual Cost variance within +/- 5% through detailed data analysis and testing.Developed the 2024 budget for the Operations Department, aligning data-driven strategies with long-term company goals.Managed the CAPEX and OPEX budget, collaborating with the VP of Operations to ensure expenditures align with departmental needs and strategic objectives.Streamlined the accrual process by automating forecasting cost adjustments, improving efficiency across the operations department.

Austin, Texas, Us

Participated and led the process of analysis and negotiation with an external 3PL to work with our Logistics Department and saved the company more than 20% on Shipping Cost.Created a simulation model with Excel Solver to validate our warehouse location based on location of events, mileage, and capacity and freight constraints.By identifying bottlenecks and mapping workflows using Lucid, and then doing Data Analysis in DOMO, Salesforce, and Excel, proposed and project managed more than 10 projects that involved several stakeholders across different departments in the company that led to a more optimized Logistics Department in terms of processes, resources, and tools.Collaborated with an external consultant to streamline inventory management by developing and implementing SKU codes for 300+ product lines; reduced inventory tracking errors and liberated 10+ hours of labor per week.By communicating with our 3PL, extracted, cleaned, and analyzed data using Excel to find our shipping cost increase drivers, to then present to the team concrete solutions and action items that generated a 50% decrease in shipping cost quarter over quarter.Based on our new 3PL contract, commodity prices, and business operations, redesigned and modelled a new shipping cost forecast model for every event that resulted in a 7% less deviation against actual costs from the old model.

Berwick, Pa, Us

Conducted an analysis on different KPIs, like frequency of finished goods, bag size, fill rate, costs, among others, for the production plants of Perry, Florida and Berwick, Pennsylvania. Had the chance to visit the plant in Perry to deeply understand the production of potato chips.Provided an analysis, recommendation, and rationale behind what items of the existing portfolio should be produced at Berwick, Perry, and Mississauga, based on customers geographical demand and freight cost. The pandemic affected a lot the supply chain of the snack companies. An increase in the price of commodities, transportation, and raw material was affecting every company in the industry. During my time there, we explored, analyzed options, and contacted different suppliers to source from due to a global shortage in the areas previously mentioned.

Worked at General Products along a fellow classmate the summer of 2020. We were located in the Bolsas Delta fabric in Monterrey, where General Products provides ink to Bolsas Delta for them to manufacture packaging for the most successful companies in America.It was excited to watch packaging production for companies like Chipotle and Panda Express.We statistically analyze the whole process, how work orders arrived to our office, intonation and measuring the ink, ink delivery to machinery, the manufacturing of material, the printing, and then the material package ready to be shipped. A lot of time was lost between transportation and work orders, so after weeks of analysis, we presented to the managers a communication system for time efficacy and optimization.Also, we found out some critical parts of the machinery were damaged and needed to be change.We ended up reducing machine downtime by 14% and also reduced unproductive time per month from 2-3 days to 12 hours.

Monterrey, Nuevo León, Mx

Worked in the Monterrey office the summer of 2019 with the development manager of emerging beverages.We worked in a variety of projects and created marketing material for the products that where going to be launched that summer. It was nice to see the signs we created on the streets weeks later!Used database SAP and Excel to track inventory along all distribution centers.Frequently communicated with the logistics team and the distribution center managers to ensure all product was delivered correctly.

Bachelor Of Science In Industrial Management, Concentrations In Supply Chain And Operations, And In Data Analytics

High School Diploma