Enterprise Data Warehouse Production Support for Ab Initio

A Fortune 500 Direct Banking and Payment Services company needed support of its Enterprise Data Warehouse covering time critical business lines including Campaigns, Payments, Banking and Rewards.

Client Challenges and Requirements

• Meeting SLAs due to high volume and complexity of the system.
• To support ongoing growth in production of 16000+ Ab Initio graphs with optimal resources.
• Executive committee having very low visibility in the overall status of project.

Bitwise Solution

• Provided Consolidated Support covering all the business lines by providing around-the-clock availability.
• Maintenance and Support of 16000+ Ab Initio jobs.
• Addition of small effort enhancements along with support activity.
• Proactive identification of delays and generating early warnings for SLA streams.
• Elimination of manual processes by achieving automation.
• Building knowledge repository of business-critical applications.
• Dark Data Element Discovery – identify and cleanup of dormant jobs and dead code.
• Fine tuning long running jobs (code and scheduling optimization).
• Extensive reporting giving complete insight of support health.

Tools & Technologies We Used

Key Results

Reduction in overall support cost by 40% with improved turnaround time

Optimized processes meeting 99% SLAs and manual intervention reduced to 5%

Achieved year on year reduction in support efforts and increase in small effort task deliveries

Reduction in job failures and re-execution efforts achieving 1% job failure ratio