Sergii Zobov
Born **.**.**, citizen of Ukraine
Work authorization: USA, Ukraine
E-mail: adt7ux@r.postjobfree.com
Cell Phone: +1-786-***-****
SAP HANA/BI/BW consultant with more than 15 years of professional experience SAP BI 7.* components (incl. BW on HANA, native HANA XS XSA). Gained experience in the full project lifecycle from project preparation, business analysis, design and development through to implementation and support along with all project activities. BI courses instructor at SAP information center.
Consulting area
SAP HANA XSA, SAP BW/4HANA, SAP BW on Hana, SAP BO,
, SAP BI architect, ABAP Development
Skills
Technology of business warehouse (SAP HANA XS XSA, BW/4HANA, BW on HANA), create Calculation View, CDS, Table Function, HANA AMDP class, data extraction/retraction from SAP- system and non-SAP system, process chains, data model development, integration, etc.;
Warehouse administration and performance optimization;
SAP HANA modelling, HANA XSA, SLT;
Reporting tolls: SAP BEx Analyzer, BO Web Intelligence, SAP Analysis for Office;
Strong programming skills ABAP (ALV, SMARTFORMS, SAP Script, OOP, Shared Memory Object), SQL, VBA;
BO 4.x Universe modelling with IDT/UDT;
SAP Experience
Customer NDA
Duration 01.2022 –
Area Reservation and accommodation worldwide service Project Description Migrate SAP BW data models and SAP HANA Project Role Senior SAP BI Consultant
Performed Tasks
Migrate and redesign existing SAP BW and SAP HANA
model to new SAP HANA XSA platform
Developed SAP HANA XSA Calculation View, table
function.
Design Tableau reports
Page 2 of 7
Customer NDA
Duration 01.2017 – 12.2021
Area IT
Project Description Migrate SAP BW data models to SAP HANA Create corporate reporting system SAP ВО (4.x)
Project Role Team lead SAP HANA/BI/BO
Performed Tasks
Migrate and redesign existing SAP BW data models to SAP HANA model.
Design of corporate reporting system SAP ВО (4.x) Analysis for Office reports.
Integration of external source system HCM with SAP BW Responsibility and coordination of BI teamwork
Developed SAP HANA Calculation View, table function, WEBI, Analysis reports
Support and development of ETL processes (AMDP scripts) Customer Lenta (www.lenta.com). Retail
Duration 01.05.2016 – 12.2016
Area Retail
Project Description Integration corporate data warehouse BW 7.4 with external system CRM Siebel.
Project Role SAP BI/HANA architect
Performed Tasks
Integration corporate data warehouse BW 7.4 with external system CRM Siebel. Design and development of integration architecture and structure of the data model, ETL process, developed SAP HANA Calculation View.
Customer
DTEK http://www.dtek.com/en/
Duration 01.12.2014 – 04.2016
Area Generation energy
Project Description Integration corporate data warehouse BPC & SAP ERP (CO, MM, FI, SD, PP). Design and development of integration architecture and structure of the data model
Project Role Senior Consultant BI/ABAP SAP BI architect Performed Tasks
Design and development BW(7.4) data mode, . Data integration, ETL processes, standard data sources extension, ABAP programming.
Page 3 of 7
Customer
JSC Gazprom, Russia, Oil and Gas
http://www.gazprom.ru/
Duration 01.05.2014 - 01.12.2015
Area Oil and Gas
Project Description Integration corporate data warehouse with 15 different source systems. Design and development of integration architecture and structure of the data model.
Project Role Senior Consultant BI/ABAP SAP BI architect Performed Tasks
Design of system architecture, Blueprint documentation. Data integration, ETL processes, standard data sources extension, ABAP programming.
Customer
JSC Gazprom, Russia, Oil and Gas
http://www.gazprom.ru/
Duration 01.07.2013 - 01.05.2014
Area Oil and Gas
Project Description Design and implementation of Corporate system for Monitoring key performance indicators at mobile technology iPad
Project Role SAP BI architect Senior Consultant BI/ABAP Performed Tasks
Creating data source (ABAP web-services), design data model BW 7.3
Customer
SGC (http://www.sibgenco.ru/)
Duration 01.02.2013 - 01.07.2013
Area Generation energy
Project Description Implementation and support of SAP BO 4.0 SP4 Project Role Senior Consultant BI/ABAP
Performed Tasks
Creating reporting system on SAP BW 7.3. Optimization data model asset accounting in SAP BW
Page 4 of 7
Customer
Lenta (www.lenta.com). Retail
Duration 01.03.2012 - 01.10.2012
Area Retail
Project Description Implementation and support of SAP BO 4.0 SP4 Project Role SAP BI architect
Performed Tasks
Creating SAP BO 4.0 reporting system on SAP BW 7.3. Optimization data model SAP BW.
Customer
Severstal PBS Coals
Duration 01.09.2011 - 31.12.2011
Area Coal mining
Project Description Implementation and support of SAP BI Project Role Project manager
Performed Tasks
Implementation and support of SAP BI standard functionality function area FI,CO,MM. Integration SAP BI with own client database MS SQL planning data
Customer
Ukrainian Railways
Duration 05.2011 – 09.2011
Area Transport
Project Description Implementation and support of SAP BO 3.1 SP5 SAP BW Project Role SAP BI architect
Performed Tasks
Creating SAP BO 3.1 reporting system on SAP BW. Creating data model on SAP BW for analysis “Passenger flow”
Customer ZAO «United Metallurgical Company»
Duration 01.04.2011 - 01.05.2011
Area Metallurgical industry
Project Description Development of reporting "cost of products sold in the context of cost elements" in BI
Project Role BI/ABAP Senior Consultant
Performed Tasks
The implementation of design solutions for the data model, source modules CO, SD, training and technical Specification for the report, the implementation of a data model, development of extractors
Page 5 of 7
Customer MTS (Vodafone.ua)
Duration 01.08.2010 - 31.12.2010
Area Telecommunication
Project Description Development of Financial Statements "Receivables subscribers PoP" in BI
Project Role BI/ABAP Senior Consultant
Performed Tasks
Design solution for the data model, preparation of technical specifications for the reports, implementation of the model data and financial reports
Customer MTS (Vodafone.ua)
Duration 01.04.2010 - 30.07.2010
Area Telecommunication
Project Description Development of the financial statements Foris in BI,data retraction into SAP R/3
Project Role Project manager
Performed Tasks
The implementation of design solutions for the data model, preparation of technical specifications for reports, implementation of the model data and financial reports
Customer Lukoil Overseas Holding Ltd.
Duration 01.12.2009 - 01.04.2010
Area Exploration and production oil and gas
Project Description Development of analytical systems analysis and control of tax rates of the partner company and all subsidiaries. The implementation of the conceptual solution "Scorecard tax reporting."
Implementation of ETL processing tax declarations by means of SAP Business Objects DATA INTEGRATOR, integration with external reference system "KSSS" database ORACLE.
Implementing a data model "SPNO" in SAP BW. Creating OLAP Universe. Construction of analytical reports in BO WEB INTELLIGENCE
Customer
SAP Ukraine
Duration 09.2009
Area
Project Description Business Objects XI 3.0/3.1: Universe Design Project Role Referent of the training courses BOU310, BOU320 Performed Tasks Referent of the training courses BOU310, BOU320 Page 6 of 7
Customer
RZD (Russian Railways)
Duration 3 months
Area Transport
Project Description Development of «Z» extractors on the financial statements, the implementation of «Z» FM
Project Role Senior Consultant ABAP
Performed Tasks
Implemented «Z» extractors on the financial statements have been implemented «Z» FM
Customer RZD (Russian Railways)
Duration 2 months
Area Transport
Project Description Development of class objects, taking advantage of Shared Memory for data processing of salary. Optimization of process of data processing, optimizing the performance
Project Role Senior Consultant ABAP
Performed Tasks
Implemented «Z» classes with support for Shared Memory, implemented «Z» RFC FM
Customer MTS (Vodafone.ua)
Duration 1 month
Area Telecommunication
Project Description Development of conceptual solutions "DWH KPI", monitoring DWH Project Role Senior Consultant BI/ABAP
Performed Tasks
Implementation of the conceptual solution "DWH KPI", statistics database, user activity, system performance as a monitor KPI's Customer Severstal Resources
Duration 01.06.2008 - 21.10.2008
Area Mining
Project Description Implementation of the conceptual solution, "Purchasing", "cash flow", "Financial assets", "Loans and borrowings received." Implementing a data model, development
«Z» extractors, FM implementation, ABAP programming, development of BEx reporting
Project Role BI/ABAP Senior Consultant
Performed Tasks
Implementation of the conceptual solution, "Purchasing", "cash flow", "Financial assets", "Loans and borrowings received." Implementing a data model, development
«Z» extractors, FM implementation, ABAP programming, development of BEx reporting
Page 7 of 7
Personal data
Main education Institute of Business "Strategy"
Qualification - Specialist in economic cybernetics Specialty - Economic Cybernetics
Degree - Master's degree
Citizenship Ukrainian
Work authorization USA
Phone +1-786-***-****
Skype zobovsv
E-mail adt7ux@r.postjobfree.com
Languages Ukrainian – native, English – upper intermediate