Celestine Tiesset portrait
Currently an Extern @Yinan Zhao

International Business Student

Redefining what's already been defined. Curious about ideas, businesses and people who challenge the way things are.

Work samples

Explore some of the projects through which I've experimented with data analytics, AI, financial modelling and consumer insights and how these tools can help businesses make better decisions and grow.

  • Beats by Dre Data Analytics: Qualitative & Quantitative Insights Externship
    Beats by Dre Data Analytics: Qualitative & Quantitative Insights Externship
    Beats By Dre logo

    Beats By Dre · May 2026 · ✅ Verified by Extern

    Beats by Dre Data Analytics: Qualitative & Quantitative Insights Externship

    Explore how leading brands decode consumer conversations to create products that resonate. This externship offers practical skills in uncovering market trends, analyzing authentic customer feedback, and performing sentiment analysis with Python and innovative AI tools. Perfect for those interested in consumer behavior, data analytics, or business strategy, you'll get a firsthand look at how companies use consumer emotions and opinions to guide strategic decisions.

    Data AnalysisPythonAI & ML
  • Wayfair AI Agent Engineering for Business Intelligence Externship
    Wayfair AI Agent Engineering for Business Intelligence Externship
    Wayfair logo

    Wayfair · Aug 2026 · ✅ Verified by Extern

    Wayfair AI Agent Engineering for Business Intelligence Externship

    Learn one of the most in-demand skills shaping the future of work: building AI agents. In this externship, you’ll step into the role of an AI Agent Developer and use n8n to design agents that think, plan, and act on real data — automating insights, decisions, and workflows. No coding experience required. By the end, you’ll create a live dashboard powered by your own AI agents, gaining hands-on experience that applies to any role or industry — from marketing and consulting to product management and data science.

    AI Workflow DesignAI Agent DevelopmentPresentation SkillsWeb Scraping & Data Extraction

About me

Redefining what's already been defined. Curious about ideas, businesses and people who challenge the way things are.

I've always been curious about ideas : where they come from, what makes people believe in them and how some eventually become successful businesses. This curiosity has led me to explore startups from very different angles, from customer analytics and AI to market strategy and financial modelling. I'm also deeply creative: music has always been part of my life, and supporting women and people whose voices are often overlooked is something I genuinely care about.

Externships

Yinan Value Investing & Financial Modeling Externship

Yinan Zhao

Experience

Women's Strategy and Growth Lead - Previously Events Committee at Erasmus AI Society

Erasmus AI Society · Apr 2026 - Jun 2027

Online Marketing Intern

MyBestSeller · Jul 2026 - Dec 2026

Female Ventures Content Coordinator

Female Ventures · Apr 2026 - Jun 2026

Marketing Committee

Turing Students Rotterdam Association · September 2024 – January 2025

Venture Reshirt

Enactus Rotterdam Association · September 2023 – January 2024

Summer Job

Societé Générale · July 2024

Internship

TessiGraphes Design · February 2024 – May 2024

HighSchools Internships

KIPSTA Decathlon, Hauts-de-France Innovation Development Agency, W-Legal Law Office, Ferme de la Motte (occupational str · 2019 - 2023

Education

Rotterdam School of Management

International Business Administration Bachelor · Class of 2026

Erasmus School of Philosophy

Double Degree Philosophy of a Specific Discipline · Class of 2025

IE Madrid

Exchange Semester in Spain · Class of 2025

Marcq Institution

French Baccalaureate · Class of 2023

Skills

Data AnalyticsConsumer InsightsMarket ResearchBrand StrategySentiment AnalysisPython

✅ Verified by Extern

Beats by Dre Data Analytics: Qualitative & Quantitative Insights Externship

Explore how leading brands decode consumer conversations to create products that resonate. This externship offers practical skills in uncovering market trends, analyzing authentic customer feedback, and performing sentiment analysis with Python and innovative AI tools. Perfect for those interested in consumer behavior, data analytics, or business strategy, you'll get a firsthand look at how companies use consumer emotions and opinions to guide strategic decisions.

Data AnalysisPythonAI & ML

Overview

During my externship with Beats by Dre, I delved into data analytics to decode consumer conversations and identify market trends. I applied qualitative and quantitative methods to analyze customer feedback and sentiments, utilizing AI tools and Python. This experience enhanced my understanding of consumer behavior and equipped me with practical skills for strategic decision-making in business.

Beats by Dre Data Analytics: Qualitative & Quantitative Insights Externship

What I've accomplished

Throughout this externship, I engaged in various projects that honed my analytical skills and deepened my insights into consumer behavior. Below are the key tasks I completed, showcasing my ability to leverage data for strategic insights.

Project breakdown

View all works

✅ Verified by Extern

Wayfair AI Agent Engineering for Business Intelligence Externship

Learn one of the most in-demand skills shaping the future of work: building AI agents. In this externship, you’ll step into the role of an AI Agent Developer and use n8n to design agents that think, plan, and act on real data — automating insights, decisions, and workflows. No coding experience required. By the end, you’ll create a live dashboard powered by your own AI agents, gaining hands-on experience that applies to any role or industry — from marketing and consulting to product management and data science.

AI Workflow DesignAI Agent DevelopmentPresentation SkillsWeb Scraping & Data Extraction

Overview

During my externship with Wayfair, I developed AI agents using n8n to automate insights and decision-making processes. This hands-on experience involved creating a Moodboard Generator and a Consumer Trend Discovery AI Agent, aimed at enhancing Wayfair's ability to respond to market shifts and competitor actions swiftly, ultimately driving smarter merchandising strategies.

Wayfair AI Agent Engineering for Business Intelligence Externship
Google Docs
Access

What I've accomplished

I produced enriched prompt templates and multiple editorial moodboards, and I built an n8n workflow that ingested marketplace and social data, extracted attributes and clusters, and output a downloadable trend report with a demo video.

Project breakdown

View all works

✅ Verified by Extern · ⏱️ In progress

Yinan Value Investing & Financial Modeling Externship

Gain insider experience in value investing by analyzing leading stocks alongside seasoned investor Yinan Zhao. Learn how professionals leverage financial modeling in Excel, interpret alternative data, evaluate market trends, and craft persuasive investment recommendations. Build real-world skills essential for careers in finance, equity research, and investment banking.

Investment AnalysisFinancial Statement AnalysisFinancial ModelingData AnalysisExcel

Overview

The externship examined leading stocks through value-investing methods with guidance from Yinan Zhao. The work compared valuation approaches and applied financial models in Excel to analyze company fundamentals and market signals. Deliverables included financial models and written investment analyses.

Yinan Value Investing & Financial Modeling Externship

What I've accomplished

I selected and documented a Russell 2000 Value stock, and produced financial-modeling and written-analysis deliverables that evaluated company fundamentals and market signals.

Project breakdown

The module identified OPCH, then produced a web-based Stock Card. I designed a responsive HTML/CSS page showing ticker, price snapshot, an annotated price chart, event timeline, a short conviction note, and a target-price input component.

I located the company 10-K, read the Business Overview, Risk Factors, and MD&A, and consolidated extracted findings into a Google Sheets workbook. The submission showed organized qualitative notes and financial-context rows for analyst review.

Google Sheets
Access

I compiled a completed qualitative template for Option Care Health, extracting business description, segment drivers, competitor mappings, and a risks sheet pulled from the 2024 annual report. The submission produced a populated research workbook.

Google Sheets
Access
View all works