Kerstin (Ilona theresia) B.

CDR Manager; BI Analyst

Grünwald, Germany

Experience

Feb 2024 - Aug 2024
7 months
Düsseldorf, Germany
Lorem ipsum dolor sit amet

Apobank

  • Developed a user interface system for performance reviews in HR reporting for top executives with a detailed rating scale and a 250-character limit.

  • Optimized data processing for personnel development mail merges by automating the integration of multiple data sources.

  • Implemented an annual compensation comparison in the finance sector using Power Query and Excel automation while ensuring data privacy and anonymization.

  • Automated personnel cost analysis: extracted data from the Paisy system, prepared SAP-compatible Excel files, and verified and reconciled calculated values.

  • Topics: data analysis, business intelligence, software development, VBA, test management, UAT testing, documentation.

  • Tools: Power Query, MS Office 2016 (Word, Excel, PowerPoint), Paisy.

Jun 2023 - Present
2 years 7 months
Munich, Germany
Lorem ipsum dolor sit amet

FeelGood Products GmbH

  • Developed an AI-powered solution for personalized advice in health and nutrition.

  • Topics: artificial intelligence, product management, business development, project management, data modeling, Scrum.

  • Tools: MS Azure (Azure Health Bot, Azure OpenAI (GPT-4), Azure Cognitive Search, Azure SQL Database, Azure Computer Vision (OCR)), Google Custom Search API, Trello.

  • Launched a dietary supplement brand "Feelgoodbears", including formulation, design, and compliance with all relevant health and safety regulations.

  • Built and optimized the online sales channel (website management, SEO, e-commerce platforms), ran integrated marketing campaigns, and coordinated influencer marketing.

  • Developed and maintained strategic partnerships for sales expansion and brand awareness.

  • Responsible for budgeting, financial control and reporting, cost management, investment planning, and accounting compliance.

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
Lorem ipsum dolor sit amet

Klinik mednord

  • Responsible for hiring, training, and development of doctors, nurses, and administrative staff.

  • Managed the clinic budget, billing, and payments from insurance and patients.

  • Organized and oversaw daily operations (patient management, scheduling, inventory management).

  • Ensured quality of medical care and compliance with health and safety regulations.

  • Planned and executed marketing strategies and events to raise awareness.

  • Generating ideas to improve medical care (new technologies, procedures, treatments).

  • Data analysis and preparation for the Bavarian Statistical Office (KPIs like bed occupancy, patient numbers).

  • Role: initially administrative manager, then clinic director.

Feb 2020 - Mar 2020
2 months
Berlin, Germany

CDR Manager; BI Analyst

Vattenfall

  • Created and expanded extensive analyses and charts in MS Power BI based on various KPIs.

  • Accounted for different tariffs (AC/DC, duration/kWh/session) and validated CDRs from invoices and contracts.

  • Created and expanded reference tables for B2B/B2C tariffs and charging station operators.

  • Reported roaming partners for invoice verification, CDR analysis, and quarterly reporting.

Jan 2020 - Jan 2020
1 month
Plattling, Germany

BI Consultant

Rubix/Zitex

  • Developed a high-level concept for integrating multiple ERP systems into a database system and presenting data analysis in Power BI.

  • Current state analysis, target state, stakeholder identification, requirements definition with status, priority, and implementation effort.

  • Outlined the BI team and responsibilities and defined next steps.

Feb 2019 - Jun 2019
5 months
Hamburg, Germany

Senior BI Product Manager/Owner

Xing SE

  • Managed BI projects using agile and non-agile PM methods over the entire project lifecycle, rollout, and training.

  • Created epics, user stories, test cases, and benchmarks for quality assurance.

  • Prioritized customer requirements in line with company and team strategy.

  • Maintained product documentation, liaised with data-providing and producing teams, visualized ad-hoc requests in MicroStrategy.

  • Conducted BI product trainings.

Jul 2018 - Dec 2018
6 months
Unterschleißheim, Germany

Requirements/Product Management; Reporting and Testing

