Project • SAP BW integration with the bank's IT ecosystem Tasks: • design and coordination of technical solutions • integration with HCP S3 (similar to Amazon AWS) (implementation on ABAP of the protocol for interaction with HCP S3) • integration with Apache Kafka (integration with SAP PO) • retraction flow from SAP BW to HCP S3 • data extraction flow in SAP BW from Kafka

Project • Business planning project for the retail business unit Tasks: • SAP BW data warehouse modeling • planning (FOX, ABAP) • development of HANA objects • development in ABAP language (User-Exit, BADI extensions) • reporting (SAP BEx + SAP Analysis for Office 2.7)

Project • Reporting block for the AutoCAPEX project Tasks: • SAP BW data warehouse model and data flow from S4 • development of new and expansion of existing data sources from S4 • development of HANA objects • reporting (SAP BEx + SAP Analysis for Office 2.7)

Project • Block of corporate reporting (blocks SAP SD, SAP MM) Tasks: • SAP BW data warehouse model and data flow from S4 • HANA DB model • reporting

Project: • AS SPOD Development environment: SAP BW Development tools: SAP BW, ABAP. Tasks: • modeling • ABAP development (SAP GUI dynpro App)

Project: • IFRS transformation Development environment: SAP BW, SAP ERP Development tools: SAP BW, BI/IP, ABAP, Analysys for Office, VBA. Tasks: • adaptation of methodology (alignment with SAP architecture) • approval of the design solution: • modeling, data flows, data extraction, reporting; • ABAP development • planning (FOX+ABAP) • reporting by means of Analysys for Office Project: • Data collection subsystem of subsidiaries Development tools: SAP BW, ABAP, ABAP WebDynpro. Tasks: • development of specifications for the hidden markup format in Excel documents • approval of the design solution; • modeling; • ABAP development of web applications using the ABAP WebDynpro framework.

Industry: Mining and processing plants, full-cycle production (metals, alloys, rolled metal products). Projects: • Analytical reporting on the SAP PS module. Development environment: SAP BW, SAP ERP, HANA DB Development tools: SAP BW, ABAP,. HANA Developer Studio (Graphic CV, SQL Script CV, CDS). Tasks: • refactoring; • approval of the design solution: • modeling, data flows, data extraction, reporting; • online reporting in S/4 HANA on CDS; • integration testing; • user training; • counseling; • ABAP: development; - extractors, User-Exit variables; - extractors on CDS + CalcView

