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
Ab Initio
UNIX Shell Scripting
Teradata SQL
PL-SQL
Tivoli Workload Scheduler
Autosys
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
