Project Experiences
20 years of BI expertise
Sandoz
01.2020 - 06.2023
BI Implementation (BI 7.5) - BI developer
Responsible for leading a team providing and pre-calculating data for a holistic reporting application network implemented with QlikSense Dashboards which engulfs desktop and mobile versions of every aspect of reporting needs
Stada
08.2021 - 06.2023
BI Implementation (BW/4HANA) - BI developer
Further developing and improving the BI planning tool to allocate general costs according to the tax regulations and calculating the performance fee to be charged towards licensors. Improving the ICP tool to create chains for calculating intercompany prices.
GE
04.2021 - 06.2021
BI Support (BW/4HANA) - BI developer
Support of the existing BI solution and HANA migration tasks
Palkeet
03.2020 - 07.2020
BI Implementation (BW/4HANA) - BI developer
Migration of an existing BI implementation to BW/4HANA. Rebuilding the entire data flow with aDSOs and CompositeProviders.
Sandoz
03.2019 - 12.2019
BI implementation (BI 7.5) - Project Manager (budget: 400.000 CHF)
Further improving the mobile native iOS application called Genie with detailed data and including different planning scenarios.
Essity
07.2018 - 04.2021
BI Implementation (BI 7.5 on HANA) – Location: Munich, Germany
Test Manager and Backend developer for PerfectStore application. Data extraction with help of HANA views and Advanced DSOs.
Sandoz
01.2017 - 12.2018
BI Implementation (BI 7.3) – Location: Munich, Germany
Creating the necessary automated interfaces to transfer data from SAP BI to a native iOS application to display critical KPIs on any iOS mobile device. An MSBI system was used as intermediate storage layer.
Sandoz
01.2017 - 01.2018
BI Implementation (BI 7.3) – Location: Munich, Germany
Created a BI application with QlikView frontend to display daily sales KPIs and variances
Novartis
09.2015 - 12.2016
BI/BO Implementation (BI 7.3) – Location: Basel, Switzerland
Creating a tool used by 100+ countries worldwide for entering and consolidating product margin data in Web Dynpro.
Novartis
06.2015 - 10.2015
BI/BO Implementation (BI 7.3) – Location: Basel, Switzerland
Creating a Master Data Management tool for maintaining hierarchies and attributes in Web Dynpro.
Novartis
06.2014 - 06.2015
BI/BO Implementation (BI 7.3) – Location: Basel, Switzerland
Migrating all consolidated financial reporting from single data warehouse systems of the divisions to a group data warehouse system.
Implementation of all closing relevant tasks (division-specific and cross-divisional)
Group-wide BPC system for creating latest forecasts
Migration of Xcelsius-Dashboards to Qlikview
Sandoz
08.2010 - 06.2014
BI/BO Implementation (BI 7.3) – Location: Munich, Germany
Creating 10+ Dashboards with BO Xcelsius with full financial scope
Data Modeling (Infocubes, DSOs, Transformations, Data Transfer Processes)
Getting data with Analysis Process Designer (APD) in international SAP BI system
Data transfer to BO Instances with BO Crystal Reports and LiveOffice (because of performance reasons)
LIMS – TechOps Quality Assurance reporting in a GxP-relevant environment with BO WEBI Reports / Advanced Analysis
Created BI-IP based application for Molecule Launch Planning and Reporting
BPC Solution for tracking of Quality Projects
Norilsk Nickel
02.2010 - 08.2010
BI Implementation (BI 7.0) – Location: Harjavalta, Finland
Implementation of a BI system with following modules: PP, PS, IM, FI, CO, KPI report
Enhancing Business Content- and creating own generic extractors (extraction with FM, from domains, from infosets)
Data Modeling (Infocubes, Transformations, Data Transfer Processes)
BI – Cognos integration (frontend, data access from BI queries)
Fövárosi Vízmüvek
10.2009 - 12.2009
BW Upgrade (BW 3.1 - BI 7.0)
Performing tasks for the function-identical upgrade of the BW system
Switch to the new loading structures (Transformations, Data Transfer Processes) regarding the CO area
Cora
09.2009 - 10.2009
BW extension (BI 7.0)
Extension of the BI system by following Modules: FI, CO, EC-PCA
Data Modeling (Infocubes, Transformations, Data Transfer Processes)
Creating Process Chains
Creating Queries
Infraserv Höchst
07.2009 - 08.2009
BI-IP Implementation (BI 7.0) – Location: Frankfurt am Main, Germany
Planning areas: Operating Planning, Material Planning
Interfaces to other Planning Areas
Data Modeling (Infocubes, Transformations, Data Transfer Processes)
Creating input-ready queries and complex Web screens with WAD (with JavaScript enhancements)
Planning Functions (both FOX and User Exit ABAP OO), ABAP Characteristic Combinations
Neckermann.de
08.2008 - 05.2009
BI-IP Implementation (BI 7.0) – Location: Frankfurt am Main, Germany
Planning areas: Assortment Planning (MAP), Sales Planning
Creating a Business Blueprint for the Assortment Planning
Implementing a Prototype System on basis Web
Interfaces to other Planning Areas (strategic planning, P&L planning)
Data Modeling (Infocubes, Transformations, Data Transfer Processes)
Creating input-ready queries and complex Web screens with WAD (with JavaScript enhancements)
Planning Functions (both FOX and User Exit ABAP OO), ABAP Characteristic Combinations
Generali
09.2006 - 07.2008
BW-BPS Implementation (BW 3.5) – Location: Vienna, Austria
Planning Areas: Internal (Controlling) Planning, Enterprise Planning (BS, P&L), Integrated Planning (Versions and Variants), Actuary planning, Financial Asset, Liquidity Planning, HGB-IFRS
Interfaces to other Planning Areas (Liquidity Planning, Financial Asset Planning, Tax Planning, Reinsurance Planning)
Data Flow to BCS
Create Excel Layouts including Visual Basic code (e. g. VBA Simulations)
Planning Functions (both FOX and User Exit), Characteristic Combinations
Data Modeling (Infocubes, InfoSources, DataSources, Transformation Rules)
Coop Hungary
08.2005 - 02.2006
BW Upgrade 3.0B - 3.5 and extension
Connecting the BW system to several source systems via Flat File Interface
Implementing an ABAP upload program for dynamic and quick uploads
Implementing upload check routines
Managing process chains
Logging and displaying (in BEx Analyzer) upload status
Exporting BW monitor entries into .csv file
FTP operations from the BW system
Multiple field-level authorizations
Workbooks with automatic generated diagrams (VBA coding)
Areva
05.2004 - 04.2005
SEM-BPS Implementation (BPS 3.5) – Location: Erlangen, Germany
Planning areas: Central cost center planning, Cost center planning for sectors, Investments
Balance sheet, P&L, Cash Flow, HGB – French GAAP, Cash Forecast
Create Excel Layouts including Visual Basic code
Planning Functions (both FOX and User Exit)
Create necessary BW objects (Infocubes, Infosources, Datasources)
BC: Roles, authorizations, transporting
Antenna Hungária
02.2003 - 10.2003
SEM-BPS Implementation 3.1B
BW modifications, authorizations
Implementation of SEM-BPS for following planning areas: Cost planning, Income planning, Portfolio Planning, P&L, Balance Sheet, Cash-flow, Financial Planning, Stock planning, Asset Planning
Create BEx Queries, workbooks
Data loading
Nitrogénmüvek
03.2002 - 02.2003
BW, SEM-BPS and SEM-CPM Implementation (BW 2.1C, SEM 3.0A)
Implementation of BW SAP BW business content area (with modifications):
General ledger, Asset accounting, Account payable, Controlling: cost center and cost element analysis, internal orders, CO-PA (Profitability Analysis), Production planning, Plant maintenance, Quality management, Material management
Create queries, workbooks, diagrams, roles and authorizations, aggregations
Ferrero
06.2002 - 03.2003
BW Implementation 3.0A
Main area: cost center and cost element analysis
Antenna Hungária
01.2002 - 09.2002
BW Implementation 2.1C
SAP BW main areas: General ledger, Asset accounting, Account payable, Account receivable, Turnover, Funds Reservation, Budget, FI-SL (special ledger), HR PD (personnel development), HR PA (personnel administration)
Create queries, Create workbooks, diagrams
Create roles and authorizations, RFC connection
Create aggregations
Don't hesitate to call me in case you need more details on my prior experiences.