My experience as a Strategic Consultant at SGS

My experience as a Strategic Consultant at SGS

 Arthur EVERARD

In this article, Arthur EVERARD (ESSEC Business School, Master in Finance Program – Master in Finance, 2023-2024) shares his professional experience as a strategic consultant at SGS Spain, the largest certification and verification company in the world.

About the company

SGS is a leading inspection, verification, testing and certification company headquartered in Geneva, Switzerland. Founded way back in 1878, SGS has grown over the past 140+ years into a global powerhouse in its industry. Today, SGS operates an expansive network of over 97,000 employees located across 2,600 offices and laboratories around the world. SGS provides critical services to clients across a diverse range of industries such as agriculture, food, pharmaceuticals, energy, mining, and consumer goods. The key services SGS offers include quality control, safety audits, supply chain security, verification testing, and certification services aimed at minimizing risk, improving operational efficiency, and ensuring regulatory compliance for its clients. In 2021, SGS reported impressive annual revenues of CHF 6.1 billion, showcasing the scale and market-leading position the company has established. SGS trades its stock publicly on the SIX Swiss Exchange and has maintained a very strong market capitalization around CHF 20 billion as of 2022, highlighting the company’s value and the confidence investors have in its ongoing growth and performance.

My internship

My missions

During my intensive five-month internship within the strategic consulting division at SGS, I gained first-hand experience driving key projects to identify new market opportunities for SGS clients across priority industry verticals. Working closely in a team of five interns, we successfully pinpointed high-potential new market entries in the rapidly growing areas of e-commerce, renewable energy, and smart city solutions. For each of these technology-driven verticals, I made key contributions in researching the competitive landscapes, analyzing growth drivers and trends, and formulating data-driven go-to-market strategies tailored to the client’s specific capabilities and needs. In addition to the core project deliverables, I worked adaptively to address over 15 distinct requests from clients, customizing our recommendations and insights to align with their feedback and objectives. Moreover, I continually demonstrated my ability to operate effectively under tight deadlines and high-pressure situations, consistently delivering high-caliber final deliverables across the 5 core project milestones.

Required skills and knowledge

The comprehensive overview provided across SGS’s operations, my contributions, and the key metrics studied highlight the diverse mix of strategic, analytical, communicative, and execution skills that are foundational for succeeding in high-impact consulting roles. The ability to formulate data-driven market strategies, address shifting client needs, operate under tight timelines, and quantify engagement outcomes using metrics like churn rate, cost synergies and market share growth will all serve me well for future consulting positions.

What I learned

By actively participating in full consulting engagements, I expanded both hard and soft skills critical for delivering impactful solutions. On the hard skills side, I honed my PowerPoint and data visualization capabilities, along with sharpening my structured approach to framing issues and developing strategies. Regarding soft skills, I improved my communication and relationship-building abilities in order to understand clients’ needs and maintain alignment. I also boosted time management, project coordination, and adaptability competencies by driving progress across fluctuating priorities and deadlines. Most importantly, I gained invaluable understanding of how the consulting world operates, from how engagement scoping and staffing works to techniques for guiding clients toward data-backed decisions. This 360-degree exposure undoubtedly provides me with a strong experiential foundation for launching my career as a strategic consultant.

Business concepts related my internship

Three key metrics we evaluated for the consulting project were churn rate, cost synergies, and market share growth. Churn rate measures customer losses – a low churn indicates customer retention and satisfaction. Cost synergies track cost savings from mergers or process improvements. Market share growth shows expanded business in existing or new markets. These metrics demonstrate the success of growth strategies for clients like SGS.

Churn Rate

Churn rate measures the percentage of customers that stop using a company’s products or services over a given period of time. It is calculated by dividing customer losses by the total number of customers at the start of the measurement period. A low churn rate indicates customers are happy and sticking with the company’s offerings. High churn means customers are leaving and switching to competitors – a major warning sign. For consulting firms like SGS, monitoring churn allows them to evaluate client satisfaction post-engagement. Low churn means clients saw value in the insights and strategies provided by the consulting team. High churn could indicate ineffective solutions or poor client management.

