Freelance SPAD : Distinguez les talents nécessaires à votre projet

Résumé d'expériences de Morgane,
freelance SPAD habitant Paris (75)

• Role: Business and Customer Intelligence Analyst

  Deutsche Bank CFU (Customer Follow Up), Belgium Name: Deutsche Bank CFU
  Jan 2010 - aujourd'hui

  Description:
  I'm working in the department Customer Follow Up which leads 3 main activities: Business Intelligence, CRM and Customer Intelligence.
  My role is:
  · Develop and manage the SAS Portal for directors of agencies (reporting)
  · Ad-hoc data querying (mostly portfolio oriented) ;
  · Provide simple to more complex data analysis to other internal departments: campaign analysis, targeting, market research, statistic methods (logistic regression mainly)

  Technical background: SAS Enterprise guide, SAS Management Console, SAS OLAP Cube studio, SAS Information map Studio, SAS Web report studio, SAS Information Delivery Portal, SAS Stored Processes,

• Role: Keyrus MIS/SRM coordinator

  Keyrus Client: Carrefour MIS/SRM, Evere (Belgium)Name: Carrefour MIS
  Jan 2009 - Jan 2010

  Description:
  Project: Acknowledge reception of targeting and analysis requests, validate the requests, plan the workload and allocate the work to team members , manage planning, scope, risks and issues, provide pro-active information about adequacy of the staffing levels

  This is done using SAS software (SAS/BASE, SAS/SQL, SAS/MACRO) and oracle Technical background: SAS (Base, SQL, Macro, Stat), Oracle

• Role: Analyst Programmer

  Keyrus Client: UMIX (utility), Leuven (Belgium)Name: PARO (Project Allocation and Reconciliation Oefening)
  Jan 2008 - Jan 2009

  Description:
  Project: gather data from all the different players in the energy market and (after validation) use them to calculate several measures that are then afterwards used to settle the payments between all parties.
  Results: exercise for the data of 2005 closed, data of 2006 ongoing, existing code enhanced,.
  This was done using SAS software (SAS/BASE, SAS/SQL, SAS/MACRO).

  Technical background: SAS (Base, SQL, Macro, Stat)

• Role: Business Intelligence analyst

  Keyrus Client: Proximus (telecom), Brussels (Belgium) Name: Market analysis
  Jan 2007 - Jan 2007

  Description:
  Projects: Ad-hoc analysis for Marketing Units in Business Mobile Division and developing analytical data models by using statistical and Data Mining techniques in order to assist, consult and guide the Business Divisions in decision-making process.
  The marketing business actions impacted included Pricing, Up-selling, Campaign Targeting and Impact Measurement.
  For all these analysis, I was working on SAS and gathered and extracted data from multiple Data Ware House sources by Oracle SQL, SAS querying and Teradata SQL

  Technical background: SAS (Base, SQL, Macro, Stat), Oracle, Teradata

• Role: Data Analyst

  Database Management (TNT group), direct marketing, Zaventem (Belgium)Name: Data Analysis and Consultancy for Marketing projects
  Jan 2007 - Jan 2007

  Description:
  Projects: category management for DELHAIZE, targetting people for mailings for RENAULT (customers and prospects), socio-demographical analysis for AFIBEL (mail order).
  My role involved scoring by creating models using geomarketing, socio-demographic analysis of markets. Definition of a methodoloy of category management (how to find the best substitute products for the charcuterie aisle).
  I used the following tools SAS (base V9 and enterprise guide, Stat, Graph, SQL, Macro, Output HTML/RTF...), MS Office

  Technical background: SAS (Base, SQL, Macro, Graph, Stat), SAS 9, SAS 9 - EnterPrise Guide

• Role: Research and survey consultant

  CREDOC (Centre de Recherche pour l’Etude et l’Observation Des Conditions de vie), Paris (France) Name: Research and survey consultancy for marketing projects
  Jan 2003 - Jan 2007

  Description:
  CREDOC is the research center for the study and the observation of living conditions. This center studies the behaviours of French people for more than 50 years and works for different customers (private, ministries, unions...).
  
  Projects: ad hoc marketing projects for industries like Danone, Nestlé, inter-professions, authorities...
  
  My role was project management with creation of market research questionnaires, database management (importation, cleaning, treatment, variables creation on SAS 9, SAS base, stat, graph, output), data analysis (PCA, MDS, modelling on SAS 9, SAS stat and SPAD), reporting and presentations to customers on Word and Powerpoint.
  Publication of a "book of research" on the relation of French attitudes towards prices.
  ********.php?ref=C215
  Main author of the book “Comportements et Consommations alimentaires des Français”, 2006
  ********.php?ref=LI32

  Technical background: SAS (Base, SQL, Macro, Graph, Stat), SAS 9, SAS programming, SPAD

• Analyst

  Moët&Chandon (LVMH), Epernay, France (stage and fixed term contract) Name: Enhancement of the quality of still wines
  Jan 2003 - Jan 2003

  Description:
  Project: Enhancement of the quality of wines (i.e the gustatory and microbiological quality of the Dom Perignon and the Moët&Chandon)
  
  My role was to search for improvement of the quality of the wines starting from their gustatory notes and the parameters of their history by using modelling, PCA with tools such as SPAD, Splus, Statgraphics and Access. Creation and automation of an Access base realizing the dashboards of decision-making aid on Access.

  Technical background: Access, Data Mining, SPAD, SPlus