01 · EXECUTIVE SUMMARY
A trade can't happen until a lot of quiet work is finished first

At RWE Supply & Trading, no counterparty can trade energy or commodity products until they clear legal, credit, compliance, and operational checks — a process that runs through Jira for workflow and approvals, and Endur (RWE's ETRM platform) for master data and trading configuration. I owned this onboarding process end to end: validating incoming requests, chasing down approvals across Legal, Credit, and Compliance, maintaining counterparty records in Endur, and troubleshooting trade bookings that failed after "onboarding" looked complete.

Handling 15+ counterparty onboardings a month across four legal entities (Germany, UK, US, Singapore), the recurring pattern wasn't one big failure point — it was several small, specific gaps (a missing Business Unit, an agreement that didn't cover the traded instrument, a credit workflow that failed silently) that each blocked trading in a different way. The work was as much about diagnosing which gap it was as it was about processing the request itself.

02 · BUSINESS CONTEXT
Why onboarding exists as a gate, not a formality

RWE Supply & Trading trades with a wide range of external counterparties, and every one of them has to be fully configured — contractually and operationally — before a trader can book a deal with them. The onboarding workflow starts with a Jira request containing counterparty information, moves through Legal, Credit, and Compliance approval stages, and finishes with the approved data being maintained in Endur. Only once every mandatory prerequisite is in place does a counterparty become "Ready to Trade."

The objective isn't just paperwork — it directly protects the business: preventing failed trade bookings, keeping counterparty master data accurate, and reducing operational risk across four legal entities operating under different regulatory regimes.

03 · STAKEHOLDERS
Eight groups, one shared deadline
  • Front Office / Traders — need the counterparty Ready to Trade before a deal can be booked, and are the first to notice if it isn't.
  • Legal — provides ISDA / EFET agreements, agreement terms, and collateral requirements.
  • Credit — approves credit limits and monitors automated credit workflows.
  • Compliance — clears counterparties from a regulatory standpoint.
  • Portfolio Team & Trading Operations — depend on correct portfolio and Business Unit configuration.
  • Business Engineering & Internal Support Functions — maintain the systems (Jira, Endur) the whole process runs on.
04 · BUSINESS PROCESS
Jira request → three approvals → Endur → Ready to Trade

A Jira request captures counterparty information, requested agreements, and portfolio selection. It progresses through Legal, Credit, and Compliance approval stages — each adding its own piece: agreement terms and collateral requirements from Legal, an approved credit limit from Credit, regulatory clearance from Compliance. Once every prerequisite is satisfied, the approved data is maintained in Endur: counterparty records, agreements, instrument permissions, portfolio configuration, and Business Units. Only then is the counterparty available for trading.

05 · BUSINESS QUESTIONS
What I was actually being asked to answer
  • Is this a genuinely new onboarding, or an additional approval request for an existing counterparty?
  • Which mandatory approvals — Legal, Credit, Compliance — are still outstanding, and where is the request stuck?
  • When a trader can't book a deal, which specific prerequisite is missing — agreement, instrument eligibility, portfolio, Business Unit, or credit limit?
  • Where are onboarding requests losing time, and which teams need to be chased?
06 · DATA UNDERSTANDING
Four data sources, one master record
SourceWhat it holds
JiraCounterparty info, approval workflow, portfolio selection, requested agreements, operational status
Credit TeamApproved credit limits, credit approval status
LegalISDA / EFET agreements, agreement terms, collateral requirements
EndurCounterparty master data, agreements, instrument permissions, portfolio config, Business Units, credit info

Endur is the system of record — everything approved elsewhere ultimately has to be reflected there correctly, or trade validation fails downstream regardless of what Jira says.

07 · ANALYSIS
What the work actually looked like week to week
  • Counterparty validation — reviewing incoming Jira requests, checking whether the counterparty already existed in Endur, and distinguishing new onboardings from additional approval requests.
  • Approval validation — confirming Legal, Credit, and Compliance had all signed off before onboarding progressed.
  • Credit validation — verifying approved limits and manually validating entries when the automated credit workflow failed.
  • Endur master data maintenance — keeping counterparty records, agreements, portfolio assignments, and trading permissions accurate and current.
  • Stakeholder coordination — following up on delayed approvals across Legal, Credit, and Compliance, and resolving onboarding bottlenecks directly.
