Technology

Case Study IT Services The client is a public listed IT services management company, with customers in North America, Europe, Asia, and Australia. Revenues close to half-abillion dollars (USD). The Problem The client has a sales team of 300 and a project services team of over 500, utilizing multiple data sources such as SalesLogix, SAP Project Systems, and internal systems to track their sales and project-related metrics. The customer needed a common platform that could allow multiple teams to analyze their data. Their existing reporting system was slow, lacked real-time capabilities, and did not offer the flexibility required for drill-downs, summary tables, or data governance. The Solution BIRD’s solution was customized to align with the client’s organizational hierarchy stored in their SalesLogix CRM database. We created over 200 complex formulas for summary tables with drill-down functionality. Using AI-enabled metadata crawlers, the mash-up feature, and advanced self-service tools, we implemented the solution in just 3 weeks. The solution has been running successfully for over 4 years. The Results 800+ users, including the executive team, are now using BIRD, with proper data governance established. High performance was achieved, meeting customer SLAs by ensuring that any report, regardless of volume, loads in under 5 seconds. We trained a few functional team members, who were able to train all other users through a train-the-trainer program. Additionally, we provided managed services for report creation, server maintenance, and upgrades. Download

Case Study Internet of Things (IoT) The customer is funded by World Bank for a river cleanup initiative, by measuring air and water quality through IoT sensors deployed from the source of the river to the end. The ProblemThe customer deployed 1800+ sensors across a river’s origin to destination, to constantly measure air and water quality and had to upload data across various systems through webservices and in the process had to comply with World Bank norms for release of funds on an ongoing basis. The customer had to push the data from sensors in real-time basis (streams) to a centralized location for furtherprocessing. As the speed of data captured increased, customer faced multiple issues with their existing system and was looking for alternatives. The Solution • BIRD’s columnar store database is used, which can house millions of records with hundreds of columns, to ensure high data ingestion happens with proper queueing mechanism, so that there is no loss of data at any point in time• A multi-instance messaging/queueing solution is configured part of BIRD, is deployed, that is capable of ingesting 10000 messages per second of data generated from IoT devices• A landing dashboard and multiple dynamic reports were developed part of the solution to access sensor stations in real-time. The Results • A security driven common landing page was developed, for all users based on access given by administrator – which solved the problem of customer giving access to various vendors that were part of the sensor maintenance• Easy navigation from landing dashboard to individual station dynamic report is provided with camera zoom in/out view, helped in lot of automation• Real-time and historical reports for trend analysis is used by customer for complying to World Bank norms Download