Salima - Consultant Développeur BUSINESS OBJECTS SAP HANA DATAWAREHOUSE SAP BUSINESS EXPLORER

Eiffage is a group with diversified skills in many areas: construction, real estate, infrastructure, energy, roads, concessions. It is the third group of French constructions and concessions, behind Vinci and Bouygues, and the fifth largest European group. Eiffage has decided to make available to all business areas a reporting tool for making corporate documents available and creating ad hoc documents to speed up arbitration and control. The REFONTE OPERIS project and Eiffage BI RH concerns the 6 business lines up to the group consolidation.

Mission
Attached to the DSI and the program director, my mission was to carry out the following as a Task Force:

Analyze data sources to establish an optimum Data Model.
Analyze power management and reporting rules.
Creating a BODS feed job for arbitration.
Optimize the technical layer under SAP HANA.
Optimize the semantic layer to allow the creation of ad hoc documents by trades.
Enrich the provision of information by creating 240 new indicators.
Migrate the 140 existing reports on the new environment.
Accompany the MOA in the implementation of best practices.
Accompany the consultants in charge of the unit tests.

Achievements
Reduction of the number of calculations views (60 calculations view by 3 calculations views)
Creation of a BO universe to simultaneously meet the needs of corporate reporting as well as ad hoc reporting.
Creation of 360 indicators.
Migration of 140 reports.
Accompanying to unit tests.
Production start.

Application and technical environments
BODS BI4 ,SAP HANA, Sql Developer, BO Univers IDT, BO WEBI BI4

Airbus is an international pioneer in the aerospace industry. It’s a leader in designing, manufacturing and delivering aerospace products, services and solutions to customers on a global scale. AIRBUS has decided to migrate 4 legacies systems under SAP ECC 4.6 to 1 ECC on Supply Chain scope by wave.
“Wave 2” migration project (based on Wave 1 experience) is focus on A350 aircraft program impacting all countries (FR / GE / UK / SP).

Mission
Attached to different team leader, as part of ARP Project, my mission was to carry out the following as a Task Force:
Migrate data from SAP ERP ECC 4.5 to ECC 6 by identifying a Core International Model.
Qualify and correct Extract, Transform and Load data rules.
Serve as expert in ETL and migration to development team On shore and Off shore (Accenture Manilla).
Provide knowledge transfer to local team (15 peoples).
Design, develop architecture and build data load process.
Build level 3 technical developments.
Assist and support test consultant

Achievements
Migration of all Purchases Orders (average costing time for each job - 5 minutes)
Creation of Kpi Dashboard to improve data cleansing (average costing time for each job - 3 minutes)
Automatic load of master and transactional data on the target environment.

Application and technical environments
SAP ECC 4.5, SAP ECC 6, SAP GUI, SAP HANA, LSMW, BODS XI, Sql Developer

E.Leclerc is a distribution cooperative network, one of the leaders in the French agri-food sector with some €50 billion in revenues. The E.Leclerc stores are supplied by a central procurement generalist organized by 16 geographical areas. E.Leclerc network has decided to optimize and migrate its decision-making tools, redesign business processes and set up a centralized repository that is shared with all the entities in the organization.

Mission
Attached to the DSI and the program director, as part of the BODS BOXI project, my mission involved migration decision-making and planning tools and was organized around 3 axes :

1st axis:
Assist and recommend as expert business intelligence solutions.
Coordinate and control the various internal stakeholders for the client (several departments) and service providers (several providers).
Monitor the progress of projects and alerts.
Prepare and lead project meetings and steering committees.
Coordinate with the leaders of each tools impacted by migration.
Coordinate between project managers and team leader of each decision tool.
Serve as technical adviser level 3.
Development of complex solutions.
2nd axis:
Design and run functional test processes.
Perform non-regression tests.
Monitor and manage incidents up to completion.
Prepare follow-up committees.

3rd axis:
Initiate and conduct site anonymization of analytical databases and restitution.

