rn_RENÉ NYFFENEGGER
DATA PLUMBING / DATABASES
Call

CLARITY IN COMPLEX SYSTEMS

Your data
problem is stuck.
Let’s find out why.

When important data cannot move, cannot be trusted,
or cannot be explained, I investigate what broke.

DATA SOURCES / INGESTION / INTEGRATION / REPORTING

Urgent work by agreement and availability.

SCROLL TO INVESTIGATE LESS GUESSWORK. MORE UNDERSTANDING.

01 / THE PROBLEM

When data needs
attention now.

A business problem rarely arrives
with a useful error message.

[ 01 ]

The numbers disagree.
Nobody knows why.

Reports and dashboards produce conflicting answers that decision-makers can no longer trust.

[ 02 ]

The pipeline is slow.
The business is waiting.

Data sources, ETL processes, or database operations have become a bottleneck.

[ 03 ]

The system works.
Only nobody understands it.

Critical logic is hidden in legacy processes, undocumented interfaces, or fragile automation.

You may not need another platform. You may need to understand the one you already have.

02 / DATA PLUMBING

Make the flow
dependable.

Connecting the systems, sources,
and processes your data travels through.

I work across the boundaries where data becomes difficult: between systems, between teams, and between what a process is supposed to do and what it actually does.

01

Connect sources

Bring heterogeneous data sources together and make their relationships understandable.

02

Strengthen pipelines

Build robust ingestion and integration paths that can be observed, tested, and maintained.

03

Automate the work

Recover and improve ETL, reporting, and repetitive data processes.

04

Improve the path

Diagnose database behavior, data quality, and transfer paths that limit throughput.

SQL, databases, ETL, migration, automation, and performance are tools within the larger problem of making data flow reliably.

03 / HOW I WORK

Understanding first.
Then intervention.

My engineering approach emphasizes automation and reproducible outcomes.

Evidence over assumptions.
Every time.

I build robust, observable implementations with appropriate logging and monitoring, optimize data-transfer paths for throughput, and reduce dependencies and complexity where practical. By developing implementation, test scenarios, and representative test data in parallel, I create repeatable evidence of correctness and make defects faster to reproduce, isolate, and fix.

  1. 01Observe the actual system.
  2. 02Reproduce the failure.
  3. 03Separate evidence from assumptions.
  4. 04Identify and explain the cause.
  5. 05Make the smallest dependable change.
  6. 06Verify with suitable tests and data.

04 / ABOUT RENÉ

A data plumber.
An escalation engineer.
Someone who asks why.

Senior data warehouse and database engineer
with more than 20 years of experience.

I connect heterogeneous data sources and continuously improve their ingestion and integration pipelines.

My experience includes SQL Server, T-SQL, Oracle, PowerShell, ETL, data migration, automation, and data-quality engineering.

I have been programming since eighth grade. I like simple systems, few dependencies, reproducible results, and explanations that survive scrutiny.

PUBLIC WORK

My technical notes and GitHub repositories show how I investigate, experiment, and explain. They are linked in the footer.

> Vim for 25+ years. Still curious.

05 / WORKING TOGETHER

Start with
a diagnosis.

First, understand what’s wrong.
Then decide what’s worth changing.

PAID DIAGNOSIS FROM

CHF 2'000

  • Scope and price agreed before work starts.
  • Remediation quoted separately.
  • Fixed prices preferred, based on the problem and outcome.

A project that sparks my curiosity may qualify for a reduced fixed fee. Tell me what you have in mind.

06 / YOUR NEXT MOVE

Tell me where
it’s stuck.

+41 76 558 70 68

Bring the symptoms, business impact, urgency,
affected systems, and what you’ve already tried.

Prefer email? mail@renenyffenegger.ch ↗

Urgent work prioritized by agreement and availability.