Sami OKBI

Business Intelligence Senior Consutant, expert in SAS solutions. I have experience since 07/2003 in data warehouse solutions with SAS and other tools. I am used to work close to the users, and conduct projects in an iterative manner to ensure the best match between the needs and the implemented solutions. I am used to work in complex environments and in interational context. I know how to manage projects: * development of a communication plan, * sponsorships, * Gantt & Pert diagrams, * meeting facilitation. Business Intelligence : SAS, Business Objects, Webfocus, Hummingbird Genio and BI SGBD: Oracle, SQL Server, Access Statistics : SAS/Stat, R, SAS Ent. Miner, SPSS, Eole, Sphinx. Programming languages : SQL, SAS (Base, Macro), SAS/AF, R, HTML, VBA, JavaScript, PHP , PL/SQL. Office : Word, Excel, Powerpoint Skills: - Analysis of the needs, - Technical design, - Counselling and training - Conception of dashboards / reporting.

Implement SAS programs to automatize national accounts reports.

SAS servers administration SAS applications support and maintenance SAS/EG users support Technical analysis Monitoring and diagnostics

Evolutive migration from WebFocus 7 to WebFocus 8

Eurostat is a Directorate-General of the European Commission located in Luxembourg. Its main responsibilities are to provide statistical information to the institutions of the European Union (EU) and to promote the harmonisation of statistical methods across its member states and candidates for accession as well as EFTA countries. Context of the project European Commission: GSAST and SAS application maintenance and second level support (Luxembourg) development expertise in data warehouse, reporting and statistical tools: * Maintenance of statistical domains that use GSAST or SAS, * Assistance of Statistician users, * Adaptation of programs, * Unix monitoring and develoments, * Migrations: SAS 9.1 to SAS 9.2 to SAS 9.4, SAS EG 4.1 to 4.3 to 7.1 * Technical support * Follow up of evolution of SAS products * Monitoring and evaluation * System requirements and quality ranges * Acceptance of deliverables * Maintenance of old tools based on SAS/AF, SAS/IntrNet and SAS/Base code. * Maintenance on VBA tools. TECHNICAL ENVIRONMENT SAS Base/Macro 9.2 to 9.4, SAS Enterprise BI Server, SAS Management Console, SAS Enterprise Guide 4.3 and 7.1, SQL, Oracle, Systems: Unix and Linux

Aperam S.A. (LuxSE: APAM) is a company, listed on the Amsterdam, Paris and Luxembourg stock exchange and with facilities in Brazil, Belgium and France, which concentrates on the production of stainless and speciality steel. It was spun out of ArcelorMittal at the start of 2011; the facilities that became Aperam had about 27% by turnover of the stainless-steel market as of 2009. Title: SAS BI expert in the DataWarehouse team Context of the project: Full SAS datawarehouse: overhaul of the application. * Monitoring and optimization of the loads of the DataWarehouse. * Analysis and SAS developments and implementations * Responsible of the Purchase domain * Recasting of the dashboards of the Purchase Domain. * Analysis of failures * Proposed action plan and optimization plan * Coordination with development team (Genk - Belgium) and monitoring achievement TECHNICAL ENVIRONMENT SAS Base V9.2, SAS EG 4.3 (and SAS BI Suite) / (Windows XP / MVS). Modeling methodologies: UML, Merise Project methodology: Rational Unified Process

La Redoute is the largest mail order company in France. The company is based in Roubaix. It was founded in 1875. It is owned by the PPR holding company. PPR was named "Pinault-Printemps-Redoute" until 2005. Thus the "R" in the acronym refers to La Redoute Title: SAS and BO analyst Context of the project: SAS and Business Objects expertise in the operational monitoring of actions of the liquidation of stocks of different brands and sales materials. * Analysis and SAS developments and implementations * Responsible of the relationships with subsidiaries (UK, Austria, Switzerland, Italy, Spain, Portugal, Greece, Scandinavia, Belgium) * Setting and program delivery, * Improved programs and procedures, * Preparing Data (various checks), * Exchange with the various parties (France & International), * Release and control of markdown rate applied for the operations of liquidation, * Tracking of the operations of liquidation, * Preparing balance sheets, * User support, bug tracking of the rate markdown applied on the WEB TECHNICAL ENVIRONMENT SAS V8.2 (MVS), Business Objects XI R3 (Windows XP). Modeling methodologies: UML, Merise Project methodology: Rational Unified Process

Vauban Humanis, Humanis group, is a leading Joint and mutual social protection in France. It provides individuals, businesses and independent professionals retirement solutions, mutual health, pension, savings and Social Action. Title: BI engineer Context of the project Various projects for the ETL flows of the Marketing datamart, indicators constructions for a web portal (customer records). * Genio developments and implementations * introduction of the new NAF(constructed code): * design and implementation of dashboards with Hummingbird BI * design and development of ETL processes with Hummingbird Genio * design and development of programs for data processing in PL/SQL TECHNICAL ENVIRONMENT HummingBird Genio (ETL) et BI (reporting) (Windows XP). Modeling methodologies: UML, Merise Project methodology: Rational Unified Process

Dans le cadre de la migration du système d’information de grand système MVS (GIE Loginord) vers l’environnement Windows/SQL Server (GIE Synergie). * Conception, réalisation, tests et recette, mise en production d’applications décisionnelles à destination des Agences ou de services du Siège au moyen de la solution Webfocus (grande autonomie sur les développements). * Mise en ligne sous intranet. Portail développé en langages Webfocus, HTML et JavaScript. * Maintenance de Bases Access reliées au SI via ODBC et amélioration des programmes de mise à jour (VBA). * Suivi des applications existances et assistance aux Utilisateurs dans leurs écritures de requêtes Webfocus. Environnement technique : Webfocus, SQL Server, ODBC, VBA, Office Equipe de 5 ingénieurs analystes. Exemples d’applicatifs dévelopés : • Mise en place d’un reporting hebdomadaire relatif à la surveillance des activités terroristes. Scoring comparant les informations des clients à un fichier listant les principaux terroristes ou groupes terroristes. Reporting présentant les clients ayant un score significatif. • Mise en place d’un intranet permettant aux agences d’interroger les détenteurs de parts sociales sur leurs souhaits de vote à la prochaine Assemblée générale (pouvoir au président, vote par correspondance, etc.). Suivi des résultats par agence. Envoi quotidien de rapports synthétiques à la direction régionale. • Mise en place d’extractions ponctuelles ou récurrentes réalisant des ciblages clients en vue d’opérations commerciales ou d’envois d’encarts réglementaires (convocation aux assemblées générales). • Mise en place d’un système de refacturation des chèques de banques (reprise des chèques de banque émis la veille, regroupement par clients, et refacturation aux clients).