Mehdi is available for hire
Hire MehdiMehdi Aziz Sidi Boumedine
Verified Expert in Engineering
Database and Data Warehouse Developer
Algiers, Algiers Province, Algeria
Toptal member since July 1, 2020
Bio
Mehdi is a database and data warehouse developer specializing in data architecture, SQL, data pipelines, and ETL, whose expertise includes the Azure data and analytics stack. He has worked in the telecommunications industry for 15+ years, focusing on complex analytical and transactional databases with huge data volumes. In addition to technical expertise and leadership experience, Mehdi has an MBA from the Paris Dauphine University.
Portfolio
Infostrux
Snowflake, Data Build Tool (dbt), Terraform, GitHub, Jira, Python 3...
Ericsson
Solution Architecture
VEON
Business Intelligence (BI), Linux, Oracle SQL, Tableau, SQL, PL/SQL, Oracle...
Experience
- SQL - 15 years
- PL/SQL - 8 years
- Data Engineering - 5 years
- ETL Development - 4 years
- ETL - 4 years
- Python - 2 years
- Azure Data Factory (ADF) - 2 years
- Databricks - 1 year
Availability
Part-time
Preferred Environment
MariaDB, Oracle, Azure
The most amazing...
...data pipeline I've built was a sequence of transformations on millions of records used to detect telecom fraud, thanks to its flexibility and performance.
Work Experience
Senior Data Engineer
2022 - PRESENT
Infostrux
- Developed an Infrastructure as a code framework for a Snowflake Data Ingestion solution based on Terraform and GitHub actions.
- Migrated data from a multi-tenant organization from one data architecture to another without impacting business continuity.
- Built and deployed dbt data models for multiple business areas for a multitenant organization.
Technologies: Snowflake, Data Build Tool (dbt), Terraform, GitHub, Jira, Python 3, Machine Learning Operations (MLOps)
Solution Architect
2017 - PRESENT
Ericsson
- Developed and delivered a multimillion-dollar technical proposal to a customer for an entire business support system stack.
- Created and delivered a million-dollar technical proposal to a customer for mediation, provisioning, billing, and charging systems.
- Played a key role in business development activities with local mobile operators for mobile financial services, customer experience management, and OSS closed-loop automation.
Technologies: Solution Architecture
CRM | Enterprise Architecture Manager
2008 - 2020
VEON
- Created a tool for SIM box fraud detection, using PL/SQL script on millions of call records.
- Delivered a contextual marketing solution using InTelestage from Business Logic Systems.
- Implemented a POS and distributor system used for indirect sales and wholesale order management.
- Launched an enterprise architecture setup project after defining the pain points and goals, revising the software requirements, and defining the transition strategy.
- Led the RFP development, evaluated proposals, and selected a major consultancy to gather requirements and develop a plan for a digital transformation.
Technologies: Business Intelligence (BI), Linux, Oracle SQL, Tableau, SQL, PL/SQL, Oracle, Data Modeling, Databases
Data Warehouse Manager
2006 - 2007
VEON
- Planned a business intelligence maturity assessment project, selected vendors, and managed the delivery of an assessment report that led to a transformation project.
- Increased the quality of reports and the team's efficiency in delivering them by initiating organizational and process changes.
- Generated advanced reports, price simulations, data reconciliations, and anomaly detections.
- Reduced the time to deliver a critical business report from 10 hours to 30 minutes.
Technologies: Business Intelligence (BI), Data Engineering, Linux, Oracle SQL, Oracle Discoverer, ETL Development, ETL, Data Warehouse Design, Perl, PL/SQL, MySQL, SQL, Data Warehousing, Oracle, Data Modeling, Databases
Data Warehouse Developer
2002 - 2006
Orascom Telecom Algeria
- Developed the initial core data warehouse ETL using the Oracle Warehouse Builder tool. The ETL fetched data from billing and systems, transformed binary and text files, and loaded them into the data warehouse.
- Built financial reports for balance aging, collection, and revenue.
- Created a set of Oracle PL/SQL scripts that reprocessed data from the billing system to deliver consistent and correctly formatted reports for finance users.
- Built data reconciliation pipelines between equipment, CRM, and billing. Used Perl, SQL, and PL/SQL to transform vendor-specific data files and billing system tables to one readable format and compared both for service assurance and fraud detection.
- Constructed a bill generation application for collection agencies to use. The application generates formatted bills in HTML based on data uploaded in a flat file.
- Created business intelligence universes and folders using Oracle Discoverer and taught users how to create custom reports from the folders.
Technologies: Business Intelligence (BI), Data Engineering, Linux, Oracle SQL, SAP Business Object Processing Framework (BOPF), Shell Scripting, ETL Development, Data Warehouse Design, SQL, PL/SQL, HTML, Perl, Oracle Discoverer, Oracle PL/SQL, Data Warehousing, Oracle Warehouse Builder (OWB), ETL, Oracle, Data Modeling, Databases, Dimensional Modeling
Experience
Data Products CI/CD Pipeline (via Toptal)
Created, after having developed and implemented around four data products, the CI/CD pipeline that transforms the Python code and Azure Data Factory templates to make them test and production-ready and to deploy them into the right environment.
Data Mart for the Logistics Domain (via Toptal)
Built a data mart for a major retailer based on the Azure stack: Synapse, Azure SQL, Databricks, and Azure Data Factory. Designed a resilient data model for the logistics domain and created the physical DB on Azure SQL, then on Synapse Analytics. Built secured and optimized ETL with PySpark on Databricks and Azure Data Factory. Developed a CI/CD pipeline with Azure DevOps to automatically deploy the data factory from dev to UAT.
Bank Interface (Toptal Client)
Developed data interfaces for the banking software using Oracle PL/SQL. I loaded and transformed the data as per the customers' coding guidelines and data mappings. I incorporated PL/SQL objects, collections, cursors, and stored procedures.
Major Reconciliation | SIM Card and Scratch Card Stock
After major events occurred for a telecom operator (vandalism, stolen cards, and management issues), the new management decided to conduct a vast data reconciliation operation on millions of SIM cards and scratch cards. I developed tools that enabled a successful reconciliation by merging two databases into one easily manageable database. The tools transformed sparse serial numbers into ranges, matched individual numbers to ranges, and generated gap reports.
Website improvements (Toptal project)
I implemented improvements on a Perl, HTML and Javascript-based web application—Koha Open Source Library Management. The improvements were changing the approval workflow, changes in the display items and cosmetic changes.
Halite Quest Project
Designed an agent (using Python) that plays against other bots in a resource/strategy game. The goal of the game is to collect the greatest number of Halites (imaginary resources) while avoiding collisions with enemies. The game was ranked in the top 50% of its type in a competition.
COVID-19 Confirmed Case Predictions
https://www.kaggle.com/mehdi16/covid-19-week-2Created a Python data pipeline that uses historical data of confirmed COVID-19 cases and fatalities plus additional information from countries as input to predict the future number of cases. The tool was ranked in the top 50% of its type in a competition.
Transforming Population Data with Spark SQL
Used a Databricks cluster in Azure Data Factory to transform raw population data into a usable format for further joins and processing with Azure Data Flow. Used methods such as group by, pivot, and sum to transpose the data.
Education
2011 - 2013
Master's Degree (MBA) in Business Administration
Paris Dauphine University - Paris, France
1991 - 1998
Bachelor of Engineering Degree in Comptuer Science
University of Science and Technology – Houari Boumediene - Bab-Ezzouar, Algiers, Algeria
Certifications
JUNE 2021 - JUNE 2023
Azure Data Engineer Associate
Microsoft
OCTOBER 2018 - PRESENT
TOGAF Foundation
The OpenGroup
AUGUST 2018 - PRESENT
Fundamentals of Digital Marketing
Skills
Libraries/APIs
Pandas, NumPy, PySpark
Tools
Tableau, Microsoft Power BI, Oracle Warehouse Builder (OWB), Spark SQL, GitHub, Azure Key Vault, Terraform, Jira
Languages
SQL, Snowflake, Perl, Python, HTML, Python 3
Platforms
Oracle, Amazon EC2, Linux, Amazon Web Services (AWS), Azure, Databricks, Azure Synapse
Storage
PL/SQL, Oracle SQL, Oracle PL/SQL, MariaDB, MySQL, Microsoft SQL Server, Databases, Oracle 12c, Azure SQL, Apache Hive, Data Lakes
Paradigms
ETL, Dimensional Modeling, Business Intelligence (BI), Azure DevOps
Frameworks
Spark, Windows PowerShell
Other
Data Warehousing, ETL Development, Data Engineering, Data Modeling, Data Build Tool (dbt), Machine Learning, Oracle Discoverer, Data Warehouse Design, Shell Scripting, SAP Business Object Processing Framework (BOPF), Solution Architecture, Linear Regression, Azure Data Factory (ADF), Azure Data Lake, CI/CD Pipelines, GitHub Actions, Machine Learning Operations (MLOps)
Collaboration That Works
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
1
Share your needs
Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2
Choose your talent
Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3
Start your risk-free talent trial
Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.
Top talent is in high demand.
Start hiring