Ing. Yassine EL HASSAK

- Develop different python and Java ETL to extract data from different PLCs transform data as per business need and load them in MSSQL data warehouse (deploy the ETL in LoopEdge devices) - Develop realtime monitoring dashboards (OEE, YEILD, downtime) - Develop a spare parts management application - Perform integration test and unit tests - Write the documentation of the solution Used technologies: SpringMVC, Spring Boot, Rest webservices, Hibernate, Maven, Tomcat, intellij, Swagger, MSSQL

- Develop two application in a team of 5 developers using Scrum developement method. - Develop Restful Webservices using J2EE - Develop data extracting batchs - Definition of final user needs - Drafting of technical and functional specifications - Perform unit tests and integration tests Used technologies: PowerAMC, SpringMVC, Spring Batch, Java Mail, Hibernate, Maven, Tomcat, Linux Centos7, Eclipse, Bootstrap, MSSQL, Sage100 i7, Mantis

- Implement a Talend ETL to extract data from the production database and load them into a decisional data warehouse. - Create functional reporting dashboards (Tableau Software). - Manage backup and versioning of the database (MSSQL 2008) - Software and Hardware Incident Resolution, System Administration & Networks - Write IT procedures and evolve them. - Establishment of an internal IT best practice Wiki - Account creation and setup in ERP (Sage 100 Enterprise i7)

Troubleshoot level 1, 2 and 3 IT incidents and manage IT infrastructure (servers, IT parc, software and network)

- Business Intelligence - Datawarehouse architecture - Data flow design - Data analytics and dashboards - Project Management

- Java, J2EE - Webservices (restful and SOAP) - MySQL, MSSQL - Modular developement