Risk Data Warehouse
Business Case
- The time consumed to extract, cleanse and conform one period of company wide data from 20+ disconnected systems was 40 man days.
- The demand for consistent, reliable data that was available to many people was growing.
Actions Taken
- Demonstrated the potential value of a centralized data warehouse to the organization.
- Upon buy-in, engaged Finance, Risk, IT and Quality personnel across all platforms to act as platform SMEs.
- Partnered with IT to communicate the vision, develop tools, operationalize platform data and definitions, train participants, and manage the overall project.
- Developed methods that accelerated tool deployment, improved data quality, and allowed users to access their data in both conformed and native formats.
Business Results
- The tool was completed in half the allocated time and under budget.
- The robust design benefited the entire business, supported new business initiatives and improved productivity by $ millions each year.
- The tool provided vital information for 500+ users and facilitated the deployment of risk compliance and auditing functions.