Tag Archive for matrixed environment

1: Structured Query Language

My first exposure to “programming” was writing database queries.

In 2006 I was asked to define a process for creating legitimate securities pricing data from unstructured text. The first challenge was to understand the corpus of text we’d be dealing with and how different geographic and asset class sources differed.

The same expression could mean different things based on its context and the shorter the expression the more difficult it is to define.  For example to a bond trader the letter “T” refers to a U.S. Treasury security; to an equity trader it means AT&T.  When that equity trader or a corporate bond trader sees the letters “WY” they see Weyerhauser while a municipal bond trader sees the State of Wyoming.

Given just the pure text it was nearly impossible to discern the correct context. Information about the source of the text was required.

We operated in a heavily matrixed environment.  I reported to through the head of product and technologists were in the R&D line. Three of the company’s most talented programmers were assigned to this project.  They had the huge task of ingesting documents (up to 500 per second) and identifying security references, prices and pricing convention (price, yield or spread to benchmark) for dozens of prices per document.  Since this data was to be used to drive investment decisions it had to be validated against other known sources.  Secure permission to view it had to be assigned to specific users and delivered to them within 100 milliseconds.  They had their hands full.

My job was to find out where to focus the parsing effort and to do that I needed metrics.  At first I asked programmers to provide reports on who produced these documents, from what region and what time of day.

Creating these reports for me took them away from the critical tasks they needed to complete.  The solution we agreed on was that they teach me how to make these reports myself.  A programmer named Joshwini showed up at my desk one day and installed a program on my PC called Oracle SQL Explorer. It had access to the tables of data they used to generate my reports. She configured it and went back to do her job.  I sat there looking at it and wondering what I was meant to do.  There was a box labelled “query” so I sent Joshwini an e-mail asking “what’s a query”.  She wrote back “SELECT * FROM TABLE”.  Her response to my follow-up questions was that it would be easier for me to Google my questions than to wait for her to get the chance to answer.  She was so right.

Professional

When my job executing orders for a discount broker moved to Atlanta, I decided to move toward the IT side of the financial services industry.

I worked for over 20 years at Bloomberg L.P. in various capacities.  All of them were somewhat sales oriented.  Even as a business manager I realized that in order to get salespeople to sell my product I had to sell them first.  Also, in order to build a decent product I had to learn – in depth where potential clients’ pain points were.  Gaining that insight seems to be a trait of most successful salespeople.

Managing a product or a business in an IT related field means relying on technologists to actually build it.  In the highly matrixed environment of companies like Bloomberg that meant I had to sell the R&D department on why they should give their best efforts to build the products I was responsible for.

I’ll never be as skilled a programmer as the professionals but to sell them I tried to learn their pain points by teaching myself some programming.  Not heavy-duty compiled languages but the lightweight web server variety.
I have always worked for companies with matrixed structures.  It promotes communication and empathy between different skill-sets while ensuring that each team member is in a reporting line that appreciates their value and understands the challenges they face.

Market data is a thin description of what companies like Factset, Capital IQ, Bloomberg and Thomson Reuters provide.  Being involved in analytics requires that one has to understand the data behind them.  Since most data is reported as news before being formatted for use in analytics the three elements (news, data and analytics) are closely connected.

Steve Jobs made a great commencement address back at Stanford in 2005.  He talked about looking back on what you’ve done so far and being able to connect the dots.  I like to think of my professional self as a curious person and when I look back I’ve done a bunch of different things but the dots have connected pretty nicely.

connectdots