Kerstin ilona theresia Burgen

HR Analytics Specialist

Kerstin ilona theresia Burgen
Grünwald, Germany

Experience

Feb 2024 - Aug 2024
7 months
Düsseldorf, Germany

HR Analytics Specialist

Apobank

Development of user interface system for performance evaluations:

  • Design and implementation of an interactive evaluation system, specifically developed for use by top executives to evaluate their subordinate management levels
  • The system enables differentiated evaluation of core competencies such as goal orientation, team culture, strategic alignment and individual development
  • Integration of control mechanisms to enforce 250 character limits for narrative evaluations
  • The interface captures and stores evaluations in a central spreadsheet using individual employee IDs

Optimization of data processing for personnel development:

  • Preparation of serial letters for managers containing information about subordinate managers' development
  • Project aimed at improving reliability and efficiency of data process

Technical implementation for annual compensation benchmarking:

  • Responsible for technical implementation of data preparation and analysis
  • Focus on efficient consolidation and automation of data processing
  • Merging existing data sources using Power Query
  • Development and implementation of automated processes
  • Ensuring data integrity and anonymization

Automation of personnel cost evaluation:

  • Development of automated solution for processing and analyzing personnel data from Paisy system
  • Implementation of PowerQuery for efficient data extraction and preparation
  • Creation and adjustment of data fields, account and cost center data
  • Verification and reconciliation of calculated values
Jun 2023 - Present
1 year 9 months
Munich, Germany

Product Manager

FeelGood Products GmbH

  • Strategic direction and growth, introduction of efficient operational processes and structures to support day-to-day business
  • Development and introduction of "Feelgoodbears" nutritional supplements, including formulation, design, and ensuring compliance with all relevant health and safety regulations
  • Building and optimizing online sales channels, including website management, SEO, and using e-commerce platforms to increase product sales and brand awareness
  • Implementation of integrated marketing campaigns, using digital and traditional channels, coordination of influencer marketing activities
  • Development and maintenance of strategic partnerships to expand distribution channels and increase brand visibility
  • Responsible for budgeting, financial control and reporting, including cost control and investment planning. Carrying out precise tax bookings to relevant accounts and ensuring accounting compliance
Jan 2021 - Feb 2023
1 year 2 months
Munich, Germany

Owner/Manager

Operating a testing station

Oct 2020 - Aug 2022
1 year 11 months
Munich, Germany

Administration Manager/Clinic Manager

Klinik mednord

  • Responsibility for hiring, training and development of staff including doctors, nurses and administrative staff
  • Monitoring clinic budget and managing financial matters such as billing and payments from insurance companies and patients
  • Organization and management of daily clinic operations including patient management, scheduling and inventory management
  • Monitoring and ensuring quality of medical care, including monitoring protocols and procedures and ensuring facility compliance with health and safety regulations
  • Ensuring high-level patient care, meeting patient needs and ensuring patient satisfaction
  • Marketing and public relations including planning and implementing marketing strategies and organizing events
  • Developing ideas for improving medical care including introduction of new technologies, procedures or treatments
  • Data analysis and preparation for Bavarian Office of Statistics
  • Analysis of relevant KPIs like bed occupancy, number of patients, etc
Feb 2020 - Mar 2020
2 months
Berlin, Germany

CDR Manager/BI Analyst

Vattenfall

Management and analysis of charging data in E-Mobility:

  • Creation and expansion of comprehensive evaluations and graphics in MS Power BI according to various KPIs
  • Consideration of different tariffs
  • Validation of CDRs from invoices and contracts
  • Creation and expansion of reference tables for B2B/B2C tariffs, charging station operators
  • Reporting roaming partners for invoice verification
  • CDR analyses
  • Reporting for quarterly closing
Jan 2020 - Jan 2020
1 month
Plattling, Germany

BI Consultant

Rubix/Zitex

Creation of a rough concept for ERP system integration and Power BI data analysis:

  • As-is analysis
  • Describing target state
  • Identifying stakeholders
  • Defining requirements with status, priority and implementation effort
  • Presenting BI team and responsible positions
  • Describing next steps
Feb 2019 - Jun 2019
5 months
Hamburg, Germany

Senior BI Product Manager/Owner

Xing SE

Managing BI projects with agile and non-agile PM methods:

  • Creating user stories
  • Conceptualization
  • Managing continuous product development as product manager
  • Creating test cases and reference values
  • Verifying and prioritizing customer requirements
  • Creating product documentation
  • Exchange with data supplying and producing teams
  • Visualization of ad hoc requirements in MicroStrategy
  • Concepting and conducting BI product training
Jul 2018 - Dec 2019
6 months
Unterschleißheim, Germany

Requirement/Product Manager

BMW Trainingsakademie

Future Retail HR IT project:

  • Creation of IT specifications/concepts for KPI Dashboard and TMSi
  • Documentation in HP ALM/Jira and Confluence
  • Coordination of reporting requirements feasibility
  • Definition of user stories for product backlog
  • Regular participation in agile ceremonies
  • Test management including specification and execution of test cases
  • Preparation of approvals
  • Creation of reporting relevant tickets
  • Close collaboration with IT department and business users
Jun 2017 - Jun 2018
1 year 1 month
Munich, Germany

Database Developer/Analyst

E.ON

Analysis and evaluation of pricing structure:

  • Managing MySQL database
  • Creating and editing views and tables via SQL script
  • Creating various work scripts
  • Coordinating with business department regarding new requirements
  • Creating design elements in jobs and transformations for import and data analysis
  • Processing data via Pentaho ETL tool
  • Documentation and integration of SQL scripts, jobs and transformations
  • Conducting database level tests
  • Reporting and visualization of data in pivot tables
Dec 2016 - Aug 2019
2 years 9 months
Munich, Germany

