m Psoft Trade Finance tfin
Key Points
- payments
- letters of credit
- loans
- reconciliations
- remittances
- analytics
- logistics and reverse logistics ( RMAs )
- energy trading
- service work
- parts tracking
- trade finance metrics: operations, financial, ESG
References
Reference_description_with_linked_URLs_______________________ | Notes______________________________________________________________ |
---|---|
F2F F2P Product document folder document folder | |
Deck for InComm - Sep 23 v2 .pptx | |
https://www.finastra.com/solutions/transaction-banking/trade- supply-chain-finance | Finastra trade finance software supports SWIFT |
payments and tokens service product concepts | |
s Blockchain Opportunity Assessment - BOA | good models on architecture process, project deliverables ** |
BVA modeling steps for journey roadmaps | |
Invoice Financing Overview | |
Invoice Financing - Investopedia | |
Beginners Guide To Export Shipping Forms ** | |
Coriolis Technologies on trade finance data, ESG | |
https://www.baft.org/ | International banking org |
DLPC - DL Payment Commitment- digital check that is negotiable | |
https://www.programmableweb.com/api/new-york-federal- reserve-foreign-exchange-rest-api | REST api for forex rate query |
Trade Finance Task List
task___________________________________________________________________________ | action___________________________ | status_______________ |
---|---|---|
get bluenumber project access: JIRA, Confluence, Github, Postman, DB | ||
get TNT project access: JIRA, Confluence, Github, Postman, DB | ||
define process, inputs, prereqs for invoicing | ||
define payment services for invoicing | ||
review onboarding model for growers, processors, shippers | ||
check use of Indy IDs, wallets for Fabric MSP services | ||
define any known integration requirements | ||
create product roadmap | ||
review IAM foundation | ||
review DB foundation | ||
review BC foundation - mediator layer? logical transaction? privacy? anchors? | ||
roles in supply chain network
| ||
do simple design model from scratchmodel lot support, implement basics to start | ||
define build strategy for TFIN basic model
| modeling tools object definitions: KD, KM, KE object life cycle events object processes object services consumed object services produced sourcing object frameworks generator tools | |
solution design goals
| ||
map basic design to current TNT system find gaps between basic model and TNT - functional, non-functional | ||
TNT features of value - dynamic onboarding, dynamic product definitions | ||
decide on validity of build plan | ||
decide on validity of using TNT | ||
Key Product Solution Questions
- What are the schain stages?
- what are the challenges, opportunities for each stage and role in the schain?
- who can pay for the solution in the schain? ( NOT the growers )
- what's the F2P story we share? ( challenges & opportunities, F2P FBRs, case studies )
TFIN Solution Requirements Doc
https://docs.google.com/document/d/1_q2IKlFsB42kNb1x5ksqma6n0t-1BUnausoN9d9n0Zk/edit#
Application Feature Dependency Map
Application Feature Impacts
Platform Capability__________________________________________ | Value_____________________________________________________________________ | |
---|---|---|
Identity Management | Trusted Profiles for people, organizations, devices | |
Ownership & Consent Management | Every account can manage data and consent | |
Application Management | Allows flexibility in licensing models given dependencies | |
Compliance & Governance | Transparent, automated compliance & governance support | |
Secure Data Sharing | Data shared securely based on authorizations | |
Analytics & AI | Smart efficient decisions and optimizations | |
Blockchain | Trusted Data Provenance | |
Smart Data | defined services and views for client apps | |
Product Delivery Concepts
_Item__________________ | notes______ |
---|---|
a>> well defined work packages for a product w good research tasks ** | |
Which services do we integrate with vs build? | 3 B sourcing model |
define the foundation for the platform | |
shop for sources including F2P TNT | |
model the system including the foundation and test | |
Key Concepts
Business Strategy Plan Model
Here are six simple steps to help you deliver an effective business strategy:
1. Gather the facts
To know where you’re heading, you have to know where you are right now. So before you start looking ahead, you should review the past performance, or the current situation. Look at each area of the business and determine what worked well, what could have been better and what opportunities lie ahead.
There are many tools and techniques available to help with this process, such as SWOT (Strength, Weakness, Opportunities and Threats) analysis.
You should look internally at your strengths and weaknesses. And for the opportunities and threats you should look at external factors. A great framework for looking at external factors is PESTLE (Political, Economic, Social, Technological, Legal and Environmental). So, for your big idea or plan you would ask: what threats and opportunities could arise under each category?
The most important part of this process is involving the right people to make sure you’re collecting the most relevant information.
2. Develop a vision statement
This statement should describe the future direction of the business and its aims in the medium to long term. It’s about describing the organisation’s purpose and values. Business gurus have debated long and hard about what comes first – the vision, or the mission statement (see step 3). But, in practice, you could develop both at the same time.
3. Develop a mission statement
Like the vision statement, this defines the organisation’s purpose, but it also outlines its primary objectives. This focuses on what needs done in the short term to realise the long term vision. So, for the vision statement, you may want to answer the question: “Where do we want to be in 5 years?”. For the mission statement, you’ll want to ask the questions:
- What do we do?
- How do we do it?
- Whom do we do it for?
- What value do we bring?
4. Identify strategic objectives
At this stage, the aim is to develop a set of high-level objectives for all areas of the business. They need to highlight the priorities and inform the plans that will ensure delivery of the company’s vision and mission.
By taking a look back at your review in step one, in particular the SWOT and PESTLE analysis, you can incorporate any identified strengths and weaknesses into your objectives.
Crucially, your objectives must be SMART (Specific, Measurable, Achievable, Realistic and Time-related). Your objectives must also include factors such as KPI’s, resource allocation and budget requirements.
5. Tactical Plans
Now is the time to put some meat on the bones of your strategy by translating the strategic objectives into more detailed short-term plans. These plans will contain actions for departments and functions in your organisation. You may even want to include suppliers.
You’re now focusing on measurable results and communicating to stakeholders what they need to do and when. You can even think of these tactical plans as short sprints to execute the strategy in practice.
6. Performance Management
All the planning and hard work may have been done, but it’s vital to continually review all objectives and action plans to make sure you’re still on track to achieve that overall goal. Managing and monitoring a whole strategy is a complex task, which is why many directors, managers and business leaders are looking to alternative methods of handling strategies. Creating, managing and reviewing a strategy requires you to capture the relevant information, break down large chunks of information, plan, prioritise, capture the relevant information and have a clear strategic vision.
Business Strategy in 6 steps deck
https://slidesgo.com/theme/strategy-in-6-steps
Digital Marketing Plan Strategy
https://terakeet.com/blog/digital-marketing-plan/
What are the steps to create a digital marketing plan
1. Set goals
2. Define your audience
3. Conduct a competitive analysis
4. Conduct a SWOT analysis
5. Determine your budget
6. Identify your channels
7. Develop specific tactics
8. Create a calendar
9. Measure results
- What is a digital marketing plan?
- How to create a digital marketing plan
- 1. Define your digital marketing goals and business objectives
- 2. Define audience segmentation and buyer personas
- 3. Conduct a competitive analysis and determine market share
- 4. Conduct a SWOT analysis
- 5. Calculate your digital marketing plan budget
- 6. Define your digital channels
- 7. Develop your digital marketing strategies and tactics
- 8. Create a marketing calendar
- 9. Measure the results and KPIs of your digital marketing plan
- Great digital marketing plans encourage integration
F2P Solution Concepts
Food Supply Chain Stakeholders Map
F2P Modules
IAMS - Identity, Access and Memberships Services
Use standard IAM solution ( open-source ideally )
Thomas Bereczky to Everyone (11:43 AM)
- Implement SSO and a Keycloak server as the OpenID access control server - https://www.keycloak.org/
- Separate the account and identity management module
- Write everything off-chain and use Hyperledger only as a backup to write data
- The Mongo Data model has to be redefined
SCMS - Supply Chain Management Services
FMS - Financial Management Services ( candidate features )
COO - Certificate of Origin
BOE - Bill of Entry
BOL - Bill of Lading
Import documents
Export documents
RMA
Remittances
Remittance reconciliation: contract, order, receipt,
Invoicing
Invoice reconciliation: PO, BOL, packing list, vendor invoice, receipts, COO, BOE, inspections
Invoice payments
Direct payments on delivery
Contract payments
Invoice Loans - Factoring receivables
Crop Loans - highly risky
Payments - via payment services
Receivables
Purchasing
General Ledger
Resource Management ( Fixed Assets, Employees, Contractors, Providers )
Payroll
External integrations with SOR ( Systems of Record )
Analytics
Events
Dependencies
Subscriptions
Actions ( when )
Processes
Alerts
Sample Forms in Trade Finance
Introduction
- Proforma Invoice 6
- Commercial Invoice 8
- Certificate of Origin 10
- Packing List 24
- Shipper's Letter of Instruction 26
- Automated Export System 29
- Inland Bill of Lading 31
- Dock Receipt 33
- Ocean BIll of Lading 35
- Air Waybill 37
- Dangerous Goods IATA 38
- Non-Dangerous Goods 42
- Bank Draft 43
FMS dependencies ( define required, optional modules )
XAC - Cross Application Control
AMS - Account Management Services
- identity
- account relations: client, vendor, employee
- roles
- authorizations
- integrations to external IAMS
- contracts
- documents
- AML, KYC support
VMS - Vendor Management Services ???
- identity
- account relations: client, vendor, employee
- roles
- authorizations
- integrations to external IAMS
- contracts
Purchasing
Inventory
Quality
Shipment
Payments
General Ledger
Trade Data Interchange Standards
https://en.wikipedia.org/wiki/Electronic_data_interchange
Some major sets of EDI standards:[5]
- The UN-recommended UN/EDIFACT is the only international standard and is predominant outside of North America.
- The US standard ANSI ASC X12 (X12) is predominant in North America.
- GS1 EDI set of standards developed the GS1 predominant in global supply chain
- The TRADACOMS standard developed by the ANA (Article Number Association now known as GS1 UK) is predominant in the UK retail industry.
- The ODETTE standard used within the European automotive industry
- The VDA standard used within the European automotive industry mainly in Germany
- HL7, a semantic interoperability standard used for healthcare data.
- HIPAA, The Health Insurance Portability and Accountability ACT (HIPAA), requires millions of healthcare entities who electronically transmit data to use EDI in a standard HIPAA format.
- IATA Cargo-IMP, IATA Cargo-IMP stands for International Air Transport Association Cargo Interchange Message Procedures. It's an EDI standard based on EDIFACT created to automate and standardize data exchange between airlines and other parties.
- NCPDP Script, SCRIPT is a standard developed and maintained by the National Council for Prescription Drug Programs (NCPDP). The standard defines documents for electronic transmission of medical prescriptions in the United States.
- The NCPDP Telecommunications standard includes transactions for eligibility verification, claim and service billing, predetermination of benefits, prior authorization, and information reporting, and is used primarily in the United States.
- Edig@s (EDIGAS) is a standard dealing with commerce, transport (via pipeline or container) and storage of gas.
Many of these standards first appeared in the early to mid-1980s. The standards prescribe the formats, character sets, and data elements used in the exchange of business documents and forms. The complete X12 Document List includes all major business documents, including purchase orders and invoices.
FMS use of templates
transaction ledger formats
ledgers
archives
document services
digital IDs
digital wallets
digital credentials
tokens
F2P Modules
food supply chain logistics improvement
food safety
ethical sourcing
fresher food
F2P Incomm presentation deck
Deck for InComm - Sep 23 v2 .pptx
see the ps deck model ...
https://en.wikipedia.org/wiki/GS1
context - existing solution
use cases for scope
quality - efficiency
security - safety
consent mgt
transparency
trust - immutability - traceability
integrations
problem stmts
current system focus ( add roadmap )
from user journeys ( cpa, dmv, dbr, firms )
user full credential exposure for proof requests
user id, pwd risks, issues
state reduced fraud, disputes
new system
impacts for use cases
food recall reduction w data quality, automation, immutability,
transparency
strategy
add did, credentials for ssi, pii
impacts
security
data protection
data privacy
easy secure access
consent mgt
reduced fraud, impersonation
any specific kpis / metrics to measure impacts?
any other related references on benefits ?
how decentralized a network is this?
next to last slide ( F2P ) shows
safety benefit ( food recall )
no other slides show the sourcing or produce quality benefits
revenue slide could benefit from added text to clarify the model
recommendations
strategies
implementations
decisions
next steps
appendices
related stds - ssi, did, toip, pki, ...
swt id bc pptx
Potential Value Opportunities
Alaskan Pollock Industry
It's not just a trade finance use case example for a mature, domestic, small business network for F2P
They have a fully matured business process model ( no redesign challenges ) with clear roles
Legislatively defined rules for sustainability
Their network probably score 95 out of a possible 100 on sustainability scores now - a great network to highlight for FP2 in promotion
https://www.alaskapollock.org/
CEO Craig Morris
https://www.linkedin.com/in/craig-morris-0031592a/
https://www.alaskapollock.org/media/2049/2021-2022-gapp-strategic-plan.pdf
Mexican Avocado Industry
Regulated
Simple international use case for trade finance
Food Supply Chain
Distribution models ??
free 30 day trials hosted
limited function, capacity open-source version
enterprise version
Potential Differentiators ??
pluggable interfaces for: identities, RBAC, data models, logic scripts, workflows, events
industry specific
pre-built integrations - EDI etc
partners on sub-systems - eg payments, inventory
Research list
Normal ERP logistics apps in cloud
Please review the shared links and let me know your thoughts.
Other Trade Finance solutions and use cases
https://www.finastra.com/solutions/transaction-banking/trade-supply-chain-finance
Bills of Lading
Tokenizing Bills of Lading - https://www.youtube.com/watch?v=JN69tm9bq7c
Coriolis Technologies - trade finance data and ESG metrics
https://coriolistechnologies.com/
Our Atlas product is now in the market and provides SMEs with a tool for learning about international trade compliance and accessing trade finance. We are soft-launching it for testing purposes at the moment but will shortly be in touch to let you know how to access it from our website. The good news is that we have signed an agreement with Finastra to deliver Atlas as a Service into their SME trade finance platform.
We’ve also been building our Kosmos consortium over the last month. The consortium will bring the trade finance sector together around some agreed standards for measuring and assessing sustainability.
Our product-based, real-time approach allows companies to know their goods and the goods of the suppliers and buyers in their supply chains. To find out more about becoming part of our industry-led consortium, do let us know. We will be running another ESG working lunch in mid-September, this time with ITFA. It would be great to get everyone back together then.
One other reason for August being so busy: we have been awarded three contracts, with the ICC UK, the Commonwealth and the United Nations Development Programme to develop the business case for regulatory reform to support paperless trade and trade facilitation programmes in Europe, the US, China, across the whole Commonwealth and the African Free Trade Area. The research is launching globally at various events, including the ICC’s annual conference, the Commonwealth Heads of Government conference and the UN Annual Meeting in September and October later this year.
Primacy - Trade gaming for the 21st Century
Atlas - lending platform
Coriolis Atlas is a one-stop shop for SME exporters seeking access to trade finance. Through our innovative suite of business planning tools, invoices, contracts, and related documents are screened and assessed in real-time using proprietary state-of-the-art machine learning and artificial intelligence techniques to assess business risk and compliance across six Atlas dimensions. SMEs can then use Coriolis Atlas to apply for trade finance directly with their preferred provider through our streamlined, integrated onboarding workflow.
Kosmos - ESG monitoring index
Monitoring the Environmental, Social, and Governance health of the world's companies, supply chains, and nations
Coriolis Kosmos is the go-to source of data and analytics for environmental, social and corporate governance. Kosmos provides key information and insights into sustainable trade flows across the globe.
Potential Challenges
Legal Terms and Documents
I have shared the legal artifacts on Blockchain and would appreciate your views.This will help our attorney draft the contents precisely matching our expectations.
My Onboarding support concepts
good customer service
easy, effective, low-cost Paramount support options
No-charge Account planning meetings to define
goals, expected usage, gather requirements, plan any custom services, standard onboarding, training, connections, support and more
use youtube videos, docs as an option here
use knowledge base with youtube video links as first stop for help normally
provide direct email, live chat and phone support options for registered account contacts
use custom Zoom support meetings as needed to resolve issues
use online Grails app to record and manage work requests ( problems, questions, feature requests )
use online BIRT or equivalent Web report tool to show system usage and manage work request status
customer portal provides account information and billing status
Customer responsibilities for implementation and support
Customer Resources committed to meet planned onboarding and support requirements
Customer designates specific support contacts who go through on-boarding training courses
Customer is responsible for integrations to existing systems unless Paramount hired on a custom SOW under an MDA to provide services integrations
Customer documents planned usage of services using JEPL ( Java Event Processing Language ) to define a planned usage model for workflows, event notifications, automation
Paramount provides support on usage documentation with JEPL via knowledge base and support staff
Customer provides a test environment to test and validate planned usage and identity support problems separate from Production systems
Customer uses Paramount online support templates to record any support incidents ( problems, questions, feature requests ) and submit to Paramount online ( see work request template as a Grails app )
Candidate Solutions
Services
Fed Forex Rates api
https://www.programmableweb.com/api/new-york-federal-reserve-foreign-exchange-rest-api
exchange rates. The list of data available covers many of the world's currencies, with both spot and buying prices quoted at different times of day. The authoritative provider makes the data available for ingestion to automated processes that must compare currencies to calculate prices for cross-border transactions, in addition to historical research uses. API methods support retrieval of regularly updated data formatted in compliance with the emerging Statistical Data and Metadata Exchange (SDMX) standard. URL-based access delivers data for specific currencies, with both 10 a.m. and noon quotes available for many frequently traded currencies
.http://www.newyorkfed.org/xml/data/fx/
Fed Forex Rates download page
Other Exchange Rate sources
exchangeratesapi.io
offers a low volume free subscription
uses EUR as the base currency for the rates
https://manage.exchangeratesapi.io/dashboard
user jm9y
swtyn#
11
akey
85c4ed3c8143a204e43d03c7ae5d8384
avalue
https://manage.exchangeratesapi.io/quickstart
Simply attach your unique Access Key to one of the endpoints as a query parameter:
{ "success":true, "timestamp":1632014357, "base":"EUR", "date":"2021-09-19", "rates":{ "USD":1.17259, "AUD":1.613804, "CAD":1.497285, "PLN":4.591908, "MXN":23.477015 } }
JS example code to pull exchange rates
// set endpoint and your access key endpoint = 'latest' access_key = 'API_KEY'; // get the most recent exchange rates via the "latest" endpoint: $.ajax({ url: 'https://api.exchangeratesapi.io/v1/' + endpoint + '?access_key=' + access_key, dataType: 'jsonp', success: function(json) { // exchange rata data is stored in json.rates alert(json.rates.GBP); // base currency is stored in json.base alert(json.base); // timestamp can be accessed in json.timestamp alert(json.timestamp); } });
https://exchangeratesapi.io/documentation/
Convert the API JSON or CSV to a forex table
- Get the currency codes from a currency code api by country
- Create the workbook currencyCodesByRegion gsheet
- Select the currencyCodes list as an input string to create a parm list for forex api
- Run a groovy script ( ) from file: groovy-ex1.groovy to create a currencyCode parm list for the exchangerateapi query
- Get the forex table for the currency codes as JSON or CSV and load as a new sheet in the gsheet
- Use a vlookup on the gsheet countryForex sheet to set the exchangeRateUSD and exchangeRateEUR values for each country returned
- export the countryForex as a csv file
- Create a table m_currencycodesforex in a database ( MySQL, Mongo, Postgres etc )
- Import the countryForex.csv file to the table
Other Financial APIs
Vezgo | One API. Every cryptocurrency integration. An API for connecting any cryptocurrency account - both exchanges and wallets. Allows apps to easily collect balances, holdings/coins and transaction... |
Finnworlds Analyst Ratings | Analyst Ratings API includes current and historical buy, hold, sell ratings of analysts. As well as details about the analyst such as the firm, the success rate and return rate. It can also be used... |
Unofficial Webull | Query public data for investment products including stocks, fractional shares, options, ETFs, and ADRs as on webull.com | Financial |
F2P solution
MVP Plan
https://drive.google.com/file/d/1fmNi3Nptr335LZyp-40l8sM7kntZLzFh/view?usp=sharing
OKR - Objectives Key Results
Problem Statements
https://paramountsoft.atlassian.net/wiki/spaces/FAR/pages/264077353/Problem+Statements
Meetings
Restructure F2P product plan - 210504
Remaining sub topics within each module will be considered later as and when the scope arises.
Step-by-step guide for Example
sample code block