Olga Methner - External IT Consultant BI And DWH

Q: Where is Olga based?

Olga is based in Krefeld, Germany .

Q: What languages does Olga speak?

Olga speaks the following languages: Russian (Native), German (Advanced), English (Intermediate) .

Q: How many years of experience does Olga have?

Olga has at least 18 years of experience. During this time, Olga has worked and for 13 different companies . The average length of individual experience is 1 year and 3 months . Note that Olga may not have shared all experience and actually has more experience.

Q: What companies has Olga worked for in recent years?

In recent years, Olga has worked for Telefónica Deutschland Holding AG .

Q: Which industries is Olga most experienced in?

Olga is most experienced in industries like Telecommunication , Pharmaceutical , and Energy . Olga also has some experience in Chemical , Retail , and Manufacturing .

Q: Which business areas is Olga most experienced in?

Olga is most experienced in business areas like Business Intelligence , Information Technology , and Project Management .

Q: Which industries has Olga worked in recently?

Olga has recently worked in industries like Telecommunication .

Q: Which business areas has Olga worked in recently?

Olga has recently worked in business areas like Business Intelligence , Information Technology , and Project Management .

Q: What is Olga's education?

Olga attended State University of Energy Technology for Computer Science and Analytics .

Q: Does Olga have any certificates?

Olga has 2 certificates . These include: Microsoft Certified Technology Specialist (MCTS): SQL Server 2008, Business Intelligence Development And Maintenance and AZ-900: Microsoft Azure Fundamentals .

Recommended expert

Krefeld, Germany

Check rate

Experience

Nov 2017 - Jan 2026

8 years 3 months

Telefónica Deutschland Holding AG

Implemented the BI solution and replaced the old BI landscape
Led the “Sales Bonus Plan” subproject: expanded the existing solution and migrated to Azure (Databricks)
Led the “Cognos Migration” subproject: expanded existing data warehouses based on MS technologies (source systems: Oracle), analyzed business requirements and designed the technical solution
Expanded the relational DWH database
Developed ETL processes using SSIS
Developed the multidimensional database (OLAP Cubes/SSAS)

Jul 2017 - Oct 2017

4 months

Private

Personal sabbatical for private reasons

Sep 2014 - Jun 2017

2 years 10 months

Bayer AG

Acted as development lead and solution architect for CoreXBI: BI solution for sales based on Veeva CRM
Analyzed business requirements and designed the technical solution
Developed a new data warehouse using MS technologies (source: Veeva CRM on Salesforce platform)
Implemented the relational DWH database using Kimball/DataVault methodology
Developed ETL processes using SSIS
Developed the multidimensional database (OLAP Cubes/SSAS)

Mar 2013 - Sep 2014

1 year 7 months

Henkel AG & Co. KGaA

Implemented the “SCOUT” BI solution for Inventory, OTC and Physical Distribution
Extended or created the relational DWH database based on MS technologies (source: SAP ERP EDW)
Developed ETL processes using SSIS
Developed the multidimensional database (OLAP Cubes/SSAS)

Jan 2013 - Feb 2013

2 months

SOVAG AG

Implemented the financial data mart as part of BI-Refresh based on existing DWH
Created the relational database
Developed ETL processes using SSIS
Developed the multidimensional database (OLAP Cubes/SSAS)

Sep 2012 - Dec 2012

4 months

Leica Camera AG

Implemented a new data warehouse and supported development of planning tools
Created the relational DWH database using MS technologies (sources: SAP ERP, flat files)
Developed ETL processes using SSIS
Developed the multidimensional database (OLAP Cubes/SSAS)
Supported development of the planning tool with MS SQL, SSAS (WriteBack) and DeltaMaster

Apr 2012 - Sep 2012

6 months

Sterling Fluid Systems GmbH

Implemented a new data warehouse
Created the relational DWH database using MS technologies (sources: SAP ERP modules SD, MM, PP, Q; SMARTCRM)
Developed ETL processes using SSIS
Developed the multidimensional database (OLAP Cubes/SSAS)

Sep 2011 - Mar 2012

7 months

defacto.x

Developed a reporting system for campaign management
Built interfaces for Microsoft Dynamics CRM and SAS using SSIS
Developed the multidimensional database (OLAP/SSAS)
Developed ETL pipelines to load the relational DWH (SSIS)
Developed reports using SSRS

Oct 2010 - Jul 2011

10 months

Otto GmbH & Co. KG

Implemented the new Core DWH for Otto
Developed the data warehouse based on MS technologies (sources: SAP CRM/ERP, SAP ERP logistics, Oracle, Teradata)
Modeled logical and physical data models
Created the physical DWH database
Defined transformation rules for ETL processes
Documented business processes

Aug 2010 - Aug 2010

