BACKGROUND

Our client is a tire manufacturer with a robust presence in Europe, the Middle East, and Africa, and is distinguished by its commitment to advancing tire technology. The client required efficient management of their corporate revenues and expenses.

CHALLENGES

• Development of the existing budgeting system on Oracle Hyperion Planning 11
• Migration to SAP Analytics Cloud Planning

SOLUTION HIGHLIGHTS

• Design and development of new calculation rules and data entry forms.
• Loading data from SAP and other sources.
• Daily monitoring of the system.
• Monitoring the correctness of the calculations.
• User support in different regions of Europe.
• Transferring the business logic to a new solution based on SAP Analytics Cloud Planning.
• Using REST API for data access.

KEY RESULTS

1/ Forms, calculation rules, measurement elements and more have been updated.

2/ Reduced by one-third the number of incidents related to:

• Proactive work with users
• Optimizing ETL processes

3/ A qualified team with competencies in Oracle Hyperion Planning 11 has been created.

4/ A working prototype of the solution has been created through SAP Analytics Cloud Planning in close collaboration with the customer’s team.

Challenges

1. Implementing data processing techniques and methodologies to calculate pivotal KPIs
2. Interactive Dashboard redesign on the QlikSense platform, to provide intuitive insights for stakeholders
3. Ensuring that the data solutions not only met the operational needs but also adhered to stringent pharmaceutical regulations
4. ETL design and implementation data integration into the global DWH solution
5. Implement streamlined data processes

Goals

1. Create a centralized data solution with Data Lake for CRM and merchandising data
2. Redesign sales activity, product visibility and distribution dashboards for finance analytics and managers for future optimal purchases

Results

1. By centralizing and streamlining data, the pharmaceutical company derives x2 quicker insights from clinical trials
2. Improved product visibility and placement
3. Consolidated data system facilitates easier and more accurate reporting, ensuring compliance with global regulatory standards
4. Automated and enhanced control of merchandising activities by identification of planogram compliance issues
5. No more time wasted searching for data across multiple systems. Our teams could now focus on analyzing the data and deriving actionable insights
6. The client benefits from significant cost savings in terms of both infrastructure and manpower

Challenges

1. Implementing data processing techniques and methodologies to calculate pivotal KPIs
2. Raw Data Warehouse (RDWH) used traditional on-premises infrastructure for its extensive data needs. It had a three-tier overloaded database system
3. A performance issue involved with creating an environment for application testing, as data cannot be easily or quickly copied from production to test
4. Costly hardware and software licensing
5. Interactive Dashboard redesign on QlikSense platform to provide intuitive insights for stakeholders

Goal

Create a platform to encourage self-service analytics and efficient data-driven decision processes

Results

1. Costs have been reduced by 30% annually
2. An improved user experience that refined data querying and exploration through a web Ul
3. Enabled data scientists and other programmers to leverage Snowflake’s scalable processing power to run AI/ML algorithms efficiently
4. Using Snowflake in the Cloud enables faster and easier recovery in case of a technology-related outage
5. Empowered users with self-service analytics, enabling them to explore and analyze data independently, uncover insights, and make data-driven decisions
6. System scales based on demand. This means reporting is no longer affected or delayed due to spikes in system demand

Challenge

Support, development, and enhancement of the ChelPipe IBM Maximo system in compliance with the requirements of the customer.

Solution

• Preventive and corrective maintenance
• Inventory management
• Service request management
• Reporting
• Integration with the corporate accounting system

Result

• Level 2 support
• Incident resolution
• Implementing changes upon request
• Development of new functionality
• Personnel training

Background

The customer is a retailer of upholstered furniture. Employees regularly receive extensive lists of products: furniture with a description, reference number and price. They need to update the prices of these products in catalogs and stores across different regions. This needs to be done in the web application and in the mainframe. Previously, about 10 employees made all changes manually: they copied data from spreadsheets and published it on websites.

Business Challenge

Automate the updating procedure and save time of company employees for more important tasks.

Solution highlights

