Smain - Chef de projet SAS
Ref : 120505L002-
78170 LA CELLE SAINT CLOUD
-
Chef de projet, Consultant, Ingénieur système (44 ans)
-
Freelance
PREVIOUS PROJECTS
FOR SAS FRANCE – Various Clients (Amundi, Société Générale GATS, Filae, CACEIS Luxemboug, Schneider)
Profile: SAS Viya 3.5/SAS 9.4 Architect
Period: May 2022 – jan 2023
Role:
• Administration, maintenance, tuning, and support of SAS Viya 3.5 multi-tenancy environments
o Linux environments, authentication setup (LDAP, PAM, SSO, OpenID, SAML), database setup (ODBC, other connectors), log analysing.
• Administration, maintenance, tuning, and support of SAS Viya 4 containerized environments
o Linux environments, authentication setup (LDAP, PAM), database setup (ODBC, other connectors), log analysing, Kubernetes, docker.
• Customization of SAS containerized and multi node architecture on Kubernetes and Docker (AWS, Azure, IBM ICP)
• Understanding about Production / Operations Support for SAS Instances
• User Access Management and permissions on SAS and hosts (Linux, LDAP, SSO, OAuth/OpenID)
• Backup & Restore & Related policies, Resilience
• SAS Products (Analytics, Statistics, T.A, Model Studio, Ent. Guide etc)
• Daily BAU support using: Linux, Git, JIRA
• Documentation of processes
• Delivering releases and development based on Agile framework
• SAS 9.4 SAS Business Analytics platform Administration, maintenance on SAS client products: SAS EG, SAS DIS, SAS VA, Model Studio, SAS Studio.
Environment: SAS VIYA 3.5 & 4, SAS AML 8.x, SAS architecture, SAS administration, Cloud technology (Kubernetes, IBM Cloud Private, Azure), SAS programming for VIYA CAS, SAS Grid, Linux (Red hat 7.x 8.x, Suse 12.x,15), SAS authentication and SSO (OpenId/OAuth, LDAP, PAM) SAS Data Integration studio, Advanced SAS Macro programming.
FOR SAS NETHERLANDS – BANKING (ABN AMRO) (remote)
Profile: SAS Viya 4 Architect
Period: January 2022 – May 2002
Role:
• Development, maintenance, and optimization of SAS Exchange Layer (EL) solutions: custom solution exchanging data between SAS Viya 4.0 and SAS 9.4 (based on SAS Grid architecture) and Wolters Kluwer solutions
• Support and maintenance of data Integration jobs, components in SAS ESP, Kafka, SAS DIS
• Administration, installation, deployment of containerized applications with Docker, Kubernetes (linux RH 7.x)
• Participation on Microsoft Azure migration from IBM Cloud Private
• Customization of containerized applications on Kubernetes and Docker
• Daily BAU support using: Linux, Git, JIRA
• Documentation of processes
• Delivering releases and development based on a Agile framework
• SAS 9.4 SAS Business Analytics platform Administration and maintenance
Environment: SAS VIYA 4, SAS ESP, SAS Technical Infrastructure, MS SQL server, SAS administration, Cloud technology (Kubernetes, IBM Cloud Private, Azure), SAS programming for VIYA CAS.SAS Grid, Linux Red hat 7.x, SAS Data Integration studio, Advanced SAS Macro programming.
MALAKOF HUMANIS (FRANCE- PARIS) – INSURANCE (partly remote)
Profile: SAS Consultant (Migration and Integration)
Period: July 2021 – December 2021
Role:
• Merging SAS 9.4 Business Analytics platform for Microsoft to SAS 9.4 Business Analytics platform for Unix AIX
• Scoping, scaling and designing of target environments.
• Design authority for implementing and optimizing SAS Platforms and business reporting.
• SAS Visual Analytics platform optimization (upscaling platforms)
• POC SAS Viya Linux 3.5/4: Study on a migration from SAS 9.4 Business Analytics platform to SAS Viya.
• Migration of SAS Entreprise Guide projects and data flows to SAS viya 4.0.
• Implementation of SAS ESP for CAS and Kubernetes API server
• Deployment of SAS Event Stream Processing in a test environment with SAS 9.4, SAS Viya, and in a Kubernetes cluster.
Environment: SAS Programming, SAS enterprise Guide, SAS VA, SAS Viya from 3.5 to 4.0, SAS 9.4 Microsoft, SAS 9.4 IBM AIX, SAS ESP for CAS, LSF, SAS Grid, Kubernetes cluster.
ORANGE (FRANCE) - TELECOM
Profile: SAS Consultant (migration)
Period: July 2019 – Oct 2020
Role:
• Leading SAS programs migrations project to DATAIKU – Python – R - Pyspark
• Scoping, scaling and designing of target environments.
• Design authority for implementing and optimizing Big Data architecture
• Work with stakeholders to evaluate costs, risks and planning.
• Deliver budget and planning estimate on migration.
• Evaluate migration risks and constraints.
• Implementation of SAS Event Stream for sensor data monitoring, operational systems condition monitoring, fraud detection, personalized marketing.
Environment: SAS 9.4, SAS Programming, SAS enterprise Guide, DATAIKU, Big Data architect on Hadoop solutions (Panda, R, Python, Hadoop, Spark, PySpark).
MALAKOF HUMANIS (FRANCE- PARIS) - INSURANCE
Profile: SAS Solutions Consultant (Architect and developer)
Period: April - July 2019
Role:
• Leading SAS Migrations SAS EBI 9.2 to 9.4, then migration AIX to Linux
• Data and Metadata Migration
• Optimizing SAS Visual Analytics performances, reports.
• SAS Viya 3.0 test environment implementation
• Design authority for implementing and optimizing Security.
• Server scaling
• Work with stakeholders to coordinate improvement initiatives.
• Deliver architecture documents
Environment: SAS Enterprise BI Server (SAS enterprise Guide, Management console, SAS Olap), SAS Visual Analytics, Shell, Unix, Linux, Oracle, DB2, Sybase, MS SQL, My SQL.
HSBC (UK- LONDON) - BANK
Profile: SAS and Big Data Consultant
Period: February - March 2019
Role:
• Design of a Disaster Recovery architecture for SAS 9.4 and SAS VA
• Systems administration and security
Monitor the enterprise environment for availability and performance and security.
• Set user privileges.
• Migrations of SAS platforms
• Managing Grid
• Assist Infrastructure in capacity planning, co-ordinate between IT and business.
• Assist Business with troubleshooting and performance tuning their models/code
• Work with stakeholders to coordinate improvement initiatives
Environment: SAS 9.4, SAS Grid, SAS VA, System administration (Linux, Windows), SAS Intelligence Platform administration (SAS enterprise Guide, SAS enterprise Miner), SAS Web Infrastructure Big Data (Hadoop Clustering, Impala/Hive, HDFS, MapReduce), Unix, Linux, Oracle.
AXA GROUP SOLUTIONS (FRANCE) - INSURANCE
Profile: SAS BI Solutions architect
Period: March 2013 - January 2018
Role:
• Design and manage the Functional and Technical implementation choice according to Shared Services target roadmap for BI entity.
• Analyze business requirements to design, develop and implement highly efficient, highly maintainable, and scalable BI and enterprise solutions that meets defined standards.
• BAU team management based on ITIL framework (incident management, problem management, change management, release management, configuration management, capacity planning).
• Design and Management of architecture projects: scoping, studies, cost evaluation, detailed specifications, planning, developments follow up, user acceptance testing, production release.
• Knowledge, Guideline and expertise to Service and Solutions delivery.
• Responsible involved in running production environment, implying related operation procedures: batch chains executions, backup procedures.
• Design, Control and validate the Solutions delivered to external customers.
• Leading relationship with third parties (Editors, vendors, and customers) to facilitate Project Deliveries and relevant choice according to BI directives.
• Daily support BAU and Project Teams to face highly technical issues.
• Contributor to release management and configuration management industrialization.
Environment: SAS platforms and analytics SAS 9.2, 9,3, 9,4 (SAS Risk, SAS FM, SAS enterprise Guide, SAS enterprise Miner, Data Flux, R), Big Data (Hadoop, Impala/Hive, HDFS, MapReduce), Unix, Linux, Windows, Apache, WebLogic. Teradata, Oracle, SQLServer, R, WPS.
EDF (FRANCE) – ENERGY INDUSTRY
Profile: SAS Consultant (Project Leader)
Period: June 2011 to March 2013
Role:
• Performance, tuning and security advisor on data migration and optimization within the SIRH project
• Expert of SAS products and platforms (Linux, Applications servers: Tomcat, Weblogic. Database administration Oracle, SQL Server, MySQL)
• Audit and advising in SAS architectures, tuning and functional best practices.
• User support and training on SAS BI tools and applications
• Administration and daily operations of the SAS BI platforms and databases
Environment: Linux (Redhat), SH/KSH Scripting, SAS 9.1, SAS Platforms and environment administration, Oracle WebLogic Server 9/10, OLAP Cubes, Database administration (ORACLE, MYSQL)
POLE EMPLOI (FRANCE) - PUBLIC
Profile: SAS BI Platform Migration project manager
Period: December 2009 to May 2011
Role:
• Management of migration project: ASSEDIC/UNEDIC Fusion (SAS data migration and optimization)
• Administration and daily operations of the SAS BI platforms (SAS 9.1.3/9.2 Weblogic 9/10, Apache, Xythos, Unix, Windows)
• User support and training on SAS BI tools and applications (Eguide, WRS, Information Map Studio)
• SAS Platform Migration RISC -> Itanium (SAS 9.1.3)
• Implementation of new SAS 9.2 Platforms (Weblogic, SCS and Unix)
Environment: SAS V8.2/9.1/9.2, SAS Enterprise BI Server 3.1/4.2/4.3, SAS Management Console 9.1/9.2, SAS Enterprise Guide 4, IBM DataStage Server/PX, Oracle WebLogic Server 9/10
CONFIRMIT (OSLO - NORWAY) – SAAS/IAAS
Profile: SAAS Platforms Pre-Sales Consultant
Period: August 2007 - November 2009
Role:
• Design, implementation, and spec audit as presales offers
• Confirmit platforms training and consultant for customers
• SAAS platform Support for international customers: USA, France, Germany
• Management, administration, monitoring of Confirmit operational and functional customer environments « On Premise » (local and international: UK, USA, France, Belgium, Romania, Norway, Sweden…)
• Management and administration of Microsoft SQL Server DB (data warehouse and DataMart optimization)
• Management and administration of web and reporting applications (MS IIS 6/7, ASP .NET)
Environment: Microsoft SQL Server 2000/2005, Microsoft IIS, Microsoft .NET
TROLLTECH (OSLO - NORWAY) - IT
Profile: Operation manager
Period: February 2005 July 2007
Role:
• Data solutions Design, Upgrade, update and maintenance of international database architecture (CRM, Salesforce), responsible of production environments, writing of procedures and documentations.
• Security, Network and Database administrator for external offices in Norway (Oslo), USA (Palo Alto, CA), Australia (Brisbane), China (Beijing) et Germany (Berlin, Munich).
• Creation of technical documents and processes
• Configuration, administration of data environments (CRM, Oracle, SQLServer)
Environment: Axapta CRM, Oracle 8i/9i, MySQL, PostgreSQL, IBM WebSphere, Nagios
RENAULT (FRANCE) – CAR MANUFACTURER
Profile: UNIX Administrator / SQL Developer
Period: September 2003 to December 2004
Role:
• Web application management: IBM WebSphere 4/5 (IBM AAT/ASTK) – loading tests Mercury Loadrunner.
• Maintenance: Shell development (Ksh, sh, bash, sql, DOS, VBS), monitoring (MQSeries).
• Administration, maintenance, support: Oracle 9i, SQL development
• Batch management: Autosys, scripts ksh, CFT.
• Application quality validation / Documentation
• Applications Integration and maintenance.
Environment: IBM WebSphere 4/5, Oracle 9i, Mercury Loadrunner, UNIX, Windows
SOLUTIONS TECHNIQUES
•PLATEFORME SAS:SAS Analytics, SAS Grid, SAS VA/VS, connecteurs SAS (ODBC, SQLServer, Hadoop ...)
•BI/BIG DATA:Hadoop, Impala, Hive, HDFS, MapReduce, Spotfire
•SGBDR:Oracle 9/10, MySQL 4/5, Microsoft SQL Server 2000/2005, PostgreSQL
•DEVELOPPEMENT:SAS Base, Macro, STAT, SQL, SHELL UNIX/Linux
•ETL: SAS Data Integration
Studio
•QUERY & REPORTING/ANALYTICS: SAS Enterprise BI Server 3.4/4.2/4.3 (SAS Web Report Studio, SAS Enterprise Guide)
•RESEAUX ET SERVICES : TCP/IP, Web services, Apache, Tomcat, Jboss)
•SYSTEMES D’EXPLOITATION: UNIX (Solaris, AIX, HP-UX), Linux (RedHat,SuSe, Debian), Windows NT4/2000/2003 (Server et Professional
FORMATIONS
2003: Ingénieur informatique Systèmes, Réseaux et Télécoms (SRT) (INSIA –Paris 20ème)
•2006:Microsoft Certified System Administrator (MCSA) Windows 2003/Vista
•2009: Formation SAS:Architecture de la plateforme SAS 9.1.3
•2009: Formation SAS:Architecture de la plateforme SAS 9.2
•2010: Formation SAS:Programmation SAS: Niv 1, 2, 3