Karim KHOUIMA

As a Data Integration Consultant, I am responsible for designing, developing and maintaining data integration solutions supporting business-critical processes and ERP modernization initiatives. -Design and implementation of data exchange flows between internal business applications. -Development and maintenance of integration processes using Semarchy xDI. -Development of SQL queries, stored procedures and data processing logic on Microsoft SQL Server. -Analysis of business requirements and translation into technical specifications. -Unit testing, troubleshooting and support during user acceptance testing phases. -Technical documentation and knowledge sharing through Confluence. -Source code management using Git and project tracking through Jira. -Contributed to the migration of accounting data to Sage X3 ERP. -Supported the migration of contract data to Sage X3. -Implemented and enhanced data exchange interfaces between multiple internal applications. Environment: Semarchy xDI, Sage X3, Microsoft SQL Server, SQL, Git, Jira, Confluence.

Delivered data integration, migration and modernization projects for multiple clients across transportation, logistics, retail and industrial sectors. -Design and development of ETL and data integration solutions using Talend. -Data migration and modernization initiatives. -Development of data transformation and data quality processes. -Technical analysis, specifications and documentation. -Unit testing, deployment preparation and production support. -Collaboration with business stakeholders and technical teams. -Migration of Oracle Data Integrator (ODI) jobs to Talend Data Integration. -Development and optimization of ETL processes and data quality controls. -Development of integration services using Talend Data Services and Talend Data Mapper. -Implementation and support of EDI exchanges and ActiveMQ-based integrations. -Development of CosmosDB connectors and migration of Talend jobs from version 6.5 to 8.0. -Validation and testing of Azure Data Lake components. -Design of a Data Warehouse for the logistics department. -Development of Talend jobs and Power BI reporting solutions. Technologies: Talend Data Integration, Talend Data Services, Talend Data Mapper, Oracle, Azure, ActiveMQ, EDI, Power BI, SQL, Git, Jenkins.

Ginkgo program which consists of the reurbanization of the Apave information system and redesigning of all inter-application flows: -Costing of developments -Design and development of Talend jobs ​-Writing of test cases and execution of unit tests of jobs -Migration of Talend v5 to v6 -Training of newcomers -Implementation of Talend best practices -Writing detailed technical specifications -Code reviewing -Maintenance, repair, operations and assistance to the production/infrastructure team in unlocking Talend processing problems

Redesign of Dalkia decision-making information system and support for various key applications (Repository, Finance and Purchasing, Optimization of travel) in terms of data feeds, reporting and the quality of the data they contain : -Design and development of Talend jobs to feed ODS, STG and DWH -Writing technical documentation -Unit testing of jobs -Development of universes, report's creation with SAP BO -Writing of technical documentation for the preparation of production

Data migration and data ingestion in DW for an automotive marketing solution : -Do a benchmark study of open source ETL tools to migrate data from OpenERP 7 to Odoo 8. -Data migration using ETL (Talend Open Studio for Data Integration). -Understand, document and utilize the functional aspects of various source systems from where the data will come into data warehouse. -Design, develop and test high-quality Extract, Transformation and Load (ETL) processes, programs and scripts. -Troubleshoot data integration issues and bugs, analyze reasons for failure, implement optimal solutions. -Create and maintain detailed documentation.

General accounting application: -Analyze business requirement. -Conception and database designing. -Coding. Technologies : VB.NET, SQL SERVER