Damien H.

🔸 Led the development of BI solutions and improved Data Warehouse pipelines for key insurance reporting. 🔸 Delivered high-quality Business Objects reports under tight regulatory timelines. 🔸 Optimized DWH performance and ensured data reliability across OLAP, Power BI, and BO environments. 🔸 Partnered with cross-functional teams to align data architecture with evolving business needs.

🔸 Maintained and optimized Oracle-based fund administration systems aligned with SWIFT standards. 🔸 Developed PL/SQL programs and automated reconciliations between Multifonds and SWIFT datasets. 🔸 Enhanced performance and reliability using execution plans, AWR/ADDM reports, and PowerShell automation. 🔸 Improved incident resolution time with effective L3 support and DevOps best practices.

🔸 Digitalized PM² methodology and developed KPIs via Power BI for project portfolio governance. 🔸 Built OLAP cubes and SSIS pipelines to automate risk reporting workflows. 🔸 Created BI dashboards and validation monitoring tools using SSRS and Power BI. 🔸 Designed a star-schema-based SQL Server database for efficient reporting. 🔸 Designed dashboard by using datamining to analyze risk and model cost

🔸 Led the development of a data quality scoring platform aligned with DAMA-DMBOK standards, covering completeness, uniqueness, consistency, timeliness, and validity. 🔸 Built a full-stack application using Python (Django), Pandas, Numpy, and deployed it via Kubernetes using Dockerized microservices, ensuring modularity and scalability. 🔸 Applied machine learning (PyTorch) to detect anomalies and potential data issues in structured and semi-structured files. 🔸 Integrated the platform with CI/CD pipelines in Azure DevOps, using Git for version control and automated deployment workflows. 🔸 Developed real-time Power BI dashboards for business users to monitor data quality scores and remediation progress. 🔸 Designed SQL Server databases and optimized T-SQL queries for fact sheet generation and ETL pipelines, used for asset management reporting. 🔸 Delivered comprehensive technical documentation and test cases to support production roll-out and future enhancements.

🔸 Designed and deployed a national data management platform to support COVID-19 contact tracing and vaccination center operations. 🔸 Developed robust ETL pipelines (IBM DataStage) to integrate datasets from the Government IT Centre (CTIE) with the Health Ministry’s Data Warehouse. 🔸 Ensured data quality control through automated validation checks, schema standardization, and referential integrity enforcement. 🔸 Implemented data anonymization and pseudonymization techniques to protect sensitive health information in compliance with GDPR and national privacy standards. 🔸 Delivered real-time, interactive dashboards with QlikView and Power BI, enabling rapid response from public health officials and epidemiologists. 🔸 Developed custom SharePoint modules (PowerShell, JavaScript) to streamline communication between administrative centers and facilitate data access. 🔸 Automated public health reporting workflows and built scalable KPI dashboards for operational and strategic decision-making. 🔸 Supported internal audits by documenting lineage, access logs, and traceability of sensitive datasets. 🔸 Collaborated with cross-functional teams to translate public health policies into technical reporting requirements. 🔸 Fostered a culture of data governance and transparency by building dashboards for data completeness, consistency, and accuracy.

🔸 Digitalized PM² methodology and developed KPIs via Power BI for project portfolio governance. 🔸 Built OLAP cubes and SSIS pipelines to automate risk reporting workflows. 🔸 Created BI dashboards and validation monitoring tools using SSRS and Power BI. 🔸 Designed a star-schema-based SQL Server database for efficient reporting. 🔸 Designed dashboard by using datamining to analyze risk and model cost

🔸 Led the development of a metadata-driven data warehouse to audit and verify document formats (PDF, FORMEX, HTML) exchanged between the European Commission and the Court of Justice. 🔸 Designed and implemented SPARQL-based data models to structure unstandardized document metadata for validation tracking and historical compliance audits. 🔸 Built automated pipelines and PowerShell scripts to monitor, convert, and reconcile document formats in line with EU publication standards. 🔸 Developed Excel-based analysis tools using Power Pivot and VBA to visualize inconsistencies, highlight missing formats, and support corrective actions. 🔸 Implemented automated quality checks to ensure all submitted documents adhered to digital accessibility and multi-format delivery rules. 🔸 Collaborated with legal, IT, and publishing teams to define format compliance KPIs and set up cross-system reporting dashboards. 🔸 Ensured data lineage and traceability of transformations through audit logs and process documentation, supporting long-term institutional transparency. 🔸 Contributed to knowledge transfer by documenting ETL workflows and conducting training sessions with operational teams on tooling and format validation.

🔸 Automated and optimized Solvency II and QRT regulatory reporting workflows using IBM DataStage and SQL, improving accuracy and reducing processing time. 🔸 Built robust ETL pipelines to extract, transform, and load data from diverse financial systems into structured reporting formats. 🔸 Designed and delivered interactive dashboards in Power BI and WebFocus to enhance visibility into fund performance, solvency ratios, and investment risk. 🔸 Implemented data quality controls to validate source data and ensure consistency across regulatory submissions. 🔸 Collaborated with actuarial, compliance, and finance teams to align data architecture with regulatory and audit requirements. 🔸 Supported fund transparency initiatives by developing data models that handled complex portfolio structures across multiple asset classes. 🔸 Ensured thorough documentation of data flows and transformation logic to support audits and cross-functional knowledge transfer.

🔸 Automated and industrialized Solvency II and QRT reporting processes using IBM DataStage, reducing manual intervention and improving accuracy. 🔸 Designed and optimized ETL pipelines (AMPERE file processing) to aggregate and reconcile data from multiple internal and third-party sources. 🔸 Built scalable data models to represent complex fund structures, enhancing transparency in investment composition and regulatory disclosures. 🔸 Developed interactive dashboards with Power BI and WebFocus, allowing real-time insights into fund compliance, solvency ratios, and investment breakdowns. 🔸 Applied data validation techniques to ensure consistency and reliability of financial and risk data across reporting cycles. 🔸 Worked with actuaries, compliance officers, and financial controllers to align data transformations with regulatory frameworks (Solvency II, Basel IV). 🔸 Documented data flows, logic, and mappings to ensure audit readiness and improve cross-team collaboration. 🔸 Contributed to the implementation of data governance standards, improving data traceability and regulatory confidence.