Kerstin Burgen - Reporting and analytics for HR

Q: Where is Kerstin based?

Kerstin is based in Grünwald, Germany and prefers 100% remote projects.

Q: What languages does Kerstin speak?

Kerstin speaks the following languages: German (Native), English (Advanced), French (Elementary) .

Q: How many years of experience does Kerstin have?

Kerstin has at least 26 years of experience. During this time, Kerstin has worked in at least 18 different roles and for 23 different companies . The average length of individual experience is 1 year . Note that Kerstin may not have shared all experience and actually has more experience.

Q: What is Kerstin's latest experience?

Kerstin's most recent position is Reporting and analytics for HR at Apobank .

Q: What companies has Kerstin worked for in recent years?

In recent years, Kerstin has worked for Apobank , FeelGood Products GmbH , Opening a test station , and Klinik Mednord .

Q: Which industries is Kerstin most experienced in?

Kerstin is most experienced in industries like Information Technology , Retail , and Healthcare . Kerstin also has some experience in Automotive , Banking and Finance , and Manufacturing .

Q: Which business areas is Kerstin most experienced in?

Kerstin is most experienced in business areas like Information Technology , Product Development , and Project Management . Kerstin also has some experience in Quality Assurance , Business Intelligence , and Operations .

Q: Which industries has Kerstin worked in recently?

Kerstin has recently worked in industries like Healthcare , Food and Beverage , and Banking and Finance .

Q: Which business areas has Kerstin worked in recently?

Kerstin has recently worked in business areas like Product Development , Project Management , and Strategy .

Recommended expert

Grünwald, Germany

Check rate

Experience

Feb 2024 - Aug 2024

7 months

Düsseldorf, Germany

Reporting and analytics for HR

Apobank

Designing and implementing an interactive evaluation system for top executives to rate core competencies such as goal orientation, team culture, and strategic alignment.
Integrating control mechanisms to enforce feedback limits and store evaluations in a central system to ensure data integrity.
Optimizing data processing for personnel development by automating the merging of various information sources for form letters.
Implementing technical data preparation and analysis for the annual compensation comparison in the financial sector.
Developing automated processes for data preparation in Excel using Power Query, ensuring data integrity and anonymization according to data protection requirements.
Automating personnel cost analysis by developing a solution to process data from the Paisy system into an SAP-compatible Excel file.
Creating test cases, user documentation, and test plans for all developed systems.
Technologies: Power Query, MS Office 2016 (Word, Excel, PowerPoint), Paisy, SAP, VBA.

Feb 2024 - May 2014

Unterföhring, Germany

Developer

Metafinanz-Informationssysteme GmbH / Allianz Versicherungsgesellschaft

Implementing a workflow to control test execution in VAPI-XP under HP ALM.
Creating external VB Scripts for test automation.
Technologies: Quality Center/ALM, VB Script, Excel 2010, VBA, DB2, MS SQL.

Jun 2023 - Present

3 years 1 month

Munich, Germany

Product Management / Project Management / Business Development

FeelGood Products GmbH

Developing an AI-based solution for personalized advice in health and nutrition, using artificial intelligence, data modeling, and Scrum.
Setting strategic direction and growing the brand, introducing efficient operational processes and structures to support daily operations.
Developing and launching the 'Feelgoodbears' dietary supplements, including formulation, design, and compliance with health and safety regulations.
Building and optimizing the online sales channel, including website management, SEO, and using e-commerce platforms to increase brand awareness.
Running integrated marketing campaigns across digital and traditional channels and coordinating influencer marketing activities.
Developing and maintaining strategic partnerships to expand sales channels.
Responsible for budgeting, financial management, reporting, cost control, and investment planning, including journal entries and accounting compliance.
Technologies: MS Azure (Azure Health Bot, Azure OpenAI (GPT-4), Azure Cognitive Search, Azure SQL Database, Azure Computer Vision (OCR)), Google Custom Search API, Trello, Power Query, MS Office 365, Shopify, Adobe Photoshop, Adobe Illustrator, MidJourney, OpenArt, ChatGPT.

Jan 2022 - Feb 2023

1 year 2 months

Munich, Germany

Opening a test station

Oct 2020 - Aug 2022

1 year 11 months

Munich, Germany

