Edmond Lamah

Project: Implementation of a new set of management indicators for Housing. Successful migration of the commercial Datamart from SAS to Informatica. Integration of SPOT identifiers across several domains. Objectives: • Design of an indicator base piloting the performance of Housing products (over 500,000 contracts). • Integration of SPOT identifiers across several business domains (SIC, Health, Telephony, Provident, Banking, and Credit). • Complete migration of the SAS commercial Datamart to Informatica, reducing processing times by 35%. Missions: • Instruction and evaluation of workloads. Instructions and cost estimations for evolution requests. • Development of housing indicator feeding mappings: Quotes, Sales Initiated, Valid Sales, Replacements and Modifications, Cancellations, Current Discounts. • Modification of mappings and scripts to support new SPOT identifiers in the SIC, Telephony, Health, and Provident areas. • Analysis and optimization of existing flows. • Business testing monitoring. • Preparation of deliverables and production deployment in DevOps mode. • Writing technical specifications, application schemas. Environment: Control M, Hive, Oracle 10g, Informatica ETL Grid 10.2.0, OGC, Nexus, Deploysid, Shell Unix, SQL.

Project: Design of group management indicator bases for regional banks through their private datamarts for reporting and analysis purposes. Objectives: • Design and feeding of an indicator base for the health domain (Health Expenses Monitoring). • Design and feeding of private datamarts for 12 regional banks. • Development of ETL flows for QPC reports.

Project: Implementation of a data platform to host data from 24 Manutan subsidiaries for analysis and management purposes. Objectives: • Design and feeding of an Azure / Snowflake cloud platform hosting over 10 TB of data. • Development of Talend ETL flows for the various data platform layers. Missions: • Workshops for defining the data dictionary for the Customers and Sales domains with the various subsidiaries. • Technical design workshops for the data platform. • Creation and configuration of Azure containers to host on-premise data. • Creation of Snowflake connectors. • Design and implementation of generic processes for feeding the data platform's bronze layer. • Support during business testing. • Writing manufacturing files for automatic Dollar Universe scheduling chains. • Preparation of deliverables and production deployment. • Writing technical specifications, application schemas. Environment: Microsoft Azure, Snowflake, Talend Cloud Data Integration, Microsoft Dynamics AX, STEP, SQL Server, Dollar U, GitLab.