Impressum


CURICULUM VITAE

Dipl. Inf. (Univ.) Marcin Chmiel
Senior Consultant at SAP Deutschland SE & Co. KG




Profile:

Marcin Chmiel is working as a senior consultant for SAP NetWeaver BI since Dezember 2006. Initially he worked for a partner company of SAP. In November 2008 he joined SAP as a consultant in the Business Information Management team. He offers a very good knowledge of BW, BI Mobile gained by SAP courses and in several customer projects. In addition to several consulting activities in the BI area he was responsible for functional business specifications and technical design in On- / Offshore environments. Hence his core subject ranges from system landscape architecture designs to implementation competences in data extraction, data modelling and reporting front-ends. He is certified in SAP BW 7.0 and he is working as a instructor at SAP Education.


SAP Experience – Summary:
  • Very good knowledge of SAP Business Warehouse
  • SAP courses TBW10, TBW20, TBW41, TBW42, TBW45, DBW73, BW362
  • Partner company of SAP courses SAP FI/CO, ABAP, SEM BCS
  • Data flow modeling
  • Very good knowledge of automated testing in SAP BW
  • Very Programming Knowledge in ABAP for SAP BW (Backend and Frontend)
  • Knowledge in the In-Memory Technology

Professional Experience & Certifications – Summary:

  • 06/17 until present, VGV Verwaltungsgesellschaft für Versorgungswerke mbH
  • 12/16 until present, Messe Berlin GmbH
  • 1 year, Bank für Sozialwirtschaft AG
  • 1 month, Federal-Mogul Burscheid GmbH
  • 2 months, BERICAP Holding GmbH
  • 3 months, Nestlé Suisse SA
  • 1 year, MKM Mansfelder Kupfer und Messing GmbH
  • 2 months, VSE Aktiengesellschaft
  • 1 month, GMH Systems GmbH
  • 3 months, Rolls-Royce
  • 2 months, Gravity Pro Consulting
  • 1 month, Man Truck & Bus AG
  • 1 month, Rewe Zentralfinanz eG
  • 3 months, Schweizer Post
  • 4 months, Continental
  • 1 year, The Standard Bank of South Africa
  • 2 years, SAP Education
  • 3 months, Shell International Petroleum
  • 2 months, Pacific Gas & Electric Company
  • 3 months, BG Group
  • 3 months, Helvetia Schweizerische Versicherungsgesellschaft AG
  • 4 months, Continental
  • 6 months, Robert Bosch GmbH
  • 6 months, Deutsche Bank
  • 3 months, ThyssenKrupp
  • 2 months, BMW AG
  • 4 months, BASF AG
  • 2,5 years, Daimler AG
  • 1 month, 3M
  • 1 month, SAP IT
  • 1 month, Biotronik SE & Co.KG
  • 2 months, ZF Friedrichshafen
  • 4 months, SAP IT Locations Strategy & Management IPO
  • 6 months, SAP IT IMS NW BI Maintenance
  • 6 months, SAP IT, Business by Design
  • SAP BW certified Solution Consultant since 2008/12
  • 12/05 - 10/08 Technology Consultant at Accenture Technology Solutions
  • 9 months, Deutsche Telekom AG
  • 8 months, Nokia Siemens Networks GmbH
  • 6 months, Siemens COM
  • 7 months, Siemens Financial Services
  • 4 months, BMW Financial Services
  • 4 months, private contracting authority
  • 4 months, HypoVereinsbank
  • 2001 - 2005, Studies of Computer Science at the University of Munich (LMU), Degree: Diplom-Informatiker (Univ.)
  • Software skills:  MS Access, MS Excel, Word, MS Project, MS PowerPoint
  • Programming skills: ABAP, Java, VBA, C++, Unix/Linux Shell Script, SQL, HTML

Project Experience – Detail:


06/17 until present
VGV Verwaltungsgesellschaft für Versorgungswerke mbH
Role: SAP BW Consultant, SAP BW Architect
Project:
  • Technical Design of new data flows for calculation of sales measures
  • Creating of modelling guidelines and naming conventions for SAP BW System
  • Design and implementation of process chains in SAP BW
  • Creating of Businessobjects Web Intelligence Reports
  • Implementing of data flows and error handling for loading of data from flat files