08 · KEY FINDINGS
Trading readiness fails in specific, repeatable ways
FINDING 1

Agreements and instruments don't automatically match. A valid ISDA or EFET agreement had to exist and explicitly cover the instrument being traded — an agreement permitting Power Futures wouldn't necessarily cover Coal Swaps. Because agreements were configured manually to reflect each counterparty's unique terms, this mismatch was a recurring, specific failure mode rather than a rare edge case.

FINDING 2

Business Unit configuration was an easy-to-miss dependency. Each portfolio contains multiple Business Units — the internal entities authorized to trade — and if the required BUs weren't associated with the agreement or portfolio setup, trade validation failed even when everything else looked complete.

FINDING 3

Automated credit workflows sometimes failed silently. When they did, there was no fallback except manual validation — meaning credit approval status in the system couldn't always be trusted without a manual check.

09 · ROOT CAUSE ANALYSIS
A structured diagnostic sequence for "the trade won't book"

When a trader reported a failed booking, the fastest path to a fix was a fixed diagnostic order rather than checking everything at once:

  • Verify the legal entity and counterparty
  • Confirm agreement availability, then validate its configuration
  • Confirm instrument eligibility under that agreement
  • Verify collateralization settings, where applicable
  • Validate portfolio assignment and Business Unit configuration
  • Verify approved credit limits
  • Only then, investigate deeper Endur configuration issues

This ordering matters: agreement and instrument mismatches were the most common root cause, so checking them first resolved most cases quickly, rather than starting with the rarer, harder-to-diagnose Endur configuration issues.

10 · RECOMMENDATIONS
Reduce the surface area for the failure, not just react to it
  • Reduce redundant counterparty setups. As part of the CALM (Counterparty Agreement Lifecycle Management) initiative, evaluated agreement structures to cut down on duplicate configurations that increased the chance of a mismatch.
  • Standardize the diagnostic workflow. The structured troubleshooting sequence in Section 9 turned "the trade won't book" from an open-ended investigation into a repeatable checklist.
  • Support process automation via RPA and optimize Jira workflows to reduce the recurring errors that were consuming the most manual re-work.
  • Give teams earlier visibility into stalled approvals — this is the direct link to the KPI dashboard work covered in the KPI & Dashboard Design case study.
11 · BUSINESS CASE
What accurate, fast onboarding is worth

The business case here is risk avoidance and velocity rather than a single cost figure: every onboarding processed correctly is a counterparty that can trade without a failed booking, a compliance exposure, or a delay traced back to master data. At 15+ onboardings a month across four legal entities, even a small reduction in rework — one fewer misconfigured agreement, one fewer manual credit check — compounds quickly across a year of onboarding volume.

15+
COUNTERPARTIES ONBOARDED / MONTH
4
LEGAL ENTITIES (DE · UK · US · SG)
8+
DISTINCT FAILURE MODES DIAGNOSED & DOCUMENTED
12 · DASHBOARD
Where this connects to reporting

The onboarding process itself doesn't have a single dashboard — visibility into it comes from two places: Power BI and Jira dashboards flagging teams that hadn't nominated an approver within 24 hours (closing bottlenecks before they escalated), and the broader KPI dashboard suite covered in the KPI & Dashboard Design case study, which tracks nomination turnaround, workload distribution, and requests stuck in a given approval stage.

13 · LESSONS LEARNED
What years of onboarding tickets taught me
  • Most "the trade won't book" issues aren't mysterious — they cluster into a small set of known failure modes. Documenting them turns tribal knowledge into a repeatable process.
  • The system of record isn't always the first place someone looks. Jira could show every approval as complete while Endur configuration was still wrong — trusting only the front-end status was a common (and avoidable) mistake.
  • Prevention beats troubleshooting. Every recurring failure mode fixed at the process level (CALM, RPA, Jira workflow changes) was one less ticket to diagnose manually later.