Abdehlai Fanouni

Design and development of Data and AI solutions for Innadvance's end clients (SMEs and scale-ups in digital transformation). Projects covering ML/AI, data engineering, and business application development. Intelligent Stock Market Recommendation System: Development of a personalized recommendation system for beginner stock market investors, with explainability of suggestions and GDPR compliance. RAG Conversational Agent for Document Database: Scattered scientific documentation (15,000+ publications, reports, protocols) making quick access to information difficult for research teams, requiring a natural language querying tool. Intelligent Stock Optimization Platform: Inefficient stock management causing overstocking (high storage costs) and stockouts (lost sales), development of a predictive solution to optimize stock levels. Cross-Platform EV Charging Mobile Application: Complete design and development of a mobile (Android, iOS) and web application for electric vehicle charging management, integrating interactive mapping, secure payment, and advanced authentication system. Data compliance and security: encryption of sensitive data, zero external transmission guaranteed by 100% local deployment, isolation of environments by Docker containerization, JWT authentication with role and permission management.

Migration of Legacy ETL to Cloud iPaaS - Talend/Qlik to Boomi

• Lead the complete migration of legacy ETL pipelines (Talend, Qlik) to a cloud-native Boomi iPaaS platform for 50+ critical interfaces.

• Write functional and technical specifications, scope development, estimate workloads, and monitor projects with reporting.

• Progressive migration of environments: development of Talend/Qlik interfaces, Java scripts, then refactoring architecture to Boomi iPaaS ensuring high availability.

• Complete production management: 24/7 incident support, functional enhancements, versioned deployments to production, UAT, and sandbox environments with GitHub version tracking.

• Workflow orchestration with TAC (Talend Administration Center) and TMC (Talend Management Console), monitoring pipeline performance, optimizing execution time.

• Multi-source integration: SFDC connectors (Salesforce via SOQL), SAP, relational databases (PostgreSQL, Oracle), Mobistep and Wizville mobile applications, Synchroteam.

• Development of REST and SOAP web services for interconnecting heterogeneous systems, error handling, and automatic retries.

• AWS Infrastructure: S3 file storage with lifecycle policies, EC2 virtual servers, automation scripts in Groovy.

• Results: Successful migration of 50+ interfaces without service interruption, 30% reduction in infrastructure costs, 20% improvement in processing time. Technologies: Talend (DI, ESB), Boomi iPaaS, Qlik, Salesforce (SOQL), Java, SQL, AWS (S3, EC2), Groovy, REST/SOAP APIs, Git.

• Development of cloud ETL pipelines and Snowflake data warehouse optimization on Azure for business analytics and reporting.

• Writing complete technical specifications, scoping development phases with business teams, estimating workloads and delivery schedules.

• Development of ETL pipelines with Matillion: extraction from multiple sources (business applications, flat files, databases), complex transformations, loading into Snowflake Data Lake.

• Optimization of complex SQL queries for analytical reporting: indexing, partitioning, Snowflake clustering, reducing execution time by 60% compared to unoptimized processing.

• Management of distributed execution on Azure compute services, monitoring job performance, automatic incident alerts.

• UAT Support: preparation of anonymized datasets for business validation, correction of anomalies in production.

• Conduct of the year-end financial process (RFA-YEFP): development of specific jobs, execution monitoring, ensuring the integrity of accounting data.