Skip to content
View ludodelot's full-sized avatar
🎯
Focusing
🎯
Focusing

Sponsoring

@marcoguillermaz

Block or report ludodelot

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Content in all repositories owned by your account will be closed.
Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. Markdown is supported. This note will only be visible to you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
ludodelot/README.md
Ludovic Delot — Business Intelligence and Data Analyst; Content Producer and Photographer

BUSINESS INTELLIGENCE · FINANCE · AUTOMATION · VISUAL STORYTELLING

LinkedIn · Email · Featured work

Profile

I build decision systems that connect business questions to reliable data products. At LVMH, I helped scale an Excel-based reporting workflow into a 20+ dashboard Power BI product on a 25-table model. Earlier work spans CPFR and supply-chain analytics at Groupe SEB, RPA investment analysis at El Puerto de Liverpool, and academic analytics at EGADE Business School.

Alongside data, I produce visual stories: festival photography for Live Nation / OCESA, content production for Tomorrowland’s Lab of Tomorrow, and client work through Delot Media.

Based in Mexico City · Mexican and French national · MSc International Management & Finance, Rennes School of Business

Animated terminal-inspired profile card summarizing Ludovic Delot’s role, experience, technical stack, education, location, and languages

Selected impact

  • 20+ Power BI dashboards scaled from an initial four, with shared KPI logic for Marketing, Commercial, Retail, Finance, IT, and Maison teams.
  • 25-table entity-relationship model connecting sell-out, stock, e-commerce, POS, product, launch, incentive, commission, forecast, and quota data.
  • Hours → minutes for recurring reporting preparation through Python-based cleaning and transformation.
  • 25,000+ SKU–store combinations analyzed for CPFR across 300+ retail locations at Groupe SEB.
  • 160+ creative clients served through Delot Media since 2019, alongside real-time festival and artist content production.

Featured projects

Builds equity portfolios from 105 US stocks using K-Means and hierarchical clustering across market, ESG, and categorical feature sets. The project focuses on segmentation and portfolio construction—not return forecasting.

Python · clustering · finance · ESG analysis

Studies return transmission and herding across the semiconductor supply chain using PCA, robust OLS, the CSAD herding test, and EGARCH volatility models.

R · econometrics · PCA · EGARCH · market behavior

Tests absolute Purchasing Power Parity between Mexico and France over 2020–2024 with OLS, then interprets why the evidence rejects the hypothesis.

R · exchange markets · OLS · hypothesis testing

Develops an integrated financial model for a bicycle-subscription business plan, including P&L, balance sheet, WACC, funding structure, and break-even analysis.

Excel · financial modeling · valuation · scenario analysis

Toolbox

Business intelligence
Power BI · DAX · Power Query · SQL · Tableau · Data Modeling · ETL · Data Visualization · KPI Governance

Programming and quantitative work
Python · R · Excel · Statistics · Econometrics · Machine Learning · Financial Analysis

Automation, AI, and development
UiPath · UiPath Insights · OpenAI API · Microsoft Copilot · Claude · Make · Notion · Google Cloud · AWS · Git · GitHub · PBIP

Creative production
Premiere Pro · Photoshop · Lightroom · Illustrator · Figma · Photography · Videography · Real-Time Editing

GitHub activity

Contribution calendar for the ludodelot GitHub account, including annual total and longest streak

Generated daily in this repository from GitHub’s public contribution calendar.

Animated monochrome ASCII portrait of Ludovic Delot

portrait.render(mode="ascii", palette="steel-blue")

Business Intelligence and data experience

LVMH · Data & Business Intelligence / Commercial Business Analyst

Luxury and Beauty · Mexico, France, and Spain · Feb 2025 – present

  • Coordinate BI delivery across Business, Data, IT, Beauty Tech, and analyst teams; translate requirements into KPI definitions, model logic, documentation, and data-quality controls.
  • Build DAX measures and Python ETL automation for Power BI-ready datasets across Google Cloud Platform and SharePoint sources; work in PBIP with GitHub version control.
  • Proposed and led the Excel-to-Power BI transformation for Loewe and Acqua di Parma, scaling the product from four to 20+ automated dashboards and establishing a shared reporting source for Mexico.
  • Built the 25-table model and an MTD Summary used by the GM LatAm, senior Key Account Managers, and Retail Managers; trained three people to automate the UK ETL process.
Role progression and additional detail

Data & Business Intelligence (Power BI) Intern · Iberia, Mexico, and global dashboards · Madrid · Jun 2026 – present

  • Support production delivery, anomaly detection, business-rule validation, and cross-market BI coordination.

Commercial Business Analyst Trainee (Remote) · France, managing Mexico’s BI operation · Aug 2025 – Jun 2026

  • Replaced manual workflows with self-service reporting used by Marketing, Commercial, Retail, and Maison HQ stakeholders in Italy and Spain.
  • Connected sell-out, stock, e-commerce, POS master data, retailer data, launches, incentives, commissions, forecasts, and quotas.

Commercial Business Analyst Trainee · Mexico City · Feb 2025 – Aug 2025

  • Built the first four dashboards and recurring sell-out, inventory, e-commerce, MTD/YTD, OOS, and lost-sales analyses.
  • Coordinated product master data and new-item setup for Chedraui and Elektra.

