Olivier – PowerBI, Tableau, Python

An InsurTech platform providing commercial fleet insurance. Built centralized, automated reporting infrastructure from scratch to replace fragmented manual processes and deliver reliable, board-ready executive metrics across the business.

• Owned the company's core KPI (Loss Ratio) — the primary metric used by leadership and the board monthly — maintaining the underlying dbt/SQL codebase and extending metric coverage as requirements evolved.
• Built automated reporting pipelines using SQL, Python, and a custom document parser with built-in audit logs and validation checks, reducing manual reporting effort by 86% (14 days → 2 days).
• Separately automated a legacy Excel-based report, cutting processing time from 7 days to 0.5 days.
• Built reconciliation and exception-handling controls into reporting pipelines, flagging calculation mismatches via version-diff checks before delivery to partners.
• Represented the analytics function in high-stakes external meetings, providing validated data directly to business partners and fielding stakeholder questions live.
• Investigated recurring data and calculation discrepancies flagged by stakeholders, traced each to root cause, and implemented corrected logic through clear, auditable SQL/dbt transformations.
• Debugged and resolved production issues in Dagster-based orchestration workflows to maintain data reliability.
• Led a full BI modernization from Apache Superset to Power BI, conducting user training and building standardized templates to enable self-service analytics.

A payment authentication and account monitoring platform for enterprise fraud prevention. Embedded within the Engineering team, the project focused on validating new data orchestration pipelines and launching a brand-new client-facing analytics product.

• Built client-facing Power BI dashboards from scratch for a product with no prior analytics layer, delivering immediate system-outcome visibility to enterprise customers as the product scaled.
• Validated Airflow ETL pipelines to ensure downstream analytics and rule integrity before production rollout, repeatedly detecting discrepancies and driving code fixes through Engineering.
• Extended dashboard coverage to a third product line, building additional reporting across multiple parts of the business.

A payment authentication platform serving major financial institutions and e-commerce clients globally. Drove core fraud analytics, automated legacy reporting, and resolved complex transaction escalations as part of the central data science team.

• Automated complex reporting workflows by replacing legacy Excel processes with Python scripts for end-to-end data transformation, reducing processing time from 1 full day to 15 minutes.
• Shifted model evaluation methodology from standard AUC curves to business-centric intervention rates and used these insights to recommend optimal feature sets.
• Developed Python-based transformation logic to map complex rule-to-feature dependencies for the global 3DS v2 migration, generating bulk XML updates for seamless deployment.
• Led post-migration remediation, investigating performance degradation caused by missing legacy features and executing corrective actions including feature substitution, reconstruction, and rule removal.
• Built client-facing Power BI and Tableau dashboards from scratch and modernized legacy Tableau reports, delivering immediate system-outcome visibility to enterprise customers.
• Provided strategic performance reporting directly to executive leadership, delivering key takeaways, insights, and critical updates.
• Resolved complex internal and external escalations via root-cause investigations into transaction anomalies, providing clear, actionable answers to engineering teams and enterprise clients.
• Extracted and analyzed large-scale payment datasets to deliver fraud insights and industry trends for a major trade organization in the financial and banking sector.

A global cross-border payments platform enabling businesses to send and receive funds worldwide. Deployed a new internal risk case management system and optimized global regulatory reporting operations, spanning SAR processing, KYB investigations, and risk analytics.

• Led the implementation of a new risk case management system, gathering requirements and setting delivery priorities with Engineering.
• Partnered with Engineering to automate SAR narrative generation by line of business and transaction type, freeing the team to focus on higher-value case investigation.
• Managed a team of 2 analysts performing Suspicious Activity Reporting (SAR), overseeing work quality and regulatory standards.
• Investigated KYB cases where a customer's business profile was unclear, sourcing documentation to resolve partner-bank and regulator information requests.
• Proactively identified an unusual account-usage pattern during routine investigation and implemented new escalation guidelines for Operational teams.
• Evaluated risk control effectiveness and recommended adjustments to payment processes and risk rules, balancing fraud prevention with product performance and customer experience.
• Delivered analytical insights on emerging risks and operational inefficiencies to inform broader organizational strategy.