Kerstin (Ilona theresia) Burgen
CDR Manager; BI Analyst
Experience
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.
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.
Opening a test station
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.
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.
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.
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.
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.
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.
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.
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
Education
Academy for Data Processing
Office Clerk · 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