Kerstin ilona theresia Burgen

HR Analytics Specialist

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
2 years
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)

Similar Freelancers

Discover other experts with similar qualifications and experience

Verified Expert
Chrisabel Prischl

Senior Global Product Manager

View Profile
Verified Expert
Philip Scheibl

Interim & Consulting - I solve problems and make cool things work digital | worldwide | critical & original

View Profile
Verified Expert
Sebastian Zwiesler

CRM Manager & Consultant

View Profile
Verified Expert
Christian Hildebrandt

Senior Business Consultant - Marketing Systeme und Adserver Technologien

View Profile
Verified Expert
Friederike Abresch

BUSINESS INNOVATION, TRANSFORMATION & DEVELOPMENT | On Demand Development of Products, Markets and Business Fields

View Profile
Verified Expert
Astrid Benker

Senior Change and Project Manager

View Profile
Verified Expert
Wolfgang Angeli

Ecommerce IT-/Web-Architect / Online Marketing / Multi-Channel Sales, Projektmanager

View Profile
Verified Expert
Gudrun Aydt

Expertin Omnichannel Marketing | Handel | Individuelle Beratung für kleinere und mittlere Unternehmen

View Profile
Verified Expert
Florian Forster

Senior Director, Global Education Excellence

View Profile
Verified Expert
Christian Piffer

Migrationsverantwortung Rechnungswesen & Jahresabschlusstests

View Profile
Verified Expert
Daniel Schaaf

Unternehmensberater

View Profile
Verified Expert
Oliver Greb

Senior Projektmanager / Business Development Manager

View Profile
Verified Expert
Christiane Neher

Data Lover, Digital Mover & Shaker

View Profile
Verified Expert
Juliane Schulz

Founder & CEO

View Profile
Verified Expert
Barbara Tobiesen

Senior Digital Growth Consultant

View Profile