Ep. 216: Robert Cooke - Streamlining Data Management: An Inside Look at Fintech Solutions

< Intro >

– Welcome to Count Me In, the podcast
where we examine all things

affecting the accounting
and finance world.

I'm Adam Larson,
and I'm excited to introduce

our speaker today, Robert Cooke.

Robert is the founder
and principal architect at 3Forge,

a New York-based provider
of data visualization

and visualization technology.

Today, Robert and I discuss his passion

on the interrelationship between
computers, people, and data.

And describes the future trends

he expects to see in data management.

Businesses of all sizes can gain value

through using data to optimize
and streamline their business.

And we discuss how
the technology chosen

plays a role in driving
a competitive advantage.

Let's listen in to learn more.

< Music >

– Well, Robert, I want to
thank you so much

for coming on the podcast today.

We're really excited to talk about you

and your organization, and fintech.

And before we go there,

I just wanted to start with
maybe you could tell

a little bit about your story
and how you got to where you are?

– Okay, yes, great, Adam,
thanks for having me on today.

So my story is I'm a lover
of all things computers.

I've been into computers my whole life,

ever since when I was a little kid.

I went through the natural learning curve,

which is, originally, I wanted
to build video games,

and this is in the early '80s.

So I was focusing on what does it mean

to write efficient code
and things along those lines.

And then later on, we had this club,

and in the club people could buy sodas

and buy candy bars, and things like that,

and it was like a Boy Scouts equivalent.

But it was all being paper-driven

in terms of the accounting and everything.

And I felt, "Well, this is a great
opportunity for computers."

And that's when I realized, wow,

computers, as a kid,
I always saw video games,

and I realized these really
are business machines,

they can really help streamline things.

And, so, our little club was actually,

probably, one of the first
grade school clubs

to, actually, be managed
through electric accounting.

Now, I'm embarrassed by
the system I built at the time

it was very hardcoded
for sodas and candy bars,

but it still got me started on the concept.

So I've really spent my whole
life thinking about,

abstractly, what it means
to connect humans to data.

And that can take you in a lot of places.

And then I ended up working in fintech,

it was Bear Stearns, it was in 2002.

And I was head of infrastructure
at the dark pool Liquidnet.

My work product has been at many

of the tier-one banks, but all
the while it's been this,

I would say my story has been
one of interest in computers

and interested in how
humans and data interact.

– And that's a huge part of,
especially, in the accounting world.

Where you have to understand
where your data is

and what your data is doing.

To be able to visualize it properly,
to give the right reports

to your CEO and all of those items.

And, so, we all understand
how important data is.

What does your organization,

what does 3Forge do in terms of data?

How do they look at data?

– Well, I look at data, I've actually broken

the problem down into three buckets.

I think two of which are very
important for accounting.

But to be exhaustive, I'll go
through all three of them.

The first bucket is what I would call

real-time streaming of data.

And that is not necessarily
as important for this conversation,

but it is something that
we focus on as well.

So the idea is, as data
is taking place somewhere

you want to be able to
have that streaming in,

and as a human be able
to read that in real-time.

An example I could give is,

if you think of, at this point,
cars are pretty advanced.

That dashboard in your car,

that's real-time streaming
information coming to you,

telling you your speed limit.

You don't have to ask the car,
"What's my speed limit?"

It's just always showing it to you,
that's real time.

I think very cool things could be done

in accounting with that,

as you start to move into workflows,

but I'll digress on that.

The second thing is what I would call

asking your computer about data.

And, so, a very simple analogy would be

you simply go on to Google

and you type in, "Who is Adam Larson?"

And then it comes up
and gives you an answer.

That would be you, a human,
invoking a question,

asking the computer
and the computer comes back,

that's the second thing.

And then the third thing is data entry,

which is pretty much what it sounds like.

The ability to fill out a form,
hit Submit and send that.

And then that goes into the computer.

Maybe it goes through some validity,

maybe it goes through
some workflow process,

with the ability to enter data.

So, to recap, we break it
into three buckets.

1. Data moving in real-time.

2. The ability to ask questions about data.

3. And the ability to enter data.

And I think one of the cool things is,

and this is like decades
to come up with this answer.

It almost seems embarrassing

because it seems so simple,
at the end of the day.

But once you've thought about it

in those three buckets,
you can really start to tackle

just about any problem
that comes your way.

And, frankly, accounting has
some of the most deceptively,

challenging problems there is.

I mean, some of the systems
that I've seen built

on our platform are way
beyond my understanding,

to be quite frank.

You know what I mean?

But there's a lot that goes into it.

– Yes, there is a lot that goes into it.

So that just goes to show
it's really important

to have the right technology in place,

at your organization.

To make sure that you can
analyze your data properly.

What have you seen as you've worked

