Robert Wunsch
SAP Senior Consultant BI/BW
Experience
SAP Senior Consultant BI/BW
Insurance
- Controlling reporting/planning application
- Support the business department in defining change requests
- Testing and approval of developments
SAP Senior Consultant BI/BW
Public sector
- Reporting for planning application
- Creation of AfO reports
- Customizing AfO reports with VBA
- Building a data model for actual and planning data
- Implementation of transformation logic in ABAP to adapt legacy data to the planning application structures
- Analysis and adjustment of planning functions
- Support the business department in planning
- Extension of the existing planning application
- Creation of new planning layouts including planning functions and data slices
- Migration support from BW on HANA to BW/4HANA
- Support for the business department in the planning process
SAP Senior Consultant BI/BW
Energy provider
- Analysis of KPI definitions and identification of potential data sources
- Creation of a concept for a KPI dashboard
SAP Senior Consultant BI/BW
Automotive supplier
- Reporting for group consolidation
- Creation of a technical blueprint based on the functional specification
- Building data model and reports
- ABAP OO / AMDP implementation within SAP BW (transformations, BADIs)
- Integration of data from SAP BCS and planning application
- Support the business area in defining reports
SAP Senior Consultant BI/BW
Automotive supplier
- FI reporting (New General Ledger)
- ABAP OO implementation within SAP BW (transformations, BADIs)
- Building data model and reports
- Transitioning the application into production
- Building validation routines for data checks
SAP Senior Consultant BI/BW
Mechanical Engineering
- Expansion of the existing reporting system
- Expansion of the BW data model including ABAP developments and reports (PP, SD)
- Incident handling
- Design and development of a reporting application (MM)
SAP Senior Consultant BI/BW
Banking
- Setup of reporting for additional contract types within the "New Bank - Synthetic Funding" project
- Adjustment of reporting for investor reports
- Creation of reports and workbooks
- Expansion of the BW data model including ABAP development
SAP Senior Consultant BI/BW
Mechanical Engineering Company (Financial Division)
- Setup of a reporting application for a new financial services application
- Analysis of data structures in the source system
- Design and implementation of a data model to integrate various data sources
- Support for the business department in defining reports
- Implementation of an ABAP application to perform residual object value analyses based on different data sources
SAP Senior Consultant BI/BW
Banking
- Adjustment of the SAP BW data model
- Adjustment of existing transformations and ABAP routines
- Creation of reports and workbooks for internal and external reporting
- Adjustment of formatting using VBA
SAP Senior Consultant BI/BW
Banking
- Adjustment of the SAP BW data model and reporting for concurrent processing of multiple ABS transactions
- Expansion of the SAP BW data model
- Adjustment of existing transformations and ABAP routines
- Creation of reports and workbooks for internal and external reporting
SAP Senior Consultant BI/BW
Banking
- Extension of the SAP BW data model to prepare data from ABS transactions for the European Central Bank's loan-level reporting
- Creation of transformations and ABAP routines based on a template
SAP Senior Consultant BI/BW
Banking
- Expansion of the SAP BW and SAP BA data model to provide data for ABS transactions
- Creation and customization of the RDL in SAP BA
- Customization of the CVPM process to extract data for the ABS suite
- Integration of data from the ABS suite into the existing SAP BW data model
- Creation of a trustee report from SAP BW
SAP Senior Consultant BI/BW
Banking
- Design and development of a data foundation in SAP BW to provide audit data for internal and external audits as well as regulatory reporting
- Creation of reports and workbooks using the BEx Query Designer
- Building and expanding the data model
SAP Senior Consultant BI/BW
Consumer Goods
- Customization of the existing BI-IP planning application
- Creation and customization of existing planning layouts
- Implementation of planning functions
SAP Senior Consultant BI/BW
Consumer Goods
- Design and implementation of a reporting application for surveys from SAP CRM
- Creation of generic extractors in SAP CRM
- Modeling of DataProviders and ETL processes in SAP Business Warehouse
- Creation of reports in the BEx Query Designer
- Development of process chains for the regular scheduling of ETL processes
- Transition of the application into production
SAP Senior Consultant BI/BW
Real Estate Management
Design and development of various reporting and planning applications as well as application management
Creation of reports with the BEx Query Designer/Web Application Designer
Creation of Web Intelligence reports based on universes and SAP BEx queries
Design and development of a management cockpit based on WebTemplates and SAP BusinessObjects Xcelsius
Development of generic extractors
Design and implementation of a hub architecture
ABAP development in the BI area (variable exits, extractors, transformation routines)
Design and implementation of authorization concepts for reporting applications
Creation of planning layouts and planning functions in BI-IP
Carrying out application management (data loading, error analysis, planning of system upgrades, performance and runtime optimizations)
SAP Senior Consultant BI/BW
Auditing
- Implementation of SAP BW-BPS for investment and operational profit planning
- Creation of the technical design based on business requirements
- Development of a data model for investment and operational profit planning in SAP BW
- Creation of planning layouts and planning functions
- Preparation of audit reports
- Operational support and end-user training
SAP Senior Consultant BI/BW
Auditing
- SAP BW implementation project for CO-PA and profit center reporting
- Creation of the technical design based on business requirements
- Development of generic extractors in SAP R/3
- Adaptation and extension of content extractors
- Modeling of InfoProviders and ETL processes
- Preparation of an operating concept including transition of the applications to regular operations
- Design and delivery of SAP BW end-user trainings
SAP Senior Consultant BI/BW
Insurance
- Design and development of reporting applications
- Documentation of the existing data model
- Gathering reporting requirements and subsequent implementation
- Modeling of data providers and ETL processes
- Integration of new ETL processes into existing process chains for automated execution
- Creation of reports with the BEx Query Designer in coordination with business departments
- Extension of the existing data model in reporting applications for the SD and CO modules
- Design and implementation of an authorization concept based on department requirements
SAP Senior Consultant BI/BW
Utility Company
- SAP BW implementation project
- Gathering reporting requirements from business departments
- Design and implementation of reporting for the IS-U industry solution
- Extension of the data model to include the FI and PCA modules
- Design and delivery of end-user trainings
- Design of an Oracle database for preparing and distributing data from R/3 to different target systems
- Modification of BASIC scripts in MapInfo
SAP Senior Consultant BI/BW
Consumer Goods
- SAP BW implementation project
- Modeling of process chains
- Creation of web templates
- Design and delivery of SAP BW training for IT department staff
Summary
I started at cimt consulting ag in the SAP BI/BW area. In several SAP BW projects, I gained comprehensive knowledge in various areas of SAP BW and different source modules.
Besides reporting projects, I also worked on planning projects using BW-BPS and BI-IP. I also successfully implemented SAP BusinessObjects Xcelsius as part of a client project.
As a subproject lead, I coordinated and monitored the work of the BI consultants involved in the project.
During a multi-year client assignment, I had the opportunity, in addition to project work, to handle application management for an SAP BW system within a complex SAP system landscape.
Skills
- It Experience Since 1994
- Programming Languages/tools: Abap, Abap Oo, Bex Tools, Sap Bo Universe Designer, Sap Bo Webintelligence, Sap Bo Xcelsius, Eclipse, Analysis For Office
- Operating Systems: Windows, Linux
- Project Management: Prince 2 Certified, Scrum
- Sap Experience Since 2002
- Sap Bw/bi (Releases 3.x And 7.x)
- Sap Bw On Hana
- Sap Bw/4hana
- Sap Modules (As Data Sources): Fi, Co, Mm, Sd, Re/fx, Crm, Is-u, Bank Analyzer
Languages
Education
University of Applied Sciences Karlsruhe
Diploma in Computer Science (FH) · Computer Science · Karlsruhe, Germany
Certifications & licenses
Prince 2 Certified
Scrum
Similar Freelancers
Discover other experts with similar qualifications and experience