The ProMi Squad (Process Mining) project aims to transparently map the entire order process in the portals area. Relevant data sources from order to activation are combined for this. A holistic view of the end-to-end process makes it possible to identify process deviations and optimization potential. Key milestones of the project are connecting the required data sources, building self-service reports, and implementing automated alerts for process deviations. The challenge lies in the technical and functional integration of heterogeneous systems and data flows to ensure consistent monitoring and control of the ordering process. ⸻ Service Description - Analysis and documentation of requirements in the omnichannel area using requirements management tools and structured elicitation methods - Functional and technical analysis of existing data sources and ETL processes using database tools - Capturing and evaluating existing interfaces between source and target systems based on technical documentation - Consulting on the technical integration of defined data sources into the Celonis environment, taking into account the used tools Celonis EMS, Data Pool, and Data Push API - Creating technical queries and visualizations for process mapping based on the platform features provided (Celonis PQL, Studio) - Using system functions to visualize and analyze existing business processes (via the Celonis Process Explorer) - Functional consulting on technical interfaces, data provisioning, and system prerequisites

In the context of advancing the reporting and analysis capabilities in Business Continuity Management (BCM), the existing BI landscape is being migrated from Tableau to Microsoft Power BI. The goal is to build a future-proof, scalable data warehouse that provides a consolidated data foundation for company-wide analyses. At the same time, existing reporting functions and automations in the standard software HiScout should be analyzed and adapted to new requirements. - **Consulting**: Advising on the architecture and setup of a data warehouse based on Microsoft technologies (SQL Server, Power BI) - **Migration**: Assisting with the migration of existing reports and dashboards from Tableau to Power BI - **Data Analysis**: Analyzing existing data sources and designing suitable ETL processes - **Automation**: Connecting and automating data sources - **Requirements Analysis**: Conducting requirements analyses and creating technical designs for reporting adjustments in HiScout - **Reporting**: Implementing and testing reporting adjustments in HiScout - **Documentation**: Quality assurance and documentation of the work performed - **Training**: Advising on creating training materials and knowledge transfer to internal teams

Typical tasks: - Analyze existing insurance processes and identify digitalization potentials - Gather and document business requirements together with business units - Create solution concepts for digital transformation (including process modeling and cost-benefit analyses) - Act as liaison between business and IT: translate requirements into technical concepts and support implementation - Support project management in planning and implementing new digital solutions (agile methods like Scrum/Kanban) Relevant tools & technologies: BPMN modeling tools (e.g. Visio, Signavio), requirements management (Jira, Confluence), knowledge of common insurance IT systems, MS Office KPIs & metrics: adherence to project milestones and budgets, reduction of process cycle times, increase in customer satisfaction/user acceptance, reduction of manual efforts through automation Challenges: aligning diverse stakeholders in the insurance environment (business units, IT, regulatory), integrating new digital solutions into existing legacy systems, dealing with regulatory requirements and data protection, change management and user adoption Deliverables: comprehensive requirement documents and process models, developed business concepts and user stories for IT implementation, defined implementation roadmap, training materials for updated processes Lessons learned: early involvement of all stakeholders facilitates the implementation of digitalization projects; iterative, agile approaches allow flexible adjustments; deep industry knowledge (products, regulations) is crucial to design viable digital solutions

- Establishment of a future O2C standard process in S/4 HANA for a retail customer with a focus on O2C integration and planned handling of the merchandise management system - The existing merchandise management system for trade goods will still be used for all logistics processes and is out of scope. - Requirements definition for interfaces - Process definition and harmonization: Establish company-wide standard processes in S/4 and in O2C process integration for the areas/entities involved (B2C, B2B, B2G) - O2C integration: Definition of the level of integration of third-party systems: - Best possible compliance with legal reporting and documentation obligations - S/4 as the leading system for executing intercompany transactions - Billing flow and invoicing - Price conditions - Rebates - Contracts What should be done for these topics during the Explore phase? - Preparation and facilitation of Fit To Standard workshops (including building a prototype in the sandbox system for the workshops) - Documentation of the results of the Fit To Standard workshops in a BPML up to level 5 - Documentation of gaps/requirements - Process design and documentation of functional concepts (Confluence + Signavio)