Administration / Clinic Management

Klinik Mednord

Responsible for hiring, training, and development of doctors, nurses, and administrative staff.
Overseeing the clinic budget and managing financial matters such as billing with insurers and patients.
Organizing daily operations, including patient management, appointment scheduling, and inventory control.
Monitoring quality of medical care, compliance with protocols, and health and safety regulations.
Ensuring high patient satisfaction and meeting patient needs.
Planning and executing marketing strategies and organizing events to raise awareness.
Developing ideas to improve medical care through new technologies or procedures.
Analyzing data and preparing reports for the Bavarian Office of Statistics, as well as evaluating relevant KPIs such as bed occupancy.

Feb 2020 - Mar 2020

2 months

Berlin, Germany

CDR Manager / BI Analyst

Vattenfall

Management and analysis of charging data (Charge Data Records) for e-mobility.
Creation and expansion of comprehensive reports and charts in MS Power BI based on various KPIs.
Consideration of complex tariff structures (AC/DC, duration, kWh) in billing with customers and suppliers.
Validation of CDRs from invoices and contracts, and creation of reference tables for tariffs and charging station operators.
Reporting to roaming partners for invoice verification and conducting CDR analyses for quarterly closings.
Technologies: MS Power BI, MS Office 365 (Excel, PowerPoint), Power Query.

Jan 2020 - Jan 2020

1 month

Plattling, Germany

BI Consultant

Rubix/Zitex

Development of a high-level concept for integrating existing ERP systems into a database system after a corporate merger.
Conducting the current-state analysis and describing the target state.
Identifying stakeholders and defining requirements with priorities and implementation effort.
Presenting the BI team and defining responsible roles.
Visualizing data analysis in Power BI.
Technologies: MS Office (Excel, PowerPoint), MS Power BI.

Feb 2019 - Jun 2019

5 months

Hamburg, Germany

Senior BI Product Manager/Owner

Xing SE

Managing BI projects through the entire lifecycle using agile (Scrum) and traditional PM methods.
Creating epics, user stories, and plans for product development.
Verifying and prioritizing customer requirements in line with company strategy.
Developing test cases, benchmarks, and product documentation.
Coordinating with data-delivery teams for early planning of BI changes.
Visualizing ad-hoc requirements in MicroStrategy.
Designing and delivering product training.
Technologies: Exasol, MicroStrategy, Atlassian JIRA, Atlassian Confluence, MS Excel, MS Word, Slack.

Jul 2018 - Dec 2018

6 months

Unterschleißheim, Germany

Requirements/Product Management, Reporting and Testing

BMW Trainingsakademie

Supporting the Future Retail HR IT project to implement talent management systems (TMSi).
Creating IT specifications and designs for the KPI dashboard and TMSi in HP ALM, Jira, and Confluence.
Defining epics and user stories for the product backlog and participating in Scrum events.
Developing and integrating a Retail HR KPI dashboard using SAP BO.
Performing market-level monitoring and reporting to ensure data quality.
Managing testing, including specifying and executing test cases (UAT, A/B tests), and handling defects.
Coordinating with IT departments, business support, and product owners.
Technologies: TMSi, HP ALM, Atlassian JIRA, Confluence, SAP BO, ITSM Suite, MS Excel, MS PowerPoint.

Jun 2017 - Jun 2018

1 year 1 month

Munich, Germany

Database Developer/Analyst

E.ON

Evaluating and analyzing extensive pricing structures using a MySQL database.
Maintaining the database by creating and editing views and tables with SQL scripts.
Processing external data with Pentaho Data Integration and exporting it as Excel reports.
Designing ETL job elements and transformations for data analysis.
Performing database-level tests for quality assurance.
Visualizing analysis results in pivot tables.
Technologies: HeidiSQL, MySQL, Pentaho Data Integration, Microsoft Azure, Microsoft Power BI, MS Excel.

Dec 2016 - Aug 2019

2 years 9 months

Munich, Germany

E-Commerce Business Owner

Own Project

