avatar

SAP BW/BI consultant

Score
100%
Experience:
13 y
Score
100%
Experience:
13 y
Location:
197000 Saint Petersburg
Last update:
19.04.2021
Register to Contact Freelancer
Available
Onsite hourly: N/A
Remote hourly: N/A
English: Advanced
Russian: Native
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.
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
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;

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