CV/Mission de Consultant powerpivot freelance

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

WORK EXPERIENCE

1 Jul 2015-Present
Freelance - Solution Architect
RoQ insights
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.

Project REBECA - Forecasting and Budgeting tool
Client Orange Business Services
Dates Since Jul 2015
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
Role Managing a team of 5 developers. Solution designing in interaction with business owners and
business analysts.

Project Rebeca 2
Client Orange
Dates April to July 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

Project Mobile application POC
Client Startup confidential
Dates April to September 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.

Project Région Globale dashboard
Client Project Management Institute France
Dates February 2017
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

Project Trainer on Microsoft BI Architectures
Client L'Oréal Asia Pacific - Hong Kong
Dates September and December 2016
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
Jan 2011-Jun 2015
Senior Solutions Architect
Capgemini, Paris France
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
Project REBECA - Financial forecast
Client Orange
Dates Since Nov 2014
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

Page 2 / 8
Curriculum vitae
Helder ********
Dates Oct 2014
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
Project L'Oréal - iPanel
Dates Nov 2011 - Sep 2014
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
Project BMS Biopharmaceutical - CRM Business Intel igence
Dates March 2011 - Oct. 2011
Summary Evolution the Business Intel igence system over the EMEA medical representative's
activity contained in the enterprise CRM. The system gets al the data from the CRM database,
transforms and maps the data using ETL components and a web application, and constructs an
OLAP cube containing aggregations about Cal s, Objectives, Tier Segmentation and so on. This cube
contains 52 measures and 24 dimensions. The biggest chal enge was to deal with the CRM data
complexity using near 100 SSIS packages.
Role Team Leader - Tasks assignment and control having a team of 5 people. Technical advisor.
Technology Microsoft BI SharePoint 2007, PerformancePoint 2007, SQL Server 2008 R2
SQL,SSAS, SSIS, SSRS , Oracle10G, ASP.NET 3.5
Business or sector IT
Jul 2005-Nov 2010
Solutions Architect / Project Manager
GFI Informatique, Lisbon Portugal
GFI was the place where I developed my career of consultant starting as Junior Developer and sorting
as Solution Architect and Project Manager. I started by mainly having a technical role that evolved, in
the last 2 years, into a more business related role of pre-sales and project management.
In this company I participated in near 20 projects from which I would like to highlight the fol owing
ones

Page 3 / 8
Curriculum vitae
Helder ********
Project IPO - Portuguese Institute of Oncology - ShareLab
Dates 2010
Summary Core software conception for the Hemato-Oncology Laboratory of Instituto Português de
Oncologia, the main Portuguese oncology hospital. It was designed and brainstormed during several
months with the col aboration of Physicians Medicine Professors , Biologists and Computer
Engineers.
ShareLab was designed to manage al the genetic analysis live cycle within the laboratory, providing
the col aboration ways between the 3 sections of the laboratory Flow Cytometry, Cytogenetics and
Molecular Biology; it also improv...