Youcef A.

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.

Technical environment: PostgreSQL/Postgis, Pl/Python, PgAgent, Qt5, PyQGIS for QGIS, FLASK, ERP for Server.

 Programmation des nouveaux outils d’analyse

 Réalisation de cartes (cartes d’analyse thématiques, cartes d’analyse croisées, cartes

 Topographiques, cartes stratégiques objectives du développement, etc.)

 Administrateur de bases de données

 Développement PLP/SQL

 Création des applications ESRI / Arcgis

 Contrôle de la qualité des données de source et de production

 Automatisation des tâches de traitement et d’exportation de données

 Respecter le délai, les contraintes et les besoins de CCTP

 Chargé d’affaires [Grand Lyon, Nice, Grenoble, Toulouse...]

 Préparation des cartes interactives pour nos techniciens de mesures

As a GIS Project Manager, 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 for Arcgis.

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.

Technical environment: PostgreSQL/Postgis, Qt5/python, FME, Portal for Arcgis.