Consolidation of Sales, Budget, Forecast data for multiple subcompanies and acquisitions to give an simplistic view for decision making and tracking.

Background:   The customer is a leading mobility solutions provider in US, operating across multiple channels with a wide geographic footprint having extensive service offerings.   Challenge:   Millions of transactional records were available in different databases of different subcompanies and acquisitions. Budget data is in Excel files  There is a separate set of logic […]

Large Insurance company had a lot of data in their source systems like Policy Asia.

Background:  Large Insurance company had a lot of data in their source systems like Policy Asia. There were 100s of reports on top of this data based on cubes. There were almost 100 different Channels and diverse types of datasets like login, issuance, WFP, WRP, etc.    Challenge:  Only nightly refresh was possible as traditional […]