Freelancer profile translated to English.

Description

I am Sekouna KABA, an experienced Senior BI & Data Consultant and Data Engineer, with over 9 years of experience in designing and operating new Data platforms. Excelling in creating tailor-made solutions, from initial design to implementation and operational maintenance. His skills cover the entire project lifecycle, closely integrating business needs, technical specifications, and enterprise architectures. Passionate about innovation and committed to delivering high-quality solutions that meet evolving client needs and operating in several business areas.

Industry field of expertise

Languages

English
Conversational
French
Native or bilingual

Workplace preferences

Can work on-site

Paris (up to 30km), Montreuil (up to 30km)

MSO-Soft
Data Engineer & Data Architect
DIGITAL AND IT
March 2024 - Today (2 years and 4 months)
Paris, France
Mission:
Implementation of a BI and DataLake solution in AWS (S3 bucket) as part of improving the performance of the company MSO-SOFT in property management.
Mission:
• Implementation of the postgres image in docker and volumes
• Ingestion of data from various sources to S3: Postgres
• Automation of data extractions from the CRM to the working directory with python
• Loading JSON and CSV files into the Data Lake on the S3 bucket - AWS
• Transformation and loading of data with DBT-core with different layers
• Definition and implementation of ETL practices, standards, guidelines, development patterns
and initialization of the catalog of reusable off-the-shelf components
• Definition of the logging strategy
• Creation of tests and documentation on dbt-core
• Creation of SCD historization scripts using djan in dbt
• Implementation of a CI/CD pipeline via GitLab
• Dashboard implementation
• Implementation of the multidimensional model on the star schema
• Feasibility and performance POC between Tableau and Power BI on the target database.
Technical Environment:
Docker, Postgres Image, Power BI, Currency API, JIRA, DBT-Core (ELT), Visual-code, Postgresql,
AWS S3, GIPS CRM, Python, Bash, GIT, AWS S3, GitLab CICD, AWS Glue (ETL), Draw.io, Jira
docker-compose Dockerfile Minio Airflow Metabase Apache Superset
Thales
Data Engineer
DEFENSE AND MILITARY
September 2022 - February 2024 (1 year and 5 months)
Vélizy-Villacoublay, France
Mission:
Implementation, evolution, and maintenance of a BI and DataLake solution for the Sales and Marketing Squad for all Entities. Building the ETL solution from scratch for the Thales group internationally.
• Implementation of data loading via Talend for the SMA DWH star model on MS SQL Server
• Ingestion of data from various sources to GCP: Storage/BigQuery
• Definition and implementation of ETL practices, standards, guidelines, development patterns
and initialization of the catalog of reusable off-the-shelf components
• Development of use-cases using Python (PySpark)
• Definition of the logging strategy
• Code Review of all Data Engineers' builds before deployment
• Implementation of a CI/CD pipeline via GitLab
• Support for the deployment of the Talend solution and user management
• Validation of CI/CD pipelines
• Study of the existing system and gap analysis for migration to Talend
• Migration of a legacy database from Azure SQLDB to AWS RDS
• Design of connectors/jobs
• Implementation of template jobs on APIs (Get, Post, Delete, and data pagination on
APIs)
• POC realization and presentation of SAP Hana
• Implementation of some KPIs on Tableau
• Implementation of the POC on dbt and Snowflake with Tableau, respecting the ELT principle which relies on the
database's capabilities
• Creation of advanced SQL queries and stored procedures.

Technical Environment:
Talend Data Management, Talend for BIG DATA, SQL SERVER, GCP, SAP BW, Code quality, Azure ADLS
GEN2, API Dynamics, JIRA, API MANAGER, GCP(BigQuery), Python, PySpark, Data Factory, Bash, AWS
S3, GitLab CICD
Accor November
Data Architect Meeting Facilitation Training Facilitation Team Spirit Workshop Facilitation
ACCOR
Data Engineer
HOSPITALITY
November 2021 - September 2022 (10 months)
Issy-les-Moulineaux, France
Mission:
Creation of a Data Warehouse on Snowflake and migration of data to Snowflake for the Sales BI team of all Accor group entities.
• Organization of workshops concerning the creation of the star model
• Scoping / Design / Development of flows
• Code review and organization of pair programming among Data Engineers
• Implementation of data loading flows with Terraform on Snowflake
• Data transformation with DBT Core on different layers
• Migration of On-Premises Talend 7.3 jobs to Talend Cloud 8 for Big Data
• Making production deployment requests after QA acceptance
• Build and Run of data loading pipelines on Terraform
• Implementation of execution plans on TAC
AGATE IT
8, rue de la Terrasse, 75017 Paris www.agate-it.fr
• Extraction of data from the data lake via Terraform into RAW data on Snowflake
• Data collection and integration
• Data transformation and loading into Snowflake with DBT
• Calculation of datamarts and aggregates / extractions (Snowflake Streams, Tasks, and Stored Procedures)
• Implementation of the business dashboard
Technical Environment:
Python (Pyspark), Talend for Big Data, Talend Cloud, DBT Core, Snowflake, Dbt, AWS/Glue, Azure, Oracle,
Sybase IQ, Terraform, MS-SQL, Shell, Java, GitLab, S3 Bucket, Streams, Tasks, Agile, Teams