Microsoft BI Architect
- Verfügbarkeit einsehen
- 0 Referenzen
- 80€/Stunde
- 92600 Asnières sur seine
- Weltweit
- fr | en
- 06.11.2013
Kurzvorstellung
Qualifikationen
Projekt‐ & Berufserfahrung
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.
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.
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.
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.
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.
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.
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.
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.
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.
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
Weitere Kenntnisse
Persönliche Daten
- Englisch (Fließend)
- Französisch (Muttersprache)
- Europäische Union
Kontaktdaten
Nur registrierte PREMIUM-Mitglieder von freelance.de können Kontaktdaten einsehen.
Jetzt Mitglied werden