Matthieu FAUCHON

🎯 Context: As a Senior Data Analyst, I contributed to a strategic project aimed at maximizing the effectiveness of marketing investments by analyzing their impact on sales. 🛠 Actions Taken: Supervised the preparation and pre-modeling verification of data Collaborated closely with local and international teams to interpret the results of the Bayesian model Integrated data via a DBT pipeline and stored it in Snowflake Used Databricks and Python for data cleaning Managed Power BI dashboards for a holistic view of marketing expenditures Contributed to the development of the MATRIX tool to integrate data-driven decision-making 📈 Results Achieved: Successfully illustrated the influence of marketing decisions on financial outcomes Delivered strategic recommendations to executive and marketing teams Significantly improved the efficiency of analytical processes, reducing production time and enhancing responsiveness

🎯 Context: As a Senior Data Analyst / BI Engineer, I managed stakeholder requests in finance and strategy, contributing to projects for developing pipelines and dashboards. 🛠 Actions Taken: Developed DBT pipelines to automate data preparation Created dashboards in Tableau to visualize KPIs and key metrics Conducted in-depth analyses to establish financial and strategic indicators Implemented tracking tools for deposit remuneration, facilitating decision-making Immersed in a LEAN environment to improve efficiency and work methods 📈 Results Achieved: Increased team responsiveness through clear and actionable visualization tools Improved operational efficiency by adopting LEAN practices, reducing request processing time Strengthened strategic decision-making by providing reliable and relevant data Optimized financial processes, enabling better resource and cost management

🎯 Context: As a Senior Data Analyst, I managed the data needs for Nickel's sales department, covering 5 countries and serving around twenty teams. 🛠 Actions Taken: Maintained and developed the CRM feed via DBT/BigQuery and the Salesforce API Improved scoring algorithms for points of sale and fraud detection Developed and maintained 22 Google Data Studio dashboards Provided support for data analysis and ad hoc requests Built and maintained a perimeter of a hundred tables on DBT 📈 Results Achieved: Improved data quality and reliability of analyses for the sales department Enhanced fraud detection capabilities, contributing to better risk management Optimized reporting processes, enabling faster and more informed decision-making

🎯 Context: As a Senior Data Analyst, I was responsible for negotiating fees under the Clearing & Custody perimeter for the entire SG group, using data solutions to optimize expenditures. 🛠 Actions Taken: Conducted in-depth analysis of SG group's expenses using Excel, Power BI, and Python Implemented data solutions to gain an overview of fees and negotiate more effectively Utilized OCR and NLP techniques for extracting and analyzing textual data Collaborated with commercial teams to optimize processes and improve outcomes 📈 Results Achieved: Significantly reduced costs through more informed and targeted negotiation Improved fee management processes, enabling greater transparency and efficiency Strengthened commercial relationships with a data-driven approach, facilitating more favorable negotiations Increased data analysis capacity, leading to more accurate and actionable insights

🎯 Context: As a Senior Data Analyst, I was responsible for data exploration for central compliance control and risk management, developing predictive tools to improve incident management. 🛠 Actions Taken: Developed a prediction algorithm using Python to classify historical incidents according to compliance domains Created interactive dashboards with Tableau Prep, Tableau Desktop, and Tableau Server to assess compliance risks Established data governance to facilitate communication between data representatives across different domains and regions Used text mining, bags of words, and machine learning techniques for analyzing textual information 📈 Results Achieved: Improved accuracy in incident classification, enabling more effective risk management Increased visibility of compliance risks through clear and informative dashboards Strengthened communication and collaboration between teams, facilitating a unified approach to risk management Optimized decision-making processes by providing actionable insights, leading to faster corrective actions

🎯 Context: As a Structured Products Coordinator, I was responsible for overseeing trade support across multiple activities (Structured Capital Markets, Strategic Equity, Securitized Product Group, Principal Investments) within Global Markets, optimizing processes through data automation. 🛠 Actions Taken: Developed automated tools via VBA for precise calculation of cash flows and P&L, improving accuracy and reducing processing time Coordinated functions and activities involved in structured product transactions, ensuring smooth data management Conducted first-line controls (1LOD) to ensure data and process integrity Implemented data solutions to meet transaction approval committee (TAC) requests, providing data-driven analyses Served as the single point of contact (SPOC) for global markets regarding operational setup that cannot be managed through the STP chain, optimizing data flows 📈 Results Achieved: Improved operational efficiency through process automation, reducing errors and processing time Increased transparency and accuracy of financial data, facilitating more informed decision-making Optimized coordination processes, enabling better integration of functions and activities involved Enhanced analytical capabilities through the use of data tools, improving the quality of reports and recommendations

🎯 Context: As an Inspector at the Inspection Générale, I conducted international and cross-functional assignments to assess risk management and internal controls, using data-driven approaches to enhance audit effectiveness. 🛠 Actions Taken: Conducted in-depth data analyses to identify risks and weaknesses in internal control management processes Utilized data mining techniques and analytical tools to extract relevant insights and support risk assessments Communicated synthesized conclusions to executive management, accompanied by data-based recommendations to trigger corrective actions Collaborated with international teams to harmonize risk management practices across different regions Developed detailed analytical reports to improve transparency and understanding of risks within the organization 📈 Results Achieved: Improved accuracy and effectiveness of audits by integrating data analysis into inspection processes Strengthened risk management through the implementation of recommendations based on reliable and actionable data Increased transparency of risk management practices, facilitating better communication and understanding at the executive level Optimized control processes, leading to risk reduction and continuous improvement of internal practices