Zaki Abdelwahed

► Dashboard creation: Creation of dashboards with Tableau Software to replace Excel reporting. The goal is to optimize the monitoring of commercial activity indicators by eliminating the reporting development step in favor of analysis.

✅ Achievement: Estimated 30% time savings, or 80 days per year

► Project management: Implementation of a Data Mart for the sales department of BNP Paribas Factor. The objective is to create a single data source containing the essential data needed for commercial activity management.

► Reporting construction: Querying the necessary data for report creation, joining different data sources, consistency checks, and formatting.

► Dashboard creation: Creation of a dashboard with Plotly Dash (Python) to track orders where shipping costs charged by the carrier exceed shipping costs charged to the customer.

► Project management: Preparation of commercial files up to the establishment of the factoring contract; Evaluation of implementation deadlines; Development of backward planning; Preferred intermediary between the sales department and transverse departments.

✅ Achievement: 50 contracts per year on average

► Sales: Analysis of client needs; Pricing of prospect contracts with the aim of balancing competitiveness and profitability goals; Development of commercial proposals; Participation in tender responses; Monitoring of commercial relationships.

✅ Achievement: nearly €2,000,000 in Net Banking Income generated

► Analysis: Financial analysis of French and foreign companies; Economic analysis of the business sector of prospects and clients; Analysis of audit reports; Drafting of credit committee reports summarizing the operation of the factoring contract in place or to be implemented, as well as any associated risks.

✅ Achievement: Drafting of 6 reports per year on average

► Compliance: Adherence to compliance directives (KYC) related to any new business relationship; Identification of the sensitivity level of countries of operation; Guarantee of compliance with procedures related to the implementation of the factoring contract.

► Data: Creation of reporting to optimize commercial activity management; Guarantee of data reliability; Resolution of anomalies (duplicates, incorrect data, etc.); Automation of financial analysis of French companies; Automation of risk assessment related to countries of operation; Research and collection of data on prospect companies.