Robert Wunsch

SAP Senior Consultant – Business Intelligence / Business Warehouse

Karlsruhe, Germany
Experience
Jun 2022 - Jan 2023
8 months
Germany
Lorem ipsum dolor sit amet

Insurance

  • Supported the business department in defining change requests
  • Tested and accepted developments
Sep 2021 - Present
3 years 11 months
Germany
Lorem ipsum dolor sit amet

Public Sector

  • Created AfO reports
  • Customized AfO reports with VBA
  • Built a data model for actual and planning data
  • Implemented transformation logic in ABAP to adapt legacy data to the planning app structure
  • Analyzed and adjusted planning functions
  • Supported the business department in planning
  • Extended the existing planning application
  • Created new planning layouts including planning functions and data slices
  • Supported migration from BW on HANA to BW/4HANA
  • Assisted the business department with the planning process
Aug 2021 - Dec 2021
5 months
Germany
Lorem ipsum dolor sit amet

Energy Provider

  • Analyzed KPI definitions and identified potential data sources
  • Developed a concept for a KPI dashboard
Aug 2019 - Jul 2021
2 years
Germany
Lorem ipsum dolor sit amet

Automotive Supplier

  • Developed a technical blueprint based on the functional specification
  • Built data model and reports
  • Implemented ABAP OO / AMDP within SAP BW (transformations, BADIs)
  • Integrated data from SAP BCS and planning application
  • Assisted the business department with report definitions
Mar 2019 - Jul 2019
5 months
Germany
Lorem ipsum dolor sit amet

Automotive Supplier

  • Implemented ABAP OO within SAP BW (transformations, BADIs)
  • Built data model and reports
  • Transitioned the application into operations
  • Developed validation routines for data verification
Aug 2018 - Dec 2019
1 year 5 months
Germany
Lorem ipsum dolor sit amet

Mechanical Engineering

  • Extended the BW data model including ABAP developments and reports (PP, SD)
  • Handled incidents
  • Designed and developed a reporting application (MM)
Jan 2018 - Jul 2018
7 months
United Kingdom
Lorem ipsum dolor sit amet

Banking

  • Adapted reporting for investor reports
  • Created reports and workbooks
  • Extended the BW data model with ABAP developments
Mar 2016 - Apr 2018
2 years 2 months
Germany
Lorem ipsum dolor sit amet

Finance Division of Machinery Manufacturer

  • Analyzed data structures in the source system
  • Designed and implemented a data model to integrate various data sources
  • Assisted the business department in defining reports
  • Developed an ABAP application to perform residual value analyses based on different data sources
Sep 2014 - Jun 2016
1 year 10 months
Germany
Lorem ipsum dolor sit amet

Banking

  • Adjusted existing transformations and ABAP routines
  • Created reports and workbooks for internal and external reporting
  • Customized formatting with VBA
Apr 2014 - Aug 2014
5 months
United Kingdom
Lorem ipsum dolor sit amet

Banking

  • Extended the SAP BW data model
  • Adjusted existing transformations and ABAP routines
  • Created reports and workbooks for internal and external reporting
Sep 2013 - Mar 2014
7 months
Germany
Lorem ipsum dolor sit amet

Banking

  • Extended the SAP BW data model to prepare data from ABS transactions for the European Central Bank’s loan-level reporting
  • Created transformations and ABAP routines based on a template
Jul 2012 - Aug 2013
1 year 2 months
Germany
Lorem ipsum dolor sit amet

Banking

  • Extended the SAP BW data model to supply data to SAP BA
  • Created/adjusted RDL in SAP BA
  • Adapted CVPM process to extract data for the ABS suite
  • Integrated data from the ABS suite into the existing SAP BW data model
  • Generated a trustee report from SAP BW
Jan 2012 - Jun 2012
6 months
Germany
Lorem ipsum dolor sit amet

Banking

  • Created reports and workbooks with the BEx Query Designer
  • Built and extended the data model
Jan 2011 - Jan 2011
1 month
Germany
Lorem ipsum dolor sit amet

