You're seeing this page as if you were . The main menu is still yours, though. Exit from immersion
Abdoulaye DiarraAD

Abdoulaye Diarra

Senior Data Consultant

€600/day
Gargenville, FR
8-15 years

Average response time: 1 hour

Freelancer profile translated to English.
Back to original language

About Abdoulaye

I am a senior Data consultant specializing in Business Intelligence within Microsoft BI (MSBI) solutions — SQL Server, SSIS, SSAS, SSRS — as well as Power BI, ODI, Semarchy xDI/xDM, and Business Objects.

I help organizations transform their data into levers for operational and strategic performance by offering integration, modeling, and decision-support solutions tailored to their business needs. Leveraging solid technical expertise and a deep understanding of business challenges, I enable my clients to make their data reliable, automate their BI processes, and accelerate their decision-making with dashboards and architectures that deliver measurable value quickly.

Result: reliable and visible indicators, increased responsiveness of business teams, and improved competitiveness in a demanding digital environment.

If you are looking to fully leverage your data to optimize costs, improve performance, or structure your BI strategy, I offer a quick diagnostic of your decision-support information system to identify immediate possible gains.
  • French

    Native or bilingual

Can work on-site
Gargenville (up to 50km), Paris (up to 50km)

Experience

  • MGEN
    BUSINESS ANALYST - Data Governance and Data Integration
    HEALTH AND WELLNESS
    January 2025 - Today (1 year and 7 months)
    Ensure the interface between business units (statistics, operations, finance, risk, marketing) and data teams (data engineers, analytics, architects) to transform business needs into robust, usable, and governed data solutions.
    Requirements Gathering and Formalization
    • Facilitate workshops with stakeholders
    • Challenge and prioritize needs
    • Formalize data use cases
    • Write detailed functional specifications
    • Define business rules
    Project Scoping
    • Define the target solution (functional architecture)
    • Estimate costs (effort, high-level planning, dependencies)
    • Identify risks and constraints
    • Anticipate impacts (migration, data recovery, acceptance testing)
    Project Management
    • Coordinate Business/IT/Data teams
    • Manage backlog and prioritization (tool: Jira)
    • Participate in sprints (agile mode)
    Documentation
    • Write acceptance test plans
    • Document flows and processes (Confluence)
    • Model business rules
    Acceptance Testing & Migration
    • Prepare test scenarios – Organize and manage acceptance testing
    • Anticipate migration needs
    • Optimize validation phases
    Data Governance
    • Contribute to data lineage – Define data dictionaries
    • Formalize validation rules
    • Participate in data quality initiatives
    Support
    • Analyze incidents – Identify causes
    • Propose corrective or palliative solutions
    Key Skills Expected
    • Functional Analysis - Project Management (Agile)
    • Data Culture (modeling, quality, governance)
    • Structured Writing - Tools: Jira, Confluence
    • Understanding of data architectures
    • Autonomy - Rigor and organization – Curiosity – Service-oriented
    Greenplum Semarchy xDI Microsoft Power BI Process Optimization Business Intelligence Solutions Expert
  • MARTIN BROWER
    BUSINESS ANALYST - Data Architecture BI
    LOGISTICS AND SUPPLY CHAIN
    October 2021 - December 2024 (3 years and 2 months)
    Mission within a strategic program for a global overhaul of the decision-support system, with the following objectives: Modernization of reporting and visualization solutions, Optimization of data flows and improvement of data quality, Migration of data integration tools.
    Data Modeling & Architecture
    • Design of the target data model: ODS, DWH, Data Marts
    • Development of conceptual, logical/physical, and physical models
    • Definition of data insertion and update processes
    • Writing mapping documents and integration specifications
    • Ensure data quality and consistency by implementing business rules and controls.
    Data Integration & Migration
    • Development of integration flows (interfaces, insert/update packages)
    • Administration, optimization, and maintenance of ETL flows - ODI
    • Automation and scheduling of processes
    • Migration to Semarchy xDI and industrialization of processes
    Reporting & Data Visualization
    • Migration of Business Objects / Cognos reports to Power BI
    • Creation of datasets from BO universes
    • Connection to sources in Import, DirectQuery, and Live Connection modes
    • Development of reports with Power BI Desktop, Service, and Report Builder
    • Creation of KPIs and indicators with DAX
    • Implementation of security (static and dynamic RLS)
    • Organization and administration of reports in Power BI Service
    • Development and deployment of decision-support dashboards
    Scoping & Analysis
    • Facilitation of business workshops and gathering of functional requirements
    • Formalization of technical and functional specifications
    • Comparative study of integration tools: ODI vs Semarchy xDI
    • Realization of a POC for migration to Semarchy xDI
    • Definition of development standards and best practices
    Added Value
    • Modernization and rationalization of the decision-support IS
    • Improvement of data integration flow performance
    • Data security and reliability
    ODI Semarchy xDI Microsoft Power BI Snowflake Oracle
  • CREDIT LOGEMENT
    SENIOR DATA/BI CONSULTANT - Development and Maintenance of the Decision-Support IS
    BANKING AND INSURANCE
    April 2018 - August 2021 (3 years and 4 months)
    My mission is to ensure the development, evolution, and maintenance of the Business Intelligence (BI) system within the IT department, guaranteeing the reliability, performance, and consistency of the data made available to business units. I am involved in the entire lifecycle of decision-support projects, from requirements analysis to production deployment and support.
    Analysis & Design
    • Analyze and formalize business needs in collaboration with users and project managers.
    • Study the impact of new requests on the existing architecture (data flows, models, performance).
    • Write detailed technical specifications based on business requirements.
    • Actively participate in design workshops and data modeling phases.
    Data Integration (ETL)
    • Develop and maintain decision-support data loading flows (data integration, transformations, consistency checks).
    • Create and evolve mappings, packages, and scenarios with ODI 12c, ensuring versioning and traceability of changes.
    • Optimize ODI processes (query performance, parallelization, flow tuning, handling large volumes).
    • Monitor loads and analyze any incidents related to data flows.
    • Initialization and monitoring of production deployments (MEP).
    Reporting & Delivery
    • Design, develop, and evolve reports using SSRS.
    • Adapt reports to user needs (indicators, dashboards, exports).
    • Ensure the performance and relevance of the reports provided.
    • Participate in the acceptance testing phase (strategy, execution, validation).
    • Monitor and resolve anomalies in coordination with support.
    Documentation & Governance
    • Write technical specifications and acceptance test plans.
    • Define the acceptance testing strategy (test scenarios, datasets, validation criteria).
    ODI SQL Server Reporting Services (SSRS) Data Modeling Business Intelligence Solutions Expert ETL

Recommendations

Be the first to recommend Abdoulaye

Help this freelancer shine by sharing your experience working together.

These freelancer profiles also match your criteria

AgathaA

Agatha Frydrych

Backend Java Software Engineer

4.7

(3)

2

BaptisteB

Baptiste Duhen

Fullstack developer

4.6

(4)

5

AmedA

Amed Hamou

Senior Lead Developer

4

(2)

7

AudreyA

Audrey Champion

Web developer

4.3

(3)

4

Education

  • Master's Degree in Computer Science and Decision Support
    University of Caen
    2010
    Sciences de l'informatique

Certifications

  • Querying with SQL Server 2012/2014
    Orsys
    2015
    Transact-SQL Data Analysis Data Modeling
  • Implementing Datawarehouse with SQL Server 2012/2014
    ORSYS
    2015
    Process Optimization Microsoft SSIS Master Data Management Data Integration

Skill set

Categories