Freelancer profile translated to English.
Back to original languageAbout Zacharie
Tired of high-tension financial closings, collapsing Excel files, and shelved tools?
For over 6 years, I've been transforming your fragmented data into an automated, reliable, and (finally) actionable decision-making ecosystem.
💡 WHAT I BRING TO YOU
With my dual expertise in business (Finance/Ops) and technical (Snowflake & Power BI Expert), I intervene where raw data needs to become a lever for cash flow and performance.
I don't just focus on the technical deployment of tools. My end-to-end support allows you to:
✔️ Structure your KPIs and clarify your management rules.
✔️ Ensure data consistency ("a single source of truth").
✔️ Build robust architectures (Snowflake, SQL) to automate data.
✔️ Transform your dashboards (Power BI) into real decision-making tools.
🏆 REFERENCES & RESULTS
Here's a glimpse of the impact of my recent interventions:
VERISURE:Complete overhaul of Finance reporting
- Before: Heterogeneous piloting, manual and time-consuming reporting.
- After: Snowflake + Power BI architecture.
- Result: Harmonized KPIs across departments, automated reporting, saving 30 hours/week, increased adoption.
APTIV:Automation of Agile project reporting
- Before: Weekly tracking with data entry delays.
- After: Real-time data pipeline.
- Result: Shift to daily and proactive management.
🤝 HOW WE WORK TOGETHER
Location:Paris / Île-de-France, Available remotely or on-site.
Availability:Immediate
Response via Malt messaging within 2 hours.
Have a BI overhaul project or a need to make your reporting more reliable? 📩 Let's discuss it directly via DM!
English
Native or bilingual
French
Native or bilingual
German
Conversational
Can work on-site
Paris (up to 50km), Paris (up to 50km)
Experience
- TalanBI & Analytics ConsultantCONSULTING AND AUDITSMarch 2026 - Today (3 months)Paris, FranceContext: Contribution to an internal project to design and present a technical demo for VivaTech 2026, showcasing an end-to-end use case in the F&B sector, from real-time data ingestion to decision-making reporting on Power BI.
- Designed an end-to-end data architecture on Microsoft Fabric for an F&B scenario (multi-site restaurant chain during the FIFA World Cup 2026): modeling a dataset of 4 to 6 million sales transactions, structured in a star schema.
- Implemented a medallion architecture using data pipelines, dataflow gen2, and Python/PySpark notebooks for data transformation and reliability.
- Set up a real-time data flow using Eventstream and KQL Databases (Eventhouse), simulating continuous sales transactions from an Event Hub, with live monitoring in Power BI.
- Developed Power BI reports connected to the Fabric warehouse (Direct Lake), with DAX measures adapted to the operational and financial KPIs of the scenario (revenue per stadium, average basket size, performance per point of sale).
- Prepared the demo presentation for technical and decision-making profiles, highlighting Fabric's value proposition as a unified platform (SaaS, centralized governance, real-time).
- VerisureLead BI / Data Analyst – Power BI & SnowflakePUBLIC SAFETYApril 2022 - December 2025 (3 years and 8 months)Antony, FranceObjective: Transform manual and fragmented financial reporting that exposed margin and cash flow (unpaid invoices, discounts, inventory) by deploying a centralized, reliable, and automated Power BI ecosystem to secure monthly closings and accelerate decision-making.I intervened in 4 aspects:1️⃣ Strategy & Scoping: In-depth audit of the existing system (performance, datasets), facilitation of business workshops, translation of needs into target KPIs, and mock-up creation up to functional acceptance.2️⃣ Modeling & Performance: Creation of unique semantic models, development of complex DAX measures, implementation of incremental refresh, and offloading heavy transformations to Snowflake via optimized SQL scripts.3️⃣ Decision-making Development: Design of executive dashboards (P&L, closing KPIs), internal audit reports (imputation anomaly detection), and operational monitoring (inventory, installation backlogs, fleet of 200+ vehicles).4️⃣ Governance & Change Management: Workspace structuring, security implementation (RLS), and user training.RESULTS✅ Closing & Finance Impact: Secured and accelerated closing cycle with elimination of last-minute manual adjustments, ensuring a "single source of truth" for teams.✅ Margin & Cash Protection: Strengthened discount control (anomaly correction) and accelerated collection through structured call prioritization.✅ Retention & Operations: Better control of customer cancellations through a 4-month predictive model and optimal inter-agency material distribution via Supply Chain monitoring.✅ Efficiency & Adoption: Saved 30-40 hours/week on Excel, freeing up time for strategic analysis, reduced report refresh times by 50-70%, and significantly decreased manual exports.Environment: Power BI, DAX, Power Query, RLS, SQL Server, Snowflake, SQL, Excel, Jira
- AptivBI Developer – Power BIAUTOMOBILEMarch 2019 - February 2022 (2 years and 11 months)Wuppertal, GermanyObjective:Replace time-consuming manual tracking with automated reporting in Power BI to secure software project KPIs and ensure reliable management decisions.My interventions:1️⃣Data prep & integration:Extraction, cleaning, and automated consolidation of Jira data and Excel files via Power Query.2️⃣BI Development:Creation and maintenance of Power BI dashboards (backlog tracking, sprint velocity) through the implementation of specific DAX measures.3️⃣Business support & communication:Continuous adaptation of reports to Product Owner requirements and preparation of data for sprint reviews.RESULTS:✅Responsiveness:Shift from sluggish weekly reporting to near-daily activity monitoring.✅Efficiency & Time Savings:Complete elimination of recurring manual adjustments; indicators systematically available before project committees.✅Reliability:Standardization of visuals ensuring common understanding and strengthening management's confidence in decision-making.Technical environment:Power BI, Power Query, DAX, SQL Server, Jira, Ms Excel.
Recommendations
Be the first to recommend Zacharie
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
- M.Sc. System Engineering and Engineering ManagementSouth Westphalia University of Applied Sciences,2019
- B.Sc. EngineeringRhine-Waal University of Applied Sciences,2018