Romain Ecanvil

Project: Support in the implementation of internal management dashboards on Power BI.

• Data modeling from ERPs Excalibur and Sages 100

• Creation of analysis reports (Revenue, Gross Margin, Value Added, Operating Gross Margin, Operating Income)

• Training of the internal team on Power BI

Project 1: Migration of the MSBI 2008R2 solution to SQL Server 2016 in 2 phases.

The first phase is the migration of the ODS, Dataware, and worldwide Datamart part (1TB RAM, 10TB database space)

The second phase corresponds to the migration of the CRM Datamart (1TB RAM and 7TB database space)

• Coordinate and manage operational teams (DBA, ControlM, Infrastructure, Monitoring, and Datalake) and development teams in an international context

• Implementation of a scrum meeting

• Normalize the ControlM chain

• Change management workshop

• Monitoring and updating technical documentation

• Contribution to the steering committee and Steering

Project 2: POC of a versioning solution within the BI project team

• Gather requirements from the Sephora BI domain manager

• Deployment of a Team Foundation Server 2018 server and demo of versioning functionalities

• Creation of an Azure DevOps, Bitbucket, and GitHub project in SaaS

• Comparison of Git and TFVC versioning systems

• Audit of processes in place within project and TMA teams

• Provisional deployment plan for the versioning solution

• Definition of a branch strategy

Project 3: Creation of a mobile and web reporting application to track worldwide revenue and budget for stores in real-time or for past dates.

Role: Management of the operational part in collaboration with several domains such as the BI, Cashing, and System teams

• Monitoring the installation of BI and Front servers (API and Web)

• Implementation of AD groups

• Drafting documentation with the help of various teams

• Definition of monitoring

• Management of the technical solution choice for scheduling store servers and central TP.Net

BI/Project Owner consultant in the commercial data management team of the NATIXIS-BGC (Corporate Banking) Datewarehouse. Design and modeling of Reporting applications for Sales and Traders for mass and analytical analyses primarily around Client Contribution and Sales Credit.

• Specification, study, development, testing/validation, production monitoring for new market risk indicators (CVA, DVA, and FVA)

o TSQL (SYBASE IQ), BO Universe, Control-M, SSAS Cube, C# and XML/XSLT

• Compliance: Add new indicators following the MIFID II reform

o TSQL (SYBASE IQ), BO Universe, Control-M, SSAS Cube, C# and XML/XSLT

• CPN1: Implementation and evolution of flows (PRIIPS, Customer Vetting, etc.) to generate first-level control alert reports for Sales and Managers.

o TSQL (SYBASE IQ), BO Universe, Control-M, and XML/XSLT

• MOA/User Assistance: Analysis and understanding of indicators, data issues, Excel on the 3 OLAP cubes and Business Object

• Integration of new trading data flows (Summit, Sophis, and Murex) into the Datawarehouse

• Technical referent for databases and Control-M scheduler

• Optimization of indicator calculation performance (Sybase IQ)

• Optimization of processing chains (+500 Control-M jobs)

• Sybase IQ 15.4 to 16 version upgrade testing

• Monitoring of server and Control-M v6 to v8 version migration

• On-call duty for Project Ownership evenings and weekends

• Talend POC execution

• Big Data: Execution of a project to archive customer search logs on Hive

o Scala, Spark v2, Eclipse, Hive, HBase, Ambari, SQL