Adil - Business Analyst SQL SERVER

Position: CMO - Head of Marketing and Communications

Job Responsibility:
Management of the marketing and communications activities: Large Consumer & Corporate Marketing, Value Added Services, Strategic & Competitive Intelligence.
Responsible for the Marketing & Sales Strategy.
Head of Mobile Money's development strategy within the operator.
Member of the Executive Committee.

Senior Business Intelligence Manager

Job Responsibility: Marketing Intelligence Services.

Strategic & Competitive Intelligence:
Listen, identification, analysis and monitoring needs and consumer behavior and market trends, while integrating the dimension of the benchmark competitive of national & foreign operators through marketing research, competitive intelligence and data mining.
Coordinate and analyze the competitive landscape.
National and international Competitive benchmarking; focus on the Telecom market, new products....
Track key KPI’s, Productions and Promotions launched by other operators.
Contribution to the daily watch.
Returns of customer information and feedbacks on the offers & services provided by Maroc Telecom: Satisfaction, Dissatisfaction, and Expectations.

Business Analytics:
Production and coordination of studies & market analysis programs: Market share, SAV, Barometer surveys of customer satisfaction, Investigations Pre and Post launch of product, Telecom market....
Carry out quantitative and qualitative analysis of the telecommunications market in Morocco, production of briefing notes and recommendations, in order to monitor the marketing activities, to support the strategic decision making and to improve Maroc Telecom’s competitive position in the marketplace.

Data Mining:
Construct models of subscriber behaviour, Segmentation of customer, Analysis of ongoing products and services in Maroc Telecom's portfolio, Ad-hoc data analysis as required, Cross & Up Selling, Marketing Campaign. Analysis (Microsoft SQL Server 2008 SSIS, SSRS, SSAS) - SPSS Modeler 13).
Full Cycle of Data Mining project: Exploration and preparation of data, selection of variables & algorithms related to issues addressed development of predictive and descriptive models (Churn, Segmentation, Scoring…) and proposition recommendations and action plan.

Reporting & Dashboards:
Development of various reporting on behalf of marketing product managers, and realization of the dashboards for monitoring various marketing indicators (Business Objects XI R2: Designer, Desktop Intelligence, Webi), (Microsoft BI – SQL Server 2008: SSIS, SSRS, SSAS).

Business Intelligence Project Manager

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).

This is a Data Warehouse umbrella that encompasses the entire business of the Company (Client Management, Fixed and Mobile Traffic, Internet & Data, 3G, Intelligent Network, BSCS, Sales and Income, indicators of Geomarketing and Data Mining....)
Committee Draft: Defining user requirements and performance indicators, Development of the expressions of need and functional schedule of conditions, Realization of Workshops with the integrator and end users.
Managing Reporting and Dashboards: Development of various reporting on behalf of marketing product managers, and realization of the dashboards for monitoring various marketing indicators (Business Objects XI R2 - Desktop & Webi Intelligence).

Installation of a mechanism which makes it possible to give an integrated vision of the customer and the possibility of consolidating the telecom offers and products, through a single identification on the three systems of invoicing (Fixed & Data, Mobile, Internet) with an identical code customer (Master Data Management):
Development of the reporting and matrices traffic (Business Objects XI R2), follow the evolution of the system and the proposal of new indicators and axes of analyses.

Business Intelligence University organized by SAS France, ESCA Morocco and School of Grenoble.
Presentation of the SAS 9 Intelligence Platform: Functional & Technical Architecture, Modules and Packages of the SAS Solution.
Handling modules: SAS Base, SAS Management Console, SAS Data Integration Studio SAS Web Report, SAS Information Studio and SAS Enterprise Miner.
Exercises & Case Studies on the implementation of each module.
Business Objects XI R2: Module of Web Intelligence.
SAP BW: Manipulation of the tool, Creation and Diffusion of the Reporting.
The Marketing applied to the ICT organized by LMS Marketing.
The Management of Project organized by LMS Marketing.

Microsoft BI: SQL Server 2008 (SSIS, SSRS, SSAS).
IBM - SPSS: SPSS Clementine - PASW Modeler 13.
IBM - Cognos: Cognos Impromptu, Cognos Power Play.
Oracle: Oracle 10g AS, Oracle Discoverer, Oracle Portal.
SAP: Business Objects XI R2 (Designer, Desktop Intelligence, Webi), SAP BW.
SAS: SAS Enterprise Miner, SAS Data Integration Studio SAS Web Report.