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 in at least 5 different roles and for 12 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 is Olga's latest experience?

Olga's most recent position is External IT Consultant BI and DWH at Telefónica Deutschland .

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

In recent years, Olga has worked for Telefónica Deutschland , Versandhaus Walz GmbH , and Hamburg Tax Authority .

Q: Which industries is Olga most experienced in?

Olga is most experienced in industries like Government and Public Administration , Retail , and Telecommunication . Olga also has some experience in Pharmaceutical , Energy , and Professional Services .

Q: Which business areas is Olga most experienced in?

Olga is most experienced in business areas like Business Intelligence , Information Technology (IT) , and Project Management . Olga also has some experience in Supply Chain Management and Marketing .

Q: Which industries has Olga worked in recently?

Olga has recently worked in industries like Government and Public Administration , Retail , and Telecommunication .

Q: Which business areas has Olga worked in recently?

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

Recommended expert

Krefeld, Germany

Experience

Nov 2017 - Present

8 years 4 months

External IT Consultant BI and DWH

Telefónica Deutschland

Implement the BI solution and replace the old BI landscape
Sub-project lead for Sales Bonus Plan: Extend the existing solution and migrate to Azure
Sub-project lead for Cognos migration: Expand the existing data warehouse based on MS technologies
Analyze business requirements and create the technical solution
Expand the relational DWH database
Develop the ETL processes (SSIS)
Develop the multidimensional database (OLAP cubes/SSAS)
Use of MS SQL Server 2016 (SSMS, SSIS, SSAS, SSRS), MS SQL Server PDW, Oracle, Power BI, Delta Lake, Databricks, Synapse

Jul 2017 - Oct 2017

4 months

Career break for personal reasons

Private

Sep 2014 - Jun 2017

2 years 10 months

Development Lead and Solution Architect

Milestone Consult GmbH & Co. KG

Implement the BI solution CoreXBI for sales based on Veeva CRM
Analyze business requirements and create the technical solution
Develop the relational DWH database (Kimball/DataVault)
Develop the ETL processes (SSIS)
Develop the multidimensional database (OLAP cubes/SSAS)
Use of MS SQL Server 2014 (SSMS, SSIS, SSAS including Tabular) and Veeva CRM on the Salesforce platform

Mar 2013 - Sep 2014

1 year 7 months

BI Consultant

pmOne AG

Implement the BI solution SCOUT for inventory, order to cash and physical distribution
Create or extend the relational DWH database
Develop the ETL processes (SSIS)
Develop the multidimensional database (OLAP cubes/SSAS)
Use of MS SQL Server 2012 (SSMS, SSIS, SSAS) and Oracle EDW (SAP ERP)

Jan 2013 - Feb 2013

2 months

BI Consultant

pmOne AG

Implement the finance data mart based on the existing DWH
Create the relational database
Develop the ETL processes (SSIS)
Develop the multidimensional database (OLAP cubes/SSAS)
Use of MS SQL Server 2008 (SSMS, SSIS, SSAS)

Sep 2012 - Dec 2012

4 months

BI Consultant

Leica Camera AG

Implement the new data warehouse and support developing the planning tools
Create the relational DWH database
Develop ETL processes (SSIS)
Develop the multidimensional database (OLAP cubes/SSAS)
Support the development of the planning tool (MS SQL, SSAS WriteBack, DeltaMaster)
Use MS SQL Server 2008 (SSMS, SSIS, SSAS), SAP ERP, DeltaMaster

Apr 2012 - Sep 2012

6 months

BI Consultant

Sterling Fluid Systems GmbH

Implement the new data warehouse based on SAP ERP (SD, MM, PP, Q) and SMARTCRM
Create the relational DWH database
Develop ETL processes (SSIS)
Develop the multidimensional database (OLAP cubes/SSAS)
Use MS SQL Server 2008/2012 (SSMS, SSIS, SSAS), SAP ERP

Sep 2011 - Mar 2012

7 months

BI Consultant

defacto.x

Develop reporting systems for campaign management
Build interfaces for Microsoft Dynamics CRM and SAS (SSIS)
Create ETL processes to load the relational DWH (SSIS)
Develop the multidimensional database (OLAP cubes/SSAS)
Develop reports (SSRS)
Use MS SQL Server 2008 (SSMS), SSIS, SSAS, SSRS, Dynamics CRM, SAS

Oct 2010 - Jul 2011

10 months

BI Consultant

Hewlett Packard Deutschland

Implement the new core DWH for Otto GmbH & Co. KG
Model logical and physical data models
Create the physical DWH database
Define transformation rules for ETL and business processes
Use MS SQL Server 2008 (SSMS), ErWin, Visual Studio including TFS, SAP ERP/CRM, Teradata

Aug 2010 - Present

15 years 7 months

BI Consultant

Versandhaus Walz GmbH

DWH and BI solution for the entire business across all clients
Develop an interface to the customer system (AS400)
Develop the data warehouse (MS SQL Server)
ETL process with SSIS: data import, validation, foreign key resolution
Use MS SQL Server 2008 (SSMS), BIDS (SSIS)

Jul 2010 - Present

15 years 8 months

BI Consultant

Hamburg Tax Authority

Developed a web-browser compatible application to capture metadata for a BI solution
Developed InfoPath forms and a web service for data exchange between InfoPath and MS SQL Server
Created stored procedures for data preparation
Implemented in a SharePoint environment
Used MS SQL Server 2008 (SSMS, T-SQL), InfoPath 2010, Visual Studio 2008 (VB.NET), SharePoint 2010

Apr 2010 - Sep 2010

6 months

BI Consultant

HeidelbergCement AG

