Olga Methner

Implementing BI solution; replacing old BI landscape

Krefeld, Germany

Experience

Nov 2017 - Jan 2024
6 years 3 months
Germany

Implementing BI solution; replacing old BI landscape

Telefónica Deutschland Holding AG

On assignment from Oraylis GmbH.

  • Sub-project lead “Sales Bonus Plan” (ongoing):
  • Extending the existing solution, migration to Azure
  • Sub-project lead “Cognos Migration” (completed):
  • Expanding the existing data warehouse based on MS technologies (source systems: Oracle):
  • Analyzing business requirements and creating the technical solution
  • Extending the relational DWH database
  • Developing the ETL processes (SSIS)
  • Developing the multidimensional DB (OLAP cubes/SSAS)

Used technologies:

  • 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

Sabbatical for personal reasons

Familie

Sep 2014 - Jun 2017
2 years 10 months
Germany

Development Lead and Solution Architect

Bayer AG

CoreXBI: Implementing BI solution for sales (based on Veeva CRM).

On assignment from Milestone Consult GmbH & Co. KG.

  • Developing the new data warehouse based on MS technologies (source systems: Veeva CRM (pharma CRM on Salesforce platform)):
  • Analyzing business requirements and creating the technical solution
  • Developing the relational DWH database (Kimball/DataVault)
  • Developing the ETL processes (SSIS)
  • Developing the multidimensional DB (OLAP cubes/SSAS)

Used technologies:

  • MS SQL Server 2014 (SSMS, SSIS, SSAS including Tabular)
  • Veeva CRM (pharma CRM on Salesforce platform)
Mar 2013 - Sep 2014
1 year 7 months
Germany

“SCOUT”: Implementing BI solution for Inventory, OtC (Order to Cash) and Physical Distribution

Henkel AG & Co. KGaA

On assignment from pmOne AG.

  • Developing the new or extending the existing data warehouse based on MS technologies (source systems: EDW (based on SAP ERP)):
  • Creating or extending the relational DWH database
  • Developing the ETL processes (SSIS)
  • Developing the multidimensional DB (OLAP cubes/SSAS)

Used technologies:

  • MS SQL Server 2012 (SSMS, SSIS, SSAS)
  • Oracle EDW (SAP ERP)
Jan 2013 - Feb 2013
2 months
Germany

BI refresh: Implementing the finance datamart based on existing DWH

SOVAG AG

On assignment from pmOne AG.

  • Developing the new finance datamart based on MS technologies (source systems: existing DWH):
  • Creating the relational database
  • Developing the ETL processes (SSIS)
  • Developing the multidimensional DB (OLAP cubes/SSAS)

Used technologies:

  • MS SQL Server 2008 (SSMS, SSIS, SSAS)
Sep 2012 - Dec 2013
4 months
Germany

BI refresh: Implementing the new data warehouse & supporting development of planning tools

Leica Camera AG

  • Developing the new data warehouse based on MS technologies (source systems: SAP ERP, flat files):
  • Creating the relational DWH database
  • Developing the ETL processes (SSIS)
  • Developing the multidimensional DB (OLAP cubes/SSAS)
  • Supporting development of the planning tool (MS SQL, SSAS (WriteBack), DeltaMaster)

Used technologies:

  • MS SQL Server 2008 (SSMS, SSIS, SSAS)
  • SAP ERP
  • DeltaMaster
Apr 2012 - Sep 2012
6 months
Germany

Implementing the new data warehouse

Sterling Fluid Systems GmbH

  • Developing the new data warehouse based on MS technologies (source systems: SAP ERP (SD, MM, PP, Q), SMARTCRM):
  • Creating the relational DWH database
  • Developing the ETL processes (SSIS)
  • Developing the multidimensional DB (OLAP cubes/SSAS)

Used technologies:

  • MS SQL Server 2008/2012 (SSMS, SSIS, SSAS)
  • SAP ERP (SD, MM, PP, Q)
Sep 2011 - Mar 2012
7 months
Germany

Developing reporting system for campaign management, creating interfaces for Microsoft Dynamics CRM and SAS

