montrose_logo
Transforming data management: a success story with Lord Abbett

Transforming data management: a success story with Lord Abbett

Infrastructure Redesign

Transforming data management: a success story with Lord Abbett

About this project

Montrose Software collaborated with Lord Abbett, a leading investment firm, to analyze and improve a large and complex ETL system. This involved optimizing system performance, automating regression testing, and addressing the challenges posed by an evolving metadata structure in a critical bucketing tool. The results included a 40% performance improvement, enhanced data integrity, and a more streamlined and human-readable metadata system.

Region

New Jersey, United States of America

Project team

4 Developers

4 Developers

Tech stack

Java

Java

Python

Python

Azure SQL Server

Azure SQL Server

Batch Script

Batch Script

Perl

Perl

About Lord Abbett

Since its founding in 1929, Lord Abbett has maintained a singular focus on managing money. As an investment-led, investor-focused firm, Lord Abbett evaluates every decision from an investment perspective, striving to achieve superior long-term investment performance for its clients. The firm currently manages over $140 billion in assets.

stocks

~$199B

assets under management 

184

investments professionals

200+

institutional clients

51

partners

The challenge

  • Improve the performance of a complex ETL system.
  • Simplify the bucketing tool's metadata structure to minimize errors.
  • Ensure the integrity and consistency of data through automation and optimization.

Key functionalities

gears

ETL system optimization

Grouped ETL steps based on their nature and replaced standalone scripts with a common metadata-driven tool. This optimization led to over a 40% increase in system performance.

gears

Automated regression tool

Developed and integrated an automated regression testing tool to ensure the integrity of results, which became part of the system’s nightly runs.

gears

Metadata structuring

Extracted the custom metadata language interpreter from the bucketing tool, identified configuration inconsistencies and duplications, and created a human-readable data structure to enforce data integrity.

Project workflow overview

workflow

Deliver your project with confidence

Tech leaders from 10+ industries rate us ★5 for quality and speed, with 98% of CTOs recommending our product team. With over 10 years of experience, you can trust us to build your product confidently.
Work with latest technologies
Our solutions are designed for stability, usability, and scalability using next-gen technologies like microservices, serverless, and cloud computing.
100+ professionals available
Our team includes developers, cloud engineers, DevOps, architects, QA analysts and UX/UI designers with the skills your project needs.
Rated 4.9/5 on Clutch.co
We ensure everything we build provides great value to you and your clients.
googleclutch

Related case study

Efficient data management: optimizing Lord Abbett's ratings process

Efficient data management: optimizing Lord Abbett's ratings process

Finance

View

Efficient data management: optimizing Lord Abbett's ratings process

Get in touch

Contact Us

logo
Our Offices
Kraków / Poland
ul. Twardowskiego 65,
30-346 Kraków, Poland
New Jersey / USA
351 Hartford Rd,
South Orange NJ 07079, USA
Reviewed on
Google logo

5.0/5.0

Google star 0Google star 1Google star 2Google star 3Google star 4
Clutch logo

4.9/5.0

Clutch star 0Clutch star 1Clutch star 2Clutch star 3Clutch star 4
Certificates
ISO Logo

ISO/IEC

27001:2022

ISO

9001:2015

2024© Montrose Software. All Rights Reserved.