Integration Archives - IBA Group - USA https://us.ibagroupit.com/tag/integration/ Wed, 31 Jul 2024 11:49:12 +0000 en-EN hourly 1 https://wordpress.org/?v=6.5.5 Corporate Data Warehouse for Bank https://us.ibagroupit.com/cases/dwh-bank/ Thu, 23 Jul 2020 11:30:21 +0000 https://us.ibagroupit.com/?post_type=cases&p=5316 The post Corporate Data Warehouse for Bank appeared first on IBA Group - USA.

]]>

Project Overview

The project was implemented to meet the following challenges:

  1. Design and implement a unified data warehouse based on the standard industrial model with a degree of customization up to 30 percent.
  2. Implement the algorithms of data upload from the accounting systems of the bank and external sources to the corporate data warehouse in line with the methodology of managerial accounting. To provide a possibility of performing adjustments.
  3. Implement the approaches of data cleansing and quality control, as well as business rule verification
  4. Build theme–based data marts designed to analyze general ledger data, loan portfolio, managerial accounting, and performance of the network of self–service banking equipment
  5. Implement a business glossary of banking terms
  6. Develop more than 90 scheduled reports covering the tasks of management reporting and reporting to the parent company and regulators.

Solution

IBA is working as a part of the development team. The IBA responsibilities include requirement analysis; application design; database design, application development; unit, functional and system testing; quality assurance; and support.

The first ten stages of the project were finished on time with excellent references from the customer.

The eleventh stage, namely the enhancement of the application is currently underway.

Project Results

The application was deployed to production in line with the schedule. IBA received excellent references from the customer.

The post Corporate Data Warehouse for Bank appeared first on IBA Group - USA.

]]>
Contracts processing automation https://us.ibagroupit.com/cases/pilot-rpa-ai-implementation-at-multinational-it-provider/ Fri, 18 Jan 2019 09:34:24 +0000 https://us.ibagroupit.com/?post_type=cases&p=4502 The post Contracts processing automation appeared first on IBA Group - USA.

]]>

Challenge

The customer aimed to test feasibility of a cognitive automation technology for its business processes. The pilot business process consisted in validation of the tax amount charged in a vendor contract. Tax rates vary for different groups of vendors and are defined in the customer’s database.

Process Requirements
  1. Achieve overall business process accuracy of 98 percent
  2. Reduce manual time spent on one process by 50 percent
  3. Train and support customer’s team to build automation for an SAP case.

SOLUTIONS HIGHLIGHTS

  1. Create an information extraction model for the fields vendor_name and cost, implement a predefined data storage with a list of vendors, and conduct an additional similarity check. Create a stamp detection model based on Tensorflow, Keras, and Open CV. Develop a script that locates a stamp in a document to help the business analytics team prepare a machine learning training set with 100 percent correctly marked data.
  2. Create five RPA nodes for MS Access automation using a desktop driver. As the database is encrypted, JDBC options are not applicable.
  3. Create a single RPA node for Skype automation with infinite reading of incoming messages to trigger the launch of the pilot business process.
  4. Develop an automatic tool to decrypt documents online.

 

Implementation

IBA Group acted as a subcontractor, working on the customer’s premises. The project was ongoing within 1.5 months.

IBA Group and the customer organized regular Q&A sessions to overcome language and cultural differences, transfer knowledge of RPA/AI technologies, drive SAP case development, and resolve issues with software and source code.

As the databases were encrypted in line with the customer’s policies, IBA Group developed an automatic tool that decrypts documents online using InfoCage FileSystem Shell.

Project Results

  1. Overall business process accuracy: 100%
  2. Reduction of manual effort: by 83.6%
  3. Average document processing time: 30 seconds
  4. Cognitive automation trained on 1,469 documents or 4,000 pages.

 

Ultimately, the customer’s development team built their own automation for an SAP case.

The post Contracts processing automation appeared first on IBA Group - USA.

]]>
Approver Maintenance Application (AMA) https://us.ibagroupit.com/cases/approver-maintenance-application-ama/ Thu, 17 Jan 2019 07:33:59 +0000 https://us.ibagroupit.com/?post_type=cases&p=4484 The post Approver Maintenance Application (AMA) appeared first on IBA Group - USA.

]]>

Project Overview