We are looking for an experienced consultant for a process and project initiative in the area of Asset P&L (Profit and Loss) at a leading international financial services provider. - Typical areas of responsibility in this role:** - Analyze and document existing end-to-end P&L processes for various asset classes (e.g. equities, fixed income, derivatives). - Identify weaknesses, risks and inefficiencies in data collection, processing and reporting. - Design and conceptualize optimized target processes for P&L calculation and attribution. - Create functional specifications and business requirements for adapting or introducing IT systems (e.g. P&L engines, data warehouses). - Manage the implementation of new processes and tools, including milestone planning, stakeholder management and test coordination. - Develop control mechanisms to ensure data quality and consistency. - Prepare training materials and conduct workshops for business areas (trading, controlling, risk). - Relevant technologies, tools or methods:** - Advanced Analytics: MS Excel (Pivot, Power Query, VBA), SQL. - Business Intelligence: Tableau, Power BI, Qlik. - Project Management: Jira, Confluence, MS Project. - ERP/Finance Systems: SAP FI/CO, Oracle Financials, or industry-specific asset management platforms. - Methods: Business Process Model and Notation (BPMN 2.0), agile project management (Scrum/Kanban). - Typical KPIs or success metrics:** - Reduction in P&L creation time (cycle time): target >25% efficiency improvement. - Decrease in manual correction entries: target >50% reduction through process automation. - Data quality index: increase "first-time-right" rate in data intake to >99%. - Efficiency ratio (cost-to-income): demonstrate a positive contribution to lowering the ratio. - User adoption rate: acceptance of new processes/tools in the business area >80% after 3 months. - Key challenges, risks or specifics:** - Heterogeneous system landscapes and inconsistent data sources (data silos). - High complexity of financial products and valuation models. - Resistance to process changes in business areas (change management). - Ensuring compliance with regulatory requirements (e.g. IFRS 9, BCBS 239). - Time- and budget-critical implementation during ongoing operations. - Concrete deliverables:** - Milestone 1: Completed as-is analysis and process documentation. - Deliverable 1: Detailed analysis report including risk assessment. - Milestone 2: Finalized target concept and business requirements document. - Deliverable 2: Implementation roadmap and project plan. - Milestone 3: Successful user acceptance test (UAT) of the new process/tool. - Deliverable 3: Acceptance protocols, training materials and project closure report.

- Build and enhance data management in SQL Server for fixed-line and All-IP products, and integrate existing and new data sources from SQL Server/Oracle from CRM systems and workflow management systems - Develop a database in SQL that captures and consolidates data from different source systems (CRM and workflow systems) - Create and expand database reports in Tableau for daily reporting - Advise business units (e.g. Technology, Order Management) on data collection and management of customer data - Continuously optimize and establish the data management process and data quality for future projects

A company is looking for an experienced professional with extensive knowledge of License Manager, Inventory Server and Integration Manager. The project’s goal is to optimize existing systems, integrate them, and ensure all processes run smoothly and efficiently. In this role, you will work closely with internal teams to analyze requirements, implement solutions, and monitor the systems. Key responsibilities: - Analyze and optimize existing systems (License Manager, Inventory Server, Integration Manager) - Integrate new processes and tools - Collaborate with internal teams for requirements analysis - Ensure system efficiency and security - Document and train the teams

- IT project manager activities - Interface/bridging role between business area and technology, requiring solid subject matter knowledge.

A company is looking for an experienced expert in P2P / Purchase to Pay / Procure to Pay to merge the IT finance systems of two entities. The goal of the project is to ensure smooth system integration and optimize processes. In this role, the expert will work closely with relevant stakeholders to analyze requirements, develop solutions, and support the implementation. Main tasks: - Analyze the current IT finance systems of both entities - Develop a strategy for system consolidation - Optimize P2P processes - Support implementation and integration - Collaborate with internal teams and external partners - Ensure compliance with finance and regulatory guidelines

- Execution and handling of switching processes (supplier change, new setup, move-in/move-out) - Independent handling of clarification cases with analysis of rejection reasons and follow-up - Support in market communication and related areas (e.g., meter reading, billing) at least at 2nd-level - Ensuring smooth processes within energy industry workflows

