Luis Guerrero

Luis Guerrero Experience • Molex of Mexico I 1997 - 2024 Finance Director I- Finance Business Partner Manager Linkedln www.linkedin.com in lguerrero Zapopan, Jalisco Profile Finance professional with over 25 years of experience in manufacturing operations, managing financial analysis, ownership of the income statement, cost structure and budgets. I develop budgeting strategies implementing your cost structure to minimize variations and achieve the expected results. I have an MBA focused on operations management and a master's degree in data science. My mix of knowledge and experience allows me to perform in-depth analysis of information to implement solutions that improve profit margins. Education Master in Data Science- ITESO MBA Operations Management 2011 - 2013 ITESO & Regis University (Double Degree) Computer Systems Engineer- ITESO Extracurricular information • • Lean VSM Expert - 2008 DAT207x: Analyzing and Visualizing Data with Power Bl 2018 • Lean Six Sigma Yellow Belt - 2008 • Diploma in Finance (ITESO) 2008 • I reorganized the finance team, hiring the members of the structure and having the entire team ready within a year. • I implemented a cost structure to differentiate the results of nine different divisions, managing to identify those with the greatest variation at 100% and managing to reduce the variation in those with the greatest impact by up to 30%. • I led the development of a differentiated budget for each division and the overall budget for the plant, which led to 87% budget compliance, an improvement of 10pp compared to the previous period. • I helped improve the plant's profit margin, going from negative in 2021 to positive 20% in the first months of 2024. • Led the creation of the financial and cost structure of two new projects transferred from other entities, fully implementing it in 6 months. Cost Manager Mexico I- • Managed and maintained the cost structure of the plants in Mexico, handling a portfolio of more than twenty-five thousand products from 10 different divisions, with an accuracy of ~90% with • • • • respect to their budgets. I coordinated the review and analysis of products with low profit margins for their re-pricing or elimination from the portfolio, improving the gross margin of the plants by 10%. Implemented automated reporting using Power Bl and Excel to support 60% growth in the Guadalajara plant operation. Developed reports to analyze the variation in detail, allowing for the implementation of cost reduction activities for approximately US$ 25M. I created the cost structure in SAP for the new plant in Guadalajara, improving the implementation of the MES tool by the company and SAP. Cost Engineer and Logistics and Customs Supervisor I- • Managed the cost structure of the Guadalajara plant, supporting operational growth from US$50M • • • • • in 2001 to US$250M in 2019 Led audits and financial inventory process in SAP for the Guadalajara and Ciudad Juarez plants, reducing the impact on loss adjustments by 60% over a three-year period I implemented automated financial and accounting information reports, reducing the month-end closing time from 5 to 2 days I collaborated in the implementation of SAP at the plant, being the "SAP Superuser" for finance, improving efficiency in financial processes, reducing response time by 50%. I led the teams to obtain the OEA and VAT certification for foreign trade, managing to obtain the certifications for the first time and considerably reducing customs clearance times. Renegotiated and developed new routes and transportation and customs providers, managing to reduce spending by $1M in one year Finance Intern I- • • I prepared financial reports, providing detailed and accurate analysis for strategic decision making, managing to deliver the complete set of reports in 3 months. I programmed in databases, optimizing storage and access to critical information to improve operational efficiency, reducing information access time to minutes instead of hours of manual searching. Advanced English I Native Spanish I Power Bl I SAP R/3 Fl, CO, MM, PP I OneStream I Python, Server I Advanced Excel I Alteryx RI Access, SQL