Microsoft Excel
Erik Alfonso Delgado Martinez
Financial Administration
Chihuahua
Summary
Experience in field of Accounts Payable, and experience in Cost Analyst, Cost Accountant & GL Senior Accountant, Plan Controller. Currently developing Project Cost Accountant Consultant role, always looking for continuous improvement and focused in accomplish the goals, always try to go a step ahead to resolve any issue, making strategies to reach the goal and be very communicative to the team & everybody involved, strong believer in team work, always willing to help and learn of everything, based on commitment and positive mentality.
Overview
6
6
years of professional experience
6
6
years of post-secondary education
1
1
Language
Work History
Senior Financial Analyst
BWI
11.2023 - Current
- Improved budget forecasting through meticulous monitoring of expenses and revenue streams.
- Reviewed financial reports and streamlined operations to increase productivity and company profits.
- Developed financial projections and forecasts to guide investment decisions.
- Assisted in preparation of presentations, data tables and other documents for investor meetings.
- Tracked prices, yields and other trends to correctly interpret impacts on investment programs.
- Created and maintained precise and accurate models, charts and reports.
- Review & Analysis of the volume loss impact in the P&L
- Profitability review by program
- Sales Analysis
- Sales forecast preparation & monitoring
- Month end close activities
- OI weekly file & explanation
- HC monitoring for forecasting
- Expenses Review
Assistant Controller
Motherson
05.2023 - 08.2023
- Review & Analyze the impact in the change of the BOM´s
- Review labor & OH rates based on the BOM´s
- Analyze changes in the structure of the process and see insights to have more profitability in the rates
- Estimate quotes for old products with the actual std cost & see the profitability and price
- Toolcrib inventory take
- Overview of the P&L
- Daily Sales & possible risks headed to MEC
Project Cost Accountant
Spirax Sacro
04.2022 - Current
- PPV Variations Analysis
- Standard cost analysis
- Standard cost variations, determine root cause of variations & explanations
- Absorption review & analysis
- Revaluation analysis
- Inventory variations review
- Propose new processes for std costing
- Inventory locations review
- Mapping of actual processes & mapping for missing processes
- WO variations (material, labor & oh)
- Roll up process & Impact review
Plant Controller
Electrocomponents International
09.2021 - 12.2021
- Budget
- Monthly Forecast
- Review of Actuals vs Forecast & Budget
- Analyzed history and trends of production data to develop reliable forecast information.
- Sales Analysis
- Absorption Analysis
- Efficiency Calculation
- Expense Monitoring
- Expense Plan Reduction
- Labor & OH Analysis and projection based on production volume
- Financial Bridges
- Financial Kpi's
- HC calculation vs production volume requirement
- Month end process
- Month end result presentation and explanation to the VP's
- Inventory variations review & approval
- New projects review & approval
- Month end JE's
- Oversaw inventory control positions by effectively following cycle counting policies and quickly identifying inventory discrepancies.
- Created and distributed reports on internal and external finances, audits, and budgets.
- Prepared balance sheets and income statements.
- Managed daily financial functions in collaboration with accounting and payroll personnel.
Senior Accountant
American industries
12.2020 - 09.2021
- Inventory Valuation
- FG Inventory & In Transit Inventory Reconciliations
- Review of Inventory variations vs GL
- Inventory Reserve Calculation
- Calculation & Review of Inventory WO's
PPP Analysis - Loans Revaluations
- Reclass of the intercompanies (AP,AR & PPP)
- Calculation for the IC's Credtors to Debtors JE's
- Review and Analysis of the Intercompanies differences
Calculation of the SG&A Quarterly - Month End JE's
- Blackline Conciliations
- SOX Requirements
- Monthly review to the staff about variances and actions to take
- Prepare working papers, reports and supporting documentation for audit findings.
- Compiled general ledger entries on short schedule with 100% accuracy.
- Reviewed accounts, resolved coding areas and tracked recurring expenses for accrual entry.
- Identified management control weaknesses and provided value added suggestions for remediation.
- Completed daily cash functions like account tracking, payroll and wage allocations, budgeting, donating and all types of cash and banking reconciliations.
- Collected and reported monthly expense variances and explanations.
- Inventory Valuation
- FG Inventory & In Transit Inventory Reconciliations
- Review of Inventory variations vs GL
- Inventory Reserve Calculation
- Calculation & Review of Inventory WO's
PPP Analysis - Loans Revaluations
- Reclass of the intercompanies (AP,AR & PPP)
- Calculation for the IC's Credtors to Debtors JE's
- Review and Analysis of the Intercompanies differences
Calculation of the SG&A Quarterly - Month End JE's
- Blackline Conciliations
- SOX Requirements
- Monthly review to the staff about variances and actions to take
- Prepare working papers, reports and supporting documentation for audit findings.
- Compiled general ledger entries on short schedule with 100% accuracy.
- Reviewed accounts, resolved coding areas and tracked recurring expenses for accrual entry.
- Identified management control weaknesses and provided value added suggestions for remediation.
- Completed daily cash functions like account tracking, payroll and wage allocations, budgeting, donating and all types of cash and banking reconciliations.
- Collected and reported monthly expense variances and explanations.
Senior Cost Accountant
Superior Industries
04.2019 - 12.2020
- Responsible of Reviewing the movements and correct booking of Raw Material with other plants such as Aluminum, Paints, WIP Wheels.
- Analysis of the Variations Accounts such as PPV, MPV and MRO cost variations with other plants.
- Weekly Analysis of the Perpetual inventories, movements, consumptions and negatives inventories of the different entities.
- Weekly Review of the WIP Module
- Monthly conciliation of the Perpetual Inventories of FG's, WIP and Raw Material vs GL.
- Analysis of the BOM's and PDS, std consumption vs real consumption.
- Roll up Maintenance
- Month End Close JE
- Weekly Scrap Valuation
- Daily Scrap Rate Calculation
- Physical Inventory Support
- Analysis of the PI Variations
- Assignment of cost to new Items such as Raw & MRO
- Weekly Expenses Presentation to the managers Review and booking of the hours dedicated to new projects and current projects.
- Expenses review
- Forecast support to plant controller
- Budget support to plan controller
Cost Accountant
Victaulic
07.2018 - 04.2019
- Planning, Studying, and collecting data to determine costs of business activity such as raw material purchases, inventory and labor.
- Analyzing data collected and recording results
Analyzing changes in product design, raw materials, manufacturing methods or services provided, to determine effects on cost - Analyzing actual manufacturing costs and preparing periodic reports comparing standard costs to actual production costs
- Recording cost information for use in controlling expenditures
- Analyzing audits of costs and preparing reports
- Making estimates of new and proposed product costs
- Providing management with reports specifying and comparing factors affecting prices and profitability of products or services.
- Maintain Cost Accounting System
- Assisting in Month end close of the General Ledger
- Conducts physical inventories and monitors cycle count program
- Reconciles finished goods, Raw material inventories
- Recosting Process for upcoming year
- Budget
- Analysis of variations of the cost accounts
- Planning, Studying, and collecting data to determine costs of business activity such as raw material purchases, inventory and labor.
- Analyzing data collected and recording results
Analyzing changes in product design, raw materials, manufacturing methods or services provided, to determine effects on cost - Analyzing actual manufacturing costs and preparing periodic reports comparing standard costs to actual production costs
- Recording cost information for use in controlling expenditures
- Analyzing audits of costs and preparing reports
- Making estimates of new and proposed product costs
- Providing management with reports specifying and comparing factors affecting prices and profitability of products or services.
- Maintain Cost Accounting System
- Assisting in Month end close of the General Ledger
- Conducts physical inventories and monitors cycle count program
- Reconciles finished goods, Raw material inventories
- Recosting Process for upcoming year
- Budget
- Analysis of variations of the cost accounts
Education
BBA - Finance Administration
Facultad De Contaduría Y Administración
Chihuahua, Chih, México. 08.2009 - 12.2015
Skills
Budget Analysis
Forecasting
Accounting principles
Budget development
Budget administration
Analytical and Critical Thinking
Accomplishments
- Documented and resolved Revaluation issue which led to better profit
- Collaborated with team of 4 people in the development of the US project
- Used Microsoft Excel to develop inventory tracking spreadsheets.
- Supervised team of 8 staff members.
- Introduced accounting procedures and stronger financial controls to improve financial reporting
- Wip development project
Software
Oracle
QAD
M3
BPC
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Languages
English
Advanced (C1)
Timeline
Senior Financial Analyst
BWI
11.2023 - Current
Assistant Controller
Motherson
05.2023 - 08.2023
Project Cost Accountant
Spirax Sacro
04.2022 - Current
Plant Controller
Electrocomponents International
09.2021 - 12.2021
Senior Accountant
American industries
12.2020 - 09.2021
Senior Cost Accountant
Superior Industries
04.2019 - 12.2020
Cost Accountant
Victaulic
07.2018 - 04.2019
BBA - Finance Administration
Facultad De Contaduría Y Administración
08.2009 - 12.2015