Harald Schelenz

• Annual budget • Monthly report • Ad-hoc report • Monthly accruals

• Annual budget • Monthly report • Ad-hoc report • Monthly accruals

• Own project: Developing a KPI dashboard to identify cost drivers and enable precise target setting • Supporting and improving the annual budget preparation • Coordinating, preparing and improving of annual budget presentations • Supporting monthly reporting activities based on data from SAP

• Own project: Development of an Excel/VBA based tool to automatically process and visualize financial data • Own project: Process optimization by creating an Intern Task Tool as well as by analyzing the cycle time for internal risk processes • Independent ad hoc risk evaluation of financial stability of suppliers based on annual report analysis • Plausibility check and validation of accruals and billings • Preparation and coordination of management documents and related communication processes

• Own project: Analysis and evaluation of regional potential for customer acquisition • Independent analysis of creditworthiness and loan applications • Preparation of on-site customer visits by researching and analyzing business model and competitors • Plausibility check and validation of bookings • Participation in a rotational program in Corporate Treasury Sales (e.g. interest rate swaps), Global Transaction Banking (e.g. letter of credits) and Leasing (e.g. payment collections)

• Own project: Construction of a tool box of consulting instruments • Own project: Creation of a benchmark for planning software • Plausibility check and validation of business plans • Preparation of reportings and customer presentations • Research and analysis of environment, market, competitors and company

• Own project: Creation of an Excel based multiple model for the energy sector • Support in goodwill impairment tests (WACC calculation, peer group analysis, plausibility check for forecasts) • Calculation of fair values using the net asset value method • Plausibility check of accruals by using a Monte-Carlo-Simulation • Data extraction via Bloomberg terminal access (interest rates, inflations rates, exchange rates) • Support in the creation of final evaluation reports and management presentations

• Own project: Management and implementation of phone interviews with high-ranking German executives • Support in market research projects, mainly in mystery shopping, individual interviews and group discussions • Management of data basis for contact and response status of participants • Follow up with overdue responses via direct call in French • Ad hoc translations of surveys, customer communications and video material from interviews

• Own project: Development and management of campaigns for local start-ups with Google adwords • Search engine optimisation (onpage and offpage) (creation of SEO articles, keyword analysis, competitor analysis, link creation in social media) • Participation in workshops about rights in online marketing, advertisement and landing page designing, email direct marketing, social media marketing