The mission aimed to enhance the SAS programming skills of selected ACM employees and support them in building datamarts and reports for both the Life and Non-Life departments.

Coaching started at SAS LEVEL ZERO, and by the end of the mission, the users had become INDEPENDENT. Each month, topics were selected from the BeOptimized Tips and Tricks catalog, covering the equivalent of SAS Prog 1, Prog 2, SQL, and Macro. Theory was explained and reinforced through tailored exercises.

On top of that, two datamarts were created to load, transform, and monitor Data Warehouse tables. Automated reports were then developed. For the Life department, reports focused on mathematical reserves and various listings, while for the Non-Life department, Excel dashboards were built to track key monthly indicators (e.g., new contracts, claims by category).
On the picture: Mission accomplished for Alexis who earned the title of SAS Data Analyst with mention !!

This achievement means that we have met a high level of instructional and SAS Software-related expertise in delivering SAS training.
Thanks to this, we are accredited to deliver SAS training for one year.
In other words, when you order a SAS training via the official SAS portal, there is a good chance that BeOptimized will be sitting in front of you!
Click here to learn more about the program
According to SAS: "SAS instructors are the best and brightest SAS experts around the world. They're committed to helping you learn and grow with SAS. The recipient of this badge has proven their expertise in developing and delivering SAS software training to users."

The aim of the mission was twofold: to assist the SAS expert team in the creation/loading of a state-of-the-art Data Warehouse and to administer the SAS9 & SAS Viya 4 platform of the FPS.

With smiles on their faces, the BNPPF team was proud to receive a special "Congratulations" certificate from BeOptimized. They can all attest that BeOptimized significantly improved the performance of their SAS processes, used by their business users since 2016! More specifically, thanks to advanced SAS programming techniques, which are part of our SAS Code Optimization service, their processes are now 5 times faster than before!

Created in 2017, the BeOptimized Tips and Tricks service has been enhanced and now culminates in a SAS Expert certification! These super students followed a condensed SAS programming course every Friday for 9 weeks, covering Data Step processing, array manipulation, DO loops, flat file ingestion, formats, Proc SQL, macro variables, and macro programs. They now master end-to-end SAS data manipulation techniques, and believe me, they are real SAS Experts! Congratulations to the entire team—you’ve all done a great job!

The objective of the mission was to take ownership of and update a data-driven SAS internet web application used by the risk department at BNP Paribas Fortis.

In 2021, BeOptimized invested in 17 solar panels, with a total installed power of 5780 Wp. The expected annual energy production is around 5 MWh. With this production, BeOptimized will generate more energy than it consumes, and the surplus will be sent to the grid, where others will consume this 100% green energy.
In parallel, BeOptimized replaced its diesel car with a 100% electric car, directly connected to the solar panels.
These investments complement previous improvements made to the office, including double-glazed windows, roof insulation, automatic Velux shutters, a gas condensing boiler, electric reversible climate control, and real-time electricity consumption monitoring.

As a guest lecturer at UCLouvain, Christophe is the holder of the course LSTAT2370. This course covers the following topics: SAS SQL, SAS Macro, SAS Advanced Techniques and Efficiencies, and SAS Viya. It is designed for students and partially prepares them for the SAS Advanced certification.

This picture was taken during the SAS Curiosity Forum and represents, from left to right, the top five Belgian players of the SASENSEI quiz. SASENSEI is a question-based learning system where you can learn SAS and challenge your peers on a worldwide basis.

The goal of this project was to create a corporate risk dashboard in SAS VA 7.4, where the data is refreshed and loaded on demand in the LASR via STP. The project was delivered on time for P&V Assurances.

This project, carried out in collaboration with the SAS Institute, assisted ERGO Insurance Belgium in developing a FATCA/CRS SAS Module, including data extraction, customer detection, reporting, dashboards, listing exports, and scheduling. This module meets the FATCA and CRS regulations and enhances the utilization of the SAS AML 6.3 Solution.

Organized annually, the SAS BeLux Forum is the premier event for SAS customers and consultants to discover new SAS technologies and insights from various projects. BeOptimized was invited to present its work on ENGIE's project. Presentation title: "SAS Code Optimization and Best Practices in a Big Data Context"

First contract signed with ENGIE Electrabel, involving three projects:

• In the Settlement & DAM Department, we participated in the MIG 6 project, reengineering all BASE SAS codes in alignment with the MIG6 changes. This provided an opportunity to optimize and implement best practices in the code used in the department. Regular coaching sessions were also conducted to enhance the proficiency of SAS users.

• In the Marketing Department, we consolidated various marketing data sources and analyzed marketing pressure on each client to optimize targeting strategies.

• In the Compliance Department, we modified ENGIE's back-end systems to comply with GDPR requirements (Right to Access and Right to be Forgotten fields).

Formation of the legal structure of BeOptimized and the launch of two services, both positioned within the SAS Software domain: SAS Consulting and SAS AML & Fraud Detection.

As a Training Consultant and Analytical Consultant, Christophe worked at the SAS Institute in Tervuren for eight years. Check his LinkedIn profile for more information on his past projects.