The project is aimed at the design, development, testing and support of the Approver Maintenance Application (AMA). The application is designed to streamline updates to the approval process for purchasing requisitions. AMA has been launched to provide an easy process to maintain data in our customer’s purchasing systems.

Solution

IBA is working as a part of the development team. The IBA responsibilities include requirement analysis; application design; database design, application development; unit, functional and system testing; quality assurance; and support.

The first ten stages of the project were finished on time with excellent references from the customer.

The eleventh stage, namely the enhancement of the application is currently underway.

Results

The application was deployed to production in line with the schedule. IBA received excellent references from the customer.

Project ManagerCustomer

Great job everyone! We are finally live!!! We would like to thank IBA for all you developed, your help and expertise. All IBA workers have been very eager to assist, extremely knowledgeable and very flexible, meeting our requests as they change. This has been such a positive experience for us and we truly value the relationship we have built with IBA thus far.

The post Approver Maintenance Application (AMA) appeared first on IBA Group - USA.

]]>
Assessment Tool for DB2 Support and Development https://us.ibagroupit.com/cases/assessment-tool-for-db2-support-and-development/ Thu, 17 Jan 2019 07:18:34 +0000 https://us.ibagroupit.com/?post_type=cases&p=4482 The post Assessment Tool for DB2 Support and Development appeared first on IBA Group - USA.

]]>

Project Overview

The goal of the project is to support a comprehensive assessment tool for DB2 product customers as well as enhance and develop the product itself. The product is designed to optimize efficiency of a DB2 database on z/OS.

Solution

The IBA activities include L2 Customer Support, L3 Change Team, and Test Team. Getting involved in the project more than six years ago, IBA Group developed strong partnership with client teams that are engaged in major product design and development. Presently, IBA is maintaining several major product releases.

Project Results

IBA is constantly improving product quality, reducing the number of customer complaints and field–opened APARs (Authorized Program Analysis Reports). The project has achieved quality targets set by the customer’s management. Users working with the assessment tool for DB2 product family describe their experience as pleasant.

The post Assessment Tool for DB2 Support and Development appeared first on IBA Group - USA.

]]>
Web Applications Production Support https://us.ibagroupit.com/cases/web-applications-production-support/ Wed, 16 Jan 2019 07:01:59 +0000 https://us.ibagroupit.com/?post_type=cases&p=4413 The post Web Applications Production Support appeared first on IBA Group - USA.

]]>

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.

Project Execution

IBA responsibilities include:

  • Functional requirements definition in collaboration with the partner’s business operations team and application owners
  • Application design based on the functional requirements in collaboration with the partner’s architects
  • Application development and unit testing
  • Processing of customer service requests assigned by the applications’ help desk. Based on the customer severity, IBA reacts to the requests for service within a certain time frame (e.g. 24 hrs, 3 days, etc.)

 

  • Interaction with customers to work out the details of customer requirements
  • Analysis and improvement of application performance
  • Based on the business and/or customer needs, development of applications’ enhancements
  • Ongoing applications’ administration
  • Updating the applications’ code to utilize new technology versions and testing the changes to produce new releases of the supported systems
  • Continuous study of new technologies and the possibility to apply these technologies in the supported systems

Project Results

IBA is providing remote support for customer applications on a daily basis. As a result, our customer achieved significant cost reduction and could focus its IT staff on problem areas and the activities that bring the greatest return.

Claudia CorinoDelivery Project Executive | IBM

I just wanted to take a second to thank the entire IBA production support team for the excellent service and support that you have provided on the Hitachi account over the past nine plus years. This was a highly successful project for us, and in many ways due in large part to the IBA teams creative and innovative contributions to Hitachi GST development. Thank you for your hard work and dedication over the years.

I want to wish the entire IBA team good luck with your future endeavors and hope we get the opportunity to work together again some day. It has been a pleasure working with the IBA team for the last nine years.

The post Web Applications Production Support appeared first on IBA Group - USA.

]]>
Material Procurement System https://us.ibagroupit.com/cases/material-procurement-system/ Wed, 16 Jan 2019 06:37:51 +0000 https://us.ibagroupit.com/?post_type=cases&p=4411 The post Material Procurement System appeared first on IBA Group - USA.

]]>

Project Overview

