Enterprise Data Warehousing
The Enterprise Data Warehouse of this organization had become quite slow after the re-platforming of their Oracle and Business Objects Warehouse in to the Ware house operating with MicroStrategy, Tableau, and custom .Net applications with Teradata database.
Our principals led a major performance tuning effort. The activities included: Troubleshooting Application versus Network to differentiate between web experiences and report execution time; Fact based optimization on SQL; Implementation of Development Standards and Guidelines; Design and Code reviews; Migration Approvals and Performance review; Implemented Workload Management; Introduced the concept of ‘Design for Performance’; Monitoring and measurement of usage; profiled data and brought visibility to data quality issues early and often.
This initiative resulted in significant reduction system resource usage and highly significant improvement in production throughput and speed.