Salim Aouamri | Data Engineer at Cosider

Salim Aouamri

Data Engineer at Cosider

Based in Algiers, Algeria

About

An expert Data Engineer with a knack for constructing data-driven applications that push the boundaries of technology and business. Skilled in collecting, transforming, and loading data to optimize processes and ensure the accuracy and integrity of essential data assets. Proficient in leveraging ETL tactics and advanced technologies to synthesize actionable insights and promote strategic decision-making within dynamic workspaces. Always striving to stay ahead of the curve by innovating new strategies.

Skills

Projects

Analyze and Manipulate Employees Data of Cos Company

This Project connects to a SQL Server database using SQLAlchemy and retrieves data from a table named 'Tab_Agent.' The data is loaded into a Pandas DataFrame for analysis. The script then performs various data manipulations and analyses using Pandas functions, including displaying statistics.

Split PDF & send it via Email

This Python script uses the PyMuPDF library (via the Fitz module), pandas, and other standard libraries to split a PDF file based on specific text (document names) found on each page. The script also adds an image to the split pages and creates a new Excel file with the split PDF names and email add

Unlocking Financial Insights: A Comprehensive SQL Analysis of Yearly and Monthly Data Trends

This SQL query appears to be a complex one with a combination of several operations, including joins, unions, grouping, and pivoting. Let's break down the main components and provide an explanation.

Unveiling the Power of Pandas: Replicating SQL Union and Left Join Operations in Python

The provided Python code is a data manipulation script leveraging the pandas library to replicate the logic of a SQL query involving a left join and a union operation. The script assumes the existence of two DataFrames, pointage_df and sous_famille_df, which are representative of tables in a relatio

Unleashing Data Mastery: A Python Symphony for Advanced Analytics Transformation with Pandas and Numpy.

This Python code leverages the powerful data manipulation capabilities of pandas and numpy to replicate the functionality of a complex SQL query for advanced data transformation. The goal is to reshape and consolidate data from a source DataFrame, akin to the SQL query provided earlier.

Experience

2020-2021

Data Analyst at CIM Annaba

-Automated ETL processes, making it easier to wrangle data and reducing time by as much as 40%. -Performs unit testing and debugging of application components. -Prepare documentation and test procedures. -Analyse sample of dataset

2021-2022

Head of Section IT | Data Analyst at Cosider OA

-Developed Python and SQL scripts for data analysis and perform transformation. -Automated the manual data reconcialiation process between the different sources, increasing the data accuracy and efficiency by 90%. -Collected 72 sets from unities databases, restored in central database, and processed it with python. -Develop and analyze strategies to boost system performance. -Processed data prior to analysis for facilitate cost accounting visualisation. -Work closely with other developers to provide data services to existing and new applications (modify production data, create and optimize stored procedures, functions, views..etc).

2022-2023

Head of IT | Data Engineer at Cosider OA

-Develops data load processes Storing and retrieving data from databases and other file systems, Develops data conversion and transformation processes and utilities for large data sets. -Develop Solutions using SSIS/SQL Server technologies which meet the requirements of the data consumer groups and comply with the business rules. -Develop web based reporting systemsto monitor system performance, transaction and error rate. -Assist in defining and documenting data transformation rules. -Focus on ETL design, development, and performancetuning. -Managed and supervised a team of 3 persons.

Education

2014-2019

Big Data Analytics at University of Badji Mokhtar Annaba

Master's Degree of Big Data Analytics