Frederic - Consultant technique SQL SERVER INTEGRATION SERVICES

From January 2003 IF Solutions s.c.s.
Developer Freelance
 UCM Cas (2014/04-current)
It's mission is to ensure the self-employed person rights to the social security and bring them throughout their career an accompaniment and give them advice on their situation and their social status.
Responsibility: As BI developer, I am in charge to develop an ETL application to migrate data from an old mainframe database to a completely re-designed relational database. I provided as second part in my job, advice and implementation of BI reporting based on QlikView and PowerPivot technology.
Platform: Windows Server 2008, Linux
Database : DB2, PostgreSql
Technology : Pentaho, QlikView, SQL, Excel PowerPivot, java, javascript.

 NIHDI (2012-2014/03)
The NIHDI organizes, manages and supervises the correct application of that «compulsory insurance» in Belgium. The NIHDI is supervised by the Minister of Social Affairs.
The payments of the health insurance funds are only possible thanks to a budget (for 2006: ± 25 billion EUR) that is (roughly speaking) fixed and managed by the NIHDI and placed at the disposal of the health insurance funds.
Responsibility: Data Architect, BI development. Provide solutions to business with the SQL Server technologies, included ETL development and reporting creation. Definition of standards for Databases, ETL, BI Self-Services,…
Organize and implements Database migration from DB2 to SQL Server.
Performance Tuning of SQL queries
Coaching SQL server and BI suite for a new internal development team.
Platform: Windows Server 2008
Database: SQL Server 2005/2008R2/2012, DB2.
Technology: Transact SQL, SSIS, SSRS, SSAS, PowerPivot,.Net (C#).

 Euroconsumers (2010 - 2011)
Euroconsumers is a private independent and non-profit organization that works in Belgium, Spain, Portugal, Italy and Brazil.
The main objectives of Euroconsumers are to promote and defend consumer interests, solve their problems and help them exercise their fundamental rights

Responsibility: Data Architect / DBA, BI development. Provide solutions to business with the SQL Server technologies, included ETL development and reporting creation. Definition of data model, analyse of model performance. As DBA, I was in charge of installation of SQL server instance, replication configuration, performance tuning, creation and monitoring of jobs and security.

Platform: Windows Server 2003/2008
Database: SQL Server 2005/2008/2008R2.
Technology: Transact SQL, SSIS, SSRS, SSAS, .Net.

 Acane Consulting (2010)
 Magotteaux
Responsibility: Analysis of needs with the business users, proposal of several technical solutions to resolve their business problems. Development of ETL (SSIS) and Reporting (SSRS).
Platform: Windows Server 2003
Database: SQL Server 2008.
Technology: Transact SQL, SSIS, SSRS.

Project : Magotteaux primary aim is to help each one of their customers to reduce their
production costs and optimize their installations thanks to high added value products and services, and through a long lasting, open relationship.

Transfer Princing Tool : Through its worldwide activities MAGOTTEAUX Group, the Client, must comply with a strict transfer pricing policy. This compliancy is audited by the statutory auditors as well as by the local Tax authorities on a yearly basis.
The solution provide an automated mechanism to upload data from DWH and the monthly management reporting data into a database and are able to produce reports used for audit and control.

 SWORD Technologies (2007 - 2010)

 BPW (Nestlé and Coca Cola based at Zurich) - BI Developer
Responsibility: Participating to workshop to define the business needs, creation of proof of concept to check the feasibility of the solution. Development of ETL (SSIS), Cube (SSAS), Reporting (SSRS) and integration with SharePoint, InfoPath Services Development, and deployment in several environments from test to production.
Platform: Windows Server 2003
Database: SQL Server 2005.
Technology: Transact SQL, SSIS, SSRS, SSAS, C#, ASPX, MOSS 2007, InfoPath Services.
Project : Beverage Partners Worldwide is the name of the joint venture partnership between The
Coca-Cola Company and Nestlé, created in 2001 as the successor to Coca-Cola and Nestle Refreshments (CCNR) founded in 1991. Coca-Cola and Nestlé hold equal parts in the joint venture. In late 2006, the two companies announced that through their joint venture, they focus on producing and selling drinks based on black tea and green tea.

BPW Finance Project: Scope of the projects (Finance, Sales Management) at BPW is to provide optimized tools to generate Financial and Sales Management reports and dashboards to be used by BPW Financial community, Sales Community and Top Management. These will provide, on a collaborative platform, a set of standard and “user” modifiable reports and KPIs that will show actuals, targets, and will allow the creation of multiple scenarios, budgets, forecasts, and long-term planning.

BPW StageGate Project: StageGate is a tool to provide a user-friendly mechanism to be able to upload periodical concerning all project innovations, review and analyze uploaded information, organize meeting's agenda and consolidate Data in an information system.
Provide a business analysis tool to report trends and business KPI , according to region, period, product .

 GDF Suez - BI Developer
Responsibility: Development of ETL (SSIS), Cube (SSAS), Reporting (SSRS) and integration with SharePoint. Discussion with the business users to improve the concept, deployment and follow up from test environment to production environment.
Platform: Windows Server 2003
Database: SQL Server 2005.
Technology: Transact SQL, SSIS, SSRS, SSAS, C#, ASPX, MOSS 2007.
Project : One of the leading energy providers in the world, GDF SUEZ is active across the entire
energy value chain, in electricity and natural gas, upstream to downstream. The Group develops its businesses (energy, energy services and environment) around a responsible-growth model to take up the great challenges: responding to energy needs, fighting against climate change and maximizing the use of resources.
ASAP project: Development and maintenance of the ASAP Solution. Datawarehouse of sales and purchase department who needed to centralized all information from the group. Exploitation of those information through reporting services of Microsoft (dashboard, reporting,…).

 Fedict Share Services - SQL Server Specialist
Responsibility: Analyse the business problem during workshops, Development of ETL, Development of Reports, coaching of juniors developers.
Platform: Windows Server 2003
Database: SQL Server 2005.
Technology: Transact SQL, SSIS, SSRS, SSAS, SharePoint (MOSS 2007).
Project : Performance management project – Implementation of PPS
Implemented a PPS database and SharePoint visualization through PPS and Excel Services for Fedict, an authority on ICT in Belgium. Fedict started the CUBSC project to improve upon their business processes, in order to analyze what they needed to improve upon and if specific actions led to improvements, they created Key Performance Indicators (KPIs). The goal of the project was to track these KPIs through PPS in the form of scorecards and interactive graphs in SharePoint. By using PPS we were able to deliver an end-user centric application that tracked a sub-set of these KPIs, so that they could build upon this to create the rest themselves after training. By using a combination of Visual Studio BIDS and PPS we were able to create the advanced calculations needed for some KPIs (normalization, prioritization…) while keeping it easy to understand

 CMI - Microsoft Specialist
Responsibility: Development of ETL (SSIS) and InfoPath Services.
Platform: Windows Server 2003
Database: SQL Server 2005.
Technology: Transact SQL, SSIS, InfoPath Services, SharePoint.
Project : The CMI (Cockerill Maintenance & Ingénierie) Group, a respected industrial partner
serving international clients, designs, modernizes and maintains equipment in the Energy, Defense and Industry sectors. Its goal is to improve the economic, technical and environmental performance of its clients’ equipment.
The Group is known for its combination of experience in Engineering and Maintenance, supported by an organization that promotes the pooling of expertise and specialties. The CMI Group is close to its clients thanks to its local offices and its sales network, which is coordinated by six representative offices worldwide. It can thus offer its clients tailor-made solutions for their equipment needs.

CMI – Quality, Security, Environment (Human Resource Management). The scope here was to provide CMI with a collaborative environment and BI tool to implement a “user” friendly solution, providing a user interface for input and output reports using Microsoft PerformancePoint 2007. It is constructed to let key “super” users easily re-deploy Analysis Services Cubes maintained through PerformancePoint for changes in dimensions and other structural or content driven characteristics and parameters.

 CBFA - SQL Server Specialist
Responsibility: Analyse the business requirements with key users, development of reports, coaching.
Platform: Windows Server 2003
Database: SQL Server 2005, Oracle.
Technology: Transact SQL, PL-SQL, SSRS.
Project : The CBFA, created as a result of the integration of the Insurance Supervisory Authority
(ISA) into the Banking and Finance Commission (BFC) is since 1 January 2004 the single supervisory authority for the Belgian financial sector.

Several Reports and Documents need to be generated to control financial institution

 SNCB - SQL Server Specialist
Responsibility: Development of SSAS Cube and ETL (SSIS).
Platform: Windows Server 2003
Database: SQL Server 2005.
Technology: Transact SQL, SSIS, SSAS.
Project : Within the framework of a POC of interaction with PerformancePoint, a cube was to be created and filled.

 Allianz (AGF Belgium) 2006 - 2007)
 .Net Software Engineer
