Enterprise Data Warehouse

Data Management Data Warehouse Business Intelligence Reporting Analytics

For a regional retail service provider, Adaptive Systems replaced dozens of disparate legacy business and reporting applications and databases with an enterprise application to manage corporate master data, a data warehouse to provide a common source of truth to all consuming applications and users, and a BI / Reporting solution consisting of dashboards with relevant KPIs, emailed and interactive reporting, and a variety of analytics, including fraud detection and customer loyalty. As the client selected best-of-breed Software-as-a-Service systems to replace legacy applications, the data warehouse also served as a hub for integrating data and workflows across many external systems to keep information in-sync.

  • Created Using: SQL Server, SQL Agent, Web APIs and Integration services (.NET), Web (MVC, .NET, Telerik), Reporting (Looker)
  • Completed on: March 2018
View Project

Mobile Apps

Mobile Dispatch Service Delivery

For a regional service company, Adaptive Systems provided their fleet with a mobile tablet app that dispatched and navigated them to job sites to perform services, and collected service information to report back to a command center. The mobile app provides embedded turn-by-turn directions, service instructions. It captures job start and completion information, and enables sending and receiving voice phone calls to facilitate team coordination to deliver great customer service, and automatic SMS text messaging for alerts to supervisors when certain events are reported by the mobile service worker. In the command center, Adaptive Systems provided the dashboard to plan the routing logistics for the fleet, track progress, make mid-course corrections and just-in-time changes to sites to be serviced. The dashboard captured the critical service data for review and creation of service tickets for invoicing.

  • Created Using: C# .Net Web API, C# .Net Web App, Native Android App, Enbedded Mapping and Navigation, and SQL Server Database, Azure-hosted solution
  • Completed on: September 2020
View Project

Business Intelligence

Data Warehouse Business Intelligence

For a national financial services provider, Adaptive systems integrated call center transactional and quality analytics data from an external system (Call Miner) with their internal data in order to create a data mart. Using Microsoft Power BI, Adaptive Systems built and demonstrated prototypes of dashboards to visualize and correlate key measures, explore relationships, and gain insights into best practices and opportunities for improvement.

  • Created Using: Integration service (.NET web client consuming an external REST api), SQL Server Database, Microsoft Power BI
  • Completed on: October 2016
View Project