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 25 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 (IT) , 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 (IT) , Product Development , and Project Management . Kerstin also has some experience in Quality Assurance (QA) , 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 and Planning .

Recommended expert

Grünwald, Germany

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 enable differentiated evaluation of core competencies such as goal orientation, team culture and strategic alignment.
Integrating control mechanisms to enforce feedback limits and store ratings in a central system to ensure data integrity.
Optimizing data processing for personnel development by automating the consolidation of various information sources for mail merges.
Implementing data preparation and analysis for the annual compensation comparison in the finance industry.
Developing automated processes for data preparation in Excel using Power Query, including ensuring data integrity and anonymization according to data protection regulations.
Automating personnel cost analysis by creating 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

-10 years -8 months

Unterföhring, Germany

Developer

Metafinanz Information Systems GmbH / Allianz Insurance Company

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

2 years 9 months

Munich, Germany

Product Management / Project Management / Business Development

FeelGood Products GmbH

Developing an AI-supported solution for personalized consulting in health and nutrition, leveraging artificial intelligence, data modeling and Scrum.
Setting the strategic direction and driving brand growth, implementing efficient operating processes and structures to support day-to-day business.
Developing and launching the "Feelgoodbears" nutritional supplements, including formulation, design and ensuring 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 tax postings 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 Management / 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 management.
Monitoring medical care quality, ensuring compliance with protocols and health and safety regulations.
Ensuring high patient satisfaction and meeting patient needs.
Planning and implementing marketing strategies and organizing events to increase awareness.
Developing ideas to improve medical care through new technologies or procedures.
Analyzing data and preparing reports for the Bavarian Office for Statistics, including evaluation of relevant KPIs such as bed occupancy.

Feb 2020 - Mar 2020

2 months

Berlin, Germany

CDR Manager / BI Analyst

Vattenfall

Manage and analyze charging data (Charge Data Records) in the e-mobility area.
Create and expand comprehensive reports and visualizations in MS Power BI based on various KPIs.
Consider complex tariff structures (AC/DC, duration, kWh) in billing with customers and suppliers.
Validate CDRs from invoices and contracts and create reference tables for tariffs and charging station operators.
Report to roaming partners for invoice review and conduct CDR analyses for quarterly closing.
Technologies: MS Power BI, MS Office 365 (Excel, PowerPoint), Power Query.

Jan 2020 - Jan 2020

1 month

Plattling, Germany

BI Consultant

Rubix/Zitex

Develop a high-level concept for integrating existing ERP systems into a database system after a company merger.
Conduct as-is analysis and describe the target state.
Identify stakeholders and define requirements with priorities and implementation effort.
Outline the BI team and define responsible roles.
Visualize 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

Manage BI projects through the entire lifecycle using agile (Scrum) and traditional PM methods.
Create epics, user stories, and designs for product enhancements.
Verify and prioritize customer requirements in line with the company strategy.
Develop test cases, benchmarks, and product documentation.
Coordinate with teams of data-providing systems to plan BI changes early.
Visualize ad-hoc requests in MicroStrategy.
Design and deliver product training sessions.
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

Support the Future Retail HR IT project to implement talent management systems (TMSi).
Create IT specifications and designs for the KPI dashboard and TMSi in HP ALM, Jira, and Confluence.
Define epics and user stories for the product backlog and participate in Scrum events.
Develop and integrate a retail HR KPI dashboard with SAP BO.
Perform market-level monitoring and reporting to ensure data quality.
Manage testing including specifying and executing test cases (UAT, A/B tests) and defect handling.
Coordinate 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

Evaluate and analyze extensive pricing structures using a MySQL database.
Maintain the database by creating and editing views and tables using SQL scripts.
Process external data with Pentaho Data Integration and export as Excel reports.
Create design elements for ETL jobs and transformations for data analysis.
Perform database-level testing for quality assurance.
Visualize 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

Self-employed

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 inventories between Shopify, eBay, and Amazon using specialized apps.
Improved eBay presence by designing CSS/HTML templates.
Carried out marketing activities like SEO, content optimization, Google AdWords, and social media.
Analyzed sales data and KPIs (visitors, net sales, order value) with 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 managed a JIRA project to control workflows for updating control unit error logs.
Coordinated with other departments to define processes and timing factors.
Created state machines in UML and developed technical specifications.
Oversaw and controlled 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 in mobile technology and IoT.
Managed projects using agile methods (Scrum), including gathering requirements, sprint planning, and Kanban board management.
Extended a multi-project handling concept and synchronized several test management databases under HP QC/ALM.
Created an IP concept as a class/instance solution to structure derivatives.
Designed and implemented interfaces via OTA API in VBA for uploading test results from Excel to QC-ALM.
Developed business intelligence software, including importing test results into a MySQL database.
Defined KPIs like test plan coverage and execution progress, and created reports in QlikView.
Conducted training and user support (3rd level).
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 Lead / 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 synchronization of ALM projects within a product family.
Developed and rolled out an RDF approach for power management.
Programmed workflow scripts in QC, Excel, and Windows for process automation.
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 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

