Marco Antonio Guerrero Alvarez

Contador publico con mas de 26 años de experiencia en funciones financieras con dominio del aspecto estratégico y funcional del área de finanzas, conocimientos de costos estándar, control de costos, gestión de manufactura, control financiero de proyectos de inversión, presupuestos, proyecciones y modelaciones financieras, amplio dominio de herramientas de TI para optimizar las funciones financieras.

Grupo Daltile, Monterrey, NL                                                                                                   

Financial Planning and Analysis Manager                                    Mar 2023 – Present

Daltile leader in ceramic tile part of Mohawk Industries.

• P&L and Balance sheet forecast and follow up of performance results.
• Control of Freight, Staff, Marketing and SG&A spending 
• Financial planning for maquila segment (providing projections to USA and Europe)
• Fixed assets management under NIF, IFRS and USGAAP rules for all Mexico Divisions (includes Tile, Carpets, Vinil Luxury Tile and Refractories.)
• Oversee control of CAPEX spend (All Mexico Divisions), follow up and cash flow projections.
• Oversee IT financial reporting in SQL, Domo, Excel and Power BI
• To attend multiple corporate financial requests from Dallas, Atlanta and Europe which include financial performance analysis, reports and projections.
• Oversee external reporting for TCNA and INEGI.
• Coordinate Strat Planning and Budget processes with internal stakeholders and USA Finance team.
• To provide multiple analysis of the performance of the business against forecast, last year, quarter over quarter and presenting to leadership team.
• To work with Financial planning teams of Italy, USA and Brazil team providing information for the Global Finance report.

Accomplishments

• Standardization of Financial reports reducing time of generation, increasing accuracy and traceability.
• Implementation for Global Financial reports ensuring common understanding of financial concepts with teams from Europe, Brazil and USA.
• Successful integration of Vitromex in financial information and Oracle’s Fixed assets, Inventory and Costing modules where I was Key user. 
• Financial processes improvements for CAPEX, Fixed Assets, intercompany operations, headcount analysis and recurrent expenses.

Vitromex, San Luis Potosí, SLP                                                                                              

Financial Planning and Controlling Manager                             Feb 2017 – Mar 2023

Vitromex is the ceramic floor and Wall coverings division of Grupo Industrial Saltillo

• Analyze the financial results of the company, providing an executive summary along with a meaningful analysis of the deviations against last month, last year and budget.
• Prepare financial information for Monthly Business Review (MBR), P&L, Production Cost, Fixed expenses, Cash Flow and Financial Figures.
• Analysis of financial information for improvement in EBITDA, Working Capital and Cashflow. 
• Responsible for coordinating Financial Budget and Forecast processes.
• Prepare sensitive analysis for short- and long-term financial information.  
• Responsible for Financial Project Management (CAPEX). 
• Responsible for Financial Plant Controlling of 4 plants; including Control of Fixed Assets, Inventory Analysis, update Standard Costs, Fixed Expenses Control, Headcount, Bill of materials and analysis of the manufacturing processes to improve costs. 
• Prepare, analyze, and present the annual budget of the company to the Directive Committee of the business, which require to coordinate the process with the different areas of the business and corporative departments (Operations, Projects, Commercial, Marketing, Talent and Culture and Supply Chain)
• Prepare, analyze, and present the forecast of the business’s financial result, EBITDA, Working Capital and Cash Flow: using a 12 months and 12 weeks rolling forecast method.
• Responsible for Costs and Fixed Assets monthly close process.
• Coordinate with the US financial team to prepare and consolidate information of Financial Results, Budget, Strategic Planning process, rolling forecast and EBITDA.
• Prepare projections for cash flow, working capital, CAPEX and EBITDA on a weekly basis.
• Collaborate with lawyers to prepare analysis and paperwork for antidumping measures. 
• Support Revenue Management, Demand Planning, Marketing and Supply Chain and Operations areas with analysis and requirements of information to improve the performance of the company.
• Finance projections for the sale of the business to Daltile.

Accomplishments

• Accuracy of 98% in the Purchase price agreement projection of Vitromex sale to Daltile with no price adjustment.
• Design and implementation of a comprehensive Forecast, Budgeting and Strategic Plan model.
• Implementation of a manufacturing cost management model.
• Implementation of CAPEX management process, machinery control and traceability to source document.
• Implementation of automated processes for generating financial reports at the end of the month P&L, Balance Sheet, Cash Flow, Financial Indicators, Fixed Expenses and Production Cost.
• Implementation of BI Dashboards for margin monitoring and control of expenses and production costs.

Cost Controlling Manager                                                               May 2013 – Jan 2017

