About Marco
Dutch
Native or bilingual
English
Fluent
German
Basic
Experience
- MilenceSenior Data Analyst / Solution ArchitectENERGY AND UTILITIESApril 2024 - Today (2 years and 2 months)Amsterdam, NetherlandsMilence mission is to rollout a European netowrk of high-performance public charging hubs for heavy-duty vehicles. They aim to transition towards data-driven decision-making by introducing BI & Analytics capabilities into their IT landscape. My role is to design and implement these capabilities.Key Contributions:• Defined the central Lakehouse architecture, aligned with Medallion principles to support scalable data operations• Designed the Enterprise Data Model and formalized data curation logic for the Gold Layer• Created central semantic models in Power BI to enhance consistency, reuse, and governed self-service analytics• Developed dashboards and insights for key business areas:○ Network Utilization & Reliability Monitoring○ Customer Revenue & Commercial Insights○ EV Market Intelligence & Benchmarking• Architected a modular energy forecasting engine, integrating:○ Grid, solar, wind, and battery simulation (supply)○ Market dynamics, historical usage, and commercial inputs (demand)• Utilized data governance tools (Atlan, Soda) to support monitoring and quality assurance• Enabled financial reporting through integration and modeling of data from Microsoft Business Central• Facilitated external data sharing with TNO and Rijkswaterstaat• Contributed to internal BI & Analytics team development through mentorship and process standardization.Tech Stack:Azure Data Lake, Databricks Lakehouse, Power BI Service & Desktop, Power Apps, SQL, Python, Azure DevOps, Terraform, Atlan, SodaEnterprise Integrations:Microsoft Business Central, MS Dynamics 365 CRM, Longship CPMS, IBM Maximo, Custom Payment Platform
- Shell Fleet SolutionsData Platform Solution Architect · Business Analyst · Project Manager · Data Migration LeadTRANSPORTATIONJune 2017 - July 2024 (7 years and 1 month)Londen, United KingdomFor Shell Fleet Solutions I designed, developed, and guided the rollout of a large-scale Azure-based BI & Analytics platform for Shell Fleet Solutions, delivered in collaboration with CGI.Key Contributions:Partnered with business stakeholders in the pre-funding phase, defining the solution vision and preparing cost estimations that secured executive sponsorshipActed as Lead SME for Fleet & Payment analytics, steering a team of business analysts and aligning reporting across business unitsDesigned the full BI & Analytics architecture, leveraging:Databricks Lakehouse with Medallion architecture (bronze/silver/gold layers)Azure Synapse Analytics for structured enterprise reportingAzure API Management to expose curated data via APIsBuilt real-time ingestion pipelines using:Azure Event Hub and Service Bus for message deliveryAzure Functions for real-time transformation and alertingCosmos DB for semi-structured event dataDelivered tabular models and dashboards via Power BI Service and Azure Analysis Services, enabling governed self-service analyticsLed end-to-end data pipeline design using Data Factory and Databricks, ensuring scalable ingestion, transformation, and curationDefined and evolved multi-layered enterprise data models, standardizing analytics across marketsCollaborated with Microsoft’s product and architecture teams to refine deployment patterns as one of the first large-scale adopters of Azure-native analytics in the organizationEnabled application and third-party integrations by exposing data services via APIs, secured via Azure API ManagementTech Stack: Azure Data Lake, Synapse, Databricks, Cosmos DB, Azure SQL, Event Hub, Service Bus, Azure Functions, ADF, Power BI, Power AppsIntegrations: Azure API Management, Mulesoft, Shell digital platforms
- M2-D2AI Solution Architect & Lead Developer - Agentic AI Data Retrieval PlatformSOFTWARE PUBLISHINGJanuary 2023 - Today (3 years and 5 months)Barendrecht, NetherlandsDesigned and built a conversational agentic platformthat enables users to extract structured data from websites using natural language, visual markup, and AI-powered scraping — orchestrated through a modular, multi-agent system.Users define target websites and data needs via a conversational assistant and a UI for visually selecting areas of interestThe main orchestration agent delegates tasks to specialized sub-agents for scraping, transformation, and publication.A data scraping agent executes extraction via DOM parsing, OCR, and fallback tools — dynamically choosing the best method when scraping does not deliver the desired data quality.A publishing agent auto-generates and exposes the curated data asREST APIs (JSON/XML/CSV) via Azure API ManagementIncludes automated API documentation and subscription based access through a Developer PortalA centralized message center manages inter-agent communication, status tracking, and modular extensibility.Vision-based extraction leverages OpenAI Vision to interpret UI-captured zones when traditional scraping failsDeployed using Dockerized microservices on Azure Kubernetes Service (AKS)with VNet isolation and full DevOps CI/CD integrationTechnology stack includes: LangChain,OpenAI Studio,FastAPI,LangSmith, Pydantic, Azure API ManagementBusiness value : Enables organizations to automatically acquire external dataand instantly and expose it through production-grade APIs. Unlocking integration with internal systems, analytics, and AI workflowsTech Stack: LangChain, OpenAI Vision, OpenAI Studio, FastAPI, Azure API Management, Azure Developer Portal, Docker, Azure Kubernetes Service (AKS), Pydantic, LangSmith, MCP, Azure DevOps, VNet
Recommendations
Be the first to recommend Marco
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
- Building Engineering / ArchitectureHZ University of Applied Sciences1996