Abdelkarim Lasnami

• Implementation and optimization of ELT pipelines for several clients in various sectors (retail, energy, mobility, events).
• Integration of new data sources into BigQuery via Fivetran, SFTP, and API, ensuring GDPR compliance.
• Development and data modeling with dbt to structure fact and dimension tables suitable for analytical needs.
• Implementation of dbt best practices to validate data quality.
• Maintenance and optimization of existing BigQuery queries to improve performance and reduce processing costs.
• Automation of transformations with Dataflow, Dataproc (spark) to process large volumes of data.
• Creation and optimization of advanced analysis models, including an RFM model for customer segmentation.
• Deployment and monitoring of data workflows, ensuring their performance and scalability.
• Data visualization and reporting via Looker Studio to provide actionable insights to business teams.

**Technologies**: Python, SQL, BigQuery, GCS, Cloud Run, Cloud Functions, Dataproc(spark), Compute Engine, VPC, Cloud Scheduler, Cloud Build, Artifact Registry, Pub/Sub, Workflows, Airflow, Looker Studio, Google Sheets, DBT (Incremental, Generic tests, snapshots, …), Github Actions

• Participation in the implementation of the migration pipeline architecture (POC).
• Contribution to data consolidation using DBT.
• Training staff on the use of DBT and code architecture best practices.
• Data preparation for audits ensuring the quality and integrity of migrated data.
• Training staff on the use of DBT and the implementation of a code architecture respecting best practices.
• Data visualization with Metabase.

**Technologies**: MongoDB, Oracle, Postgres, Ora2Pg, Talend, Google Cloud Platform, DBT Core, Python, SQL, Metabase, GitLab, Jira

• Collection, processing, transformation, and analysis of data from CRM, GA4, MongoDB, Social Ads
• Automation of ETL/ELT pipelines with the implementation of Google Cloud services
• Implementation of Data Build Tool for transformation and data mart modeling
• Development of dashboards and advanced reports on Looker Studio and Streamlit
• Definition of tracking strategies and implementation of advanced solutions via Google Tag Manager (GTM)
• Migration from Postgres to MongoDB
• Web scraping and populating the database.
• Collaboration with PM/Marketing/UX/Designers/IT/Sales/Admissions teams to optimize advertising campaigns based on data-driven insights
• Creation and maintenance of workflows, macros, and layouts on the CRM, user administration, assistance, and review for updates
• Lead of the CRM field categorization project
• Microsoft 365 Administration

**Technologies**: BigQuery, Zoho CRM, Zoho Analytics, Cloud Functions, Cloud Run, DataProc(spark), Pub/Sub, Cloud Build, Artifact Registry, Cloud Scheduler, Data Build Tool, MongoDB, Postgres, Google Sheets, Excel, GA4, SEO, GTM, GDPR, Looker, Tableau, Streamlit, Docker, Python, SQL, Github Actions, Terraform, DigitalOcean, CI/CD, UML, JIRA, Notion, Slack, Remarketing