José Pedrosa

Within the Digital Business Solutions team at Carmignac, I was responsible for orchestrating the transition of a historically on-premise data infrastructure to the Microsoft Azure cloud, while integrating strategic platforms like Salesforce. The objective was to dematerialize processes, improve the quality and speed of information access, and enhance system resilience.

Missions:

● Development and evolution of tools and reports

● Migration to Carmignac's new Product Repository

● Modeling of new data flows

● Optimization expertise

● Support to various business teams

Technical Environment:

SQL Server / T-SQL, MSBI (SSIS, SSAS, SSRS), PowerBI, Azure Devops, Azure Data Factory, Salesforce, Visual Studio, Git, ControlM.

Responsible for the development and maintenance of the ESGRM application, dedicated to the evaluation of Environmental, Social, and Governance (ESG) criteria, I contributed to the design and industrialization of the scoring methodology.

My role was to ensure the robustness, performance, and reliability of data processing and reporting processes. In particular, I helped transform the ESG data chain into a fully automated, reliable, and scalable flow.

Missions:

● Participation in the development of the new ESG scoring methodology.

● Integration of data providers (Sustainalytics, MCSI, Trucost, Carbon 4...)

● Creation, evolution, and optimization of calculation methods

● Optimization of existing procedures

● Creation of PowerBI reports

Technical Environment:

SQL Server / T-SQL, Aladdin by BlackRock, MSBI (SSIS, SSAS, SSRS), Power BI, Visual Studio, TFS.

Responsible for the development and maintenance of applications in the Private Banking domain.

Direct contribution to the improvement of tools (management reports, portfolio statements) and compliance with regulatory constraints.

Missions:

● Regulatory developments (MIFID2, ISF, IFI, IFU, GDPR)

● Evolutions of applications related to private banking document generation: management reports, portfolio statements, various bank correspondence

● Migration of the commission management tool (RCP – FIN SOFT)

● Technical support to business teams

● Development of technical documentation

● Optimization of existing SQL stored procedures

Technical Environment:

SQL Server(T-SQL), MSBI (SSIS, SSAS, SSRS), Power BI, TFS, Visual Studio, ControlM.