Expanded an online shop system by adding wholesale products and marketing them on eBay and Amazon.
Developed an Excel solution for automated processing and uploading of product data from CSV files to Shopify.
Implemented functions to optimize product titles, descriptions, and inventory updates.
Synchronized inventory between Shopify, eBay, and Amazon using specialized apps.
Improved the eBay presence by designing CSS/HTML templates.
Carried out marketing activities such as SEO, content optimization, Google AdWords, and social media.
Analyzed sales data and KPIs (visitors, net revenue, order value) using Power BI.
Technologies: Shopify, MS Office/Excel 365, VBA, SSAS, Power Pivot, MS Power BI, HTML, CSS.

Aug 2016 - May 2017

10 months

Munich, Germany

Process Management

BMW

Designed and administered a JIRA project to monitor workflows for updating control unit error logs.
Coordinated with departments to define processes and timing factors.
Created state machines in UML and drafted technical specifications.
Oversaw and monitored the entire implementation process.
Technologies: MS Excel, MS PowerPoint, MS Visio, Atlassian JIRA, Confluence.

Aug 2014 - Jun 2016

1 year 11 months

Neubiberg, Germany

Requirements Manager / Product Manager / Software Engineer

Intel Mobile Communications GmbH / Intel Germany GmbH

Supported designers and testers by developing custom methods, flows, and software solutions for mobile technology and IoT.
Managed projects using agile methods (Scrum), including gathering requirements, sprint planning, and Kanban board management.
Expanded a multi-project handling concept and synchronized multiple test management databases in HP QC/ALM.
Developed an IP concept as a class/instance solution for structuring derivatives.
Designed and implemented interfaces using the OTA API in VBA to upload test results from Excel to QC-ALM.
Developed business intelligence software, including importing test results into a MySQL database.
Defined KPIs such as test plan coverage and execution progress, and created reports in QlikView.
Conducted training and provided 3rd-level user support.
Technologies: HP ALM 12.0, ClearQuest, MySQL, VBA, VBS, OTA API, REST API, JIRA, QlikView 2012, MS SQL Server.

Nov 2010 - Dec 2013

3 years 2 months

Neubiberg, Germany

Project Manager / Product Management / Development

Infineon / Intel Mobile Communications GmbH

Led the project to design and introduce a QC-based test management system for chip power management.
Created a concept for multi-project handling and synchronizing ALM projects within a product family.
Developed and rolled out an RDF approach for power management.
Programmed workflow scripts in QC, Excel, and Windows to automate processes.
Implemented interfaces between Excel and the QC API for data import/export.
Developed reports and templates to visualize test data using SQL queries.
Conducted workshops and training sessions for users and clients.
Technologies: HP Quality Center 10.0, HP ALM 11.0, ClearQuest, VBA, VBS, OTA API, MS SQL Server, SharePoint.

Mar 2009 - Mar 2010

1 year 1 month

Unterföhring, Germany

Test Analyst

Kabel Deutschland GmbH

Conducted system tests at the web service and front-end levels for connecting partners to the customer portal.
Coordinated offshore development in India and ensured communication.
Identified use cases, wrote test case descriptions, and executed and evaluated the tests.
Tracked defects and contributed to test case automation.
Integrated product data into Oracle databases and modified customer master data.
Technologies: SOAP UI, ClearQuest, Mercury Quality Center, TOAD for Oracle, Oracle SQL Developer.

Aug 2008 - Feb 2009

7 months

Munich, Germany

Internet provider (apparel industry)

Development of an online store with integrated inventory management.
Development of a tool for automatic data synchronization between the store and the inventory system.
Focus on database design and software development in an e-commerce environment.
Technologies: MS Access, VBScript, VBA, EMS SQL Manager, Zencart.

Apr 2006 - Dec 2008

2 years 9 months

Munich, Germany

Requirements Manager

BMW

Design and creation of new projects in Mercury Quality Center for data configuration of control units.
Identification and assessment of functional requirements as well as creation of functional specifications.
Administration, customization and technical implementation in VBScript.
Documentation and creation of UML diagrams.
Implementation of scripts for automatic processing of data import/export from Outlook and Excel.
Technologies: Mercury Quality Center 8.2/9.0, VBScript, VBA, Visio 2003, MS Word.

Feb 2004 - Mar 2006

2 years 2 months

Munich, Germany

Incident Manager / Software Developer

Hypovereinsbank

