Elie Adechi

SQL Server / Azure Data Factory - Implementation of financial data integration flows from various ERPs (SAGE X3, SAP, DESK, CIS, ODIN, etc.) for financial consolidation and reporting - Consistency check between operational ERPs and accounting ERP.

• Audit of the existing system and understanding of needs.

• Proposal of a complete architecture of flows following the medallion principle.

• Creation of environments and development branches on SQL Server and Azure DevOps.

• Development of ADF pipelines for integration, transformation, and provision of dimension and fact tables.

• Collaboration with a Data Analyst and business stakeholders for defining needs and indicators.

• Implementation of data governance and accessibility processes according to GDPR.

• Complete documentation of the architecture and flow documents.

• Development of data engineering culture and skills within the IT department and business units.

SQL Server Migration to Microsoft Fabric: Design and implementation of data integration, storage, automation, and optimization solutions for data flows, data quality, and data security.

• Gathering business and user requirements for data from various systems (SAP, Salesforce, SuccessFactors, ADP, etc.).

• Definition of the medallion architecture and workspaces, data models, storage structure, and deployment pipelines.

• Development and industrialization of integration, transformation, and centralization flows for data from various applications and systems using pipelines, spark notebooks, stored procedures, etc.

• Development and industrialization of data provisioning flows for reporting or interfacing with other systems.

• Management of data governance and access according to GDPR (encryption, masking, RBAC, RLS).

• Management of secrets on Azure Key Vault.

• Monitoring of jobs and capacity metrics.

• Participation in team meetings.

• Writing technical and functional documentation.