Hello, here

Yann Triquet

Senior Developer .NET / SQL

Hi !

.NET C# developer with 20 years of experience, helping companies design robust and high-performance applications. Expert in SQL and Visual Studio, I work on demanding projects from insurance to automotive industries. Reliable and responsive, I bring my expertise to optimize your developments and accelerate your success.

I currently live in Loiret (45), but I am geographically mobile, in France or internationally.

  • Name Yann Triquet
  • Birth 1975
  • Experience 20 years
  • Country France
  • City Orléans (45)
  • EMail ytriquet@gmail.com
  • Phone +33 6 64 52 85 77
  • Freelance 01 april 2025
  • Mobilité Everywhere
Download Contact me

Skill

.NET Application

Application design

ASP.NET, WinForm, WPF, API

SQL Database

Relational database

SQL Server, SSMS

Consultant

.NET design

SQL Server

Technic

IDE, automatisation, API

Framework, nugget, cloud

Design and maintenance of .NET applications

Experienced .NET Developer with over 20 years of expertise in designing and developing robust applications in C#. Mastery of the .NET ecosystem (Framework and Core), with in-depth expertise in ASP.NET (MVC, Web API), WPF and WinForms. Significant experience in the insurance, retirement, military and automotive industries, where I developed and maintained mission-critical applications.


In the insurance field, I contributed to the redesign of a contract management system in ASP.NET and SQL Server, improving performance and user experience. For a military project, I developed a WPF application optimizing the management of sensitive equipment and stocks. Also experience in software architecture, integration of web services (REST, SOAP) and optimization of SQL Server databases.

Design and optimization of relational databases

Expert in SQL Server database design and optimization, with more than 20 years of experience in modeling and developing high-performance and scalable solutions. Mastery of normalization principles, indexes, views, triggers and stored procedures to optimize performance and guarantee data integrity.


In the insurance sector, I designed and optimized a complex database for contract management, significantly improving query times and the scalability of the system. In-depth experience in SQL tuning (indexing, execution plan, partitioning), transaction management and data access security.


I also worked on data integration and transformation with SSIS (SQL Server Integration Services), notably for a critical database migration project in the retirement sector.

Experienced .NET Consultant

With over 20 years of experience in .NET development, I work as a consultant to help companies design and improve their business applications. My expertise covers the entire development cycle, from requirements analysis to production deployment, including database modeling and application performance optimization.


As a consultant, I provide valuable insights into modernizing software architectures, implementing best practices (SOLID, DDD, TDD), and adopting Agile methodologies. I have in-depth expertise in integrating web services (REST, SOAP), automating deployments via CI/CD (Azure DevOps), and optimizing SQL Server databases.


My ability to understand business challenges and collaborate with various teams enables me to deliver solutions tailored to clients' needs while ensuring the sustainability and performance of applications.

IDE

Microsoft Visual Studio (2005-2022)

SQL Server Management Studio (SSMS)

SQL Server Profiler

Microsoft SSDT (SSIS, SSAS)

IIS 7 (Serveur HTTP)

TFS / GitHub

Office

Microsoft Access (VBA, BI, SQL Server)

Excel, Word (Automatisation VBA)

API

Microservices RESTful

Web API .NET Core

API REST / Swagger

SOAP / PostMan

Framework & Nugget

.NET Framework 4.7

ASP.NET Core

EntityFramework, System.Data

WinForms, WPF, Blazor

XUnit, Log4Net

Cloud computing

Azure App Services

Azure SQL Database

Azure DevOps