Industry: Trade. Hypermarket chain Projects: • Integration of Globus SAP Retail and Globus DWH (MSSQL) (full cycle). Development environment: SAP BW, SAP ERP Development tools: modeling in SAP BW, ABAP, SAP .Net Connection Library, Visual Studio (C# client). Tasks: • Coordination of the scope of the project with the customer and Globus Competence Center • Writing specifications and documentation of development • ABAP development • Functional testing of ABAP developments within the project. • Activate standard data extractors in SAP Retail • Develop custom data extractors in SAP Retail • Develop objects for storing and processing data in SAP BW • Develop tools and libraries for data retraction from SAP BW to the Win64 platform (not OpenHUB). • Integration testing

Industry:  Network of consumer electronics supermarkets, e-commerce Projects - Automation of sales planning and procurement planning of CD (full cycle) Development environment: - SAP BW, SAP BI/IP, SAP BO Analysis for Office, HANA Developer Studio Development tools and languages: - Modeling SAP BW, Integrated Planning, ABAP, HANA modeller, HANA SQL script, VBA for Excel. Tasks: • Development and approval of the specification of CCD objects within the framework of the project • Consulting the project team within the competence (BW, ABAP, Hana) • Development within the framework of the project of tools for building a sales forecast for the year • ABAP development (User-Exits,BADi,Web Dynpro) • Integration testing

Industry:  Supermarket chain, multi-brand Projects - SAP BW 7.30 Oracle migration to 7.40 Oracle - SAP BW 7.40 Oracle migration to SAP BW 7.40 on HANA Tasks: • Transfer to platform 7.40 on HANA ABAP of developments containing native Oracle SQL and PL/SQL code

Industry:  Nuclear industry Project QCD (SAP BW) Tasks: • SAP BW methodology • Examination of contractors' solutions on SAP BW topics • Design of new and expansion of existing facilities of the KCD. • Development on change requests, incident handling (reporting to BOBJ)

Industry:  Petrochemical industry Project SAP BW reporting Tasks: • Development of SAP BW reporting • Design of new and expansion of existing facilities of the KCD.

Industry:  Trade (products) Project Support for "SAP BI on HANA 7.40" Tasks: • Development of new functionality in accordance with RFI (full cycle).

Industry:  Trade in consumer electronics Project SAP BI on HANA 7.30 Tasks: • Development of new functionality in accordance with the TOR (full cycle). • Modeling on HANA DB, integration of HANA DB - SAP BW. • Submission of OSS for SAP based on the results of error analysis. • Advising the internal SAP BW development team.

Industry:  Trade in consumer electronics Project "Migration of SAP BI 7.01 to SAP BI on HANA 7.30" Tasks: • Transferring SAP BI 7.01 DW objects to SAP BI on HANA 7.30, copying data, setting up extractors to external systems, setting up parallel staging at the pilot stage, developing tools for daily data reconciliation in two systems. Setting OSS for SAP based on the results of error analysis, using SAP Notes. • Maintenance of an existing SAP BI 7.01 solution • Development of new functionality for TK. • Documentation.

Industry:  Oil and gas sector Project Management reporting as part of SAP R/3 implementation at TNK-Industries Tasks:  Making changes to the data warehouse (creating new data warehouse objects, expanding 2LIS extractors, creating transformations, changing existing transformations)  Reporting using SAP BW (Bex, MS Office, VBA)  Development and planning of data loading scenarios  Documentation

Industry:  Energy Project: Purchase price planning Tasks:  Project activities (analysis of functional requirements, writing technical specifications, design, coordination of solutions with the customer, presentations, meetings, work planning)  HD design  Purchasing data extraction from R/3 (2LIS* extractors)  Import of data from suppliers' offers for bidding from 1C (ABAP program)  Material purchase price planning format (BI/IP, Excel, VBA)  Decision on planning regulations (approval of adjustments, STS, decision to eliminate blocking, customization tables, reference books)  Application for maintaining master data (ABAP Web Dynpro)  Setting up planning applications in the SAP NW portal  Reporting using SAP BW (Bex, MS Office, VBA)  Documentation

Industry:  Banking activities. Project: Reporting on the control of the approval of contracts Tasks:  Analysis of the current state of work on the project (CD, extractors, calculations, reporting)  Decision on HD architecture  Data extraction from R/3 (extractors of master data, transactional data from R/3)  Calculations of the parameters for negotiating contracts  Reporting by means of SAP BW (Bex, MS Office, VBA).

Industry:  A large retail network of mobile communication devices (more than 4,000 outlets) Project: Extending the functionality of the SAP BW 3.5 module. Tasks:  Expansion of the data warehouse in accordance with the TOR.  Data extraction from SAP R/3, SAP XI/PI – all stages of development.  ABAP reports with OLAP BAPi (MDX query).  Extending bex functionality with virtual features and indicators (ABAP).  Sales planning (SAP SEM/BPS).  Setting up SAP BW Precalc Server.  Creation of corporate reporting of investment planning within the framework of the project using SAP BW (Bex, MS Office, VBA).  Work on incidents (support)  Employee consulting.

Industry:  Transport Project: Investment planning within the framework of the Russian Railways financial resources management project. Tasks:  Creation of corporate reporting of investment planning within the framework of the project using SAP BW (Bex, MS Office, VBA).  Making changes to the structure of the data warehouse.  Employee consulting.

Industry:  Large household appliances retail chain Project: Maintenance and refinement of the SAP BW module as part of the SAP R / 3 implementation project, optimizing the performance of the reporting system on large amounts of data. Tasks: Functional scope of the project:  Data warehouse (SAP BW), analysis and modification  Refinement of reporting in accordance with the needs  Data extraction from R/3, SAP XI, PIPE. Organizational scope of the project:  Parent company;  More than 500 users. Functions performed:  Refinement of data warehouse, expansion of existing and creation of new info-objects, expansion of extractors;  Performance optimization, monitoring.  Development of new and improvement of existing reports using SAP-BEX;  Development of mdx queries for data import from SAP BW to other systems via OLE DB connection.  Development and planning of scenarios for daily data loading.  User support;  User training.

Industry:  Oil and gas sector Project: Development of budgets and formation of management reporting for a group of companies. Tasks: Functional scope of the project:  Enterprise planning (SAP SEM-BPS);  Data warehouse (SAP BW). Organizational scope of the project:  Parent company;  50 subsidiaries;  More than 2000 users. Functions performed:  Development of reports using SAP-BEX;  Testing and modification of reports;  User support;  User training;

Industry:  Oil and gas sector Project: Development and formation of management reporting for a group of companies as part of the implementation of the SAP HR module. Tasks: Functional scope of the project:  Data warehouse (SAP BW).  A set of workbooks and Bex queries.  A set of roles to differentiate access to data. Organizational scope of the project:  Parent company;  50 subsidiaries;  More than 200 users. Functions performed:  Refinement of the data warehouse in accordance with the requirements of the customer;  Development of reports using SAP-BEX;  Customizing the access control system based on SAP BW roles and security objects.  Testing and modification of reports;  User support;  User training;