freiberufler Microsoft BI Architect auf freelance.de

Microsoft BI Architect

offline
  • 80€/Stunde
  • 92600 Asnières sur seine
  • Weltweit
  • fr  |  en
  • 06.11.2013

Kurzvorstellung

7 years of experience in MS BI 2005/2008/R2/2012

Qualifikationen

Projekt‐ & Berufserfahrung

BI Architect
Laboratories Servier -, Paris
10/2011 – 12/2012 (1 Jahr, 3 Monate)
Life Sciences
Tätigkeitszeitraum

10/2011 – 12/2012

Tätigkeitsbeschreibung

Technical Environment: TFS 2010, SQL Server 2008 R2, SSIS 2008 R2, SSAS 2008 R2, SSRS 2008 R2, MDX, Asp.net
4.0, C # .Net, Objective-C, Xcode..

Design and delivery of a “CoreSystem” architecture that can be used in many countries.
Validation of the architecture by Microsoft (Marième Dieng).
Development of an MDX generator.
Development of a translation module for reporting.
Establishing security cubes and reports.
Development of the BI solution for Slovenia.
Participation in the development of solutions in Belgium and Portugal.
Development of an export tool for SSRS reports and automation of synchronisation of those
documents in iPad by an in house tool called “eVisualAid”.
Design and development of a website encapsulating reports and allowing the complete
translation of reports (prompts and content).
Development of a prototype of analysis on iPad.
Technical and functional documentation.

Technical Reference,
Eiffage, Paris
10/2010 – 10/2011 (1 Jahr, 1 Monat)
Versorgungswirtschaft
Tätigkeitszeitraum

10/2010 – 10/2011

Tätigkeitsbeschreibung

Technical environment: SVN, SQL Server 2005, SSIS 2005, SSAS 2005, SSRS 2005 MDX.

Collection of need and definition of input files specification.
Technical Reference, supervision and participation in development.
Implementation of an architecture based on three cubes and an MDX code generator.
Development of packages of the “ trainings “ data mart of the Sextant project.
Development of analysis cubes and calculation of indicators.
Development of reports.
Documentation.

MS BI Consultant
McDonald's France, Paris
4/2010 – 8/2010 (5 Monate)
Großhandel
Tätigkeitszeitraum

4/2010 – 8/2010

Tätigkeitsbeschreibung

Technical Environment: SQL Server 2008, SSRS 2008 MDX, XML, Bristol Report.

Designing of setting tables.
Development of stored procedures to run MDX code and dynamic TSQL.
Management of access rights.
Development of 4 reports that replace existing Bristol reports.

ETL Architect
VALEO, Paris
3/2010 – 9/2010 (7 Monate)
Automobilindustrie
Tätigkeitszeitraum

3/2010 – 9/2010

Tätigkeitsbeschreibung

Technical Environment: SQL Server 2005/2008, SSIS 2005/2008.

Need definition with SAP BWCC team
Analysis of existing ETL solution (Microsoft SSIS - SQL Server 2005)
Definition of the new architecture.
Validation of the new architecture by Microsoft (Olivier Pieri).
Implementation of new features (parallelism, job logic, data profiling, monitoring).
Flows acceleration using multithreading.
Setting up migration SQL Server 2005 to SQL Server 2008 R2.
Validation of data quality.
Communication with the Indian operational team.

MS BI Trainer
B & D, Zurich
4/2008 – 4/2008 (1 Monat)
Telekommunikation
Tätigkeitszeitraum

4/2008 – 4/2008

Tätigkeitsbeschreibung

Technical Environment: SQL Server 2005, PerformancePoint 2007.

Introduction to SQL Server 2005
Presentation of some ETLS especially SSIS
SSIS Workshops with practical case: supplying PerformancePoint Planning model.

MS BI Consultant
MORNAY, Paris
11/2007 – 2/2010 (2 Jahre, 4 Monate)
Soziale Einrichtungen
Tätigkeitszeitraum

11/2007 – 2/2010

Tätigkeitsbeschreibung

Technical Environment: Oracle, PL / SQL, ACCESS / VBA, Power Designer, SQL Server 2008 (SSIS, SSRS, SSAS), Excel
2007, C# .Net.

Existent system Analysis (Access, VBA, PL/SQL).
Definition of new data models.
Definition of new partners and suppliers Data integration architecture.
Data recovery from the old system.
Development of the global data integration solution.
Development of many operational reports based on monitoring data model.
Development of data interaction packages between a CRM and a marketing campaign tool.
Design and development of data integration packages of a marketing data mart.
Development of analysis reports using Excel 2007.
Development of a jobs administration console (C#).
Automatic matching of duplicated entries and development of manual reconciliation GUI

Designing a cube analysis of behavioural indicators.

MS BI Consultant
SEPHORA (LVMH), Paris
4/2007 – 9/2007 (6 Monate)
Großhandel
Tätigkeitszeitraum

4/2007 – 9/2007

Tätigkeitsbeschreibung

Multidimensional modelling of a data warehouse and a data mart for the website “sephora.fr”.


Calculation of CBI (Customer Behavioural Indicators).
Establishment of a reconciliation data mart reconciling data of retail and e-commerce.
Development of batches feeding data warehouse with SSIS (SQL Server 2005)
Development extraction packages using DataStage 7.5
Development of T-SQL stored procedures.

Technical Environment: SQL Server 2005, SSIS, TSQL, DataStage 7.5 PowerDesigner11, Visio 2007.

BI Consultant
SNCF, Paris
12/2006 – 3/2007 (4 Monate)
Versicherungen
Tätigkeitszeitraum

12/2006 – 3/2007

Tätigkeitsbeschreibung

Design and development of monthly reports using Cognos ReportNet.
Calculation of indicators for Thalys and freight trains.
Recipe and validation.

Technical environment: Orcale 10g, Cognos ReportNet 1.1 Powerplay Cubes.

BI Consultant
RATP, Paris
6/2006 – 9/2006 (4 Monate)
Versicherungen
Tätigkeitszeitraum

6/2006 – 9/2006

Tätigkeitsbeschreibung

Design and supply data marts using SSIS 2005.
Calculation of indicators of the security department.
Design and development of OLAP analysis.
Participation in the development of “decision-portal” using ASP.NET, C#, SSRS 2005.

Technical Environment: SQL SERVER 2005, TSQL, SSIS, SSRS, SSAS, ASP Net, C# .Net.

DiplomArbeit
IFN - TU, Braunschweig
1/2006 – 6/2006 (6 Monate)
Versicherungen
Tätigkeitszeitraum

1/2006 – 6/2006

Tätigkeitsbeschreibung

Participation in the project of handwritten Arabic script recognition.
Usage of hidden Markov models and reference database of the IfN.
Study and interfacing with multiprocess and multithreaded HTK.
Implementation of GUI for learning and recognition of input images and generation of HMM and the resulting
text.

Technical Environment: Visual C + + 8, MFC, STL, MATLAB, HTK, MS Visio.

Über mich

sehr unabhängig

Weitere Kenntnisse

SSAS,SSIS,SSRS,MDX,TSQL,SQL Server 2005/2008/R2/2012

Persönliche Daten

Sprache
  • Englisch (Fließend)
  • Französisch (Muttersprache)
Reisebereitschaft
Weltweit
Arbeitserlaubnis
  • Europäische Union
Home-Office
bevorzugt
Profilaufrufe
1506
Alter
41
Berufserfahrung
17 Jahre und 9 Monate (seit 06/2006)

Kontaktdaten

Nur registrierte PREMIUM-Mitglieder von freelance.de können Kontaktdaten einsehen.

Jetzt Mitglied werden