1 month

Versandhaus Walz GmbH

Delivered DWH and BI solution for the entire business across all entities
Developed an interface to the customer system (AS400)
Developed the data warehouse using MS SQL Server
Created ETL processes with SSIS, including data validation and foreign key resolution

Jul 2010 - Jul 2010

1 month

Finanzbehörde Hamburg

Developed a browser-compatible application for metadata capture for a BI solution
Created browser-compatible InfoPath forms for metadata capture and display
Developed a web service for data exchange between InfoPath and MS SQL Server
Developed stored procedures to prepare data for InfoPath and the database
Implemented the solution in a SharePoint 2010 environment

Apr 2010 - Sep 2010

6 months

HeidelbergCement AG

Delivered DWH and BI solution for invoicing across all entities in Germany
Developed an interface to the customer system (Sybase DB)
Developed the data warehouse using MS SQL Server
Created ETL processes with SSIS, including data validation and foreign key resolution
Developed a multidimensional database (OLAP Cube) with dimensions and facts
Created reports using Cubeware

Jun 2009 - Jan 2010

8 months

Conergy AG

Developed a time-tracking tool for recording engineering and installation services
Designed and implemented the database
Developed a client application
Performed data analysis and reporting

Nov 2007 - Jan 2010

2 years 3 months

Conergy AG

Developed various controlling and engineering tools (forecasting, allocation, project controlling)
Designed and implemented corresponding databases and user applications

Industry Experience

See where this freelancer has spent most of their professional time.

Experienced in Telecommunication, Pharmaceutical, Energy, Chemical, Retail, and Manufacturing.

Telecommunication

Pharmaceutical

Energy

Chemical

Retail

Manufacturing

Business Area Experience

See which departments and functions this freelancer has contributed to most.

Experienced in Business Intelligence, Information Technology, and Project Management.

Business Intelligence

Information Technology

Project Management

Skills

Bi And Dwh, Architecture, Data Modeling, Etl, Reporting
Ms Sql Server (Ssas, Ssis, Ssrs)
Power Bi
Azure
Synapse
Databricks (Spark Sql, Pyspark, Python)
Data (Delta) Lake
Oracle
Devops
Sap Power Designer
Ms Dynamics Crm
Sap Erp
Sap Crm
Sas (Campaign Management)
Veeva Crm
Sales Force

Languages

Russian

Native

German

Advanced

English

Intermediate

Education

Oct 2000 - Jun 2005

State University of Energy Technology

Diploma · Computer Science and Analytics · Russian Federation

Certifications & licenses

Microsoft Certified Technology Specialist (MCTS): SQL Server 2008, Business Intelligence Development And Maintenance

AZ-900: Microsoft Azure Fundamentals

Statistics

Experience

Total positions 14

Experience in Telecommunication 8 y

Avg length 1 y 3 m

Longest experience 8 y 2 m

Expertise

Main industries Telecommunication, Pharmaceutical, Energy

Main business areas Business Intelligence, Information Technology, Project Management

Qualifications

Certifications earned 2

Profile

Created

June 2026

Need a freelancer? Find your match in seconds.

Try FRATCH GPT

Frequently asked questions

Have questions? Find more information here.

Where is Olga based?

Olga is based in Krefeld, Germany.

What languages does Olga speak?

Olga speaks the following languages: Russian (Native), German (Advanced), English (Intermediate).

How many years of experience does Olga have?

Olga has at least 18 years of experience. During this time, Olga has worked and for 13 different companies. The average length of individual experience is 1 year and 3 months. Note that Olga may not have shared all experience and actually has more experience.

What companies has Olga worked for in recent years?

In recent years, Olga has worked for Telefónica Deutschland Holding AG.

Which industries is Olga most experienced in?

Olga is most experienced in industries like Telecommunication, Pharmaceutical, and Energy. Olga also has some experience in Chemical, Retail, and Manufacturing.

Which business areas is Olga most experienced in?

Olga is most experienced in business areas like Business Intelligence, Information Technology, and Project Management.

Which industries has Olga worked in recently?

Olga has recently worked in industries like Telecommunication.

Which business areas has Olga worked in recently?

Olga has recently worked in business areas like Business Intelligence, Information Technology, and Project Management.

What is Olga's education?

Olga attended State University of Energy Technology for Computer Science and Analytics.

Does Olga have any certificates?

Olga has 2 certificates. These include: Microsoft Certified Technology Specialist (MCTS): SQL Server 2008, Business Intelligence Development And Maintenance and AZ-900: Microsoft Azure Fundamentals.

What is the availability of Olga?

The availability of Olga needs to be confirmed.

What is the rate of Olga?

Olga's rate depends on the specific project requirements. Please use the Meet button on the profile to schedule a meeting and discuss the details.