The project was designed to migrate the Material Procurement System (MPS) of our client to an up-to-date software platform. MPS is an IT system that supports all processes in the purchasing environment of our client.

Its features include:

  1. Process all customer requirements
  2. Provide purchasing agents with information about automotive markets, parts, suppliers, prices, and business terms
  3. Relieve purchasing agents from routine jobs
  4. Perform analysis and generate reports
  5. Calculate revenues and savings
  6. Generate cost structures
  7. Compare negotiation targets with actual business results
  8. Control negotiation progress between purchasing agents and suppliers.

 

The legacy system was implemented using the programming language Smalltalk from CINCOM. One of the challenges was the absence of documentation (functional specifications and documented test cases) for the legacy system. The task was to migrate MPS to Java 3-tier architecture and create up-to-date documentation (use-case model and documented test cases).

The new application needed to meet the following requirements:

  1. Use Java EE technology
  2. Provide the same functionality as the legacy application with additional functional features
  3. Function with the legacy database and be able to use the same database concurrently with the legacy MPS
  4. Provide multi–language support including hieroglyphic (Japanese).

Project Execution

The project started in December 2003. IBA Group responsibilities included detailed system analysis, application design, application development, functional and system testing, quality assurance, and warranty support.

Built on advanced technologies, MPS was developed using RUP methodology with full lifecycle supported by IBA. Given application’s complexity, IBA suggested using pure Java EE platform for migration. Special tools were integrated in the development and build processes to ensure that code satisfies all customer requirements.

 

An iteration approach with five releases was adopted for the project. Each release included analysis (reverse engineering from Smalltalk code); design and implementation; system, functional and acceptance testing; and deployment to production.

Environment

  • Programming languages: Java, Java script, XML, HTML, SQL
  • Application servers: IBM WebSphere v 5.1, IBM DB2 on zOS, IBM WebSphere MQSeries
  • Development environment: IBM WebSphere Application Developer v 5.1

Project Results

IBA Group efforts for the project amounted to 90,000 person-days. IBA delivered the project on schedule and in budget. In 2005, a complete migration release of the MPS application was deployed to production. Further MPS releases incorporated additional functional features in line with new Change Requests.

 

The figures below show statistic results of the project:

  1. About 800 DB tables
  2. More than 1,800 use cases
  3. About 8,000,000 lines of Java code
  4. About 30K Java classes
  5. More than 90 Change Requests during the migration phase, most of these introducing new functionality
  6. More than 3,000 concurrent users around the world (Germany, US, Brazil, and Japan).

The post Material Procurement System appeared first on IBA Group - USA.

]]>
Supplier Relationship Management Solution https://us.ibagroupit.com/cases/supplier-relationship-management-solution/ Wed, 16 Jan 2019 06:20:45 +0000 https://us.ibagroupit.com/?post_type=cases&p=4406 The post Supplier Relationship Management Solution appeared first on IBA Group - USA.

]]>

Project Overview

The Supplier Relationship Management Solution is built on the powerful SAP NetWeaver platform that allows for integration and coordination of personnel, information, and processes at all technological and organizational levels.

 

SAP NetWeaver facilitates interaction, harmonizes information, and provides comprehensive data analysis. Using SAP NetWeaver, it is possible to perform many processes in the background mode, exchange large and complicated documents, and automatically archive all operations.

Project Execution

IBA is implementing the project in close cooperation with the customer. The project is scheduled as a long-term one and is still underway.

The development process is built using a standard production cycle that includes the following phases:

  1. Analysis of requirements
  2. Design
  3. Implementation
  4. Testing

 

Environment

  • SAP ERP 2005
  • SAP SRM
  • ABAP
  • IDOCs
  • BADI
  • BAPI
  • USER EXIT
  • Enhancements
  • ABAP Webdynpro

Project Results

The customer’s affiliates adopt the SRM on an ongoing basis. To date, all European affiliates of our customer are utilizing the new system.

 

 The solution provides enhanced capabilities for supplier relationship management, resulting in time reduction, quality improvement, and higher transparency.

The post Supplier Relationship Management Solution appeared first on IBA Group - USA.

]]>
IBA Mobile Banking for Bank https://us.ibagroupit.com/cases/iba-mobile-banking-for-bank/ Tue, 15 Jan 2019 08:57:21 +0000 https://us.ibagroupit.com/?post_type=cases&p=4353 The post IBA Mobile Banking for Bank appeared first on IBA Group - USA.

]]>

