Marco Antonio Guerrero Alvarez

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.

Contratar a esta persona

Sobre mí

Experiencia

Chain of departmental stores

Educación

ITESM

UANL

Datamex del Norte

Universidad Tecmilenio

Other Courses

Valoraciones

Personas similares cerca de Monterrey

Alex Maya

Oscar Montemayor Gutierrez

Silvia Compean

Liliana Gonzalez

Adrian Garcia

Jose Angel Serrato Gonzalez

Otras personas similares

Elías González Paul Rivera

Guillermo Hernandez

Benjamin Josue Salazar Salazar

Alvin Pavel Antonio Guzmán

Mónica Fonseca

Omar Pérez Rosales