Impressum

CURRICULUM 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:

    • 2 years, BG-Phoenics GmbH
    • 1 year, Bundesanstalt für Immobilienaufgaben
    • 2,5 years, Messe Berlin GmbH
    • 5 months, VGV Verwaltungsgesellschaft für Versorgungswerke mbH
    • 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:
    2 years
    BG-Phoenics GmbH     		Role: SAP BW Consultant, SAP BW Architect
    Project:
    • Implementation of Master SAP BW System for parallel usage of several customers (one development system/several system landscapes)
    • Reimplementation of all ABAP Developments according to Master BW System
    • Implementation of central customizing tools in order to meet all individual customer requirements in quality and productive BW systems
    • Implementation of customizing solution for showing of individual customer logo in Analysis for Office reports
    • Implementation of ABAP Report for coping of hierarchies
    • ABAP Implementation of tools for individual customized executing of process chains and infopackages
    • Performance tuning of ABAP Implementations in datasources in source systems
    • ABAP Implementation of Report-Report-Interface for opening PDF invoices directly from Archiving system
    • Migration of ABAP BeX Variables from User Exit (CMOD) to BAdI
    • Implementing of ABAP Methods for InfoProvider data remodeling of characteristics and keyfigures values
    • Analyzing of authorizations problems in SAP BW
    1 year
    Bundesanstalt für Immobilienaufgaben    		 Role: SAP BW Consultant, SAP BW Architect
    Project:
    • In-place conversion of BW System Landscape to BW4HANA
    • Planning of concept and migration phase
    • Execute housekeeping and migration steps
    • Migration of ABAP BeX Variables from User Exit (CMOD) to BAdI
    • Analysis and reimplementation (according to Simplification List for SAP BW/4HANA) of all ABAP developments in SAP BW
    2,5 years
    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
    • Loading and activating authorizations from ERP into SAP BW System
    5 months
    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
    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
    • 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)
    __________________________________________________________________________________________________________________________________________________________________________________________