Responsibility: applications maintenance, Support, Backup DBA.
Platform: Windows Server 2000 / 2003
Hardware: Compaq Server.
Database: SQL Server 2000/2005.
Technology: Transact SQL, DTS, SSIS, Reporting Services, C#(1.1), VB6, Com+ , Biztalk
Description: In Belgium, Allianz is one of the main players on the insurance and financial
services market.

Allianz offers a complete range of property and casual insurance (fire, accident and
miscellaneous risks) and life insurance (Provisions and Investments) to individuals,
self-employed individuals, SME and large companies.

Allianz have chosen to offer their products and services exclusively through professional
insurance brokers. They are the intermediaries between customers and our company.

The company employs more than 1,100 people in Belgium and is a subsidiary of Allianz, world
leader in insurance and asset management. Prior to 1 December 2007, the company was called
AGF Belgium Insurance.

The mission for the company is to create a specific team to organize, control and test all
application deployment and maintenance. To create this team it is needed of train some people
and create an interaction between the architect team, development team and the business.
In addition, I need to give support to the DBA team and provide development support.

 SPF Mobilité et Transports (2004 -2006)
 Database administrator SQL Server 2000. ( Undetermined )
Responsibility: Daily maintenance of servers.
Platform: Windows Server 2003
Hardware: Compaq server.
Database: SQL Server 2000.
Technology: Transact SQL, DTS and Reporting Services.
Description: Daily maintenance of server Sql (Backup, monitoring, etc…).
Import and export data from « package DTS ».
Creation and configuration of reporting with « Reporting Services »

 Hermes (6 months)
