Aghilas Zouaoui

End of assignment: December 2022

OBJECTIVE: Make processed and analyzed data available to business teams via extracts or Power BI dashboards. Project management for web applications (creation of forms for studies, website with study results)

Assignments:

- Gathering and understanding needs from business teams

- Development of data pipelines, transport, and processing.

- Data provision: extracts, CSV or Excel report creation,

Power BI dashboard creation

- Maintenance and bug fixing for existing pipelines

- Migration of projects from Cloudera to Azure

- Automation of data pipelines

- Architecture support for retrieving external data via API

- Creation of user interfaces in PowerApp and PowerAutomate

- Project management:

▪ Gathering and understanding needs

▪ Writing specifications

▪ Agile Scrum methodology

▪ Writing user stories

▪ Schedule tracking (user stories)

▪ Writing contracts

▪ Development monitoring and testing

- Technical environment:

o At the beginning of the assignment (3 months): Cloudera, Hive, Hue, Py Spark, Alteryx.

o Remainder of the assignment: Azure, Py Spark, Python, Databricks, Snowflake,

PowerBI, PowerApps, Power Automates, Alteryx, Azure

Data Factory, Informatica cloud, Stone Branch,

Data Lake Gen2.

OBJECTIVE: Provide a centralized data platform. The data on this platform is intended to be consumed directly by business teams and also by the various applications created by the datalab.

Assignments:

- Make data available to data scientists

- Installation and experimentation on server or via docker:

▪ Dataiku

▪ Alteryx

▪ Nominatim/Etalab

▪ OSRM

- Technology experimentation:

▪ Speech to text: experimentation on transforming audio

recordings of home visits into text

▪ Image recognition: experimentation to retrieve

square meter surfaces from housing plans.

- Implementation of Keydream API: sending apartments that best match

user demand after distance calculation and weighting.

- Support for the sandbox platform architecture and the future

production platform

Role and Responsibilities

- Understanding business needs

- Data preparation

- Data provision

Technical environment:

Azure, Pyspark, Databricks, DataFactory, Sql Server, MongoDB and Docker

OBJECTIVE: Automate the creation of the revaluation summary for savings and retirement contracts on a Big Data platform.

Assignments:

- Business owner support

Role and Responsibilities

- Understanding business needs

- Writing business rules

- Transmitting documents to the IT department

- Development monitoring

- Anomaly reporting

- Correction tracking

- Participation in project progress meetings

- Writing a test plan

- Executing tests

Technical environment

- SAS and SQL testing via HUE