SAS Platform Administrator and Technical Expert - CBTW

• SAS Viya and SAS 9.4 Administrator
• Mar. 2023 - Present - CBTW (Lyon)
• Context :Maintenance and administration of SAS platforms.
• Missions : Within the HMS (Hosted Management Services) project.
  • Maintenance and administration of SAS Viya 4 platforms deployed on Azure
  • Support for SAS 9.4 to SAS Viya migration at all levels for HMS clients
  • Development support
  • Code optimization
  Within the RMS (Remote Management Services) project.
  • Administration of a multi-server SAS 9.4M8 platform
  • Development assistance
  • Incident resolution
  Various projects.
  • On-site client intervention for technical incident resolution
  • Content assessment of SAS V9 platforms for Viya migration
  • Development of VA reports
  • Coaching and support in SAS V9 / Viya / CAS programming
• Technical environment :Windows 10 - Unix - Kubernetes on Azure. SAS Viya 4 - SAS V9.4M8 - SAS VA - SAS EM - CAS

SAS Platform Administrator and Technical Expert - Freelance

• Data Engineer
• Jan. 2020 - Feb. 2023 - Solvay (Lyon)
• Context :Reorganization of Solvay’s Data service offering, migration of all SAS projects to Dataiku.
• Missions : Migration of industrial SAS projects to Dataiku.
  • Redevelopment of all industrial projects of the Digital @cceleration program on the Dataiku platform
  • Industrialization of industrial projects
  Development of the fingerprinter project.
  • From Dataiku, develop a template project applicable to all factories, providing pre-calculated indicators to control rooms
  • Data extraction from local MES/PI systems
  Support and maintenance.
  • Data provider and support for the Marietta plant diagnosis by McKinsey
  • Maintenance and administration of the Dataiku system
  • Maintenance of projects in production
• Technical environment :Windows 10 - Unix. DSS 8/9 - Postgres SQL - My SQL - GCP (GCS - Cloud SQL - GBQ)

• SAS Platform Administrator and Technical Expert
• Nov. 2018 - Dec. 2020 - Solvay (Lyon)
• Context :Providing expertise in the management of Big Data and Analytics service platforms.
• Missions : Design and administration of the SAS platform.
  • Design of the centralized bi-server SAS 9.4 platform with the SAS editor
  • Installation of SAS 9.4 in a bi-server setup (web & compute) on four environments powered by Windows Server 2016
  • Administration of the SAS 9.4 platform
  • Implementation of monitoring automation for the platform
  Development of industrial projects through the Digital @cceleration program.
  • Optimization of factory output by applying predictive models to sensor data from various factories
  • Data extraction from MES sensors via ODBC and application of the SAS optimization module on the data model
  • Project automation via VBS scripts
  • Optimization of the VA dashboard
  • Creation of a template project to be applied across different factories
  Benchmarking the SAS Viya test platform.
  • Performance testing of a Viya platform provided by the editor
  • esting the capabilities of its dashboarding tool
  • No-code testing
• Technical environment :Windows 10 - Unix. SASV9.4M5 - SAS VA - SEG - SAS Miner - SAS Studio

Business Intelligence Engineer, Development and Administration - Lincoln

• SAS V9 Platform Administrator
• Nov. 2015 - Nov. 2018 - Crédit Agricole S.A. (Saint Quentin en Yvelines)
• Context :Crédit Agricole required a new resource to administer its SAS platforms.
• Missions : Administration of SAS platforms.
  • Administration of SAS Enterprise BI Server, Visual Data Discovery, and Office Analytics platforms on Unix
  • Administration of networked SAS desktop on Windows 7
  • Security in SAS metadata and on Linux filesystems
  • Development of audit tools and SAS activity measurement in SAS language + Linux shell
  • Creation of reporting tables on SAS activity
  • Development of specific configurations for launching SAS batches on Linux server
  • Writing detailed technical specifications and installation procedures for SAS components
  • Approval of SAS tools on PC workstations
  User support:
  • Level 3 technical support for issues encountered on SAS Linux, SAS Hadoop, or standalone PC SAS desktop
  • Analysis and optimization of user SAS code
  • Support for Level 1 and Level 2 operations engineers (in French and English) in advanced support requests
  • SAS technical reference
• Technical environment :Windows XP. SASV9 BI, SAS9.2 - SAS9.3 - SAS9.4 - SEG - Stored Process - SAS Portal, HTML, DIS, Hadoop, Linnux Red Hat, VMWare Esx

• Business Intelligence Engineer in a Service Center
• Jan. 2010 - Sept. 2013 - Pacifica (Paris 15)
• Context:Provision of services related to the development of new projects.
• Missions: Development on QlikView of an application dedicated to budget management, staffing, MEPS, and server availability.
  • Implementation of QLIKVIEW development best practices
  • Application prototyping
  • Integration of data sources (18 XLS sources, 2 SAS sources)
  • Development and testing of 13 user interfaces
  • Data warehouse testing
  Creation of a web application under SAS using stored processes, allowing users to generate and view reports.
  • Management of source files and report executions in a web interface
  • Viewing results and managing the application by closing periods
  Development of a tool to justify accounting entries.
  • Presence and validity checks of files
  • Technical and functional checks: comparison of accounting entries between files from different systems, managed by an Excel file handled by users
  • Archiving of regulatory data once checks are validated
  In the context of all projects,
  • Participation in the analysis of the specifications and additional specifications during user workshops
  • Development and unit testing
  • Integration phase validation by enhancing the test plan
  • Incident handling and user support during the testing phase
  • Writing technical documents necessary for production in the PACIFICA context (technical specifications, operating manual, mapping)
  • Responsibility for package deliveries during deployments (integration phase, testing phase, production deployment)
