Smail Yaici

Project: intervention on the entire Data chain (flows, models, reporting) for steering activities within the DATA / BI team (accounting, account management, ..)

- Collection and monitoring of user needs

- Presentation of developments and collection of feedback from stakeholders

- Processing of various business requests (in the form of JIRA tickets)

- Ensure JIRA backlog management

- Daily production monitoring (using Dollar Universe tool)

- Incident processing and anomaly correction

- Modeling of new flows and datamarts

- Design and development of integration chains (TSQL, SSIS)

- Creation of several regulatory reports (Tableau / Cognos).

- Support for developers and optimization of existing developments (Packages, Queries, Analytical Reports)

- Writing of technical and functional documentation

- Write and distribute documentation for updates

- Prioritization and planning of deliveries

- Lead team rituals (daily, sprint reviews, retrospectives, etc.)

- Support for business teams and assistance

- Preparation of test cases and support during acceptance,

Project: Processing of various improvement or correction requests for the business (in the form of Redmine tickets) and creation of Reports.

● Collection and monitoring of user needs

● Integration of new data into the data warehouse

● Incident processing and anomaly correction.

● Creation and improvement of SSIS flows and stored procedures.

● Deployment of developed packages in Production

● Creation of several reports in SSRS.

● Writing of technical and functional documentation

Project: Processing of various improvement or correction requests for the business (in the form of Mantis tickets), daily management of maintenance and participation in the data architecture redesign project.

- Maintenance management,

- Daily verification of SSIS flows

- Investigation and correction in case of anomalies in SSIS processes.

- With the architect, definition of a new cloud reporting solution

- Study of cloud solution choice: AWS / Azure

- Study of a Dataviz solution: Power BI (on premise / Azure) and Tableau Software

- Implementation of Power BI reporting

- Creation of Power BI reports (Report Server and Cloud) and Tableau Software

- Creation of data flows with SSIS (Source types: delimited flat files (.csv) / SQL Server)

- Deployment of packages on Azure Cloud services

- Creation of stored procedures in T-SQL for data sets.

- Data update

- Implementation of multidimensional and tabular SSAS Cubes.

- Creation of reports with SSRS.