Azure Container

  • Experience

  • Malakoff Humanis (45)

    Insurance Sector

    C# .NET Developer

    Since 03/2023

    During my time at Malakoff Humanis, I had the opportunity to work on strategic projects related to healthcare cost management within the Pleiade information system.
    As a .NET Developer / SQL Server specialist, my role was to ensure the evolution and optimization of critical applications used for processing reimbursements and managing supplemental health insurance contracts.

    I notably developed a high-availability REST API enabling the automatic registration of a dental estimate based on the image of the estimate provided by the healthcare professional.


    Technology: C#, ASP.NET, VS 2022, TFS, REST API, SQL Server, Swagger, PostMan, RabbitMQ

    Architecture: Microservices, Monolith

    Methodology: V-Model, Agile

    Environment: Windows, Azure DevOps

    Quality: Code review, Sonar Cube

    Team size: 15 developers

  • Thales (78)

    Defense Sector

    C# .NET Programmer Analyst

    03/2022 - 02/2023

    During my mission at Thales, I worked on the backend of the NCOP application, a key solution for NATO enabling real-time visualization and sharing of critical operational information.

    My role was to design, optimize, and secure backend services in .NET, aggregating data flows to ensure the reliability and performance of the platform.


    Technology: C#, IIS7, Virtual Machines, Windows Services, VS 2012, VS 2019, GitHub, SOAP API, REST API, SQL Server

    Architecture: Multi-layer (N-Tiers), Client-Server

    Methodology: Agile, DevOps

    Environment: Windows, Windows Server, Azure DevOps, SharePoint

    Quality: Code review, Sonar Cube

  • Essilor (91)

    Optical Sector

    C# .NET / SQL Server Programmer Analyst

    01/2021 - 02/2022

    During my mission at Essilor, I worked on the development and optimization of business applications dedicated to order and optical lens production management. As a .NET Developer / SQL Server specialist, my role was to ensure the performance and reliability of the tools used by production and logistics teams.

    I contributed to the development and improvement of applications in C# and ASP.NET (MVC and Web API). I also developed an SSIS project for billing data transfer.


    Technology: C#, VS 2019, GitHub, SQL Server, SSIS, SSMS

    Methodology: Agile, DevOps

    Environment: Windows

    Quality: Code review

  • Crédit Mutuel - EID (45)

    Insurance Sector

    C# .Net Programmer Analyst / Technical Architect

    10/2018 - 09/2021

    During my mission at Crédit Mutuel, working as a consultant via CGI, I played a key role as a C# .NET Programmer Analyst and Technical Architect, contributing to several strategic projects related to insurance management and document processing. My expertise in .NET development, architecture design, and SQL Server databases enabled me to deliver robust and scalable solutions while advising teams on best practices.


    Technical Web Support: As part of the launch of a new internal service center, I acted as a technical web support, guiding teams in development and architectural best practices. I was a key point of contact to help team members improve their skills and ensure the technical quality of deliverables.


    Insurance Document Processing Project: Developed a new document management tool for generating and sending PDF letters, SMS, and emails for the insurance sector.


    Manager Console Project: Developed a web application for back-office insurance managers to streamline client case management.


    Technology: C#, VS 2015, ASP.NET, Web Services, .NET DLL

  • Humanis (41)

    Insurance, Retirement Sector

    .Net / .Net Core Technical Expert

    05/2017 - 09/2018

    I joined a newly created team called "Service Division," focused on developing Web APIs with an architecture close to REST Microservices. These APIs were designed to expose data securely (HTTPS, OAuth2, JWT tokens, gateway) for both extranet and intranet applications while enabling rapid deployment (estimated at 20 hours per iteration). The microservices expose data owned by a monolithic system.


    Technology: VS 2012, C#, REST API, Microservices, SSIS, MSMQ, .Net Core, OAuth 2, XUnit

  • ETAI (45)

    Automotive Sector

    .NET Developer / VBA / SQL

    05/2005 - 05/2017

    AMOA, Developer: In the automotive data department, my responsibilities included maintaining the link between the IT and production departments. I worked as a business analyst, developer, and trainer.
    After creating the production program (called PDR), I was responsible for its evolution, maintenance, deployment, and training. The PDR system runs on two SQL servers, is used by 50 employees in France and Tunisia, and processes 4 million records every month.


    .NET Developer / VBA: Development of .NET Windows Form / Console applications under Access.
    Creation of an ergonomic ETL based on the "SqlBulkCopy" class.
    Development of an image enrichment tool using metadata.
    Implementation of a synchronization tool between two NAS servers via FTP protocol.
    Automated bitmap processing (VBA + ImageMagick).
    Development of catalogs (Data extraction + automatic layout).
    Creation of a DataGridView (.NET) inspired by Access UI.


    Database SQL Server Developer: Database modeling and design.
    Stored procedures development.
    CLR SQL Server (Scalar function, table, aggregate, and user-defined type).


    Technology: MS Access, Visual Studio, VB.NET, VBA, SSIS

-->

Contact me