As the SQL Database Administrator at NGE INFRANET for the Région Auvergne Numérique project, I oversee the entirety of the company's database queries, including managing access rights and user roles. A significant part of my role involves implementing over 70 custom functions tailored for geoprocessing tasks and creating around 200 trigger functions powered by spatial data interpretation using PostGIS. My proactive contribution to project advancements has been vital. After thoroughly assessing PostgreSQL's performance, we made the strategic decision to migrate all processing tasks to PostgreSQL. This transition has dramatically reduced maintenance efforts, streamlined updates, and enabled instant delivery of deliverables. The impact has been immense, for more efficient and reliable data management across the board.

As a GIS Project Manager at SFR , I served as the main point of contact for sales teams, management, and various stakeholders, including deployment project managers. After analyzing the existing processes, my primary focus was on managing workflows and ensuring flexibility. My goal was to eliminate all manual manipulation by implementing streamlined processes. I began by setting up a PostgreSQL database connected to the ESRI suite and populated it with data streams from FME, sourced weekly, daily, and monthly. This eliminated the time-consuming manual work previously required. I also focused on enhancing data presentation for better decision-making, primarily using ESRI's Web AppBuilder. The new processes significantly reduced the workload. Tasks that used to take a week, including data import, conversion error handling, and manual layout adjustments, were streamlined into an automated flow. The result was a clean database and a seamless publication process, with no manual effort needed. The cartography and Data analysts team was particularly satisfied, as their heavy workload was greatly reduced. Overall, everyone was pleased with the improvements and efficiencies achieved.

Within the renewable energy project development team at EDF Renewables, I addressed various inquiries from different departments including land management, prospecting, project management, environment, and public consultations. My role involved providing and publishing data via Portal for ArcGIS after processing it with various tools such as PVSyst and WindPro, and implementing FME workflows for identifying suitable zones for PV and wind projects through multi-criteria analysis. I also established an automated workflow for land management, based on MAJIC data, parcels, and various cadastral data, to identify optimal areas for project installation. Additionally, I provided strategic and environmental constraints data to ensure smooth project implementation. Moreover, I was frequently solicited by the prospecting and public consultation teams to deliver strategic and quantitative maps for our prospects, aiding in more effective decision-making and project planning.

Wearing two hats, I serve as the main point of contact for our clients regarding our solutions, and I customize the integration of our deliverables into their information systems. What do we do? For whom? How? At Diagway, we conduct road inspections to detect various road pathologies using LCMS technology, 360-degree metric capture cameras, and our AI solutions for automatic detection and integration of highly accurate diagnostics. We adapt our deliverables to fit the information systems of our clients in both the public sector (such as departmental councils, metropolitan areas, and municipalities) and the private sector (such as road managers like Vinci Autoroute and Cofiroute). An important aspect of my role was developing industry-specific plugins for QGIS, and I was also fully responsible for managing the database.

Within the Exploration and Production (EP) division, I was responsible for integrating energy data into the ESRI suite and migrating databases from Oracle to PostgreSQL. Our database detailed each project with metadata such as project name, country, geographic scope, and various project-related information. After analyzing the existing data and deployed solutions, I proposed a more efficient management solution called GeoNetwork, specifically designed for handling metadata. This allowed us to standardize our data following the ISO 19139 standard for geographic information, providing a more streamlined and rapid data management process that is also free and produces high-quality standardized data. This solution was well-received by the entire geomatics team within the EP division. I implemented a process for converting existing data to the ISO 19139 format using Python and FME. In parallel with these tasks, we also responded to various inquiries from different field specialists.

As part of the Copernicus European project, I developed PL/SQL functions to handle complex spatial data processing tasks, ensuring the quality of spatial data topology. I created approximately 60 spatial processing functions. Additionally, I contributed to internal R&D projects aimed at optimizing SQL functions.

As a Surveyor Engineer, I have managed topographic projects by leading a team of four surveyor technicians. My responsibilities included planning missions, overseeing the execution team, and ensuring the accuracy of measurements in line with the execution plans. I maintained good relationships between the field team and project stakeholders, ensuring seamless communication and collaboration. I also supervised my team’s work, ensuring their development and efficiency. I handled the analysis and processing of data from GNSS receivers, executed VRD projects, and conducted land surveying tasks such as boundary markings and divisions. Additionally, I supported project monitoring, conducted surveys, and produced topographic, cadastral, and division plans. My expertise spans topography, topometry, cartography, and photogrammetry, including structure layout and volume calculations.

As part of the construction project for the largest airport in Oran, I had the honor of contributing to this monumental endeavor. As a surveyor, I was responsible for all topographic services, including topographic surveys, altimetric and vertical verification, and topographic layouts. I worked closely with the entire team, from construction managers and civil engineers to the project supervisor. This enriching and intense experience encompassed all aspects of spatial precision required for such a large-scale project.

My first steps into the professional world as a Geomatician began with the acquisition of spatial data. At SONATRACH, the National Petroleum Group, I conducted field surveys using Total Station, GNSS, and LIDAR. These surveys involved data collection, cleaning, and processing to align and pre-process the data, culminating in 3D modeling. For underground data, we utilized two ground-penetrating radars to extend our modeling capabilities. This comprehensive approach allowed us to successfully complete our mission in the middle of the desert, in remote and challenging locations.