Data Integration Architect & Supply Chain Consultant

Connect every system. Secure every pipe. See the whole business.

I design the data integration architecture that brings cloud (AWS, Azure, GCP) and on‑prem systems together on one secure platform — the complete, trustworthy foundation that people, analytics, and AI agents all need before they can act on the full picture instead of a partial one. I bring the same end‑to‑end thinking to supply chain planning. Based in Umbria, Italy. Working with manufacturing groups worldwide.

25+
Years in supply chain & data systems
3
Clouds connected — AWS, Azure, GCP
7
Industries, oil & gas to cosmetics
4
Countries with active client teams
About

Business analysis, product management, and testing — for supply chain software.

I’m Philip De Rop. I spent years as a product manager and test manager for a supply chain software company before going independent as Catena‑Tec. I still help that company manage product development and testing, and I take on engagements directly with manufacturers who need help getting the right things to the right place at the right time.

A large part of my work now is data integration architecture: connecting a company’s systems — cloud platforms like AWS, Azure and GCP, and whatever still runs on‑prem — into one secure, unified platform, using Fivetran, dbt core, PostgreSQL, SQL Server and Databricks. Done properly, that’s what lets a business see itself end to end, and it’s the same complete, trustworthy foundation that AI‑based analytics and agents need before they can give a full answer instead of one based on half the data.

Alongside that, I still do the planning work: demand planning, supply planning, inventory management, rough‑cut capacity planning and scheduling. And I build software — as a C# developer, software test manager, and product development manager.

Most of my clients are project managers with a lot on their plate, so I keep meetings short and stay engaged for the long run. The majority of my work comes from clients I’ve stayed with for years, and from the people they bring in when they move on to bigger roles.

Based in
Paciano (PG), Umbria, Italy
Works with
Teams in the US, Belgium, Bulgaria & India
Services

Connect the data, plan the chain, build the software.

Catena is Italian for chain. These days that chain is as much about data as it is about physical goods — a company can’t plan, analyze, or automate what its systems can’t see. Most engagements start with the data and pull in the other two.

01  Data integration & architecture

Designing and building the secure pipelines that connect every system a company runs — cloud or on‑prem — into one platform, so there’s a single, trustworthy source of truth for analytics, reporting, and AI agents that need full context to act.

01

Connect

Cloud platforms — AWS, Azure, GCP — and on‑prem systems, including ERPs like SAP, wherever the data actually lives.

02

Integrate

Bidirectional pipelines built on a reusable dbt core standard, plus direct tooling — including RFC and BAPI connections into SAP.

03

Unify

One platform — any database, warehouse, data lake or lakehouse — holding the complete picture.

04

Analyze

Company‑wide insight, ready for BI, analytics, and AI agents that need the full context.

02  Supply chain planning
01

Demand planning

Forecast what customers will need, by product, location and period.

02

Supply planning

Build a network‑wide plan to meet that demand across plants and suppliers.

03

Rough‑cut capacity

Stress‑test the plan against real capacity before it’s committed.

04

Inventory management

Set the right stock levels for raw materials and finished goods.

05

Scheduling

Turn the plan into a detailed, executable production schedule.

03  Software delivery

Software development

C# application development — building the tools that run the plan, not just specifying them.

Test management

Leading QA for software delivery, from test strategy through release sign‑off.

Product management

Owning a roadmap from idea through release, working directly with development teams.

Industries

Sectors the chain has run through

Mostly large manufacturers with plants in more than one country — if it’s made somewhere and needs to end up somewhere else, the planning problem is familiar.

Oil & gas
Optimizing railcar allocation and scheduling for the transportation of crude and refined products.
Pharmaceutical
Planning and testing support for regulated, multi‑site production networks.
Chemicals
Polyolefins and polypropylene, resins, and specialty polymers — production and distribution planning.
Glass
Automotive and display glass manufacturers, planning across multiple plants.
Food & beverage
Dairy, berries, dried fruit and brewing — short shelf life, high planning stakes.
Packaging
Production and inventory planning for packaging manufacturers.
Cosmetics
Multi‑site production and finished‑goods planning.
Experience

Representative engagements

A few examples of the kind of work I do — not a client list, since most of what I do runs quietly in the background of someone else’s operation.

Ongoing

Universal ERP data integration hub

Building a bidirectional integration layer that connects ERPs — including SAP — as sources, and any database, warehouse, data lake or lakehouse as a destination. Includes a tool that pulls data from any database and pushes it into SAP over RFCs or standard BAPIs, plus a reusable dbt core standard for major ERP systems, extended with client‑specific customizations.

Completed

Tank inventory management

Helped a manufacturer manage storage and inventory across a network of tanks.

Rail logistics

Crude & refined oil transport

Optimized the use of railcars for moving crude and refined oil products between sites.

Multi‑plant planning

Chemicals & polymers

Helped chemical manufacturers plan production and distribution for polyolefins, polypropylene, resins and specialty polymers across several plants.

Beyond supply chain

Business analysis & QA elsewhere

Applied the same approach to hotel software, audio‑visual rental systems, and healthcare staff‑planning platforms.

Insights

Notes from the field

I’m building out a small library of notes on supply chain planning and software delivery. Nothing published yet — here’s what’s coming.

Coming soon

Forecasting demand across multiple plants

Coming soon

What a good business requirement actually looks like

Coming soon

Why an AI agent is only as good as your data pipeline

Have a topic you’d like covered? Get in touch.

Contact

Let’s talk about your chain.

Most engagements start with a short conversation about where the planning is breaking down. No sales deck required.

Based in
Località Mazzarelli 2, 06060 Paciano (PG), Italy

Opens your email client, addressed to phderop@catena-tec.it — nothing is sent from this page directly.