• Participation in pre-sales activities:- Development of the concepts of the Data Platform- Designing the functional and technological architectures of the Data Platform for various customer segments- Participation in the preparation of presentations- Research of various software systems• Consulting on the design of big data platforms• Preparation of training materials on introduction to big data• Designing the new analytical platform of the United Credit Bureau. The plaform is intended to realize and provide different production services like scoring, triggering and benchmarking to the Bureau clients in the near real-time mannerThe analytical platform is intended to run under control of RedHat OpenShift platform. Technical stack consists of the following frameworks and systems:- Red Hat OpenShift (Container Platform)- Apache Cassandra (Distributed NoSQL Database)- Apache Flink (Distributed Data Streams Processing Framework)- Apache Kafka (Distributed Message Broker)- Apache Hadoop (Distributed Batch Data Processing and Storage)- Ceph (S3 compatible Object Storage)

Functional analysis of IT systems and organizational interaction. Consultations regarding hardships of Business Intelligence and Data Warehouse implementation.

• Formation of bigdata platform integration department within bigdata division• Department functional organization• Participation in the design of technological and functional concepts and architecture of the integration layer• Participation in the design of data layers to build a Data Lake• Participation in the development of data quality control methodology• Control the development of batch and streaming loading mechanisms• Organization of the support function of loading and unloading data

• Oracle to Hadoop replication routine developmentDeveloping utility to reduce high load on Oracle database based data warehouses. The main goal of the tool is periodical determining of changed segments and replicating them concurrently onto Hive database of Hadoop cluster.• Working Capital implementation projectManaging a team of subcontractor during implementation of Russian OpCo unit of global Wroking Capital project. Working-out of common structure and architecture of OEBS's data providing process.• BusinessObjects integration to OEBSInvestigation of technical aspects of integration. Preparation of documents on integration architecture and Oracle development specific requirements. As a future step of analytical reporting evolution I am investigating technologies of separating analytical data from OEBS operational data, i.e. preparation to Data Mart implementation - capture of data change and on-line aggregation. • Integration of joint companies’ systems to OEBSInvestigation of integration solution using Informatica PowerCenter platform. Design of integration architecture documents. Development prototypes of integration routines based on Oracle Advanced Queueing technology. Training Informatica PowerCenter team members to work with Oracle queues and OEBS specific API usage.• Self-implemented tracking systemDesign and development of change tracking system for internal usage within OEBS implementation devision. The system is built on Oracle APEX technology, based on abstract model, extendable by end-users using similar to OEBS Flexfields routines.

Calculation module is built on Oracle database server and consists of two parts:• distribution routines• control routines of distribution, export from Oracle and import to analytical system processesDistribution of Expenses conforms to hierarchical model designed by end-user and produces hundreds millions data records. To achieve optimal performance a processes tree based on the model is built. These processes work concurrently under control of the coordinator process.

• OEBS implementation at KarTelDesigning architecture of development approach to same-code base (universal code while different setup) for different installations of Vimpelcom’s and KarTel’s OEBS instances to simplify development of common system extensions. Technical leader of development implementation and data migration of financial modules.• OEBS regional rollout projects at VimpelcomArchitectural design and partial implementation of seed data migration infrastructure. Development of account payables and general ledger data migration routines.• Third line support of OEBSProblem solving, bug fixing, development of new functionality and reports according to business requirements. Maintenance of Service Requests to Oracle Support service.• Cramer OSS implementation at VimpelcomAt the initial phase of the project, assisting in planning of the configuration and installation of Oracle products stack of Cramer platform.

• Jail Management System (JMS) is a part of Mississippi Automation System Project (MASP)Scrutiny of the background and causes of the project and designing architectural and UI requirements. Design of the object model of the system compliant with Global Justice XML Data Model (GJXDM). Design of logical and physical data model of the backend site. Guidance of the system’s development team.

• Development of Service Inventory SystemDesign of database model of the system. Development of Oracle database routines to communicate with Weblogic java based middle tier. Analysis and training java team to Oracle specific JDBC features to improve system performance.• Development of KOFA systemInitially, development of Oracle database server-side routines and stabilization of the system functionality. Afterwards as a technical manager and architect I managed issues and designed several major releases including integration of KOFA into YellowNet electronic payments system and SAP/R3.• Development of TAX systemInitially, development of server side functionality of this Oracle database based client-server system and overall technical management of the consequent evolution of the system afterwards.