E-commerce Manager

Extension of existing shop system:

  • Development of Excel solution for reading and uploading CSV fields
  • Product creation in Shopify in various sizes per article
  • Uploading product photos
  • Updating product inventory
  • Adding new products
  • Synchronizing inventory between Shopify, eBay and Amazon
  • Creating eBay shop with various categories
  • Optimizing article presence in eBay using CSS/HTML template
  • Improving search engine ranking through SEO and content
  • Google Adwords
  • Social media management
  • Data analysis with Power BI Desktop
  • Display of tables and charts according to various KPIs like visitor numbers, product page views, net sales, average order value
Aug 2016 - May 2017
10 months
Munich, Germany

Process Manager

BMW

JIRA project for control of workflows in control unit error memory data updates:

  • Coordination with responsible department
  • Defining processes
  • Creating state machine in UML
  • Creating specification
  • Creating and administering test project
  • Supporting and controlling implementation process
Aug 2014 - Jun 2016
1 year 11 months
Neubiberg, Germany

Product Manager

Intel Mobile Communications GmbH/Intel Deutschland GmbH

Method and flow development supporting designers and testers:

  • Requirements gathering
  • Work package bundling and prioritization
  • Sprint planning and Scrum ceremonies
  • Project overview via Kanban board
  • Project management and delivery

Multiproject handling concept:

  • Creation of IP concept as classes/instances solution
  • Coordination of technical implementation tasks
  • Testing
  • Workflow script programming
  • Rollout management
  • Training

Test result upload:

  • Excel template creation
  • Interface design and implementation
  • User support
  • Training

BI software development:

  • Database design and analysis
  • API interface implementation
  • BI system integration
  • KPI definition
  • Testing and training
  • Qlikview reporting
Feb 2014 - May 2014
4 months
Unterföhring, Germany

Developer

Metafinanz-Informationssysteme GmbH/Allianz

Implementation of workflow for test execution control in VAPI-XP (HP ALM):

  • Creating external VBScripts via VAPI-XP
Nov 2010 - Dec 2014
3 years 2 months
Neubiberg, Germany

Project Manager

Infineon/Intel Mobile Communications GmbH

Project management and technical implementation:

  • Introduction of QC based test management
  • Concept development for multiproject handling
  • Team coordination
  • Process rollout
  • Documentation and training
  • Interface programming
  • Report development
  • Workshop moderation
  • Process and requirements management
Mar 2009 - Mar 2010
1 year 1 month
Unterföhring, Germany

Test Analyst

Kabel Deutschland GmbH

Testing portal integration projects:

  • Communication with offshore and internal developers
  • Test case identification and description
  • Test execution and evaluation
  • Error tracking
  • Support for test automation
Aug 2008 - Feb 2009
7 months
Munich, Germany

E-commerce Developer

Creation of online shop with merchandise management:

  • Development of inventory management system
  • Development of automatic data synchronization tool between shop and inventory system
Apr 2006 - Dec 2009
2 years 9 months
Munich, Germany

Requirements Manager

BMW

Conception and creation of new projects in Mercury Quality Center:

  • Requirements analysis and evaluation
  • Development of operational projects including role concept
  • Technical implementation in VBScript
  • Documentation and UML diagrams
  • Quality assurance
  • Error analysis and resolution
  • Data import/export automation
Feb 2004 - Mar 2006
2 years 2 months
Munich, Germany

Incident Manager/Developer

Hypovereinsbank

Multiple projects:

  • Windows XP rollout incident management and support
  • Development of data supply system for decentralized bank servers
  • Development of installation verification tool
  • GUI development
  • System architecture design
  • Integration support
Nov 2003 - Dec 2004
2 months
Bremen, Germany

Developer

University

Development of CATI program for computer-assisted telephone interviews:

  • Questionnaire implementation
  • Question flow and filtering logic
  • Decentralized data storage
  • Data consolidation and SPSS integration
May 2003 - Oct 2003
6 months
Neuss, Germany

Database Developer

Software Company/Toshiba

MIS (Management Information System) development:

  • Concept creation
  • Database design
  • Query development
  • Stored procedure programming
  • DTS package creation
  • Data warehouse implementation
  • System administration tool development
May 2002 - Mar 2003
11 months
Frankfurt, Germany

Desktop Publisher/Developer

Deutsche Bank

Investment division presentation creation:

  • Complex Excel graphics development
  • PowerPoint presentation creation
  • Document management in Documentum
  • Shift planning application development
  • English language documentation
Sep 2001 - Apr 2002
8 months
Bremen, Germany

Developer

Stahlwerke Bremen

Migration of pig iron desulfurization calculation application:

  • Frontend development
  • Database design
  • ADO data access implementation
  • SIVAX telegram data exchange
Jul 2000 - May 2001
11 months

Retail Developer

Database migration project:

  • Migration from Paradox 9 to MS SQL Server 7
  • Frontend adaptation
  • SQL Server installation and configuration
  • Data integrity implementation
  • Automated backup solution
  • Excel and Word VBA programming
Aug 1999 - Apr 2001
1 year 9 months

Managing Director

Founded and managed network solutions company until selling shares in 2001

Jun 1997 - Jan 2000
2 years 8 months

Retail Systems Developer

Retail management system development:

  • METO printer interface programming
  • POS software interface
  • Staff training
  • System support
  • POS software maintenance
  • Branch implementation
  • Remote data transfer
  • User manual creation
  • Paradox frontend development
  • Excel data query programming

Languages

German
Native
English
Advanced
French
Elementary

Education

Akademie für Datenverarbeitung

Bürokauffrau · Bremen, Germany

Certifications & licenses

Professional Scrum Master (Psm I)

Professional Scrum Product Owner (Pspo I)