Frederic - Consultant technique SQL SERVER INTEGRATION SERVICES

Ref : 141209P002
Photo de Frederic, Consultant technique SQL SERVER INTEGRATION SERVICES
Compétences
SQL
SQL SERVER ANALYSIS SERVICES
SQL SERVER REPORTING SERVICES
Expériences professionnelles
  • 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.

Études et formations
  • Formation
    1998 Cours Commerciaux & Industriels de la ville de Wavre Wavre
     Attestation of higher education : Oracle
     Attestation of higher education : Windows NT Server 4.0

    1996 EPHEC Brussels
     Graduate in computer science.

    1994 Institut Technique de Namur Namur
     Certificate of secondary education
     Certificate of qualification in Computer Science

    Certificats
     Microsoft Certified IT Professional : Database Administrator
     Microsoft Certified IT Professional : SQL Server 2008 Business Intelligence
     Microsoft Certified Technology Specialist : SQL Server 2005
     Microsoft Certified Technology Specialist : SQL Server 2008 Business Intelligence
     MCSA SQL Server 2012
     Microsoft Certified Technology Specialist : .Net 2.0 Web-Based Client Development

    Other Formations
     UML Overview
     Java Basics and J2EE
     T-Sql
     Updating your database development skills to Microsoft SQL Server 2005
     Programming With C#
     .Net C# and Visual Basic
     Building Knowledge Management & Collaboration Solutions based on Microsoft Products and Technologies
     Developing & Deploying MS BizTalk Server 2000 Solutions
     Exchanging and Transforming Data Using XML and XSLT
     Active Server Page 3.0
     Modélisation Orientée Objet (UML)
     Windows 2000
     Microsoft Visual Interdev 6
     Java 1.1

    Languages
     French: Native Language.
     Dutch: Intermediate.
     English: Intermediate.

D'autres freelances
DBA SQL

Ces profils pourraient vous intéresser !
CV Administrateur Bases de Données ORACLE
Noel

Administrateur Bases de Données ORACLE

  • CHAMBÉRY
SQL ORACLE SQL SERVER
Disponible
CV Ingénieur de développement JAVASCRIPT
Soufiane

Ingénieur de développement JAVASCRIPT

  • MAISONS-ALFORT
CRM PYTHON OpenERP Angular C# ASP.NET .NET SQL MYSQL JAVA
Disponible
CV Data Analyst Google Cloud Platform
Arthur

Data Analyst Google Cloud Platform

  • PARIS
BIGQUERY SQL GIT GITLAB APACHE HIVE DATA Google Cloud Platform APACHE HADOOP APACHE SPARK PYTHON
Disponible
CV Administrateur Bases de Données SALESFORCE
Oraud

Administrateur Bases de Données SALESFORCE

  • CARRIÈRES-SOUS-POISSY
SALESFORCE AGILE SQL JAVA
Disponible
CV Ingénieur de développement JAVA
Ali Msahazi

Ingénieur de développement JAVA

  • ALFORTVILLE
JAVA J2EE JAVASCRIPT SQL Angular REACT.JS Spring Boot UML POSTGRESQL MERISE
Disponible
CV Développeur
Serigne Souhaibou Mbacke

Développeur

  • PARIS
PHP SQL HTML5 CSS WORDPRESS JAVASCRIPT REACT.JS React Native
Disponible
CV Administrateur Bases de Données SQL SERVER
Didier Tu Sais De Dieu

Administrateur Bases de Données SQL SERVER

  • CHAMPS-SUR-MARNE
SQL WINDOWS MYSQL AGILE UNIX PROJECT MANAGEMENT OFFICE SQL SERVER LINUX SAP
Disponible
CV Développeur C#
Olivier

Développeur C#

  • MONTLUÇON
C# SQL PHP SQL SERVER .NET Microsoft Power BI ASP.NET MVC JAVASCRIPT MYSQL IIS
Disponible
CV Consultant automatisation des tests AGILE
Adel

Consultant automatisation des tests AGILE

  • PARIS
AGILE JIRA SQL SQUASH TESTLINK JAVASCRIPT POSTMAN
Disponible
CV Data Analyst
Safia

Data Analyst

  • TOULOUSE
SQL Microsoft Power BI PYTHON DATA SQL SERVER EXCEL APACHE SPARK Google Cloud Platform AZURE BIGQUERY
Disponible