Consultante en analyse de données et Business Intelligence
Data-on est un cabinet de conseil et d’expertise dans le domaine de la data et de la business intelligence basée dans la région Parisienne.
Réalisations :
● Création et diffusion des rapports d’analyse à partir de Power BI.
● Import et transformations des sources de données dans Power Query.
● Création des mesures DAX
● Participer et aider à la formation POWER BI des nouveaux consultants.
● Préparer et passer avec Succès des certifications sécurité RGPD et Power BI PL300.
JURIDICA est une filiale du groupe AXA, spécialisée en protection juridique.
Au sein de l’équipe DATA/BI, j’ai participé au développement d’une solution décisionnelle permettant d’afficher un rapport décisionnel destiné au DSI de JURIDICA dont l’objectif est le suivi de l’activité téléphonique de l’entreprise (la solution permet de collecter les données des appels provenant du système d’information opérationnel de l’entreprise, les intégrer automatiquement, calculer les KPI demandés et représenter l’information dans des layouts spécifiques. Finalement, restituer les données sous forme des tableaux de bord et des rapports).
Réalisations :
● Compréhension des besoins métiers et analyse des spécifications fonctionnelles.
● Rédaction des spécifications techniques détaillées.
● Extraction et chargement de données sources à travers des packages SSIS.
● Développement de procédures stockées, fonctions, indexes
● Intégration des données dans le data Warehouse (SQL Server 2016)
● Tests unitaires des développements
● Conception du modèle de données
● Import et transformations des sources de données dans Power Query
● Création des mesures DAX
● Création et diffusion des rapports d’analyse aux métiers concernés à partir de Power BI.
PROJECT 1 - SIRENE
A program that aims to migrate all gas day simulation products from the Legacy Data Center (On Premise) to
the AWS cloud.
Achievements :
● Create the CI/CD factory for the program : Gitlab-ci, Terraform, Docker ...
● Create the cloud infrastructure on AWS all as
Migration of legacy data from an Oracle database and NaS disks to AWS (20 billion rows per Oracle
partitioned table and 10 TB of data on Nas) : AWS DMS, Aws File Gateway, Lambda, Aws Data Sync,
…
● Create a real time application performance monitoring Hub (APM) and analytics Dashboard : Aws
ELK (kibana), grafana, cloudwatch logs & alarms, Aws kafka
● FinOps : Recommandations et optimisations, Cost Intelligence Dashboard, Cost and usage Reports
& Alarms,
● Product Architecture: ToGaf Standards, Security & CAB validation , HeadLess & MicroServices
Architecture.
PROJECT 2 - RIO
A program that aims to migrate all legacy GRTGaz products to new stacks built on AWS cloud.
A total of 20 major products to be migrated, including transaction application, pipeline management stack,
reservation and distribution of gas in France.
Achievements :
● Accompany Rio in the creation of the Cloud Architects team. Its aim is to set up the common
applications technical architecture (Headless, Microservices, ...), Devops/CI/CD practices, Security &
Cloud rules for all products throughout the program (+90 developers) .
● Product Architecture: Togaf, validation with enterprise architects, CAB validation and security
validation (application & cloud) , PO & Business requirements.
● Create the RUN management and monitoring Dashboards for all products (Elasticsearch, Grafana,
aws cloudwatch groups & alarms, metrics sns, …)
● Create an ETL platform (Airflow on EKS) which will take care of the transfer and transformation of
legacy data from the Data Center to new architectures on cloud.
● Cloud FinOps, recommendations and optimizations of the MongoDb / Atlas databases.
● Follow and supervise good practices in the design of APIs, product architecture diagrams.
● Provide support and guidance to development teams on the CI/CD, IaC and data engineering.
● Participate in the implementation of agility (SAFe, Scrum & kanban) in the program.
● Participate in the recruitment of employees according to the needs of the teams.
Technical Environment :
HeadLess, REST, ApiGee, GraphQL, AWS (Serverless/lambda, ECS Fargate, EC2,
ElasticSearch / kibana, CloudWatch, EKS, S3, DynamoDb, RDS, Route53, ApiGateway, ALB, NLB,
XRAY, ...), Terraform, Gitlab-Ci, JIRA, NodeJs, Python, SpringBoot, Airflow, KAFKA (MSK), ….
I had the following consulting missions :
➔ GRTGAZ - ( Domain : European leader in gas transport )
A mobile SDK Ads (Android & iOs) embedded in +500 Voodoo mobile games and downloaded by +2 billion
users
Achievements :
Implementation of the Voodoo Ads Sdk architecture (Clean Architecture, Multi-threads, high
performance, Header bidding, real time processing, …)
● Participate in the training of a team of 7 developers (Android & iOs)
● Participate in the implementation of good mobile development practices (Clean Code, Testability, test
coverage, quality control with sonar and TI / TU, GitFlow)
● Implementation of the continuous integration factory and continuous deployment (Jenkins on AWS,
Faslane, AWS Mobile Farm)
● Creation of a Data pipeline on AWS cloud to collect +2 Millions/hour logs and events from Voodoo
games (RedShift, Lambda, Kinesis, firehose, nodejs, Kibana / ElasticSearch, Airflow).
● Contribute in the creation of an Android version of the SDK iOs Voodoo Ads (Clean architecture,
Kotlin, Dagger, Kotlin Kapt, Retrofit, RxAndroid, Picasso, ...)
PROJECT 2 - SDK Voodoo Sauce
A Unity sdk embedded in +1500 Voodoo games and other Unity Studios and downloaded by +10 billion users.
Achievements :
● Refactoring of the Voodoo Sauce Unity SDK architecture to facilitate the integration and update of
external publishing SDKs (FacebookAds, AdMob, Vungle, IronSource, …)
● Implementation of the continuous integration factory and continuous deployment (Jenkins on AWS,
Faslane, AWS Mobile Farm)
● Restructuring and management of a team of 6 Unity developers.
● Creation of a Data pipeline on AWS cloud to monitor the performance of each third-party sdk (Latency,
timeouts, fraud, …) ~ 1 Million events / hour
● Implementation of good mobile development practices (Clean Code, Testability, test coverage, quality
control with sonar and TI / TU, GitFlow)
● Improve / Track GDPR Popup performance in Voodoo games
Mobile payment SDK (HCE, SCM) with management of Wallets, multi-cards, transactions, etc.
Achievements :
● Implementation of the Antelop Payments iOs Sdk architecture (Async, Secure REST, Multi-Threads,
Event Sourcing, …)
● Integrate, Builder, adapt the C/C++ Framework for securing Antelop Payments transactions, wallets
and cards for the iOS SDK.
● Create a "SampleBank" application to showcase the SDK features.
● Implementation of the development, continuous integration and continuous delivery factory: Automate
everything
● Automate the generation of documents and deliverables (Cocoa Framework, Swift & ObjC)
● Setting up the PCI-DSS process for iOS developers
PROJECT - B2C Mobile Applications
Generali's B2C applications:
● My Generali Client Application.
● AMapp mutual health insurance application.
● Application for monitoring reimbursements and claims (iNomeneo, Verif, Autofocus, etc.)
Achievements :
● Creation, evolution and maintenance of GENERALI's B2C mobile applications
● Maintenance and improvement of the android and iOs development factory.
● Improved mobile development processes
● Maintenance and improvement of functional and unit tests
PROJECT - Mobile Applications
Applications dedicated to the management of JcDecaux advertising furniture :
● Advertising furniture management and pricing tool
● Location applications, maintenance monitoring of JCDecaux advertising furniture parks.
● Support applications for...
I had the following consulting missions :
➔ VOODOO - ( Domain : Global leader on mobile games )
Mobile & Data Solution Architect