All projects

Automation and reliability of BI data flows

Integrating health and protection insurance data flows, automating processing and checking consistency.

Professional experienceBI data flows

An assignment from my professional background. No internal or confidential data is disclosed.

Abstract illustration of the main data flow — no internal or confidential data is shown.

Context

From February 2024 to March 2025, I worked through Apside within Harmonie Mutuelle’s BI team on health and protection insurance data flows.

  • Health and protection insurance data flows
  • Data from multiple sources
  • Data to consolidate, reconcile and reconstruct

Challenge

The challenge was to consolidate data from multiple sources and check its consistency to feed the BI system.

Objectives

  • Develop and update integration processes.
  • Extract, transform and consolidate data.
  • Check data consistency and reconcile sources.
  • Automate data reconstruction and loading.

Contribution

I contributed across the data flows: extraction, transformation, consolidation, reconstruction and loading. Power BI checks and reconciliation complemented these processes to address data reliability.

  • Developing integration and consolidation processes in SAS.
  • Automating data reconstruction with Python.
  • Automating integration and loading with PowerShell.
  • Implementing consistency checks and reconciliation with Power BI.

Work carried out

Developed and maintained SAS processes, automated reconstruction with Python, automated loading with PowerShell and consistency checks with Power BI.

Technologies

  • SAS
  • Python
  • SQL
  • PowerShell
  • Power BI

A similar challenge?

Facing a similar challenge? Let’s talk.

Describe your data, processes and objectives to discuss an engagement suited to your needs.

Discuss your project