Mesh
CASE

Oracle

Oracle is an American corporation, the largest manufacturer of software for organizations, as well as a leading supplier of server equipment.
The company operates in the field of database management systems, middleware and business applications (ERP- and CRM-systems, specialized industry applications).

Problems received for solution:

  1. Setting up import/export and collecting real-time data from Oracle and converting it to a simplified format and storing it in database tables.
  2. Organization of uninterrupted data exchange and their updating via API.
  3. Collecting, storing and analyzing the received data for further processing and use.
  4. Attracting the capacities of Big Data to build a system of end-to-end analytics and generate configurable reports based on the received data at the request of the user.
staff
02

Staff

A ready-made team of specialists with rich experience in fast and high-quality implementation of projects of any complexity was allocated to close client tasks.

Team Lead
Manage a team of IT specialists, develop project architecture and code reviews.
DevOps Engineer
Development and automation of build processes and delivery of code from developers to production.
Project Manager
Organizing a team and workflow, collecting data from the client on the desired implementation of the portal and writing a technical task.
Imports/Exports developer
Working with databases and APIs, organizing dynamic data exchange and setting up import/export.
projects/iq-oracle.title5
Monitoring bugs in production: performing functional, integration and regression testing.
03

Completed work

Design
  • Collect project requirements
  • Creating a RoadMap for the implementation of a complex IT project
  • Writing terms of reference
DevOps engineering
  • Organization of the work environment for data import and export
  • Automate the processes of building new versions of the project, building reports and servers
Imports/Exports

    Import customer data:

  • Import data by customer addresses
  • Import product promotion data
  • Import customer metrics
  • Metric Aggregation Service Data Import
  • Import customer financial data
  • Import the client’s current balance
  • Import customer advance account status
  • Import customer total credit limit data
  • Import customer credit limit data
  • Import customer receivables data
  • Import past due customer receivables data
  • Import data on the date and amount of the next payment according to the schedule
  • Import contract number data to internal customer accounts
  • Import customer internal account numbers data
  • Import customer payment history

    Import Catalog Data:

  • Import product price data for customers
  • Import data on the balance of goods in warehouses
  • Import data on delivery dates for goods
  • Import product discount data
  • Import customer orders
  • Import customer price list data
  • Import product unit data
  • Import SKU Priority Sort
  • Import remaining goods

    Motivational program data import:

  • Import data on rewards for participating in motivational programs and performing services for clients
Testing

Functional, integration and regression testing of the operation of the SAP API Importer base module after database integration and import.

04

Results

01.

The base module API Importer is used as the basis for all imports, and contains routines and helpers such as basic import loops (iterative and custom) for a third-party Oracle system, configuration structures for all imports, models for import database tables, HTTP client for communication with a third-party Oracle system.

02.

The base module supports internal helper functionality common to all imports for interaction between them and the import manager, as well as for the Service - Discovery functions and promotion of Prometheus metrics.

 
03.

Maintain active work with the databases of the above systems, carry out integration on the specified tables and the information stored in them.

04.

Organization of uninterrupted data exchange via API in compliance with all security protocols in the field of digital data exchange and the use of asynchronous encryption technologies.

01.

The base module API Importer is used as the basis for all imports, and contains routines and helpers such as basic import loops (iterative and custom) for a third-party Oracle system, configuration structures for all imports, models for import database tables, HTTP client for communication with a third-party Oracle system.

02.

The base module supports internal helper functionality common to all imports for interaction between them and the import manager, as well as for the Service - Discovery functions and promotion of Prometheus metrics.

03.

Maintain active work with the databases of the above systems, carry out integration on the specified tables and the information stored in them.

04.

Organization of uninterrupted data exchange via API in compliance with all security protocols in the field of digital data exchange and the use of asynchronous encryption technologies.

Feedback

Submit your application

Get the best people to work on your projects at a relevant price

#THREESTEPS

Нам доверяют мировые корпорации, одна из которых компания L’Oréal, являющаяся лидером мирового рынка. Мы разработали инновационный комплексный проект в бьюти секторе.

#Цель

Привлечение трафика в категорию «уход за кожей лица» с целью увеличения средней корзины продаж.

#KeyVisual

Нами была предложена и реализована комплексная креативная маркетинговая концепция акции “3 шага”, включающая в себя 3 этапа ухода за кожей лица - очищение, увлажнение и маска. Мы разработали коммуникацию с клиентом за счет онлайн и оффлайн платформ с привлечением навигационных подсказок в роли интерактивного консультанта, который решает проблемы индивидуального подхода в бьюти секторе.

#Конструкция

Мы позаботились о том, чтобы покупательский трафик мигрировал в бьюти категорию “Уход за кожей лица”, с последующим увеличением средней корзины продаж. Был создан виртуальный 3D-полигон, включающий в себя рестайлинг островных конструкций, пристенных стеллажей, воблеров и стопперов. Разместили рекламное оборудование и нанесли навигационные подсказки для концепта прогноза продаж.