Juan Pablo Cervantes Silva
Summary
Experienced Senior Cost Accountant and Financial Analyst with over 6 years of expertise in cost accounting, financial analysis, and process optimization across various industries. Specializing in cost management, budget forecasting, and financial reconciliation,skilled in Power BI and Power Query, adept at automating data workflows and visualizing large-scale datasets.
Overview
12
12
years of professional experience
Work History
Sr. Cost Accountant Supervisor
Carlisle de Mexico
10.2022 - Current
- Coordinating cost accountant activities.
- Automatization of reports with power Bi
- Budget, Forecast
- Rates calculation
- Variances analysis (POV,PPV, absorption)
- E&O Calculation
- Cap Variance
- Ph. Inventory, Costed of Material
- Routes Analysis, BOMs, cost collector
- Analysis of Efficiency,Waste
- CAPEX. savings
Cost Accountant
Autosplice de Mexico
04.2022 - 10.2022
- Costed of Material
- Analysis Product Variations (PPV, Scrap, labor)
- Overhead Absorption
- Analysis BOM, Production Routes.
- Automation and Standardization of Excel Report with Power Query, BI, and Pivot
Fixed Asset & Cost Accountant
Continental Automotive S de RL de CV
09.2019 - 04.2022
- Costed of Material
- Routes Analysis, BOMs, cost collector
- Analysis Monthly (Scrap, PPV)
- Analysis Shop Floor (TE/TGB minutes, Bulk Material)
- Capitalization of Fixed Asset
- Calculation of material reserves (E&O, LCM, Scrap)
- Distribution of Depreciation Cost to the Products
- Prepare Budget and Forecast, Bridge, calculate of Overhead rate
- Posting Journal Entry Software SAP
- Reconciliation of Financial Statements Accounts, cycle account
General Accountant related to local taxes
Grupo Empresarial 5 de Mayo
01.2016 - 04.2017
Clerk Accountant related to local taxes
Consultoría Dinámica del Noroeste S.C
03.2013 - 01.2016
Education
Public Accounting -
Tecnológico Nacional de México, Tecnológico de Nogales
01.2018
Skills
- Good with Numbers
- Deductive Reasoning
- Software CONTPAQ & SAP HANA
- Microsoft Office Advanced Excel Power Query, Power BI & Power Pivot
Languages
Native Spanish
English 80%
Areas Experience
- Taxes
- Account Payable
- General Accounting
- Cost Accounting
- Finance Analysis
Timeline
Sr. Cost Accountant Supervisor
Carlisle de Mexico
10.2022 - Current
Cost Accountant
Autosplice de Mexico
04.2022 - 10.2022
Fixed Asset & Cost Accountant
Continental Automotive S de RL de CV
09.2019 - 04.2022
General Accountant related to local taxes
Grupo Empresarial 5 de Mayo
01.2016 - 04.2017
Clerk Accountant related to local taxes
Consultoría Dinámica del Noroeste S.C
03.2013 - 01.2016
Public Accounting -
Tecnológico Nacional de México, Tecnológico de Nogales
Similar Profiles
Graciela Rubí Fernandez GarzaGraciela Rubí Fernandez Garza
Squad Member Innovación Y Mejora Continua at Nueva Walmart De Mexico S De RL De CVSquad Member Innovación Y Mejora Continua at Nueva Walmart De Mexico S De RL De CV
Carlos Salvador Sanchez CruzCarlos Salvador Sanchez Cruz
Service Engineer at Meyn Food Processing Technology De Mexico S De RL De CVService Engineer at Meyn Food Processing Technology De Mexico S De RL De CV
Pablo Castillejos ZermenoPablo Castillejos Zermeno
Tax Supervisor at HALLIBURTON DE MEXICO, S. DE R.L. DE C.V.Tax Supervisor at HALLIBURTON DE MEXICO, S. DE R.L. DE C.V.
RANDA R ASSALRANDA R ASSAL
SR. COST ACCOUNTANT at Home Market FoodsSR. COST ACCOUNTANT at Home Market Foods
Oanh DeMarcoOanh DeMarco
Sr. Accountant- Budgeting and Cost Controlling at Cuulong Joint Operating CoSr. Accountant- Budgeting and Cost Controlling at Cuulong Joint Operating Co