• Technical environment:Windows XP. SAS V9 BI - Stored Process - SAS Portal, HTML, CSS, JS, Qlikview

Design & Development Engineer - Aixial

• Design & Development Engineer
• Jan. 2010 - Sept. 2013 - Groupama (Noisy-le-Grand)
• Context:The department was undergoing a major migration from SAS V8 Windows to SAS V9.2 Unix.
• Missions: Migration of all programs and warehouses from Windows/SAS V8 to Unix/SAS V9.2.
  • Compliance of SAS V8 programs to SAS V9 under Unix
  • Modification of dashboards created under Windows in DDE to the method adapted under Unix (mainly tagset.excel)
  • Migration of DMexpress 4 programs to the latest version DMexpress 6 (file processing)
  • Testing the migration from Oracle 8 to Oracle 11
  • Testing data warehouses
  Development of reporting tools.
  • Creation of automated monthly dashboards for the optical department, under SAS V9
  • Creation of dashboards for the Sévéane project under SAS V9
  • Creation of automated monthly dashboards for the Tiers Payant department from the DMTP datamart, under SAS V8 (DDE) then migration to SAS V9
  Creation of a SIPA data warehouse.
  • Writing detailed specifications
  • Setting up the Oracle database
  • Creation of reading programs (under SAS rather than the traditional DMexpress), feeding and automating the warehouse
  • Setting up validation files for the MOE
  Creation of a DMTP datamart.
  • Writing detailed specifications
  • Setting up the Oracle database
  • Creation of feeding and automating programs for the datamart under SAS V8
  • Warehouse and datamart tests for SAS V9 migration
  Monitoring feeds and limited projects on existing warehouses.
  • Monitoring daily/monthly feeds of warehouses and resolving any issues
  • Occasional addition of variables in existing warehouses
  • Occasional corrections of issues detected in warehouses
• Technical environment:Windows XP - Unix. SAS V8 - SAS V9 - DMExpress 6 - Oracle 11

• Design & Development Engineer
• Sept. 2007 - Dec. 2010 - Crédit Agricole Consumer Finance (Evry)
• Context:Following the client score developments carried out at Sofinco, project testing was performed.
• Missions: Validation of data for the daily client score implementation project.
  • Testing score data for production deployment
  • Creation of automatic data validation routines
  Implementation of Basel II regulatory compliance specifications.
  • Resolution of anomalies detected by the Banking Commission
  • Implementation of consistency and quality controls for Basel II data
  • Functional specifications for Basel II required data
  Development of reporting tools.
  • Development of stored applications producing client balance reports in HTML and Excel formats
• Technical environment:Windows XP - Unix. SAS V9.1.3 BI - SEG V4

• Design & Development Engineer
• July 2007 - Aug. 2009 - Sofinco (Evry)
• Context:The department I worked in was responsible for SAS databases.
• Missions: Administration of SAS databases and user support.
  • Management of flows/metadata and update tracking for Sofinco environments
  • Development of data recovery and restoration programs
  • Creation and provision of SAS tables for users
  • Creation of stored applications to assist development
  • Resolution of incidents and user work requests
  The "client score" project aimed to calculate the daily score for prospects.
  • Writing functional specifications in coordination with the risk prevention department
  • Writing detailed technical specifications
  • Development of raw/calculated databases to host client score data
  • Testing before validation and production deployment
  • Writing project documentation
  For ad-hoc projects,
  • Prescoring-Partner project: implementation of prescoring, pre-allocation, and problem resolution indicators for SOFINCO partners, managed from parameter tables
  • Implementation of data dictionary tables (from XML queries on metadata and flat files) to feed a JAVA application
  • Creation of datamarts for balance defense
  Implementation of SAS support for users.
  • Optimization and automation of user programs
  • Technical support
• Technical environment:Windows XP - Unix. SAS V9.1.3 BI - SEG V4 - ETL Studio V3.3 (DIS) - SMC V4

• Design & Development Engineer
• Feb. to June 2007 - Internship - Caisse des Affaires Familiales (Pau)
• Context:Internship in SAS application development.
• Missions: As part of ad hoc analysis development, creation of SAS applications facilitating database navigation.
  • Implementation of SAS/SQL reporting queries
  • Automatic generation of HTML outputs for impact and profiling analysis results
  • Integration of reports into automated Excel applications
• Technical environment:Windows NT / XP - Unix. SAS V8.2 / Base–Macro - SAS/Graph - SQL

I have two children aged and years.
I practice mushing with my 3 huskies.
I am also a regular photographer.