Freelancer profile translated to English.
Back to original languageAbout Haddi
Business Intelligence Consultant (MOE/MOA) with 18 years of experience, primarily in the insurance sector. I have acquired expertise in the creation and redesign of business intelligence information systems: requirements gathering, BI information system design in accordance with all BI standards, database modeling, development of data feeds and reporting, support for testing and operations, and functional and technical documentation. I also have experience in the design, management, and analysis of data for management applications, MDM, or for internal/external company exchanges. I can adapt perfectly to business contexts other than insurance to successfully carry out BI projects. In order to precisely meet needs while respecting best practices, I always strive to coordinate and communicate with all stakeholders involved in my projects: end-users, MOA, MOE, architects/urban planners, and production teams.
French
Native or bilingual
English
Fluent
Can work on-site
Paris (up to 50km), Niort (up to 10km), Nantes (up to 10km), Le Mans (up to 10km), Bordeaux (up to 10km)
Experience
- MNTBI Technical Lead (MOE)BANKING AND INSURANCEApril 2022 - June 2024 (2 years and 3 months)Paris, FranceØ Project: BI Information System MaintenanceAs the technical lead for the BI information system, I was responsible for implementing change requests from business analysts or directly from users (Marketing, Actuarial, Accounting, Management) across all functional areas: individuals, contracts, contributions, and benefits in Health and Provident sectors. As a key contact for several projects or 'continuous improvements,' I performed the following:• Gathering user requirements and writing functional specifications• Designing the solution and data model• Coordinating stakeholders (data providers, production teams)• Writing technical specifications, installation guides, and operational guides• Developing ODI data feed processes• Developing Cognos framework, packages, and reports• Providing user support during testing and production• Administering the Cognos portal (access management, support)Environment: Cognos v10, ODI v12, Oracle 11g, Activ’Infinite v8Ø Project: Maintenance of data exchanges with MNT partnersData received by MNT from its partners, MUTEX and SMACL, are integrated into the DIVE datalake using BIG DATA technologies: files are deposited in an HDFS space and then loaded into a Hive database through Python (Spark framework) processes orchestrated with Oozie. This data then feeds the BI system and CRM. As the manager responsible for the maintenance of these flows, I developed enhancements and fixes for these processes using GitLab for versioning and delivering components. I used Ambari to analyze and resolve platform DIVE malfunctions with the Production Infrastructure team.Environment: Hive, Python, Oozie, GitLab, Ambari
- MGEN TechnologiesOperational Project Manager - BI Business Analyst (MOA)BANKING AND INSURANCEJune 2021 - March 2022 (10 months)Le Kremlin-Bicêtre, FranceØ Project: Technical Redesign of Internal Control BIThe Internal Control reporting (ISO, QPA reports) for MGEN is generated from heterogeneous databases (ISO, PMS) and outside MGEN's enterprise data warehouse (EDE). The technical redesign project for Internal Control BI aims to achieve several objectives while continuing to meet the needs covered by existing reporting:• Replace the DataManager ETL, which is no longer maintained by its publisher, with Oracle Data Integrator and replace the Cognos reporting tool with Power BI.• Streamline the production of Internal Control indicators by integrating them into the enterprise data warehouse in line with the BI architecture and standards.As an operational project manager within the Internal Control Business Analyst team, I performed the following:• Designed the target data models (tables to be added to the enterprise data warehouse, structures composing the new Internal Control datamart).• Wrote functional specifications and conducted testing for the data feeds to the new structures.• Developed a Proof of Concept (POC) for the new reporting solution using Power BI (data modeling in Power BI and development of the pilot report).• Estimated costs, created schedules, and led weekly project meetings with the MOA and MOE teams.Environment: Power BI (September 2021 version), Cognos v11, Netezza 7.2, PostgreSQL 9.6, Oracle 11g, DataManager, ODI
- ACOSSProduction Coordinator - BI Technical Lead (MOE)PUBLIC SECTORJanuary 2020 - May 2021 (1 year and 5 months)93100 Montreuil, FranceØ Project: Automation of SIDERAL Indicator LoadingThe loading of indicators from various sources (Email, Telephony, Claims, Aramis, Watt, Arome, Writing, Litigation, Declaration) into the BI system (Sideral) was performed manually. As a production coordinator within the BI Technical Lead team, I designed and implemented mechanisms to automatically trigger processes without third-party intervention, considering constraints such as source data availability checks, process scheduling, and automated error recovery.Environment: Shell, Oracle 12c, PL/SQL, Datastage v11, AutosysØ Project: Redesign of Manual Indicator File ProcessingUsers of the BI system (Sideral) provide indicator files that are manually extracted from SAS and must be loaded into a detailed Datamart and an aggregated Datamart of the BI system. As a production coordinator within the BI Technical Lead team, I designed and implemented the redesign of these loading processes:• By harmonizing business rules implemented separately for each of the 21 files with the MOA, and by replacing file-specific processes with cross-functional processes compliant with a standard BI architecture (ODS, Foundation, Datamarts).• By automating all actions that were previously performed manually, including file transfers and checks, loading scheduling and execution, and sending status updates and information about the loads to users.• By implementing automatic email reminders to individuals producing the files when the predefined loading schedule is not met.Environment: Datastage v11, Shell, Oracle 12c, PL/SQL, Autosys
Recommendations
Be the first to recommend Haddi
Help this freelancer shine by sharing your experience working together.
These freelancer profiles also match your criteria
Agatha Frydrych
Backend Java Software Engineer
4.7
(3)
2
Baptiste Duhen
Fullstack developer
4.6
(4)
5
Amed Hamou
Senior Lead Developer
4
(2)
7
Audrey Champion
Web developer
4.3
(3)
4
Education
- General Engineering DegreeESAIP2005Diplôme d'ingénieur généraliste
- DEUG MIAS Diploma (Mathematics and Computer Science Applied to Science)University of Franche-Comté2002Diplôme de DEUG MIAS