Mes compétences :
Business
Business Object
Datawarehousing
Informatica
Entreprises
Syncer
- BI Architect
2011 - 2012Mission: Maintenance and evolution of the Systeme U central Business Intelligence System
Design, development, test, debug, document and support MicroStrategy applications.
Interact with business, ETL and architecture teams to design and build MicroStrategy infrastructure.
Ensure that completed solutions provide the functionality required by application experts and that performance is optimized.
Lead development team to achieve complex business objectives and develop innovative solutions.
Translate concepts in ways that can be understood by a variety of audiences.
Involved with senior management for key design and architecture decisions, as well as project estimation and resource planning
Troubleshoot production issues
Windows 7 professional edition; AS400; Informatica PowerCenter V8.6.1; Microstrategy V9, Microstrategy Web v9; Mega 2005 SP1
LaPoste HR Office
- BI Consultant
2010 - 2011Mission: Proposing a cross-functional data basis to the HR department responding to a set of new emerging needs
Maintenance and enhancement of the unified data warehouse used for operational
management of human resources.
Gather users needs and translate them into functional and technical specifications
ETL development for Operational Data Store, Data Warehouse and Data Marts
Report and restitution development using MicroStrategy
Assembly test of the different components of the application
Troubleshoot production issues
Create and document non-regression tests to check that the new versions do not impact existing reports.
SUN Solaris 10 Update 6; Windows Enterprise Edition 2003 R2 sp2; ORACLE 11g R2; Informatica PowerCenter V8.6.1; Microstrategy Web v9.0.1 32bits; Microstrategy IS v9.0.1 32bits; Power AMC 12; Visual Source Safe
Logica
- BI Consultant / Team Leader
COMPIEGNE2010 - 2010Mission: Facilitating competencies evolution of newcomers, and implementing a customizable transcoding solution
Create and model technical solutions.
Functional and technical design, prototyping
Define and implement complex business rules
Organise ETL development team workload to achieve performance
Help and support new team members in order to improve their technical abilities
Assembly test of the different components of the application
Set up development and testing environments
Produce Hardware and Software setup document for the environments, including hardware specifications, and scripts/settings for the software.
Verify completeness of the documentation and deliver deployment files
Development of deployment scripts
Production support
SUN Solaris 10 Update 6; Windows XP Enterprise Edition sp3; Sybase IQ 12.7; Sybase ASE 12.5; Informatica PowerCenter V8.6.1; Power AMC 12; Tortoise SVN; Business Object 6
SNCF
- BI Consultant
2009 - 2010Mission: Equipping the SNCF with a software solution allowing Data confrontation from its main supplier to its own SI (Automation of B2B partnerships).
Build application for comparing data in internal system with data provided by suppliers
Build JEE application for processing data and presenting the results of the comparisons
Create UML models of the different components and services with Rational Software Architect
Build and unit test application components
End application users training
Windows XP Enterprise Edition sp3; JEE; Spring; Hibernate; Weblogic; Rational Software Architect; Rational clearcase;
BNP Paribas
- BI Consultant
Paris2008 - 2009Mission: Integrating a new life insurance multi-support management software package (Master-I of LineData Services)
Build Informatica Mappings and Workflow
Deliver technical specifications of the developed components
Participate in defining the development process best practices
Create materialized views in Oracle 10g for time optimisation
Windows XP Enterprise Edition; Informatica PowerCenter V8.5; Rational clearcase;