|
|
the client |
| Our client is a leading media and entertainment conglomerate based in the U.S. |
|
|
the challenge |
- To automate manual report generation processes
- Implement departmental and project user security
- Ensure automated exception reporting facility for data discrepancies
|
|
|
the solution |
- Combined data from different source systems (ERP, legacy systems) into a single data mart
- Integrated project related data from ERP with user security information from CPM (Corporate Performance Management) – Capital Planning instance to implement user security
- Key subject areas included project identifiers, month, year, area and CERs (Capital Expense Reporting)
- Key metrics comprised of approved amount, spent amount, open purchase orders, invoice amounts
|
|
|
the benefits |
- Reduction in manual data aggregation, consolidation and summarization integration time and effort
- Automation of capital expense reporting landscape with seamless integration of data across diverse systems – ERP, legacy apps, products
|
|