with many organizations.

As they come to you
with different problems

and having to work through
their data issues?

– Well, it's interesting because
it goes without saying

that Excel is the predominant
piece of software being used.

And Excel, I'm sure if I look,
I've got five monitors here,

I'm sure if I look around enough

I'll find Excel up on one
of them for something.

And, I think, Excel is an
incredibly powerful tool

for certain activities,

especially, if you're trying
to mock things up quickly

You're trying to aggregate some data,

maybe determine interest rates,

something like that
it's very good for that.

But I do think it has a
tendency to be overused,

to the point of abused,

and I think a lot of people would agree.

But at the same time, at least,
there hasn't been a good alternative.

And that's something we focused on,

is providing that alternative.

A few of the places where Excel
starts to break down is,

and they're making headway in this slowly,

but it's being able to
prevent fat-finger events.

It's very easy to accidentally update data

that you shouldn't be updating.

Also, it's hard to keep a good
audit trail of who's done what,

and there really isn't
much around workflows.

So let's say you and I
work in an organization.

You can enter data into a system,

but that data doesn't actually get reflected

until I, as your manager, in this
scenario, would approve that.

And, so, something along those lines.

So the workflow aspect
is another thing missing.

But with that said,
I think, Excel is definitely

a very powerful tool, and it's
used in a lot of cases.

I think there are also a countless
number of vendor solutions

that solve a particular problem,

within any space that you can choose,

accounting certainly being one of them.

And then you've got, as you get

to the larger organizations,

a lot of our customers are tier-one banks,

100,000 employees plus organizations.

They'll often roll their own software.

And, so, what 3Forge
is trying to fill the gap

is to provide a generic platform.

And I would say Excel is
a data-agnostic, generic platform.

You can do just about
anything you want in it.

So we have provided
a data-agnostic platform,

but with a focus on trying
to fill in those gaps

around being able to audit
changes to the calculations.

Being able to put workflows
around data entry.

Making it a little bit easier to build reports.

And I think another thing is,
and this gets a bit technical,

but having a separation
between data, calculations,

and display those three pieces.

And, so, that's what we focused on.

– Well, and that's a huge part

where things can go wrong, in Excel,

is where you're trying to put calculations

in the same spot where you
have all the data listed.

And you can maybe
accidentally delete something,

you can do all those things.

So having those blocks in place,

sounds like a really great solution

to some of the biggest problems

that you see with Excel.

– Yes, and it's interesting
because these problems,

a lot of these problems
were solved in the '80s.

And they made their ways into databases

and I could talk a lot.

I mean I love the history of the database,

and where it's gone, and
the sort of things it's done.

But it's been really, I would say,

centered around the developer mentality

not the business-user mentality.

And, so, we've just taken
a lot of the things

we learned from the database discipline

and tried to raise that up,

so that it can be a little bit
more digestible by business users.

By people that are actually used

to using something like Excel.

So, for example, I could go on all day,

but one thing that databases do very well

is what you would call data integrity.

So, you can't put apple pie
into a price column,

it just won't let you.

It won't let you type that in.

So it's just, "No, it's got to be a price."

In fact, if you can even say
it's got to be a price

with this many digits of accuracy,

and it has to be within this range.

So if you could set up those things,

it's actually pretty tough to do in Excel.

Excel makes it very flexible.

But it's not hard for one to imagine that

you could add those sorts of features.

You know what I mean?

You can add those features

to say, "Okay, this column of data
must have this validity to it."

You know what I mean?

And if it doesn't, then,
just don't let them enter it

or force them to do
something else, et cetera.

So that's just one of many examples.

But really it's been about,
I think, a lot of our journey

has been trying to bridge that gap.

Between the sophisticated
solutions that developers

have at their disposal,
learned through databases,

and being able to move
that up the value chain

so that business users have
access to that as they-

– Yes, that makes a lot of sense.

Because what we've been seeing
in the accounting space

is that a lot of accountants
are learning about data science.

Because they recognize the importance

of having the validity of the data

and being able to analyze it from that way.

But are there ways for
people to understand

and analyze the data without
being the data scientist?

– Yes, first off, well, if we
specifically talk about our platform,

I could give general answers.

But with our platform,

how we've tackled that
is through personas.

So the idea is you have,

I guess, what you could
call the database manager,

we call it the Admin persona.

And those are really the people
that can actually go in

and do very physical things with the data.

They can actually change
the validity around

what it means to be a price,

as an example, data integrity type things.

And then you've got another persona,

which is people that want
to be able to build dashboards.

And usually, they're subject
matter experts.

So they understand that;
"If I take price times quantity,

well, that's going to give me value."

Something like that, I mean,
that's a trivial example.

But the idea that they are
subject matter experts,

and they understand
how the data operates,

