Mehdi Talbi

Freelance services in: – DevOps – Data Engineering / DataOps – Backend Engineering

Contributed to building the company Data Platform on GCP within a team of 2 Senior Data Engineers, 1 PM and 1 Data Analyst. Contributions are including, but not limited to: – Private Managed Airflow (Cloud Composer) setup (infrastructure, CI/CD, etc.) – Infrastructure Management via Terragrunt (pretty much all infrastructure aspects apart from networking setup), development of related Terraform modules – Common Airflow DAGs development – On-demand lead generation pipeline available as a service to Operations team – Mixpanel to BigQuery integration

Developing Twilio SuperSIM applications and maintaining the legacy Programmable Wireless applications. Main areas of work: – SIM cards data usage measurement and limiting – Integration with existing billing systems – Mobile Core events processing – Ops tooling (deployment pipelines utils, metrics' monitoring management, etc.) Languages: Scala (80-90%), Python, (Java) Technologies: AWS, Apache Kafka, Apache Spark, Apache Cassandra, Jenkins, Kibana, Datadog, Terraform, OpenAPI, MySQL

Erento Gmbh: 1 month in-house consultant in data engineering, including maintenance and development of the existing Python/Airflow setup and development of a backup process for S3 and Redshift data. Bookatiger.com: Fixing and improvement of the current ETL setup. Lingual Consultancy Gmbh: Development of a Google Sheets based solution for translation services pricing and invoicing using Google Apps Script (Javascript syntax).

In charge of various consulting projects, mostly in the field of data engineering. Scope of consulting projects: – ETL pipelines – Python development (ready-to-deploy ETL and tracking scripts, refactoring and development of the company's repository) – Data analysis and forecasting – Data warehousing and processing – Multi-channel attribution modelling (web and mobile) – Tracking and Analytics setup Technical Stack: – ETL: Python scripts, Jenkins – AWS: EC2, S3 – APIs: Google Analytics, Facebook Ads, Bing Ads, Google Tag Manager, Google BigQuery, AWS (S3) – Databases: MySQL, Postgres, Amazon Redshift, Google BigQuery – Data Analysis: Python (pandas, numpy, matplotlib, seaborn, scikit-learn) – Tracking and Analytics: Google Tag Manager, Google Analytics, JavaScript

– Full automation of daily/weekly reportings from ETL (online/offline marketing costs to Postgres DB) to Tableau automatic mailings. – PostgreSQL: advanced functions development (data processing for Tableau extracts), database reorganization, runtime optimization (decreased total overall runtime by >30%), .. – Python programming: ETL cronjobs using various APIs (Adwords, Facebook, Piwik), running on AWS EC2. – Tableau Software: various Marketing/Operations dashboards, BI monitoring dashboard (SQL functions execution & runtime monitoring, errors logging). – Daily use of Sourcetree/Bitbucket. – Occasional Ad Hoc analyses with Excel.

Creation of PostgreSQL functions, mostly for management reports, sales, and pricing teams. – Data imports from Close.io API to a local database using Python scripts – Development of an Excel macro to gather all contact information of Rolex official retailers worldwide. – Development of Excel macros and Google Apps Scripts (VBA & JS for Google Apps).

During this internship, I had the opportunity to use and develop my skills at 3 different positions: – CEO Assistant: various analytical tasks (online competition analyses, market sizing, impact analysis). – Business development: pricing studies, negotiations and integration of new e-merchants. Improvement of processes for merchants' sales analysis to determine causes of future performance problems. – VBA development: creation of VBA tools for several departements (business development, content management, payments & accounting). – Very basic use of Jaspersoft BI Software

– Offpage/Onpage SEO activities (netlinking, keyword density optimization, etc...) for France – Development of operational VBA tools for SEO reportings, cost analysis, data cleaning/classification – Creation of Landing Pages for the french website – Tools: Sistrix, SeoMajestics, Ahrefs, ...

Sourcing Manager assistant for IT Services : – Involved in negotiation meetings on various projects – Analysis of suppliers' panel Pre-selection of a potential panel and negotiations on rate cards for new frame agreements Development of a VBA pricing analysis tool for suppliers' rate cards – In charge of negotiations on smaller projects (< 30K€)