• Oversee financial information of 5 plants in Mexico and collaborate with the financial team in USA.
• Review monthly P&Ls and provide meaningful variance explanations of actual results vs. budget, forecast, last year and prior month to the senior management.
• Coordinate the presentation of operating results with directive committee.
• Review and approve transactions to ensure entries are appropriate and in accordance with NIF and IFRS and support monthly financial close.
• Coordinate with Internal Control department to ensure proper documentation of processes is maintained, develop internal controls, and recommend areas for improvement.
• Attend internal and external auditors.
• Establish and maintain the standard cost system.
• Support Commercial team providing information and assessment about product costs, new products, quotations, prices, and margin analysis.
• Coordinate with the Continuous improvement team following up the results of the projects of savings.
• Support Supply chain team providing assessment about levels of inventory, production and procurement. 
• Assist the Financial Planning team in the preparation of the annual budgeting, forecast and planning process, leading the categories of Cost of Sales, Cost of production and S&A expenses.
• Assist tax department and international trade team with different analysis and requirements of information.
• Coordinate Manufacturing and Laboratory teams to maintain Bills of Materials and cost of resources updated. 
• Oversee and maintain budgetary control.
• Responsible for ensuring that the valued inventories are accurate and properly valued, estimate reserves of obsolescence of inventory.
• To prepare the reconciliation Cost of Goods Sold and Cost for taxes.

Accomplishments

• Implementation of automated processes for generating financial reports at the end of the month P&L, Balance Sheet, Cash Flow, Financial Indicators, Fixed Expenses and Production Cost
• Implementation of BI Dashboards for margin monitoring and control of expenses and production costs
• Optimization of manufacturing cost closing time and financial closing with automation in the generation of closing and management reports

Organización Soriana, Monterrey, NL                                                             1999 - 2013

Retailer Company, Soriana is the second chain of supermarket in México 

Project Manager                                                                                 Dec 2010 - May 2013

• Organize meetings with directives, team leaders and staff employees to research and define new processes, prepare work plans, present advances and track progress against timelines.
• Analyze and document the financial processes; identify and evaluate the differences between the current processes against processes in the SAP system, establishing the best practices of the industry
• Implement the processes of financial planning and finance in SAP
• Document and make business specifications for legacy systems and SAP 
• Follow up of tests for SAP and legacy systems
• Implement the process of budgetary control.
• Coordinate with financial and commercial teams to update the definition of costing and the process of allocating general expenses.
• Present initiatives and the new processes to senior management and sponsors
• Key user for finance area for the Transformation Project of Soriana and SAP implementation
• Training financial staff to operate with the new processes and SAP system.
• Leader in the processes of cleaning up the master date of finance
• Member of the team assigned to evaluate ERP systems vendors.

Accomplishments

• Successful implementation of the Finance module of the SAP system
• Analysis and re-design of Finance processes (Soriana Transformation Project)
• Definition of the change in the Retail cost management system (update to the Net Cost model)

Cost Accounting Manager                                                               Ago 2007 - Nov 2010

• Review monthly P&Ls for the logistic division and provide meaningful variance explanations of actual results vs. budget and last year to the senior management.
• Coordinate with International Trade and Commercial team to define the integrated cost of imports.
• Review and analyze levels, accuracy, inventory valuation, purchase costs and scraps of products.
• Review and analyze commercial conditions with suppliers
• Assist financial close for Logistic Division.
• Support Logistic Division for updating yields of inventory scrap and following up the benefits of new projects.
• Attend internal and external auditors
• Assist tax department and international trade team with different analysis and requirements of information.
• Oversee commercial and logistic procedures, assure its application and recommend areas for improvements.
• To prepare reconciliation between Accounting Cost of Sales and Cost of Sales for taxes.
• Coordinate monthly result presentations with the directive committee of the logistic division

Cost Accounting Sub-manager                                                      Feb 1999 - Aug 2007

• Review and analyze accuracy, valuation and levels of inventory of CEDIS
•  Coordinate the Logistic Team in scrap analysis and updating the yields of inventory scrap.
• Integrate and review import expenses.
• Assist commercial team to analyze discounts and purchasing conditions with suppliers.
• Analyze gross margin profit for products distributed by CEDIS.
• Review, analyze and apply rebates and commercial agreements with suppliers
• Attend internal Audit requests
• Attend suppliers’ claims and requests for details of agreements

FAMSA, Monterrey, NL                                                                      Ago 1996 – Oct 1998

Sub-Accountant

Chain of departmental stores

• Review financial transactions, fixed assets control and calculate taxes
• Review monthly P&Ls and provide meaningful variance explanations of actual results
• Oversee financial close process
• Prepare financial statements
• Review reconciliations between filial companies.
• Analyze and integrate balance accounts.

ITESM

Monterrey, Nuevo León

MBA, 2010

UANL

Monterrey, Nuevo León                                                                                                               

Bachelor’s degree in accounting (CPA), 1997

Datamex del Norte

Monterrey, Nuevo León

Analyst Programmer Technician, 1995

Universidad Tecmilenio

Industrial and Systems Engineer, 2024 (Certificate in process)

Other Courses

Leader of Leaders, ITESM, 2022

IMMEX Program Administrator Certificate, GBU, 2021

Microsoft Power BI, Compueducación, 2020 

Development of directive skills (Academia de Liderazgo IPADE) 2018

Microsoft Certified Professional (SQL BI) 2017

Labor Taxes Legislation, UASLP 2015

Continuous improvement, ITESM, 2010

Costs Systems, 2004