Elyes is available for hire
Hire ElyesElyes Boutaleb
Verified Expert in Engineering
Data Engineer Developer
Location
Paris, France
Toptal Member Since
November 9, 2023
Elyes is a senior business intelligence (BI) expert with 16 years of experience working for worldwide clients. He specializes in ETL processes, particularly utilizing tools such as SAP BusinessObject Data Services (BODS) and Otic. Proficient in SQL, Microsoft SQL Server, and Oracle, he seamlessly integrates cloud technologies with BI systems. Elyes holds many certifications in IBM Cognos administration, design, and reporting, as well as IBM TM1 and Cloud platforms.
Portfolio
Imerys
Amazon Web Services (AWS), SAP BusinessObjects Data Service (BODS), Otic...
Dassault Systèmes
TM1, Cognos TM1, SAP BusinessObjects Data Service (BODS), Oracle, SQL, Windows...
MGEN
SQL, Oracle SQL Developer, Oracle ODI, Oracle Data Integrator (ODI), Netezza...
Experience
Availability
Full-time
Preferred Environment
Batch, Amazon Web Services (AWS), ETL, IBM Cognos, Cognos TM1, SAP BusinessObjects Data Service (BODS), Cloud, PL/SQL, Oracle, SQL Server BI
The most amazing...
...TM1 app I've developed allowed 100s of users to save the workload of the budget forecasting process while working interactively, collaboratively, and securely.
Work Experience
Otic, SAP BODS, and AWS Cloud Project Manager
2019 - 2023
Imerys
- Worked at a Paris-based industrial leader and maintained all existing data flows and jobs via the ETL tool Otic. This included sales data such as orders, deliveries, and invoices from different ERPs in China, the UK, the USA, and Europe.
- Devised and implemented the necessary procedures for incorporating sales data from the newly established factory in India.
- Decommissioned the legacy system and switched to SAP BODS.
- Oversaw the monthly closing process, ensuring that sales invoices from all ERPs were loaded every month using Otic.
- Created new flows and developed a reporting system to meet the needs of the business.
Technologies: Amazon Web Services (AWS), SAP BusinessObjects Data Service (BODS), Otic, AWS Lambda, Big Data, Databases, Data Engineering, Tableau, Microsoft Power BI, PostgreSQL, Cloud Firestore, NoSQL, Database Migration, Microsoft SQL Server, Google Cloud Platform (GCP), Data Lakes, Azure, Data Warehousing, Data Analysis, Data Warehouse Design, ETL Pipelines, Database Lifecycle Management (DLM), ETL Tools, Data Science, Microsoft Excel, Amazon S3 (AWS S3), Redshift, Data Migration, Data Modeling, Azure Data Factory, AWS CLI, Python, Requirements Analysis, BigQuery, CSV File Processing, SQL, Data Architecture
TM1 and SAP BODS Senior Consultant
2018 - 2019
Dassault Systèmes
- Used TM1 and SAP BODS to establish new key performance indicators (KPIs) encompassing marketing, time analysis, and FTE analysis. Designed input tasks tailored for these KPIs.
- Performed evolutionary and corrective maintenance on all cubes, i.e., finance, resources, and project, as part of the business monitoring and dashboarding project using TM1 and SAP BODS.
- Executed a large-scale project to transition the main TM1 dimensions, including brand, sales organizations, geography, and industry.
- Oversaw security management in TM1 for users, dimensions, cubes, IT processes, and rules. Designed, implemented, and deployed SAP BODS flows for operational data store (ODS) feed and data marts.
- Developed the entire application for a finance assessment project using TM1, enabling the business to input revenue, cost, and margin forecasts.
Technologies: TM1, Cognos TM1, SAP BusinessObjects Data Service (BODS), Oracle, SQL, Windows, Job Schedulers, Task Scheduling, Databases, Data Visualization, Data Engineering, Modeling, PostgreSQL, Microsoft SQL Server, MySQL, Data Warehousing, Data Analysis, Data Warehouse Design, Database Lifecycle Management (DLM), ETL Tools, Data Science, Microsoft Excel, Data Modeling, Requirements Analysis, CSV File Processing, Data Architecture
BI Senior Consultant
2015 - 2018
MGEN
- Supervised both the evolutionary and corrective maintenance of the established information system integrated with the Microsoft SQL Server database, as well as the newly implemented system connected to Netezza.
- Spearheaded the design and implementation of Oracle Data Integrator (ODI) flow developments.
- Participated in the migration from the legacy system to the new Netezza infrastructure.
Technologies: SQL, Oracle SQL Developer, Oracle ODI, Oracle Data Integrator (ODI), Netezza, Squirrel, IBM Rational ClearQuest, Batch, Databases, Data Visualization, Data Engineering, Modeling, PostgreSQL, MacPractice, Microsoft SQL Server, MySQL, Firebase, Data Lakes, Data Warehousing, Data Analysis, Data Warehouse Design, ETL Pipelines, Database Lifecycle Management (DLM), ETL Tools, Big Data, Data Science, Microsoft Excel, Jira, Data Modeling, Requirements Analysis, CSV File Processing, Data Architecture
SAP BusinessObject (BO) Expert
2014 - 2015
Groupe Renault
- Designed and developed new universes in SAP BusinessObjects (BO) as part of the expansion of the Renault Supplier Appeals scope to multiple new organizations.
- Supervised the examination of existing universes using SAP BO Designer, implementing necessary modifications as needed.
- Optimized the existing universes, provided user support, and generated reports using SAP Web Intelligence (WebI).
Technologies: SAP BusinessObjects (BO), SAP BO Dashboards, Databases, Data Visualization, Data Engineering, Modeling, SAP, Microsoft SQL Server, Data Warehousing, Data Analysis, Data Warehouse Design, Database Lifecycle Management (DLM), ETL Tools, Data Science, Microsoft Excel, Requirements Analysis, CSV File Processing, SQL, Data Architecture
Cognos TM1 Consultant
2014 - 2014
Service Center
- Participated in IBM Cognos software installations and configurations.
- Participated in the installation of virtual machines for the servers and the subsequent installation and configuration of Cognos 8, Cognos 10.1.1, and TM1.
- Assisted in the installation and configuration of SAP BusinessObjects 3.1 products.
- Developed TM1 applications and mockups for UNICEF and Aegide.
Technologies: IBM Cognos, IBM Cognos Business Intelligence, Cognos TM1, TM1, Microsoft SQL Server, MySQL, Data Warehousing, Data Analysis, Data Warehouse Design, Data Science, Microsoft Excel, CSV File Processing, SQL, Data Architecture
SAP BO Design and Development Engineer
2013 - 2013
Institut National du Cancer
- Provided expert SAP BO design and development engineering services to the French National Cancer Institute and an independent expert research group called BVA.
- Maintained the decision-making system, which involved utilizing SAP BusinessObjects Business Intelligence (BI) to aggregate and summarize the surveys conducted by BVA for breast, cervical, and colorectal cancer screening.
- Conducted a feasibility study and assessed the potential impact before upgrading from BOXI3.1 SP2 to BOXI3.1 SP6.
Technologies: SAP BusinessObjects (BO), SAP BusinessObjects Data Service (BODS), SQL, Server Administration, Development, Central Configuration Manager (CCM), Design, Web Intelligence Rich Client (WebI), Import Wizard, Data Services Designer, Oracle 11g, SQL Plus, Microsoft, Databases, Data Visualization, Data Engineering, Modeling, SAP, Microsoft SQL Server, Data Warehousing, Data Analysis, ETL Pipelines, Database Lifecycle Management (DLM), ETL Tools, Data Science, Microsoft Excel, CSV File Processing, Data Architecture
Hyperion Planning Design and Development Engineer
2012 - 2012
Societe Generale
- Participated in the implementation of cubes using Hyperion.
- Assisted in the implementation of reports using Hyperion Financial Reporting.
- Participated in developing Hyperion Planning web forms.
Technologies: Oracle Smart View, Development, Essbase, Databases, Data Visualization, Data Engineering, Modeling, Data Warehousing, ETL Pipelines, Data Science, Microsoft Excel, CSV File Processing, SQL, Data Architecture
SAP BODS Design and Development Engineer
2012 - 2012
Opcaim
- Maintained the business intelligence system for Opcaim.
- Worked on resolving issues related to BI servers, such as the SAP BO reporting server, Oracle Database server, and SAP BODS integration server.
- Managed and optimized data flows and jobs within the SAP BODS environment.
Technologies: SAP BusinessObjects (BO), SAP BusinessObjects Data Service (BODS), SQL, Batch, Windows, Job Schedulers, Task Scheduling, Databases, Data Visualization, Data Engineering, Modeling, SAP, Microsoft SQL Server, Data Warehousing, Data Analysis, Data Warehouse Design, ETL Pipelines, Database Lifecycle Management (DLM), ETL Tools, Data Science, Microsoft Excel, CSV File Processing, Data Architecture
SAP BO Design and Development Engineer
2011 - 2012
Air Liquide
- Ensured the Third-party Application Maintenance (TPAM) integration to the existing SAP BODS data flow.
- Managed user access for reporting using the Central Management Console (CMC). Administered and secured SAP BusinessObjects Planning user access to their respective workbooks.
- Oversaw data design using SAP BO Designer for TPAM and other projects.
- Performed TPAM tasks and addressed any issues or irregularities identified and reported by SAP BO users.
- Oversaw the successful conversion of SAP Desktop Intelligence reports to WebI during the XIR2 migration to SAP BI4.
Technologies: Oracle, SQL, SAP BusinessObjects Data Service (BODS), SAP BusinessObjects (BO), SAP Business Planning and Consolidation (BPC), Databases, Data Visualization, Data Engineering, Modeling, SAP, Microsoft SQL Server, Data Warehousing, Data Analysis, Data Warehouse Design, ETL Pipelines, ETL Tools, Data Science, Microsoft Excel, CSV File Processing, Data Architecture
Oracle Warehouse Builder (OWB) and SAP BO Engineer
2010 - 2011
Ageas Insurance Limited
- Updated all Oracle packages, PL/SQL stored procedures, and Oracle Warehouse Builder (OWB) data flows as part of a project focused on evolving the structure and method of employee remuneration, resulting in a new remuneration system.
- Worked on the evolutions of existing models of SAP BO universes using an SAP Designer tool in development, test, and production environments. Conducted both evolutionary and corrective TPAM on SQL queries.
- Created and maintained SAP BO reports as well as documentation related to deliveries.
Technologies: SAP BusinessObjects (BO), Oracle, Oracle BI, SQL, Toad, Oracle PL/SQL, PL/SQL Developer, Oracle Warehouse Builder (OWB), Databases, Data Visualization, Data Engineering, Modeling, SAP, Data Warehousing, Data Analysis, Data Warehouse Design, ETL Pipelines, Database Lifecycle Management (DLM), ETL Tools, Data Science, Microsoft Excel, CSV File Processing, Data Architecture
Cognos and Genio Expert
2010 - 2010
Groupe M6
- Assumed responsibility for the channel scope, specializing in projects involving Cognos for reporting and Genio for data integration across various areas, including channel operations, advertising, finance, and human resources.
- Created Cognos Reports for Groupe M6's channels and entities, including M6 television, W9, Paris Première, Teva, M6 Mobile, M6 Music Black, M6 Music Club, M6 Music Hits, M6 Boutique, and M6 Films.
- Streamlined the processing time for existing reports and created prompt pages and summary pages using Java, Jakarta Server Pages (JSP), JavaScript, and HTML, which were combined with Cognos reports.
- Developed stored procedures in Oracle corresponding to the Operational Data Store (ODS) and Data Warehouse (DWH) database.
Technologies: Jakarta Server Pages (JSP), HTML, XML, JavaScript, Essbase, Genio, IBM Cognos, Cognos Report Studio, Frameworks, Oracle, SQL, Cognos ReportNet, Databases, Data Visualization, Data Engineering, Modeling, Microsoft SQL Server, Data Warehousing, Data Analysis, Data Warehouse Design, ETL Pipelines, Database Lifecycle Management (DLM), Data Science, Microsoft Excel, CSV File Processing, Data Architecture
Cognos Design and Development Engineer
2009 - 2010
Afpa
- Managed beneficiary allowances and information systems. Worked on financial, production, human resources, financial, and sales management.
- Oversaw evolutionary and corrective maintenance and realization of requests, including developments, creation of packages, deliveries, and documentation.
- Led maintenance of models using Framework Manager version 1.1 and generation of cubes using Transformer version 7.4 and online analytical processing (OLAP) using PowerPlay, as well as the evolution of Cognos ReportNet reports.
- Assumed responsibility for the administration of Cognos servers, managing access and publishing of cubes, as well as overseeing Cognos ReportNet reports.
- Developed data flows using Cognos Data Manager and Unix shells for creating packages, FTP transfers, launching streams, publishing reports, and cubes. Developed Oracle SQL scripts using Toad.
Technologies: Development, Cognos ReportNet, Cognos Framework Manager, Cognos Administration, IBM Cognos Transformer, IBM Cognos PowerPlay, Oracle, Toad, PL/SQL, Cygwin, FileZilla, PuTTY, Databases, Data Visualization, Data Engineering, Modeling, Microsoft SQL Server, Data Warehousing, Data Analysis, Data Warehouse Design, ETL Pipelines, Database Lifecycle Management (DLM), ETL Tools, Data Science, Microsoft Excel, Entity Relationships, CSV File Processing, SQL, Data Architecture
Cognos C8 and Data Manager ETL Consultant
2009 - 2009
Groupe Soufflet
- Worked at Groupe Soufflet, the foremost privately-owned grain collection company in Europe.
- Oversaw the maintenance, correction, and evolution of Cognos Data Manager data flows within the BI department, collaborating closely with the IBM team.
- Worked on Cognos security administration tasks as part of my role.
Technologies: Cognos ReportNet, Data Management, Cognos Data Manager, ETL Tools, Databases, Data Visualization, Data Engineering, Modeling, Microsoft SQL Server, Data Warehousing, Data Analysis, Data Warehouse Design, ETL Pipelines, Database Lifecycle Management (DLM), Data Science, Microsoft Excel, Entity Relationships, CSV File Processing, SQL, Data Architecture
Cognos Data Manager ETL Consultant
2007 - 2009
Urssaf
- Served as a technical project manager, leading the human resource management (HRM) scope. Crafted data flows using the Cognos DecisionStream or Cognos Data Manager.
- Implemented the solution for transferring SID files to a data warehouse. Used Unix shell and Oracle scripts for the development.
- Wrote technical documentation, manuals, and diagrams for the HRM data warehouse.
Technologies: IBM Cognos 8, Development, Cognos Report Studio, IBM Cognos Impromptu, Unix, Shell, AWK, Oracle, PL/SQL, SQL, Cognos Data Manager, Data Management, ETL Tools, Databases, Data Engineering, Modeling, Microsoft SQL Server, Data Warehousing, Data Analysis, Data Warehouse Design, ETL Pipelines, Database Lifecycle Management (DLM), Data Science, Microsoft Excel, Entity Relationships, SQL Server Integration Services (SSIS), CSV File Processing, Data Architecture
Experience
Imerys | Transfer of Files Using SAP BODS
Created an SAP BODS job to transfer CSV files from the AWS cloud to an external SFTP server. The CSV files contain deliveries, orders, and invoices. Additionally, I implemented another SAP BODS job to transfer forecast-related CSV files from an external server to the AWS cloud. The project yielded a high degree of success and demonstrated the efficacy of the implemented solutions.
Imerys | Creation of Sales Data Flows Using Otic
Oversaw the development of data flows on the legacy system using Otic while serving as a technical project manager at Imerys. This entailed not only managing any necessary evolutions but also performing TPAM. In particular, for a new plant in Visakhapatnam, India, I guided the project through all phases until its successful delivery.
From a technical standpoint, I implemented a data flow to extract sales data such as deliveries, orders, and invoices from their ERP system, which is currently operational and scheduled in Otic. Also, I replicated a similar project for a new plant in South Africa, demonstrating proficiency in executing similar ventures across different locations.
From a technical standpoint, I implemented a data flow to extract sales data such as deliveries, orders, and invoices from their ERP system, which is currently operational and scheduled in Otic. Also, I replicated a similar project for a new plant in South Africa, demonstrating proficiency in executing similar ventures across different locations.
Groupe M6 | Optimizing Cognos Reports Execution Time
Spearheaded a project focused on optimizing the execution time of specific Cognos reports. First, I conducted a comprehensive study to gain a deep understanding of their functioning. After identifying the bottleneck areas, I devised and implemented a solution that drastically reduced the execution time from over one hour to less than ten minutes. This achievement garnered high praise from the client, reflecting their satisfaction with the outcome.
Skillset
Languages
SQL, Batch, HTML, XML, JavaScript, AWK, Python
Tools
IBM Cognos, Microsoft Power BI, PuTTY, Microsoft Excel, Jira, AWS CLI, BigQuery, TM1, Squirrel, IBM Rational ClearQuest, Oracle Smart View, Toad, Cognos ReportNet, Cognos Framework Manager, Cygwin, FileZilla, Shell, Oracle Warehouse Builder (OWB), SQL Server BI, Tableau, GitHub, Looker, AWS Glue
Paradigms
ETL, Data Science, Requirements Analysis, Business Intelligence (BI), Oracle ODI
Platforms
Amazon Web Services (AWS), Windows, Unix, Google Cloud Platform (GCP), Oracle, Firebase, Oracle Data Integrator (ODI), Microsoft, AWS Lambda, Azure, Alteryx
Storage
Databases, PostgreSQL, NoSQL, Database Migration, Database Management Systems (DBMS), Microsoft SQL Server, MySQL, Data Lakes, Database Lifecycle Management (DLM), Amazon S3 (AWS S3), Redshift, SQL Server Integration Services (SSIS), Oracle SQL Developer, Netezza, Essbase, PL/SQL, Oracle 11g, Oracle PL/SQL, PL/SQL Developer, Cloud Firestore
Other
SAP BusinessObjects Data Service (BODS), Otic, ETL Tools, Data Visualization, Data Engineering, Modeling, SAP, Data Warehousing, Data Analysis, Data Warehouse Design, ETL Pipelines, Data Migration, Data Modeling, Data Architecture, Cognos TM1, Big Data, CSV File Processing, Cloud, Cloud Computing, Job Schedulers, Task Scheduling, SAP BusinessObjects (BO), SAP BO Dashboards, IBM Cognos Business Intelligence, Server Administration, Oracle BI, Genio, Cognos Report Studio, Frameworks, Cognos Administration, IBM Cognos Transformer, IBM Cognos PowerPlay, Data Management, IBM Cognos 8, Development, IBM Cognos Impromptu, Central Configuration Manager (CCM), Design, Web Intelligence Rich Client (WebI), Import Wizard, Data Services Designer, SQL Plus, SAP Business Planning and Consolidation (BPC), Cognos Data Manager, Computer Science, MacPractice, Entity Relationships, Azure Data Factory
Frameworks
Jakarta Server Pages (JSP)
Education
2006 - 2007
Master's Degree (M2) in Computer Science and Decision Support
University of Caen Normandy - Caen, France
2005 - 2006
Master's Degree (M1) in Computer Science and Decision Support
University of Caen Normandy - Caen, France
Certifications
OCTOBER 2023 - OCTOBER 2024
Intensive Cloud Training
The Cloud Bootcamp
JANUARY 2011 - PRESENT
IBM Certified Solution Expert – Cognos BI
IBM
JANUARY 2011 - PRESENT
IBM Certified Expert – IBM Cognos 8 Migration Professional
IBM
JANUARY 2011 - PRESENT
IBM Certified Specialist – Cognos 8 BI
IBM
JANUARY 2011 - PRESENT
IBM Certified Administrator – Cognos TM1 10.1
IBM
JANUARY 2011 - PRESENT
IBM Certified Administrator – Cognos 10 BI
IBM
JANUARY 2011 - PRESENT
IBM Certified Designer – Cognos 10 BI Multidimensional Reports
IBM
JANUARY 2011 - PRESENT
IBM Certified Designer – Cognos 10 BI Reports
IBM
JANUARY 2011 - PRESENT
IBM Certified Developer – Cognos TM1 10.1
IBM
JANUARY 2011 - PRESENT
IBM Certified Developer – Cognos 10 BI OLAP Models
IBM
JANUARY 2011 - PRESENT
IBM Certified Developer – Cognos 10 BI Metadata Models
IBM
JANUARY 2011 - PRESENT
IBM Certified Developer – Cognos 10 BI Data Warehouses
IBM
Collaboration That Works
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
1
Share your needs
Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2
Choose your talent
Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3
Start your risk-free talent trial
Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.
Top talent is in high demand.
Start hiring