Said AGHZOU

• Design and implement data migration strategies for large-scale application systems, including database schema evolution and data transformation workflows. • Develop Python-based tools and procedures to migrate user data and accounts between legacy and target infrastructures. • Implement secure identity migration processes using Keycloak, ensuring consistency and integrity of authentication data. • Build and execute automated migration workflows, including synchronization processes and API-based data transfers. • Write and validate migration procedures through extensive testing on staging environments using Pytest. • Monitor and support migration dry-runs, identify issues and improve tools and processes. Technologies: Python, FastAPI, PostgreSQL, SQL, Keycloak, Docker, GitLab CI/CD, Pytest, Poetry, uv, Shell.

-Developed Python utilities for CityJSON data processing: merging, filtering/subsetting features, transform to simplified format. -Automated validation and QA of CityJSON files using Pytest -Maintain and develop the code for updating the ML models -Enhance and evolve proprietary of calculation engine -Contribute to the ongoing improvement technical stack -Demonstrate advanced Python proficiency, clean-code architecture and strong problem-solving skills Technical stack: Python 3, Git, Github, CityJSONs, CI/CD, AWS (S3, boto3), PostgreSQL, Unit Tests, Integration Tests.

-Analyze and technically translate functional requirements. -Design and propose solutions in collaboration with the architect. -Perform back-end development in Python to implement required functionalities. -Write the test plan and execute tests to ensure deliverable quality. -Participate in software integration and validation of developed solutions. -Update technical documentation to ensure traceability and maintainability of solutions.

Skills: Agile Methodologies · Data Structures · GitHub · API Development

Client : Veolia / Python Backend Developer / Cloud Data Analyst GCP. The operating activities to be covered are for the Data part: -Interface monitoring -Corrective maintenance -Participation in the evolution of data models implemented in Big Query (GCP) -Follow-up of the evolutions of the business request (collection of the need) to the setting in production. These actions are carried out on GCP (Google Cloud Platform) tools supplied with data from back Office service tools (Finance, Purchasing, HR, Legal, etc.) as well as all the solutions developed around them such as reports data visualization (Google DataStudio, Google Sheet,...). Migration of a platform from version Python 2.7 to version 3.9 under the Flask framework as well as SQLAlchemy Text to SQLAlchemy ORM. Technical documentation of a platform developed in PHP: -Assimilate the application code of the solution. -Documentation of developments and procedures related to manual technical and/or functional administrative tasks.

-Management of the company's internal applications (statistical extraction tools, websites); -The automation of database or geomatics processes; -Data management (Scripting, Data analysis, Data science, Use of APIs, etc.); -The implementation and monitoring of projects such as the development of mobile applications or the expansion of the information system to other countries; -Virtualization. Technologies : Laravel 6/7, VueJS 3, MySQL, PostgreSQL, Linux, SQL, Python 3, Debian 9/10, PHP 7, JavaScript, JQuery, Bootstrap 4, Joomla 3.9

-Analysis of specifications -Design and management of the database (Mysql) -Development of algorithms for processing SQL queries -Management of user data of an E-Learning Moodle platform on CSV files -Development and redesign of responsive websites -Agile SCRUM method -International environment (development team) Technologies : Mysql, SQL, PHP7, Wordpress, JavaScript, JQuery, HTML5, CSS3, Boostrap, Serveur OVH et XAMPP, Trello et Taîga.

- Badge control with Syctom software (SPID and SYSPéau) - Data management in another software - Data processing in Excel

- Study and analysis of specifications - Development and improvement of two websites - database management (MySql) Technologies : PHP, HTML, CSS, Mysql et introduction en Symfony 2.