Retail

Application Management Support for Data Integration Platform

Application Management Support f

A $100B NYSE listed retail company needed round-the-clock support for its eCommerce data integration and reporting platforms. The customer required a dedicated team to engage in smooth transitioning from Go-Live to a Stable Steady State with ongoing production support.

Client Challenges and Requirements

  • Need for a dedicated support team to streamline the development, maintenance and support areas within the eCommerce department
  • To support ongoing growth in production of 1000+ processes with optimal resources
  • Support Azure cloud migration and parallel runs with on-premise
  • Proactively identify recurring issues, root cause analysis and fix
  • Consistently produce knowledge documents and periodic updates

Bitwise Solution

  • Provide support for production covering 40+ subject areas by forming an Agile team
  • Maintenance, enhancements and support of 1000+ jobs per period
  • Build and update Knowledge Repository
  • Dark Data Element Discovery – Identify and cleanup of dormant jobs and dead code
  • Fine-tuning long running jobs (code and scheduling optimization)
  • Extensive reporting for complete insight of support health
  • Addition of small effort enhancements and improvements along with support activity
  • Driving weekly support discussion connects to discuss the support KPI and action items in terms of follow-up and root cause analysis

Tools & Technologies We Used

SSIS
SSRS
SSAS
Azure Data Factory
Azure Synapse
Azure Databricks
SQL Server

Key Results

End-to-end ownership  model aligned with  customer’s OKRs

End-to-end ownership model aligned with customer’s OKRs

Onshore involvement  reduced to 10% for  controlled costs

Onshore involvement reduced to 10% for controlled costs

Consistent updates to  Knowledge Repository

Consistent updates to Knowledge Repository

Achieved QoQ reduction  in support efforts for  optimal performance

Achieved QoQ reduction in support efforts for optimal performance

Share

Download Case Study

Let's Engineer Your AI Advantage