Achievements
Reduction in the reporting perimeter of BO XI R3 to BI 4 reports (from 467 reports to 128 reports).
Reduced load stream processing times (eg 8 to 10 minutes).
Reduced backup processing times (eg. : 1 daily backup to 2 weekly backups).
Respect of planning and costs.
Optimization of communication and manage collaboration between the various technical and business departments.
Template for deliverables.
Knowledge transfer in favour of 2 junior project managers.
Participation in Informatica workshops for managing master data.
Boost competence of the business teams on the main rules of a repository.
Validation by the business teams of the data characterisation (masters, consecutives, parameters).
Validation of repositories’ modeling (5 million products, 10 000 suppliers, 500 stores).
Validation of MCD suppliers, products and stores.

Application and technical environments
BO XI R3 - BI 4, Sql Developer, DB2, flat files, xml, SQL, MYSQL.

Allianz Global Investors is an asset manager for private and institutional clients worldwide.
It manages assets valued at almost 500 billion euros. The announced shutdown of SAP support on R3 version, has imposed the migration of its decision-making environment as well as its planning tool to ensure sustainability and quality trade-offs.

Mission
Attached to the DSI in collaboration with Business Unit Reporting within the PEER ONE migration project, my mission was to ensure that schedule and budget were met, while promoting exchanges between technical teams and European businesses through the following actions :
Referencing, qualification, cost estimation, project planning (documents, universes, ETL / other flows, treatment planning).
Level 3 technical development, assistance and support of junior developers
Management, monitoring, technical and functional assistance for 6 junior consultants.
recommendation and formalization of necessary adaptations and modifications (documents, universes, flows, RDBMS)
Preparation and presentation of progress reports to the project committees.

Achievements
Reduction of the migration perimeter of BO XI R3 documents to BI 4 (from 1164 reports to 280 reports).
Reduced update times for BO documents (eg. : From 4 hours to 3 minutes).
Optimization of 10 universes and 6 RDBMS.
Scheduling of 280 documents migrated to the new version of Infoburst.
Implementation of the new user repository BO (CMC)
Documentation update.
Knowledge transfer in favour of junior consultants

Application and technical environments
BO XI R3 - BI 4, Sql Developer, INFOBURST, ORACLE, flat files.

Founded in 1982, Synapses' mission is to train, advise and assist companies in the implementation of their management and office automation systems, as well as to support them in the evolution of their systems.

Mission
Attached to the CEO, my mission was to provide training on the different Business Object modules to end customers and intervene as an expert on various ERP.

Achievements
Creation of a training support on end customer’s production environment.
Qualification leader.
Training of junior consultants.
Level 3 technical development and functional support.

Ranked as the 3rd largest global reinsurance group in the world, SCOR is organized into two business branches, SCOR Global P & C (Property & Casualty reinsurance) and SCOR Global Life (life reinsurance), and an asset management business, SCOR Global Investments.
Due to constantly increasing processing time, it was necessary to consolidate the BI tools.

Mission
Attached to the IT department, as part of the DWH project DIMENSION, my mission was to provide the following :
Setting up of an inventory of the tools used.
Rationalization of 6 RDBMS, 10 universes and ETL.
Optimization of backup procedures and incident management.
Realization of the scoping phase, budget, and project planning
Organization and monitoring of unit test activities until the production phase.

Achievements
Creation of 2 DWH (management portfolios, reinsurance) and 30 documents.
Reduction of business support costs (eg. : elimination of Excel file redundant with Business Object application, training).
Replacing the monthly data load (initial duration : 5 days) with daily data load (duration : 20 minutes)
Replacing the monthly backup procedures (initial duration : 24 hours) by a daily backup (duration : 1 hour)
Development of a targeted backtrack procedure.
Internal training for new environments.
Respect of planning and budget.
Leadership of unit tests up to production

Application and technical environments
SAP, BODS XI, TOAD, BO XI 4, Sql Developer, ORACLE, flat files.
 

HEINEKEN France, a French subsidiary of the Dutch group, has a turnover of € 1.6 billion, making it one of the top 100 companies in France. The HEINEKEN group is developing two strategic activities: Brewery, through its subsidiary HEINEKEN Entreprise, and Beverage Distributor, through its subsidiary France Boissons. The announced shutdown of SAP support on ECC version 4.5, has imposed the migration of its transactional and master data environment.

