DLD Analytics LLC | investment management consultant

Your Dilemma,

Our Solutions

At DLD Analytics, our fervor for data and operations drives our commitment to excellence. Whether you're facing operational challenges, have specific data requirements, or require interim operational support, we possess the expertise and experience to provide tailored solutions. Specializing in the family office and investment management space, we recognize the unique demands of this sector. We are dedicated to crafting innovative and bespoke solutions that precisely align with the distinctive needs of our clients in this specialized field.

OUR SERVICES

Automation with VBA

Over the years, we've dedicated substantial effort to refining numerous Excel processes and untangling complex spreadsheets. In essence, any cumbersome Excel process or spreadsheet can undergo significant improvement. Our experience has revealed that individuals often adapt to difficult methods when, in reality, there exists a markedly more efficient approach waiting to be discovered.

Examples of some projects can be found below (or click here).

Spreadsheet Audits

This encompasses a comprehensive spectrum, delving into intricate aspects such as Data Governance, Process Control, and Optimization, while also conducting fundamental functionality checks. These include meticulous examinations of linkages, reference integrity, security protocols, and privacy concerns, ensuring a thorough evaluation across various dimensions.

System Implementation

Our track record includes successful contributions to multiple implementation projects spanning diverse applications, including Portfolio Administration, Loans, General Ledger, CRM, Fund Accounting, and Performance Analytics. In addition to these implementations, we've developed numerous scripts tailored for seamless data migration between systems, ensuring real-time accuracy on a daily, weekly, and monthly basis.

Reporting

We've crafted a myriad of reports across a spectrum of applications, including Factset, Axys, Investran, Bloomberg, Microsoft CRM, Great Plains, and Atlas 5. These reports span diverse categories such as Accounting/Financial Statements, Tax, Investment Performance, Client Meeting Materials, and Philanthropic reports. Our proficiency in reporting extends to a range of tools, encompassing Crystal, Power BI, SQL, Excel, and application-specific reporting utilities, ensuring a versatile and tailored approach to meet various reporting needs.

Interim Executive/Manager

We boasts extensive leadership experience, having held pivotal roles such as CIO (Chief Information Officer) and COO within multi-generational family offices and investment firms. Drawing from a wealth of firsthand insights, we offer invaluable expertise to bridge gaps in these roles and any associated functions, including but not limited to IT, Finance, Accounting, Portfolio Administration, Fund Accounting, Performance Analytics, and more. We stand ready to address non-permanent needs with a strategic and seasoned approach.

Project Management

In the realm of project management, the pivotal alignment of project goals with overarching business objectives cannot be overstated. Leveraging our team's extensive industry knowledge and nuanced understanding of fintech, we stand ready to assist you in accomplishing a spectrum of internal projects with precision and efficacy.

EXCEL/VBA PROJECTS

Here is a sample of some of the Excel/VBA projects we have worked on in the past. Generic data is used in all presentations.

NOTE: These are just very brief videos highlighting basic aspects of the underlying utilities. They do not completely represent everything that the utilities are capable of. Please contact us for additional information.

Time Weighted Performance Analysis

This brief video presents a dynamic performance utility designed to easily process monthly returns, presenting a comprehensive array of insightful metrics and performance data in a user-friendly manner.

Investment Performance Analysis

This brief video introduces an innovative investment performance utility crafted to deliver comprehensive insights into both entity-level and security-level performance, presented in a variety of practical and user-friendly formats.

Listed Security Trade Validation

This utility enhances the processing of listed security trades. It conducts a thorough validation checks against internal systems and also performs a meticulous cash projection examination. Additionally, the utility generates export files and initiates automated emails to brokerages and custodians.

NOTE: You can double-click on the images below to download a sample of the spreadsheet. The spreadsheets do not contain any VBA code and do not have any macros. They are just presented so you can get a feel for what the data looks like. There are multiple tabs in each file. Please contact us below for additional information.

AUM Calculator

This dynamic spreadsheet offers diverse capabilities for segmenting and analyzing AUM (Assets Under Management) figures with precision and flexibility.

Dispersion Calculator

This spreadsheet served as a sophisticated tool for calculating dispersion, specifically tailored for the creation of GIPS-compliant marketing materials.

Eisenhower Matrix

This spreadsheet is crafted upon the foundation of an Eisenhower Matrix, with its axes subtly adjusted to cater to specific requests.

Financial Statement Scenario Analysis

This spreadsheet empowers the accounting team to conduct scenario analysis seamlessly, ensuring a streamlined process without any disruption to the Accounting Book of Record (ABOR).

Investment Data Summary

Tailored for the weekly investment team meeting, this spreadsheet adeptly consolidates and presents comprehensive performance figures in a concise and insightful manner.

Trade Desk Analytics

This meticulously crafted spreadsheet served as a pivotal tool for the quarterly Trading Committee Meeting, facilitating detailed and strategic discussions with precision and clarity.

Liquid Security Trading Performance Example

ABOUT

Hello, I'm Duane Dibble, Founder and Consultant with DLD Analytics LLC. I bring over 25 years of expertise in the investment management and family office sector. My professional journey encompasses roles ranging from fund accountant and performance analytics manager to operations manager, culminating in positions as Chief Information Officer and COO.

I possess in-depth knowledge of the operations across the entire spectrum of an investment company and family office, including the front, back, and middle office. My experience extends to undertaking projects that involve expanding and consolidating application infrastructures, working with diverse applications, and managing their integrations.

Highlighted in the projects section, I've successfully developed dashboards and applications in Excel/VBA, effectively consolidating data from multiple systems.

My passion lies in overcoming challenges and not just providing solutions but ensuring they are optimal. I am eager to bring this mindset to your project, as the process of finding the best solution is what I find most enjoyable and rewarding.

You can find additional information on my LinkedIn profile:

https://www.linkedin.com/in/duaneldibble/

- Duane