Brainspire Solutions
Brainspire develops custom software solutions to client’s individual needs.
Brainspire develops custom software solutions to meet client’s individual needs. We drive success based on client priorities and tapping into client business expertise. They provide solutions across all industries and their horizontal experience actually enhances their ability to provide innovative and objective solutions to new industries – breaking the “we’ve always done it this way” mentality.
Leveraging the Agile Methodology, cloud environments, automated testing and continuous build processes as part of the Brainspire Development Framework, they increase project velocity and quality in iterative releases at reduced costs. Clients can make prioritized decisions throughout a project through sharing of all work completed, all tasks left to accomplish, risks and roadblocks and detailed budget information.
Main areas include:Custom application Development, integration, Data & Bi Consulting, Portals and websites, custom mobile applications, and cloud-based software development.
Listing Details
THE SITUATION
Johns Manville is a global manufacturer of construction materials products, with $3B annual
revenues.
• To service the North American market, the company spends approximately $20MM per month
on transportation and freight related costs.
• The client had made a significant investment implementing a new Transportation Management
system (SAP TM), which was collecting substantial amount of data, however not all of it had
been utilized for useful and actionable information.
• The internal Supply Chain and Logistics department had identified numerous initiatives for
investigating and analyzing data, in search of areas to focus on improving costs and negotiating
leverage with transportation providers.
THE SOLUTION
Johns Manville Client engaged Brainspire for two purposes: • Build an analytics/visualization dashboard platform to support transportation analytics • Provide coaching and mentorship to internal resources, to develop skillsets around data analytics approaches, database tools, and visualization packages. • Brainspire worked with the client to identify where and how data is stored in the source TM system and designed queries using SAP tools for extracting data. • Brainspire collaborated with other internal IT resources to define the ETL schedule for loading data from the transactional source system (SAP TM) and into an existing SQL Server DataMart. • In close collaboration with the Supply Chain and Logistics department, the team identified core KPI’s and metrics to measure department and transportation provider performance. • Brainspire resources and internal client IT analysts built multiple dashboards and visualization tools using Tableau to present data in an easily interpreted visual format.