Design and development of a modern data platform in the Azure Cloud for an e-commerce company. Implementation of scalable data pipelines and a lakehouse architecture. - **Typical tasks:** - Designing and implementing ETL/ELT processes with Azure Data Factory/Databricks. - Building and managing the data infrastructure (Data Lake, Synapse). - Developing data models and ensuring data quality. - Automating deployments using IaC (Terraform). - Performance tuning and coordinating with stakeholders. - **Relevant technologies, tools & methods:** - Azure Data Factory, Synapse, Databricks, Data Lake Storage. - Apache Spark, Delta Lake. - Python (PySpark), SQL. - Terraform, Azure DevOps. - **Typical KPIs & success metrics:** - Data latency, pipeline uptime (>99.9%), query performance, cost efficiency. - **Key challenges & risks:** - High data volumes, GDPR compliance, avoiding data silos. - **Deliverables:** - Production-ready data pipelines, structured data lake/warehouse, IaC scripts, technical documentation.

A company is looking for an experienced MES consultant specializing in MPDV’s Hydra X to support the system’s expansion to additional sites. The system is already rolled out at one location and should now be scaled further. The role includes supporting the introduction of new features or system versions, implementing system customizations and optimizations based on production requirements, and overseeing the rollout. The consultant will work closely with internal teams and external service providers to ensure quick identification and resolution of MES system issues. - Support the introduction of new system features or versions - Implement system customizations and optimizations based on production requirements - Assist with the rollout to additional sites - Quickly identify and resolve issues in the MES system

We are looking for an experienced IT project manager to oversee and implement IT projects in a hospital setting. The goal is to deliver various digitization and infrastructure projects (e.g., HIS migration, medical technology integration, ISMS implementation or TI components) on time, on budget and with assured quality. In this role, the project manager takes full responsibility for planning, controlling and implementing the projects and acts as the interface between IT, clinical departments and executive management. - Overall responsibility for planning, controlling and implementing IT projects in a clinical environment - Coordination of internal and external stakeholders, including the IT department, medical staff, service providers and manufacturers - Ensuring compliance with time, budget and quality requirements - Creating project plans, status reports, decision papers and presentations - Risk management, resource planning and escalation management - Managing acceptance and testing procedures, including documentation - Support in preparing KHZG or NIS2 relevant measures - Interface function between IT, clinical departments and executive management

A company is looking for an experienced engineering expert in sterile filling to support a challenging project in pharmaceutical production. The goal of the project is to optimize the efficiency and quality of filling processes and ensure that all regulatory requirements are met. In this role, the expert will work closely with the internal team to develop technical solutions, analyze existing processes, and implement improvements. Main tasks: - Analyze and optimize processes in sterile filling - Ensure compliance with GMP and other regulatory requirements - Develop and implement technical solutions for process improvement - Collaborate with interdisciplinary teams - Document and report progress and results

A company is seeking support in setting up or optimizing a structured funding controlling system for municipal energy, infrastructure, or digitization projects. The goal is to increase efficiency and transparency in the use of funding and ensure compliance with funding regulations. The role includes identifying suitable funding programs at the EU, federal, and state levels, assisting with applications, fund disbursements, and preparation of usage reports. It also involves setting up a monitoring and reporting system (e.g., in Excel) that aligns project plans with funding requirements. Consulting on processes and interfaces such as accounting and project management, as well as training internal teams as needed, are also part of the tasks. - Identification of suitable funding programs (EU, federal, state) - Support with application, fund disbursement, and usage reports - Setting up monitoring/reporting (e.g., in Excel) - Aligning project plans with funding requirements - Consulting on processes and interfaces (e.g., accounting, project management) - Training internal teams as needed

- Customizing / parametrization of the core banking system according to business requirements - Maintaining daily operations - Initial and advanced training of internal staff

Project description As part of implementing and optimizing the tool **Multi Domain Orchestration and Inventory (MDOI)** in the transport mobile network area (B2X), the focus is on planning, building, commissioning, managing, and optimizing several thousand devices for the fixed and mobile network. The application enables the selection and configuration of suitable devices and technologies and their efficient deployment for maximum network coverage and customer satisfaction. Efficient management of these projects and processes while increasing automation requires the use of the MDOI software solution. Project scope without personal reference - IT Project Management: creating software rollout and migration plans for the application's bi-monthly releases of MDOI, based on Blueplanet, considering all relevant dependencies using JIRA and stakeholder management - Design Management: planning and creating all relevant designs and reviewing them in the Multi Domain Orchestration and Inventory (MDOI) tool for the Transport Networks area, as an implementation description of the requirements using JIRA and Confluence - Stakeholder Management: developing and implementing communication measures for software changes based on the created designs, checking if the requirements are fully covered by the designs, including creating management documentation using Microsoft Outlook, Microsoft Teams and JIRA

