/Data Warehousing and BI Reporting

ITW

MatchPoint Solutions brought in industry-leading functional and technical expertise to ITW to help them upgrade their outdated and unstable BaaN ERP systems to a new consolidated ERP system, and enable a website integration post a seamless migration of the multiple existing sites to Azure. This significantly reduced the maintenance costs and eliminated the need for manual updates across their vast online presence.

/The Challenge

ITW Manufacturing Group was using a legacy BAAN IVb2 ERP system that had high system maintenance costs and risked turning the business unproductive or uncompetitive. They were planning to upgrade to a new ERP system but wanted someone with proven industry expertise to help them navigate their new ERP journey with ease. The process demanded critical competence and meticulous skill as the data from the multiple ERP Systems needed to be consolidated and kept synchronized with their data warehouse until the migration was completed and implemented successfully.

High maintenance costs of legacy BaaN ERP system
Need for ERP migration and website integration for smoother operation
Need for On Demand BI Optimization and Visualization
Large project requiring high level of functional and technical prowess
/The Solution

The MatchPoint Solutions (MPS) Team brought together cutting-edge resources with world-leading industry, process, and integration experience to empower the ITW team with the functional and technical expertise required for this project. Our Professional Services Team went on to implement a phased approach to support the ERP implementation while providing Business Intelligence Optimization Services in parallel.

On-Demand Data Optimization, Visualization, and User Empowerment

MatchPoint Solutions leveraged the Data Warehouse to generate custom SSRS and Microsoft Power BI reports based on the priorities established by ITW. We also set up the needed security credentialing with support from ITW IS. This process was initiated with respect to the current Back Order Report for Paslode. As Baan data was imported and validated as part of Phase 1, we created reports using this data for the users.

Since the existing Baan ERP system was an outdated and unstable system, we worked with ITW to create a data extraction process. We began with fully understanding their requirements and their Baan source data, and went on to designing the ITW Data Warehouse data model and importing Baan data to the database using mappings.

Matchpoint Solutions managed the Data Warehouse Optimization effort by consolidating existing data from the multiple ERP Systems—Epicor 9, ROI, and Baan. This involved updating existing SSIS data packages pulling data into the Data Warehouse and creating packages to bring in data that was not currently being brought in. Then, ITW had multiple databases which were used to sync data from Epicor or ROI ERP systems. We consolidated the data and ERP system to help reduce cost and enable better manageability for the data infrastructure.

Upon consolidation of data from the three legacy ERP systems, we engaged with the ERP Vendor to perform a Data Mapping Exercise. Following that, we worked closely with the ERP Vendor to migrate Source Data to the selected ERP system. We managed the Database setup for the new ERP system on Azure, and created three environments for the new ERP system—Development, Test, and Production, managing the refresh for all three environments.

ITW had many websites which were hosted on different content management systems like Joomla, WordPress, Custom, and different hosting platforms. Many of these sites were using different E-commerce engines and catalog systems. Any update to any tool or part had to be done manually in all these sites. We helped ITW stabilize and migrate all the websites to Azure. Following that, we created the integration and the needed update protocol to have the websites reflect the most accurate information from the underlying source ERP tables and other data sources.

Results

/Client Profile

About ITW

Illinois Tool Works Inc. or ITW is an American Fortune 500 company that produces engineered fasteners and components, equipment and consumable systems, and specialty products. Today, it employs nearly 65,000 people in hundreds of businesses across 58 countries, and is based in Glenview, Illinois, a suburb of Chicago, Illinois.

Global industrial company ​

Differentiated business model​

Founded in 1912​

Based in Glenview, Illinois​

/WHAT WE OFFER

About MatchPoint

We are quick, thoroughly expert, and offer in-depth domain knowledge and cutting-edge digital transformation solutions.

Shortest turnaround time

A nimble team of expert engineers and UX designers

Innovative digital solutions for all platforms

Industry-leading Data Warehousing and BI Reporting

case-studies-img

Equinix

MatchPoint helped Equinix quickly expand their ServiceNow team and systems to boost the throughput of automations and customer service capabilities.

case-studies-img

Blaize

MatchPoint Solutions helped Blaize upgrade their infrastructure from aging Active Directory Servers and move to the cloud, enabling external user access, centralized identity management, and single sign-on capabilities for their applications.

case-studies-img

Sephora

MatchPoint Solutions helped Sephora quickly size up their ServiceNow team and systems to increase their throughput of developing new automation and strengthen their customer service.

case-studies-img

Salesforce Development

MatchPoint Solutions helped an energy major quickly scale their Salesforce team and systems to increase the throughput of developing new automation and strengthen their customer service.

case-studies-img

RoundlyX

MatchPoint Solutions helped RoundlyX redesign their entire user experience across mobile and web and implement the new application platforms within just 6 months.

case-studies-img

AltoIRA

MatchPoint Solutions provided AltoIRA with product design, architecture, and development expertise to help them white label their CryptoIRA and offer it as a service to other IRA companies.

case-studies-img

Blue Studios

MatchPoint Solutions helped Blue Studios design and implement their new marketplace, offering a superior user experience and excellent instructor-analytics tracking for the administrators.

case-studies-img

ITW

MatchPoint Solutions brought in industry-leading functional and technical expertise to ITW to help them upgrade their outdated and unstable BaaN ERP systems to a new consolidated ERP system, and enable a website integration post a seamless migration of the multiple existing sites to Azure. This sign.....

case-studies-img

Accel Partners

MatchPoint Solutions helped Accel Partners redesign their website for superior usability and performance across devices and migrate their application to the cloud with ease.

case-studies-img

API Management and Migration

A global mobility-as-a-service provider executed a complex migration of over 400 APIs over a brief course of six months resulting in superior application performance and user experience with the help of skilled experts from MatchPoint Solutions.

case-studies-img

Service Now Support

MatchPoint Solutions helped our customer quickly size up their ServiceNow team and systems to increase the throughput of developing new automation and strengthen their customer service.

case-studies-img

Product Engineering and Design

A team of six engineers and UX designers from MatchPoint had OS-agnostic apps conceptualized, built, and deployed in the client's App Ecosystem in less than 2 months, rapidly empowering them with new revenue opportunities in the pandemic.

case-studies-img

Robinhood

MatchPoint Solutions helped Robinhood scale quickly to augment automation capabilities and implement wider integration between their enterprise business systems.

case-studies-img

Palantir

Palantir significantly boosted the automation and integration implemented between their enterprise business systems enhancing their burndown of User Stories by 10x the previous throughput with quick, expert help from MatchPoint Solutions.

case-studies-img

Pandora

Pandora was able to modernize their 15-year old Salesforce system, eliminate dependencies, and empower their development team through successful migration with the help of MatchPoint Solutions.

case-studies-img

Cepheid | Danaher Corporation

Cepheid was able to migrate their on-premise datacenter to AWS, modernize the existing cloud resources, and effectively manage the workloads with deep cloud expertise and engineering support from MatchPoint Solutions.