Germo G.
BI Development
Experience
Jul 2023 - Present
2 years 2 monthsBI Development
Rhenus Logistics
- Industry: Logistics
- Migration from Cognos to Microsoft BI
Mar 2023 - Jul 2023
5 monthsBI Development
SoftwareONE
- Migrations
- from SSAS OLAP through SSAS Tabular to Power BI Premium
- from on-premise Data Warehouse to Data Lakehouse
Nov 2022 - Dec 2022
2 months Lorem ipsum dolor sit amet
TÜV Rheinland i-sec GmbH
- Coaching on SSAS data modeling and Power BI
- Coaching on Microsoft BI and Microsoft SQL Server
Sep 2022 - Dec 2022
4 months Lorem ipsum dolor sit amet
Kerkhoff Experts GmbH
- Quick scan for purchasing
- Spend cube with Microsoft Power BI
May 2022 - Jan 2023
9 months Lorem ipsum dolor sit amet
Nomura Asset Management Europe KVG mbH
- Industry: Banking and financial services
- Size: 10-50 employees
- Built new DWH, migrated from old DWH
- DWH and ELT created with AnalyticsCreator
- Microsoft SQL Server (on-premise)
- AnalyticsCreator
- DataHandwerk
- Antora
- git
Mar 2022 - Apr 2022
2 monthsSupport in Microsoft SQL Server / BI
Betty Barclay
- Industry: Consumer goods and retail
- Size: 1000-5000 employees
- Microsoft SQL Server (on-premise)
- Power BI
- BimlExpress
- git
Jan 2022 - Apr 2022
4 monthsSupport in Microsoft SQL Server / BI
Roller
- Industry: Consumer goods and retail
- Size: ?
- Microsoft SQL Server (on-premise)
- Power BI
- BimlExpress
- git
Aug 2021 - Jun 2022
11 monthsSupport in Microsoft SQL Server / BI
Syskron - in House of Krones
- Industry: Industrial and mechanical engineering
- Krones is global leader in filling lines
- Size: >10,000 employees (Krones)
- Microsoft SQL Server (on-premise)
- Power BI
- DataHandwerk
- Antora
- git
- jira
Aug 2021 - Dec 2021
5 months Lorem ipsum dolor sit amet
abcfinance
- Industry: Banking and financial services
- Size: 500-1000 employees
- Concept and PoC for a “source to target” documentation for central DWH across layers (Data Vault, star schema, tabular models)
- Includes versioning, metadata enrichment, business data, interfaces for business users, link to source system info in ETL/ELT, etc.
- Support in solution implementation
- Develop processes/workloads for doc generation and update
- Introduce suitable tool
- Microsoft SQL Server (on-premise)
- DataHandwerk
- Antora
- git
- TFVC
Apr 2021 - Jun 2021
3 monthsPower BI Expert
Peter Hahn GmbH
- Industry: Consumer goods and retail
- Size: >1,000 employees
- Facilitate BI requirement workshops
- Consulting and creating mappings & BI implementations
- Turn requirements into technical BI solutions
- Collaborate with subprojects and provide inputs
- Microsoft SQL Server (on-premise)
- Power BI
- TFVC
Feb 2020 - Mar 2021
1 year 2 monthsPerformance Reporting: Microsoft BI Architect and Developer
MEAG - Munich ERGO Assetmanagement GmbH
- Industry: Banking and financial services
- Size: 500-1000 employees
- Developed a reporting tool with Power BI for automated report creation from SimCorp Dimension instead of Excel sheets
- DWH, ELT and SSAS built with AnalyticsCreator
- Modules in Python, PowerShell
- Microsoft SQL Server (on-premise)
- AnalyticsCreator
- Power BI
- git
Nov 2019 - Dec 2019
2 monthsBuild DWH with AnalyticsCreator
Würth Logistics AG
- Industry: Transport and logistics
- Size: 50-250 employees
- Used AnalyticsCreator to build a reporting DWH for logistics data in SQL Server + SSAS Tabular for flexible reporting with Power BI or other frontends
- Coached internal developers to extend the DWH with AnalyticsCreator
- Data source: operational logistics DWH (Oracle), planned SAP etc.
- Swiss logistics company coordinating global logistics for a German Fortune 500 leader in assembly and fastening materials
- Microsoft SQL Server (on-premise)
- AnalyticsCreator
- git
Sep 2019 - Present
6 yearsMicrosoft BI Architect and Developer
Iconcare (BInovis & Visality)
- Industry: Healthcare, hospital, logistics
- Size: 10-50 employees
- Hospital Process Analyzer
- 30 years of process control experience in hospitals and airports behind this Iconcare tool
- Project goal: develop a standard control tool for OR planning and management with unique features for early detection and response to process disruptions
- Process and time analysis in hospitals (OR times, changeover, utilization, staff use)
- Tech:
- Microsoft SQL Server
- Power BI
- Microsoft Fabric
- SmartHome
- assisted living
- smart meters
- energy usage time analysis
- HomeAssistant
- IoT
- MQTT
- Microsoft SQL Server (on-premise)
- Python
Sep 2019 - Mar 2020
7 months Lorem ipsum dolor sit amet
Swisscom
- Industry: Telecom
- Size: >10,000 employees
- Imported and processed ServiceNow data for reporting, built DWH with AnalyticsCreator, reports in Power BI
- API import from ServiceNow (Python)
- Import, integrate, transform in SQL Server DWH
- SSAS analytical database
- Reports in Power BI
- DWH, ELT, SSAS with AnalyticsCreator
- Microsoft SQL Server (on-premise)
- AnalyticsCreator
- git
- jira
Oct 2018 - Sep 2019
1 yearNew DWH: Microsoft BI Architect and Developer, BI Analysis Platform, AnalyticsCreator
Provinzial Nord-West
- Industry: Insurance
- Size: 5000-10,000 employees
- Built new DWH on Azure, based on MS SQL BI tech
- SQL Server (relational, SSAS, SSIS) on-premise and Azure
- Power BI
- AnalyticsCreator
- Big Data
- jira
- git
Aug 2018 - Oct 2018
3 monthsProduction Step Throughput: Microsoft BI Architect and Developer, BI Analysis Platform, AnalyticsCreator
ZEISS Group
- Industry: Industrial and mechanical engineering
- Size: >10,000 employees
- Production step throughput
- Redesigned existing Power BI solution: moved to DWH + SSAS Tabular for performance and richer analytics
- Combined logic in DWH (SQL Server) and SSAS Tabular
- DWH, ELT, SSAS with AnalyticsCreator
- Microsoft SQL Server (on-premise)
- AnalyticsCreator
- Power BI
- TFVC
- git
- Microsoft Azure support: Azure services, SSAS migration, ETL / ELT, misc
- SQL Server (on-premise and Azure)
Nov 2017 - Jul 2018
9 months“Candidate-Cube”: Microsoft BI Architect and Developer, BI Analysis Platform, AnalyticsCreator
Adecco Germany Holding SA & Co. KG
- Industry: Staffing services
- Size: >10,000 employees
- Extend existing DWH with a “Candidate-Cube”:
- Gather business requirements
- Create specs
- Technical implementation
- Build ETL (SSIS)
- Cube creation (SSAS)
- Reports (SSRS)
- DWH, ELT, SSAS with AnalyticsCreator
- Prep for possible Azure migration
- Products:
- SQL Server (relational, SSAS, SSIS) on-premise
- Power BI
- AnalyticsCreator
- TFVC
May 2017 - Nov 2017
7 monthsChurn Prevention: Microsoft BI Architect and Developer, BI Analysis Platform, AnalyticsCreator, Data Scientist
Adam Opel GmbH
- Industry: Automotive
- Size: >10,000 employees
- Predict churn rates (brand switch), analyses
- Data Vault, data mining, prediction
- SQL Server (relational, SSAS, SSIS) on-premise
- Power BI
- AnalyticsCreator
- DWH, ELT, SSAS with AnalyticsCreator
- TFVC or git
Apr 2017 - May 2017
2 monthsReporting and statistics with Power BI
Kuhn und Bülow Versicherungsmakler Group
- Industry: Insurance
- Size: 10-50 employees
- Build foundations for stats and reports to analyze policyholders, insurers, claims and premiums from operational data
- Power BI
- TFVC
Sep 2016 - Dec 2016
4 monthsCustomer Segmentation, Ancillaries: Microsoft BI Architect and Developer
airberlin
- Industry: Transport and logistics
- Size: 5000-10,000 employees
- SQL Server 2014 (relational, SSAS, SSIS) on-premise
- jira
- TFVC
Jul 2016 - Jun 2017
1 yearSSAS databases for planning system with Tagetik: Microsoft BI Architect and Developer, Microsoft
Kelvion
- Industry: Industrial and mechanical engineering
- Size: 1000-5000 employees
- SQL Server 2016 (relational, SSAS, SSIS, SSRS) on-premise
- cMORE/Connect for SAP (Theobald SAP Integration)
- cMORE/XL (XLCubed)
- Targit
- Power BI
- git
Jun 2016 - Jul 2016
2 months Lorem ipsum dolor sit amet
proXcel GmbH
- Industry: Consulting
- Size: 10-50 employees
- Support in analyzing and processing complex production data with Microsoft BI Analysis Platform, data mining
May 2016 - May 2016
1 monthBI Support, Microsoft BI Analysis Platform
Heraeus Kulzer
- Industry: Industrial and mechanical engineering
- Size: 1000-5000 employees
- SQL Server (relational, SSAS, SSIS) on-premise
- TFVC
Mar 2016 - Sep 2018
2 years 7 monthsBICC (BI Competence Center) - Dashboards with Datazen, BI Analysis Platform: Microsoft BI Architect and Developer
ZEISS Group
- Industry: Industrial and mechanical engineering
- Size: >10,000 employees
- SQL Server (on-premise)
- ETL, DWH, reports: Project control dashboards with Datazen
- Data import from SAP and Essbase
- SAP via cMORE/Connect for SAP (Theobald)
- Products:
- Datazen
- SQL Server (on-premise)
- TFVC
- Core project 03.2016 - 04.2016, support until 09.2018 including ServiceNow migration
Jun 2015 - Mar 2016
10 monthsBI Competence Center VW Commercial Vehicles, Data Mining, neural networks, visualization, BI Analysis Platform:
Volkswagen Used Vehicle Trading and Service GmbH (VGSG)
- Industry: Automotive
- Size: >10,000 employees
- Data Mining Leasing, DM VGSG (young used)
- Data mining with Statistica
- Neural networks
- Forecast residual values and sales volume for used VW commercial and lease vehicles
- HIS: dealer info system
- PuRAS: profitability and accounting after sales
- Master data management
- Visualizations with Tableau
- BI development with SQL Server (relational, SSAS, SSIS) on-premise
- Wherescape
- TFVC or jira
- scientific background:
- Gleue, C.; Eilers, D.; von Mettenheim, H.-J.; Breitner, M. H. (2017):
- Decision Support for the Automotive Industry: Forecasting Residual Values using Artificial Neural Networks,
- in Leimeister, J.M.; Brenner, W. (eds): Proceedings of 13th International Conference on Wirtschaftsinformatik (WI 2017), St. Gallen, pp. 1205-1219
Aug 2012 - May 2015
2 years 10 monthsSCOUT (= Supply Chain Optimization Unified Toolbox), BI Analysis Platform: Microsoft BI Architect and Developer
Henkel AG & Co. KGaA
- Industry: Consumer goods and retail
- Size: >10,000 employees
- Inventory
- Order to Cash
- Physical Distribution
- Forecast Accuracy
- Product Availability
- Days of Supply
- Slow Mover Detection for financial devaluation
- Migrated and extended an application from SAP BW to SQL Server
- BI design and development with SQL Server 2012 on-premise
- Main focus: SSAS, datamart, also SSIS
- Reporting with XLCubed
- SAP via cMORE/Connect for SAP (Theobald)
- TFVC
Oct 2011 - Apr 2012
7 monthsMoscow, Russian Federation
Procurement Performance Management (PPM), Spend Control, Supplier Consolidation: BI Developer
MTS (Mobile TeleSystems OJSC)
- Industry: Telecom
- Size: >10,000 employees
- Procurement Performance Management
- Spend Control
- Supplier Consolidation
- SQL Server (on-premise) and SSAS
Feb 2011 - May 2012
1 year 4 monthsSwitzerland
Dynamic Planning Framework - Dynamic Forecast: Microsoft BI Architect and Developer
Nestlé Suisse S.A
- Industry: Consumer goods and retail
- Size: >10,000 employees
- BI design, development with SQL Server 2005/2008 (ETL, staging, DWH)
- Performance tuning
- Requirements analysis, design, liaise with business, development, documentation, testing, tuning, maintenance, consulting
- SQL Server 2005, SQL Server 2008 R2 on-premise
Nov 2010 - Dec 2019
9 years 2 monthsHospital DWH: Microsoft BI Architect and Developer
DRK Kliniken Berlin
- Industry: Healthcare, hospital
- Size: 1000-5000 employees
- Project: materials management, occupancy, operations, DRG info
- Construction and investment controlling
- OR management (planning, utilization, changeover times…)
- Monthly reporting
- Financial planning and projections
- Migrated BI apps from SQL Server 2000 to 2008 R2
- User training
- Data sources: Orbis (HIS) etc.
- Skills: planning, controlling, requirements, design, liaising, tuning, reporting, documentation, testing
- Products: SQL Server 2008 R2 on-premise (relational, SSAS, SSIS, SSRS), Access, Cubeplayer, Subversion
- Ongoing support until full migration to clinical DWH by HIS vendor
Nov 2010 - Feb 2011
4 monthsP4P CoreDWH - Datamarts/Reports, BI Analysis Platform: Microsoft BI Architect and Developer
Otto Group
- Industry: Consumer goods and retail
- Size: >10,000 employees
- Multichannel retail
- Financial services
- Service
- BI design, development with SQL Server
- Requirements, design, liaise, development, docs, testing, tuning, maintenance, reporting
- SQL Server 2008 R2 (relational, SSAS, SSIS) on-premise
Sep 2010 - Nov 2010
3 monthsMigration of order entry stats from SAP BW to SQL Server: Microsoft BI Architect and Developer
Krones AG
- Industry: Industrial and mechanical engineering
- Size: >10,000 employees
- BI design, development with SQL Server
- Requirements analysis
- SQL Server 2008 R2 (relational, SSAS, SSIS) on-premise
- SAP via cMORE/Connect for SAP (Theobald)
- TFVC (?)
Jan 2010 - Aug 2010
8 monthsGLOBIS (Global Business Information System), COLOR (Common Local Profitability Reporting), BI Analysis Platform:
Henkel AG & Co. KGaA
- Industry: Consumer goods and retail
- Size: >10,000 employees
- BI design, development with SQL Server
- Requirements analysis
- SQL Server 2008 R2 (relational, SSAS, SSIS) on-premise
Oct 2008 - Dec 2009
1 year 3 monthsBI Team (Controlling, Finance, IT), BI Analysis Platform: Microsoft BI Architect and Developer
Rudolf Wöhrl AG
- Industry: Consumer goods and retail
- Size: 1000-5000 employees
- Projects: HR controlling, workforce planning
- Migrated SQL Server 2000/2005 to 2008 on-premise
- Reporting with Bissantz Deltamaster
- Subversion (?)
- Data sources: various
Oct 2005 - Aug 2012
6 years 11 monthsAnsbach, Germany
Hospital: design and build analytic apps for controlling and HR, Microsoft
District Hospitals Middle Franconia, Ansbach
- Industry: Healthcare, hospital
- Size: 1000-5000 employees
- Psychiatric hospitals, controlling and central HR
- Designed and built analytic apps for:
- Financial controlling
- Business planning
- HR data controlling
- Occupancy controlling
- Medical controlling of psychiatric and somatic cases
- Ongoing support
- Migrated SQL Server 2000 to 2005/2008 on-premise
- Data sources: Orbis (HIS), PWS (HR data), Excel, others
Oct 2005 - Dec 2011
6 years 3 monthsFreelance expert in business analysis (BI) for hospitals, Microsoft BI Analysis Platform: Microsoft BI Architect
HGC GesundheitsConsult GmbH
- Industry: Healthcare, hospital
- Size: 10-50 employees
- Partner: GfS => HGC GesundheitsConsult GmbH => Vendus
- Projects:
- Hospital controlling
- Medical controlling
- Data model, analysis and reporting design for:
- Market and competitive controlling of medical services
- Service structure comparisons
- KPI benchmarking
- Referrer controlling
- Clinical path controlling
- Financial controlling
- Case-based cost accounting with gross margins or full costs
- Business planning
- HR data controlling
- Occupancy controlling
- Performance comparisons across departments and sites
- Data sources: various (SAP, ORBIS, text files, Excel…)
- SQL Server (2000, 2005, 2008) relational, MSAS, SSAS, DTS, SSIS on-premise
- Bissantz Deltamaster
- Subversion
Sep 2005 - Jan 2009
3 years 5 monthsIT Application Dev, Data Warehouse and OLAP, Microsoft BI Analysis Platform: Microsoft BI Architect and
Landwirtschaftliche Rentenbank
- Industry: Banking and financial services
- Size: 50-250 employees
- Projects:
- Concept
- Production workflows (Subversion)
- Dev standards
- Test concepts
- Evolve DW and OLAP apps
- Migrate SQL Server 2000 to 2005
- Analyze user needs
- Develop business and tech concepts
- Design and run user training on OLAP
- Focus: IAS & HGB financials, controlling, money markets, securities issuance
- Data sources: iSeries (AS 400)
- Requirements, design, liaise, dev, docs, testing, tuning, maintenance, reporting
- SQL Server 2000 (relational, MSAS, DTS) on-premise
- SQL Server 2005 (relational, SSAS, SSIS, SSRS) on-premise
- MIS Plain
- Datawarehouse Explorer
- Subversion
Sep 2004 - Oct 2004
2 monthsDevelop analytical module for DRG grouper, incl. scenarios and cost module: Microsoft BI Architect
ID GmbH
- Industry: Healthcare, hospital
- Size: 10-50 employees
- Data sources:
- §21 data
- IMC data or other formats
- These feed DRG grouper
- Optional case-based cost data
- SQL Server 2000 (relational, DTS, MSAS) on-premise
- Excel
- Cubeware Analysis System
Jan 2004 - May 2004
5 monthsConcept and implementation of “§21-DRG Analysis” (for hospitals)
MIS GmbH
- Industry: Consulting
- Size: 250-500 employees
- Industry: Healthcare, hospital
- Data: §21 data, IMC data; fixed grouper data; optional cost data
- DWH: SQL Server
- ETL: TSQL, DTS
- OLAP: MSAS, MIS Alea
- Frontends: MIS Onvision, MIS Plain
Jan 2004 - Apr 2004
4 monthsMedical controlling, DRG controlling and reporting design, modeling and support of relational and analytic
VzE - Assoc. for Protestant Hospitals
- Industry: Healthcare, hospital
- Size: 5000-10,000 employees
- Coaching on various frontends (MIS Plain, MIS Onvision) for reporting
- User training on software and database use
- Data sources: various: §21 data, manual sources, SAP…
- DWH: SQL Server
- ETL: TSQL, DTS
- OLAP: MSAS
- Frontends: MIS Onvision, MIS Plain
Jan 2003 - Apr 2010
7 years 4 monthsHospital – central finance and DRG reporting, Microsoft BI Analysis Platform: Microsoft BI Architect and Developer
Vivantes GmbH - Health Network
- Industry: Healthcare, hospital
- Size: >10,000 employees
- Projects:
- Controlling
- Cost accounting
- Quality and process management
- Technical design
- Modeled and managed central finance and DRG reporting
- Coached on frontends
- Ongoing support
- User training on OLAP dbs
- Migrated SQL Server 2000 to 2005
- Data sources: SAP, Excel, text files, Access…
- Requirements, design, liaise, dev, docs, testing, tuning, maintenance, reporting
- SQL Server 2000 (relational, MSAS, DTS) on-premise
- SQL Server 2005 (relational, SSAS, SSIS) on-premise
- Bissantz Deltamaster
- Softpro CubePlayer
- MIS Plain
- MIS Onvision
- MIS Integration Framework
- Subversion
Sep 2001 - Dec 2003
2 years 4 monthsDesign, development and support of “DRC” (Diagnosis Related Costs) for various cost accounting views
KCC
- Industry: Healthcare, hospital
- Size: 10-50 employees
- (hospital sector) with MIS partner
- As DRGs measure revenue, DRCs allow cost calculations to match structure
- Contribution margin calculations
- DRCs used in multiple hospitals
- Data sources vary by hospital
- DWH: SQL Server
- ETL: TSQL, DTS, Access, Excel
- OLAP: MSAS
- Frontends: MIS Onvision, MIS Plain
May 2001 - May 2004
3 years 1 monthEmployed BI Architect and Developer (Consulting via MIS GmbH)
Medienhaus Aschendorff
- Industry: Media and publishing
- Size: 500-1000 employees
- Designed and implemented advertisement information system (AIS)
- DWH: SQL Server ‘VIVAinfo’ based on VI&VA, extended with objects and ETL
- ETL: TSQL and DTS
- Analytic DB: MSAS
- Supported and trained on MIS Plain for reporting
- Data sources: VI&VA, a SAP-based extension for newspapers, and others
Jan 2001 - Dec 2001
1 yearConcept and implementation of “MIS Business Solution Hospitals”
MIS GmbH
- Industry: Healthcare, hospital
- Size: 250-500 employees
- DWH: SQL Server
- ETL: TSQL, DTS
- Analytic DBs: MIS Alea, MSAS
Sep 2000 - Mar 2002
1 year 7 monthsAdvertisement Information System (AIS) based on VI&VA data (Consulting via MIS GmbH)
Märkische Oderzeitung
- Industry: Media and publishing
- Data sources: SAP, VI&VA
- ETL: Access, Excel
- Analytic DB: MIS Alea
- Frontend: MIS Alea Excel Integration
Dec 1999 - Sep 2000
10 monthsTechnical project lead (Consulting via MIS GmbH)
Deutsche Telekom
- Industry: Telecom
- Size: >10,000 employees
- Migrated analytic app from MIS Alea to MS Analysis Services (then MS OLAP Services), kept existing reporting
- DWH: SQL Server
- ETL: TSQL, DTS
- Analytic DBs: MIS Alea, MS OLAP Services
- Frontend: MIS Alea Excel Integration
Sep 1999 - Sep 2004
5 years 1 monthEmployed BI Architect and Developer
MIS GmbH
- Industry: Consulting
- Size: 500-1000 employees
- Projects:
- Client and project acquisition
- Initial meetings
- Present MIS offerings
- Engage prospects at events
- Run acquisition workshops
- Prepare proposals
- Customer situation analysis
- Capture business and technical requirements
- Develop business and technical concepts with client
- Lead design workshops
- Implement analysis and reporting systems
- Take project responsibility
- Deliver solutions with common DB tech and languages
- Align solutions with overall project and business concepts
- Design and deliver custom training
- Multiple migrations from MIS Alea to MSAS 2000
- Diverse projects across industries (energy, insurance, banking…)
Summary
- Excellence through expertise
- Craftsmanship instead of assembly line
- Technocracy instead of democracy
- Trust in experts
As a medical cyberneticist I am “cybernetic in thinking and acting”
- Analyze target vs actual
- Identify various paths
- Consider causes and effects
- Detect disturbances and respond to them.
Social skills, quick grasp and ambition ensure that professional requirements are precisely captured and implemented with maximum customer satisfaction:
- competent, goal-oriented, also lateral-thinking and nonconformist
- analytical, precise, responsible, independent, fast, effective and efficient.
Languages
German
NativeEnglish
AdvancedRussian
AdvancedEducation
Pirogov Russian National Research Medical University
MD, Biophysicist, Medical Cyberneticist · Medical Cybernetics · Moscow, Russian Federation
Need a freelancer? Find your match in seconds.
Try FRATCH GPT More actions
Similar Freelancers
Discover other experts with similar qualifications and experience
- English
- Deutsch
2025 © FRATCH.IO GmbH. All rights reserved.