Lyle is available for hire
Hire LyleLyle E Tripp, CFA
Verified Expert in Engineering
Hedge Funds Developer
Pleasant Hill, CA, United States
Toptal member since July 2, 2020
Bio
Lyle is a seasoned technical expert specializing in large database, data warehouse, and data lake projects for 20+ years. He offers top notch design, project management, development, and implementations on projects and products as the situation requires. Lyle uses new and old technologies to solve simple problems with simple solutions while still being ready to tackle and finish complex problems and projects.
Portfolio
Eagle Automated Solutions, LLC
C++, SQL Server Reporting Services (SSRS), Python, MySQL, Amazon Aurora...
Thomson Reuters
PHP, C++, Linux, MySQL
StarMine Corporation
Linux, PHP, MySQL
Experience
- SQL - 20 years
- Excel 2010 - 20 years
- Hedge Funds - 15 years
- Python 3 - 7 years
- SQL Server Reporting Services (SSRS) - 6 years
- Amazon Aurora - 2 years
- MySQL - 2 years
- Pandas - 1 year
Availability
Part-time
Preferred Environment
Pandas, PyCharm, Amazon Aurora, MySQL, Microsoft SQL Server
The most amazing...
...computation I've done recently was completely re-balancing a customer's $3 billion hedge fund 100x faster than their previous solution.
Work Experience
Principal Consultant and Data Analyst
2012 - 2020
Eagle Automated Solutions, LLC
- Designed, developed, and supported a web-based trading calculator for complex trades and rebalances, trading up to $1 billion at a time. Used SQL and PHP.
- Performed backtesting performance analysis on Bitcoin returns using Python/Pandas.
- Designed and built a big data loader into Aurora. Built with C++ and tested with MySQL. During the 2020 crash, our data loader processed over 1.5 billion records over 6.5 hours in real time.
- Designed and built a large scale performance reporting system for investors. Outputs included 12 reports each for 20 funds plus 25 custom spreadsheets each month. Handled many complex security types and custom reporting needs.
- Shaped and developed a complex custom rule compliance system to avoid costly penalties and fines. This system calculated and alerted on hundreds of custom risk calculations using two completely different data suppliers for intraday and EOD reporting.
- Designed and helped build data imports for 15 vendors and brokers: Morgan Stanley, Barclays, Bank of America, JP Morgan, Factset, and Eze OMS.
- Created and developed a Slack bot that parsed the Slack channel between portfolio managers and traders, looking for low liquidity trades to suggest slower trade schedules. This system saved millions of dollars.
Technologies: C++, SQL Server Reporting Services (SSRS), Python, MySQL, Amazon Aurora, Microsoft SQL Server
Global Head of Persistent Analytics
2008 - 2010
Thomson Reuters
- Managed the engineering team through a two-year Thomson Reuters integration.
- Budgeted, scheduled, and managed StarMine product infrastructure relocation to redundant TR facilities, finishing on-time and $200,000 under budget.
- Trained my replacement and helped several of my staff move into the larger Thomson Reuters organization.
Technologies: PHP, C++, Linux, MySQL
Chief Technical Officer
1999 - 2008
StarMine Corporation
- Grew the engineering team from two to 35 while increasing revenue from $10,000 to $40 million. StarMine sold to Thomson Reuters in 2008 for $97 million, 6X the original cash investment.
- Led a team that calculated billions of equity analytics accurately in a four-hour window each night for institutional investors to use in forming their portfolios.
- Passionately wrote and edited dozens of feature design documents.
- Had a reputation for evangelizing high-quality standards and excellent customer support.
- Led the technical due diligence process during acquisition by Reuters Corp.
Technologies: Linux, PHP, MySQL
Experience
Slack Bot Expensive Trade Detector
We parsed the Slack channels between the portfolio managers and the traders. When we detected a trade being ordered ("MSFT buy 100k"), we would run the trade through an API that had a real-time calculation to detect how much that trade size would affect the price of the security we were about to trade. For high liquidity trades, the bot would say nothing. For low liquidity trades, the bot would show how expensive this trade was and suggest trading speeds other than the implied default. This feature saved my client's clients millions of dollars.
Bitcoin Hedge Fund Performance Analysis
Used Python Pandas to analyze the monthly performance of a Bitcoin hedge fund. Turned infrequent trades into monthly intervals to create yearly attributions separated by long and short positions and maximum yearly drawdowns.
Hedge Fund Rebalancing Tool
I built a tool that could rebalance a single trade, multiple trades, multiple classes of securities, or the whole $3 billion portfolio.
The details include a different ratio for each of 20 funds, different prime brokers for each fund/security type pair, minimum trade lot sizes, tricky rounding issues to always get the correct total position, and the extreme need to be accurate with such a large total investment.
The order management system would take 90 minutes to do a full portfolio rebalance with many known errors that would have to be manually corrected. This new tool could do the whole portfolio in 20 seconds, allowing the traders to go home early and with more confidence the trades were correct.
The details include a different ratio for each of 20 funds, different prime brokers for each fund/security type pair, minimum trade lot sizes, tricky rounding issues to always get the correct total position, and the extreme need to be accurate with such a large total investment.
The order management system would take 90 minutes to do a full portfolio rebalance with many known errors that would have to be manually corrected. This new tool could do the whole portfolio in 20 seconds, allowing the traders to go home early and with more confidence the trades were correct.
Education
1996 - 1998
Master's Degree in Business Administration
St. Mary's College of California - Moraga, CA
1981 - 1985
Bachelor of Science Degree in Mechanical Engineering
M.I.T. - Cambrige, MA
Certifications
SEPTEMBER 2001 - PRESENT
Chartered Financial Analyst
CFA Institute
Skills
Libraries/APIs
Pandas
Tools
Excel 2010, PyCharm, Tableau
Languages
SQL, Python 3, Python, C++, PHP
Paradigms
ETL
Storage
MySQL, Database Architecture, SQL Server Reporting Services (SSRS), SQL Server 2010, PostgreSQL, Amazon Aurora, Microsoft SQL Server
Platforms
Amazon Web Services (AWS), Linux
Other
Hedge Funds, Stock Market, Equities, Equity Market Data, FactSet, Equity Research, Fixed Income, Futures & Options, Options, Futures, Slackbot
Collaboration That Works
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
1
Share your needs
Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2
Choose your talent
Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3
Start your risk-free talent trial
Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.
Top talent is in high demand.
Start hiring