Sofian Guessab

Refonte totale d'un document excel pour la prise de décision: - Automatisation de scénarios immobiliers avec VBA - Instauration de nouvelles métriques - Fiabilisation et robustesses des données - Import automatiques des données clients

Assisting sales staff in their daily tasks: ● Pricing equity derivatives (vanilla/exotic options, swaps) ● Verifying flows for index and basket swaps ● Onboarding new clients (liaising with all bank stakeholders: legal, middle/back office, trading, etc.) ● Ensuring the rollover of positions at maturity ● Keeping the various reports related to the activity up to date ● Drafting termsheets Client analysis: ● Excel analysis of all client positions ● Excel analysis of swap prices based on trading requests

Designed and developed trading tools (Python): ● Creation of a database containing all SBL trades, single stock swaps and currency swaps, as well as events related to the trade lifecycle (recall, increase, etc.) ● P&L visualization for forward start swaps (cost, gains, repo, etc.) ● Pricing repo rates for specific SBLs. ● Indicators for managing dividend risks. Responsible for the SBL (securities borrowing lending) trading book: ● Ensuring coverage of uncovered positions in other equity books in the trading room ● Remunerating available inventory stocks ● Sourcing specific stocks to perform dividend swaps Maintaining legacy tools (VBA): ● Credit risk exposure for SBL ● Dashboard and daily report Index trading training: efp, dividend future

o Trading of cash, equity and bond collateral on loan/REPO deals to hedge exposures & reconciliation of SBL positions and collateral o Managing books and flows with traders on products handled by the dealing room o Carrying out daily checks to ensure that collateral and loans are settled & responding to the needs of Risk Management teams o Development and improvement of new procedures and controls to reduce the risk of potential mismanagement of collateral

Sales analysis for all products: ● Creation of an interactive dashboard with PowerBi featuring graphs and key data. ● Proposing areas for improvement to reduce costs and increase margins. ● Weekly reports. Complete overhaul of a service (Trade-in Pack): ● Analysis by category (telephony, computers, household appliances, etc.). ● Sales forecasting, price adjustments according to different scenarios ● Following a reorganization of the premises, I was able to participate in the data migration by working with the data scientist to gather data and create new features necessary for my analyses Participation in the creation of a new service: ● Assisting the project manager in client meetings ● Performing cost analysis for this service