defacto.x

  • Developing interfaces for Microsoft Dynamics CRM and SAS (SSIS)
  • Developing the multidimensional DB (OLAP, SSAS)
  • Developing the ETL pipelines to load the relational DWH (SSIS)
  • Developing the reports (SSRS)

Used technologies:

  • MS SQL Server 2008 (SSMS)
  • SSAS
  • SSIS
  • SSRS
  • Microsoft Dynamics CRM
  • SAS (campaign management)
Oct 2010 - Jul 2011
10 months
Germany

Implementing the new core DWH for Otto GmbH & Co. KG

Otto GmbH & Co. KG

On assignment from Hewlett Packard Deutschland.

  • Developing the data warehouse based on MS technologies (source systems: SAP CRM/ERP, SAP ERP logistics, Oracle, Teradata)
  • Modeling the logical and physical data models
  • Creating the physical DWH database
  • Defining transformation rules for ETL processes
  • Documenting business processes
  • etc.

Used technologies:

  • MS SQL Server 2008 (SSMS)
  • ErWin
  • Visual Studio (including TFS)
  • SAP ERP
  • SAP CRM
  • Teradata
Aug 2010 - Aug 2010
1 month
Germany

DWH and BI solution for the entire company across all clients

Versandhaus Walz GmbH

  • Developing an interface to the customer system (AS400)
  • Developing a data warehouse (MS SQL Server)
  • ETL process (transferring data from the customer system to the DWH using SSIS packages, data validation and foreign key resolution)

Used technologies:

  • MS SQL Server 2008 (SSMS)
  • BIDS (SSIS)
Jul 2010 - Jul 2010
1 month
Hamburg, Germany

Developing a web browser–compatible application for capturing metadata for a BI solution

Finanzbehörde Hamburg

  • Developing web browser–compatible forms with InfoPath for capturing and displaying metadata for a BI solution
  • Developing a web service for data exchange between InfoPath and MS SQL Server
  • Developing stored procedures to prepare data for InfoPath and the MS SQL database
  • Implementing the solution in a SharePoint environment

Used technologies:

  • MS SQL Server 2008 (SSMS, T-SQL)
  • InfoPath 2010
  • Visual Studio 2008 (VB.NET)
  • SharePoint 2010
Apr 2010 - Sep 2010
6 months
Germany

DWH and BI solution for the billing system across all clients in Germany

HeidelbergCement AG

  • Developing an interface to the customer system (Sybase DB)
  • Developing a data warehouse (MS SQL Server)
  • ETL processes (transferring data from the customer system to the DWH using SSIS packages, data validation and foreign key resolution)
  • Developing a multidimensional DB (an OLAP cube with relevant dimensions and facts)
  • Creating reports using Cubeware software

Used technologies:

  • MS SQL Server 2005 (SSMS)
  • BIDS (SSIS, SSAS)
  • Cubeware
Jun 2009 - Jan 2010
8 months
Germany

Time tracking tool

Conergy AG

  • Developing a time tracking tool for recording engineer and technician work in a project
  • Developing a database
  • Developing a client application
  • Data analysis and report creation

Used technologies:

  • MS SQL Server 2005 (SSMS)
  • Visual Studio 2005 (VB.NET)
  • MS Excel 2003
Nov 2007 - Jan 2010
2 years 3 months
Germany

Multiple controlling and engineering tools, like forecasting, allocation, project controlling tool, etc.

Conergy AG

  • Developing multiple controlling and engineering tools to support business processes
  • Developing corresponding databases and user applications

Used technologies:

  • MS SQL Server 2005 (SSMS)
  • Visual Studio 2005 (VB.NET)
  • MS Excel 2003
  • MS Access 2003

Languages

Russian
Native
German
Advanced
English
Intermediate

Education

Oct 2000 - Jun 2005

State University of Energy Technology

Diploma in Computer Science · Russian Federation

Lorem ipsum dolor sit amet

General University Entrance Qualification

Certifications & licenses

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

Microsoft

AZ-900: Microsoft Azure Fundamentals

Microsoft