Sami Boulechfar

Key contributor to data transformation initiatives, supporting strategic decision-making within France Active, a network dedicated to empowering socially engaged entrepreneurs. - Built and maintained 3 SQL data warehouses centralizing and standardizing data for three business units (guarantee, investment, financing) enabling cross-entity analytics and strategic alignment. - Automated 90% of financial reporting workflows by designing 4 ETL pipelines for data cleaning, validation, and integration. - Delivered executive Power BI dashboards, fostering unified decision-making and interdepartmental coordination. Presented insights to leadership during monthly strategy meetings. - Developed a predictive model supporting the Finance Department’s monthly forecasts and budget optimization. - Multi-project management and cross-team collaboration, coordinated with various teams : France Active Garantie, France Active Investissement and France Active Financement to address the specific needs of each entity. - Presentation of results to leadership, effectively communicated insights and recommendations, ensuring alignment between data and strategic goals.

Online data analysis with luxury brands - Developed 2 SQL data warehouses centralizing 30,000+ monthly rows from multiple sources, enhancing luxury brands analytics. - Built scraping workflows (Selenium, Appium) to monitor 20+ e-commerce platforms extracting competitive data on resale markets - Created 3 Power BI dashboards used by Cartier, Chanel, Hermès & Tag Heuer to monitor product availability, pricing trends and competitor strategies. - Conducted strategic analysis to help clients position themselves in the second-hand market. - Classified luxury products from store window images, enabling clients to monitor compliance with their policies by resellers worldwide. - Utilized Git extensively for effective version control management. - Provided guidance and training to juniors in online data production and extraction processes.

Data analysis to detect correlations between investment fund inventories and subscriptions to BNP Paribas Forex services. Conception and development of a BNP Paribas customer data analysis software to detect new commercial opportunities. - Conducted strategic analysis of the foreign exchange market with a team of business experts. - Acted as an intermediary between the technical team and the business unit to understand needs. - Extracted insights from investment fund datasets to identify factors encouraging BNP clients to subscribe to their Forex offers. - Design of a complex relational database schema in PostgreSQL, integrated with a REST API developed using FastAPI, and a data analysis software for investment funds. This tool, used by BNP's business experts, enables the detection of new business opportunities. - Managed projects using agile methodologies, including sprint management and organizing and leading weekly meetings with business and technical experts. - Detection of anomalies in data from BNP Paribas' Fund Administration (FA) service, contributing to the improvement of data quality.

Created a mobile app for interactive storytelling using Python, Flutter, and MongoDB. Designed a NoSQL schema for content publishing, user registration and engagement tracking. Tested internally and presented as part of portfolio projects.

Accelerate the extraction of association rules via relational analysis of concepts. - Researched and monitored advanced clustering techniques and recommendation systems. - Accelerated association rule extraction through relational concept analysis, reducing the number of generated concepts by 37% and the number of rules by 75%. - Developed a recommendation system in Python and C++ based on K-Nearest Neighbors (K-NN). - Authored a scientific paper and presented the results to a panel of experts.

Internship as an operator where I had to pack, move and unpack boxes.