Yanis Atsi

Mission 1: Creation and enhancement of Power BI reports: Gathering business requirements: Analysis and formalization of client needs. Establish necessary queries for monitoring accounting flows. Extract data from various sources. Perform transformations within Power Query ETL. Create SQL and DAX queries for measures, calculated columns, and custom visuals. Generate reports for monitoring the accounting chain of different jobs. Analyze, track, and correct anomalies. Deploy reports on Power BI Service for centralized and secure access. Configure automatic and scheduled report updates for regular data refresh and implement and manage roles. Create technical and functional documentation.

Mission 2: Development of a Machine Learning model (XGBoost) to predict unsettled trades, including data cleaning (Python) and visualization in Power BI dashboards.

Research and development of optimization solutions for solving combinatorial problems using resolution methods for optimization (Exact and approximate methods). Solving knapsack problems, clustering problems, Gray wolf genetic algorithms, Memetic.