Elyes - Consultant SAS

System migration to support companion card
 Review SAS programs: Amend codes, Unit test, move it to Prod Env.
 Analyse actual DI jobs and report the impact.
 Preparation of Unit test Plan, project delivery plan.
 Build profitability management reports: Profit / Lost / Cost (Daily & Monthly)

IIS SAS Implementation (Insurance Intelligence Solution)
 Concept & Design (Data and Process Quality, Deployment), ETL jobs building, scheduling and optimisation.
 Unit test, Details (technical and functional) specification and mappings.
 Create Daily database system (Dialler & CMS in collaboration with VODAFONE) to send the new prospects to the Call Centres.
 Financial data analysis, Claim and ASU (Accident Sickness Unemployment)
 Finance and Actuarial reporting.(Expenses Ratio, pricing, net profit report )
 KPI reports (Web dynamic dashboard via Portal / Stored process)
 DDS Database (DWH) administration (Detail Data Store, Oracle tables)

Demo for NAG client: using SAS Portal, SAS dashboard, Enterprise Guide, Microsoft Add-In.
 Programming and Executing Stored Process.
 Customizing html reports.

Market research (Desktop, Notebook, Handheld, Display) in four European countries (HP)
 Reporting and survey analysis

Pre-targeting scoring for new bank credit offer.
 Data extraction, transformation and loading
 SAS programs automation and optimization.
 Datawarehouse architecture, datamarts creation.

Affinity scoreboard (grocery retail)
 Baby old age estimation to prepare a special offer for customer whose will potentially have a new born.
 Data clustering into alimentation and no alimentation parts.
 Determination of customer score from his purchase.
 Datamining, Text mining, scoring.

Customer Intelligence: bond between marketing research department and data warehousing team.
 Ad-hoc analysis for marketing, budget and financial needs.
 Data Extraction, Data mining and Clustering.
 Econometric Model creation to detect churn.
 SAS programs Automation for monthly reports.

; Implementation of SAS Platform EBI.
 Creating Suppressions, Universes and Campaigns in SAS Campaign Studio.
 Executing and Scheduling Campaigns.

 Formulation a model of the series of the national medium prices of products in frame of PCI-AFRIQUE to work out an analysis of the temporal coherence of data (International Comparison Program)

Elaboration of decision Assistance for the purchase of credence
 Estimate and prediction of the rate of recoverability by an econometric model
 Technical Environment: SAS programming, Data mining with SPSS