Sofiane O.

BI/ETL DEVELOPER

732 euro
Freelancer
8 years
Asnières-sur-Seine, FRANCE

My experience

More

DIOR HAUTE COUTURE - ISDNovember 2018 - Present

Development:
Lead consultant for Qlik DIOR project, managing remote support team. Applications
development for business units and high management. Mashup development for sales associates
on iPad using VueJS technology. Widgets package development for each business unit. Reload task
automation using Powershell. Incorporation of complex business rules to monitor stock covers and
Supply chain efficiency. Using REST connectors to collect data from external sources. 
Architecture:
Rebuilding data extraction and modelling from the ground up. Data Layer
development and optimisation using best practices. Security administration for multiple
environments. Managing licensing, user management and delivery methods. Administrating and
editing Nprinting weekly reports. Performing a Qlik Sense server upgrade to February 19 version. 
Tools:
Web Developments (HTML-CSS-JS) - Qlik Dev-hub - QMC - Qlik Web Connectors and APIs -
NPrinting
More

APEC- ISDSeptember 2017 - September 2018

Development:
 Adaption of Cognos reports to Qlik Sense - Qlik Sense application development -
Making interactive reports for decision makers. Data processing via Oracle SQL Server - Advanced
scripting and data transformation. Compiled training material, and trained staff on use of application.
Analyse large volumes of data on Geographical levels using KML layers and GeoAnalytics
operations. 
Architecture:
Configuration of Qlik Sense Server (QMC and Hub) including Licensing, Stream
Management, Tasks, Users, Security Rules and Audit. Designing Security structure. Monitoring a Qlik
Sense upgrade to June 18 version. Creating scheduled jobs for QVD extracts and report reloads. 
Tools:
GeoAnalytics - Extensions JS - Story telling - Mashup - QMC.
More

AIRBUSNovember 2015 - August 2017

Managing outstanding works for both A380's forward and central section: Production- Supply and
Partners - Logistics - Engineering. 

Digital management:
Application development for following up the outstanding works using
QlikSense. KML coding for maps and visualisations. Delivered all aspects of solutions for large multinational teams including POC.
More

BOEING B 787 POWER PANELSJanuary 2014 - October 2015

Management of logistics flow: Procurement - Scheduling - MPS & SOP - Stock and Batch transfer management - Technical upgrade management.
Data processing: IS extract configuration -
Implementation of KPI and production control tools.
More

ANGERSFebruary 2014 - August 2014

Final term internship:
Setting up safety stocks for transfer - Foresight analysis - MPS - Lean
Manufacturing for production shift.
Data processing: Implementing database queries - Data mining
- Gap analysis.

My stack

Visual Basic, VBScript, Tableau Software, SSIS, SQL, SPSS, SAP, REST, QlikView, PowerShell, Power BI, Oracle SQL Developer, Oracle PL/SQL, Microsoft SQL Server, Microsoft Excel, Matlab, Jscript, HTML, Design, Data processing, Cognos Impromptu, Adobe Photoshop