Modernize Enterprise Commissions Platform – A Leading property management company
Problem
- Third party Commissions platform lacks functionality needed in reporting
- Current ETL processing is managed via MS Access database with limited supportability.
- Cloud based analytics platform is needed to service global user base.
Action
- Architecture and Roadmap for delivering current ETL layer using Informatica Cloud
- Modeling and building a robust, cloud based Commissions data mart to service business users analytic needs
- Design and implement web-based UI for Sales Admin team business rule maintenance and management
- Solidify technical framework for smooth adaptation of future state data initiatives across the enterprise
KPI's
50%
Increase Report Access
75%
Increased utilization of analytics
70%
Faster processing of Commission data