data

JUMP START BATTERY PRODUCTION
When Interstate Batteries' data architecture was stalling out, we super-charged their database. They are now hitting 2x the speeds they had before with boosted security.

CLIENT: INTERSTATE BATTERIES (IB)


PROJECT:

IDM Security Project

STRATEGIES:

Digital Transformation, Custom Development, Modernization

TECHNOLOGIES:

Data Lake, Information Modeling, Data Mining, Interfacing, Integrations

FACTS

L

IB needed has a multitude of different custom and out-of-the-box application for in-house and franchise dealers

L

IB needed a centralized way to handle user access to all its  programs; both internal and external

ISSUES

L

On boarding franchise dealers and new employees is a nightmare to do all the different software and data sources

L

The in-place IDM application was so slow it was unusable

L

Third-party consultants had written version 1.0 of the security software and had left without knowledge transfer or documentation

L

Oracle database architecture was overly complex and slow to access

L

UI/UX workflow was cumbersome and hard to understand

RESPONSE

L

Worked with in-house DBAs to performance tune the Oracle DB and optimize queries

L

Automated adding new applications and their security to IDM

L

Modernized code base to handled more robust UI/UX design

L

Decoupled solution modules for better performance

L

Cleansed existing data

L

Create new certified training software

L

Create Benchmark Software for streamlining the HVAC manufacturing process

RESULT

L

Increased database read/write times by 200%

L

Workflows times for adding/modifying users was reduced by over 100%

L

Workflows times for adding/modifying applications was reduced by over 100%

L

We received hugs from users