Thomas Roulin

In the context of an international company, this project concerned the migration of an existing Excel solution managing bonuses and positions to a .NET desktop client, taking the opportunity to review the business processes, improve data and master data management and open access to all markets worldwide for data entry and report extraction.

The project's initial phase lasted one year, employing around four developers. Then, I took the lead of the development team and managed complete release cycles, including requirements gathering, planning, testing, deployment, and documentation for two years. I was involved from the beginning in all the business discussions, IT infrastructure, and software architecture.

Composed of a C#.NET client in WPF/MVVM, DevExpress library, a .NET Web API, and a SQL Server database, it is now used by more than 100 users and has significantly improved the daily work of the HR departments of this company.

The last brick of these financial data flows consisted of an Azure Data Factory, an Azure SQL Database, and a reporting layer with Power BI.

I've been involved in the design and maintenance at all stages, experimenting with advanced SQL concepts like partitioning, column store indexes, query optimization, and CI/CD implementation with Azure DevOps pipelines. I learned a lot about Power BI, getting the most out of it by working directly on the SSAS cubes.

These optimizations and the development of a monitoring engine allowed us to improve the end-to-end flow, from the financial consolidation generation to its availability in the reports, from a few days to less than an hour.

This project consisted of a platform to run quantitative analysis models and execute automated trades. From acquiring relevant data to sending trading orders, I was responsible for improving the overall architecture. Initially working alone, the team grew to include 10 members with cross-functional skills.
Over the months, the stabilization, optimization, and extension of the quality check coverage led to a considerable increase in the generated profits.