Ilyasse Richa

For 5 years, I have been supporting banking and insurance players in the implementation and evolution of their BI solutions: data warehouse, master data, data quality, and steering reporting.

I am aware of the specific challenges of the sector (regulatory, indicator reliability, traceability, data governance) and I help business teams to have reliable and actionable KPIs.

Technical Skills

• Semarchy xDM: master data modeling (customers, contracts, products…), business and quality rules, validation workflows, duplicate management, quality indicator monitoring.

• Data Governance & Quality oriented towards the banking/insurance context (traceability, compliance, inter-system consistency).

• Integration & Processing

• Oracle Data Integrator (ODI): mapping and package design, orchestrations, dependency management, performance optimization on large volumes.

• SQL: feeding business datamarts (risks, regulatory reporting, commercial steering, claims…).

• Data Visualization & Reporting

• Power BI: modeling, DAX, Power Query, interactive dashboards, publication

• Qlik (Qlik Sense / QlikView): load scripts, associative modeling

Types of missions I undertake

• Implementation or redesign of BI foundation for banking/insurance: data models, feeding flows, customer/contract/product master data, data quality.

• Creation of Power BI / Qlik dashboards for: commercial steering, portfolio monitoring..

• Business support: requirements gathering, KPI definition, mock-up, development, acceptance testing, deployment, and skills transfer.

• Optimization of existing systems: report performance, indicator reliability, definition harmonization, documentation, and best practices implementation.

My way of working

• Business and regulatory oriented approach: understanding challenges.

• Smooth collaboration with IT and business teams