A B.

Complete structuring of an SME's data system: modeling, flows, automation of reporting obligations, and implementation of pilot reporting.

– Design and modeling of the business data system (billing, accounting, inventory)

– Definition of data flows and business management rules

– Automation of reporting obligations (VAT, installments, accounts filing) — compatible with Sage / ERP

– Implementation of reporting and pilot indicator restitution via Power BI

– Contribution to a customer data management project (GDPR)

Stack: Power BI · MySQL · SQL · Sage / ERP · Excel

Project 1 · Data Hub / Data Visualization

Support and maintenance of a BI report park of over 2,000 reports. Management of rationalization and Cloud migration to Snowflake / Power BI.

– Requirements gathering, Agile/Scrum ceremonies facilitation, backlog management (incidents & evolutions)

– Management of BI report park rationalization: user workshops, gap analysis Data Lake → Data Warehouse → target

– Support for Cloud migration to Snowflake / Power BI

- Implementation of Power BI security roles (RLS)

– Data analysis in PySpark, MicroStrategy report design

– User story writing, functional specifications, Confluence documentation; Jira/Xray testing coordination

Project 2 · SimpliFi Program — Finance Data Steward

Construction of a common financial foundation for the Allianz Group (harmonization of accounting & financial reporting of subsidiaries).

– Analysis of SAP ABAP accounting flows and Finance data publications (input PySpark, output API)

– Data modeling in workshops with Allianz entities and lead Data Modeler

– Data mapping, dimension inventory, securing migration to the Data Pool

– Promotion of Finance data ownership; provision of consolidated data to the Group

Stack: Snowflake · Databricks · Power BI · PySpark · DBT · MicroStrategy · AWS · Informatica IDMC · Data Vault · SAP S/4 HANA

Implementation of the new default definition (Basel III standard) in the Internal Rating Model. Design of a quality control system delivered to the Risk Management Department.

– Requirements gathering, business analysis workshops, writing functional specifications (BCC, data dictionary)

– Design and validation of business rules; functional architecture of the Datamart

– Definition of a data quality indicators dictionary and management of the associated dashboard

– Full testing management: test cases, non-regression, anomaly tracking (Squash / Mantis)

Stack: SQL Server · SSRS · Oracle Data Integrator · Squash TM · Mantis