YI LIU

YI LIU

Valuation & Modeling Specialist

Followers of YI LIU365 followers
location of YI LIUMadrid, Community of Madrid, Spain

Connect with YI LIU to Send Message

Connect

Connect with YI LIU to Send Message

Connect
  • Timeline

  • About me

    Data Analyst Excel, Sql, Power Bi. Financial modoler, Financial Analyst, Data Analyst Freelancer, Financial Data Analyst Freelancer

  • Education

    • Universidad Rey Juan Carlos

      2015 - 2016
      MASTER CONTABILIDAD Y FISCALIDAD Contabilidad y actividades afines NOTABLE

      Habilidades adquiridas a través del curso • Conocimiento avanzado en Plan General Contable• Realizar contabilidad de todos tipos de operaciones • Conocimiento de IRPF, Impuesto de sociedad • Liquidar el impuesto de sociedad y la contabilidad fiscal• Análisis de los Estados Financieros• Prácticas en utilizar programa A3

    • Universidad Complutense de Madrid

      2018 - 2020
      Máster oficial Finanzas de Empresa Financieros Contables, Modelizacion financiera, Corporate Finance, International finance, Derivados

      Habilidades adquiridas a través del curso• Analisis de montar modelo financiero complejo para la valoracion de Proyecto y LBO• Conocimiento de Fusión y Adquisión(M&A)• Analisis de estados financieros • Analisis estatisticos con programa Gretl • Analisis de valor y viabilidad de Proyecto• Analizar valor de Proyecto a través de método opciones reales• Analizar el proformence de Cartera de Inversion, Capital Riesgo

  • Experience

    • KPMG Advisory (China) Limited Beijing Branch

      Dec 2012 - Aug 2018
      Valuation & Modeling Specialist

      - Billed invoices and managed accounts receivable using SAP.- Prepared weekly and monthly accounts receivable reports for department heads.- Supported project managers in collecting receivables and assisted the accounting department with overseas payment documentation.- Performed administrative tasks as assigned, ensuring smooth departmental operations.

    • Ykile

      Jul 2019 - Oct 2019
      Contabilidad y administracion

      - Establish models for internal daily accounting, cash management, and receivables and payables management using EXCEL tools.- Create templates for client invoicing and fixed asset amortization.Record income and expenses using the established model.- Generate monthly financial reports for the partners.Assist with company events.

    • DONCELMAR SL

      Dec 2019 - now
      Financial Administrator

      - Maintained and recorded client bank transactions using SAGE DESPACHO.- Assist in tax filings and reconciled client invoices during quarterly tax periods (April, July, October, January).- Prepared periodic financial reports and analyzed the financial health of client companies.- Reconciled accounts receivable and payable, providing key insights and suggestions to clients.- Assisted with fiscal year-end account reconciliations and tax filings.- Collaborated with colleagues to complete Form 347 audits in April.- Handled daily client communication and report preparation - I am currently managing around 20 clients, including cleaning service companies, real estate developers, restaurants, and independent contractors. Show less

    • Fiverr

      Sept 2020 - May 2022
      Financial Data Analyst

      - providing financial modeling and financial forecast services for business plan- providing company valuation service for small consultanting firm or consultancy- providing financial data analysis services for small business using powerbi or excel

    • Efinancialmodeling

      Jan 2021 - now
      Efinancialmodels Vendor

      Designed and sold financial models on the eFinancialModels platform, showcasing expertise in financial modeling.

  • Licenses & Certifications

    • Dashboards & Data Visualization

      Corporate Finance Institute
      May 2023
      View certificate certificate
    • FP&A Monthly Cash Flow Forecasting

      Corporate Finance Institute
      May 2023
      View certificate certificate
    • Power Pivot Fundamentals

      Corporate Finance Institute
      May 2023
      View certificate certificate
    • Scenario & Sensitivity Analysis

      Corporate Finance Institute
      May 2023
      View certificate certificate
    • SQL ADVANCED TRAINING

      Udemy
      Aug 2020
    • Máster de contabilidad y fiscalidad

      Universidad Rey Juan Carlos
    • POWER BI BUSINESS ANALYSIS TRAINING

      Udemy
      May 2020
      View certificate certificate
    • DAX ADVANCED TRAINING COURSE

      Udemy
      Jun 2020
      View certificate certificate
  • Volunteer Experience

    • TRANSLATOR WRITING

      Issued by Peace for Humanity Organization on Nov 2011
      Peace for Humanity OrganizationAssociated with YI LIU
    • Traductora voluntaria

      Issued by Blue Ocean Network TV on Dec 2009
      Blue Ocean Network TVAssociated with YI LIU
    • Volunteer Staff

      Issued by Mision salesiano on Jun 2019
      Mision salesianoAssociated with YI LIU
    • Asistente de contabilidad

      Issued by FUNDACIÓN JÓVENES Y DESARROLLO on Oct 2018
      FUNDACIÓN JÓVENES Y DESARROLLOAssociated with YI LIU
    • Accountant intership

      Issued by Reclamador.es (Startup) on Jan 2018
      Reclamador.es (Startup)Associated with YI LIU