$$$$
{{ $t($store.state.user.experience_value_in_dollars) }}
Expert
{{ $t($store.state.user.experience_search_name) }}
0
jobs
Excel and Macro Expert
Ramiro Navarro
,
london, United Kingdom
Experience
Other titles
Skills
I'm offering
I you need any help with Excel modelling, macro building, P&L templates, budget templates, projection templates, financial model, forecasting, you can count on me
Markets
United Kingdom
Language
English
Fluently
Spanish
Fluently
Ready for
Ongoing relation / part-time
Available
My experience
2016 - 2018
job
Financial Controller
Sabadell Information systems ltd - Group Sabadell.
GB)
• Building the cost model to control the IT platform of TSB bank.
• Cost management: monitor cost deviations and submit periodical reports to the holding
• PRA requirements: ensure regulatory capital and liquidity requirements, attend PRA data requests
• Expenses monitoring: monitor expenses, create reporting outputs to submit to the holding, cash flow forecasting
• Month end reporting. Balance sheet analysis, P&l
• Financial management of the agreements: support the holding on the definition of the mark-up to apply to clients
• Financial forecasting: elaborate financial forecasting and submit to the holding for approval decision
• SAP module FI implementation coordination + tool for invoice authorization
• Inbound/outbound payment administration: approve/deny based on current budget status
• Reporting accounts in UK GAAP and IFRS
• Management control: apply general guidelines submitted by the holding
• Building the cost model to control the IT platform of TSB bank.
• Cost management: monitor cost deviations and submit periodical reports to the holding
• PRA requirements: ensure regulatory capital and liquidity requirements, attend PRA data requests
• Expenses monitoring: monitor expenses, create reporting outputs to submit to the holding, cash flow forecasting
• Month end reporting. Balance sheet analysis, P&l
• Financial management of the agreements: support the holding on the definition of the mark-up to apply to clients
• Financial forecasting: elaborate financial forecasting and submit to the holding for approval decision
• SAP module FI implementation coordination + tool for invoice authorization
• Inbound/outbound payment administration: approve/deny based on current budget status
• Reporting accounts in UK GAAP and IFRS
• Management control: apply general guidelines submitted by the holding
Administration, SAP, Budget, Forecasting, Management, It, Support, Implementation, Monitoring, Regulatory, UP, It platform
2015 - 2016
job
Financial, Administration & HR Controller
Grupo Codorniu.
GB)
• Managing a team of 6 people in different roles of general accounting, accounts payable, sales administration, procurement and stock control, taxes and treasury
• Monthly and year end accounting process closing. Inter-company billing and reconciliation. Accruals closing estimation, Balance sheet and p&l reconciliation
• Cash flow budgets, treasury control
• High quality financial performance reports: analytical P&L, individual profit analysis per company areas. Provide monthly reporting to department heads, discipline leads, and brand heads for spending in their respective areas.
• Marketing expenditure control, by brand, by concept, monthly analysis reporting and deviation.
• Analysis real vs budget deviations
• VAT, Corporation Tax, Alcohol duties, Alcohol regulation
• Full reporting financial - controlling - sales package to the headquarters by line of business, customer, etc.
• Risk assignation for new customers, collection procedures, bad debt analysis, sales conditions maintenance
• Stock levels controls, cost optimization
• Contracts of employment, employee policies, employee procedures
• Process optimization and unification with the headquarters
• Owner of the annual budgeting process including the preparation of quarterly and monthly projections and maintain the model to accurately reflect business needs and requests in all expense categories (new hires, freelance, office costs, T&E).
• Managing a team of 6 people in different roles of general accounting, accounts payable, sales administration, procurement and stock control, taxes and treasury
• Monthly and year end accounting process closing. Inter-company billing and reconciliation. Accruals closing estimation, Balance sheet and p&l reconciliation
• Cash flow budgets, treasury control
• High quality financial performance reports: analytical P&L, individual profit analysis per company areas. Provide monthly reporting to department heads, discipline leads, and brand heads for spending in their respective areas.
• Marketing expenditure control, by brand, by concept, monthly analysis reporting and deviation.
• Analysis real vs budget deviations
• VAT, Corporation Tax, Alcohol duties, Alcohol regulation
• Full reporting financial - controlling - sales package to the headquarters by line of business, customer, etc.
• Risk assignation for new customers, collection procedures, bad debt analysis, sales conditions maintenance
• Stock levels controls, cost optimization
• Contracts of employment, employee policies, employee procedures
• Process optimization and unification with the headquarters
• Owner of the annual budgeting process including the preparation of quarterly and monthly projections and maintain the model to accurately reflect business needs and requests in all expense categories (new hires, freelance, office costs, T&E).
Marketing, Administration, Budget, Contracts, Procurement, Controlling, Sales, Process optimization, Office, Treasury, Contracts
2009 - 2011
job
Tax and Accounting Manager
Codorníu, S.A.
Spain)
• Managing a team of over thirteen finance professionals.
• Preparation of management accounts. (Spanish GAAP and conversion into IFRS - reporting to the National stock market). Monthly and annual reporting; including reconciliations process: revenue vs. accounting, cost accounting vs. financial.
• Tax accounting. Annual Corporation Tax and VAT preparation, including group optimization.
• Financial planning, actual results, working capital, capital expenditure and special reporting requests.
• Managing a team of over thirteen finance professionals.
• Preparation of management accounts. (Spanish GAAP and conversion into IFRS - reporting to the National stock market). Monthly and annual reporting; including reconciliations process: revenue vs. accounting, cost accounting vs. financial.
• Tax accounting. Annual Corporation Tax and VAT preparation, including group optimization.
• Financial planning, actual results, working capital, capital expenditure and special reporting requests.
Management, Finance, Working capital, Manager
2007 - 2009
job
Group Controller
Porcelanosa Group LTD.
UK)
• Company secretary for nine UK subsidiaries, Group entity and Real Estate Company, HQ based in Spain.
• Direct the annual budgeting process including the preparation of quarterly and monthly projections and maintain the model to accurately reflect business needs and requests in all expense categories, as well as, cost analysis, cost deviation and cash flow analysis.
• Build process around operational efficiencies - documenting business development investments, procuring signatures, revenue forecasting, monitoring project health and escalating problem accounts; as well as, shared services coordination for the UK subsidiaries: IT, Marketing and Human Resources.
• Review models with an eye on identifying areas for cost savings; analyze and review profit planning, sales forecasts, expense budgets and board reports for the entire UK group, reporting to Spanish HQ.
• Company secretary for nine UK subsidiaries, Group entity and Real Estate Company, HQ based in Spain.
• Direct the annual budgeting process including the preparation of quarterly and monthly projections and maintain the model to accurately reflect business needs and requests in all expense categories, as well as, cost analysis, cost deviation and cash flow analysis.
• Build process around operational efficiencies - documenting business development investments, procuring signatures, revenue forecasting, monitoring project health and escalating problem accounts; as well as, shared services coordination for the UK subsidiaries: IT, Marketing and Human Resources.
• Review models with an eye on identifying areas for cost savings; analyze and review profit planning, sales forecasts, expense budgets and board reports for the entire UK group, reporting to Spanish HQ.
Marketing, Business development, Forecasting, Human Resources, Sales, It, Development, Monitoring, Health
2004 - 2006
job
Subject Matter Expert and Key Contact Lead
Bayer Euroservices, S.L. -Shared Service Centre.
(Barcelona, Spain)
• Key user at Accounts Payable processing department, in charge of Benelux, Italy, Iberia, and Switzerland regions. Checking and approval of daily payment list.
• Subject Matter Expert and Key Contact Lead appointed within Systems, Solutions and Projects department, to rebuild process around "shared services" principle driving efficiencies to the whole group.
• SOX key user. Developing and testing (process and control) first AP SOX procedure implementation.
• Project Coordinator. AS400 migration to SAP across certain local entities.
• Key user at Accounts Payable processing department, in charge of Benelux, Italy, Iberia, and Switzerland regions. Checking and approval of daily payment list.
• Subject Matter Expert and Key Contact Lead appointed within Systems, Solutions and Projects department, to rebuild process around "shared services" principle driving efficiencies to the whole group.
• SOX key user. Developing and testing (process and control) first AP SOX procedure implementation.
• Project Coordinator. AS400 migration to SAP across certain local entities.
SAP, Implementation, Testing, Coordinator, Processing
1999 - 2004
job
Accountant - Credit controller
Spain, S.A.
Spain)
Accountant - Credit controller. September 1999 - May 2004 Bosch Siemens Home Appliances Spain, S.A. (Zaragoza, Spain)
• Manage invoice and billing function.
• Credit & Risk analysis.
• Completion of monthly finance reporting pack.
• Financial accounting to trial balance.
• Pre-payments / Accruals / Journals.
• Bank reconciliations.
Accountant - Credit controller. September 1999 - May 2004 Bosch Siemens Home Appliances Spain, S.A. (Zaragoza, Spain)
• Manage invoice and billing function.
• Credit & Risk analysis.
• Completion of monthly finance reporting pack.
• Financial accounting to trial balance.
• Pre-payments / Accruals / Journals.
• Bank reconciliations.
Finance, Accountant, Risk analysis
My education
Darden Graduate School of Business Administration
Masters, SAP FI-CO
Masters, SAP FI-CO
n/a
Secondary, Accounting
Secondary, Accounting
Ramiro's reviews
Ramiro has not received any reviews on Worksome.
Contact Ramiro Navarro
Worksome removes the expensive intermediaries and gives you direct contact with relevant talent.
Create a login and get the opportunity to write to Ramiro directly in Worksome.
38100+ qualified freelancers
are ready to help you
Tell us what you need help with
and get specific bids from skilled talent in Denmark