12/16 until present
Messe Berlin GmbH
Role: SAP BW Consultant, SAP BW Architect
Project:
  • Investigation  of current development status in SAP BW System according to LSA structure
  • Migration of 3.x data flows to 7.x data flows in SAP BW
  • Deleting of unusable and obsolete objects and data flows in SAP BW
  • Creating of modelling guidelines and naming conventions for SAP BW System
  • Design and implementation of process chains in SAP BW
  • Design and implementation of Corporate Memory in SAP BW
1 year
Bank für Sozialwirtschaft AG
Role: SAP BW Consultant, SAP BW Architect
Project:
  • Implementing of DataSources based on function module in SAP ERP System
  • Creating of modelling guidelines and naming conventions for SAP BW System
  • Implementing of new data flows in SAP BW
  • Development of start and end routines (ABAP)
  • Creating of new BeX queries and reports
  • Creating of technical documentation
  • Implementing of virtual KeyFigures
1 month
Federal-Mogul Burscheid GmbH
Role: SAP BW Consultant, SAP BW Architect
Project: SAP BW Integrated Planning Workshop
  • Preparation and execution of a workshop for SAP BW Integrated Planning
  • Verifying the feasibility of customer requirements
2 months
BERICAP Holding GmbH
Role: SAP BW Consultant, SAP BW Architect
Project: Designing of Reporting Solution with SAP Manufacturing Intelligence and Integration in SAP BW
  • Verifying the feasibility of customer requirements for Reporting in SAP BW
  • Designing of End-Solution for Reporting from SAP MII
3 months
Nestlé Suisse SA
Role: SAP BW Consultant, Commentary Solution Expert
Project: Implementing of Commentary Solution in Customer System
  • Creation of Standard Reporting Templates for Commentary Solution (Web Application Designer, Analysis for Office)
  • Customizing of Commentary Solution in customer system
  • Creation of virtual provider for consuming of comments
  • Creation of MultiProvider for consuming of comments
  • Creation of authorization object and authorization roles for Commentary Solution
  • Importing of Commentary Solution into customer system
  • Implementing of Web Dynpro Application for Creating of Comments
  • Knowledge Transfer Workshop
1 year
Mansfelder Kupfer und Messing GmbH
Role: SAP BW Consultant, SAP BW Architect
Project: Implementing of new SAP BW System, Implementing of new Reports in SAP BW System
  • Implementing of DataSources based on function module in SAP ERP System
  • Creating of concept for user authorizations in SAP BW
  • Implementing of methods for dynamically checking of user’s analysis authorizations
  • Creating of modelling guidelines and naming conventions for SAP BW System
  • Implementing of new data flows in SAP BW
  • Development of start and end routines (ABAP)
  • Creating of new queries and reports
  • Creating of technical documentation
  • User training for BeX Query Designer and Analysis for Office
  • Implement methods for automatically distributing of planning data according to factory calendar
2 months
VSE Aktiengesellschaft
Role: SAP BW Consultant
Project: Technical support for SAP BW System
  • Support for implemented data flows, BeX Queries and ABAP Routines in SAP BW System
1 month
GMH Systems GmbH
Role: SAP BW Consultant, Commentary Solution Expert
Project: Commentary Solution upgrade
  • Upgrade of Commentary Solution to the newest version in SAP BW System
  • Testing activities in SAP BW System after Commentary Solution Upgrade
3 months
Rolls-Royce
Role: SAP BW Consultant, Commentary Solution Expert
Project: Implementing of Commentary Solution in Customer System
  • Creation of Standard Reporting Templates for Commentary Solution (Web Application Designer, Analysis for Office)
  • Customizing of Commentary Solution in customer system
  • Creation of virtual provider for consuming of comments
  • Creation of MultiProvider for consuming of comments
  • Creation of authorization object and authorization roles for Commentary Solution
  • Importing of Commentary Solution into customer system
2 months
Gravity Pro Consulting
Role: SAP BW Consultant, Commentary Solution Expert
Project: Implementing of Commentary Solution in Customer System
  • Creation of Standard Reporting Templates for Commentary Solution (Web Application Designer, Analysis for Office)
  • Customizing of Commentary Solution in customer system
  • Creation of virtual provider for consuming of comments
  • Creation of MultiProvider for consuming of comments
  • Creation of authorization object and authorization roles for Commentary Solution
  • Importing of Commentary Solution into customer system
