Xavier Rousseau

Context

Short mission within a team in charge of decision-making dashboards related to risk indicators.

Objective: clarify business needs, analyze available data, and ensure the reliability of reporting used for management.

Achievements

• Analysis and reformulation of business needs concerning risk indicators

• Exploration of source data and assessment of its consistency

• SQL analyses to support understanding and validation of reporting

• Clarification and formalization of certain implicit business rules

• Contribution to the design of simple dashboards adapted to real-world usage

• Coordination with business and data teams

Results

• Better understanding of indicators by users

• Reduced ambiguity in reporting

• Improved reliability of decision-making analyses

Functional Environment

Decision-making risk management and analytical reporting in a banking environment

Technical Environment

SQL, Starburst, Oracle Analytics Cloud (OAC Dataviz), star schema modeling

Context

Mission within the Climate Analytics & Alignment department in a demanding regulatory environment.

ESG indicators were used for both regulatory reporting and internal strategic management.

Objective: ensure the reliability and security of complex indicators from multiple sources to guarantee consistency and decision-making clarity.

Achievements

• Comprehensive analysis of the data transformation chain (from source to reporting)

• Diagnosis of inconsistencies, calculation discrepancies, and potential biases

• Recalculation and harmonization of multi-source environmental indicators

• Formalization of business rules and documentation of traceability

• Implementation of quality controls to secure reporting

• Design of Power BI dashboards focused on strategic management

Results

• Stabilization of indicators used in sensitive regulatory reporting

• Improved transparency on calculation rules

• Reduced interpretation gaps between business and data teams

• Enhanced reliability of the ESG decision-making system

Functional Environment

Multi-source ESG indicators, regulatory reporting, strategic management

Technical Environment

SQL, Python, Power BI, Jupyter Notebook

Context:

Intervention within Product and Marketing teams to structure the understanding of search engine usage.

Usage indicators were heterogeneous and unstable, making it difficult to manage product evolution and marketing actions.

Achievements:

• Analysis of team needs

• Definition and structuring of usage-related KPIs (sessions, clicks, queries, engagement)

• Exploration and analysis of user logs to understand actual behavior

• Harmonization and stabilization of existing indicators

• Automation of recurring analyses in SQL

• Redesign and improvement of dashboards used for management

Results:

• Improved clarity of usage indicators

• Reduced interpretation gaps between teams

• Provision of more reliable and usable dashboards

• Enhanced team capability to manage using stabilized data

Functional Environment:

User behavioral analysis, product KPIs, marketing management

Technical Environment:

SQL, Apache Zeppelin, Kibana, Confluence, Jira