Analytics and Reporting Specialist · Allschwil, Schweiz
Peter Eckert
Human | Technology | Awareness
Analytics and reporting specialist with many years of professional experience in business intelligence, data analysis and reporting – including some thirteen years at F. Hoffmann-La Roche, where I progressed from BI specialist to Senior Analytics & Insights Specialist.
My strengths lie in translating complex data and processes into clear, visually compelling insights, and in the dialogue between the business and IT that turns requirements into workable solutions. Building on that experience and on my personal interests, my aim is to support your area and to explore new ideas together.
The path there began in the laboratory. As a qualified chemist (HTL), I learnt how to take accurate measurements, analyse data carefully and interpret it in a meaningful way. It is precisely this systematic approach that continues to shape my work with data every day.
Career at glance
Professional career
Positions, activities and projects – with the corresponding reference letters as PDFs.
since 2024Neuorientierung und Stellensuche
Seit dem Austritt bei Roche: Weiterbildung, ein Projekteinsatz, die Begleitung meiner Mutter – und die Suche nach der nächsten Aufgabe in Data Analytics und Reporting.6 positions
-
05.2026 – present
Marketing and sales
B2B Cosmetics · Therwil BL Ongoing
Show summary
A marketing role with a provider in the B2B cosmetics sector within the second labour market. The role combines creative tasks such as photography and site visits with the analytical processing of sales and customer data..
Show details
Duties and responsibilities
- Preparing sales and product range data to inform decision-making
- Supporting marketing initiatives and customer communications
- Creating Instagram and LinkedIn posts
- Organising and coordinating monthly site visits
Projects
- Implementation of digital collaboration (Office 365)
- Photos of all staff members for the company website (www.b2bcosmetics.ch)
Methods and tools
-
04.2026 – present
Actively seeking a role in Data Analytics & Reporting
Active job search · Region Basel / Nordwestschweiz Ongoing
Show summary
I am looking for a role in which I can draw on my many years’ experience in business intelligence, data analysis and reporting – ideally at the interface between business departments and IT, where data is transformed into clear, actionable insights to inform decision-making.
Show details
Duties and responsibilities
- Key areas: Business Intelligence, data visualisation, automated reporting and data quality
- Preferred tools: Tableau, Microsoft Power BI, SQL, Power Platform, Excel/Office 365
- Role profiles: Data Analyst, BI Specialist, Reporting Analyst, Business Partner Analytics
- Availability: by arrangement, available at short notice
Methods and tools
ToolsMethodsLanguages and queries -
05.2025 – 04.2026
Career reorientation, care for and accompaniment of my mother
Career reorientation · Schweiz
Show summary
I took some time off to be with my brother, support my mother and grieve. Afterwards, I re-evaluated my career and took the necessary steps.
Show details
Duties and responsibilities
- Organising and providing family care
- Reviewing and sharpening my professional profile
- Self-study in generative AI and modern analytics tools
Methods and tools
-
02.2025 – 04.2025
SQL and Tableau development
Swisscom · Zürich
Show summary
Fixed-term assignment in data preparation and dashboard development: SQL queries for the analysis of operational data and the Tableau visualisations built on top of them.
Show details
Duties and responsibilities
- Developing and optimising SQL queries for analyses
- Building and adapting Tableau dashboards
- Agreeing metric definitions with the business units
- Documenting data flows and analysis logic
Methods and tools
ToolsMethodsLanguages and queries -
08.2024 – 01.2025
Further training in Power BI and Office 365
mebea – people | careers | work · Pratteln BL
Show summary
A structured further-training programme focused on Microsoft Power BI and Office 365, complemented by career positioning and application strategy.
Show details
Duties and responsibilities
- In-depth Microsoft Power BI: data modelling, DAX, report design
- Automating workflows with Office 365 and Power Automate
- Practical projects preparing and visualising real data sets
Methods and tools
ToolsLanguages and queriesPlatforms -
02.2024 – 07.2024
Career break and offshore sailing licence
Time out · Mittelmeer
Show summary
A deliberate break after thirteen years at Roche, used to obtain the Swiss offshore sailing licence – navigation, passage planning and command of a sailing vessel.
Show details
Duties and responsibilities
- Theoretical and practical training in navigation and seamanship
- Passage planning, meteorology and safety procedures on board
2011 – 2024F. Hoffmann-La Roche
Dreizehn Jahre im Konzern, vom BI-Spezialisten zum Senior Analytics & Insights Specialist – fünf Funktionen, belegt durch vier Zeugnisse.5 positions
-
02.2019 – 01.2024
Senior Analytics & Insights Specialist
F. Hoffmann-La Roche AG · Basel
Show summary
As Senior Analytics & Insights Specialist I was the point of contact for regional procurement stakeholders and accountable for their data reporting. The focus was on harmonising spend data from different sources and presenting it in Tableau so that decisions could be derived from it.
View employment referenceShow details
Duties and responsibilities
- Responsible for business partnering with specified regional Procurement stakeholders
- Accountable for timely communication and data reporting to identified stakeholders
- Design and implement data insights for end users in a visual and compelling way, particularly in tools such as Tableau, showing advanced proficiency
- Support data transformation and conformation activities as well as standardise data to be used in an integrated enterprise data warehouse
Projects
- Supplier Relationship Management dashboard: created the first dedicated SRM spend dashboard, enabling the SRM team to easily identify strategic suppliers across categories and regions
- Americas dashboard: designed the consolidated dashboard combining spend data, metrics and KPIs from multiple sources into a single platform
- Global procurement addressable spend report: instrumental at the early stages of its definition, testing, implementation and maintenance, used by procurement professionals across the Roche network
- Tool evaluation: explored Alteryx, SAP Analytics Cloud and ThoughtSpot, identified opportunities to apply new process flows and shared knowledge and best practices with team members
Achievements
- Established the first SRM spend dashboard used across the Roche network
- Consolidated several Americas data sources into a single platform
- Continuously shared analytics knowledge and best practices within the team
Methods and tools
ToolsLanguages and queriesPlatforms -
10.2018 – 01.2019
Analytics & Insights (A&I) Specialist
F. Hoffmann-La Roche AG · Basel
Show summary
Internal transfer to the Analytics & Insights department. During this transitional phase I took on the analytical support of regional stakeholders and laid the groundwork for the later senior role.
View employment referenceShow details
Duties and responsibilities
- Analytical support for regional procurement stakeholders
- Building data analyses and visualisations in Tableau
- Harmonising spend data from various source systems
Projects
- Took over and developed the regional reporting streams after the departmental transfer
Methods and tools
ToolsLanguages and queries -
04.2016 – 09.2018
Data Analytics and Reporting Specialist
F. Hoffmann-La Roche AG · Basel
Show summary
In the Data Governance & Analytics department I acted as Business Intelligence Relationship Manager for the LATAM and EEMEA regions and was responsible for quarterly reporting to the Finance Leadership Team and the Roche Procurement Committee.
View employment referenceShow details
Duties and responsibilities
- Act as Business Intelligence Relationship Manager for the regions LATAM and EEMEA
- Responsible for quarterly reporting to the Finance Leadership Team and the Roche Procurement Committee (One Procurement)
- Collaborate with South San Francisco (USA), Roche Diagnostics GmbH in Mannheim (Germany) and the Shared Service Center Budapest (Hungary)
- Create Tableau dashboards for addressable spend, care for cash and savings
Projects
- Elaborated the definition of addressable spend for Global Procurement
- Established a cross-divisional savings report
- Standardised quarterly reporting for the Roche Procurement Committee
Achievements
- Completed a Category Management course in 2017
- Attended a Leadership Excellence Programme (LEP) Matrix Leaders course in 2018
- Established a cross-divisional savings report
Methods and tools
ToolsLanguages and queriesPlatforms -
07.2012 – 03.2016
HR Management Reporting Analyst
F. Hoffmann-La Roche AG · Basel
Show summary
Permanent position in global HR reporting: I managed BI front-end changes and formed the interface between the reporting needs of HR and IT.
View employment referenceShow details
Duties and responsibilities
- Manage BI front-end changes in the area of global HR reporting and build the interface to IT representing HR’s reporting needs
- Collect, coordinate, prioritise, implement, change, test and communicate BI front-end changes to existing SAP (web-)reports, queries and dashboards in CHRIS whilst also identifying needs for new reports
- Simplify and standardise data retrievals to ensure a fast delivery time in reporting services
- Provide support to end users and troubleshoot problems in terms of reporting access and authorisation
Projects
- Standardised recurring HR data retrievals to shorten delivery times
- Developed the SAP-based reporting landscape within the CHRIS system
Achievements
- Built a dependable interface between the HR business and IT
Methods and tools
ToolsPlatforms -
07.2011 – 07.2012
Business Intelligence Specialist Datawarehousing & BI Reporting
F. Hoffmann-La Roche AG · Basel
Show summary
Entry at Roche on a fixed-term contract within Group Functions Informatics, Medicines & Pharma Research and Early Development (pRED) Finance IT.
View employment referenceShow details
Duties and responsibilities
- Data warehousing and BI reporting for the finance function of pharmaceutical research
- Building and maintaining analyses and reports
- Working with the business to clarify reporting requirements
Projects
- Built reporting streams for pRED Finance IT
Achievements
- Offered permanent employment in July 2012
Methods and tools
ToolsLanguages and queriesPlatforms
2001 – 2011Selbständigkeit
Eigene Firma: Betreuung von Kunden im 1st-Level-Support und erste Auswertungen mit Excel und SAP BEx.1 position
-
11.2001 – 06.2011
1st-level support and Excel/SAP BEx reporting
P + P Eckert GmbH | ComProX GmbH · Reinach BL
Show summary
Almost ten years in a family business environment: technical user support combined with building analyses and reports for clients. This period produced the specialisation in SAP BEx reporting and Excel-based analysis that paved the way into business intelligence.
Show details
Duties and responsibilities
- 1st-level support for users: recording, qualifying and resolving hardware and software issues
- Building and maintaining analyses with SAP BEx (Business Explorer)
- Developing complex Excel analyses including VBA automation
- Installing, configuring and maintaining workstations and networks
- Advising clients on the selection and introduction of IT solutions
Projects
- Standardised Excel reporting templates with VBA automation for recurring client analyses
- SAP BEx queries and report workbooks for the business
Achievements
- ITIL Foundation Certificate obtained in 2007
- Training as SAP Business Warehouse Consultant (BW310 and TBW20, 2008/2009)
Methods and tools
ToolsLanguages and queriesPlatformsStandards and frameworks
1998 – 2001Einstieg in die IT
Vom Helpdesk vor Ort zur Applikationsentwicklung – der Wechsel vom Labor an den Rechner.3 positions
-
01.2001 – 10.2001
Application developer and integrator
Martha Software GmbH · Gipf-Oberfrick AG
Show summary
Development and adaptation of an industry solution for managing pig-breeding data, plus configuration of merchandise management solutions. Internally trained on the Centura tool chain.
View employment referenceShow details
Duties and responsibilities
- Creating and adapting reports and analyses
- Creating and adapting the user documentation
- Creating and adapting the installation programme
- Adapting the programme to various customer requirements
- Adapting the internal technical documentation
- Configuration work on business solutions using the standard software Apertum for merchandise management
- Configuration, maintenance and support of the internal network and its workstations
- Data capture in the data service for pig-breeding organisations
Projects
- Reporting and analysis layer of the in-house solution for managing pig-breeding data
- Installation programme of the industry solution using Wise Installer
Achievements
- Internal training on Centura Team Developer 1.1.2, Centura Report Builder 1.1.2, SQL-Talk 7.5.1, SQL-Base 7.5.1 and Wise Installer
- Highlighted in the reference: knowledge of Windows networks and VBA programming of MS Office applications
Methods and tools
ToolsLanguages and queries -
07.1999 – 12.2000
IT support and software projects
ProcessLink GmbH · Reinach BL / Basel
Show summary
Two clearly distinct phases: infrastructure and support around Windows NT 4.0 in the first year, then the development of a web-enabled budgeting application for a client in the second half of 2000.
View employment referenceShow details
Duties and responsibilities
- Migrating PCs to Windows NT 4.0
- Engineering and 2nd-level support for NT environments
- NMS Word automation: scripting and template adaptation
- Supporting the client with the introduction and maintenance of the software developed
Projects
- Customer-specific, web-enabled budgeting software built with Allaire ColdFusion, SQL and Crystal Reports on a Microsoft SQL Server 7.0 database (second half of 2000)
- Company-wide migration of workstations to Windows NT 4.0
Achievements
- ORACLE K1000 certificate – professional introduction to SQL and Oracle (August 1999)
- First database application delivered under own responsibility
Methods and tools
ToolsLanguages and queriesPlatforms -
03.1998 – 06.1999
Field service engineer – on-site help desk for major clients
ALSO COMSYT AG · Kriens LU, Niederlassung Reinach BL
Show summary
Stationed at a major client’s help desk: receiving, qualifying and routing hardware and software issues, complemented by own programming work.
View employment referenceShow details
Duties and responsibilities
- Call receiving – taking hardware and software problems by telephone
- Ticketing – recording issues electronically in a database
- Dispatching – qualifying problems and routing them accordingly
- Supporting – direct user assistance via remote access
- Monitoring – user assistance by email
Projects
- Tool for recording back-up times built with Access and VBA, including an interface to the existing time-recording system
Achievements
- First database application with a productive interface to an existing system
Methods and tools
ToolsLanguages and queries
1988 – 1998Ausbildung und Chemie
Berufslehre, erste Stellen in der pharmazeutischen Forschung und das Studium bis zum Diplom als Chemiker HTL.4 positions
-
05.1996 – 10.1996
Analytical research in microbiology
Werthenstein Chemie AG · Schachen LU
Show summary
Temporary position in the analytical department of a research and development site belonging to the pharmaceutical group Schering-Plough. This is where the first database application of my own was created – the actual beginning of the path into data analysis.
View employment referenceShow details
Duties and responsibilities
- Sampling of the water used in production as well as air and surface samples with regard to sterility
- In-process control during the manufacture of active substances using chromatographic methods, predominantly HPLC
- A wide range of partly very complex analyses across the entire analytics group
Projects
- Developed a Microsoft Excel based database for trend analysis of the microbiology measurements on water, rooms and personnel hygiene, with automated graphical evaluation through macro programming
- Further developed an agarose gel electrophoresis method for separating DNA fragments within a biotechnological active-substance project
Achievements
- First database and analysis solution of my own with automated visualisation
- Highlighted in the reference: tireless commitment, reliability, quick grasp and a very independent way of working
Methods and tools
-
08.1992 – 02.1998
Degree course – dipl. Chemiker HTL (qualified chemist)
University of Applied Sciences of the Two Basel Cantons (FHBB) · Muttenz BL
Show summary
Studies at the chemistry department of the University of Applied Sciences of Both Basel, completed with the diploma as dipl. Chemiker HTL. The course shaped the analytical, methodical way of working that later carried the move into data analysis.
View employment referenceShow details
Duties and responsibilities
- Analytical and preparative chemistry, instrumental analysis
- Evaluation and documentation of measurement series
- Diploma thesis in the Department of Industry
Achievements
- Diploma as dipl. Chemiker HTL, issued on 13 March 1999
Methods and tools
-
04.1991 – 03.1992
Preclinical research, Bone & Joint unit (formerly endocrinology)
Sandoz Pharma AG · Basel
Show summary
First position following the apprenticeship as a laboratory technician: peptide synthesis and analytical characterisation in preclinical research.
View employment referenceShow details
Duties and responsibilities
- Preparation, purification and analytical characterisation of amino acid derivatives and peptides
- Carrying out various solid-phase peptide syntheses, primarily by the Merrifield method
- Reaction control, preparative purification and characterisation of the end products by reversed-phase liquid chromatography (RP-HPLC)
- Documenting experiments and results in clear protocols
Achievements
- Highlighted in the reference: experimental skill, quick and conscientious execution and logical approach
Methods and tools
-
03.1988 – 07.1991
Apprenticeship as a laboratory technician in chemistry
Apprenticeship as a chemical laboratory technician · Muttenz BL
Show summary
Basic training in the chemical laboratory, completed in 1991 – the foundation for the later work in research and analytics.
Show details
Duties and responsibilities
- Preparative and analytical laboratory work
- Measurement data capture, documentation and evaluation
Methods and tools
Overview
Diplomas, courses and certificates
| Issued on | Designation | Issued by | |
|---|---|---|---|
| 19.02.2024 | Microsoft Power Platform App Maker Certificate | Digicomp Academy AG | |
| 20.11.2023 | Microsoft Power Platform Fundamentals Certificate | Digicomp Academy AG | |
| 10.10.2023 | Artificial intelligence in everyday working life Certificate | IBAW – Institut für berufliche Aus- und Weiterbildung | |
| 04.07.2017 | Category Management Course | F. Hoffmann-La Roche AG, Global Pharma Procurement | |
| 30.01.2009 | SAP Business Warehouse Consultant Training | SAP (Schweiz) AG, Education | |
| 15.11.2007 | ITIL Foundation Certificate in IT Service Management Certificate | TÜV SÜD Akademie GmbH / EXIN | |
| 19.08.1999 | Professional introduction to SQL and Oracle Course | ORACLE Software (Schweiz) GmbH | |
| 13.03.1999 | dipl. Chemiker HTL (qualified chemist) Diploma | Fachhochschule beider Basel (FHBB) |
