Marek Werulik available

Marek Werulik

MDM Expert / Master Data Management Lead / Data Migration Expert

Profileimage by Marek Werulik MDM Expert / Master Data Management Lead / Data Migration Expert from Pruszkow
  • 05-800 Pruszkow Freelancer in
  • Graduation: 2005
  • Hourly-/Daily rates:
  • Languages: German (Elementary) | English (Full Professional) | Polish (Native or Bilingual)
  • Last update: 22.09.2020
I have over 15+ of professional experience including over 10 years with Master Data Management projects.

I have an experience leading MDM/MDG teams and projects in multinational large projects, from the blueprint phase, through design, development, delivery and post go-live. I have an experience as the solution architect, mdm stream/project lead, data migration expert, data quality expert. I also have an experience with most of the required activities: data model definition, solution architecture, data quality (standardization, harmonization, cleansing, de-duplication) rules definition, process analysis, technical design, data mapping, data migration, setting up data governance processes, setting up support organization and many others.

I worked with several leading Master Data Management and Data Quality solutions from Informatica, SAP, IBM Infosphere, Talend, Oracle, Siebel.

I also have extensive experinece leading large data migration projects with multiple sources, complex transformations, cleansing, deduplication and leading multinational teams.
  • Swiss Krono (Germany) – Interim MDM IT Process Owner and MDM Project Lead – Full time engagement from January 2019 until March 2019
    • Leading MDM project (5 consultants) supported by Global MDM organization (4 data stewards)
    • Responsible for the definition of TO-BE processes for the governance of Material Master and Business Partners in S4/HANA
    • Leading the team responsible for the definition of master data information: Material Master, BOM, Customer and Vendor data plus referential data, naming conventions, data standards
    • Setting up data governance framework: procedures, policies and tools supporting management of the master data
    • Defining data migration processes from three legacy systems to S4/HANA, harmonizing existing referential data
  • Roche (Switzerland) – MDM Solution Architect & MDM Dev Team Lead – Full time engagement from September 2017 until January 2019
    • Responsible for solution architecture within IDMP & Master Data Alignment programme
    • Data architecture of products, organizations and regulatory data
    • Lead the data migration activities
    • Designed Regulatory Master Data Hub architecture using Informatica MDM Hub, TIBCO and Informatica PowerCenter
    • Lead a team of 6 developers to setup MDM Hub and E2E processes between sources, MDM Hub and downstream systems
    • Designed the integration with RIMS, Submission Tool and Supply Chain Management
    • Supported Linguamatics I2E PoC to extract content from documents
  • Messe München (Germany) – MDM Architect – December 2017
    • Analysis of As-Is and definition of high-level To-Be data architecture and systems landscape with a focus on customer data domain. Mapping of Talend MDM capabilities with the collected requirements. Definition of the transition plan
  • Messe München (Germany) – Data Quality and Migration Expert – Full time engagement from July 2017 until October 2017
    • Responsible for improving the customer master data quality
    • Leading data migration process: concept creation, profiling, cleaning, standardization, mapping, transformation (Talend) and migration
    • Leading a team of two consultants building data quality enrichment rules, conversions and data migration from Siebel and MS Dynamics into Salesforce
  • DB Cargo (Germany) – MDM Architect. Full time Involvement from March 2017 to July 2017
    • Customer data structures design
    • Functional and technical design of the integration between MDM platform (Siebel UCM with EDQ) and main consuming + source system (Oracle Sales Cloud) using Oracle Integration Cloud Service
    • Initial data migration design from Oracle Sales Cloud to MDM including data profiling, data cleaning and standardization
    • Leading a team of two developers (one from Sales Cloud, one from Integration Cloud Service)
  • Nordea (Finland) – MDM Business Data Architect. Full time involvement from November 2016 to March 2017
    • Roadmap and project planning for data transition and system decommissioning of five legacy customer master data system into one global platform based on IBM InfoSphere MDM plus OSB, IBM CDC, IBM Data Stage and Event Manager
    • Leading data analysts team (2 resources) profiling the data and mapping information elements from mainframe legacy systems to business data model layer used as an abstract layer in global MDM platform
    • Driving non-functional requirements deployment related to authorization, authentication, logging and data access auditing
  • DB Cargo (Germany) – CRM Data Migration Leader – Part time involvement from November 2016 to January 2017
    • Leading data migration team to profile, map, convert and migrate 850 users and their data from Oracle CRM on Demand to Oracle Sales Cloud
    • Resource and project planning from data workstream perspective
  • City Hall of Warsaw (Poland) – MDM Solution Architect. Solution architecture design to enhance existing Siebel instance as customer master data system. Part time involvement from August 2016 to October 2016.
  • CuReMa (Germany) – Solution Architect. Support solution architecture design of two new web applications to manage projects’ risks and timesheets. August 2016 – September 2016.
  • DB Schenker (Germany) – CRM Architect / Data Management Team Leader during CRM global rollout to 71 countries and 7000 users for two separate Deutsche Bahn companies: DB Rail and Schenker Logistics. Fulltime involvement from June 2012 to July 2016. Around 50 individual IT systems were replaced by the global CRM solution. Project was run in Waterfall methodology at the beginning and changed to Agile from 2013.
    • Resource and workload planning – leading Data Management team (3 members)
    • Design of customer data processes and data structures
    • Design of unique identifiers and references for integrated systems
    • Supported Integration Architect in E2E outbound and inbound interfaces design. Managed tests of the interfaces with the rollout entities
    • Responsible for Master Data Governance (MDG) processes and tools design to improve the data quality: consistency, completeness and uniqueness.
    • Designed data quality rules to build Golden Record based on the incoming information from different data sources
    • Designed solution architecture for Oracle Fusion Customer Data Hub and integration with CRM. Design of matching rules with embedded Informatica Identity Resolution (IIR) data quality tool
    • Proof of concept support with Oracle Enterprise Data Quality (EDQ)
    • Single point of contact for integration with two subproject: corporate DWH and Schenker Logistics MDM Customer Profile
    • Responsible for a design and build of tools supporting effective data migration and validation from external source systems
    • Leading data migration processes in all rollout countries and entities (85 different rollouts, 67 countries, 5500 active users, 150 data sources, 10M+ customer production data records migrated). This includes data migration and integration workshops with senior key business (up to MD, SVP level) and IT representatives, data scope definition, fit gap analysis, data profiling, de-duplication, test and production migration
