Kerstin Burgen - Reporting and Analytics for HR

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 8 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

Lorem ipsum dolor sit amet

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

Lorem ipsum dolor sit amet

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

Lorem ipsum dolor sit amet

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

Lorem ipsum dolor sit amet

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

Lorem ipsum dolor sit amet

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

Lorem ipsum dolor sit amet

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

Lorem ipsum dolor sit amet

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.

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)

Need a freelancer? Find your match in seconds.

Try FRATCH GPT

Similar Freelancers

Discover other experts with similar qualifications and experience

Sascha Jürgens

Experience

Reporting and Analytics for HR

Apobank

Developer

Metafinanz Information Systems GmbH / Allianz Insurance Company

Product Management / Project Management / Business Development

FeelGood Products GmbH

Opening a test station

Administration Management / Clinic Management

Klinik Mednord

CDR Manager / BI Analyst

Vattenfall

BI Consultant

Rubix/Zitex

Senior BI Product Manager/Owner

Xing SE

Requirements/Product Management, Reporting, and Testing

BMW Trainingsakademie

Database Developer/Analyst

E.ON

E-Commerce Business Owner

Self-employed

Process Management

BMW

Requirements Manager / Product Manager / Software Engineer

Intel Mobile Communications GmbH / Intel Germany GmbH

Project Lead / Product Management / Development

Infineon / Intel Mobile Communications GmbH

Test Analyst

Kabel Deutschland GmbH

Online retailer (apparel industry)

Requirements Manager

BMW

Incident Manager / Software Developer

Hypovereinsbank

University

Database Developer

Software house (Toshiba)

Deutsche Bank

Stahlwerke Bremen

Retail

Managing Director

Network Solutions Company

Retail

Skills

Languages

Education

Academy for Data Processing

Office Clerk · Bremen, Germany

Certifications & licenses

Professional Scrum Master (PSM I)

Professional Scrum Product Owner (PSPO I)

Similar Freelancers

Agile Coach & Partner

Project Lead & Subject Matter Expert

Agile Coach & Senior Scrum Master

Lead Product Owner

Management Consultant

Portfolio Manager, Consultant, Leadership Coach

COO & Co-Founder

Atlassian Specialist E2E Processes

CEO, Founder & Managing Partner

Senior IT Manager & Project Manager

Business & Tech Consultant

Program Manager Terahertz

Product Operations Manager, Media Operations & Growth, Global Marketing

Product Owner (Freelancer) - Intelligent Personal Assistant

AI Coach and Consultant

Founder & Product Lead

Commercial Program Manager

Interim E-Commerce SME Consultant – Special Accounts

Founder and CEO

AI Trainer

Senior Product Manager / Product Owner

Project Manager for e-Invoice Implementation

Global Director B2B SaaS and Digital Growth

CEO

Architecture Consultant (Freelance)

Interim Product Manager + Managing Director

Product Owner – Redesign of an iOS and Android SaaS Application Platform