Freelance SAS : Distinguez les savoir-faire que vous recherchez

Résumé des missions de Smail,
freelance SAS habitant ?

Consultant Senior SAS BI & Business Analyst
1-Bpost Bank ( Brussels):
janvier 2019 - aujourd'hui
Professional Experiences

Context of the mission

Tasks

Analyze the data that has to be taken from SAP BW to send to SAS through SAS data integration.
Prepare & execute the necessary test cases based on the requirements to meet the expected quality.
Data of modeling processes in SAS DI.
Analyse technical errors and to define the suitable solution.
Quality Control (QC) Operations.
Data collection process to enable quick and reliable data analysis and improving quality of Data (Data integrity.

Be the point of contact for the people of Finance and Credit risk.
Creating SAS reports.
Test & assess the project implementation.
Implement templates and strategies in a more advanced SAS environment.
Reports requiring extensive data analysis to validate the data
technical environment
SAS 9, SAS Base & Advanced, SAS MAcro, SAS BI,SAS EG, SAS Mc, SAS FM , SAS DI, SAS Server Production,
IFRS9 ,SAS/IntrNet, , SAS VA,SAS Connect, Agile methodologies ,ETL Desktop, Numara Track-IT, SAP BI, Data Flux,Unix,Lunix, DMA, Java Script,Olap cube,Oracle, Mainframes ,JCL.Matlab,

Consultant Data Modeling Analyst.( Regulatory Risk Modeling team)
-ING Bank ( Brussels)
mars 2018 - décembre 2018
Context of the mission

Tasks

1/ Change management of modeling processes:

Act as point of contact towards IT and closely follow IT projects
I gathered the business requirements and define solutions together with IT.
I participated in modeling projects as data expert

2/ Daily management of modeling processes:
Data of modeling processes in SAS DI.
Monitoring and ensure consistency of modeling processes across systems
Execute and monitor the modeling processes and ensure the data quality within these
processes.

3/ User support regarding modeling processes:

Write and maintain an up-to-date documentation
Perform data analyses
I answer to the questions of the end-users
technical environment

SAS Base ,SAS Macro , SAS DI studio - SAS EG- Stored Processes ,Data lake.

Consultant Senior IS Data Warehouse Technical Analyst.
3-AG Insurance ( Brussels)
juillet 2017 - février 2018
Context of the mission

Tasks

Analyze the non-formalized business requirements on the data warehouse layers (ODS,CDS, Datamart or report) and check it against the operational data model and business processes.
Collaboration with the architecture teams & the team leaders of the different domains impacted or involved in the project for the scoping & estimation of the project.
Adequate communication & reporting to the management (both IT & Business) on the project progress.
Test & assess the project implementation.
Design efficient technical solutions in collaboration with the functional designers.
Quality insurance by detailed testing.
Ensure the follow-up of day-to-day processes (monitoring)
Prepare & execute the necessary test cases based on the requirements to meet the expected quality.
Creation Business functional (BF) and RDM (Erwin Data Modeler).
Insure the long term quality of the systems in the field of stability, scalability, traceability, flexibility and performance
technical environment
SAS Base ,SAS Macro ,SAS OLAP Cube Studio, SAS DI studio - SAS EG- Stored Processes-
SAS Dataflux, ETL solutions Erwin Data Modeler ( RDM) r9.64, Microsoft BI tools, Sql Server,
Agile methodology.

Consultant SAS BI developer Analyst
TOWERS WATSON (Brussels):
octobre 2011 - mai 2017
Context of the mission

Tasks
Optimise the configuration of the different front end interfaces in .net and web services technology to the SAS computational server using SAS Integration technologies. Assist with the calibration of a second SAS server to handle client requests running in batch.
Assist with gathering user requirements in the application and successful use of Risk models.
Write specifications for SAS programs.
Develop, maintain, optimize and validate SAS programs.
Communicate accurate and timely status updates to line manager and end-users.
Coordinate and perform tests, including end-user reviews.

Rewrite and further streamline the data extraction and data preparation SAS programs that are used to create the multiple regression analysis models provided to clients and I also assisted with the statistical modelling.
Analysing the data, and writing reports.
Data collection process to enable quick and reliable data analysis and improving quality of Data (Data integrity)
Used also the Studies of Data Mining: Predictive and Descriptive modelling.
technical environment

SAS9 , SAS Base, & Advanced,SAS Macro, SAS Connect,SAS Server , SAS/STAT, SAS Modeling ,
SAS MC, SAS EG,SAS forecast studio,SAS DI, Hadoop, SAS Stored Process,Data Flux,,sql-server client, SAS/IntrNet.,
Java Script,Matlab,Unix/Linux ,Sql Serve

Consultant SAS BI
5-EDF/LUMINUS (Hasselt):
mai 2011 - septembre 2011
In the Solution Provision Service

Context of the mission

Tasks
Analyse technical errors and to define the suitable solution
Responsible to log all of the actions taken in a ticket system
Check incoming requests to handle proactively.
Coordinate and perform tests, including end-user reviews.
Implement templates and strategies in a more advanced SAS environment.
Identifying recurring requests or issues to be communicated to application specialists.
Communicate accurate and timely status updates to line manager and end-users.
Make extraction of data weekly through (SAP LP1 and SAP, CRP-CRM Production)
Problem solving is a key element to the role.
Creating SAS reports .
Reporting teams .
Be the point of contact for the people of Marketing.
technical environment
SAS 9, SAS Base & Advanced, SAS MAcro, SAS BI,SAS EG, SAS Mc, SAS FM , SAS DI, SAS Server Production, SAS/IntrNet, , SAS VA,SAS Connect, Agile methodologies ,ETL Desktop, Numara Track-IT, SAP LP1 and SAP ,CRP-CRM Production. Hadoop, Data Flux,Unix,Lunix, DMA, Java Script,Olap cube,Oracle, Mainframes ,JCL.Matlab, ,.

Statistical Analyst, SAS Programmer
6-GBSC (General Biomedical & Statistical Consulting) CRO (Gent)
juillet 2008 - avril 2011
Context of the mission

Tasks

Preparation courses in Bio-Statistics for the Ministry of Health of Dubai
Data analysis and programming SAS 9
Verification of anomalies of SAS 9 program & interpretation and correction of errors related to syntax
Reporting anomalies of SAS 9 programming to support team
Create derived analysis datasets
Assist Clinical Data Management (CDM) group to design or review database structures
Quality Control (QC) Operations.
Clinical study & analysis and reporting (from ADAM derivation to creation of Tables,Figures,Listings)
Analysis of DCF (Data Conversion Factory) with Proc format.
Knowledge of pharmaceutical regulatory environment.
Analysing the data, and writing reports.
Data collection process to enable quick and reliable data analysis and improving quality of Data (Data integrity)
CDISC Study & Controlled Terminology.
Therapeutic area on statistical programming/Deliver statistical analysis.
Coding for data cleaning (DVP) & safety reporting
Involved to the creation with team of GBSC Statistical Analysis Plan (SAP)
Advise on new statistical methodologies to be used in support of industrial operations
Supporting SAS code validation activities
Ensure support and troubleshooting for end up users of the statistical applications.
Develop SAS utility programming tools for clients.
Problem solving is a key element to the role.
Ensure programming support for the Stat team.
Queries Management / Data Cleaning SAS
Analysis of statistical data/Writing of statistical presentations.
Statistical intervals (confidence, prediction, tolerance intervals), fixed & mixed effects ANOVA models, regression analysis, statistical process control.
Statistical modelling with PROC ,(ANOVA /GLM ,REG, CORR, MIXED,MEANS, SUMMARY,TABULATE...)
Act as secondary programmer to validate SAS programs that produce derived analysis datasets and data analyses and ad-hoc reports
Other procédures of SAS ( import, report, ,print, univariate,freq , corr ,reg , format, plot, gplot,gchart…)
Also creation of new data set with instructions proc sql, ODS: Output Management SAS (HTML, PDF, RTF)
technical environment
SAS 9, SAS Base , SAS Macro, SAS Olap ,SAS DI, SAS SDD,Sql.,MS office, Oracle, ,Data Modeling.
Matlab.

Assistant professor in computer modelling
ULB (Brussels):
janvier 2008 - mai 2008
8-MOBISTAR (Brussels): from July 2007 to December 2007

SAS Data warehouse/data Migration Analyst
Implementation of tools to make decision for company (Mobistar) using tools SAS 9, SAS EG,
Business Object 6, 5, ETL. MDWH (Marketing Data Warehouse).
Data warehousing, recoveries of existing data sources in different databases and (Reporting) through Business Object, Web intelligence, then modelled and analyzed, using SAS Proc SQL.

Context of the mission

Tasks

Collect, cleaning and formatting Operational data (SAS programming).
Achievement of data marts.
Analysis on Sales (SAS).
Creating reports (SAS, Business Objects 6.5).
Traffic analysis using Business Objects, Web Intelligence, Excel, Access & SAS, sending reports and new updated figures to the concerned members.
Make audit of files and directories to manage data files by interests.
Act as secondary programmer to validate SAS programs that produce derived analysis. Datasets and data analysis and ad-hoc reports.
Queries Management / Data Cleaning SAS
Used also the Studies of Data Mining: Predictive and Descriptive modelling.
Write conversion script & Compiling test results ,
The growth and profitability of the various campaigns/ campaign management.
Improved customer knowledge and optimization of the relational strategy.
CRM & Customer Intelligence to optimize customer relationships.
To evaluate the feasibility of required testin...