Cost Synergies

Cost synergies refer to cost savings and efficiency improvements achieved by combining operations and streamlining processes after mergers, acquisitions or other business integrations. Quantifying cost synergies helps companies like SGS demonstrate the financial upside of inorganic growth through M&A. It shows tangible bottom-line impacts. Specifically for management consulting firms, cost synergies can be generated by consolidating back office functions, integrating IT systems, and leveraging shared services post-acquisition. High cost synergies boost profitability.

Market Share Growth

Market share growth reveals how successfully a company like SGS expands within its core markets or penetrates new high-potential segments. It is measured by comparing the percentage of total market sales or customers held by the company over time. Increases in share signal effective strategies. For consultancies, market share growth validates their ability to win new business and expand wallet share with existing clients through cross-selling and new service offerings. It highlights the competitive positioning and growth trajectory of the consulting firm within its addressable industry advisory market.

Why should I be interested in this post?

For those interested in consulting, this experience offers very relevant preparation and perspective into core aspects of the job.

Related posts on the SimTrade blog

   ▶ All posts about Professional experiences

   ▶ Snehasish CHINARA My Experience as an External Junior Consultant with Eurogroup Consulting

   ▶ Pranay KUMAR My internship experience junior consultant at ZEBOX

Useful resources

SGS

About the author

The article was written in December 2023 by Arthur EVERARD (ESSEC Business School, Master in Finance Program – Master in Finance, 2023-2024).

My experience as a Business Analyst at HelloFresh

My experience as a Business Analyst at HelloFresh

Arthur EVERARD

In this article, Arthur EVERARD (ESSEC Business School, Master in Finance Program – Master in Finance, 2023-2024) shares his professional experience as a business analyst at Hellofresh Benelux, the largest meal kit provider in the world.

About the company

HelloFresh is a meal-kit delivery company founded in Berlin, Germany in 2011 by Dominik Richter and Thomas Griesel. The company ships preportioned ingredients and recipes to customers to prepare home-cooked meals. HelloFresh went public in November 2017, completing its IPO on the Frankfurt Stock Exchange. The company’s stock price rose significantly during the COVID-19 pandemic in 2020 and 2021 as demand for meal kits surged due to lockdowns and reluctance to grocery shop in-person. However, in 2022 the stock declined from its pandemic highs as consumers returned to pre-pandemic habits and inflation/recession concerns weighed on the stock price. Despite this drop, HelloFresh remains one of the largest meal kit providers globally. HelloFresh reported record revenue of €5.99 billion in 2021, a 62.5% increase over 2020, with adjusted EBITDA of €827 million. The company provides over 30 different recipes each week, shipping pre-portioned fresh ingredients and step-by-step instructions for dishes such as seared steak with mustard sauce, chicken enchiladas, and zucchini noodle Bolognese. HelloFresh carries over €1 billion in total debt but remains profitable, positioning itself as the largest meal-kit provider globally based on market share.

Logo of HelloFresh.
Logo of HelloFresh
Source: the company.

My internship

During my six-month internship at HelloFresh, I worked within the product development department on the HelloFresh Market. The product development department at HelloFresh is responsible for optimizing the HelloFresh Market, which is the section of the HelloFresh website that allows customers to add individual items to supplement their regular meal kits. The product development team analyzes sales data and customer feedback to determine the optimal mix of products to offer on the Market that will maximize sales and customer satisfaction.

My missions

I extracted data using SQL code and created pivot tables to analyze product and category performance. Using this data, I generated charts and visualizations that provided insights into growth opportunities. I also managed the database of over 4,000 products, monitoring demand and availability. Additionally, I led ten research projects focused on competitive analysis and predicting demand fluctuations in the Benelux (Belgium, Netherlands and Luxemburg) region.

Required skills and knowledge

