Aptitive implements a dynamic reporting and self-service analytics platform

Client Industry

Trade Association

Technology Used

JAVA-related frameworks Spring Web Services Spring Security Hibernate Apache/Tomcat Oracle RDBMS

The Challenge

Our client needed a way to allow their over 1800 partners and subsidiaries to update their own data in the client’s legacy system, eliminating the need for the client’s employees to manually upload flat files each month containing this data. The application to do this needed to include specific data access rights for different partners, down to which field each user role and partner company could read and update. The application had to be available 24/7, tracking and monitoring for inbound and outbound requests, and it had to be easy for partners to use.

Our Solution

We created a service application that provides over 10 different APIs and has a robust data permissions security layer that gives our client the ability to setup user access through a GUI administration tool. The solution allows real-time read and update access to legacy membership systems, keeping the national membership data in sync. The application is self-monitoring and records all inbound and outbound requests with an additional support service that is used to notify IT of any application issues. The application is expandable, easy-to-use, and quick when adding new partners.

The Outcome

Our solution automated previously time-consuming work, added a self-monitoring security layer, and allowed our client insights at a granular level.

The application seamlessly handles over 25,000 transactions per day with an average response time under 2 seconds, allowing our client immediate access to real-time information. It delivers 59 requests per second on average, including update services and integration into the legacy system, which exceeds the Service Level Agreement by over 40%. Our client was given the ability to easily onboard new partners, monitor and track all activity, and expand as needed to accommodate future growth.

Client Industry

Trade Association

 

Technology Used

JAVA-related frameworks Spring Web Services Spring Security Hibernate Apache/Tomcat Oracle RDBMS