
YI LIU
Valuation & Modeling Specialist

Connect with YI LIU to Send Message
Connect
Connect with YI LIU to Send Message
ConnectTimeline
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 - 2016MASTER CONTABILIDAD Y FISCALIDAD Contabilidad y actividades afines NOTABLEHabilidades 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 - 2020Máster oficial Finanzas de Empresa Financieros Contables, Modelizacion financiera, Corporate Finance, International finance, DerivadosHabilidades 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 2018Valuation & 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 2019Contabilidad 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 - nowFinancial 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 2022Financial 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 - nowEfinancialmodels VendorDesigned and sold financial models on the eFinancialModels platform, showcasing expertise in financial modeling.
Licenses & Certifications
- View certificate

Dashboards & Data Visualization
Corporate Finance InstituteMay 2023 - View certificate

FP&A Monthly Cash Flow Forecasting
Corporate Finance InstituteMay 2023 - View certificate

Power Pivot Fundamentals
Corporate Finance InstituteMay 2023 - View certificate

Scenario & Sensitivity Analysis
Corporate Finance InstituteMay 2023 
SQL ADVANCED TRAINING
UdemyAug 2020
Máster de contabilidad y fiscalidad
Universidad Rey Juan Carlos- View certificate

POWER BI BUSINESS ANALYSIS TRAINING
UdemyMay 2020 - View certificate

DAX ADVANCED TRAINING COURSE
UdemyJun 2020
Volunteer Experience
TRANSLATOR WRITING
Issued by Peace for Humanity Organization on Nov 2011
Associated with YI LIUTraductora voluntaria
Issued by Blue Ocean Network TV on Dec 2009
Associated with YI LIUVolunteer Staff
Issued by Mision salesiano on Jun 2019
Associated with YI LIUAsistente de contabilidad
Issued by FUNDACIÓN JÓVENES Y DESARROLLO on Oct 2018
Associated with YI LIUAccountant intership
Issued by Reclamador.es (Startup) on Jan 2018
Associated with YI LIU
Languages
- chChino
- inInglés
- esEspañol
Recommendations

Blessing ekpo
Passionate TEFL-Certified English Teacher & Event Manager | Dynamic Compere & Public Speaker | Produ...Port Harcourt, Rivers State, Nigeria
Mirae l.
Digital Marketing & Content Management | Co-founder of choaSingapore
John yarpaz
Financial Management | Accounting | Financial Analysis | Effective Communication | Tax Optimization ...Dubai, United Arab Emirates
Ramiz riaz - fcca
Corporate Management & Financial Reporting Specialist|FCCA UK|ICAEW Finalist|FreeAgent|Taxcalc.|CCH ...Lahore District, Punjab, Pakistan
Danny j rivera
Assistant Director at Queens Community HouseBrooklyn, New York, United States
Eltaj abbasov, mba
Onshore operator IV at Binagadi Oil Company | MBA Project ManagementBaku City, Baku Ekonomic Zone, Azerbaijan
Gábor csáki
Senior Category Manager for engine castings at INNIO JenbacherAustria
Omar el ghetrify
Partnerships Manager driving growth through strategic partnerships and CRM expertise.Washington DC-Baltimore Area
Yashvardhan sai ampa
Mech 2024 | Undergrad at IIITDM KancheepuramChennai, Tamil Nadu, India
Adewale adenekan acti,fbma,cna,fccmn,b.sc.
Asst. Chief Accountant at Federal Ministry of Humanitarian Affairs and Poverty Alleviation FCT,Abuja...Abuja, Federal Capital Territory, Nigeria
Rassie jacobs
General Manager at Ingran Africa TechnologiesCity of Johannesburg, Gauteng, South Africa
Amr allam, cfo, ksa visa
Group Finance DirectorEgypt
Pedro rivas
Director Strategic Planning Perú & Ecuador/ The Coca-Cola CompanyPeru
Reuben govender
Bachelor of Laws - LLB at University of South Africa/Universiteit van Suid-AfrikaCity of Cape Town, Western Cape, South Africa
Magdalena jędraszczyk
Planowanie produkcji, zarządzanie projektami, zarządzanie produkcją, kontrola jakości.Leszno, Wielkopolskie, Poland
David gregory
Vice President - Goldman Sachs AycoGreater Houston
Ankur srivastava
Faculty at IRMAAnand, Gujarat, India
Louisa cronin cert cii
Experienced Developer and Account Manager. A positive and engaging role model in the employee benefi...Egham, England, United Kingdom
Liubov a.
TraductriceParis, Île-de-France, France
Hatim abbas
Being human in an AI worldGlenroy, Victoria, Australia
...