Responsibility: Definition of architecture and development.
Platform: Windows 2000/Xp / Windows Server 2003
Hardware: Laptop compatible Intel + server (hosting).
Database: MS Access 2000 (client), Oracle 9 (server).
Technology: Visual C# (Forms), SQL, XML, crystal reports, Business Object.
Description: The SPF/FOD Mobilité et Transports is in charge of the control of all transport
(road, railway, airlift and river) in Belgium.

In order to control of the road transport, the organization has an tool created to save the history of truck and drivers traffic violation.

 Reporting (punctually)
Responsibility: Definition of report and access management
Platform: Windows 2000 / Xp / Windows Server 2003 / Unix
Database: SQL Server 2000 / 2005, Oracle 7.
Technology: SQL Server Reporting Services, Business Object.
Description: Creation of reports for data control from different applications.

 Euro Argus s.a. (2003-2004)
 Mediascore 3.0 (6 months)
Responsibility: Analyse, architecture, development, database design and project management.
Platform: Windows Xp / Windows Server 2003
Database: SQL Server 2000.
Technology: Visual C# (Forms), T-SQL.
Description: Mediascore 3.0, the scientific media analysis tool
Euro Argus is specialized in press monitoring and media analyses. Based on a scientific concept
and certified by three universities (Katholieke Universiteit Leuven, Université Catholique de
Louvain, Vrije Universiteit Brussel, Stichting Marketing), our research tool offers quantitative
and qualitative analyses of the media impact.

