Client
A leading diesel engine manufacturer
Goal
Reduce bottlenecks on the production line that arise from last-minute changes to orders and ensure compliance with build instructions
Tools and technologies
Windows, SQL Server, C#, .NET, ESB, HTML5, Angular, GitHub, JIRA, Visual Studio, and WebStrom


BUSINESS CHALLENGE
A diesel engine manufacturer based in Detroit faced frequent production delays. The cause of the inefficiency was its build book system. The manufacturer used a printed build book to communicate the specifications of the engine being built to the production floor. But, often after the book was sent to the shop floor, the manufacturer had to make changes to specifications. In such cases, those working on the production line would not be able to use the printed build book. Waiting for a reprinted book would halt production. As a result, the changes were usually communicated outside the manual and assumed to be followed. If the new specifications weren’t followed, they would be discovered only in quality assurance, leading to a loss of time and dollars.

SOLUTION
The client wanted a solution to resolve bottlenecks created by the printed build book and ensure compliance with build instructions. Ideally, the build book is dynamically pushed onto a handheld device assigned to the shop floor. The system would allow managers to update the specifications in the build book on the fly and alert the production team to the changes.
The device would also communicate the status of production to managers. For example, they would know which work center is working on an engine so that relevant pages of the build book could be updated and displayed to those work centers.Â
Iris custom-built an application that allowed real-time updates of the build book. It was designed to push the build book to work center operators on V10 devices (RFID transponders) with screen sizes ranging from 3 inches to 10 inches. The solution included a consolidated dashboard that provided the management near real-time visibility of work centers and the status of the engine production.

OUTCOMES
During Phase 1 of the project, we deployed 250 V10 devices. After a pilot run of four weeks, the client stopped printing build books; the handheld devices with our application were a superior alternative. The solution helped eliminate printing costs and allowed the manufacturer to accommodate last-minute changes in specifications without disrupting production.
Related Stories

An agile sprint for financial data
How Iris helped a mega sportswear brand’s global operations and financial reports go flexible, agile, and analytical.
Contact
Our experts can help you find the right solutions to meet your needs.
Get in touchAn agile sprint for financial data

Client
Among the world’s largest manufacturers of sportswear, the client sells its products in more than 120 countries and employs more than 13,000 people.
Goal
To significantly reduce turnaround time and ease associated with report creation.
Tools and technologies
Microsoft SQL Server’s Analysis Services (SSAS), Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services (SSRS), Boomi AtomSphere, and Power BI.


BUSINESS CHALLENGE
The client’s standard SAP reports limited the flexibility to slice and dice data or add fields to reports. Modifying or creating new reports was either difficult or expensive.
The top management, including the CFO and financial controllers, found it difficult to get a high-level, integrated view of the company’s finances.
The existing process required data transposition between various systems, including the SAP and Oracle systems. Much of this data was extracted and consolidated manually, which was time-consuming.

SOLUTION
Iris executed a distributed Agile framework for the client’s global delivery model. Our solution extracted data from the client’s SAP ERP system employing Dell Boomi adapters, and used SSIS (SQL server integration services) to obtain enriched data.
We made the data actionable by mapping it onto interactive PowerBI Tableau dashboards. The team also created a data warehouse using a custom-made finance data model. The easily shareable data cubes replaced all legacy reports and reduced the number of SAP user licenses.

OUTCOMES
The execution of an Agile framework and use of interactive Power BI dashboards benefited the client in many ways such as:
- Enhanced visualization of operations and accounting flows
- Creation of need-based reports without additional licenses
- 95% reduction in time and effort to produce reports
Related Stories

Powering shop floor efficiency with data analytics
Manufacturing application helps reduce bottlenecks and accommodate last-minute specification changes without disruption.
Contact
Our experts can help you find the right solutions to meet your needs.
Get in touchCompany
