The client Tamoil is a major operator in the oil and energy industry, introduces its activities in the oil and energy sectors in Europe and Africa.
The project Settlement of a BI platform across several services
Roles Business Analysis, Design & Delivery
Tasks • Formalization of business requirements into functional specifications
• Translation of functional specifications into technical requirements
• Implementation of advanced reporting platform – back-end and front-end, based on SAP R3.
• Testing follow-up with business users
• Deployment
• Maintenance activities: support, performance optimization
Technologies QlikView SAP Connector, MS SQL Server
The client Merck Serono is specialized in the treatment of cancer, neurodegenerative diseases, infertility, endocrine and metabolic disorders, cardiovascular diseases and other conditions with unmet medical needs. Around the world, some 16,000 employees work to discover, develop, manufacture and commercialize Merck Serono’s prescription therapies, available in over 150 countries.
The project KPIs on Merck Export
Roles Design, Delivery, Maintenance
Tasks • Design and development of framework and reports
Technologies Cognos 8
The client Headquartered in London, HSBC is one of the largest banking and financial services organisations in the world. HSBC's international network comprises around 8,000 offices in 87 countries and territories in Europe, the Asia-Pacific region, the Americas, the Middle East and Africa.
The project Client reporting for relationship Management
Roles Design, Delivery
Tasks • Qlikview application design
• Reports development
Technologies Qlikview
The client Nagravision in the evolving digital television market. Nagravision, a Kudelski Group company, has a long standing track record as a world leader in digital content security. This has formed the basis of its overall leadership in generating and securing service provider revenues for Pay TV services.
The projects Service & Sales BI reporting platform allowing to monitor the activity
Second and third level support for Nagravision Business Intelligence platform
Roles Oracle BI Manager and Support & Maintenance
Tasks • Analysis of reporting and analysis needs, proposition of solutions in terms of Business Intelligence.
• Development of new BI reports
• Update of the existing reports
• Maintenance and evolution of the BI repository (data model)
• Mapping of data to match with user’s needs.
• Responsible for the second and third level support
• Handling of Incident & Problem management
• Corrective & Preventive maintenance
The client Givaudan is one of the most respected companies in the fragrance and flavour industry. Its rich heritage dates back to 1796, making it the first company to establish itself as a creator of tastes and scents. In 2008, the company achieved sales of CHF 4,087 million, with a work force of 8772 employees and subsidiaries in 46 countries.
The project Migration from Cognos Impromptu to Cognos 8
Roles Migration
Tasks • Migration of a report set from Cognos Impromptu to Cognos 8
• Direct day-to-day follow-up with the global head of development Europe
• Definition of migration strategy
• Analysis of current reports
• Migration & Development of reports in Cognos 8 platform
• Non-regression testing
Technologies Cognos 8.3 (Report Studio, Query Studio, Framework Manager), Oracle, Cognos Impromptu
The client Previously presented.
The project Marketing & Sales reporting platform allowing to monitor sales opportunity processes
Roles Analysis & Delivery
Tasks • Development of new KPIs’ reports
• Migration of reports from DMR model to relational model
• Dev/Test deployment process documentation management
The client The BCV was founded over 160 years ago to serve the people of Vaud, and has kept a strong community focus to this day. They offer a full range of services, including personal banking, corporate banking, private banking and asset management. In addition the BCV engages trading activities in various financial markets
The project BCV Employee
Roles BI Business Analyst
Tasks • Maintenance and development of Reports for existing Business Objects universes.
• Analysis of Needs for the departments of the bank, proposition of solutions in terms of Business Intelligence.
• Support of users for the development of their Report requests.
• Participation in different projects: CRM, Credit...
This experience allowed me to get involved in a full-service bank and to have a deep view of the needs in term of reporting.
The client Saxo Bank is privately held with co-founders Kim Fournais and Lars Seier Christensen holding majority stakes. Private Equity firm General Atlantic bought a minority stake in June 2005. In September 2007 Saxo Bank announced acquisition of Synthesis Bank, a white label partner of Saxo Bank for four years. In November 2007 Saxo Bank announced a white label partnership with Citibank, its biggest deal so far. In January 2008, Espirito Santo, took a five percent stake in Saxo Bank, making Saxo Bank’s market value at 1.26 Billion EUR
The project Analysis of Reporting needs and recommendation of implementation
Roles Business Intelligence Analyst
Tasks • Study of needs and multidimensional analysis per Department (Marketing, Sales, Finance, Top Management)
• Definition of KPI’s per Department
• Definition of available dimensions for the DWH
• Proposition and Validation of Microsoft restitution tools
This project allowed me to get up to date on my understanding of the banking sector and to bring a complete analysis of needs to a structure in full development.
The client Mobistar (Euronext: MOBB) is the second largest of Belgium's three mobile telecommunications operators. It competes with Proximus, owned by Belgian state owned telco Belgacom, and Base, a subsidiary of Dutch KPN.
The project Mobistar M&E - Measurement & Evaluation of Marketing Campaigns
Roles Developer, Integrator BI and CRM
Tasks International projects for measurement and evaluation of Marketing Campaigns:
• Development of an Access-Oracle Server application allowing for the management of campaigns and the upload and consolidation of financial information,
• Definition and put in place of Reports for monitoring and decision (universe, reports),
• Writing of technical documentation
These projects allowed me to acquire strong understanding of the telecommunications sector and of the CRM applications. They also allowed me to work with multicultural teams.
The client Carrefour SA (Euronext: CA) is a French international hypermarket chain. Headquartered in Levallois-Perret, France Carrefour is the largest hypermarket chain in the world in terms of size, and the second largest retail group in the world in terms of revenue and third largest in profit after Wal-Mart and Tesco. Carrefour operates mainly in Europe, China, Colombia, Brazil, Argentina and in the Dominican Republic, but also has shops in North Africa and other parts of Asia.
The project Steering of Project : Retalix Check-out systems
Roles Senior Consultant
Tasks Pre-analysis and steering of the implementation of a Check-out systems tool for the company Retalix : Functional analysis in the context of a changing of collection systems for the stores Carrefour and Shopi with as an objective the acquisition of an expertise on the Retalix collections in order to integrate it in the existing IT systems by identifying the functional evolutions to bring to respond to those needs expressed by the business.
• Acquisition and making of a directory of all the necessary documentation for the functional applicative and technical mastery for Retalix’s Check-out systems
• Put in place a test environment
• Monitor the study meetings with the Business
• Writing of functional specifications
• Numbering / figuring and planning of the solution implementation.
These various experiences with Carrefour allowed me to acquire solid knowledge in the area of mass distribution and to have a real experience of project management.
Technologies Retalix Check-out systems