Home>Data Extraction & Consolidation

Data Extraction & Consolidation

Client

For a global investment management company

Business Problem

  • Our client wanted to ingest and process data on cloud-based consolidation engine​
  • They also wanted roll-up and visualization capabilities

Abzooba’s Solution:

  • Reporting components (semantic layers & reports/ dashboards) for ~35 views
  • Specialized data store/table structure and data refresh approach
  • Extraction of actuals & forecast from Workday
  • Ingestion of consolidated data back into Workday
  • Data collation (Actuals – available entries in Workday + Current Year)
  • Informatica BDM based File Extraction jobs
  • Informatica BDM based File Archival Jobs
  • Batch programs for Budget Load and Data Scrub

Business Benefits:

  • File from Workday split into multiple files and made available to budget owners to download
  • Updated data from database is reconciled into a consolidated file and uploaded to SFTP for review

Tech Stack

Speak to AI expert