Incident management and third-level support for the Windows XP rollout.
Design and implementation of a GUI for administering a system that supplies data to decentralized servers.
Development of interfaces for processing process information and communicating with reference servers.
Development of a tool for installation validation in integration and quality assurance environments.
Design of the system architecture and automated updating of test XMLs.
Technologies: MS Windows NT/XP, Visual Basic 6.0, SourceSafe, COM, MS Project, XML, HTML, Rational Rose, Visio.

Nov 2003 - Dec 2003

2 months

Bremen, Germany

University

Development of a CATI program for computer-assisted telephone interviews including questionnaire logic.
Implementation of filter flows based on the answers to the questions.
Management of decentralized data storage and central aggregation of results for SPSS.
Technologies: Visual Basic 6, MS Access 2000, VBA, SPSS.

May 2003 - Oct 2003

6 months

Neuss, Germany

Database Developer

Software company (Toshiba)

Further development of a Management Information System (MIS) for the dynamic display of sales figures and inventories.
Database design and formulation of complex queries.
Programming stored procedures in T-SQL and creating DTS packages.
Development of a VB program to manage user-defined system tables.
Support for clients in an international environment.
Technologies: Visual Basic 6, MS SQL Server 2000, T-SQL, DTS, Datawarehouse.

May 2002 - Mar 2003

11 months

Frankfurt, Germany

Deutsche Bank

Created presentations and complex charts in Excel and PowerPoint for the investment division.
Followed styles and standards when preparing documents.
Managed documents in Documentum.
Developed an application for creating shift schedules.
Communicated and documented in English.
Technologies: MS Windows NT/XP, Documentum (e-docs), VBA, Lotus Notes, MS Office 97.

Sep 2001 - Apr 2002

8 months

Bremen, Germany

Stahlwerke Bremen

Converted a PC application for calculating pig iron desulfurization processes to Visual Basic 6 using OOP.
Designed the frontend and database.
Implemented data access using ADO.
Processed and exchanged data via telegram traffic (SIVAX).
Technologies: Visual Basic 6, VBScript, Source Safe, SQL, Oracle Rdb.

Jul 2000 - May 2001

11 months

Germany

Retail

Migrated the database from Paradox 9 to MS SQL Server 7.
Adjusted the frontend and installed the SQL Server on NT systems.
Designed the database and implemented data integrity.
Programmed automated backups and used Transact-SQL.
Created VBA macros in Excel and Word to display database queries.
Technologies: MS SQL Server 7, VBA, MS Excel 2000, Paradox 9, Transact-SQL, TCP/IP.

Aug 1999 - Apr 2001

1 year 9 months

Germany

Managing Director

Network Solutions Company

Founded and led a company for network solutions.
Sold the company shares in 2001.

Jun 1997 - Jan 2000

2 years 8 months

Germany

Retail

Enhanced and implemented a merchandise management system for store operations.
Programmed interfaces for label printers and cash registers.
Trained staff, provided support, and maintained the POS software.
Set up remote data transmission and created user manuals.
Developed the frontend using Paradox (ObjectPAL).
Technologies: Windows NT 4, MS Excel 5, VBA, Paradox 5/7/9, ObjectPAL.

Industry Experience

See where this freelancer has spent most of their professional time.

Experienced in Information Technology, Retail, Healthcare, Automotive, Banking and Finance, and Food and Beverage.

Information Technology

Retail

Healthcare

Automotive

Banking and Finance

Food and Beverage

Business Area Experience

See which departments and functions this freelancer has contributed to most.

Experienced in Information Technology, Product Development, Project Management, Quality Assurance, Business Intelligence, and Operations.

Information Technology

Product Development

Project Management

Quality Assurance

Business Intelligence

Operations

Skills

Areas Of Application

Business Intelligence
Database Design And Analysis (Oracle, Ms Access, Ms Sql Server, Mysql, Db2)
Quality Management / Quality Assurance
Methodology, Processes
Agile Project Management (Scrum / Kanban)
Project Planning And Coordination
Concept Development

Focus Areas

Data Analysis
Business Analysis
Concept Development/Specifications
Product Management
Scrum / Kanban
Excel/Vba Development

Products

