Freelance OPEN DATA : Les nouveaux consultants identifiés

Résumé d'expériences de Denis,
freelance OPEN DATA résidant dans la Haute-Savoie (74)

• Consultant as a Freelance

  Today Bi(Consultancy)
  2011 - aujourd'hui

  Consulting activity in the area of Business Intelligence (BI) with a Qlikview platform expertise. This activity covers the aspects of consulting, analysis, project management or contractor assistance, realization and support. It is based on the best practices and Qlikview project methodology, and was developped in various domains: Finance, Energy, Cosmetic, Distribution, Research…

• BI Project leader for Tamoil SA (Energy – oil & gaz)
  2005 - 2011

  Focus of my activity into Business Intelligence. Analyse, selection and deployment of Qlikview as a new tool for the company. Infrastructure creation, definition of standards, business requirements analysis. Application development management for a hundred of users

• IT Project leader

  2000 - 2005

  Management of various IT projects, for all departments (finance, network retail, sales, logistic, refinery, affiliates, HR & administration). Team member in an ERP replacement project: process/data inventory and specifications

• IT Project leader for Piaget International SA (High Jewelry-Watches)
  1995 - 2000

  Development manager. Specific development, maintenance & migration of ERP. Y2K project

• Analyst/Programmer

  Banco Santander (Private banking)
  1990 - 1992

  Maintenance of a private banking software and development of statistical applications

• Programmer

  Sopra SA (ICT)
  1985 - 1990

  Realizations, Professional skills
  Project management
  Based on the Qlikview Project Methodology (QPM), setup of the project phases in leveraging on agility concepts
  Providing a project status reporting, automating a BI project dashboard
  Coordination of maintenance, development or support activities performed by internal actors or by third party consultants
  Demos, presentations (commercial events)
  Organisation of a tool selection and proof of concept
  
  Architecture and Analysis
  Design of the entire business intelligence architecture, including : tool selection, license choice, environments structuring and sizing, process design, security concepts, standard definitions in respect of adopted design pattern and corporate identity, design recommendations, system operations guidelines
  Capture of the business requirements along clients/users meetings and workshops, integration of functional/technical needs in the proposed solution in a formal and standard Business Requirements document. After a first user validation, delivery of assessment based on that document. Iterative review with users for qualitative enhancement of the application during the whole software development lifecycle (SDLC)
  Design and Realization
  Strong experience in data modeling with QlikView associative concept
  Proficiency with complex scripts and formulas (set analysis, partial reload, …)
  Ability to adapt application ergonomy to visual standards and best practices
  Dataflow architecture for datawarehouse building (QVD), taking care of reusability, performance and occupied space
  Experience in collecting large volume of data from multiple sources: structured databases, text files, web based data sources (open data), connectors (SAP)
  Permanent worry about optimizing loading scripts and disk space, keeping acceptable complexity for process and maintenance, without decreasing evolution capabilities
  Experience in setting up web based applications on Server (and Publisher)
  Realization of applications using various techniques: Tablet design (iPad), geospatial map, auto archiving scripts, Open Data load, Qlikview Extensions...
  
  Operation/Maintenance
  Qlikview server setup and general administration
  Qlikview versions upgrades (v9, v10, v11)
  Application deployment across dedicated server environments (Dev/Test/Prod)
  Data load process monitoring (follow-up + dashboard setup)
  Setup of alerts on data load process and on data quality
  Static/dynamic security access setup for users or groups (Publisher / Section Access)
  
  Documentation
  Architectural specification.
  Business requirements and Assessments documents
  Technical and User documentation
  Training workshop documents
  
  Training and support
  Support to BI users.
  Coaching for Qlikview application developers
  Training cycle creation and delivery to users
  Promote objects customizing/sharing by KeyUsers, within agreed deployment strategy
  Aim to solutions that empower the client’s autonomy
  
  Consultant Décisionnel Indépendant (QLIKVIEW certifié - 5ans)
  Nombreuses réalisations en gestion de projet, analyses de besoin, développement, maintenance, support, assistance utilisateurs ou développeurs.
  Expérience et maîtrise de la partie administration et installation des Qlikview Server / Publisher.
  Expérience en Gestion de projets informatiques et BI. Suivis de projets Qlikview
  Niveau de connaissance ETL (Script SQL Qlikview) + Design d'applications : Expertise (5 ans + certifié Qlikview)
  Connaissance en SGBD : MSSQL, DB2 400 : Bonne. MySQL, PostgreSQL, Oracle, DB2 : Moyenne
  Méthode : Personnelle + QPM (recommandée Qlikview)
  Développement pour interfaces mobiles (tablettes iPad),
  Systèmes de coordonnées géographiques,
  Connecteur Qlikview SAP
  Open data