18 months: Data & Analytics
Customer: Jochen Schweizer Mydays Holding GmbH, Germany
Tasks:
- Lead Business Analyst/ Project Manager | Data source transition BI platform (Databricks, SAP, proprietary)
- Conducted comprehensive impact assessments on existing reporting DWH, data marts and Power BI reports for seamless integration of the new sources
- Led implementation of the report modifications in Power BI; collaborated closely with the DevOops team to productmanage all required backend changes
- Spearheaded cross-functional coordination with operational teams and stakeholders (finance & operations), overseeing upstream dependencies & driving downstream process adjustments and data reconciliation efforts
- Product Owner | BI platform for SaaS subsidiary (Azure Databricks & Power BI)
- Full review, optimisation & productionising of existing DWH and reporting suite enhancing efficiency & accuracy
- Integrated critical business data sources (Salesforce, Stripe); defined & standardised key KPIs and deployed executivelevel dashboards to replace fragmented & manual Excel reporting processes
- Led the offboarding of the SaaS BI platform post-sale managing all aspects (project planning to final sign-off), ensuring a smooth transition meeting business & compliance requirements
9 months: Data Strategy & Products
Role: Data Manager
Customer: RTL Deutschland, Germany
Tasks:
- Data onboarding for new streaming platform (Google Cloud)
- Evaluated new data sources for suitability, usability & availability across multiple business applications (incl. CRM, ML model training) ensuring alignment with strategic objectives
- Collaborated with the in-house legal team to ensure full GDPR & data governance compliance
- Set-up data governance framework introducing roles & responsibilities, data catalogue & governance processes
8 months: CRM-Integration into central data lake (Databricks & SAP)
Role: Lead Business Analyst
Customer: Essity GmbH, Munich, Germany
Tasks:
- Conducted data mapping & gap analysis to align legacy data with new standards
- Developed the data glossary; integrated data into the new master data model & defined Golden Records to ensure data consistency & integrity across the organisation
- Established workflows & processes for ongoing master data management with global data management team
- Product Owner of the BI platform | E-commerce team (Databricks & Power BI)
- Oversaw Power BI admin & user management ensuring accessibility across the team in-line with compliance
- Streamlined existing reports by harmonising KPIs aligning them with new management strategy
18 months: Reporting DWH and finance & operational data marts (Microsoft Analysis Services)
Role: Product Owner
Customer: Ambassador Theatre Group, London, UK | Data Team
Tasks:
- Conducted impact assessment & feasibility study for CRM system replacement & established data governance framework to ensure seamless integration & compliance
- Spearheaded requirements engineering for the integration of a legacy ticketing system
- Created comprehensive documentation of the existing data landscape, creating a standard framework for documentation & processing standards to enable future efficiencies
- Lead the launch of a Power BI pilot for front-of-house teams and developed the concept for a company-wide roll-out covering costing, resourcing, technical set-up, data governance & user training
2 years: IT Project Office
Customer: Bloomsbury Publishing Plc, London, UK
Tasks:
- Implementation of a global CRM solution & automation of sales/ O2C-process for digital subscriptions (Salesforce)
- Managed end-2-end the replacement of five disparate CRM systems with a unified global CRM
- Consolidated customer data into a single customer view to improve customer insights, implemented a global marketing consent management function ensuring regulatory compliance
- Streamlined & automated O2C process, collaborating with internal stakeholders (Sales, Accounts & Finance) and coordinating with technical teams & external payment processor, significantly reducing manual efforts
- ?Customised Salesforce workflows & user interfaces & designed data flows to Finance, internal DWH, 3 rd party
2010 - 2014: multiple large-scale BI data platforms
Role: Senior Data Solutions Consultant
Customer: Aimia Inc, London, UK
Tasks:
- Owner of multiple large-scale BI data platforms for prominent international retailers, responsible for the entire project lifecycle from initial data discovery & requirements gathering to KPI definition, platform development, implementation, solution testing & smooth BAU handover
- Data Migration Lead for re-platforming of existing client solutions, overseeing the design & execution of complex migration processes whilst mitigating risk, minimising downtime & ensuring seamless transition
- Served as Data Product Owner for the cutting-edge proprietary, meta-data driven BI platform steering strategic enhancements to align capabilities with evolving client needs
2004 - 2010: data migration project across four different data warehouses
Role: Senior Data Manager
Customer: dunnhumby Ltd., London, UK
Tasks:
- Business Analyst/ Developer for the CRM reporting platform on SAS; SME for marketing campaign delivery
- Business Analyst for a large-scale data migration project across four different data warehouses
1997 ? 2003: proprietary healthcare software ORBIS
Role: Database Developer Oracle
Customer: GWI Research GmbH, Trier, Germany
Tasks:
- SQL Developer on the proprietary healthcare software ORBIS