Optimizing AWS Cloud

Infrastructure for Financial Company

About the Client

Our client is a global leader in the commercial finance services. The organization provides customized lending and risk mitigation solutions to support both international and domestic business growth.

Overview

Operating through its two primary divisions, Finance and Risk departments, the company relies on multiple internal and third-party data sources to make informed underwriting decisions. However, inconsistencies in client identification across different data providers made it difficult for the client to effectively aggregate, analyze, and leverage critical financial data.

Partnering with Sphere, our partner sought to optimize its AWS cloud infrastructure, improve data retrieval efficiency, and enhance performance across financial decision-making processes.

Challenge

The business faced key operational and technical hurdles that limited the full potential of its data infrastructure:

Data Inconsistencies Across Providers

Multiple third-party data providers referred to the same clients in different formats, codes, and naming conventions, creating mismatches. This inconsistency delayed underwriting decisions and hindered comprehensive risk assessments.

Inefficient Data Aggregation

Retrieving, processing, and analyzing debtor-related data was slow due to fragmented structures in the existing database. The lack of optimized query structures increased processing time, negatively impacting decision-making speed.

Suboptimal AWS Cloud Utilization

The cloud environment was not fully optimized, leading to unnecessary costs and underperformance in data retrieval speeds. High ingestion time made it difficult to process large amounts of financial data efficiently.

Our Solution

To address these challenges, Sphere executed a structured optimization plan focusing on database evaluation, data warehouse enhancements, and AWS infrastructure adjustments.

Sphere conducted a deep-dive assessment of the client’s current database condition and structure, identifying inefficiencies that hindered performance.

To improve data aggregation, Sphere restructured the debtor and key data elements in data warehouse:

Sphere optimized AWS cloud services by fine-tuning data ingestion pipelines and query execution strategies:

• Reviewed and optimized table structures to improve query execution and retrieval speeds.

• Identified redundant data points and recommended indexing strategies for better search performance.

• Implemented a standardization framework to unify client identification across different data sources.

• Designed new tables for summarization and quick search, enabling faster debtor-related analytics.

• Provided a roadmap for long-term enhancements to further refine client’s financial data strategy.

• Adjusted cloud resource allocations to improve performance while reducing unnecessary costs.

• Implemented new indexing and caching mechanisms, leading to significant gains in processing speeds.

Result

By partnering with Sphere, our client successfully transformed its AWS cloud infrastructure, improving data retrieval efficiency, financial analytics, and underwriting processes. Through database enhancements, structured data warehouse recommendations, and AWS optimization, the organization now operates with a faster, more cost-efficient, and high-performing cloud environment—delivering better response times and smarter financial decisions while saving on operational costs.

The AWS cloud optimization project delivered measurable performance improvements, enhancing data accessibility and processing capabilities:

• 20% reduction in data ingestion time, allowing faster integration of new financial data.

• 30% improvement in query performance, enabling real-time insights for underwriting and risk assessments.

• More efficient data aggregation and standardization, eliminating inconsistencies across third-party data providers.

Key Achievements

Streamlined data processes to support faster decision-making in finance and risk assessments.

Achieved 20% faster ingestion times and 30% faster query results, reducing operational delays.

Ensured consistent client identification, improving the accuracy of underwriting and risk assessments.

Optimized AWS infrastructure, reducing wasteful spending while boosting cloud efficiency.

Organizations around the world trust us

Hear from

our clients

Hear from our clients

Lee Ebreo

VP of Engineering at Credit Ninja

These things would not have been achievable if we did not build our own in-house system and if we did not partner with Sphere to help us achieve our goals.

Selah Ben-Haim

VP of Engineering at Prominence Advisors

Our experience with Sphere and their team has been and continues to be fantastic. We keep throwing new projects at them, and they keep knocking them out of the park (including the rescue of a project that was previously bungled by another vendor).

Ben Crawford

Senior Product Manager at Enova Financial

I would expect to be delighted. It's been a really positive experience, working with Sphere, and I would expect you to have the same.

Mark Friedgan

CEO at CreditNinja

Sphere consistently prioritizes the needs of their clients, demonstrating both agility and teamwork. As an offshore team, they have been an integral part of our organization and we plan to continue growing with them.

René Pfitzner

Co-Founder at Experify

Sphere provided excellent full-stack development manpower to augment our team and help push our product forward. They are easy to work with, tech-savvy and proactive.

Bruce Burdick

Chief Information Officer at Integra Credit

We've been working with Sphere and its excellent consultants since our founding. I've found that they are true partners in the success of our business.

Jemal Swoboda

CEO at Dabble

The resources and developers that Sphere Software provides are skilled and have the required technical expertise, but more importantly, they have helped us build a culture of excellence within our team.

Arthur Tretyak

Founder and CEO at IntegraCredit

With Sphere, we were able to migrate in half the time it would take to train an additional FTE… and for a fraction of the cost. Our experience with Sphere has been exceptional.

Lee Ebreo

VP of Engineering at Credit Ninja

These things would not have been achievable if we did not build our own in-house system and if we did not partner with Sphere to help us achieve our goals.

Selah Ben-Haim

VP of Engineering at Prominence Advisors