Data Engineer for the City of Geneva• Developed QlikSense dashboards adhering to best practices for production, cost, and consumption data management.• Optimized QlikSense data table structures to enhance efficiency and ensure reliability.• Refactored cost and consumption calculations by incorporating specific technical parameters for greater accuracy.• Authored comprehensive documentation on dashboards and data table structures, tailored for both technical and non-technical audiences.Internal Proof of Concept on Microsoft Fabric• Established a demo environment on Microsoft Fabric to explore and evaluate its technical capabilities.• Managed LakeHouse environments in Microsoft Fabric by implementing ETL pipelines using PySpark notebooks and medallion architecture.• Generated synthetic data to simulate data lake and data warehouse scenarios for testing and analysis.• Documented a comparative analysis of Microsoft Fabric versus traditional Azure Services, highlighting the pros and cons.

Data Engineer Azure Consultant InternAssisting in the migration and integration of an on-premise architecture to Microsoft Azure Cloud.• Implemented ETL pipelines on Azure Data Factory using both time-driven and event-driven triggers.• Transformed and loaded data from SAP and on-premise Microsoft Server databases into the Azure environment.• Developed SQL queries tailored to the specific needs of cross-functional users.• Optimized and monitored pipeline performance to ensure efficiency and reliability.• Automated metadata-driven pipeline creation through Python scripting, increasing operational efficiency.• Documented pipeline architecture and dependencies to provide clear guidance for ongoing and future projects.

Réalisation d'un Proof Of Concept dans un environnement AWS en utilisant les services AWS Lambda, Transcribe, S3, Sagemaker Augmented AI. Développement Python et NodeJS.