Roberto Serna Lizárraga
Av Centenario 2720 C43, Bosques
de Tarango, A. Obregón 01580.
Single
Email: ********@*******.***
Mobile: +521**********
Part.Number: +525*-********
Available to Travel. Open to
Relocation.
Professional Studies:
Universidad Tecnológica de
México. (UNITEC).
Bachelor s in Public Accounting.
June 2002 - December 2005.
Escuela Bancaria y Comercial
June 2012 - November 2012
Diploma in IFRS & Corporate
Finance.
Language:
English Advanced. Fluent speaker
and writer.
Other Knowledges:
MOffice: Excel, Word, Power Point
Advanced, Outlook, ERP: SAP
FI/CO Modules, (Key user), AS-
400, JD Edwards, BI Oracle-Smart
View, AD-Hoc Analysis, BRACS.
Khalix (MFG Prod), Movex,
Hyperion, TM1 (Prospective &
Contributor), PowerBI, Qlik View.
Certificated by American Business
School Paris in Good Finance
Practices.
Others:
2008: Financial Advice in building
Society with American Railway Co.
2014: Travel to HQ of Rich
Products, Bufalo,NY to impart
training in BI Financial Reporting
Studio. (Key User).
Job Experience:
Amanco WAVIN México. September 2020 - April 2021.
Financial Planning Manager. Personnel in Charge: 1
• Annual Budget Preparation.
• Preparation of Monthly and Quarterly Forecast by UN.
• Elaboration of Last Estimated and Pre - Flash Updated.
• Analysis of impacts on prices and costs by business line, evaluation of risks and opportunities
• Responsible for the analysis of manufacturing costs and variations.
• Monthly closing: Preparation of P&L, Balance Sheet, Cash Flow and Working Capital.
• Profitability analysis by business lines, GP & EBITDA.
• Analysis of variations and creation of strategic plans to close GAP's: Sales, GP and EBITDA.
• Financial KPI's Dashboard: DSO, DIO, DPO.
• Responsible for financial information and analysis of CAPEX and return on investment.
• Real cost analysis vs Std, COG's, PPV, Selling, G & A.
• Gross Profit & EBITDA Bridges
• Executive presentations for Direction: JMR.
• Preparation of Closing Templates and Monthly Close Reporting for Regional and Global Corporate.
JBS- Meatme. April 2020 - September 2020.
FP&A & Operations Leader - Business Controller
Personnel in Charge: 2
• Annual Budget Preparation, Monthly Forecast by Stores. Sales, CM, Expenses, EBITDA.
• Responsible for the P&L by Store and report to the corporate to USA & Brazil.
• Responsible for the analysis of commercial costs.
• Pre-Flash and monthly closing
• Profitability analysis of regular products, product launches, promotional.
• Loss Control CEDIS and Operations.
• Inventory and Expiry Control.
• GP Analysis, by Store by Product by Category.
• Analysis of variations and creation of strategic plans to close GAPs: Sales, GP and EBITDA.
• Dashboard KPI s Financial and Operational
• Monitor the calculation of the variable remuneration of sales leaders and Category representatives.
• Responsible for statistical information from the commercial area to the manager.
• Analysis of real costs vs ABC, COG s, Selling, G&A.
• Gross Profit, EBITDA Bridges
• Executive presentations for Management.
• Finance Governance of S&OP Demand Planning, New
Products Launch, Pricing, monitoring of price
implementation.
ECOLAB México.- November 2017 - March 2020.
F&B Finance Business Partner Personnel in Charge: 1
• Annual Budgeting and Monthly Forecast.
• Responsible for P & L of the division and corporate reporting in St. Paul and Miami.
• Pre-Flash and monthly closing, review of provisions.
• Analysis of CM & Gross Profit, by Customer, by Program by Product.
• Analysis of variations and creation of strategic plans to close GAP s: Sales, CM, Gross Profit and OI Threshold.
• Sales, Gross Profit & OI Bridges.
• Monitor ratios: DSO, Inv. Turns and WC.
• Analysis of real costs vs Std, COG's, PPV, Selling, G&A.
• Gross Profit, OI Bridges
• Executive Presentations for Management (AVP F & B) (MBR, QBR, SBR, TH, OI Threshold).
• Finance Governance of S&OP, Div. Restatements,R&O, Pricing Report to Miramar and follow-up on PI.
• Balance SC's, Analysis for new projects and investments. (PCAF's) National and regional projects, asset optimization, to improve profitability and productivity BOSTIK US.- April 2017 - September 2017
Jr Financial Planning and Cost Manager Mexico - Personnel in charge: 1 (Determined time temporary - due to acquisition by other Company - Merged)
• Preparation of Report and monitoring of sales of the Mercosur region.
• Analysis of P&L's by BU, by customer, by product vs Budget, FCST and LY.
• Report and executive presentation of the results by month, Mexico and Mercosur to Local and Reg. HQ.
• Monthly RCG and explains variations to EUA & France.
• Contribution Margin, Gross Profit and OI analysis.
• Responsible to Std Cost, revaluation: raw materials, packaging, labor and direct expenses.
• Financial Reports of Inventories KPI s, std cost variations and transfer prices. (Inventory Reserve, Inv.Turnover,Inventory Valuation, PPV y MUV)
• Investment Projects in México reviewed w EUA & France.
• Monthly Forecast, S&OP & Budget.
PNT Quimibond México.- October 2016 - February 2017 External Financial Controller. (Finance BP & Business Impulse - Professional Fee Squeme - determined time temporary)
• Diagnose and improve through financial, commercial and production strategies, to increase profitability and business momentum in the market.
• Preparation of monthly sales report vs. previous year vs Budget by BU.
• Elaboration & Analysis of P&L's by BU, customers and products. KPI'S development of the organization.
• Audit and develop the processes of the organization.
• Financial and Commercial Coaching to the Presidency, General Management, and support areas to help in making decisions to improve profitability. TUPPERWARE Brands Mexico. May 2016 - October 2016
Chief of Financial Planning & Analysis - Personnel in charge: 2
(Global restructuring)
• Development Weekly Report & KPI s in cooperation with BI Department.
• Consolidate & coordinate monthly closing of Mexico, CAM y Bolivia reporting to WHQ in Orlando.
• Elaborate of Flash, Forecast and Budget.
• Review and monitoring P&L, Balance Sheet, CAPEX and OPEX by entity and subsidiaries.
• Responsible to controlling the promotional expenses in TWBM.
• Responsible to elaborate monthly MPR of Mexico, CAM y Bolivia for a conference with WHQ.
• Development information by Management Effective Taxes by subsidiaries. CHEP LatAm (Equipment Pooling Systems).- May 2015 - May 2016 SR Financial Planning Analyst LatAm - Personnel in Charge: 1 - (Global restructuring)
• Development Weekly Report & Weekly Volume Regional Report. Consolidate, coordinate monthly and annual closing of the Latin America region (Argentina, Brazil, Chile, Central America, Mexico, Peru and Colombia) reporting to Global Pallets in Atlanta - Orlando and WHQ in Australia (Brambles). Reporting to Finance Manager to Regional CFO and functionally to LatAm CEO.
• Development of Pre Flash, Forecast, Budget and Regional 5YP by SL.
• Review and monitor P & L, Balance and CAPEX (Pallets) by country and region.
• Casual Development Report Audit Financial Stewardship Book. Regional Report Control IS IT reporting to International Finance (Atlanta, GE).
• Responsible for project Taxonomy Overheads by Country, by Cost Center Region headquarter in UK
(Webridge, Brambles).
• Financial Controller and responsible in start-up of new subsidiaries in Colombia and Peru. Productos Rich, S.A. DE C.V. (Rich Products)
September 2009 - May 2015
Financial Planning Analyst
• Report of monthly sales, weekly vs. previous year, AOP by BU's (ISB, Food Service, RB, Exports, SM) financial support to Sales, Marketing, R & D, Trade Marketing, Operations and Plant).
• Elaboration and analysis of P & L by BU, client and products, SG & A, Manufacturing and Profitability, Monthly Forecasting by Oracle BI (Smart View).
• Implementation of BI Oracle. (HPM)
• Preparation of AOP, S & OP and LRP. NPV's for Launch of NP and Supply Chain Optimization.
• Finance Governance S & OP, New Product Launches (FBP).
• Investment projects, VPN, ROI and TIR and profitability analysis as well as generation of financial information necessary for effective decision making for the company.
• Responsible for Business Review, Presentations for Management, IR Meeting, MBR Meeting, Supply Meeting, DRC Meeting, reporting to VP of Finance in Mexico and WHQ Búfalo, NY.
• Consolidation of the LatAm Region Information.
Jafra Cosmetics International (México)
June 2009 - September 2009 (Covering maternity leave). Financial Planning Analyst (Financial Planning)
MARKETING 911 CRM Company
Marketing Services
October 2008 - April 2009
Accounting Coordinator and Administrator Sr
ALSTOM Transport, S.A. de C.V.
June 2004 - October 2007
Work Package Controller - Personnel in charge: 7
Experience as a General Accountant in: Contabilidad & Informatica 2000, S.C. / Grupo Hexa 2002-2004