Andres Eduardo Aguilar Esparza

Andres Eduardo Aguilar Esparza Senior Accountant Aguascalientes, Ags. +-+ -+ linkedin.com/in/andres-aguilar- - EXPERTISE AREAS  Accounting  Internal Control  Financial information  Audit + Transfer Pricing activities + Tax calculations + Sarbanes Oxley audits + Budget, Financial Models, Cashflow +Problem solving +Teamwork KEY ACHIVEMENTS Fiscal Matters – Recovery of VAT refunds that helped to improve cash flow ERP Migration - Collaboration in some (3) successful migrations of financial information. Improvements in Accounting department – Review and Reduction of activities to reduce the processing time of the information for the close of month. EDUCATION Autonomous University of Aguascalientes Aguascalientes, Ags. Bachelor's degree in public accounting Jun-1999. PROFESSSIONAL EXPERIENCE AP Consulting Services Aguascalientes, Ags. Accountant (Family Business) Aug-2018-Actual.  Accounting Consulting services to individuals and legal entities in Mexico, reviewing and evaluating their internal control’s procedures in Treasury, AR, AP, Inventories, Fixed Asset, Sales, expenses, etc.  Processing daily transactions by journal entries and doing interfaces with AR and AP modules  Delivery of financial information in monthly basis with the clients providing some comments to the variations  Tax calculation according to local regulations  Delivery of financial information monthly. Achievements: Quality service is provided with client satisfaction. Mabuchi Motor México S.A. de C.V. (Large company 1,700 employees) Aguascalientes, Ags. Accounting Vice Manager May-2023/Nov-23.  Overseeing the accounting process, Banks, AR, Inventories, Fixed Assets, AP, Taxes calculation  In charge of close of month in quarterly annual basis. Submission of financial statements to corporates offices in Tokio, Japan.  Coordinating some other activities such UBO, Refipres and Transfer pricing study.  Managing of the annual budget and some forecasting scenarios and updating cashflow in monthly basis  Review and booking of the payrolls journal entries Technical Skills- Software’s-Excel Advanced, Microsoft Office 365, Hyperion, Blackline, Cadency SAT Local Software’s, Issif, Sipred, Diot ERP´s + Oracle, Map, Sap, As400, QAD, Baan-LN2, Solomon, Quickbooks Contaq, Nomipaq, Adminpaq, Cheqpaq, SAE-Coi, Noi Language: English-C1 advanced Level Andres Eduardo Aguilar Esparza Senior Accountant Aguascalientes, Ags. +-+ -+ linkedin.com/in/andres-aguilar- - Achievements: The first annual tax report was delivered after resolving several issues. FRAM GROUP SERVICES MEXICO SA DE CV San Luis Potosí, SLP. Accountant Lead Dec-2021-May-2023.  Member of the team in charge of the migration of the financial information from two entities located in Los Angeles, Ca. to Corporate offices in San Luis Potosi, Mexico as a global shared services center.  Overseeing the accounting process, including tax calculations and audit activities coordination  In charge of the close of month and monthly reports regarding Net Sales breakdown, Headcount report, expenses analysis, submission of the financial information with comments to the variations, attending the external auditors’ requirements.  Review and booking payroll journal entries and reconciling ending balances in payroll accounts  Preparing after submission of financial statements, the balance sheet accounts reconciliations. Achievements: Migration of financial information from companies located in Los Angeles, Ca. to the corporate offices in SanLuis Potosi successfully completed PROFESSIONAL EXPERIENCE Mighty Nonprofits LLC Bookkeeper Remote. Accountant (Contractor) Jan 2021-Dec 2021.  Responsible for booking revenues, expenses and payroll transactions coming from donations in a nonprofits companies located in USA  Responsible for close of month, Balance sheet account reconciliations and reporting the financial information. Achievements: services provided on time and with customer satisfaction, we obtained recommendations that allowed us to get more customers. Donaldson, S.A. de C.V. Aguascalientes, Ags. Tax & Accounting Supervisor JUN-19- FEB-2020.  Overseeing accounting process, Review and approval of the manual journal entries according to the internal control’s procedures, Review and approval of the monthly account’s reconciliation  In charge of the close of month, preparation of the Monthly financial statements  Monthly Tax calculation and submission of Annual Tax Return,  Submission of financial information to the corporate offices located in Bloomington, Minnesota.  Coordination of the external and internal audits Transfer pricing study information  Assisting in the cash flow report and Budget preparation  Recognition of the leases and proper booking Technical Skills- Software’s-Excel Advanced, Microsoft Office 365, Hyperion, Blackline, Cadency SAT Local Software’s, Issif, Sipred, Diot ERP´s + Oracle, Map, Sap, As400, QAD, Baan-LN2, Solomon, Quickbooks Contaq, Nomipaq, Adminpaq, Cheqpaq, SAE-Coi, Noi Language: English-C1 advanced Level Andres Eduardo Aguilar Esparza Senior Accountant Aguascalientes, Ags. +-+ -+ linkedin.com/in/andres-aguilar- - Achievements: Recovery of 5 M USD in VAT refunds. Mahindra México, S. de R. L. de C.V. Aguascalientes, Ags. Accounting Manager Aug 18- JUN 19.  Responsible for the accounting department, AP, AR, Treasury, Inventories and intercompany.  Preparation of the Monthly financial statements, Budget calculation and Forecast  Taxes calculation and submission of Annual Tax Return and submission to the corporate offices in Houston. Tx and Mumbai, India.  Coordinating the activities to gather information for transfer pricing study Achievements: Internal control processes implemented in accounting department. Cortina, Tagle e Isoard contadores, S.C. Queretaro, Qro. Accounting Supervisor JUNE 2017-FEB-2018.  Managing an accounting team of 4 staffs, responsible of the accounting process, tax calculations; review of the internal control procedures and in several cases Treasury transactions of 23 abroad companies  Reviewing the accomplish of Transfer prices study, Mexican gaaps as NIF D-3, payroll liabilities, NIF D-4 Deferred tax calculation, electronic invoicing and electronic accounting. Achievements: All the task and duties were completed on time, high satisfaction of our clients Michelin México Services, S.A. de C.V. Queretaro,Qro. Corporate Accountant /Sascar Corporate Accountant JUNE 2015- MAY 2017.  In charge of Accounting department, coordinating 6 staff, responsible of the monthly close,  reconciliation between PL vs SL consolidating of the financial information,  Responsible of Monthly Financial package and submit to USA headquarter and Clermont, France.  Review of the daily financial transactions according to internal control guidelines of the company and updating the Corrective Action register in the case of an unusual transaction due to the amount and nature.  Monthly review of the P&L and TB statements vs BA/Forecast, providing some comments to those items with differences bigger than 10% Administration and updating the cash flow every week,  Calculation of the monthly taxes, IRS, VAT, withholding taxes and deferred tax Provide information to external and internal auditors for statutory and internal control purposes Preparation of the annual tax return. Achievements: Reduction of journal entries and improvement of the information processes. Technical Skills- Software’s-Excel Advanced, Microsoft Office 365, Hyperion, Blackline, Cadency SAT Local Software’s, Issif, Sipred, Diot ERP´s + Oracle, Map, Sap, As400, QAD, Baan-LN2, Solomon, Quickbooks Contaq, Nomipaq, Adminpaq, Cheqpaq, SAE-Coi, Noi Language: English-C1 advanced Level Andres Eduardo Aguilar Esparza Senior Accountant Aguascalientes, Ags. +-+ -+ linkedin.com/in/andres-aguilar- - A.E PETSCHE COMPANY, S. DE R.L. DE C.V. QUERETARO, Qro. General Accountant APRIL 2011 -JUNE 2015.  In charge of the accounting department, Treasury area, tax department, AP and AR.  Improvement of internal control policies, controls of the fixed assets, payroll  Responsible for the monthly close and Financial Statement preparation/submission.  Preparation of Annual Budget preparation, application and control versus P&L statement.  Preparing the financial consolidation of three companies of the AEP group, taking off the incomes  Use of the Safe Harbor scheme to invoice costs & expenses coming from maquila activities in the harnesses manufacturing. Achievements: Successful migration of financial information from AS-400 to Oracle erp. Yorozu mexicana, S.A. de C.V. Aguascalientes, Ags. Accounting Supervisor September 2008 – July 2010.  In charge of the accounting department and the fiscal area and taxes duties  I had a supervisory position in the accounting system “BAAN-LN2”, making the migration of the general ledger from a conventional system to ERP (BAAN-LN2) maintenance of the transactions ensure proper GL recording  Responsible for collecting all the information from several production areas to prepare the Budget  Responsible for the forecast for control of the Flat tax payments. Achievements: Migration of the financial information from Contpaq to BAAN-LN2 DENYM, S.A. DE C.V. September Aguascalientes, Ags. Accounting Supervisor 2008 – July 2010. Responsible of the follow departments • Accounting • Payroll • Warehouse • Taxes duties (including annual and monthly statements, payment in advanced of IRS, IETU) • . Liaison with internal and external auditors. Achievements: Review of the internal controls in treasury, Inventory and payroll departments and there were no findings or issues. Technical Skills- Software’s-Excel Advanced, Microsoft Office 365, Hyperion, Blackline, Cadency SAT Local Software’s, Issif, Sipred, Diot ERP´s + Oracle, Map, Sap, As400, QAD, Baan-LN2, Solomon, Quickbooks Contaq, Nomipaq, Adminpaq, Cheqpaq, SAE-Coi, Noi Language: English-C1 advanced Level Andres Eduardo Aguilar Esparza Senior Accountant Aguascalientes, Ags. +-+ -+ linkedin.com/in/andres-aguilar- - FORJAS Y MAQUINAS, S.A. DE C.V. (TRW AUTOMOTIVE) Aguascalientes, Ags. Internal Management Coordinator Aug2007-Aug 2008 • Responsible for the Taxes department, Fixed Assets department, Overseeing the process the general ledger and payroll, ensure proper GL controls being maintained daily, driving continuous process improvements in such departments. • Responsible of the Financial Statement preparation • Responsible of Maquila process, in accounting management and taxes duties, using the Safe Harbor scheme to invoice all the cost & expenses of operation and applying a markup of 6.5% • Control of the inventories for maquila purposes • Liaison with internal and external auditors • Reporting on the four quarter TAX PACKAGE, to corporate finance. • Reporting the Mexican-Us Gaaps reconciliation. • Managing reporting deadlines, administration of annual performance for taxes purposes, • Assisting in the preparation of the budget, monitoring cost implications. • Assisting in the preparation of the cash flow • Assisting in Sarbanes-Oxley compliance and audit. Achievements: • I established a dynamic flow of information that gives services to the other departments. • Recovery of 12 M MXN of VAT in 2 months. CONSTRUCTORA DE MAQUINARIA TRIUFO S.A. DE C.V Aguascalientes, Ags. Accounting Manager Nov-1999-Aug-2007. • In this position, I was responsible of accounting department, Cost department, taxes department and supervising Payroll department, Treasury, accounts payables, accounts receivable and inventories. Responsible for monthly closing, account analysis, cash flow reporting and the preparation of the budget. Achievements: Throughout the 6 years we recovered VAT refund by 450 K MXN, 5 M MXN rounded per year. MINERA REAL DE ANGELES, S. A. DE C. V. (Grupo Carso) de Angeles, Zac. General Accountant Mar 1994 – Feb. 1999. Responsible of Accounting department, Costs department, Taxes department, Noria Achievements: I had successful participation in the implementation and development of new software for the financial information of the company (migration from a software to an ERP). Technical Skills- Software’s-Excel Advanced, Microsoft Office 365, Hyperion, Blackline, Cadency SAT Local Software’s, Issif, Sipred, Diot ERP´s + Oracle, Map, Sap, As400, QAD, Baan-LN2, Solomon, Quickbooks Contaq, Nomipaq, Adminpaq, Cheqpaq, SAE-Coi, Noi Language: English-C1 advanced Level