In order to assess a relevant media strategy, you need to measure your media impact, your communication and pr work and you need to react in crisis situations. Euro Argus proposes quantitative and qualitative media analyses under its label Mediascore 3.0, a scientific tool of our analyses department.

Euro Argus provide you analysis of each article 4 hours after its publication in the Belgian press and 48 hours for the foreign press. Every article is read, analysed and commented, allowing you to be informed about the quantitative and qualitative impact. To offer the possibility to react quickly Euro Argus can integrate an 'alert-service' (short messages) by e-mail. A compilation of the articles in the form of graphics and comments can also be ordered.

This service also exists for international analyses. Euro Argus has a team of analysts for the international press. Working with native speakers in different countries guarantees accurate analyses.

 Mediascore Online (3 months)
Responsibility: Analyse, architecture, development, database design and project management.
Platform: Internet, Windows Server 2003
Database: SQL Server 2000.
Technology: Visual C#, Asp .Net, T-SQL.
Description: The applications provide you the possibilities to make several analyses based on the data introduced in Mediascore tools. Application to give the possibility of the self-creation of statistics in real time.
The customer has the capabilities to generate a grid statistics with sorting and grouping and different chart statistics. It is also possible to export data directly into a Ms Excel file.
SQL server replication is configured for data updating on web server.

 Investeringsfonds voor de persverspreiders – IVP (2002-2011)
 Ekassa System ( Undetermined )
Responsibility: Analyse, architecture, development, database design and project management.
Platform: Windows 98se / Me / 2000 / Xp / Windows SBS Server
Database: SQL Server 2000 (MSDE).
Technology: Visual Basic 6.0, T-SQL.
Description: Investerings fonds voor de persverspreiders (IVP) is an association between some Belgium press diffusers.

The role is to organize and provide services to bookstore.
Ekassa is Cash register system dedicated to the bookstore Belgium business.

Mar 2000 to Nov 2002 Skillteam s.a. Brussels
Application Developer
 Production Labelling System
Responsibility: Development and installation on production.
Platform: Windows
Hardware: PC compatible Intel
Technology: Visual Basic 6.0, Ms Word 2000
Description: Labelling system for packaging and distribution. Using the mail merge function of office 2000 with different templates for label format.

 Central Library
Responsibility: Analyse of modifications and modify existing application.
Platform: Windows
Hardware: PC compatible Intel
Database: SQL Server 6.5
Technology: Visual Basic 6.0, SQL
Description: Application of management for customer jobs historic.

 Central Library (Intranet)
Responsibility : Analyse of modifications and modify existing application
Platform: Internet, Windows
Hardware: PC compatible Intel
Database: SQL Server 6.5
Technology: Visual Basic 6.0, ASP 3.0, T-SQL
Description: WEB Application to consult customer historic.

 Ekassa System
Responsibility: Analyse, architecture, development, database design and project management.
Platform: Windows 98se / Me / 2000 / Xp / Windows SBS Server
Hardware: PC Compatible Intel.
Database: SQL Server 2000 (MSDE).
Technology: Visual Basic 6.0, T-SQL.
Description: Point of sales applications for book shop with stock management and sales statistics.

 Mediascore 2.0
Responsibility: Recuperation of project for finalize them.
Platform: Windows.
Hardware: PC compatible Intel + Compaq server.
Database: SQL Server 7.
Technology: Visual Basic 6.0, SQL.
Description: Application of media analyses, data encoding and statistics generation.

 JEPP
Responsibility: Development.
Platform: Internet, Windows
Hardware: PC compatible Intel
Database: SQL Server 2000
Technology: Visual C#, XML
Description: WEB Application for creation of response to an offer of the public market.

Jul1996 to Feb 2000 Cel Data Services Brussels
Field Engineer
 Field engineer for bank agency and head office.
May 1995 to Jun 1996 NCR Corp. Brussels
Database management
 Management of data’s and participation to migration of data’s to a new system based on Oracle.