Thomas Rohmann
SAP BI Architect
Experience
Jul 2023 - Present
2 years 1 monthSAP BI Architect
Iqony
- Technical environment: BW4H
- Creation of LSA++ architectures in PCA, CO, HR, IS-U, FI, PUR
- Introduction of accrual accounting in IS-U
- Story implementations in SAC
- Connection of PowerBI via Datasphere
- Support activities in HR, BCS addon in BW4H, Lumira
Jan 2022 - Oct 2023
10 monthsSAP Senior Consultant
Investitionsbank des Landes Brandenburg ILB
- Technical environment: EA-FINSERV, SAP-FIN, BW 7.5
- Analysis and adjustments of customer extensions in ECC for CMS and CML
- Development of SAP BI extractors based on CMS SAP function modules
- Development of ABAP reports in the CMS area for result evaluation
- Setup of an LSA architecture
- Finding/fixing errors in SAP CMS coding
Oct 2022 - Dec 2022
3 monthsSAP BI / HANA Senior Consultant
Weber Maschinenbau
- Technical environment: BW 7.5
- Support for in-place conversion to BW4H
- Conversion of complex ABAP logic to AMDP
Feb 2020 - Jun 2023
3 years 5 monthsSAP BI / HANA Senior Consultant
Bayer
- Technical environment: BW 7.5
- BI data modeling in the COPA area
- ABAP developments in BI (e.g. transport checks, HCPR test programs)
- Solving performance issues in the ABAP stack using ABAP OO RTTS for memory optimization and Parallel Processing Framework for performance
- Development of a generic mapping/splitting engine with ABAP OO
- Replacing complex ABAP logic with AMDP-based approaches
- Tool evaluation Snowflake, PowerBI, creating a prototype BI app: SQL development in Snowflake, frontend in PowerBI
Jul 2018 - Sep 2020
2 years 3 monthsSAP BI / HANA Senior Consultant
tesa
- Technical environment: BW 7.5 (B4H mode)
- Creation of functional and technical specs
- Leading workshops for requirements gathering
- Creation of aDSOs, openODSViews, CompositeProviders
- Creation of queries, variables, key figure systems
- Creation of VDMs with Core Data Services for PP, QM, FI, WM
- Creation/analysis/fix of CDS views
- Creation of calculation views
- Development of AMDPs
- Development of authorizations/analysis authorizations
- Performance analysis of CDS-based VDMs
Mar 2017 - Jun 2018
1 year 4 monthsSAP BI / HANA Senior Consultant
Marquard & Bahls AG
- Technical environment: BW 7.4 on HANA / BI IP, BPC embedded
- Design of virtual staging scenarios with HANA InformationViews (CalculationViews, AttributeViews, AnalyticalViews)
- Development of SQLScript-based procedures/functions in HANA
- Performance evaluation and optimization of HANA models
- Development of CompositeProviders based on HANA views
- Connection of VirtualProviders to HANA
- Development of planning scenarios with BI IP/PAK/AMDP-based developments
- Development of input-ready workbooks with Analysis for Office including VBA scripts
- Development of the authorization concept based on analysis authorizations
May 2016 - Feb 2017
10 monthsSAP BI Senior Consultant
Vaillant Group Business Services
- Technical environment: BW 7.3 / 7.5
- Evaluation of options to connect Microsoft SharePoint databases to SAP
- Development of a REST/ODATA-based approach to load SharePoint lists into SAP with ABAP OO
- Development of a SOAP-based approach to load SharePoint lists including a suitable XML parser with ABAP OO
- Performance optimization of loading processes with ABAP OO
- Development of a loading cockpit with WebDynpro
- Integration of QlikView Publisher tasks into SAP BW process chains
- Implementation of an RFC connection to start QlikView Publisher tasks from BW process chains
- Development of a SAP BI IP app for entering calendar data
- Development of several WebDynPro apps including assistant class hierarchies and dynamic context nodes
- Adjustments of forms with Adobe Lifecycle Designer (WebDynPro)
Sep 2014 - Jan 2015
5 monthsSAP BI Senior Consultant
Lufthansa Technik
- Technical environment: BW 7.3, SAP BusinessObjects Analysis
- Implementation of a project to analyze time-related activities
- Design and implementation of a multi-layer data model
- Design and implementation of transformations, creation of class hierarchy for start/end routines
- Testing and go-live
Mar 2013 - May 2016
3 years 3 monthsSAP BI Senior Consultant
Unicredit Services
- Technical environment: BW 7.3, 3.5 in SAP HR
- Inventory and overhaul of process chains
- Inventory and overhaul of the multilayer architecture
- Review and correction of existing generic extractors from SAP HR
- Development of a generic extractor module for all infotypes
- Creation of a tool to evaluate and clean error stacks with email functionality
- Introduction of a pseudo-delta method including solutions for typical HR issues (overlapping time slices, detection of deletions)
- Creation of tools for mass generation of DSOs, InfoSources, transformations, data sources
- Development of a tool for attribute inheritance along hierarchies (ABAP OO)
- Development of a concept for key figure reporting
- Development of a complex solution to calculate the "Flow" key figure system (ABAP OO)
- Daily support and ticket handling
Sep 2012 - Feb 2013
6 monthsSAP BI Senior Consultant
Edeka
- Technical environment: BW 7.3, 3.5
- Implementation of change requests in MM and SD from extraction to query design
- Migration of legacy data
- Development of a real-time data extraction scenario
- Development of a generic file extractor with ABAP OO
- Fixing application logic in SD-based data flows
- Development/fixing of WAD-based applications
Jul 2008 - Sep 2012
4 years 3 monthsSAP BI Senior Consultant, Project Manager, Quality Assurance Consultant, Lead Consultant
Panasonic
- Technical environment: BW 7.0
- Project management of various BI implementation projects; functional leadership and coordination of consultants
- Implementation of special interfaces (outbound + inbound) using BI tech (FI, SD, MM, CO)
- Development of a BI IP-based solution for inventory optimization
- Development of a program to delete inactive RFC connections
- Performance optimization of a process chain
- Fixing an ABAP OO issue of high memory use in workbooks with many embedded queries
- Development of an APO-to-BW interface to generate flat files for a global planning system
- Overall responsibility for all interfaces to the global planning system as Lead Consultant
- Coordination/implementation of interface change requests (mainly changes to InfoCubes, ODS, updates, custom developments)
- Management of several junior consultants
- Communication with HQ in Japan
- Support activities (troubleshooting, performance optimization)
- QA consulting: technical review of solutions
Jul 2008 - Dec 2009
6 monthsCoach
systrion AG
- Technical environment: BW 7.0
- Onboarding a junior consultant to consulting
- Improving customer communication
- Introduction to requirements analysis
- Training in BI 70, especially Administrator Workbench and BEX Query Designer
Jan 2008 - Jun 2008
6 monthsTest Coordinator
Unilever
- Technical environment: BW 3.5, R/3, Proclarity, Siebel Consumer Goods 7, TOAD, TestDirector
- Testing a Proclarity and BW based reporting system
- Communication with international teams
- Executing test scripts in TestDirector
- Root cause analysis in source systems (R/3, Siebel) using TOAD (SQL queries for data validation)
- Coordination of other testers' activities
Aug 2007 - Jun 2008
11 monthsProgrammer, Technical Project Manager
Axel Springer / Cora Verlag
- Technical environment: BW 7.0, flat files
- Blueprint creation for a controlling MIS based on SAP BW
- Selection of the reporting frontend from the BI suite
- Technical design for connecting the new MIS app to the existing MIS reporting and various file interfaces
- Integration into the existing BW system (Multiproviders, base cubes, transformations, infosets)
- Implementation (data modeling, data flow modeling)
- Implementation of reporting requirements with BEX Report Designer and BEX Query Designer
- Implementation of planning functions with BI IP (modeling RT cube, input-ready workbooks, FOX formulas)
- Migration to production and handover to IT
- User training
Jan 2007 - Present
18 years 7 monthsFreelance SAP BI Consultant
SAP BI Beratung Thomas Rohmann
- Thomas Rohmann has been working in SAP Business Intelligence consulting for about 20 years.
- With his core skills in SAP BI architecture, design, modeling and development (ABAP, ABAP OO), he covers the entire SAP BI process.
- Lately he has focused on new SAP HANA features like Information Views, Core Data Services and AMDP.
- Through his many project experiences, he has detailed process knowledge in Supply Chain Management, Logistics and Finance.
Jul 2006 - Dec 2006
6 months Germany
CSLM Process Lead
Accenture Services
- Transfer of business from Unilever.
May 2006 - Jun 2006
2 months Germany
IT Business Intelligence Systems Manager
Unilever Deutschland
- Management of European CRM reporting in SAP BW
- Responsible for the European Customer Service Level Monitoring project
Feb 2005 - Apr 2006
1 year 3 months Hamburg, Germany
SAP BW Implementation Manager and Project Manager
Unilever Deutschland
Jun 2004 - Jan 2005
8 months Hamburg, Germany
Manager in SAP FI/CO
Unilever/ Lever Fabergé Deutschland – PAT AC
Mar 2001 - May 2004
3 years 3 months Paris, France
SAP BW Team Lead, BW Business Analyst and BW Developer
Unilever / Lever Fabergé France – Eiffel AC
Apr 1999 - Feb 2001
1 year 11 months Hamburg, Germany
System Analyst
Unilever / Lever Fabergé Deutschland
Oct 1997 - Mar 1999
1 year 6 months Hamburg, Germany
Consultant in OLAP/DataWarehouse
Oracle Deutschland GmbH
- Working with Oracle RDBMS and Express technology.
Oct 1995 - Sep 1997
2 years Hamburg, Germany
IT Organizer/System Analyst
Radio Marketing Service GmbH
Summary
Thomas Rohmann has been working in SAP Business Intelligence consulting for about 20 years. With his core skills in SAP BI architecture, design, modeling and development (ABAP, ABAP OO), he covers the entire SAP BI process. Lately he has focused on new SAP HANA features like Information Views, Core Data Services and AMDP. Through his many project experiences, he has detailed process knowledge in Supply Chain Management, Logistics and Finance.
Languages
German
Native
English
Advanced
Education
Lorem ipsum dolor sit amet
Diploma in Business Informatics · Business Informatics
Certifications & licenses
Solution Consultant SAP NetWeaver 2004s BI/BI70
SAP
Solution Consultant SAP NetWeaver 2004 BI
SAP
Similar Freelancers
Discover other experts with similar qualifications and experience