The procedure was automated on the EasyRPA platform. Now employees only prepare the initial spreadsheet and upload it to Google Drive folder. The robot monitors the folder every 20-30 minutes. When it extracts the data, it navigates the web applications and the mainframe and inserts the new prices in the right places. At the end, the robot submits a report to the manager with the results.

Project results

Now the solution is being prepared for putting into commercial operation.

BUSINESS CHALLENGE

Develop an application to analyze photos made by a drone while flying over rice fields. Count the number of plants that have sprouted on the plots in the photo.

SOLUTION

The IBA Group team implemented image processing algorithms to accurately calculate the number of objects located on them. For end users, we created an application that processes photos, determines the number of plants on them and generates reports in *.csv and *.pdf formats.

Application algorithm:

• Create a polygonal image of the region of interest.
• Download satellite image for it (requires Internet connection).
• Take a calibration photo (taken at the desired measurement height containing two highly visible objects placed on the ground at a distance of 1 m from each other).
• Take a photo above the field for measurements.
• Perform calibration procedure using the calibration image.
• Generate report.

OUTCOME

Thanks to the application, the customer can receive reliable information about the state of rice fields using drones. The project is continuously improving.

Business challenge

Automate the processes of recognition and validation of documents.

Solution

The Company processes lots of orders and contracts every day, most of which are in paper form. There are four different types of orders/contracts. All of them must be entered into the system, validated in other systems and supplemented with new data. Previously, this was done manually by operators.

IBA Group experts took part in the development of a system that automated these processes.

Result

The customer received a system that uses OCR to automate the recognition of four types of contracts. In addition, robots were created to validate documents and obtain additional data.

Business challenge

Migrate the existing procurement management system servicing the manufacturing processes of the automotive manufacturer to the Java platform with subsequent support and development of new system.

Solution

With the support of the customer, IBA Group experts migrated the procurement management system of the automobile group of companies from the SmallTalk platform to the Java platform. At the same time, the project documentation was restored using the code to describe functional behavior of the system. In the period from 2003 to 2005, the IBA Group team reached 100 people.

Since 2005, the IBA Group team continued to support and to develop the new system. During this period, at the request of the customer, modifications were introduced to the system that were required by constantly changing business environment: the opening of new plants, the creation of production sites in new regions, changes in the economy and legislative framework, the development of cooperative relations with other manufacturers of automotive equipment, changes in the customer’s internal processes. Technical changes related to the evolution of the Java platform have also been implemented.

Result

Between 2003 and 2005, the IBA Group team migrated the existing system to the Java platform with a complete replacement of the system in commercial operation with a new system.

Since 2005, the IBA Group team has implemented more than 900 requests for system changes due to new business requirements.

The system is implemented in all customer factories around the world. The total number of system users is about 50,000 procurement specialists.

Business Challenge

Migrate existing functionality from the old customer portal to the new Hybris platform.

Project Overview

IBA provides support for a number of customer applications including:

1. Extranet n-Tier B2B application designed to automate the development of distribution programs allowing our business partner to manage the growth in demand within a distribution channel. As a result, both internal and external users (customers) are able to utilize and process efficiently the data that are distributed between various sources.
   Internet n-Tier B2C application designed to provide warranty support to the users of our partner’s hardware.
2. Extranet B2B web application that supports warranty returns by OEMs, distributors and resellers (Return Material Authorization). The application is ultimately flexible and easily customizable to the needs of each specific user.
3. A number of intranet applications that perform a range of functions for more than 18,000 users worldwide. These are applications like company-wide employee directory, employee CADP (Contribution Assessment and Development Plan) tracking, hardware deployment tracking, and etc.

All extranet and internet applications are implemented using the MVC (Model Viewer Controller) model. The front-end of the systems is using JSP, Java Servlets, DHTML, and Struts technologies and is hosted on IBM WebSphere four server cluster. The business logic is implemented using the EJB. Data between different application tiers flow in XML format using IBM MQSeries (JMS) as transport. IBM DB2 UDB cluster is used as a data storage system. The system interacts with SAP R/3 as a back end. All intranet applications are built on Vignette Application Portal.