and how it interacts, and what data

from this sheet multiplied
by data in this sheet,

what that's going to look like.

And then the last persona I would
say would be the consumer.

And now we're a little bit
more into either people

that are just looking
for end-of-day reports,

or want to be able to fill out
a questionnaire,

and then get answers around that.

What was our P & L over the last quarter?

And they don't, necessarily,
need to understand

all the inner workings under there.

So a lot of this is tackled
through this persona concept,

which, again, this isn't something
that we invented.

It's just we're trying to make it

a little bit more accessible
to the financial world.

– Yes, so do you have any examples,

maybe that you can share,

of organizations that have
been successful?

Obviously, you don't have to
use names of the organizations.

But of organizations that
have been successful

using software like yours,
as you've observed it?

– Yes, absolutely, I mean,
we've definitely had cases

where organizations, especially,
when they're dealing with money

and everything has to be 100% accurate.

I was surprised to learn this,

but a lot of times they would
have to actually tackle it,

because you can never be sure,

"Is the Excel, the integrity
of all that data correct?"

They would actually do things in duplicate

and then see if everything netted out.

And when it didn't, then
they could work backwards.

And by doing it twice,
having two individuals do it,

now, they knew that integrity was there.

Then, the issue they start
to face, over time, though,

is as the assets under
management grows,

so does the complexity
of trying to calculate

what the carry interest
is going to look like.

This is just one example.

And, so, as the assets grow and grow

this becomes, exponentially,
more difficult,

I'm imagining, I can't say for certain.

But to me, it seems as though
as you have more moving pieces

and you calculate, predict it all,

it just goes up and up exponentially.

And, so, it actually got to a point,

and I've seen this at multiple firms,

where the amount of time it takes

to actually do the calculations,

and to provide reports
back of investor positions

and things like that, exceeds
what can be done in a month.

And then as it grows,
it can't be done in a quarter.

And then, all of a sudden,
you're now to a yearly result.

And, at this point, our customers,

they really look that and say
they have three choices.

They either just tell everyone,

"Look, we can only produce this yearly."

Or they say, "We're going to find

some vendor product that happens."

And they can use Excel
in that, first example,

they use Excel and they do it yearly.

Second example is they conform

to an existing vendor product
that has a certain solution.

But that means that basically the vendor

is now driving the business,

as opposed to the business
driving the business.

You know what I mean?

It has to conform to how the
vendor designed the software.

And then the third option
is using our approach.

And I say our approach
because I could see, over time,

other people building products like ours.

But, for now, it's our platform.

So they could basically say,

"Okay, I'm going to adopt
this data-agnostic solution.

I'm going to put my business logic in

and then we can now
produce these reports."

And, so, we've been able to help

our customers keep
their very customized,

I would call, intellectual property,

that gives them a competitive edge.

They've been able to keep all that.

All those things that we're leaving,

that were all domiciled in Excel,

they've now been able
to put that into our platform.

But now they have all
the rigors and checks

that they would get from
a bespoke vendor solution,

or by hiring a team of people and building

something from scratch, in a database.

– So would you say that
it's been successful?

Have you been successful at this,
as time has gone on?

I see that 3Forge has been
around since around 2010.

How is that process gone
along over the years?

– Well, the crazy thing is
we attacked this opposite

almost every other software vendor.

I mean, we really went after the
hardest to-use cases there were.

I think today we estimated that

about one in five equity orders
around the world

are somehow analyzed through
our software, across our clients.

So when it comes to the large,
recognized banks,

we're being used in those.

And, so, we're talking about
replacing gobs of Excel reports,

and it's not a technical term,
but just huge volumes

of what was being done in Excel
have been replaced.

So we've seen success, for sure,
at the large tier-one banks.

It's recently in the last,
I would say 24 months,

that now that has started to trickle
over to the buy-side.

And, so, yes, we've
definitely seen success

at several buy-side firms as well.

- So as you think about the future,

as we're coming to
the end of the conversation.

When you look at the future
and the future of technology,

and how the industries are going.

Where do you see organizations

going as far as looking at their data?

– well, I think there's
a lot to be said there.

First off, every organization,
and I've thought about this.

I blurted this out on one podcast
I did a while ago,

and then I thought about it retrospectively,

and the more I think about it,
the more I agree.

There is no business that
cannot gain substantial value

through the data they
already or should own,

that they're producing.

I thought about it, even if
you're a small car dealership,

or if you are a cleaning service,

there's probably data
that can help you optimize

and streamline your business.

Going all the way back to my candy bars

and soda back when I was a kid.

So I think that, and it's
definitely happening

with our larger customers.

They've now acknowledged
that what was considered

to be a cost is now an asset.

At one point, I was like, "Oh, we have
to store seven years of data

