Philippe Cattan

Price studies, Inflation, assortments, Cross-store benchmarking, counting, forecasting… Ad hoc. Manage the production of studies within deadlines, quality, and margins. • • Creation of non-standard studies at the request of major distributors, based on precise specifications. • • Analysis using big data (field survey sources, web, scanning) ✓ Weighted inflation studies by volume, sales ✓ National and local price index studies for major distributors ✓ Dashboards, counting and assortment studies, Insights ✓ Price competitiveness study, price divergence study between the national brand, distributor brands (premium or standard), organic and economy brands using a clone and link system (product matching) according to client hierarchy or not. ✓ Non-food or fresh produce studies (fruits and vegetables, butchery, poultry, bakery..), Sales forecasting. Update results on a cloud platform with scenario planning in the form of historical graphs (Power Query, Dax). Client presentations in debrief meetings.  On average, 1000 studies delivered per month with 98% client satisfaction and on-time delivery.  Team training. Writing documentation, improving processes. Supporting the technical skill development of teams on Oracle SQL, Python. Implementing new tools and KPIs to anticipate problems and manage alerts.  Productivity gain. Quality: Increase client satisfaction and decrease the number of complaints/adjustments of studies through production and presentation quality, adherence to client specifications, budgets, and deadlines. Definition, implementation, and management of KPIs via dashboards => adherence to delivery times, minimization of rework. Communication of results to top management and sales teams => increased client orientation and decision-making. Implementation of an alert system with data validation.

• • Development of non-standard studies for distributors with SQL. • • Data Engineering, data preparation, data cleaning, data quality verification, and study production. • • Studies with multi-source cross-referencing (big data, databases, field surveys, distributor scanning data, web data, promotions…). • • Management of large study programs: from production to quality verification, data integration into their databases, results presentation.  Multi-country studies for REWE (Eastern Europe), and major French distributors for European studies.

• • Production of studies based on price surveys for major distributors in Europe, calculation of inflations, price indices. • • Cross-country studies, inflations, feasibility, and implementation of client studies (client hierarchy, relationship with field teams..).  Management of 200 to 300 complex international studies/year.