- A company is seeking an experienced interim procurement professional to support its Amsterdam office due to a departing colleague. - The role will end once a permanent successor is found, with the possibility of extension depending on the recruitment process. - The professional will act as the sole representative of a group-wide procurement organization in the Amsterdam office, working closely with a team of nine spread across Europe. - The role involves managing end-to-end procurement processes for both existing and new suppliers, focusing on Marketing and Professional Services categories. - The professional will ensure adherence to procurement standards, negotiate prices, and compare offers in collaboration with business owners. - The onboarding will primarily be remote, with occasional in-person days in Amsterdam.

Management of a strategic digitization project in a hospital network, e.g. implementing a new HIS or a patient record (ePA) according to KHZG. - **Typical responsibilities:** - Overall responsibility for project planning, control, and monitoring (time, budget, quality). - Management of the interdisciplinary project team. - Requirements, risk, and stakeholder management. - Planning and management of change management and rollouts. - Ensuring compliance with regulatory requirements (KHZG, GDPR). - **Relevant technologies, tools & methods:** - HIS systems (Orbis, iMedOne), ePA solutions. - Standards: HL7, FHIR. - Methods: PRINCE2, PMI/PMBOK, agile/hybrid. - Tools: MS Project, Jira, Confluence. - **Typical KPIs & success metrics:** - KHZG compliance, user adoption rate (>85%), process efficiency, milestone adherence. - **Key challenges & risks:** - High process complexity, intense stakeholder management, interoperability, data security. - **Deliverables:** - Project plan, status reports, requirements specification, change concept, cutover plan, project closure report.

On behalf of a renowned client in the life sciences industry, we are looking for freelance support in Clinical Data Management. The main task is to take responsibility for coordinating all data management activities in clinical trials. - Typical tasks in this role:** - Creating and reviewing the Data Management Plan (DMP) and the Data Validation Plan (DVP). - Designing and implementing electronic case report forms (eCRFs) in EDC systems (Electronic Data Capture). - Coordinating data collection, validation, and cleaning throughout the study lifecycle. - Developing and executing query processes to resolve data inconsistencies with the study sites. - Medical coding of adverse events (AEs) and medications (e.g. using MedDRA, WHODrug). - Performing SAE reconciliation (matching of serious adverse events). - Preparing and executing the database lock after data collection is complete. - Creating status reports and communicating with the study team (project management, monitoring, biostatistics). - Relevant technologies, tools or methods:** - EDC systems: Medidata Rave, Oracle Clinical, Viedoc, Zelta, OpenClinica. - Programming languages/analysis tools: SAS, R, Python, SQL. - Standards: CDISC (SDTM, ADaM), GCP (Good Clinical Practice), 21 CFR Part 11. - Collaboration tools: MS Teams, Jira, Confluence. - Data visualization: Tableau, Power BI. - Typical KPIs or success metrics:** - Data quality: query rate (number of queries per 1,000 data points) < X; data entry error rate < 1%. - Time management: time from last patient last visit (LPLV) to database lock (target: 4-6 weeks). - Efficiency: average time to resolve queries (target: < 10 business days for critical queries). - Compliance: 100% adherence to milestones and processes defined in the DMP. - Protocol adherence: rate of protocol deviations related to data management < 5%. - Key challenges, risks or specifics:** - Managing increasing data volumes and sources (e.g. wearables, ePROs). - Ensuring data integrity and security (cybersecurity, data protection/GDPR). - Complexity from mid-study changes (protocol amendments) and their impact on the database. - Ensuring consistent data quality across multiple, globally distributed study sites. - Shortage of qualified professionals and high demands for onboarding in study-specific systems. - Specific deliverables:** - Finalized and approved Data Management Plan (DMP). - Live and validated study database (EDC system). - Regular data cleaning reports and status updates. - Clean, quality-assured, and analysis-ready database. - Final locked study database with a complete audit trail. - Archived project documentation after study completion.