because the SEC is requiring
us to do this."

And I was like, "There's
overhead in this cost."

And they've, actually, that's shifted
on the balance sheet to an asset.

So that information that's
sitting there is critical.

The problem is when it's sitting,

and I know I keep picking on Excel,

but I could pick on lots of systems.

The problem is when all
of that data is sitting in siloed,

broken up areas and you
can't look at it holistically,

it's very hard to extract value,

certainly, maximum value from that data.

And I know I'm going on
a little bit of tangent here.

But one example, we had a customer

who they literally had an Excel file

for every single account
that they were managing.

So if they had 400 accounts
they had 400 Excel files.

To be able to actually take that data,

which is something we do very well.

To take our system and lay that
on top of these Excel files.

Something I haven't
talked too much about

but we have the ability
to take our platform

and have it sit on top of Excel files.

So you can ask questions
across your entire Excel plant,

if you want to call it that.

And suddenly they could realize
there were certain accounts

that were sitting there very domiciled,

not doing anything.

There were other accounts that had

a lion's share of the investment,
and it became very easy

to ask these questions across this data.

So, I think, one of the
things is that organizations

are going to understand that they need

to start to consolidate that data,

to get more value out of it.

A data warehouse is one approach.

I don't actually think it's
necessarily the best approach,

especially for large organizations,

but I do think that is a big
part of the future.

Another thing, another trend that I see

is that as systems grow
and companies grow,

systems tend towards
complexity, they have to.

People are always adding new features;

they're not really taking away features.

People are adding new laws to a contract.

They're not removing
elements from a contract.

You know what I mean?

Generally speaking, and, so,

as things get more and more complex,
I think there needs to be more rigor

around how data is managed.

And I know that's a lot to chew,
what I just said there.

But as systems are getting
more and more complex,

there needs to be processes in place

that manage the flow and
accountability of that data.

And I think organizations
that do that better,

and in fact, one of our customer
is all over the place.

They just have their whole
motto is "Stability first."

You know what I mean?
– Yes.

– And by the way, they're probably
one of the top companies,

one of the largest companies in the world.

And the more I thought about that,

well, isn't that, kind of a boring mantra?

"Stability first."

But you know what, at the end of the day,

it's having that stability,

and having the security, and the
awareness of the complexity

that I think really gives people
a competitive advantage.

– It really does.

And the other thing I was thinking about,

maybe you can comment on this,

what about small to
medium-sized businesses?

Because you've mentioned a lot
of the big-time businesses.

But small to medium-sized businesses

are a large portion of IMA members,

and they're tapping into
technology more and more

because the world is online right now.

And, so, what about those people

who are trying to get into data now?

– Mh-hmm, yes, well, it's definitely
worth stepping back

and saying, as a small business,

what is your intellectual IP?

And, by the way, I founded
3Forge in 2010, '11, 2011.

And, so, I know what it's like
to be a small startup.

And you have to make,

pretty much all your decisions
have to be close to correct,

you know what I mean?

And you have to be willing to pivot,
et cetera, as you need to.

So I look at it as, for small companies,

it's important to have focus

on what it is that is your intellectual IP.

And be able to take that and use
the correct technology for it.

And I do believe that through technology,

using the right technology,

you can get a large
competitive advantage.

And if you're using the same
technology as your competitors,

of course, you can be smarter
than your competitors,

that's why you can win.

You can have some edge or some insight

that your competitors don't.

But, ultimately, as we go down
this path more and more,

the technology that customers choose,

that small businesses choose,

is going to have a bigger impact.

And, by the way, I will say
that small companies

have a huge advantage in that
they can be much more nimble

and they can make decisions a lot faster.

The ability for a large organization

to switch from one platform to another

can easily be a large initiative.

I'm not even talking about
3Forge, at this point,

just generally speaking, switching
from one platform to another.

18-month initiative, 24-month initiative,

a team of 50 developers,
da, da, da, these huge things.

But small companies take advantage

of the fact that you can move quickly.

– Definitely, that's a huge
point to remember,

is that you can be more nimble
when you are smaller.

And being able to do
that is a huge advantage,

especially, as the world becomes smaller

because of how vast technology
is growing, basically.

– Mh-hmm, agreed.
– Well, Robert,

thank you so much for coming
on the podcast today.

I really appreciate you coming on

and sharing your knowledge
and expertise with us.

– Yes, absolutely, thanks
for having me on.

< Outro >

– This has been Count Me In,
IMA's podcast.

Providing you with the latest
perspectives of thought leaders

from the accounting
and finance profession.

If you like what you heard and
you'd like to be counted in,

for more relevant accounting
and finance education,

visit IMA's website at www.imanet/org.

Creators and Guests

©Copyright 2019-2024 Institute of Management Accountants. All rights reserved.