Fouad Lalmi

Keywords: functional analysis, SAS development, testing, support, technical documentation

Detailed achievements:

- As part of the "Convergence" project to migrate "Custom" contracts from the "Health-Provident" scope and to secure the social account closing deliverables for the "Technical Accounting" and "Inventory & MTP" teams:

- Responsible for the evolution of the output file construction process for feeding the IBNR Death Capital and Work Stoppage calculation model:

- Performance of non-regression tests on the basis of previous production cycles

- Implementation of Git repositories for versioning of all SAS code

- Documentation: user execution procedures, output field hierarchy

- SAS support and training for various stakeholders.

Keywords: scoping and high-level estimations, support, specifications and functional analysis, testing and SAS code

Detailed achievements:

- End-to-end management of the decommissioning project for the "Oracle EPM Workspace" Data Modeling tool, which involved fully transcribing the queries of existing data models under SAS Guide.

Actions taken: drafting functional specifications and test plans, technical support to development teams and business units (Customer Relations, Actuarial, Underwriting, Technical...) for production deployment.

- To secure the annual renewal operations of third-party payment cards: project to automate access to "third-party payment" data flows from "SQL Server" databases through the creation of new SAS views consolidating these flows according to agreed-upon criteria with business teams.

- Participation in the implementation of a tool to detect fraud cases due to potential over-billing for private rooms: facilitation of "business" workshops for defining needs, detailed functional specifications, development of SAS code to anticipate volume and facilitate the writing of technical specifications before implementation in Power BI.

- Management of various production incidents through rapid communication and by finding urgent solutions.

- Redesign of the data dictionaries for SAS views "Contracts", "Insured", and "accounting flows": metadata retrieval, functional field definitions, and online loading of these dictionaries into the "Data Galaxy" tool.

- Responsible for channeling various evolution requests from business teams: organizing workshops for feasibility studies, recording requests as JIRA tickets, continuous communication, and planning roadmaps for actions to be taken and/or prioritized.

- Centralization of authorization requests for access to data tools.

- Facilitation of weekly team meetings to review the backlog of ongoing projects.

- Training junior profiles in writing specifications, test plans, and monitoring the quality of their SAS developments.

Projects: leading SAS developer teams, designing SAS application solutions, and defining requirements.

Detailed achievements:

- Supervision of SAS developer teams at the CDS offshore (External Service Center) and workload management.

- Handling of evolution requests from business units (Actuarial and Risk) and drafting of work requests for the CDS, using the HP ALM QC tool.

- Forecast estimation of the budget allocated to quarterly SAS projects, and verification of invoices issued by the CDS after work order approvals.

- Responsible for delivering packages of program/SAS table evolutions under development to the MOA pre-testing environment (FIT) and business pre-production testing environment (UAT), then drafting the delivery note in anticipation of final production deployment (after validation of all tests).

- Management of post-production incidents: incident reporting via ITSM tools and analysis of errors found in SAS logs for debugging.

- Targeted development of SAS programs, optimizations, handling of tasks not covered by the CDS, including the implementation on the SAS Web portal "RAI PV" of a new batch file conversion interface from .csv to .dbf format, allowing the user to select/enter the input file directory, while introducing Javascript input validation.

- Centralization of requests for opening/modifying user access rights to SAS applications for submission to SAS administrators.

- Active participation in various meetings and operational committees with business units and the CDS respectively, to discuss feedback, future needs, on-call schedules, and staffing.

- Daily monitoring of the progress of various Jira tickets.

- Support to the Business Owner for drafting functional and technical specifications.