Trade Capture Platform
TCP is a platform that enables Shell to import external trades, analyse them, and ensure they are matched to the appropriate trade data in Shell's internal trade logbook.
This process utilises key-value pair mappings stored in a database accessible to TCP platform developers. Currently, key personals lack direct access to view/amend what is mapped in production and heavily relies on outdated spreadsheet documentation.
This hampers efficiency and diverts resources from essential projects. A solution was urgently needed to boost mapping visibility, reduce reliance on external teams, and drive business growth and efficiency.
Impact
Streamlined Failure Analysis: With more efficient failure analysis the TCP support teams can quickly identify and address issues, reducing time to fix issues by 75%.
Reduced Time sink for developers: Developers went from spending 4 hours a week writing complex scripts to a fully automated process - This translated to about a 95% decrease in time spent writing complex SQL scripts. Developers could now focus on pivotal business initiatives at Shell.
Improved Traders' Visibility: With instant access to live mapping data, traders can promptly obtain crucial information, empowering them to make well-informed decisions quickly and efficiently.
Company
Shell
My Role
Lead Product Designer
Researcher
Visual Designer
Prototype
Duration
4 Months
Platform
Responsive Web
Users can view all exchanges as well as status
Users can view & amend all mappings within an exchange
Discovery
Discovery through research is at the core of any design-driven problem-solving process; only by deeply understanding the problem can solutions be gleaned.
My primary objective was to delve into understanding both the business and user needs/problems, while identifying areas of opportunity for improvement within the current user journeys.
I conducted a series of problem statement workshops, internal stakeholder interviews, and user interviews. I synthesised my findings into an As-is customer journey map. This was helpful in presenting my research findings to key stakeholders and led to a shared vision on how to approach solving our core user needs.
Problem Statement Workshops
Involving stakeholders in our discovery journey is essential as it fosters empathy towards our end users, this ultimately leads to well-thought-out solutions.
I employed the WHO, WHAT, WHEN/WHERE, and WHY framework to ensure clarity around the core problems.
Customer Interviews
A key outcome of the problem statement workshop was identifying our key users as perceived by the business.
Using this as a basis, I contacted and set up one-on-one interviews with eight participants who fit these persona profiles, gaining insights into their preferences, journey frustrations, behaviour patterns, and expectations.
Internal Stakeholder interviews
I conducted stakeholder Interviews to grasp the business impact and technology stack constraints.
Aligning business objectives against user objectives is crucial during this stage to ensure we are prioritising the right problems from the user's and business perspective.
Customer Journey Mapping
Research Insights
At Shell, the Trading desk and Operations teams face delays in updating trading data due to the absence of real-time access to production data mapping.
This challenge affects efficiency and competitiveness, particularly during scenarios such as new market introductions, data changes, trade flow failures, and new trader onboarding.
Lack of access to live Mapping data
Mappings are documented in Wiki and Spreadsheets, which are not maintained.
Inefficient failure analysis
Failure analysis and troubleshooting takes more effort and time as it involves validation of multiple tables and understanding the relationships between them can be complex.
Outdated change management processes
Support teams aren’t able to view configured TCP mappings quickly, this causes delays in implementing changes due to Change management process in production.
Reliance on external teams
Support teams have to manually run SQL scripts in order to make changes. They have to rely on TCP developers to create scripts and run it this takes days to make simple changes.
Delayed change Implementations
Support team is extremely dependant on TCP developers to create scripts. This creates delays in the process of completing Service now tickets.
Having to wait a number of days to implement changes when they can be done in minutes.
Time Sink
Creating mappings takes time away from More business focused tasks for TCP developers.
The problem statement workshop outcome was key in aligning with the business around the exact problem we are trying to solve.
![](https://framerusercontent.com/images/K6cUNifhQFa6qEX3kqNwfqMkiY.jpg?scale-down-to=512)
TCP Support team
The TCP Support teams need to manually run complex database scripts to check and change trade data mappings (Especially when new traders, products, or markets come in) as well as monitor transactions and run failure analysis.
Aside from running scripts, the slow process is delayed further due to having to go through a change management process.
This slow process makes it hard to fix problems quickly and adapt to trade changes. It causes delays and messes up the smooth flow of trades in the company.
This inefficiency not only affects support teams but also hurts the business. We can use the support team's time and skills for more business related tasks.
![](https://framerusercontent.com/images/RamtTAckY2oBVdwHXcKMoDwUlro.jpg?scale-down-to=512)
Internal Product teams
The TCP application support Team lacks real-time access to production mapping, heavily relying on outdated documentation.
This hampers efficiency and diverts resources from essential projects. A solution is urgently needed to boost mapping visibility, reduce reliance on external teams, and drive business growth and efficiency.
![](https://framerusercontent.com/images/6sHpq3dI8RZD4vLq93yNIsQrkiw.jpg?scale-down-to=512)
Business Users - Traders
At Shell, the Trading desk and Operations teams face delays in updating trading data due to the absence of real-time access to production data mapping.
This challenge affects efficiency and competitiveness, particularly during scenarios such as new market introductions, data changes, trade flow failures, and new trader onboarding.
Our solution aims to expedite access and reduce external team dependence.