Performed system tests at the web service and front-end level to connect partners to the customer portal.
Coordinated offshore development in India and ensured communication.
Identified use cases, wrote test cases, and carried out and evaluated tests.
Tracked bugs 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

Online retailer (apparel industry)

Created an online shop with integrated inventory management.
Developed a tool for automatic data synchronization between the shop 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

Designed and created new projects in Mercury Quality Center for data provisioning of control units.
Identified and evaluated business requirements and created functional specifications.
Administered, customized, and technically implemented solutions in VBScript.
Documented and created UML diagrams.
Implemented 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 3rd level support during the Windows XP rollout.
Designed and implemented a GUI for administration of a system that provides data to decentralized servers.
Developed interfaces to process workflow information and communicate with reference servers.
Created a tool for installation checks in integration and quality assurance environments.
Designed the system architecture and automated updates of check XML files.
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

Developed a CATI program for computer-assisted telephone surveys including questionnaire logic.
Implemented skip patterns based on question responses.
Managed decentralized data storage and centralized merging of results for SPSS.
Technologies: Visual Basic 6, MS Access 2000, VBA, SPSS.

May 2003 - Oct 2003

6 months

Neuss, Germany

Database Developer

Software house (Toshiba)

Enhanced a management information system (MIS) for dynamic display of sales figures and inventory.
Designed the database and formulated complex queries.
Programmed stored procedures with T-SQL and created DTS packages.
Developed a VB program to manage user-defined system tables.
Supported international clients.
Technologies: Visual Basic 6, MS SQL Server 2000, T-SQL, DTS, Data Warehouse.

May 2002 - Mar 2003

11 months

Frankfurt, Germany

Deutsche Bank

Creation of presentations and complex charts in Excel and PowerPoint for the investment area.
Compliance with styles and standards in document creation.
Document management in Documentum.
Development of an application for creating shift schedules.
Communication and documentation 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 hot metal desulphurization processes to Visual Basic 6 using OOP.
Created the front end and database design.
Implemented data access via ADO.
Processed and exchanged data via telegram protocol (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.
Adapted the front end and installed the SQL Server on NT systems.
Database design and implementation of 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 managed a network solutions company.
Sold the company shares in 2001.

Jun 1997 - Jan 2000

2 years 8 months

Germany

Retail

Further developed and implemented a merchandise management system for retail stores.
Programmed interfaces for label printers and cash registers.
Trained staff, provided support and maintenance for the POS software.
Set up data transmission and created user manuals.
Developed the front end with Paradox (ObjectPAL).
Technologies: Windows NT 4, MS Excel 5, VBA, Paradox 5/7/9, ObjectPAL.

Industries Experience

See where this freelancer has spent most of their professional time. Longer bars indicate deeper hands-on experience, while shorter ones reflect targeted or project-based work.

Experienced in Information Technology (8 years), Retail (6.5 years), Healthcare (4.5 years), Automotive (4 years), Banking and Finance (3.5 years), and Manufacturing (3 years).

Information Technology

Retail

Healthcare

Automotive

Banking and Finance

Manufacturing

Business Areas Experience

The graph below provides a cumulative view of the freelancer's experience across multiple business areas, calculated from completed and active engagements. It highlights the areas where the freelancer has most frequently contributed to planning, execution, and delivery of business outcomes.

Experienced in Information Technology (15.5 years), Product Development (9.5 years), Project Management (8 years), Quality Assurance (7.5 years), Business Intelligence (5.5 years), and Operations (4.5 years).

Information Technology

Product Development

Project Management

Quality Assurance

Business Intelligence

Operations

Skills

Application Areas

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 Industry
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)

Profile

Created

February 2025

Last Update

March 2025

Need a freelancer? Find your match in seconds.

Try FRATCH GPT

Frequently asked questions

Do you have questions? Here you can find further information.

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 25 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 (IT), 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 (IT), Product Development, and Project Management. Kerstin also has some experience in Quality Assurance (QA), 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 and Planning.

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.