-
ibex consulting
- Big Data Analyst / Developer
2015 - maintenant
Self-learning topics:
• Big Data products such as Hadoop, Pig, Hive end Impala, Linux using Hadoop virtual machine Cloudera
-
Groupe SPB
- Analyst & Data Analyst
Le Havre
2014 - 2014
operates as a broker and is European leader in affinity insurances and services for more than 100 major brands, with implantations in 12 countries
Le havre - France Data Migration from SAS to SQL Server 2008 R2
Reports Migration from SAS to SSRS 2008
SQL- 2008R2 Frequent communication with business regarding in business needs gathering
SSIS I developed professional reports to replace SAS replace
SSRS
-
RealDolmen
- Lead ETL Developer & Data Architect
2013 - 2014
Cleaning and migrating data from SQL SERVER 2000 to SQL Server 2008 R2 using SSIS 2008
SQL- 2008R2 * BI Architect
TFS As Senior BI Consultant, I worked in a leadership role to set a BI environment in a highly secure environment.
DWH Modeling I built a data warehouse diagram, I used Kimball methodology.
SSIS, SSAS I developed ETL package, to load data into Data warehouse.
Kimball Best Practice The data warehouse contains 12 fact tables
-
Johnson Controls
- SAP Crystal Reports Migration
Colombes
2013 - 2013
Belgium Replace SAP Crystal Reports with Microsoft Reporting Services(SSRS 2012) in relation to a new ERP (iScala) migration ,
-
ibex consulting
- SQL Developer
2013 - 2013
SQL SERVER 2012 I migrated data from SQL SERVER 2008 to SQL SERVER 2012 of Databases, ETL Package and Reports.
SSIS Preparing the certification:
SSAS Implementing a Data Warehouse with Microsoft SQL Server 2012
SSRS
-
EUROPEAN COMMISSION
- Data Migration Specialist
2011 - 2013
Cleaning and migrating data from Oracle, SQL SERVER 2000, mySQL and Excel to SQL Server 2008 R2 using SSIS 2008
I had to develop a thorough understanding of the system that was to be turned off. The first step was to model the legacy system in its entirety.
SQL SERVER 2008 R2 Before it was moved, the data must be read, understood and translated, while obsolete elements need to be discarded.
SSIS I developed a migration strategy and approach; I defined the scope, schedule, technical requirements and a detailed execution plan.
SSAS
SSRS I developed migration routines; validated business requirements for historical data, data analysis, mapping and referential integrity and certification scripts.
Power Designer I completed end-to-end migration while coordinating with business users in completing data validation, verifying and evaluating the control mechanism and metrics.
I executed full-scale migration into the production environment.
Microsoft SharePoint 2010 * BI Project
I worked with the business to gather business requirements, created data models based on these requirements and designed BI functionality to meet these needs
Agile project management techniques I designed and implemented DW and BI architecture
I designed data models and databases to implement these models
TFS Source Control I integrated data from other applications
I developed OLAP Cube.
I produced reports from OLAP (Cube) with Reporting Services (SSRS 2008) with intensive use of MDX
-
ArcelorMittal
- BI Consultant
2011 - 2011
I built a Data Warehouse using SSIS ,
-
Fortis Bank
- DataStage / Data Migration Consultant
2009 - 2010
Amsterdam I migrated customer account data (retail) from Fortis Bank to ABN AMRO Bank.
NETHERLANDS
DataStage In terms of migration volumes, 1.7 million customers have their account and related products migrated.
I designed, implemented, tested, and deployed parallel DataStage solutions.
I demonstrated knowledge of parallel concepts (data collection, data skew, data partitioning, buffers, sorting, aggregation, data collecting.
-
ibex consulting
- Data migration
2009 - 2009
I migrated data from SQL SERVER 2005 to SQL SERVER 2008 of Databases, ETL Package and Reports
-
Imperial Tobacco
- Senior BI Consultant
Paris
2008 - 2009
With numerous sales regions in approximately 130 countries throughout Europe, Imperial Tobacco needed a comprehensive business intelligence solution that could provide more effective business planning and forecasting abilities.
Belgium I worked in reporting services, we created several reports to better present the company information for the top management to track actual results against targeted levels.
I completed functional analysis including Business Requirements gathering, formalising reports based on the outcomes of interactions with the Clients.
SQL SERVER 2005 I built OLAP Cube with Analysis Services (SSAS 2005)
-
Allianz
- ETL Architect & Project Manager
Puteaux
2008 - 2008
Building data Warehouse for Insurance department
Belgium I managed a development team
I participated in the full lifecycle of ETL software development - analysis, design, build, documentation and testing.
SQL SERVER 2005 I collaborated with analysts, technical leads, business partners and developers
SSIS I organized a series of interviews with the people that run the business and have knowledge of all activities and processes
I analyzed source systems and created a mapping to the target database schema
CA ERwin® Data Modeler I defined and implemented the required business transformation rules and logic (ETL development)
I reviewed the conceptual data model and data mappings to ensure adherence to stakeholder and internal team needs
SharePoint I defined a suitable architecture for data integration from multiple, disparate data sources (including legacy systems, relational databases, flat files, etc).
-
SIGI
- Senior BI Consultant
2008 - 2008
Luxembourg I implemented business intelligence dashboards using MOSS 2007 Report Center & Excel Services producing different summary results based on user view & role membership.
I built OLAP cube with Analysis Services (SSAS 2005)
-
Moêt & chandon
- DATASTAGE Consultant
2007 - 2007
I processed the data (coming from SAP R/3) in DataStage
FRANCE Server jobs
I created and managed the modification of Sequences
DataStage I updated jobs and sequences with new business roles
SAP I validated, ran and monitored jobs using DataStage Director
Oracle Deployment
I wrote scripts to CREATE table, UPDATE table, ALTER table, ADD
columns, DROP or MODIFY columns.
-
Telindus
- BI Consultant
LES ULIS
2007 - 2007
I developed reports for Help Desk service (Clarify database) using SQL Server Reporting Services 2005
-
bposte
- BI CONSULTANT
2006 - 2006
-
careworks - Dublin
- BI Consultant
2006 - 2006
Ireland I developed professional reports using SQL Server Reporting Services.
I authored reports using the Report Designer. I deployed and published these reports.
-
Philip Morris International
- BI Consultant
Lausanne
2006 - 2006
I developed professional reports using SQL Server Reporting Services.
I authored reports using the Report Designer. I deployed and published these reports.
-
Deutsche bank
- Quality assurance
Paris
2005 - 2005
I managed Quality Assurance (QA), Testing, Security (ASP Web application),
I used DTS (Data Transformation Services) and Data Warehouse, downloading AS400 Files to SQL Server tables (BCP, DTS) including
Tables, Views, stored procedures ,UDF, Cleanup Database , Shrinking Database
-
Fiat
- Functional Analyst
Trappes
2002 - 2005
I produced reports from OLAP(Cube) with Reporting Services (SSRS
SSAS I extensively used MDX
SSRS
-
EUROPEAN COMMISSION
- Consultant
2000 - 2001
EUROPEAN COMMISSION I designed, implemented, deployed and updated the official website for TAIEX (Directorate-General: Enlargement. European Commission) http://taiex.ec.europa.eu/
I developed the EC web site: http://ccvista.taiex.be/ using CCVISTA (The CCVista Database was created to store translations off all the languages of candidate countries of the EU measures ;
-
Commission Européenne
- MS Analysis Services
Bruxelles
2000 - 2001
I designed, implemented, deployed and updated the official website for TAIEX (Directorate-General: Enlargement. European Commission) http://taiex.ec.europa.eu/
