You're seeing this page as if you were . The main menu is still yours, though. Exit from immersion
Tiantian L.TL

Tiantian L.

Financial Analyst

€450/day
Paris, FR
0-2 years

Average response time: 1 hour

Freelancer profile translated to English.
Back to original language

About Tiantian

I offer solutions to develop and automate reporting in Excel and Power BI.

Having worked in small teams, I am used to keeping the whole team informed in real time.

My projects include:
- automating the tracking of purchase orders using Power Query;
- setting up reports by region and by function;
- reclassifying accounting entries and preparing income statements;
- creating interactive reports in Power BI for the retail sector.

I can adapt quickly to new systems and tools. Please send me a message if you’re interested!
  • French

    Native or bilingual

  • English

    Native or bilingual

  • Chinese

    Native or bilingual

Can work on-site
Paris (up to 30km)

Experience

  • FREELANCE
    Financial Analyst
    PRESS AND MEDIA
    October 2025 - November 2025 (1 month)
    Paris, France
    ● Performance analysis: Create a dashboard from the customer database. Improve visibility on revenue drivers, enable cross-channel analysis, and facilitate business planning.
    ● P&L: Reclassify accounting entries to build an income statement, analyze products/expenses/EBIT/fixed assets/depreciation.
    ● Personnel expenses: Develop forecasts for personnel expenses, HC, and FTE by team and by month.
    Business analysis p&l Microsoft Excel
  • Ipsen Pharma
    Management Controller
    HEALTH AND WELLNESS
    July 2024 - December 2024 (5 months)
    92100 Boulogne-Billancourt, France
    ● Budget and forecast: Support the financial planning cycle covering 13 departments. Support payroll analysis (personnel expenses, HC, and FTE). Ensure forecast landing and updates.
    ● Monthly closing: Prepare entries, ensure data reliability. Analyze and reconcile budget vs. Actual vs. Forecast variances.
    ● Cross-departmental coordination: Lead monthly expense reviews with operational teams (IT, Strategy, Purchasing), identifying variances and corrective actions.
    ● Process improvement: Automate order tracking and ensure reliability of financial data – 30% productivity gain. Develop dashboards used by several process managers.
    Accounting Close Budget Management
  • Ernst & Young (UK)
    Strategic and Financial Consultant
    CONSULTING AND AUDITS
    May 2023 - August 2023 (3 months)
    Beijing, China
    ● Budget plan: Structure a robust budget framework by analyzing data from 10+ annual reports and 50+ supplier contracts for an industrial park project.
    ● Financial analysis: Develop KPIs and dashboards to evaluate assets (occupancy rate, rental trends), allowing for better cost and risk control.
    ● Ad hoc requests: Occasional updates to forecast assumptions (changes in volumes, revenues, operational assumptions) to meet client requests.
    Financial Modeling Business analysis

Recommendations

Be the first to recommend Tiantian

Help this freelancer shine by sharing your experience working together.

These freelancer profiles also match your criteria

AgathaA

Agatha Frydrych

Backend Java Software Engineer

4.7

(3)

2

BaptisteB

Baptiste Duhen

Fullstack developer

4.6

(4)

5

AmedA

Amed Hamou

Senior Lead Developer

4

(2)

7

AudreyA

Audrey Champion

Web developer

4.3

(3)

4

Education

  • Grande Ecole
    ESSEC BUSINESS SCHOOL
    2025
    Finance d'entreprise et Finance de marché
  • Bachelor's degree
    BEIJING FOREIGN STUDIES UNIVERSITY
    2021
    Licence

Certifications

Skill set

Categories