Mapped, migrated and finally decommissioned systems: Salesforce, SuperOffice Caesar, Smart CRM and many custom made
  • Leading data migration processes for Oracle (Fusion) Sales Cloud: 71 organizations with 6500 active users and 16M+ customer data records of different information entities migrated from legacy applications to Oracle Sales Cloud
  • Participation in Proof of Concept subproject to migrate client from Oracle CRM on Demand to Oracle Sales Cloud
  • Define the strategy and processes of migrating the data and users from CRMoD to Oracle Sales Cloud as the last phase of the project
  • Support redesign the processes defined in Oracle CRM on Demand to use out of the box functionality in Oracle Sales Cloud whenever possible
  • Leading design, validation and migration of master billing accounts and financial information from 63 SAP instances
  • Participation in all application releases, including planning and execution of mass data updates
  • Skandia (Poland) – CRM Expert. Part time involvement from June 2012 to September 2012. And April 2013.
    • Run Business Analysis phase related sales activities management
    • Prepared Customer Life Cycle Functional design
    • Implement the customer structure and management processes in Oracle CRM on Demand
    • Data migration to CRM on Demand and Marketing on Demand
    • Conducted End User training and technical workshops for administrators
  • 3M (Poland) – CRM Expert. Part time involvement in January 2013 and March 2014.
    • Run Business Analysis phase related to lead management processes
    • Implement data structures and data management processes in Oracle on Demand
    • Setup data migration processes for the client
  • Azure Services (Malta) – Senior CRM Project Manager / Subject Matter Expert during Oracle CRM on Demand (R19) Sales Edition implementation. Fulltime involvement from December 2011 to June 2012.
    • Managing the project and a team of five senior consultants
    • Responsible for an overall solution architecture of CRM domain covering Marketing, Sales and Member Services processes
    • Data architecture design of CRM and supporting marketing application
    • Involved in integration architecture design with external marketing application, mass mailing system, documents generating application, hotel reservations system and CTI
    • Supporting the project as Oracle CRM on Demand expert
  • Elsevier (UK) – MDM Subject Matter Expert. Short engagement in October 2011.
    • Run Business Analysis workshops
    • Working with the Consulting Partner and the customer on the solution architecture of the Customer Data Hub
  • Johnson & Johnson Vision Care (Poland) – CRM / ETL EMEA Lead during Oracle CRM on Demand (R17 – R19) Life Sciences Edition global implementation. Fulltime involvement from July 2010 to December 2011.
    • Successfully deployed Oracle CRM on Demand to 14 countries in Europe and Middle East.
    • Leading the implementation of the global project for the region supporting local business specific requirements (solution architecture, business analysis, impact analysis, new functionality & bug fixing development, release management)
    • Data architecture design
    • E2E integration architecture design with financial systems
    • Managing country rollouts by running data migration and integration workshops with senior key business and IT representatives, data scope definition, fit gap analysis, data profiling, de-duplication, test and production migration
    • Mapped business processes, migrated data and finally decommissioned several systems, mainly Salesforce which was used in Central and Western Europe
    • Managing data migration & integration with other IT systems done locally or by external data providers
    • Running training for pilot users end-users on site or remotely
    • Managing cooperation with multiple parties from all countries participating in a project (business users, development team, local IT, external data or services providers)
    • On-going support of live markets. Cooperation with business champions and key users to model and support post go-live business requirements
    • Involved in migration to Single Tenancy and CRM Desktop (offline client) rollout
    • Ensure high level of CRM adoption to end users
  • PriceWaterhouseCoopers (United Kingdom) – Supporting pre-sales process for Oracle MDM advisory project for a publishing sector customer in the UK
  • People-At-Work (Germany) – Supporting pre-sales process for Oracle MDM implementation for a telco customer located in Switzerland
  • Oracle (Poland) – Supporting pre-sales processes and customer workshops related to Oracle CRM on Demand projects
  • CGI (Poland) – Supporting pre-sales processes related to Oracle CRM on Demand projects
  • Euro Consulting EMEA (Malta) – Supporting pre-sales processes related to Oracle CRM on Demand and Oracle RightNow projects
  • MTS (Russia) – Leading Consultant during analysis of Siebel 8.0 Campaign Management processes
    • Leading a team of three consultants
    • Responsible for delivering project review document, describing standard mechanism of loading campaign data as well as running throughput tests on demo environments
  • Pannon GSM (Hungary) – Audit Siebel 8.1.1 SFA & UCM project
    • Preparation of Project Assessment document
    • Delivered UCM workshop to Pannon project management team
  • Polkomtel (Poland) – Solution Architect during Siebel 8.0 implementation as a core system in CRM domain
    • Project delivery coordinator managing four Oracle consultants
    • Responsible for solution architecture in Customer and Account Management area and E2E integration with other domains
    • Technical & Business Use Cases preparation
  • Rompetrol (Romania) – Solution Architect and Leading Developer during Siebel CRM 8.0 implementation
    • Leading development team of three consultants
    • Responsible for the overall solution preparation (design, configuration, testing, deployment)
    • Siebel configuration – Account Management and Service Requests functional areas
    • Development and test environments management
  • Oracle (Poland) – Siebel Advisor during Siebel Call Center and eService 8.1.1 implementation for Oracle Hotline
  • Supported Siebel UCM / Oracle MDM sales process at Avea (Turkey), CEC Bank (Romania), Pravex Bank (Ukraine), Raiffeisen Bank (Romania) and Turk Telecom (Turkey)
  • Supported Siebel CRM sales process at Allianz (Romania)
  • Allianz (Poland) – Siebel UCM Expert
    • Support Wola Info in Siebel UCM project preparation for Allianz
  • Areva T&D (France) – Siebel UCM Consultant during Siebel 8.0 implementation
    • Data modeling and design of globally unique identifiers of the data
    • Data migration from source systems using Informatica PowerCenter
    • Master Data Governance rules setup to improve data consistency, standardization and uniqueness
    • Built integration with other IT systems
    • Siebel configuration and introduction of new functionality
    • Built good relations with the client which lead Oracle to extend the project to next phases
    • Setup of data matching rules in Informatica Identity Resolution connected with Siebel
    • Shadowed by junior Oracle consultant
  • Belgacom (Belgium) – Siebel UCM expert
    • A member of successful team which run Proof of Concept on customer site that turned into selling licenses and consultancy
    • Positioned Siebel UCM and CRM in the overall Belgacom architecture
    • Activity finished with the presentation to Belgacom top management
  • British Telecom (Germany) – Siebel 8.1.1 benchmarking project
    • Act as Siebel UCM Consultant + Oracle database specialist
    • Project conducted at Hewlett-Packard European Performance Center in Stuttgart for British Telecom
    • Responsible for installation of Siebel enterprise software on farm of servers including Oracle database, Siebel UCM and Oracle Data Quality servers on Linux and Windows boxes
    • Real-time integration tests leadership
    • A central person in the project co-operating with India offshore center, Database Administrators, consultants tuning the application and other staff
    • Preparation of SQL procedures for data randomization and migration
  • ByTel (France) – Siebel UCM expert
    • Pre-sales activity which turned into a long engagement for the team
  • L’Oreal (France) – Siebel UCM expert
    • Preparation of Prove of Concept for Siebel UCM implementation
  • Telenor (Serbia) – Siebel UCM expert
    • Preparation of Siebel UCM project offer for the customer
Most of my projects in the last ten years had headquarters abroad. Because of my rollout management roles, I traveled frequently within Europe.
My preferred way of working is 4 days / week on site, 1 day / week remote.

I am happy to travel to any location in Europe which has reasonable connections with Warsaw (Poland) airport.
My projects are run on time and within the budget. I am a hard working person, always keeping the deadlines. I am honest to the customer.