Becha Ahmed

BOUYGUES TELECOM - ONE OF THE LEADERS OF THE TELECOMMUNICATIONS SECTOR
Technical Environment: BO-XI, OBIEE, Informatica, NEOLANE, Windows/Unix
Project: Realization of business intelligence projects
 Encryption and Design
 Power of Datawarehouse: Creating and / or updating of the datamart
 Creating and / or updating dashboards.
 Test and acceptance.
 Evolutions realization, correction and optimization on the whole of the decisional chain.
Project: Migration of forty recurrent marketing campaigns from the old application (Marketing- Director) to Siebel Marketing
 Assist the MOA marketing analysts in creating segments by providing them the best practices
 Suggest an organization for the creation of the segmentation

GEODIS - ONE OF THE LEADERS OF THE TRANSPORT AND LOGISTICS SECTOR
Technical Environment: OBIEE, Informatica, DAC, Windows/Unix
Project: Implementation of CRM and Oracle BI application
 Realize evolutions and corrections for Oracle BI application :
- Correction and optimizations of the DAC execution plan
- Creation and evolution of the Informatica Mappings/Workflows power
- Evolution of the reporting
 Transfer of skills to the management information system team (loading the Data warehouse using Informatica and DAC tools).

L'ORÉAL & THE BODY SHOP - ONE OF THE LEADERS OF THE COSMETICS SECTOR
Technical Environment: OBIEE, Informatica, DAC, Siebel, DTSX (SQL-server)
Project: Migrating the BI / Marketing platform to the new version of the application
 Impacting the Informatica and DAC processing by the changes in the standard data model
 Updating the OBIEE repository
 Integration with Siebel Marketing V8 unit
 Implementation of evolutions and corrections of Oracle BI Applications.
Project: Activation of the Loyalty Program (3 months)
 Loading of the standard data model : activation of Informatica Mappings/Workflows and update of the DAC execution plan
 Update the OBIEE repository
 Activation of the standards dashboard and creating a custom reports
Project: Loading the external data in the transactional database (1 months)
 Loading of 10 million records in the Siebel-CRM’s transactional database (OLTP) in order to enrich the customers/prospects information.

ESSILOR - ONE OF THE LEADERS OF THE PHARMACEUTICAL SECTOR
Technical environment: Siebel-Analytics, Informatica, DAC, Windows
Project: Design of reporting for vendors, call centers, and marketing (300 users and 1500 target)
 Realization changes in Siebel-Analytics applications for French and Spanish affiliates:
- Development of Informatica mappings power
- Scheduling and load data through the DAC
- Development of data model of Datawarehouse
- Setting up business rules (visibility data)
- Creation of dashboards
- Management of permissions
 Internationalization of Siebel-Analytics applications:
- Creating Informatica mappings power (Multilingual Lists of Values)
- Setting the DAC
- Creating mappings for update the historical data
- Updating the disconnected mode (Multilingual synchronization)

PERNOD RICARD - CO-WORLD LEADER IN THE INDUSTRY OF WINES & SPIRITS
Technical environment: OBIEE, Informatica, Windows
Project: Improving performance of OBIEE.
 Improving of the execution time of sales dashboard:
 Creating a new structure of the tables
 Producing of an alimentation model in Informatica
 Loading the historical data in the new tables
 Adapting of indicators in the OBIEE repository

SIEMENS (IA&DT) - INDUSTRY AUTOMATION & DRIVE TECHNOLOGIES DIVISIONS SECTOR
Technical environment: Oracle BI - On Demand, Windows
Project: Deploy of dashboards destined for sales force and managers
 Reports development, setup and test
 Training administrators

ALSTOM – ENERGY AND TRANSPORT SECTOR
Technical environment: OBIEE, Windows
Project: International deployment of Oracle BI applications
 Realization of data quality analysis development: adaptation of the data model in the OBIEE repository

Project: Making an interface between CEGID and ORTEMS tools
 Analyze and put in correspondence the data models of two systems
 Propose the architecture of interoperability
 Develop a platform which allows to manage the interactions between the systems