Throughout my internship at HelloFresh, I developed a valuable mix of hard and soft skills. In terms of hard skills, I improved my Excel abilities considerably, including advanced use of pivot tables, lookups, and complex formulas. I also honed my PowerPoint skills to deliver impactful presentations. Regarding soft skills, I learned the importance of teamwork, time management, and public speaking. Collaborating with team members, prioritizing tasks, and presenting findings to stakeholders were critical.

What I learned

Additionally, I gained important knowledge specific to my role. I learned how to write and optimize SQL code to extract and analyze large datasets efficiently. My Excel modeling skills became sharper through regular use of data analysis, lookups, and visualizations. I gained useful insight into the food industry by managing HelloFresh’s extensive product database. The internship gave me valuable exposure to e-commerce operations and using data to inform business decisions. I also developed a deeper understanding of key performance metrics like AOV, ticket size, and repeat rate that guide strategy for online retailers. Overall, this internship provided me with marketable hard and soft skills and enriched my familiarity with the data-driven decision making crucial in food e-commerce.

Key concepts related my internship

I present below three key concepts that I used throughout my internship: Average Order Value, Ticket Size, and Repeat Customer Rate.

Average Order Value (AOV)

This metric calculates the average amount spent per order across all customers. It is important for e-commerce because it indicates whether customers are spending more or less per transaction over time. A high AOV signals customers are purchasing more items per order or higher-value items. Tracking AOV helps e-commerce optimize pricing, discounts, product selection, and cross-selling tactics to encourage larger basket sizes. In the department we used to check the evolution of the AOV of the week compared to the previous week.

Ticket Size

Ticket size measures the average number of items purchased per order by customers. Monitoring this shows if customers are adding more products to their carts from an order to another, which boosts revenue. A low or declining ticket size could indicate issues with product selection, bundles/recommendations, or that customers are running out of reasons to buy more per order.

Repeat Customer Rate

The repeat customer rate shows the percentage of customers that make more than one purchase with the company over two consecutive periods (say six months or one year). A high repeat rate is crucial for e-commerce profitability because acquiring new customers is more expensive than retaining existing ones. Repeat customers tend to spend more over their lifetime too. This metric indicates whether marketing efforts and customer experience lead to loyal, valuable long-term customers.

Why should I be interested in this post?

The overview of HelloFresh and description of the product development department would be useful reading for anyone interested in working in the food or e-commerce industries as an analyst or in a finance role. The details provided give insight into how data analysis and financial metrics are utilized at a meal-kit company to optimize product selection and drive growth. Understanding how databases are leveraged, performance is monitored, and strategic decisions are informed by data analysis is applicable for those pursuing analyst positions that require SQL, Excel, and visualization skills. Additionally, the explanation of key business concepts like average order value , ticket size, and repeat customer rate provides a look into e-commerce economics that would benefit those interested in finance roles focused on online retail and subscription businesses. In summary, the text illustrates responsibilities and skills sought after in analytical and financial positions at food and e-commerce companies.

Related posts on the SimTrade blog

All posts about Professional experiences

▶ Jayna MELWANI My professional experience as a Global Development and Learning Intern at Danone

▶ Fatimata KANE My internship experience as a marketing intern at Amazon

   ▶ Marie POFF Film analysis: The Wolf of Wall Street

Useful resources

HelloFresh

About the author

The article was written in December 2023 by Arthur EVERARD (ESSEC Business School, Master in Finance Program – Master in Finance, 2023-2024).

My experience as a Real Estate Analyst at Eaglestone

My experience as a Real Estate Analyst at Eaglestone

 Arthur EVERARD

In this article, Arthur EVERARD (ESSEC Business School, Master in Finance Program – Master in Finance, 2023-2024) shares his professional experience as a Real Estate Analyst at Eaglestone, a Belgian real estate developer operating in Europe.

About the company

Eaglestone is a real estate developer based in Brussels, Belgium and focused on commercial and residential projects across Europe. Founded in 2014, Eaglestone has already developed over €1 billion in real estate assets including office buildings, hotels, apartments and more. The company currently has around 15 ongoing projects spread across major cities like Brussels, Amsterdam, London and Lisbon. Eaglestone’s business model involves identifying promising development opportunities, securing financing, overseeing construction, and managing/leasing the completed properties.

