Freelancer profile translated to English.

Description

C# .NET and Data & Business Intelligence Developersenior with 12 years of experience, specializing in the design and development of backend applications, APIs, services in a .NET environment, and data solutions.

Expertise in client-server application development, REST API design, data modeling, and SQL and T-SQL query optimization.

Passionate about solving complex problems, transforming data into actionable insights, and continuously improving systems and processes.

Proven experience in the finance and portfolio management sectors, with a strong command of Microsoft technologies (C#, .NET Core, .NET Framework, Entity Framework, LINQ, SSIS, SSAS, SSRS, SQL Server, Azure Data Factory).

Effective collaborator with multidisciplinary teams to deliver robust, scalable, and high-performing solutions.

Industry field of expertise

Languages

French
Native or bilingual
English
Fluent

Workplace preferences

Can work on-site

Paris (up to 50km)

Candriam
Senior Microsoft BI and C# .Net Developer
PRIVATE EQUITY
May 2022 - December 2024 (2 years and 8 months)
Paris, France
Portfolio management company subsidiary of New York Life Investments
Run and TMA: As a Microsoft BI expert and .Net developer, I ensure the corrective and evolutionary maintenance of applications, SSIS packages, SSAS cube, SQL queries, SQL Server and Oracle stored procedures, and SSRS dashboards in the SCIS domain.
• Optimization of the C# .Net 4.8 & Oracle 19g integration batch for Indices and benchmark (file ingestion time improved by 100%, i.e., from 10 min per file to 1 min)
• Monitor production incidents on MSBI solutions (batches, server, etc.) and propose solutions.
• Optimization of SSAS cube response time by changing the dynamic dimension security model from a DLL to a dynamic expression in MDX.
• Development of PowerBI POCs on Sales indicators (AUM, NNC, etc.).
• Mentoring and onboarding of junior developers and new joiners on MSBI solutions.
• Participation in SCRUM agile ceremonies (daily, retrospective, sprint planning, review, refinement)
• Technical referent for Microsoft BI
• Azure DevOps (Git Repos, Agile Board, CI/CD deployment pipeline, Test plan, etc.)
Project Web Plan: As part of the redesign of their website, I joined the existing team as a Data Engineer to implement data feeding flows on an Azure ecosystem

Environments: Microsoft BI 2019 (SQL Server, SSIS, SSAS, SSRS), MDX, PowerBI, T-SQL, C# 12, .Net 8, .Net Framework 4.7.2, Oracle 19g, PL/SQL, Salesforce, Rest API, WCF, SOAP, Azure (SQL Server, ADF, ADLS, LogicApp…), Azure DevOps (CI/CD, Board, Test, …), Clean Code (Sonar, Code coverage, Unit test), Git, Agile Scrum
C# ASP.NET Core Transact-SQL SSIS SSAS
Crédit Agricole CIB,
Senior Microsoft BI and C# .Net Developer
BANKING AND INSURANCE
March 2019 - March 2022 (3 years)
Montrouge, France
Microsoft BI Expert & C# Developer
Run and TMA: As a Microsoft BI expert and C# developer, I was responsible for the operation of a risk reporting tool, which daily and/or weekly generates reports on market and credit risk indicators such as VaR, stress tests, P&L, limits, etc., across all of the bank's credit portfolios, making every effort daily to ensure that batches run correctly and that reports are ready for use before 9 AM.
• Resolution of incidents and production problems in an international architecture
• Enhancement of the market risk indicator reporting GUI (C# thick client)
• Corrective and evolutionary maintenance (MCE) and optimization of SSIS packages, SSAS cubes, SQL queries, and stored procedures
• Technical referent for Microsoft BI on the tool's architecture (N3 support on MSBI and Control-M servers)
• Enhancement of batch workflows on Control-M
• Technical and functional support to assist clients (end-users) in understanding and validating report results
• On-call duty on weekends and public holidays

Project CACIB obsolescence: As an MSBI expert, I was responsible for the processing and upgrade of all technical and application environments of the market risk reporting application servers.
• Upgrade and migration of server OS from Citrix, MSBI 2012 to 2019 (SQL Server, SSIS, SSAS)
• Remediation of SSIS packages.
• Acceptance testing and validation of each environment (Dev, Test, UAT, Prod)
• Define and validate the roadmap for production migration.
SSIS Microsoft Power BI Transact-SQL .NET C# SSAS
Ecofi,
Application Manager & IT Operations & BI Developer
PRIVATE EQUITY
May 2014 - January 2019 (4 years and 8 months)
Paris, France
Asset management company subsidiary of Crédit Coopératif bank
Application Manager & IT Operations & BI Developer
• Responsible for the operation of a portfolio of applications (Neoxam Tracker, Salesforce, Website,…)
• Resolution of incidents and production problems
• Supervision of project progress from scoping phases to production deployment
• Corrective and evolutionary maintenance (MCE) and optimization of SSIS packages, Talend jobs, SQL queries, and stored procedures
• Design and development of an internal rating limit calculation tool in C# and SSRS
• Design, development, and implementation of an application for calculating management fees in C#
• Design and development of data feeding flows for the reporting datamart using Talend
• Migration to Salesforce: design and development of Salesforce feeding flows with SSIS
• Migration to Drupal: design and development of website feeding flows with SSIS
• Migration to BPCE-IT: close collaboration with service providers and software vendors for the migration of applications and workstations to BPCE-IT Environments: Microsoft BI (SQL Server, SSIS, SSRS), T-SQL, C#, .Net, VB .net, Nexus, Salesforce (Apex, Visualforce), SAP BO, Reportive, Java, Talend MDM, Talend DI, Nexus, Drupal, MySQL, OVH, Agile
SSIS .NET C# Transact-SQL Microsoft BI SQL Server