CV/Mission de Consultant powerpivot freelance

Exemple de missions de Helder,
Consultant powerpivot habitant les Hauts-de-Seine (92)

• Client Startup confidential
  Jan 2017 - Jan 2017

  Summary Mobile aplication for a confidential use case, something like an Airbnb with IoT. It includes
  the development of an Android application for mobile phone with geografical data, Beacons and IoT
  using Raspberry Pi. The server side is hosted on Google Cloud Firebase.

  Technologies Android Studio, Eclipse, Java 8, Node.js, Google Firebase Real Time and Firestore NoSQL databases.

• Role Managing a team of 5 developers. Solution designing in interaction with business owners and business analysts.

  Client Orange
  Jan 2017 - Jan 2017

  Summary Conception and implementation of a revenue forecast POC. Evolution of the Rebeca tool
  having a web user interface ful y Javascript, JSON, REST. Decision support and automatic data
  adjustments using Machine learning. Al the reporting in SSAS feeded in near real-time with SSIS.
  Development of an API using ASP.NET Core Web API.
  
  Page 1 / 8
  Curriculum vitae
  Helder ********

  Technologies NoSQL Elastic Search, R, JavaScript, EXTJS, ASP.NET Web Api, SQL Server 2016 SSAS, SSIS, SSRS, ABINITIO, C#, DAX, MDX

• Client Project Management Institute France
  Jan 2017 - aujourd'hui

  Project Région Globale dashboard
  Summary Development of a reporting dashboard for the "Région Globale" of Project Management
  Institute France. It characterizes the worldwide based PMI France members over the time with trends
  and evolution KPI's.
  Technologies Power BI online and desktop, DAX, M

• Client L'Oréal Asia Pacific - Hong Kong
  Jan 2016 - Jan 2016

  Project Trainer on Microsoft BI Architectures
  Summary Prepared and delivered a training about Microsoft Business Intel igence architecture for
  the internal team of L'Oréal.

  Technologies SQL Server 2016 SSAS, SSIS, SSRS, PowerPivot, Power BI

• Solution Architect

  RoQ insights
  Jan 2015 - aujourd'hui

  Works as freelance helping clients conceiving solutions with custom developments. Specialized in
  near real time Business Intel igence, Machine Learning and SOA solutions.
  I'm very technical, I love programming languages, algorithms, data structures, paral el and distributed
  computing, real time computing, cryptography and security algorithms. But my strongest point is the
  understanding of the functional requirements and the conception and optimisation of the solution
  ergonomics to accomplish the process.
  I also have a continuous experience and university degree in Project Management.

• Client Orange Business Services
  Jan 2015 - aujourd'hui

  Summary Conception and development of a solution for revenue forecasting for al the International
  Business of OBS. It included the development of an Excel Add-In to adjust data on SSAS cubes in
  real time, using C# and VSTO. It includes the development of an SSIS paral el execution Scheduler,
  capable of asynchronously launch SSIS packages and control execution graphs, taking into account
  dependencies and priorities.
  Master Data Management was implemented on SQL Server 2016 MDS where we stored al the
  referentials, with the ability to update and versioning it, together with the access rights and
  responsibilities matrix for each Referential.
  We built a standard injection mechanism able to trigger, accept and reject data treatments. For al
  sources we configured the interface contract, including mapping with referentials and data validations
  rules like data type, mandatory/optional. Over this standard injection mechanism, we built Data
  Quality standard reports able to show errors or warnings on input files. Those reports were used for al
  kind of files, behaving particularly accordingly with the configured interface contract.
  Responsible by Microsoft licenses assignment and optimization and for Cloud P&L.

  Technologies Excel VSTO, SQL Server 2016 SSAS, SSIS, SSRS, SharePoint 2013, C# Visual Studio 2015, WebServices, VMware vSphere Orange cloud , DAX, MDX

• Client Orange
  Jan 2014 - aujourd'hui

  Project REBECA - Financial forecast
  Summary Construction of a Forecast solution using SSAS cubes tabular and multidimensional ,
  ASP.NET, SSIS, SSRS and SharePoint. The solution receives files on the SharePoint site and treats
  al the data using Integration Services. The cube is refreshed with the new data some seconds after
  the user submits it to the SharePoint site.The solution is highly customized using multithreading c# on
  al levels SharePoint, ASP.NET, SSIS, SSAS stored procedures and SSRS web services. The control
  of the solution is implemented using SharePoint Workflows.
  As part of the deliverable was the configuration of a SharePoint 2013 farm, including SQL 2014
  Business Intel igence components PowerView and PowerPivot.Also included the configuration of the
  distributed security between servers using Kerberos.

  Technologies SQL Server 2014 SSAS, SSIS, SSRS, DQS, PowerView, PowerPivot, SharePoint 2013, C# Visual Studio 2013, WebServices Project People localization using Wi-Fi

• Helder
  Jan 2014 - aujourd'hui

  Summary Using Wi-Fi data sent by smartphones, tablets and laptops, the system is able to localize
  people in public buildings. It consists in a set of receivers placed on the building capturing frames sent
  by devices sending data, or simply trying to reach an access point. The data is captured using .Net
  specific development for the wireless cards, then is transmitted in near real-time to an Apache Spark
  server that synchronizes the streams coming from the dif erent receivers. The synchronized stream is
  used to query a trained neural network Microsoft Analysis Services and places de results in a
  database.
  This system was developed in the context of a proof of concept Apache Spark Streaming.
  Main responsibility Ful conception and development

  Technology Apache Spark, Java 8, Hadoop, Microsoft SQL Server 2014, .Net

• Jan 2011 - Jan 2014

  Project L'Oréal - iPanel
  Summary Development of a Business Intel igence solution containing data about the worldwide
  sales of cosmetics. It receives data from each country in several file formats using SSIS and .NET
  parsing. A web application was developed to control al the system operations and proceed to the data
  treatment involving reference data management and mappings. At the end of the treatment the data is
  stored in a data warehouse and published to the users in a SSAS cube. The system receives data
  from more than 30 countries containing near 15 bil ion of facts a month and updates data in less than
  one minute.
  Main responsibility Solution Architect Design of a solution to deal with a large data volume in real
  time, using a web application that al ows to instantly scrol ing over lists and trees of hundreds of
  thousands of dimension members. Designing of large data files parsers to receive and store several
  GB of data in some seconds. Design databases for real time mapping and al ETL needed to
  accomplish the data warehouse feeding. Conception and implementation of several algorithms for
  data treatment al owing the publication of new data in the SSAS cube on some seconds.
  Development of several system parts using .NET, SSIS, SQL and SSRS. It also included a
  datamining proof of concept using Microsoft Time Series Algorithm for sales predictions.

  Technology Microsoft BI SQL Server 2012 SQL, SSAS, SSIS, SSRS Oracle11G, ASP.NET 4, .NET 4, ExtJs 4.1

• Senior Solutions Architect

  Capgemini, Paris France
  Jan 2011 - Jan 2015

  My main role in Capgemini was to conceive information systems architectures adapted to the Vision
  and Strategy of our clients, led by business and business benefits. Deal with clients is one of my
  preferred tasks in either contexts of pre-sales or project.
  In the fol owing paragraphs I present the main Capgemini projects where I've been