Logo of Eaglestone.
Logo of Eaglestone
Source: the company.

My internship and missions

During my two-month internship at Eaglestone, I worked on several key projects. I compiled and presented detailed analyses on new London, Lisbon and Brussels investment opportunities (development for offices and residential buildings) to the CEO, including market overviews and financial projections. I visited three ongoing construction sites in Brussels to assist with leasing and sales strategies. Additionally, I reviewed financial models for major projects and provided input on funding options like special purpose vehicles (SPVs) and bullet loans (similar to zero-coupon bonds) to support Eaglestone’s equity and debt needs.

Required skills and knowledge

During my internship, I improved vital hard and soft skills. For hard skills, I honed my Excel modeling for feasibility analysis, project financing and timelines. I also gained PowerPoint presentation experience. Regarding soft skills, I improved at working independently, time management, public speaking and presenting to executives. Additionally, I learned enormously about real estate development operations and strategies. I became comfortable presenting analysis and recommendations to senior leadership. The experience provided me with tangible skills and invaluable exposure to the world of real estate finance.

What I learned

The overview of Eaglestone and my internship experience highlights skills and knowledge applicable to real estate finance and development roles. Understanding how to assess new opportunities, project costs and returns, and different funding sources provides useful perspective for those interested in real estate or project finance analyst positions. The work I completed, and metrics analyzed are directly relevant to finance departments at real estate companies.

Financial concepts related my internship

Three important financial metrics for real estate are return on investment (ROI), cash-on-cash return, and gross rent multiplier. ROI measures the profitability of an investment as a percentage of the total cost. Cash-on-cash return indicates the annual income generated by a property as a percentage of the total cash invested. Gross rent multiplier shows the relationship between purchase price and potential rental income. Tracking these metrics allows developers like Eaglestone to evaluate opportunities, fund projects strategically, and maximize ongoing returns. They provide vital insights into real estate investment performance.

Return on Investment

ROI measures the profitability of an investment as a percentage of the total investment (assets on the balance sheet). It is calculated by dividing net profit by total cost. ROI is useful for comparing different real estate opportunities, as it shows the potential profit per dollar invested. A higher ROI indicates a more profitable investment. Tracking ROI helps developers like Eaglestone allocate capital by comparing projects.

Cash on Cash Return

Cash-on-cash return shows the annual pre-tax income generated by a property as a percentage of the total cash invested. It provides a clear picture of the annual return. Cash-on-cash return demonstrates the ability to recoup the initial investment through ongoing rental or sale income. Real estate investors use this metric to evaluate the short-term returns on a project.

Gross Rent Multiplier

Gross rent multiplier compares the purchase price of a property to the potential annual rental income. It is calculated by dividing the purchase price by the annual rent. A lower gross rent multiplier means the property is more affordable based on the expected rents. This metric helps assess if the acquisition price for a development is appropriate given the usual market rents (used as a benchmark). It is an important consideration in the initial viability of a project.

Example

Please find below an Excel file to illustrate the three concepts above: return on investment (ROI), cash-on-cash return, and gross rent multiplier.

Download the Excel file to compute the present value of a stock

Why should I be interested in this post?

The overview of Eaglestone and my internship experience highlights skills and knowledge applicable to real estate finance and development roles. Understanding how to assess new opportunities, project costs and returns, and different funding sources provides useful perspective for those interested in real estate or project finance analyst positions. The work I completed, and metrics analyzed are directly relevant to finance departments at real estate companies.

Related posts on the SimTrade blog

   ▶ All posts about Professional experiences

   ▶ Clément KEFALAS My experience of Account Manager in the office real estate market in Paris

   ▶ Ghali El KOUHENE Asset valuation in the real estate sector

Useful resources

Creating tomorrow’s city together – Eaglestone

About the author

The article was written in December 2023 by Arthur EVERARD (ESSEC Business School, Master in Finance Program – Master in Finance, 2023-2024).