Marek Werulik

Participation in the following projects:
• DB Cargo (Germany) - MDM integration project. Started in March 2017
• Nordea (Finland) - MDM implementation project: 5 months full-time
• DB Cargo (Germany) - Legacy CRM transition to a modern CRM. 3 months part-time
• DB Schenker (Germany) – Global CRM / MDM consolidation project. 50 months full-time
• Skandia (Poland) – New CRM implementation project. Duration: 4 months part-time
• Azure Services (Malta) – New CRM implementation project. 6 months full-time
• Johnson & Johnson Vision Care – Global CRM consolidation project. 18 months full-time

Also engaged in shorter projects (solution design, blueprints preparation, project advisory, architecture review / audit) mainly from MDM domain.

Supporting different vendors accross Europe in Oracle CRM on Demand, Oracle Sales Cloud, Siebel UCM pre-sales processes and Oracle Master Data Management solutions offer

• 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 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

• 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

Oracle CRM on Demand Expert during CRM on Demand (R19 – R20) implementation for Insurance company. A part-time involvement
• Run Business Analysis workshops
• Prepared Functional Documentation
• Configured CRM on Demand
• Conducted End User training

Master Data Management Team Leader during CRM/MDM global rollout to 71 countries and 7000 users for two separate DB companies: DB Schenker Rail and Schenker Logistics. Fulltime involvement.
• Leading Data Management team (3 members)
• Design of customer data processes and structures
• Design of unique identifiers and references for integrated systems
• Responsible for Data Quality processes design and setup including deduplication rules, built of Golden Record, Customer Accounts hierarchies
• 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
• Single point of contact for integration with two subproject: corporate DWH and MDM Customer Profile
• Responsible for a design and build of tools effective supporting data migration and validation from external source systems enabling
• Leading data migration processes in all rollout countries and entities for CRM on Demand (85 different rollouts, 67 countries, 5500 active users, 150 data sources, 10M+ customer production data records migrated)
• Leading data migration processes for Oracle 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 all application releases, including planning and execution of mass data updates
• Participation in Proof of Concept subproject to migrate client from CRMoD 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

Senior CRM Project Manager / Subject Matter Expert during Oracle CRM on Demand (R19) Sales Edition implementation. 6 months fulltime involvement.
• 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
• 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

CRM / ETL Lead for EMEA region during Oracle (Siebel) CRM on Demand (Releases R17 to R19) global implementation
• Successfully deployed CRM on Demand in 18 months to 15 countries in Europe and Middle East
• Led the implementation for the whole region (solution architecture, business analysis, impact analysis, new functionality & bug fixing development)
• Data migration & integration with other IT systems and external data providers leadership
• Run train the trainer sessions and end-users training on site
• Cooperation with multiple parties from many countries (Business users, Development team, Local IT, External data providers)
• On-going support of live markets (administration, cooperation with business champions and key users to model and support business requirements)
• Ensure high level of CRM adoption to end users

• Member of CRM Eastern Europe & CIS region consulting department
• Involved in Siebel implementation projects:
•••• MTS (Russia, Telco) / Campaign data load optimization - 2010, Siebel CRM Technical Architect, EMEA Experts Team Leader
•••• Pannon GSM (Hungary, Telco) / Review of Siebel SFA & UCM implementation project - 2010, Siebel CRM / UCM Expert
•••• Polkomtel (Poland, Telco) / Solution architecture preparation for planned Siebel CRM implementation - 2009-2010, Solution Architect, Oracle Team Project Coordinator
•••• Rompetrol (Romania, Energy) / Siebel CRM 8.0 implementation - 2009, Solution Architect, Config Team Leader
•••• Oracle (Poland, IT) / Siebel CRM 8.1.1 implementation
2009, Siebel CRM Expert
• Supporting sales of Siebel CRM / UCM projects in Romania and Turkey

• Member of MDM Western Continental Europe consulting department
• Acting as Project Manager, System Architect, Business Analyst, Developer and Pre-sales depending on the project
• Frequently travel around Europe
• English – primary language at work
• Involved in projects:
•••• British Telecom (Germany, Telco) / MDM benchmarking project - 2009, Team Leader, Siebel UCM 8.1.1 Specialist. Benchmarking project run to test throughput of standard web services in Siebel UCM
•••• Areva T&D (France, Energy) / Siebel UCM 8.0 implementation, phase II - 2008, Siebel UCM Solution Architect.
•••• Belgacom (Belgium, Telco) / Solution Architecture preparation for future Siebel CRM and UCM implementation project - 2008, Siebel UCM 8.1.1 Solution Architect
•••• Shorter engagements: Allianz (Poland), Bouygues Telecom (France), L’Oreal (France), Telenor (Serbia)

• Member of the international department – IT Europe
• Involved in Siebel CRM implementation in 17 countries across Europe
• Data migration processes leadership in Ireland, Norway, Poland, Denmark, France, Belgium and Portugal
• Lead Implementation Analysis sessions
• Team management as a Secondary Team Leader
• Participation in the Pre-Change Request board
• Prepare analysis of raised Change Requests
• Work coordination with Third Party data providers, i.e. Cegedim or Dendrite
• Manage interfaces deployment to co-promote products between GSK and Roche or other pharmaceutical companies
• Manage master data validation interface deployment in 7 GSK markets
• Business and System Requirements analysis
• Prepare Technical Specification
• Data migration templates and data quality validation procedures development
• PL/SQL programming
• Train Data Team members in programming techniques
• Frequently travel around Europe and co-operate with people all over the world
• English – primary language at work
Used technologies (mainly): PL/SQL, Siebel Tools, EIM, Unix shell scripts, MS Project, XML

• Member of the implementation department of CRM system – Webforce
• Programmed the database side and user interface
• Developed interfaces for automatic data exchange with pharmaceutical companies
• Involved in data migration from legacy systems or other data sources
• Maintained synchronization and replication processes
• Wrote technical and user specification
• Prepared reports for data analysis
Used technologies (mainly): PL/SQL, Sybase, XML, C#, VBScript

• Implemented the Softlab SQL program, integrated ERP system in medium and big companies
• Configured warehouse and financial – accountancy modules
• Collected clients’ business requirements
• Developed reports using Crystal Reports and other Softlab systems
• Trained end users
• Presented ERP solutions for future clients
• Developed new database objects and functionality
• Involved in data migration from legacy systems or other data sources
Used technologies (mainly): T-SQL, XML, Delphi, Crystal Reports