Yassir Sedjari

Implementation of a BI Connected Vehicle platform on GCP (Pub/Sub, GCS, SQL, LookML), with automated data pipelines and executive performance, quality, and decision-making oriented CCS dashboards. Design and deployment of a scalable BI solution on Google Cloud Platform (GCP) for CCS dashboarding needs. Implementation of automated data pipelines (ingestion, transformation, exposition) orchestrated with Airflow, leveraging Pub/Sub, Cloud Storage (GCS), and SQL. Data modeling and creation of the semantic layer via LookML, ensuring consistency, reliability, and standardization of indicators. Development of analytical dashboards for monitoring the performance of connected vehicles and services. Analysis of quality trends and production of strategic reporting for Engineering teams and top management (VP). Implementation of CI/CD pipelines with GitLab for deployment and maintenance of workflows.

Implementation of pipelines to collect, transform, and store large volumes of data (CRM, data usage, network logs) with Dataflow, BigQuery.

Design, transformation, and publication of customer data (CRM, usage) to enhance customer knowledge.

• Project management, business support, evolution of Big Data platforms (Teradata, Hadoop)

• Implementation of automated solutions on GCP with Terraform. CI/CD deployment via Gitlab CI, Ansible, and Python scripting. Diagnosis and correction of incidents, participation in detailed designs, Implementation of an automated file ingestion process to GCP: File deposit on Cloud Storage via API, SFTP, or partner feeds. Automatic triggering via Cloud Functions on event (finalize, delete, metadata update).

Development of Python Cloud Functions to: Validate the structure and metadata of incoming files (naming, format, size, date…), Perform preliminary processing (cleaning, parsing, filtering), Trigger downstream jobs (e.g., Dataflow job launch, API call, or Airflow DAG triggering).

Integration of external data of file type, web service calls, or TOPIC consumption (Webmethod universal messenger and Kafka) Configurations on Terraform SFTP Server.