SAP BW/BI consultant

Description

SKILLS

Consultant with over 11 years SAP BI solutions implementation. Strong knowledge of SAP BW architecture solutions and related technologies.
Extensive practical experience in systems integration and loading data from heterogeneous sources.
Project experience: 7 full cycle BI projects. Expert knowledge in SAP BO product line. Focus on manufacturing and retail industries.

TECHNICAL SKILLS
Data warehouse:
? SAP BW NW 7.0-7.5;
? SAP BW on HANA;
Reporting:

BEx reports.
SAP BO Web Intelligence;
Bex Analyzer & BO Analysis;
SAP BO Live Office; Visualization interfaces and dynamic reports:
SAP Design studio;
SAP BO Dashboards;
SAP BO Mobile;
SAP BO Explorer;
SAP Lumira.

ETL-tools:

SAP DataServices.

Main Skills

Other Skills

ABAP

Oracle Hyperion

Web Intelligence

systems integration

SAP BPC

Oracle Forms

data flows

SAP ERP

raw data

SAP HANA

databases

data loading

Crystal Reports

corporate data

MS SQL

ETL

SalesForce

SAP BI

SAP

Data warehouse

SAP BW

data mart

Oracle DB

Data Warehousing

Design Studio

Excel

Oracle

implementation of SAP

Web application

SAP BO

data flow

data marts

HANA

Hyperion

Work & Experience

01.07.2017 — 30.04.2018

international Real Estate company

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;

01.03.2017 — 30.06.2017

International Bank

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;

01.10.2016 — 31.03.2017

Big retail network

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;

01.05.2016 — 31.01.2017

International Production Company

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.

01.06.2015 — 30.04.2016

Retail Network

Lead Consultant SAP BI/BO

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.01.2012 — 31.05.2013

Lead consultant SAP BI/BO

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;

01.11.2010 — 31.12.2011

Energetics

Lead consultant SAP BI/BO

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;

01.11.2009 — 30.06.2010

Energy Provider (Utilities)

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;

01.05.2009 — 30.11.2009

Telecom Provider

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;

01.07.2007 — 31.01.2009

Metallurgy

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;

Attachments

SAPBW/BIConsultant