Freelancer profile translated to English.

Description

Professional in Microsoft Business, I have contributed to and carried out projects for data exchange, data quality processing, and decision support for over 10 years in several business areas (Retail, Banking, Marketing...).

I am MCSE certified (Microsoft SQL Server Solution Expert). During my career, I have had to handle and master several tools and technologies:

Microsoft SQL Server suite (DBMS, SSIS, SSRS, SSAS, Data Quality, MDS) (2008R2, 2012, 2014, 2016)
Talend Open Studio
Data Warehousing
Schedulers: Microsoft Orchestrator & Job Scheduler
CRM (Data Integration): SharePoint 2010 & Dynamics CRM
E-Commerce Site (Data Integration): Magento & PrestaShop
Reporting: SSRS, Power BI, ProClarity
Modeling: Power AMC
Versioning: RedGate (SQL Compare, SQL Data Compare, SQL Doc)

Languages: T-SQL, PL/SQL, XML, JSON, PowerShell, Batch MS-DOS, C#, Java, VB.Net,...

I contribute throughout the project from the creation of technical and functional specifications to the deployment of projects.

I tend to create a relaxed environment during team collaboration and ensure that no one is struggling for better overall performance. I am benevolent towards people who want to learn, and I do my best to ensure we succeed in our challenges together. I always strive to be transparent and propose optimized solutions.

Languages

Arabic
Native or bilingual
English
Conversational
French
Native or bilingual

Workplace preferences

Can work on-site

Paris (up to 50km)

Un Jour Ailleurs
Purchasing / Marketing Reporting
FASHION AND COSMETICS
November 2016 - Today (9 years and 7 months)
Paris, France
Design and implementation of a Data Warehouse to collect data from various company applications and ensure data quality and consistency checks between different management systems. Implementation of various data flows between the company's different applications.
Commercial / Purchasing / Logistics / Marketing / Accounting and Finance Reporting.

My mission consists of:
+ Needs and existing system analysis
+ Design, implement, and optimize data loading ETLs (Normalization, Conversion, correction…)
+ Reporting on operational monitoring via SSRS
+ Excel (Power View / Power Query / M Language)
+ Deliverable documentation
+ Various projects:
- Revenue collection from various cash registers (150 stores in France) + Reporting
- Redesign and management of data exchange flows with the Magento E-Commerce site (Orders, Customers, Products, E-Card…)
- Management of data flows between the different SI software:
* Prios: PLM (Products, Raw materials, Suppliers, Supplier Orders, Receipts)
* Magento: E-Commerce Site (Customers, Customer Orders, Products, E-Card)
* Storeland: Sales Management (Customers, Customer Orders, Supplier Orders, Receipts, Stocks, Stock Movements, Stores…)
* WES: Logistics Management (Receipts, Physical Stock, Products)
* CODA: Accounting / Finance Management (Suppliers, Accounting documents…)
* Baseware: Invoicing Management (Supplier invoices)
* Adobe Campaign: Marketing Campaign Management (Customers + Prospects, consents, Marketing Campaigns)
* Other external systems (TinyClues, Advalo, Splio)
* DWH: Built from scratch with log management, error recycling, and technical and functional data quality control
- Customer de-duplication & Segmentation in the Data Warehouse (20,000 customers in 10 minutes on a database of 3 million customers)
SQL Server Talend Celigo REST API DWH Data Quality PowerShell Job Scheduler
KRYS GROUP
Opto11 Standard + Migration, Reform, Maintenance, and Evolution of Projects
HEALTH AND WELLNESS
May 2015 - October 2016 (1 year and 5 months)
Paris Area, France
Design and implementation of the technical solution for integrating the new Opto11 standard into the Group's 'Konvergence' application. Reform, technical optimization, evolution, and migration of existing projects (Stars, B2, CIS, CRM Returns…).
My mission consists of:
- Technical estimation of project batches
- Creation of detailed technical and functional specifications for the integration of the new Opto11 standard.
- Design, implementation, and optimization of data loading ETLs
- Automatic transcoding management (Configuration via SQL file)
- Data normalization, conversion, automatic correction
- Alert management
- Operational monitoring reporting via SSRS (Volume statistics, loading times…)
- Data quality reporting via SSRS (% rejections, data quality, rejection tracking, corrective evolution…)
- Optimization of existing SSIS project content (SSIS packages, SQL scripts, C# scripts)
- Deliverable documentation
SQL Server Power AMC Red Gate PowerShell
FINDUS FRANCE
Modeling and Creation of a Group Repository
AGRICULTURE
February 2015 - April 2015 (2 months)
Paris Area, France
Design and implementation of a repository for the Findus Group. The objective is to have a repository containing all the Group's domains, which must be flexible with all source systems, scalable at minimal cost, and multilingual.
My mission consists of:
- Technical estimation of project tasks
- Writing the 'Expression of Need' document (Existing system analysis)
- Writing the 'Findus Repository Design and Conception' document
- Creation of database creation scripts with:
+ Configuration of the SQL Server version to install
+ Metadata initialization
+ Versioning of database objects to manage deliverable evolution
- Creation of the deliverable operation document
- Creation of the solution maintenance document
SQL Server