We developed a web based business intelligence solution used by a top player in the storage systems industry. The solution provides world wide secured access of different business departments and regions to valuable insights out of the analysed data. The application shows multiple KPIs important for the business like bookings, revenues forecast, billable percent of hours worked by engineers, costs, margins, top partners, support cases presented in different dashboards and graphical/tabular reports.
The challenge was to provide business insights to the decision makers, aggregate different data formats from wide range of heterogeneous systems (SAP, ORACLE BI, WebServices, CSV, Excel, Sharepoint) and keep the data fresh for all geographic regions for a world wide enterprise. We also struggled with keeping the data available for query while importing it, securing sensitive data, having jobs running 24x7 and keep Snapshot a big amount of data in a small time frame.
Highly efficient cloning/database publishing mechanism setup for uninterrupted access to consistent data while the ETL jobs are running. Configuring security mechanism to mask sensitive data depending on user access rights. Development of customized Web portal for instant access to dashboards and reports with slice and dice mechanism. High availability and scalability using clusters and load balancing.
Development of a very flexible and performant ETL solution for data aggregation from different sources. Monitoring and alerting mechanisms using custom scripting, Zabbix and Grafana. 24x7 On Call Support provided by a dedicated team. Multiple environments for development, testing, stage and production.
- SQL Server
- SQL Server Analysis Services
- SQL Server Clone Database, NetApp SnapManager for Microsoft SQL Server
- Tableau, Excel
- Junit, Jetty, Tomcat
- Jenkins, Maven
- Continuous Integration