Consumer Goods

  • Created and adjusted existing planning layouts
  • Implemented planning functions
Apr 2010 - May 2010
2 months
Germany
Lorem ipsum dolor sit amet

Consumer Goods

  • Developed generic extractors in SAP CRM
  • Modeled DataProviders and ETL processes in SAP BW
  • Created reports in BEx Query Designer
  • Developed process chains for regular scheduling of ETL processes
  • Transitioned the application into operations
Sep 2006 - Dec 2011
5 years 4 months
Germany
Lorem ipsum dolor sit amet

Real Estate Management

  • Created reports with BEx Query Designer/Web Application Designer
  • Developed Web Intelligence reports based on universes and SAP BEx queries
  • Designed and developed a management cockpit using web templates and SAP BusinessObjects Xcelsius
  • Developed generic extractors
  • Designed and implemented a hub architecture
  • ABAP development in BI (e.g., variable exits, extractors, transformation routines)
  • Designed and implemented authorization concepts for reporting applications
  • Created planning layouts and planning functions in BI-IP
  • Performed application management (data loads, error analysis, system upgrade planning, performance and runtime optimizations)
Feb 2006 - Aug 2006
7 months
Germany
Lorem ipsum dolor sit amet

Audit Firm

  • Created the technical design based on functional requirements
  • Built a data model for investment and operating result planning in SAP BW
  • Developed planning layouts and planning functions
  • Produced audit reports
  • Provided operational support and user training
Jul 2005 - Jan 2006
7 months
Germany
Lorem ipsum dolor sit amet

Audit Firm

  • Created the technical design based on functional requirements
  • Developed generic extractors in SAP R/3
  • Adapted/extended content extractors
  • Modeled InfoProviders and ETL processes
  • Created an operations concept including transition to production
  • Planned and conducted end-user SAP BW training
Jan 2005 - Aug 2005
8 months
Germany
Lorem ipsum dolor sit amet

Insurance

  • Documented the existing data model
  • Gathered reporting requirements and implemented solutions
  • Modeled DataProviders and ETL processes
  • Integrated new ETL processes into existing chains for automation
  • Created reports with BEx Query Designer in coordination with business units
  • Extended the existing data model in reporting applications for SD and CO modules
  • Designed and implemented an authorization concept based on business requirements
Mar 2003 - Dec 2005
2 years 10 months
Germany
Lorem ipsum dolor sit amet

Utility

  • Collected reporting requirements from business units
  • Designed and delivered reporting for the IS-U industry solution
  • Extended the data model to include FI and PCA modules
  • Planned and conducted end-user training
  • Designed an Oracle database to prepare and distribute data from R/3 to various target systems
  • Adjusted BASIC scripts in MapInfo
Jan 2003 - Feb 2003
2 months
Germany
Lorem ipsum dolor sit amet

Consumer Goods

  • Modeled process chains
  • Created web templates
  • Planned and delivered SAP BW training for IT staff
Summary

I completed my computer science studies at Karlsruhe University of Applied Sciences in 2003 with a diploma thesis on using SAP Business Warehouse in a food industry company.

Building on the data warehousing knowledge I gained during my studies and diploma thesis, I started at cimt consulting ag in the SAP BI/BW area. In several SAP BW projects, I gained extensive skills in different areas of SAP BW and various source modules. Besides reporting projects, I also carried out planning projects with BW-BPS and BI-IP. I also successfully introduced SAP BusinessObjects Xcelsius in a client project.

As subproject lead, I coordinated and oversaw the work of the BI consultants involved in the project.

During a multi-year client engagement, I had the chance, alongside project work, to handle application management for an SAP BW system within a complex SAP landscape.

Languages
German
Native
English
Advanced
Education

Karlsruhe University of Applied Sciences

Diploma in Computer Science · Computer Science · Karlsruhe, Germany

Certifications & licenses

Prince2 Certified

Need a freelancer? Find your match in seconds.
Try FRATCH GPT
More actions