Developed a data warehouse and BI solution for the invoicing system across all clients
Developed an interface to the customer system (Sybase DB)
Built the data warehouse (MS SQL Server)
Managed ETL processes with SSIS: data loading, validation, resolving foreign keys
Designed a multidimensional database (OLAP cube)
Created reports with Cubeware
Used MS SQL Server 2005 (SSMS), BIDS (SSIS, SSAS), Cubeware

Jun 2009 - Jan 2010

8 months

Developer

Conergy AG

Developed a time tracking tool to record engineering and technician services
Designed a database and a client application
Analyzed data and generated reports
Used MS SQL Server 2005 (SSMS), Visual Studio 2005 (VB.NET), Excel 2003

Nov 2007 - Jan 2010

2 years 3 months

Developer

Conergy AG

Developed several controlling and engineering tools (forecasting, allocation, project controlling)
Supported business processes through database and user application development
Used MS SQL Server 2005 (SSMS), Visual Studio 2005 (VB.NET), Excel 2003, MS Access 2003

Industries Experience

See where this freelancer has spent most of their professional time. Longer bars indicate deeper hands-on experience, while shorter ones reflect targeted or project-based work.

Experienced in Retail (15.5 years), Government and Administration (15.5 years), Telecommunication (8.5 years), Pharmaceutical (3 years), Professional Services (2 years), and Energy (2 years).

Retail

Government and Administration

Telecommunication

Pharmaceutical

Professional Services

Energy

Business Areas Experience

The graph below provides a cumulative view of the freelancer's experience across multiple business areas, calculated from completed and active engagements. It highlights the areas where the freelancer has most frequently contributed to planning, execution, and delivery of business outcomes.

Experienced in Business Intelligence (18 years), Information Technology (18 years), Project Management (10.5 years), Supply Chain Management (1.5 years), and Marketing (0.5 years).

Business Intelligence

Information Technology

Project Management

Supply Chain Management

Marketing

Skills

Analysis And Design
Quick Comprehension
Solution-oriented
Team And Communication Skills
Willingness To Cooperate
Presentation And Facilitation
Reliability And Flexibility
Resilience And Assertiveness
Bi And Dwh On Ms Technologies (Ms Sql Server, Ssms, Focus On Ssas, Ssis, Ssrs, Etl Processes), Database Development, Power Bi, Azure Synapse, Databricks, Data (Delta) Lake
Ms Sql Server, Ms Sql Server Pdw, Databricks Delta Lake
Ms Access
Mysql
Oracle
Sql
T-sql
Mdx
Dax
Vb.net
Vba
Delphi
Html
Xml
Ms Sql Server 2005 - 2022
Sap Power Designer
Erwin
Visual Studio 2005 - 2022 (Including Ssdt, Tfs)
Ms Iis
Source Systems: Ms Dynamics Crm, Sap Erp, Sap Crm, Sas (Campaign Management), Veeva Crm, Sales Force, Dynamic Crm
Windows 2000, Xp, Vista, 7
Windows Server 2000, 2003, 2008
Data Warehouse: Expert
Data Modeling: Expert
Erwin: Expert
Sap Power Designer: Expert
Ms Sql Server: Expert
Visual Studio: Expert
Azure Synapse: Very Good
Databricks: Very Good
Olap, Tabular Technology: Expert
Power Bi: Very Good
Etl: Expert
Ssms (Management Studio): Expert
Ssis (Integration Services): Expert
Ssas (Analysis Service): Expert
Data Mining: Good
Ssrs (Reporting Services): Expert
Sql: Expert
T-sql: Expert
Mdx: Expert
Cubeware Cockpit: Good
Vb.net: Very Good
Vba: Very Good
Excel, Infopath, Access: Expert
Ms Dynamics Crm: Good
Sharepoint: Good
Teradata: Broad Knowledge
Oracle: Good
Sap Crm/erp: Broad Knowledge
Sas (Campaign Management): Broad Knowledge
Iis: Broad Knowledge
Veeva Crm (Salesforce): Broad Knowledge

Languages

Russian

Native

German

Advanced

English

Intermediate

Education

Oct 2000 - Jun 2005

State Technical University of Energy Technology

Diploma in Computer Science, Information Systems, Database Development, Data Analysis · Computer Science · Russian Federation

Certifications & licenses

Business Intelligence Development And Maintenance

Microsoft Certified Technology Specialist (MCTS): SQL Server

AZ-900: Microsoft Azure Fundamentals

Profile

Created

January 2024

Last Update

May 2025

Need a freelancer? Find your match in seconds.

Try FRATCH GPT

Frequently asked questions

Do you have questions? Here you can find further information.

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 in at least 5 different roles and for 12 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 roles would Olga be best suited for?

Based on recent experience, Olga would be well-suited for roles such as: External IT Consultant BI and DWH, Career break for personal reasons, Development Lead and Solution Architect.

What is Olga's latest experience?

Olga's most recent position is External IT Consultant BI and DWH at Telefónica Deutschland.

What companies has Olga worked for in recent years?

In recent years, Olga has worked for Telefónica Deutschland, Versandhaus Walz GmbH, and Hamburg Tax Authority.

Which industries is Olga most experienced in?

Olga is most experienced in industries like Government and Public Administration, Retail, and Telecommunication. Olga also has some experience in Pharmaceutical, Energy, and Professional Services.

Which business areas is Olga most experienced in?

Olga is most experienced in business areas like Business Intelligence, Information Technology (IT), and Project Management. Olga also has some experience in Supply Chain Management and Marketing.

Which industries has Olga worked in recently?

Olga has recently worked in industries like Government and Public Administration, Retail, and Telecommunication.

Which business areas has Olga worked in recently?

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

What is Olga's education?

Olga holds a Master in Computer Science from State Technical University of Energy Technology.

Does Olga have any certificates?

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

What is the availability of Olga?

Olga is immediately available for suitable projects.

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.