TheGppablo

Spain

@pabloguinarte

Badges

Sql

Certifications

Work Experience

  • Business Analyst

    Freelancer•  March 2020 - Present•  vigo

    Make the complete bookkeeping including nominal ledger and preparation of the final accounts that includes taking into account prepayments and accruals, depreciation, bad debts, account of the final stock figure and the profit tax. Bank reconciliation, Cash flow budgeting. Prepare Tax returns and liaise with tax authorities when necessary. Advise and support clients regarding financial matters. Financial and Commercial, Reporting and Variance Analysis.

  • Consumer Insights Analyst

    Harte Hanks at Cisco•  January 2018 - February 2020

    Analyze and mine multiple data sources, providing insights and analysis to support marketing and sales across the globe. Derive company level intelligence identifying areas of opportunity including potential value. Includes sizing potential audiences, identifying gaps, building targets and segmentation.

  • Commercial Analyst

    Alexion Pharma•  February 2017 - September 2017

    Prepare commercial reports related to the sales activity and performance of the commercial team. Collaborate with other members of the operations team in order to improve the reliability of the information recorded in Salesforce.

  • Financial Analyst

    The Walt Disney Company Ltd•  January 2014 - November 2016

    Elaborate Commercial Reports on a Weekly basis in order to measure how successful our commercial performance has been against our KPI’s. Present to the team the weekly reports highlighting the most relevant aspects. Creating Ad-hoc Reports either on own initiative or on request in order to dive deep into specific areas of interest. Collaborate in the elaboration of the Annual Operation Plan for the business area.

  • Financial Accounts Executive

    The Walt Disney Company Ltd•  November 2012 - January 2014

    Accounts payable function for the department; this includes procession invoices and payments for the relevant vendors. Bank Reconciliation, Cash Flow forecast. Month End duties, including revenue and cost recognition.

  • Finance Assistant

    Cd Adapco•  June 2012 - November 2012

    Accounts payable function for the department; this includes procession invoices and payments for the relevant vendors, and expenses for employees.

  • Accountancy Department

    American Airlines•  October 2008 - March 2012•  London

    Accounting for the expenses incurred in the markets that I have assigned, that includes processing the invoices and doing the payments to the vendors by BACS or Chaps. Auditing and processing employee’s expenses. Making the monthly accruals. Elaborating the monthly VAT for the Spanish market.

  • Financial Accountant and Tax Advisor

    AT. VIGO•  January 1998 - December 2007

    Revise accounts and produce statements at regular interval to report the situation to the client, for those clients that use to do the accountancy in their own offices. Make the complete bookkeeping including nominal ledger and preparation of the final accounts that includes taking into account prepayments and accruals, depreciation, bad debts, account of the final stock figure and the profit tax. Deal with the Spanish tax authorities regarding corporate taxes, VAT, personal income taxes and other tax returns like intrastate, etc that needed to be prepared. Bank reconciliation, Cash flow budgeting. Prepare the financial information, (balance sheet, Profit and loss account, etc) for banks and credit institutions. Prepare VAT returns included ordinary operations, intercommunity operations, export and imports.

Education

  • University of Vigo

    Business Administration, Business Administration and Economics Degree•  January 1988 - December 1994

Skills

Excel
Tableau
SQL
SAP
Sage 50
Python