Jonathan Fritsch
Professional experience
Business Intelligence Consultant
Oxylane - Dourges - France(Consultant - Since June 2011)
- Within the logistic department, evolution and correction of indicators in the Datawarehouse, DataMart and the reporting tool.
- Creation of tower controls in the ETL which controls and check the data source quality
- SQL performance improvement by upgrading the ETL (ODI) Integration Knowledge Module
- Development of organizational methods improving my working time and task management
Business Intelligence Consultant
Groupe Caisse d'Epargne Technologies (Provider - Ineat Conseil) - Seclin - France(Permanent contract - Since October 2010)
- Data structure migration monitoring and aid, from its development to its production start. This includes :
- Updates and creations of technical documentation, ksh and csh applications, and PL/SQL stored procedures
- Test and verification of these process
- Constant communication with Project Managers to synchronize their evolutions with the new structure
Business Intelligence Consultant
ETO Infinity (Provider - Ineat Conseil) - Roubaix - France(Work placement - June 2010 - September 2010)
- Analyze, development and documentation of data loading processes towards a relational Database Management System, and aggregation and transfer of these data towards a Decision Support Database Management System.
Buyer Assistant
Auchan Import Export - Villeneuve d'Ascq - France(Temporary work - July 2009 - September 2009)
- Product packaging checking and product database updates. Communication help between clients and suppliers.
Support Analyst / Project Owner
Société Générale Corporate & Investment Banking - La Défense - France(Work placement - August 2008 - February 2009)
- Within the equity sector (GEDS/CAR/RES/SUP) my missions where:
- Costumers request management
- Financial data quality help
- Participation in the setting up of different organizational plans within the equity research sector
Webmaster and Events Assistant
Trade development Service Center - Shanghai - China(Work placement - March 2006 - September 2006)
- Events communication and preparation help organised by the company.
Skills
Business intelligence
- Business Objects 6.5
- Oracle Data Integrator
- OBIEE
- Talend Open Studio
- ETI Extract
Database Management System
- Oracle 9i/10g/11g
- MYSQL 5.0.53
- SQL Server 2005/2008
- MS Access
Language
- SQL
- PL/SQL
- Transact SQL
- CSH and KSH
- VB
Operating System
- windows
- unix