1 month
MAN Truck & Bus AG
Role: SAP BW Consultant, Commentary Solution Expert
Project: Workshop for SAP BW Commentary Solution
  • Verifying the feasibility of customer requirements for Commentary Solution in SAP BW
  • Workshop for Commentary Solution for SAP BW
2 months
Rewe Zentralfinanz eG
Role: SAP BW Consultant
Project: New implementation of SAP BW on Hana, Proof of Concept
  • Technical Design of new data flows for calculation of sales volumes and controlling reports
  • Technical Design of ABAP Reports and Routines in data flows for calculation of key figures
  • Development of data flows in SAP BW
  • Creating of Queries
  • Creating of Reports in Analysis for Office
  • Implementing of commentary solution for SAP BW
  • Currency calculation in reports
  • Multiplying of data for demo purposes (from 110 million data rows to 5,2 billion data rows)
  • Loading of data from Microsoft SQL database
  • Creating of technical documentation
12 months
The Standard Bank of South Africa
Role: SAP BW Consultant, Commentary Solution Expert
Project: Programming of new functionalities (commenting on several measures in Analysis for Office, locking functionality for hierarchy nodes) for Commentary Solution
  • Creation of new Analysis for Office Reports
  • Importing of Commentary solution into Customer System
  • Creating of technical documentation
  • Training of team members
  • Creating of performance Tests
  • Creating of new BeX Queries and standard reports with commentaries
3 months
Continental
Role: SAP BW Consultant, Commentary Solution Expert
Project: Implementing of Commentary Solution in Customer System
  • Creation of Standard Reporting Templates for Commentary Solution (Web Application Designer, Analysis for Office)
  • Customizing of Commentary Solution in customer system
  • Creation of virtual provider for consuming of comments
  • Creation of MultiProvider for consuming of comments
  • Creation of authorization object and authorization roles for Commentary Solution
  • Importing of Commentary Solution into customer system
3 months
Schweizer Post
Role: SAP BW Consultant, Commentary Solution Expert
Project: Implementing of Commentary Solution in Customer System
  • Creation of Standard Reporting Templates for Commentary Solution (Web Application Designer, Analysis for Office)
  • Customizing of Commentary Solution in customer system
  • Creation of virtual provider for consuming of comments
  • Creation of MultiProvider for consuming of comments
  • Creation of authorization object and authorization roles for Commentary Solution
  • Importing of Commentary Solution into customer system
2 years
SAP Education
Role: SAP BW Instructor,
Project: teaching SAP BW standard courses:
  • BW310 - BW - Enterprise Data Warehousing
  • BW305 - BW – Enterprise Reporting, Query + Analysis
  • BW307 - BW Web Application Designer
  • TBI20 - Web Application Designer & Data Warehousing
3 months
Shell International Petroleum, London
Role: SAP BW Consultant, Commentary Solution Expert
Project: Implementing of Commentary Solution in Customer System
  • Creation of Standard Reporting Templates for Commentary Solution
  • Customizing of Commentary Solution in customer system
  • Creation of virtual provider for consuming of comments
  • Creation of MultiProvider for consuming of comments
2 months
Pacific Gas & Electric Company,
San Francisco
Role: SAP BW Consultant, Commentary Solution Expert
Project: Implementing of Commentary Solution in Customer System
  • Creation of Standard Reporting Templates for Commentary Solution
  • Customizing of Commentary Solution in customer system
  • Creation of virtual provider for consuming of comments
  • Creation of MultiProvider for consuming of comments
3 months
BG Group, London
Role: SAP BW Consultant, Commentary Solution Expert
Project: Implementing of Commentary Solution in Customer System
  • Creation of Standard Reporting Templates for Commentary Solution
  • Customizing of Commentary Solution in customer system
  • Creation of virtual provider for consuming of comments
  • Creation of MultiProvider for consuming of comments
