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

Teddy Malfait

Expert business process automation - Excel, VBA

€900/day
Paris, FR
15+ years

Average response time: 1 hour

Freelancer profile translated to English.
Back to original language

About Teddy

Passionate about organizational efficiency, I bring my business and technical expertise to design and develop simple and automated solutions for:

> Optimize the efficiency of your daily processes through automation
  • Production: streamlining processes, information flows, supply management...
  • Administrative: automation of invoicing & legal documents
  • Reporting: automated production and sending of dynamic reports. Simple or very sophisticated reporting. Excel or PowerPoint format. Possibility of a Web portal. Possibility of automated analysis, comments, and recommendations.

> Secure your decision-making with simulation models
  • Dynamic business plans, to simulate investments, quantify success factors, and determine financing needs (How much? When?)
  • Simulation of the profitability of complex commercial offers
  • Simulation of the impact of a modification of your current offer or a new offer on your market share. Cannibalization vs. market extension.

> Improve your organization's commercial attractiveness with optimization models
  • Construction of the optimal offer per customer segment, point of sale, region...
  • Optimization of offer pricing (in general, and in response to "custom" tenders)
  • Merchandising optimization


Aware of the specificities of each organization, I pay particular attention to:
  • A thorough understanding of my clients' issues, specificities, and business constraints
  • The design of configurable and flexible solutions to ensure their sustainability
  • The definition of simple and user-friendly solutions accessible to users

Note: daily rate varies depending on the nature of the missions and the required skill level. An initial meeting is therefore necessary to establish an appropriate quote.
  • French

    Native or bilingual

  • English

    Fluent

Can work on-site
Paris (up to 50km), Vannes (up to 100km), Nantes (up to 100km), Rennes (up to 100km)

Experience

  • Sephora
    Automated selection of the ideal offer by store/customer typology
    FASHION AND COSMETICS
    December 2021 - Today (4 years and 6 months)
    Paris, France
    As part of the sophistication of offer definition and staff reduction, design and development of automated tools under Excel and VBA to select the optimal offer by store typology.

    • Analysis of needs and operational constraints
    • Design of the architecture and principles of the new offer selection process
    • Development of the various tools needed in Excel, integrating multiple constraints, general (competitive positioning, brand strategy, negotiations, logistics...) or specific to each category (merchandising rules).
    • Integration of numerous business parameters for guiding recommendations and ensuring the approach's sustainability
    • Automation of information flows using VBA. Automated data feeding, optimized automated calculations, cross-typology summaries...

    Mission carried out within the #DataMarketing Numsight firm
    Process Modeling Modeling Automation Data Analysis Microsoft Excel VBA
  • carrefour media
    Analysis of the impact of marketing actions by brands
    AGRICULTURE
    January 2017 - December 2021 (5 years)
    Paris, France
    As part of the monetization of Carrefour's data and media for brands, design of the measurement process and development of the ROI analysis template.

    • Definition of the statistical method for adjusting control groups
    • Porting and adaptation of existing scripts to the new Carrefour systems (GCP/Big Query)
    • Design and development of the Excel impact measurement template
    • Design of the PowerPoint analysis presentation model
    • Monitoring of targeting and data production for impact measurements

    Mission carried out within the #DataMarketing Numsight firm
    Marketing Communication ROI Microsoft Excel SQL Google Cloud
  • Neovia - ADM
    Strategy and business plan for launching a new service
    AGRICULTURE
    September 2018 - June 2019 (9 months)
    Vannes, France
    As part of the launch of a new service for breeders and cooperatives, development of the strategy and associated business plan.

    • Market opportunity analysis and launch strategy development
    • Identification of cost and revenue centers (fixed and variable, direct and indirect, financial flows between group entities...)
    • Construction of a dynamic business plan model, allowing simulation of different hypotheses (commercial strategy, pricing, investments, customer acquisition and retention, etc.), and identification of the offer's success and profitability conditions under each scenario.
    Marketing Business Plan Modeling Microsoft Excel Market Research

Recommendations

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

  • MBA from HEC (formerly ISA)
    HEC School of management
    2000
    Stratégie, marketing, macro et micro-économie...
  • Engineer from Ecole Centrale de Lille
    Ecole Centrale de Lille
    1999
    Modélisation, statistiques, analyse de données

Skill set (29)

Categories