Case study

Transforming Transaction Models

A Case Study By 7Alder

Case study

Transforming Transaction Models

A Case Study By 7Alder

Overview

The client is a revolutionary company in the vehicle technology sector, transforming how vehicles, businesses, governments, and drivers interact. With its advanced digital platform, the Client offers seamless integration and intuitive interfaces that simplify complex processes across dealerships, drivers, government agencies, and enterprises. The Client’s solutions include digital title and registration, fraud protection, digital signatures, DMV compliance training, and much more. Their services are available across all 50 states, ensuring that each state’s unique requirements are met with tailored solutions.

Client

7Alder 7Alder is a fractional analyst and analytics firm dedicated to providing efficient, accurate, and data-driven solutions to clients who need the best information for their decision-making process. Specializing in model development and optimization, 7Alder leverages its expertise to enhance business operations and the decision-making processes. With a focus on innovation and efficiency, 7Alder partners with companies to deliver state-of-the-art analytical services that drive growth, financial performance, and operational excellence.

The Challenge:

The Client’s transaction models were housed in a database, written in SQL code. This allowed models to process very quickly. Each model is made up of thousands of logical statements layered on top of another. Combined, this web of logic creates a model that can ingest hundreds of inputs, run those inputs through logical calculations, then output the desired results based on the input data. Each model being written in code and housed in a database limited the Client’s ability to fine tune and correct errors that may have occurred in the model. Over time this created a host of problems which were detrimental to operations and negatively impacted potential revenue and profit margins.

Initial Situation:

Need for Change: The Client needs to be able to adjust models within minutes, not days. Models need to be fine tuned to penny perfect, not within a hundred dollars. Models need to be 100% dynamic, adaptable, and scalable.

7Alder’s Approach:

When the Client approached 7Alder, the challenges were clearly articulated:

Sustainability Issues: The existing models struggled to maintain correct logic as time went on.
Accuracy Concerns: Errors in transaction processing were leading to client dissatisfaction.
Model Adaptability: Models were difficult to adjust and fine tune, leading to false patches and compounding logic problems.

Understanding the Challenge:

Strategy: Working alongside the Client, 7Alder determined a strategic plan:

Enhancing Sustainability: Switch out the database SQL models for API-connected Excel models.
Improving Accuracy: Incorporate advanced algorithms and clear structures to reduce errors while maximizing reliability.
Increasing Adaptability: Leverage clear structure and logic to easily fine-tune and adjust models at a moment’s notice.

Implementation Process:

Models were grouped into batches; each batch went through this process:

Transition: Original SQL code was extracted and converted into Excel, including all tables, data, calculations, and structure.
Correction: Once models were in Excel form, they were duplicated for the documentation process, and corrected. The corrections included working closely with research experts providing relevant model information. Each model was corrected until it was penny perfect against thousands of historical transactions.
Documentation: Throughout this process, everything was documented and notated to work as a guide to understand and manage models into the future. A complete structure and user guide was generated to make model adjustment easy to understand for anyone.
Deployment: Once models had been documented and tested for correctness against historical data, they were deployed. Models were connected to an API to handle customer transactions. These models are handling millions of transactions on a weekly basis, continuing to maintain correctness.

Improving Correctness:

Phases of Implementation: This chart depicts the amount of correctness errors in a model over time and the impact of working with 7Alder. Remaining correctness errors are due to incorrect data entry by the client. The model is theoretically perfect in all possible situations.

Key Features:

Improved Accuracy: Every logical decision within a model is documented. All relevant constants and variable calculations are easily accessible for fine-tuning. Models are tested against thousands of historical transactions.
Scalability: Models are honed to penny perfect in thousands of situations and duplicated within the API, allowing for easy adjustments and the ability to handle millions of transactions simultaneously.
Efficiency: Models are designed with tight, clean logic and algorithms, maximizing compute strength and efficiency. A transaction can be processed through the API and model in less than a second.
Ease of Use: Models are designed to be user-friendly. Constants that change on a weekly or monthly basis can be easily adjusted. Variable logic changing in a cyclical schedule is built into the model for automatic updates.

Benefits to Client:

Operational Efficiency: Streamlined operations and reduced downtime.
Cost Savings: The new models generate an estimated ~$50MM in cost savings and client retention.
Accuracy and Adaptability: Accurate and adaptable models using cutting-edge logic.
Enhanced Client Satisfaction: Improved service, near-instant response times, and highly accurate models lead to increased client satisfaction.
Future-Proofing: Models are designed to adapt to future needs and technological advancements.

Client’s Perspective:

“Wil and the team are masters of Excel. No matter the issue we ran into, they were able to find a solution that worked for us. They adapt quickly and finish the job on time. Wil responds quickly and communicates complex ideas in a simple, easy-to-understand way. 7Alder has supported us on a variety of projects, exceeding expectations consistently.”

Impact Statement:

Working with 7Alder has been a successful experience for our company. Their expertise in model development and operational logic has allowed us to overhaul our transaction models. The new models are more accurate, efficient, and scalable, directly contributing to enhanced client satisfaction and operational efficiency.

Closing:

The collaboration between 7Alder and the Client has resulted in a significant transformation of the Client’s transaction models, with benefits of ~$50MM and improved operational outcomes.