John Emil Lundberg

Experience

• 

  Clas Ohlson

  Sept 2018 - Aug 2022

  Clas Ohlson is one of the largest omnichannel retailers of non-grocery household goods in Northern Europe, employing over 4,500 people and operating across Sweden, Norway, Finland, and Germany. Available both online and in 220 physical stores with over 30% of the Swedish population, 3 million people, in the customer loyalty club.Supported the central Product Management & Sourcing department with their quarterly strategy plans; providing customer insights, leading change management, and managing stakeholders across other teams. Achievements:- Designed and implemented an assortment planning process across 45 product categories with a total average sales uplift estimated at 6%- Implemented three new off-the-shelf customer and competitor insights tools for the function: Prisjakt Analytics, Google Merchant Center, and Panelista which have been ranked as the most useful insights sources in an internal survey- Educated over 20 coworkers in the three-stage course for Power Pivot and advanced MS Excel analysis to improve internal analytics capability Show less Lead the development of a new corporate pricing strategy in collaboration with a team of BCG consultants to improve sales and profits. Achievements included: - Designed and proposed a new corporate pricing strategy to the senior leadership team which got approved. Presented this strategy to over 100 senior stakeholders- Developed a new Power BI dashboard to measure and visualize CPI (​​Competitor Price Index) to guide CFO & CEO monthly decision making- Prototyped a rule-based dynamic pricing tool in Power Query that resulted in an average sales volume uplift of 30%- Developed a pricing model in Excel and Power Query to calculate the optimal market price per SKU for over 3000 products, resulting in estimated time savings of 50% of manual price update Show less Supported the strategic project Category Reset that aimed to improve in-store merchandising to boost sales and profit. Initially worked with BCG consultants, then with internal Project manager once consultants left. Was responsible for all data analysis and KPI reporting for the project.Achievements included: - Developed a statistical performance dashboard using DAX and Excel to measure sales in test stores and control stores to calculate the uplift of new in-store merchandising. The insights guided the senior leadership team and CEO in their decision-making of 15 business categories, resulting in an average sales uplift of 5% per category- Developed a promotion evaluation model in Excel and evaluated more than 3,000 products to calculate baseline sales and identify promotion uplifts to generate insight for the commercial leadership to base decisions on for future promotions Show less

  • Business Insights Lead

    Aug 2021 - Aug 2022

  • Senior Pricing Specialist

    Apr 2020 - Jan 2022

  • Business Insights Analyst

    Sept 2018 - Apr 2020
• 

  Talabat

  Aug 2022 - now

  Senior Insights Specialist

  Talabat is part of the global food platform Delivery hero and MENA region’s largest food delivery and grocery platform, operating in seven different countries: Kuwait, United Arab Emirates, Qatar, Egypt, Oman, Bahrain, and Jordan.Currently responsible for analyzing and reporting the performance of Q-commerce vertical and creating recommendations for growth and profitability to managementAchievements:- Designed a commission structure for 7 markets which is estimated to drive 5% profitability growth across the MENA region- Implemented an incentive scheme for the account managers and sales executives to focus internal efforts on the new strategic direction of the business with an average achievement of 99%- Created a weekly and monthly performance reporting framework with core KPIs to keep management informed on performance and target tracking progress Show less