SAP BW/BI consultant

PROFESSIONAL EXPERIENCE
international Real Estate company  (United Arab Emirates)
07/2017 – 04/2018
SAP BW Architect
Project: SAP BW + SAP BO Full Cycle implementation. Remote and onsite work.
Project description:  BO reporting for Finance and Real estate modules, including all stages, starting from scratch using SAP BW on Hana 7.4 + SAP BO 4.2 
Responsibility:

• Business requirements gathering;
• Creation of technical specifications;
• Creation of data flows for FI and RE-FX areas in SAP BW based on HANA-optimized business content;
• Development of custom Bex queries with a complex logic using ABAP;
• Web Intelligence report development;
• Integration with SalesForce;
• Creation of Design Studio dashboards for “Leading Health Indicators” key figures.

Technologies:

• SAP BW 7.4 on HANA;
• SAP BO 4.2 Web intelligence;
• SAP Design Studio;
• SalesForce;

International Bank (Spain)
03/2017 – 06/2017
SAP BO Architect
Project: Creation of data warehouse. Remote work.
Project description:  The project assumed loading data from several external systems (Oracle DB, MS SQL DB, SAP HANA, Excel) and creation of Data warehouse for the reporting using SAP Data Services ETL. 
Responsibility:

• Integration with external databases;
• Creation of 3-layer model – raw data, staging, data mart;
• Creation of scripts for Data clearing, checking for a duplicate, checking for a data correctness.

Technologies:

• SAP Data Services 4.2;
• SAP HANA;
• ORACLE DB;
• MS SQL DB;

Big retail network  (Uzbekistan)
10/2016 – 03/2017
SAP BO Architect
Project: Full cycle implementation of SAP BO 4.2 based on SAP BW on Hana. Reports development. Remote and onsite work.
Project description:  The project assumed installation and setup SAP BO platform, integration it with SAP BW on HANA, development of 24 WEBI reports, 2 Design Studio dashboards with main KPIs and 4 separate Lumira dashboards for each department. 
Responsibility:

• Getting clarifications from the business;
• Development of the architecture of SAP BO (sizing, user groups and authentication models, integrations, report templates, SAP BW data flow structure);
• Development of the data model – extractors, transformations, cubes, etc. in SAP BW
• Creation of BEx and WEBI using Web intelligence;
• Creation of dashboards using Design Studio and Lumira;
• Creation of Composite providers and calculation views in SAP Hana.

Technologies:

• SAP BW 7.4 on HANA;
• SAP BO 4.2 Web intelligence;
• SAP Design Studio;
• SAP Lumira;
• SAP HANA;

International Production Company (Denmark)
05/2016 – 01/2017
SAP BW Consultant
Projects: KPI reporting, Orders overview. Remote work.
Project description:  

• KPI reporting - calculation of various performance key figures to measure the efficiency of production processes i.e. efficiency of employees, time efficiency, downtimes, the volume of production, etc. Data model based on ERP and MS SQL datasources.
• Orders overview – The reporting, based on ERP infosets, which shows the history of sales and billings orders.

Responsibility:

• Getting clarifications from the business;
• Creation of the infosets and datasources in ERP system;
• Development of the data model – extractors, transformations, cubes, etc.
• Development of the report using BEx Query/Web application Designers.

Technologies:

• SAP BW 7.3;
• MS SQL DB.

Retail Network: fashion industry (Russia)
06/2015 - 04/2016
SAP BO ?rchitect
Project: SAP BO implementation
Project description: The project involves the extraction of data from 1C platform, creation of corporate data warehouse based on MS SQL system, implementation of SAP BO  platform and realizing of reports
Responsibility:

• Development of  architectural solutions;
• Development of universes, the logical structures of the tables and reference relationships;
• Creation of different types of reports, including Webi reports, Design Studio dashboards and spaces in SAP BO Explorer;
• Geo analysis and mobile reports development;
• System support and development of documentation.

Technologies:

• MS SQL DB;
• SAP Data Services 4.1;
• SAP BO 4.2 Web intelligence;
• SAP Design Studio;
• SAP BO Explorer;
• SAP BO Universe designer.

One of the largest Retail Network (Russia)
10/2013 - 01/2015
Lead Consultant SAP BI/BO.
Project: SAP BW on HANA, SAP BO implementation
Project description: Implementation of a corporate data warehouse, development of analytical reporting SAP BI, SAP BO.
Responsibility:

• Creation and setup of data flow from SAP ERP, MS SQL and Oracle;
• Warehouse and data marts creation;
• Permissions model setting;
• BEx-reporting development;
• Webi-reporting and dashboards developing;
• Mobile reports development.

Technologies:

• SAP BW 7.4 on Hana;
• SAP BO Web intelligence;
• SAP BO Design Studio;
• SAP BO Mobile;

Large home appliances retail chain (Russia)
08/2013 - 09/2013
Lead Consultant SAP BI/BO.
Project: Corporate reporting “Business review”.
Project description: Development of corporate reporting using SAP BW on HANA and SAP BO.
Responsibility:

• Loading data from heterogeneous systems into SAP HANA using SAP BO Data Services;
• Coordination of models and reported data flows to the customer;
• WEBI-reporting based on SAP BW on HANA.

