Business Intelligence Project Manager
Organization: Maroc Telecom – Marketing Department. Rabat, Morocco
2007 - septembre 2009
Job Responsibility: Business Intelligence Services.
Project of Implementation of new customer segmentation for Maroc Telecom Customer by developing a Data Mining solution:
Analysis of available databases and retrieval of specific behaviors in market segments: criteria for use (Traffic, Income, ARPU, MoU...) and sociodemographic data…
Definition of the different segments: Lot 1 "segmentation of youth customer", Lot 2 “segmentation of corporate customers.
Implement of a market study to refine the segments: Confirm profiling and define the behaviors and expectations of consumers.
Developing a Data Mining solution for segmentation: Creating a Marketing Data Marts, Implementation of Automated models & Data Mining Analysis (Microsoft SQL Server 2008 SSIS, SSRS, SSAS) - SPSS Modeler 13).
Review the current segmentation, for the declination of the new segmentation in the product portfolio: Driving change of Information System, marketing campaigns, targeting, Adaptation of the marketing mix for each of the identified segments, development of offers and actions to be taken via the Data Mining.
Project of Implementation of Data Mining solution:
The project is part of a set of strategic projects that aim to improve customer knowledge and control its direction by moving from a reactive to a proactive mode.
Recruitment, Retention, Segmentation and loyalty, Customer, Scoring, Churn, Cross / Up Selling.
Project Manager Marketing side: Analysis of existing, drawing expressions of need and the functional specifications, tracking the RFQ and evaluation of technical and financial records of bidders.
Project of Installation of the Business & Strategic Intelligence platform in Morocco Telecom:
Competitive Intelligence Component: Automating the customer feedback on the benefits of products and services provided by Maroc Telecom. (Satisfaction, Waiting and Dissatisfaction) (AMI Enterprise Intelligence)
Audit of the current process of competitive intelligence, defining the targeting plan and indicators to follow.
Setup and integration of the module of Competitive Intelligence in the BI platform AMI Enterprise Intelligence.
Automation of information feedback field (Customer Focus Listen and Competition) on the provision of products and services provided by Morocco Telecom (Satisfaction, Waiting and Dissatisfaction).
Progress reports, development of user guides, user training, running meetings and writing reports.
Animation of a community of watchers and monitoring the information collected, through enrichment by syntheses and comprehensive studies.
Project of automation of the Marketing Dashboards:
Installation of a decisional system of Reporting and Dashboards for the follow-up of the marketing activity (Follow-up of the products and services Fixes & Dated, Mobile and Internet provided by Maroc Telecom)
Analysis needs definition of the indicators of performance for the three segments (Business, General Public and Professional).
Design and Creation of the O.D.S (Intermediate Database) and the Marketing Data Warehouse (Sybase Power AMC, SQL Server 2000, Oracle 10G).
Alimentation of Data Bases using the ETL (DTS) and the stored procedures.
Creation and development of the universes and the various Reports and Dashboards for the general indicators (Business Objects XI R2) and of the requests for the indicators resulting from the Control of Management (SAP BW).
Migration of existing Data Warehouse to a Data Warehouse in SQL Server 2008 (Microsoft BI - SQL Server 2008 SSIS, SSRS, SSAS).