Hp Alm/Quality Center: Excellent Knowledge
Clear Quest: Good Knowledge
Ms Office And Vba: Excellent Knowledge
Atlassian Jira: Very Good Knowledge
Atlassian Influence: Very Good Knowledge
Power Bi: Very Good Knowledge
Qlikview: Very Good Knowledge
Pentaho Data Integration: Very Good Knowledge
Visio: Very Good Knowledge
Microstrategy: Good Knowledge
Sap Bo: Good Knowledge
Shopify: Excellent Knowledge

Programming Languages/Development Environments

Vba/Vb Script: Very Good Knowledge
Visual Basic: Very Good Knowledge

Databases

Ms Sql Server: Very Good Knowledge
Mysql: Very Good Knowledge
Oracle: Good Knowledge
Oracle Rdb: Good Knowledge
Exasol: Very Good Knowledge
Bde: Good Knowledge
Dao/Ado: Good Knowledge
Db2: Very Good Knowledge
Paradox: Very Good Knowledge
Access: Very Good Knowledge

Industries

Automotive
E-Commerce
Healthcare
Banking
Business Administration
Retail
Wholesale And Foreign Trade
Trade
Import/Export
Cable Network Operators
Aviation
Steel Industry
Management Consulting
University
Microelectronics/Semiconductors
Mobile Communications/Iot
Insurance
Energy
Social Networks

Languages

German

Native

English

Advanced

French

Elementary

Education

Academy for Data Processing

Office Clerk · Bremen, Germany

Certifications & licenses

Professional Scrum Master (PSM I)

Professional Scrum Product Owner (PSPO I)

Statistics

Experience

Total positions 25

Experience in Information Technology 8 y

Avg length 1 y 2 m

Longest experience 3 y 1 m

Global Experience

Countries worked in 1 (Germany)

Primary country Germany

Expertise

Recent roles Reporting and analytics for HR, Developer, Product Management / Project Management / Business Development

Main industries Information Technology, Retail, Healthcare

Main business areas Information Technology, Product Development, Project Management

Qualifications

Certifications earned 2

Profile

Created

February 2025

Last Update

June 2026

Need a freelancer? Find your match in seconds.

Try FRATCH GPT

Frequently asked questions

Have questions? Find more information here.

Where is Kerstin based?

Kerstin is based in Grünwald, Germany and prefers 100% remote projects.

What languages does Kerstin speak?

Kerstin speaks the following languages: German (Native), English (Advanced), French (Elementary).

How many years of experience does Kerstin have?

Kerstin has at least 26 years of experience. During this time, Kerstin has worked in at least 18 different roles and for 23 different companies. The average length of individual experience is 1 year. Note that Kerstin may not have shared all experience and actually has more experience.

What roles would Kerstin be best suited for?

Based on recent experience, Kerstin would be well-suited for roles such as: Reporting and analytics for HR, Developer, Product Management / Project Management / Business Development.

What is Kerstin's latest experience?

Kerstin's most recent position is Reporting and analytics for HR at Apobank.

What companies has Kerstin worked for in recent years?

In recent years, Kerstin has worked for Apobank, FeelGood Products GmbH, Opening a test station, and Klinik Mednord.

Which industries is Kerstin most experienced in?

Kerstin is most experienced in industries like Information Technology, Retail, and Healthcare. Kerstin also has some experience in Automotive, Banking and Finance, and Manufacturing.

Which business areas is Kerstin most experienced in?

Kerstin is most experienced in business areas like Information Technology, Product Development, and Project Management. Kerstin also has some experience in Quality Assurance, Business Intelligence, and Operations.

Which industries has Kerstin worked in recently?

Kerstin has recently worked in industries like Healthcare, Food and Beverage, and Banking and Finance.

Which business areas has Kerstin worked in recently?

Kerstin has recently worked in business areas like Product Development, Project Management, and Strategy.

What is Kerstin's education?

Kerstin attended Academy for Data Processing for Office Clerk.

Does Kerstin have any certificates?

Kerstin has 2 certificates. These include: Professional Scrum Master (PSM I) and Professional Scrum Product Owner (PSPO I).

What is the availability of Kerstin?

Kerstin is immediately available full-time for suitable projects.

What is the rate of Kerstin?

Kerstin's rate depends on the specific project requirements. Please use the Meet button on the profile to schedule a meeting and discuss the details.