Taha Touati

Function: BI Project Manager / Technical Architect

End clients: Groupe PSA / LeasePlan / Fraikin / Internal

Mission: Project management and development of the solution "GDR-BI by SmartData for Lead"

 Gathering requirements from functional teams

 Estimation – breakdown – planning

 Writing functional specifications, data dictionary, technical specifications

 Recruitment

 Task allocation to team members and progress monitoring

 Manage the client relationship COPIL / COPROJ / COTECH

 Architecture of the base and application design

 Development of Talend processing / INSEE data flows + specific partner data

 Development of Reporting elements with Power BI and Embedded deployment

 Technical and functional documentation

 Implementation of the technical infrastructure, deployment and user training

Database: SQL Oracle 12g, PostgreSQL 10/12

Data processing: Talend / Specific in Java

Reporting tools: Microsoft Power BI / Embedded in a Node.JS / Bootstrap application

Environment: Windows / Unix

Auchan Retail International – Corporate Products Department (DPC) November 2018-March 2019:

Function: Flow Project Manager - Data Expert

Teams:

- 2 days per week in the International BI team

- 3 days per week in the MDM team – Inter-application exchanges

-----------------------------------------------------------------------------------------------------------------------------

Mission 1: in the International BI team

At a rate of 2 days per week, I was responsible for the design, architecture, development, deployment and Run of business data transformation processing for management purposes. I created the following bases:

- Margins (5NET international, local and international supplier discounts)

- Promotions: processing and application of promotions to support functional teams for

price choices and target the right promotion periods per product

- Panel and negotiation files: make available to functional teams indicators allowing them to manage panel choices and produce reliable negotiation files

- Supervision of junior developers, estimation and project management

Technologies:

Database: Teradata

Data processing: Talend, Shell Restitution: Business Object / Qlik Sense Environment: Unix / Windows

-----------------------------------------------------------------------------------------------------------------------------

Mission 2: in the MDM / Exchanges team

3 days per week, I was responsible for redesigning the MDM model and developing

processing for inter-application exchanges:

- Improving performance and optimizing the data model

- To meet Run needs, I added the asynchronous logging components of YodaLogs (developed by the Auchan Corp. teams) and developed the ELK stack to load these logs and manage the various processing via Kibana dashboards

- Redesign of orchestration jobs

- Development of extraction jobs for the domains: Textile, Bazaar, Food

- Improving the performance of certain MDM components

Technologies:

Database: Oracle

Data processing: Talend MDM, Talend Integration Environment: Unix / Windows

Jan 2017-Nov 2018:

Function: business intelligence project manager – technical and functional

Clients: ANTS (National Agency for Secure Titles), SIV (Vehicle Registration Service) and SSA (Armed Forces Health Service)

Team: the transverse department “InfoCentres” is attached to the MTS (Mobility & e-Transactional Services) business unit. It is composed of a set of teams called “InfoCentre”, each of which takes charge of one or more Data projects. I was responsible for the following InfoCentres:

- ANTS-COMEDEC: BI project from start to implementation

- SSA: BI project from start to implementation

- SIV: maintenance / development of evolutions and corrections

-----------------------------------------------------------------------------------------------------------------------------

Mission 1: ANTS – National Agency for Secure Titles

In order to manage its new COMEDEC (Electronic Communication of Civil Status Data) platform by data, ANTS and Worldline tasked me with developing and implementing an end-to-end business intelligence chain with flat files containing business data to be cross-referenced with reference data as input and two ODS (detailed, cleansed data) and DWH (aggregated data around the requested analysis axes) databases as output, which are fed by the ETL on a daily basis.

The project's major constraints:

- Reproduce the existing system identically (complex and mostly obsolete Excel macros)

- Recalculate the entire history since 2016 at the end of the “ETL Developments” project - ETL performance

- Intelligent rejection management and automatic erroneous data recycling mechanism

- Custom Data Quality process to validate the reliability of calculated data and indicators

- Strong dependence on the business team which prepares the raw data exports for us

My tasks and responsibilities:

- Gathering requirements, organizing and facilitating workshops

- Writing the Expression of Need, breaking down and estimating the project, proposing a schedule

- Writing the functional and technical specifications document and monitoring its validation by the client

- Writing the technical architecture document and ordering the machines

- Implementing the application architecture of the COMEDEC InfoCentre and sending system requests

- Developing the ETL and its various functionalities (recalculation, automatic purge, rejections, etc.)

- Creating the various statistical reports (tabulations, graphs, OLAP cubes and dashboards)

- Deploying the solutions, training and supporting the test teams (internal and external)

- Implementing monitoring mechanisms (back, middle and front)

- Writing the user guide and the operating document for delivery to production

- Supporting and supervising the team of 3 developers throughout the project

Technologies:

Database: Oracle 11g

Data processing: Custom ETL in Java: Data-Aggregator, Maven, Hibernate, Jenkins, Sonar

Reporting: Pentaho Business Analytics Server 8.1, Report Designer, MDX Schema Workbench Designer

Environment: Cent OS, Crontab scripts, back-middle architecture for the ETL and back-middle-front for the reporting tool

-----------------------------------------------------------------------------------------------------------------------------

Mission 2: SIV – Vehicle Registration Service

The SIV InfoCentre is an end-of-life project. It was assigned to my department as part of a maintenance contract pending its complete redesign.

The project's major constraints:

- Maintain the business intelligence in operational condition without undertaking significant developments despite the slowness, slowdowns and sometimes malfunctions due to the complexity of the processing and the various layers of corrective measures that generate regressions

- Impossible to have an ODI and BO environment to qualify the corrective measures

- No possible investment in this project before the end of the contract

My tasks and responsibilities:

- Correcting bugs, restarting processing in the event of failure and monitoring platforms

- Explaining any discrepancies and correcting the calculation methods for certain indicators

- Implementing a battery of non-regression tests

Technologies:

Database: Oracle 11g

Data processing: ODI (Oracle Data Integrator), Shell

Reporting: Business Object BI4 – Web Intelligence

Environment: Unix / Windows

-----------------------------------------------------------------------------------------------------------------------------

Mission 3: SSA – Armed Forces Health Service

The business intelligence chain for SSA supports the AXONE business application developed by Worldline and intended for the management and monitoring of the health of soldiers and their families. All data that passes through the various components of the AXONE tool is anonymized, transformed and aggregated to allow managers and decision-makers to effectively manage this medico-military activity and report to higher authorities. This project is classified as secret.

The project's major constraints:

- Recalculate and process all historical data (15 years)

- Retention of business intelligence data for 130 years

- Degraded / disconnected mode (for example for submarines). This data must be integrated and the indicators incremented for the period concerned and a report on any deltas must be produced

- Compliance with the GDPR without losing the analytical integrity of the various dimensions

My tasks and responsibilities:

- Project management and supervision of the business intelligence team

- Organize and facilitate workshops, negotiate schedules and prioritization of deliverables with the client

- Creation of a data dictionary and the functional specifications document

- Implementation of the architecture in two blocks: feeding the MongoDB ODS: anonymization and feeding the MySQL DWH: calculation of indicators and aggregation of data

- Writing detailed technical specifications and the technical architecture document

- Development of processing with Talend V7 to feed the ODS and the DWH

- Creation of Lot 1.a reports and planning of automatic export sends via JasperReports Server / Qlik Sense

- Acceptance, deployment and delivery of Lot 1.a

Technologies:

Database: MongoDB, MySQL

Data processing: Talend Studio for Big Data V7.0

Reporting: Qlik Sense, JasperReports Server 6.3

Environment: Cent OS, Crontab, Windows