IBA has implemented its Mobile Banking System in Bank. The IBA Mobile Banking enables holders of plastic cards issued by Bank to make payments and retrieve banking information via mobile phone, smartphone or PDA at any point of the world 24 hours a day.

To make a card account mobile, a customer only needs to install a corresponding application to his/her mobile phone. The Java application is a software shell for the IBA SMS Banking System providing a convenient intuitive interface to IBA SMS Banking services.

The user is able to:

  • Receive information about changes in the account balance
  • Perform payments for public utilities, mobile services, as well as services of internet providers and cable TV
  • Block the card in case of loss
  • Receive news and updates online via GPRS channel
  • Cancel SMS Banking service.

The post IBA Mobile Banking for Bank appeared first on IBA Group - USA.

]]>
Mobile Client for Document Workflow System https://us.ibagroupit.com/cases/mobile-client-for-document-workflow-system/ Mon, 14 Jan 2019 13:44:59 +0000 https://us.ibagroupit.com/?post_type=cases&p=4352 The post Mobile Client for Document Workflow System appeared first on IBA Group - USA.

]]>

KEY ISSUES

The goal of the project was to develop a mobile client to simplify processing and approving of documents at a large–scale organization. The client should be closely connected with a backend document workflow system based on IBM FileNet.

 

In addition, it should bring to end users new instruments for working with corporate documents, including operations in offline mode, a flexible business process model, and a comprehensive commentary mechanism.

Solutions Highlights

IBA developed a solution that performs the following functions.

  • Online and Offline Modes

Synchronization of documents and tasks between a server and a mobile client when internet connection is available. Users can work with documents on the mobile client even without internet connection
Integration with the server backend based on IBM FileNet
Encrypted data transport between the server and the mobile client
Intelligent document downloading mechanism with a possibility to download only a header or an entire document.
Background synchronization and synchronization on demand.

  • Documents and Tasks

Flexible integration with DMS Business Processes. Updates in the document flow path automatically reflected on the mobile client without code changes
Downloading of new documents from the server and uploading of user updates to the server during synchronization
Embedded viewer for attachments: MS Office , iWorks, PDF, RTF, and graphics
Support for linked documents.

 

  • Comprehensive commentary mechanism

Voice and printed comments
Comments as PDF annotations in the document body
Commentary history from previous users/iterations
Possibility to cancel decision before synchronization

  • Search

Real time search across documents on a mobile device
Advanced search on a mobile device and on the server.

  • Settings

The number of documents to store on a mobile device and the background synchronization frequency are configured in settings.

Environment

  1. iOS platform, the target device being iPAD
  2. xCode development environment (Objective C, C/С++, XML)
  3. Custom PDF annotation library.

Key results & benefits

The mobile client is integrated and synchronized with the corporate information system that is built on IBM FileNet. The user can download to his or her mobile all documents that require reaction and work with them anywhere, including in offline mode. It is possible to view the attached files or give comments, record audio comments, insert graphic comments in the document body or add handwritten notes. For graphic notes, a standard PDF annotation mechanism is applied.

 

In addition, the mobile client provides quick search across documents that are kept on the mobile device or server, allows users to mark documents as favorite, and provides quick access to them.

The post Mobile Client for Document Workflow System appeared first on IBA Group - USA.

]]>
Bank Automates Document Processing https://us.ibagroupit.com/cases/bank-automated-document-processing/ Fri, 11 Jan 2019 09:06:48 +0000 https://us.ibagroupit.com/?post_type=cases&p=4212 The post Bank Automates Document Processing appeared first on IBA Group - USA.

]]>

KEY ISSUES

To prepare financial reporting, the bank’s employees process 500 types of files. The data in the files is the same entity when it is loaded into the corporate system, but is called differently.

The goal of the project was to reduce manual processing of documents to standardize the data. At the beginning there are only a few experts who know where and what data to retrieve.

Talk to our finance and banking experts

Solutions & Key Results

The process is automated by 90%. 98% of data are extracted automatically with 96% accuracy. The figures are growing as the robots are constantly trained on “historical data”.

The post Bank Automates Document Processing appeared first on IBA Group - USA.

]]>