Robert Wunsch
SAP Senior Consultant – Business Intelligence / Business Warehouse
Experience
Jun 2022 - Jan 2023
8 monthsGermany
Lorem ipsum dolor sit amet
Insurance
- Supported the business department in defining change requests
- Tested and accepted developments
Sep 2021 - Present
3 years 11 monthsGermany
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 monthsGermany
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 yearsGermany
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 monthsGermany
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 monthsGermany
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 monthsUnited 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 monthsGermany
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 monthsGermany
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 monthsUnited 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 monthsGermany
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 monthsGermany
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 monthsGermany
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 monthGermany
Lorem ipsum dolor sit amet
Consumer Goods
- Created and adjusted existing planning layouts
- Implemented planning functions
Apr 2010 - May 2010
2 monthsGermany
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 monthsGermany
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 monthsGermany
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 monthsGermany
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 monthsGermany
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 monthsGermany
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 monthsGermany
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
NativeEnglish
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
Similar Freelancers
Discover other experts with similar qualifications and experience