Power BI · DAX · SQL query logic · Python ETL · Data Modeling · KPI Governance · Commercial Analytics

Groupe SEB · National CPFR Supply Chain Data Analyst

Consumer goods · Mexico City · Feb 2024 – Aug 2024

  • Analyzed demand and inventory across 25,000+ SKU–store combinations for the company’s second-largest mass-retail client using Excel and R.
  • Identified out-of-stock, excess-inventory, and slow-moving patterns across 300+ locations; communicated recommendations to Sales, Marketing, Supply Chain, and Planning.

CPFR · Supply Chain Analytics · R · Excel · ETL · Data Modeling · Demand Forecasting

El Puerto de Liverpool · Automation Business Analyst

Digital Center of Excellence, Finance · Mexico City · Aug 2024 – Feb 2025

  • Evaluated the feasibility and ROI of a $27,000 USD UiPath Insights investment; the business case showed that it was not worth pursuing.
  • Designed RPA ROI dashboards and implemented performance monitoring for automation projects.

UiPath · RPA · ROI Analysis · Finance · Stakeholder Management

EGADE Business School · Data Analyst Intern

Faculty and Research Intelligence · Mexico City · Aug 2024 – Dec 2024

  • Built Power BI dashboards for publication output, SDG alignment, career development, and tenure analysis.
  • Used Python for cleaning and exploratory analysis, and the OpenAI API to classify academic articles.

Power BI · Python · EDA · OpenAI API · Academic Analytics

Content, marketing, and photography experience

Delot Media · Founder

Mexico City · Aug 2019 – present

  • Served 160+ clients across portrait, product, fashion, video, social content, and analytics work.
  • Managed sales tracking for 10+ concurrent clients and covered events at Autódromo Hermanos Rodríguez and Lunario del Auditorio Nacional.

Live Nation / OCESA · Photographer and content producer

Concert and Festival Business Units · Feb 2023 – Mar 2025

  • Official photographer for Vive Latino 2024, covering 12+ headline artists with same-day editing; delivered the highest official-account post volume on day two of Festival Arre 2024 while covering 9+ artists.
  • Produced press, backstage, short-form, and aftermovie content for festivals, concerts, and two internationally touring DJs at EDC México.

Tomorrowland · Content Marketing Producer, Lab of Tomorrow

Boom, Belgium · Jul 2026

  • Produced and delivered same-day short-form, long-form, interview, and digital-screen content across the entertainment-technology program.
  • Recorded and edited Lab of Tomorrow’s most-viral Reel to date.
More creative and marketing work

Piso 40 · Content Marketing Specialist · May 2024 – May 2025
Built the restaurant’s digital brand, photography/video system, content calendar, and KPI-led channel strategy.

COPARMEX University Chapter · Marketing & Communications Coordinator · Dec 2024 – Aug 2025
Worked with the President and Vice President on strategic initiatives and institutional alignment with Tecnológico de Monterrey.

Tecnológico de Monterrey · Marketing Communications Intern (“Storyteller”) · Aug 2022 – Jul 2024
Managed social content and event coverage, wrote for CONECTA, and delivered projects involving Holon IQ, Starbucks Mexico, and NFL Mexico.

Content Production · Photography · Videography · Adobe Creative Cloud · Content Strategy · Social Analytics

Education, leadership, and entrepreneurship

Rennes School of Business · MSc International Management & Finance

Rennes, France

Quantitative finance, econometrics, data science, Python, forecasting, portfolio optimization, risk simulation, financial modeling, and AI/fintech applications.

Tecnológico de Monterrey · BSc Business Intelligence

Mexico City · 97/100 · 3.8/4.0 GPA

Data-driven decision-making, database integration, Power BI and Tableau, Python and R, data mining, risk analysis, and communication. Scholarship for the highest entering GPA from high school; winner of the CDL campus phase for INC MTY 2023.

Leadership, venture work, certifications, and honors

President, Business Intelligence Student Committee · May 2024 – Jun 2025
Led representation and stakeholder communication for the Business Intelligence student cohort.

Projectype · Co-Founder, Finance and Technology Operations · Dec 2024 – Jun 2026
Owned budgeting, forecasting, profitability analysis, governance, and automated workflows built with Notion, Make, and Power BI.

Certifications
Microsoft Azure AI Fundamentals (AI-900) · Inside LVMH Certificate · Introduction to AWS · Google Cloud Foundations · SQL for Finance Professionals · Financial Statements in Power BI · Notion Essentials, Advanced, and Certified Admin · Claude Code 101 · McKinsey Forward · TOEFL ITP

Honors
Winner, Banorte Ideation & Prototyping Challenge · Winner, Patagonia Conscious Capitalism and Story Prototyping Challenge · Winner, CDL Campus phase · 100% Venture Lab Summer Sprint Scholarship

Languages
Spanish (native) · English (professional, TOEFL ITP) · French (elementary)


Business intelligence with commercial context. Visual work with analytical discipline.

Connect on LinkedIn · Send an email

Pinned Loading

  1. python python Public

  2. r r Public

    Collection of R scripts for statistical analysis and data exploration.

  3. sql sql Public

  4. power_bi power_bi Public

  5. tableau tableau Public