3 months
Helvetia Schweizerische Versicherungsgesellschaft AG
Role: SAP BW Consultant, Commentary Solution Expert
Project: Implementing of Commentary Solution in Customer System, Implementing of Analysis for Office Template for commenting of several measures for Commentary Solution Creation of Standard Reporting Templates for Commentary Solution (Web Application Designer, Analysis for Office)
  • Customizing of Commentary Solution in customer system
  • Creation of virtual provider for consuming of comments
  • Creation of MultiProvider for consuming of comments
  • Creation of authorization object and authorization roles for Commentary Solution
  • Implementing of Analysis for Office Template (VBA)
  • Importing of Commentary Solution into customer system
4 months
Continental
Role: SAP BW Consultant, Commentary Solution Expert
Project: Implementing of Commentary Solution in Customer System, Implementing of function module (ABAP) for consuming of comments in Web Application Designer
Implementing of a Template with function module for consuming of comments in WAD
  • Creation of Standard Reporting Templates for Commentary Solution
  • Customizing of Commentary Solution in customer system
  • Creation of virtual provider for consuming of comments
  • Creation of MultiProvider for consuming of comments
6 months
Robert Bosch GmbH
Role: SAP BW Consultant
Project: Planning data retraction from SAP BCS to SAP ERP – Technical Design and implementation
  • Technical design and implementation of ABAP function modules, BADIs for data retraction to several SAP ERP systems
  • Creation of RFC connections SAP BW – SAP ERP
  • Creating of new BeX queries for data retraction
  • Creating of technical documentation
6 months
Deutsche Bank
Role: SAP BW Consultant, project coordinator
Project: Development of a SAP BW architecture for reconciliation of financial data
  • New Technical Design of reconciliation model – Reconciliation Hub – in SAP BW
  • Development (ABAP) of data flows in SAP BW with extensions in ABAP
  • Coordination of technical environments and data extraction
  • Creating of technical documentation
3 months
ThyssenKrupp
Role: SAP BW Consultant,
Project: New implementation of SAP BW APO
  • Technical Design of new dataflows for calculation of shipment expectation/calls of order/deliveries in SAP BW APO
  • Technical Design of ABAP Reports and Routines in dataflows for calculation of key figures
  • Optimizing the data flow performance
  • Development of data flows in SAP BW
  • Creating of technical documentation
2 months
BMW AG
Role: SAP BW Consultant,
Project: Provisioning of new data in SAP BW system
  • Solution design and development of new data flows
  • Development (ABAP) of new tools for testing activities of data flow in SAP BW
  • Development of new Excel reports (VBA & ABAP)
  • Creating of new BeX Queries and standard reports
  • Testing of data extraction
  • Creating of technical documentation
3 months
BASF
Role: SAP BW Architect, SAP BW Architect Consultant
Project: Implementing of prototype for hierarchy costs in SAP BW
  • Intercompany eliminations
  • Performance tuning
  • Testing of data extraction
  • Creating of performance Tests
  • Ensuring the technical feasibility
  • Creating of technical documentation
2,5 years
Daimler AG
Role: SAP BW Consultant,
Project: Provisioning of new data in SAP BW system for analysis of planning and controlling data
  • Solution design and development of new data flows
  • Development of start routines (ABAP)
  • Development (ABAP) of new tools for testing activities of data flow in SAP BW
  • Development of new Excel reports (VBA & ABAP)
  • Creating of new BeX Queries and standard reports
  • Testing of data extraction
  • Creating of technical documentation
1 month
3M
Role: SAP BI Mobile Consultant,
Project: Mobile BI Workshop
  • BI Mobile -  overview for reporting on mobile devices
  • Technical preconditions for mobile reporting
  • Introduction to SAP IPad Apps (BO Explorer, EViews, BI Mobile)
  • Restrictions compared to Business Objects Reporting
  • Live presentation on IPad
1 month
SAP IT
Role: SAP BW Consultant,
Project: Test automation workshop for SAP BW and remote consulting
  • Creating of regression tests for SAP BW
  • Creating of stress tests for SAP BW
  • Creating of performance Tests
  • Training of team members
1 month
Biotronik SE & Co.KG
Role: SAP BI Mobile Consultant,
Project: Proof of concept for Mobile BI on IPad (iOS)
  • Technical preconditions for Mobile BI Reporting on IPad
  • Ensuring the technical feasibility
  • Checking of network architecture
  • Introduction  to SAP IPad Apps (BO Explorer, EViews, BI Mobile)
  • Live presentation on IPad