Mission
Attached to the DSI France, pilot site in the ******** project, my mission was to carry out the following :
Migrate data from SAP ERP ECC 4.5 to ECC 6 by identifying a Core International Model.
Qualify and correct load data rules.
Serve as expert in ETL and migration to development team.
Provide knowledge transfer to local team (3 people).
Manage project’s local team (6 persons) and ensure coordination with project’s international teams (6 countries, 10 people).
Design, develop architecture and build data load process.
Build level 3 technical developments.
Assist and support junior developers
Create an easy to use process of manual data cleansing for business users.
Lead project meetings.
Leadership of unit tests up to production

Achievements
Create a Core Model (80% of the data)
Create a cleansing database module to improve business arbitration before migration (less than 2% of data)
Automatic load of master and transactional data on the target environment.

Application and technical environments
SAP 4.5, SAP 6, ACCESS, BODS XI, DATASTAGE SERVER V6, TOAD, BO XI R3, Sql Developer

ERDF, operator of the electricity distribution network in France, is a wholly-owned subsidiary of EDF (one of the world’s leading electricity companies).The modification of existing BI systems was imposed by new French legislation on publication of dashboard reports.The OSCAR project responds to the need for information on access to energy in France. The PCB project responds to the obligation to communicate the state of progress of the cleaning of equipment containing PCBs and PCTs to ADEME.

Mission
Attached to the DSI, my mission concerned both the OSCAR and PCB projects :

OSCAR:
List, qualify and prioritize new publication needs in partnership with the head of publishing (50 reports).
Prepare budget and schedule workloads and priorities.
lead project meeting.
Develop needs (ETL, RDBMS, reporting, scheduling).
Leadership of unit tests up to production
PCB:
Optimize the monthly file generation process.
Document the generation procedure.
Transmit the monthly file and archive the discharge.

Achievements
Optimization, evolution and automation of the ETL flows and the RDBMS architecture (time saving : 80%)
Creation of 5 dashboard reports.
Creation of automated processing via event-scheduling.
Training on Business Objects tools to avoid redundant Excel extractions.
Leadership of unit tests up to production

Application and technical environments
GIS Mercator SAP3.5, ACCESS, BODI, DATASTAGE SERVER V6 SINOE, TOAD, BO XI R3, MMI PCB Sql Developer, Informatica, Oracle, flat files.

Schneider Electric is an international company that manufactures and markets products in the electrical field. As part of the rationalization of its tools, Schneider Electric initiates the BRIDGE project (transactional tools) and decides to align its BI tools (BIG BOSS project for France (pilot) and BOSSII project for worldwide).

Mission
Attached to the IT department, my mission was to carry out the following :
Choose and implement the new BI solution in accordance with the new transactional solution on SAP ECC Core Model 5 (Bridge Project)
Develop and parametrize the chosen solution.
Train and support the local team (3 persons).
Monitor the progress of international teams (4 countries).
Lead project and steering committees.

Achievements
Replace outdated tools of purchases analysis for France and worldwide.
Integrate the solution in global architecture compounds of 3 datacenters in order to ensure 24 hours worldwide coverage.
Create 1 datamart and 2 universes (60 tables, 20 documents by universe) at France level.
Create 3 datacenters, 7 datamarts, 30 universes (20 tables, 30 documents by universe) at worldwide level.
Leadership of unit tests up to production

Application and technical environments
D & B, SAP ECC 5, BW 3.5, BODI, BO XI R3, BI 7 NETWEAVER, INFORMATICA, DATASTAGE SERVER V6, 6Sigma, ORACLE, ACCESS, flat files.

Euro Disney is a company which operates, through its subsidiaries, the Disneyland Paris leisure complex and its adjoining commercial property developments. It develops, in partnership with the State and local authorities, part IV of the new town of Marne-la-Vallée, Val d’Europe.
The announced shutdown of SAP support for Release 5, has imposed the migration of its financial controls and personnel management.

Mission
Attached to the IT department, my mission, as part of the BOXI project, was to carry out the following :
Streamline, migrate and optimized existing BI tools.
Develop the necessary adaptations.
Create and parametrize the different profiles of the access rights.
Lead unit tests up to production

Achievements
Migration and optimization of 12 Universes (30 tables) and 60 dashbord reports per universe.
Adaptation of loading data treatments.
Creation and parametrization of the security repository.
End users’ training.
Leadership of unit tests up to production

Application and technical environments :
SAP 3.5, BO V5 BO XI R3, TOAD, HR ACCESS, BODI Sql Developer, Oracle, database owner, flat files.