Mohamed Ali Amri

Managed several projects and the TMA part.

The main tasks in each project are:

Creation of SSIS flows for data integration.

Creation of stored procedures.

Management of SSAS OLAP cubes.

Creation of SSRS reports.

Project: Invoice Plus

Creation of SSIS flows for integrating invoice data sent, and for generating XML files to be sent.

Applied log flows to trace SSIS flow executions.

Creation of an SSRS report to track incoming and outgoing file flows.

Project: Smart Pricing

Creation of an SSIS package to process all new product price files and populate the relevant tables according to business management rules, applying a log flow for execution logs as per business needs.

Creation of an SSRS report to track price file integrations.

Project: Evolution à Seuil

Creation of SSIS flows called by the "Evolution a seuil" application, which integrates new raw material prices and calculates and compares their evolutions with new ones.

Applied the log flow for each package execution.

Project: Implementation of sales and compensation status tracking reports.

Implementation of stored procedures that translate all compensation management rules, and use them as a data source for SSRS reports.

Creation of SSRS reports according to technical-functional needs and design aspects.

Integration of reports into a web interface used by the company. Documentation of the different project stages.

Project: Implementation of reports and analyses for the marketing team. Analysis of marketing team needs and management rules.

Creation of data integration flows either with SSIS or stored procedures on SQL Server.

Creation of reports on SASva or Excel extractions according to marketing needs.

Automation of integration flows with SQL Server Agent.