Might be available
(Updated 2021-09-03)SAP Senior konsultti
Helsinki, Finland
Beginner Latvian, Finnish, Svenska, English, German
- Integration
- SAP SCM
- SAP BW,BO
Skills (35)
PROBLEM SOLVING
MAINTENANCE
Business Intelligence
SAP
Change Management
BI
RETAIL
FINANCIAL REPORTING
SALES PLANNING
BW
PERFORMANCE TUNING
BW HR
R/3
MICROSOFT OFFICE
FINANCE
ACCOUNTING
BUDGETS
BUDGETING
EBX
BUDGET
DATA SERVICES
HANA
INVOICES
CRM
PURCHASE ORDERS
COST MANAGEMENT
Qlik
HR
SEM
COGNOS
PAINTER
INDUSTRIAL MANUFACTURING
HEALTHCARE
INDUSTRIAL ENGINEER
ISS
Summary
Marko has strong 20 years' experience in business intelligence, data warehousing and consulting. He is widely recognized as an expert on his area of specialty. Marko has been working in team manager position/senior BW consultant/architect, recruiting and training new employees and leading system implementations. Marko has also been working in Acando board. He’s got a proven track record of business development and new customer acquisition. Marko has
lead several large scale DW implementation and development projects.
Marko is vision-driven, BI architect with deep background in conceptualizing, deploying and enriching reporting solutions to support business processes. He has deep understanding of designing and building complex business intelligence solutions, data mining, financial planning and analytics solutions. With background in customer financial department work he has good understanding of how to define enterprise KPIs and turn them into high usability dashboards. Marko has superior expertise in data modelling, data staging and reporting as well as designing complex reporting and budgeting solutions. Marko is familiar with several products and platforms in the analytics domain.
Professional Experience
2008-01 - Present
Individual Contribution:
AMS support & development: Development and support tasks in BW, SAP ECC Extractors including e.g. performance
optimization, process monitoring, system architecture and system maintenance.
Projects (as BW Technical Architect):
Server transfer, Upgrades, New extractors, data flows, integrations, Planning tools, Qlik
Competence areas within the assignment:
SAP BW, SAP ECC, SAP Bex Tools, Authorizations, Integrations, BW/IP planning,SAP SEM-BCS, Qlik, Netweaver Portal, SCM
OTHER CUSTOMERS/PROJECTS
marko.kapanen@datarctic.com
+358 400 713 789
Metsä Tissue SCM Support
Semper SE SCM / BW reporting for APO
Componenta BW reporting / maintenance
Skanlog DK BW Upgrade 7.4 + Maintenance
Altia BW 7.3 + ECC project + Planning
Saint Gobain BW Performance tuning
Alma Media BW, BW-IP Planning / BO Project (Financial Reporting etc.)
Metsä Group BW HR aggregates
YIT BW Upgrade 7.3
VVO Bex Analysis
Altia BW + BW-IP planning Maintenance
YIT Financial Reporting, BW-IP Planning, WAD Portal
Cargotec Reporting, development
Arktika/Kesko Installations, development tasks, upgrade
Raisio Sales Planning, IP + development
Fujitsu SAP BI Basics - training
Lännen tehtaat APD text -files, development tasks
Moventas Budgets/reporting, development tasks
Valio Web -reporting, WAD/Portal (several areas)
Hartwall Sales Planning, IP Planning demo project
Hartwall APO support
Valio group Sales / Corporation
Rimi Baltic, Latvia Maintenance tasks, performance tuning, reporting (WAD)
Keskofood Maintenance, several development tasks/areas
Kesko BW 3.5 Upgrade
VTP Oy / Kesko Financial Reporting
Intrade Partners (S-Group) Maintenance (several tasks)/ web -reporting, WAD/Portal
Metso Financial Reporting (SAP FI-SL) / BW
Hartwall Cognos; Sales Reporting
Hartwall Several areas (SAP COPA etc.), Reporting, Modeling
Fujitsu Services BW 3.0 Upgrade
Hartwall BW 3.0 Upgrade
MacGregor Reporting, several areas
ICL Invia Finance (SAP EC-PCA)
Stockmann Purchase orders, invoices
Stockmann, Sesto R/3 Retail
COURSES
2016-01 - Present
Individual Contribution:
AMS support & development: Development and support tasks in BW, SAP ECC Extractors including e.g. performance
optimization, process monitoring, system architecture and system maintenance. BW Upgrade, data flow migration
marko.kapanen@datarctic.com
+358 400 713 789
Competence areas within the assignment:
SAP BW, SAP ECC, Solman, SAP Bex Tools, Authorizations, Integrations, BW APD, BW Upgrade, Xtract IS
2019-11 - Present
Designing a new architecture for BW (FICO & HR area) and attach new reporting to BO layer. Design a new approach for
"Open hub services"
Competence areas within the assignment:
SAP BWonHANA, SAP HCM, BO 4.3, Authorizations, Integrations, BW APD, BW Upgrade, Open Hubs
2021-04 - 2021-06
Designing a queries / data flows (FICO & Logistics area) and attaching queries to BO layer.
Competence areas within the assignment:
SAP BWonHANA, SAP S/4 HANA, BO 4.3, Authorizations, Integrations,
2019-05 - 2020-03
Individual Contribution:
To create a base architecture including authorization concept in BW for Classic BPC budgeting system. Fetch data from S/4 to BW for budgeting purposes
Competence areas within the assignment:
SAP BWonHANA, SAP Bex Tools, Authorizations, Integrations, SAP S/4 HANA, BPC Classic
2019-10 - 2020-01
Individual Contribution:
Manage, test & validate a BW upgrade in Veho's system landscape.
Competence areas within the assignment:
SAP BW, SAP ECC, SAP Bex Tools, Authorizations, Integrations, SAP SCM
2008-01 - 2019-12
Individual Contribution:
AMS support & development: Development and support tasks in BW, SAP ECC Extractors including e.g. performance
optimization, process monitoring, system architecture and system maintenance.
Projects (as BW Technical Architect):
Server transfer, Upgrades, New extractors, data flows, integrations, Planning tools, Qlik
Competence areas within the assignment:
SAP BW, SAP ECC, SAP Bex Tools, Authorizations, Integrations, BW/IP, Qlik, Netweaver Portal
2018-01 - 2018-01
2007-01 - 2018-01
2015 - 2016 Metsä Group / BW services
marko.kapanen@datarctic.com
+358 400 713 789
ASSIGNMENT EXPERIENCE (most recent)
2017-09 - 2018-01
Individual Contribution:
Design, lead and develop solution to split data warehouse so that to different legal entities can operate in the same
system. New development / COPA
Competence areas within the assignment:
SAP BW, SAP ECC, BO, WebI, SAP Bex Tools, Authorizations, Integrations, SAP CRM
2017-09 - 2017-11
marko.kapanen@datarctic.com
+358 400 713 789
Individual Contribution:
Current system analysis and performance optimization for selected data flows.
Competence areas within the assignment:
SAP BW, SAP ECC, SAP Bex Tools, Authorizations, Integrations, Solman, Netweaver Portal
2017-04 - 2017-11
Problem solving, Sales history, Cal day sync, UOM issue
Individual Contribution:
Problem solving, Sales history / Cal day sync, APO/SCM Planning, Monitoring. System analysis
Competence areas within the assignment:
SAP BW, SAP ECC, SAP SCM/APO, Integrations
2016-01 - 2017-11
Individual Contribution:
AMS support & development: Development and support tasks in BW, BO, WebI, Bex Tools, SAP ECC Extractors including
e.g. performance optimization, process monitoring, authorizations, system architecture and system maintenance.
Competence areas within the assignment:
SAP BW, SAP ECC, BO, WebI, SAP Bex Tools, Authorizations, Integrations, SAP CRM, BW/IP Planning
2016-01 - 2017-11
Individual Contribution:
AMS support & development: Development and support tasks in BW. Server Transfer Project, BW upgrade
Competence areas within the assignment:
SAP BW, SAP ECC, SAP Bex Tools
2016-01 - 2017-11
Individual Contribution:
AMS support & development: Development and support tasks in BW, SAP ECC Extractors including e.g. performance
optimization, process monitoring, system architecture and system maintenance.
Competence areas within the assignment:
SAP BW, SAP ECC, SAP Bex Tools, Authorizations, Integrations, SAP CRM, BW/IP Planning, Netweaver Portal
2017-01 - 2017-01
2016-01 - 2016-01
+358 400 713 789
2016-01 - 2016-01
2016-01 - 2016-01
2015-01 - 2015-01
2015-01 - 2015-01
2013-01 - 2013-01
2012-01 - 2012-01
2012-01 - 2012-01
2011-01 - 2011-01
2011-01 - 2011-01
2010-01 - 2010-01
2009-01 - 2009-01
2008-01 - 2008-01
2007-01 - 2007-01
2007-01 - 2007-01
2006-01 - 2006-01
2006-01 - 2006-01
2005-01 - 2005-01
2005-01 - 2005-01
2004-01 - 2004-01
2004-01 - 2004-01
2004-01 - 2004-01
Cognos Decision Stream for DW Cognos Finland 2004
developers
marko.kapanen@datarctic.com
+358 400 713 789
2003-01 - 2003-01
2003-01 - 2003-01
2003-01 - 2003-01
2002-01 - 2002-01
2002-01 - 2002-01
2002-01 - 2002-01
2001-01 - 2001-01
2000-01 - 2000-01
PERL -language, basics Tieturi Oy 2000
1999-01 - 1999-01
Controlling
Academic Background
2021-09 - 2011-01