Technologies:

• SAP HANA;
• SAP Data Services;
• SAP BO Web intelligence;

Large Retail chain
05/2013 - 08/2013
Lead Consultant SAP BI/BO. Project: Corporate reporting.
Project description: Development of corporate reporting on BEx.
Responsibility:

• Development and coordination of specifications;
• Implementation reports of warehouse stock analysis;
• Development of mechanism control of receivables;
• Flows and SAP BW data model development;
• Creation of Bex-reporting.

Technologies:

• SAP BW 7.3;
• SAP BO 4.1;

Largest food retailer (Russia)
10/2012 - 02/2013
Lead Consultant SAP BI/BO.
Project: Billing and calculation of projects’ profitability
Project description: Creation of internal corporate reporting by mean of SAP BW 7.3 and SAP BI 4x.
Responsibility:

• Development of dashboards and webi-reports with details on the country, region and shopping complexes intended for regional directors in the sphere of sales;
• Creation of data flow SAP BW;
• BEx and WEBI-reports creation;
• Setup of integration SAP BW – SAP BO;
• Coordination of concepts and sketches of mobile screens;

Consumer goods production company (Russia)
01/2012 - 05/2013
Lead consultant SAP BI/BO. Project: BI/BO reporting.
Project description: Creation of new and modification of existing reports, dashboards and spaces in the fields of PP, SD, FI and bonuses.
Responsibility:

• Creation of new and modification of existing reports, dashboards and spaces in the fields of PP, SD, FI and bonuses.
• Development and customization of data flows SAP BW (extractors of ERP and flat files, creating transformations, MultiCubes);
• Setting permissions model SAP BW / BO, creating a single point of management roles in the systems;
• BEx-reports creation;
• Creation of Information Spaces SAP BO Explorer;
• SAP BI Migration to 4 and setting LifeCycle Manager.

Technologies:

• SAP BW;
• SAP BO;

• SAP BO Explorer;

Energetics (Russia)
11/2010 - 12/2011
Lead consultant SAP BI/BO. Project: Budget planning
Project description: implementation of process of budget planning and budgeting by mean of SAP BPC 7.0.
Responsibility:

• Implementation of process of budget planning and budgeting by means of SAP BPC 7.0.
• Analysis of methodology and architecture of the estimated process conducting in the system SAP BPC;
• Developing of budget planning and budget execution forms (BPC for Excel);
• Development of methodology and full cycle forms of making adjustments and approval of estimates;

Technologies:

• SAP BW;
• SAP BPC;

Energy Provider (Utilities) (Russia)
11/2009 - 06/2010
Lead of a project team.
Project description: development of an automated manager information support system which means a set of dashboards and analytical reporting in key areas of operation of business (PP, SD, HR, LO, FI).
Responsibility:

• Development of reporting forms and interactive analytical data displays (Webi, Xcelsius);
• Download and compilation of data from disparate sources (Data Services);
• Creation of BEx-reporting;
• SAP BO tweaking in order to serve a large number of users.

Technologies:

• SAP BW;
• SAP BO Web intelligence;
• SAP Data Services;
• SAP Xcelsius;

Telecom Provider (Russia)
05.2009 – 11.2009
06.2010 – 12.2010
SAP BI Consultant.
Project: Interactive dashboards for top managers.
Project description: Development of corporate reporting and dashboards in the fields of FI, P&L.
Responsibility:

• Development of corporate reporting and dashboards in the fields of FI, P&L;
• SAP BO-SAP BW-Hyperion integration;
• Development of methodology for interactive reporting, consulting of key users;
• Development of  reporting forms and data marts (Bex, Webi, Xcelsius, Live Office);
• ETL-loading data (Data Services);

Technologies:

• SAP BW 7.1;
• SAP BO 3.1;
• SAP Data Services;
• Oracle Hyperion DB;

Oil and gas industry (Russia)
01/2009 – 04/2009
SAP BI Consultant
Project: Pilot project of manager monitors
Project description: Creating a pilot project of dashboards of a leader in the implementation of Performance Manager and Xcelsius 2008 to demonstrate the capabilities of the platform.
Responsibility:

• Creating a pilot project of dashboards of a leader in the implementation of Performance Manager and Xcelsius 2008 to demonstrate the capabilities of the platform.
• Survey, analysis and description of business processes;
• Data Warehousing on a standard BW-content;
• Reporting forms development (BEx, Webi);
• Monitors of key performance indicators development by means of BO Performance Manager, Xcelsius.
• Development of documentation, user training.

Technologies:

• SAP BW 7.1;
• SAP BO;
• SAP Xcelsius;

Metallurgy (Russia)
07/2007 - 01/2009
Engineer – Programmer
Project: Balanced Scorecard
Project description: Support and development of project Balanced Scorecard based on BO XI R2.
Responsibility:

• Support and development of project Balanced Scorecard based on BO XI R2.
• Implementation and administration of BO XI R2;
• Reporting form development (Webi, Crystal Reports);
• Implementation of BSC toolkit by means of SAP BO Performance Manager;
• Oracle Forms development;
• ETL-data loading (Data Integrator).

Technologies:

• ORACLE DB;
• SAP BO XI R2;