BMW Trainingsakademie

  • IT specifications/concepts for the Retail HR KPI dashboard and TMSi in HP ALM, Jira, and Confluence.

  • Aligned reporting requirements with business support, central IT, and service providers.

  • Defined epics and user stories, participated in refinement, sprint planning, review, and retrospectives.

  • Test management: specified and executed test cases (UAT, A/B testing), defect management, and acceptance preparation.

  • Created ITSM tickets and Cornerstone cases in operations, working closely with the IT department and product owners.

Jun 2017 - Jun 2018
1 year 1 month
Munich, Germany

Database Developer/Analyst

E.ON

  • Managed a MySQL database: created and edited extensive views and tables via SQL scripts and work scripts.

  • Coordinated with the department on new requirements.

  • Designed and implemented jobs and transformations in Pentaho Data Integration.

  • Documented and integrated SQL scripts, jobs, and transformations, and performed database-level tests to ensure data quality.

  • Reported and visualized data in pivot tables.

Dec 2016 - Aug 2019
2 years 9 months
Munich, Germany
Lorem ipsum dolor sit amet

Own project

  • Expanded the existing shop system: integrated products from various wholesalers into Shopify and marketed on eBay and Amazon.

  • Developed an Excel solution to process CSV data with functions and references for meaningful product titles and descriptions.

  • Added products in Shopify, uploaded photos, updated inventory, and synchronized with marketplaces via a Shopify app.

  • Customized an optimized CSS/HTML template for the eBay shop and set up categories.

  • Marketing activities: SEO, Google AdWords, social media.

  • Analyzed visitor numbers, page views, net sales, and average order value in Power BI.

Aug 2016 - May 2017
10 months
Munich, Germany

Process Management

BMW

  • Defined processes for updating error memory data in JIRA, including coordination with the department.

  • Created a state machine in UML and specification.

  • Administered and supported the test project, monitored the implementation process.

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
More actions

Similar Freelancers

Discover other experts with similar qualifications and experience

Katrin M.

CEO

View Profile
Roland J.

Business Analyst Generative AI solutions

View Profile
Ursula M.

Data Scientist & AI Engineer & AI Architect

View Profile
Hakan K.

Infrastructure Team and Project Lead

View Profile
Jürgen F.

AR/VR/XR Architect

View Profile
Jens R.

Founder & Product Lead

View Profile
Tungi D.

Technical PMO | Delivery Master | LLM-Expert

View Profile
Martin G.

AI Product Owner | AI with Clear ROI

View Profile
Darav T.

COO & Co-Founder

View Profile
Manuel K.

Co-Founder

View Profile
Christian K.

CEO, Founder & Managing Partner

View Profile
Andreas E.

Building Startup Organizational Development, Setting Up Podcast(Video) Studio, AI Coach

View Profile
Sascha J.

Agile Coach & Partner

View Profile
Markus L.

Digital Business Architect & Consultant

View Profile
Matthias H.

Technical Product Owner – AI & Data Platform on AWS

View Profile
Thomas B.

Agile Coach & Senior Scrum Master

View Profile
Marcus D.

Experienced IT Project Manager with AI Expertise // Senior Product Owner // Product Manager

View Profile
Ali S.

Product Owner & Business Analyst

View Profile
Oliver S.

Senior Product Manager for Digital Application Processes

View Profile
Tarik H.

Technical Product / Digital Asset Owner

View Profile
Achim K.

Portfolio Manager, Consultant, Leadership Coach

View Profile
Eduard V.

Tech Lead Customer Base Documentation Automation

View Profile
Albert F.

Lead Product Owner

View Profile
Albert V.

Program Manager Terahertz

View Profile
Stefan R.

Senior Product Owner

View Profile
Markus F.

Interim Head of Product

View Profile
Bertrand R.

Freelance Product, IAM & Cybersecurity Consultant

View Profile
Thies S.

Interim Head of Product

View Profile
Samet P.

AI-Consultant

View Profile
Janko B.

Agile Coach in the SAP/S4 Migration Program Organization and Agile Transformation Coach

View Profile