Konstantin is available for hire
Hire KonstantinKonstantin Epanov
Verified Expert in Engineering
SAP BI Developer
Location
Strasbourg, France
Toptal Member Since
November 29, 2023
Konstantin is an SAP Analytics architect and developer specializing in SAP BW, HANA, S/4HANA, ERP systems, and embedded SAP technologies. As a professional with extensive experience in the full development cycle in a complex environment, he takes extra value from systems and technologies and facilitates support. Konstantin is the SAP Certified Application Associate who follows the BI market's latest trends and solutions and often works under requirements volatility.
Portfolio
LeasePlan
SAP BW/4HANA, SAP HANA, SQL, Data Warehousing, Data Warehouse Design
SAAQ
SAP HANA, SAP Cloud Platform Integration (CPI), SAP BW/4HANA, SQL, ABAP...
UPSA
SQL, SAP Fiori, SAP S/4HANA Embedded Analytics, Graphs
Experience
Availability
Part-time
Preferred Environment
SAP BW/4HANA, SAP HANA, SAP S/4HANA, SAP Datasphere
The most amazing...
...thing I've developed is a graph-based model of relationships that navigates a multilevel cross-dependent hierarchy of tables and views in S/4HANA.
Work Experience
SAP BW Consultant
2021 - 2023
LeasePlan
- Developed SAP Business Warehouse (BW) and HANA models for finance, risk management, and regulatory reporting.
- Created provision allocation and movement models in SAP BW.
- Supported corporate data warehouse models with non-SAP data and data flow from SAP S/4HANA to iController, mainly FI-CA (Contract Accounting).
- Developed a program for tracking objects between transports in QA, ACC, and production systems, reducing conflicts among developers.
Technologies: SAP BW/4HANA, SAP HANA, SQL, Data Warehousing, Data Warehouse Design
SAP Analytics BI Architect
2021 - 2022
SAAQ
- Developed a strategy and configuration for HANA XSA and Azure Repos.
- Provided technical assistance to the BI team in SAP BW, HANA, and ABAP development.
- Developed SAP BW and S/4HANA, creating an ABAP class with an XML parser for SAP Ariba Web Services.
Technologies: SAP HANA, SAP Cloud Platform Integration (CPI), SAP BW/4HANA, SQL, ABAP, Data Warehousing, Data Warehouse Design
SAP S/4HANA Analytics Expert
2021 - 2021
UPSA
- Defined specifications for SAP S/4HANA embedded analytics with Core Data Services (CDS) and Fiori.
- Broke down the SAP logic using Fiori applications, web services, and CDS to build customer reports, including disbursement analysis, days sales outstanding, material cost estimate, bill of materials (BOM) analysis, and process order costs.
- Designed the complex report named Récap Obsolescence Discrétionnaire with SAP Materials Management (MM) and SAP Extended Warehouse Management (EWM) stocks, financial valuation, and calculations of age and obsolescence.
Technologies: SQL, SAP Fiori, SAP S/4HANA Embedded Analytics, Graphs
SAP Analytics BI Architect
2018 - 2020
IBM
- Implemented SAP Business Planning and Consolidation (BPC) in SAP BW/4HANA for SAAQ, an automobile insurance and road safety company owned by the Government of Quebec.
- Built BW interfaces to enable direct data loading into BPC from financial accounting (FI), engagement from controlling (CO), depreciation from asset accounting (FI-AA), commitments from procurement, and non-SAP data with a full-time equivalent (FTE).
- Clarified several points within depreciation and balance carryforward to improve the BPC solution.
- Designed and developed retraction of budget for cost centers and work breakdown structure (WBS) models from BPC to S/4HANA Project System (PS).
- Defined additional logic with general ledger account for interfaces within payroll in S/4HANA. Improved system stability, including contact with SAP support for incident resolution, especially BPC transport problems.
- Contributed to installing and configuring the SAP HANA 2.0 XS Advanced server.
- Defined the CDS and requirements of Fiori applications, such as custom analytical queries for the finance department. Provided technical assistance to the BI team with technologies and BW/4HANA development.
- Provided support, defined the strategy, improved the existing solution, and implemented new functionality for insurance in BW.
- Contributed to a solution based on Git, Gerrit, and CI to develop ABAP. Developed a model for SAP Financial Supply Chain Management (FSCM) in S/4HANA with ABAP and CDS.
- Developed new models for the calculation of FTE in BW: Advance DataStore Object (ADSO), Open ODS, and Business Explorer (SAP BEx). Developed a model for FSCM Claim Management in BW and supported the upgrade of BW 2.0 with XSA.
Technologies: SAP BW/4HANA, SAP S/4HANA, SAP HANA, ABAP, SQL, SAP BusinessObjects (BO), SAP Business Planning and Consolidation (BPC), SAP S/4HANA Embedded Analytics, Graphs, Data Warehousing, Data Warehouse Design
SAP Analytics BI Architect
2018 - 2018
IBM
- Improved the existing solution for ALDO Group, a global retail chain of shoes and accessories stores.
- Completed the Smart Data Integration (SDI) upgrade and enabled real-time integration with Oracle for POS and non-SAP data.
- Fixed performance issues as data transfer process (DTP) filters were not propagated to Oracle, and a parallel process for partitions did not work.
- Created a model that extracted data for the Qlik Sense product performance dashboard. The complex algorithm calculated weeks of running sum with purchasing, POS sales, and price datasets.
- Developed the cost of goods sold for a scenario where order and liability costs did not exist at the moment of sale. Created a customer hierarchy in CDS for the finance team.
- Improved system stability by contacting SAP support for incident resolution, installation of OSS notes, monitoring, and EarlyWatch Alert.
- Supported and performed QA for the BW part of BPC standard implementation and reported design issues.
Technologies: SAP BW on HANA, SAP ERP, Fashion Management, SAP BusinessObjects (BO), SAP HANA, ABAP, SQL, Data Warehousing, Data Warehouse Design
SAP Analytics BI Senior Consultant
2016 - 2018
IBM
- Acted as an integration and development architect for BW and ERP analytics projects. Supported, consolidated, and planned a parallel project to implement SAP Fashion Management Solution (FMS) with the embedded BPC.
- Served as a technical manager of BI internal and off-shore teams, defining the strategy and guidelines and designing the ETL processes and data marts for all areas. Built solutions for technical issues with SAP support and conducted quality checks.
- Used SAP BW on HANA for ERP logistics, POS, and legacy systems data. Designed BW/4HANA using new objects such as ADSO, Open ODS, CompositeProvider, CalcView, SQL in AMDP, flow graphs, Operational Data Provisioning (ODP), and HANA source systems.
- Installed and configured the real-time SDI with Oracle.
- Used front-end tools like BEx for reports and data marts, WebI reports based on BEx queries and universe, and extraction for Qlik Sense.
- Developed complex models in BW, covering assortment and sales, cost of goods sold, sales price classes and CDS for ERP extractors, and inventory, POS, pricing, and purchasing extracts for Qlik Sense.
- Created reports and self-service data marts for the finance team and logistic reports for the buy and sale area using ERP analytics. The design was based on the custom CDS, standard and extension of standard CDS cubes, and analytic queries.
- Developed the CDS, BPC plan, statistics, CalcView, and remote hierarchy class and analyzed technical issues of the embedded BPC.
Technologies: SAP ERP, SAP BusinessObjects (BO), SAP BW/4HANA, SAP HANA, SQL, ABAP, Data Warehousing, Data Warehouse Design
SAP BI Architect
2016 - 2016
Lenta
- Collaborated with the SAP AG cooperation on a separate data warehouse project for POS data using Smart Data Access (SDA), Vora, Hadoop, dynamic tiering, near-line storage (NLS), and Customer Activity Repository (CAR).
- Participated in the process of choosing a new BI tool—Oracle BI, Microsoft Power BI, or QlikView—by investigating user requirements and system features.
- Migrated HANA SP 11 with six nodes to IBM Power 8TB with one node together with the team.
- Troubleshot issues with missing HANA view and product system stabilization in the dry-run phase, debugged and analyzed critical issues with data type and truncated SQL, and resolved with a workaround and a patch from SAP development.
- Built a model in BW and HANA for EGAIS, a unified state automated information system for control of alcohol products. ERP's Special Purpose Ledger (FI-SL) has interfaces with a state-owned database and material movements to distribution centers.
- Developed a new version of alcohol declaration from MM and purchase order using batch management algorithm. The stock had to be taken from the old declaration first and then from the new one, resulting in two stock levels with different granularity.
Technologies: SAP BW on HANA, SAP ERP, ABAP, SAP BusinessObjects (BO), SAP HANA, SAP Extended Warehouse Management (EWM), Hadoop, SQL, Retail & Wholesale, Data Warehousing, Data Warehouse Design
SAP BI Architect
2013 - 2016
Lenta
- Provided support for SAP BW on HANA and SAP BusinessObjects. Improved BI development and support processes by securing a library of codes, knowledge transfer, documentation automation, reports, KPI repository, and self-service approach to analytics.
- Acted as a technical manager of an internal team of five and external contractors in charge of design and quality checks. Established rules and best practices and initiated workshops and learning sessions for the team.
- Implemented Multidimensional Expressions (MDX) in ABAP, solving syntaxes and performance issues, and simple OData on BEx for the SAP mobile platform.
- Developed various reports as per user requirements, including ERP and EWM extractors, introduced enhancements using Business Add-Ins (BAdIs), and transformed complex data flows with expert, inverse, and script routines, classes, and programs in ABAP.
- Implemented new features to BW on HANA, such as SQL and CE functions on script view and table function, complex graph views, and CompositeProvider. Completed optimizations with AMDP classes.
- Developed complex SAP BusinessObjects WebI reports using context operators on BI Consumer Services (BICS) and HANA connections.
- Implemented several predictive analysis library (PAL) functions based on the Application Function Modeler (AFM) flowgraph, SQL, or SAP HANA Analysis Process (HAP).
- Analyzed SAP BusinessObjects and BEx problems in the SAP AG cooperation. Supported the QlikView dashboards project covering delta extractor on HANA view, BEx data marts, and general dashboard logic and performance.
- Implemented dashboards for the top and middle management, covering daily, weekly, and monthly sales, stocks, P&Ls, and price monitoring indexes. Replaced the costs in millions with the FI-SL alternative evaluation in BW.
- Developed sales per promotion and promotional pricing, SAP EWM service-level agreement based on handling unit (HU) movement and purchase order, price monitoring with indexes by competitors, assortment for store format, and stock provision with risks.
Technologies: SAP BW on HANA, SAP ERP, SAP BusinessObjects (BO), SAP HANA, SAP Extended Warehouse Management (EWM), ABAP, SQL, Hadoop, Retail & Wholesale, Data Warehousing, Data Warehouse Design
SAP BI Senior Consultant
2012 - 2013
Lenta
- Provided support for the SAP ERP solutions to the retail, logistics, and finance teams.
- Used all BI components, from ERP generic extractors and delta on timestamp and change documents to virtual cubes, complex data flows, expert routines, BAdI, programs and classes, and BEx queries.
- Analyzed requirements to execute several projects, including calculations for controlling departments based on SAP Controlling, HR, and Sales and Distribution data.
- Calculated manufacture costs, enabling the allocation based on tariffs, controlling bonuses, vendor fees for a place in a store, and rates depending on sales and distribution.
Technologies: SAP Business Warehouse (BW), SAP ERP, ABAP, SAP BusinessObjects (BO), SAP Extended Warehouse Management (EWM), Retail & Wholesale, Data Warehousing, Data Warehouse Design
SAP BI Developer
2010 - 2011
Mars
- Maintained SAP BW in the global center of excellence.
- Developed extractors, DataStore Object (DSO), transformations, cubes, and BEx for the quality management project.
- Analyzed errors and corrections mainly for logistics, i.e., sales and distribution and materials management.
Technologies: SAP Business Warehouse (BW), SAP ERP, Data Warehousing, Data Warehouse Design
Experience
Graph for S/4HANA Views and CDS
https://drive.google.com/file/d/1hKje3-ajTJ2gJIPyi7g4lTVz3pkcAYn-/viewI developed a model of relationship tables, views, and CDS for the S/4HANA system based on graph technology. It has different types of nodes and relationships and helps navigate a multilevel cross-dependent hierarchy of views in the S4 system. For example, users can go from table ACDOCA to the most frequently used CDS cube, I_JournalEntryItemCube.
Education
2000 - 2005
Master's Degree in Applied Computer Science in Economics
Saint Petersburg State Polytechnic University - Saint Petersburg, Russia
1996 - 2000
Professional Degree in Commerce in the Electronics Industry
Saint Petersburg Engineering School of Electronics - Saint Petersburg, Russia
Certifications
FEBRUARY 2024 - PRESENT
Microsoft Certified: Power BI Data Analyst Associate
Microsoft
OCTOBER 2023 - PRESENT
Databricks Certified Data Engineer Associate
Databricks
NOVEMBER 2021 - PRESENT
CISI Level 3 Award in Technology in Investment Management
The Chartered Institute for Securities & Investment
NOVEMBER 2020 - PRESENT
SAP Certified Application Associate - Treasury with SAP S/4HANA
SAP
AUGUST 2020 - PRESENT
SAP Certified Application Associate - SAP HANA 2.0 (SPS04)
SAP
AUGUST 2020 - PRESENT
Microsoft Certified: Azure Data Fundamentals
Microsoft
JUNE 2020 - PRESENT
SAP Certified Application Associate - SAP Analytics Cloud
SAP
APRIL 2020 - PRESENT
SAP Certified Application Associate - Reporting, Modeling and Data Acquisition with SAP BW/4HANA 2.x
SAP
Skills
Tools
SAP S/4HANA, SAP Extended Warehouse Management (EWM), SAP Fiori, Microsoft Power BI
Languages
SQL, ABAP
Platforms
SAP HANA, Databricks, Azure
Frameworks
Hadoop
Storage
Neo4j
Industry Expertise
Retail & Wholesale
Other
SAP BW/4HANA, Data Warehouse Design, SAP BusinessObjects (BO), SAP BW on HANA, SAP Business Warehouse (BW), Data Warehousing, SAP ERP, Investment Management Technology, SAP Analytics Cloud (SAC), Commerce, Economics, SAP Cloud Platform Integration (CPI), SAP S/4HANA Embedded Analytics, Fashion Management, SAP Business Planning and Consolidation (BPC), Treasury & Liquidity Management, Financial Risk Management, SAP Treasury, SAP Datasphere, Computer Science, Graphs, Electronics
Collaboration That Works
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
1
Share your needs
Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2
Choose your talent
Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3
Start your risk-free talent trial
Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.
Top talent is in high demand.
Start hiring