2 months
ZF Friedrichshafen
Role: SAP BW Consultant,
Project: Test automation workshop for SAP BW and remote consulting
  • Creating of regression tests for SAP BW
  • Creating of stress tests for SAP BW
  • Creating of performance Tests
  • Team members training
4 months
SAP IT Locations Strategy & Management IPO
Role: SAP BW Consultant,
Project: Provisioning of new data in SAP BW system for analysis of SAP locations
  • Solution design and development of new data flows
  • Extension of existing data flows
  • Creating and maintaining process chains
  • Development of start routines (ABAP)
  • Creating of new BeX Queries and reports
  • Creating of technical documentation
  • Testing of data extraction
6 months
SAP IT IMS NW BI Maintenance
Role: SAP BW Consultant,
Project: Technical design and implementation of automated test with trace tool in SAP BW systems
  • Preparation of SAP BW systems for testing activities
  • Concept definition and development of automated tests in SAP BW systems (java and ABAP)
  • Creating and executing of regression tests
  • Creating of technical documentation
6 months
SAP IT Business by Design
Role: SAP BW Consultant,
Project: Ensuring the quality and stability of SAP BW systems, especially data quality in SAP BW systems
  • Organization of the preparation of BI systems for testing activities
  • Technical analysis and troubleshooting to problems of data supply
  • Creating and monitoring of process chains
  • Creating and monitoring of data flow for real-time data acquisition
  • Creating of technical documentation
  • Execution of regression tests
  • Technical analysis and troubleshooting to reporting problems
  • Testing of data extraction
9 months
Deutsche Telekom AG
Role: Software developer, Solution Consultant
Project: Implementing of reporting tool for preliminary financial closing activities
  • Solution design and development of reporting tool
  • Professional and technical customer support
  • Creation of technical documentation
  • Team members training
8 months
Nokia Siemens Networks GmbH
Role: Solution Consultant, SAP BW Consultant,
Project: technical Support for SAP BW System, SEM-BCS and for PE Collector, implementation of change requests
  • Professional and technical customer support
  • Reconciliation between SAP BW and Hyperion
  • Reconciliation between PE Collector and Hyperion
  • Preparation of carry-forward procedure
  • Currency translation in SAP BW
  • Adjustment of FCT profiles in SAP BW
  • Creation of Excel-Reports from PE Collector
  • BEx-Reporting
  • Creation of technical documentation
6 months
Siemens COM
Role: Solution Consultant, SAP BW Consultant,
Project: Adaptation of SAP BW, SEM-BCS (based on Siemens B + template) for the integration of companies Siemens COM, Nokia Siemens Networks; establishment of alternative data streams (PE collector) for group and management reporting
  • Solution design and development of reporting tool
  • BEx-Reporting
  • Adjustment of FCT profiles in SAP BW
  • Creating of technical documentation
  • Creating of Excel-Reports
7 months
Siemens Financial Services
Role: Solution Consultant
Project: technical support, maintenance, development and documentation of end-of-day process for banking system Murex MxG2000
  • Stabilization  and tuning of the EOD
  • Tuning of Reports
  • Unix Shell Scripting
  • Professional and technical customer support
  • Trainings
  • Creation of technical documentation
4 months
BMW Financial Services
Role: Solution Consultant,
Project: Coordination of technical environments (development, test, production)
  • Coordination of technical environments
  • Creation of technical documentation
4 months
HypoVereinsbank
Role: Software developer
Project: Implementation of an electronic payment system (PalME System) for the Palm Vx. Creation of technical documentation for certification „Common Criteria for Information Technology Security Evaluation“
  • Implementation of PalME System in C++
  • Creation of technical documentation

General information:
Dipl.- Inf. (Univ.) Ludwig-Maximilians-Universität München

SAP certification SAP Certified Application Associate- Business Intelligence with SAP NetWeaver 7.0

SAP trainings: Enterprise Data Warehousing (TBW10)
Reporting & Query Design (TBW20)
Advanced Enterprise Data Warehousing & Reporting  (TBW42)
Integrated Planning (TBW45)
SAP BW powered by SAP HANA (BW362)

Languages: Polish (native)
German (fluent)
English (fluent)
Russian (basic)

__________________________________________________________________________________________________________________________________________________________________________________________