Olga M. - 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 2012

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

Need a freelancer? Find your match in seconds.

Try FRATCH GPT

Similar Freelancers

Discover other experts with similar qualifications and experience

Vitali H.

Experience

Implementing BI solution; replacing old BI landscape

Telefónica Deutschland Holding AG

Sabbatical for personal reasons

Familie

Development Lead and Solution Architect

Bayer AG

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

Henkel AG & Co. KGaA

BI refresh: Implementing the finance datamart based on existing DWH

SOVAG AG

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

Leica Camera AG

Implementing the new data warehouse

Sterling Fluid Systems GmbH

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

defacto.x

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

Otto GmbH & Co. KG

DWH and BI solution for the entire company across all clients

Versandhaus Walz GmbH

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

Finanzbehörde Hamburg

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

HeidelbergCement AG

Time tracking tool

Conergy AG

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

Conergy AG

Languages

Education

State University of Energy Technology

Diploma in Computer Science · Russian Federation

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

Similar Freelancers

Power BI Expert

BI Development

ETL, DWH, BI Solution Design, Architecture & Development.

Business Analyst, Data Warehouse Developer

MS Power BI / MS SQL Developer

Independent IT Consultant

Founder and Managing Director

Project Management, Consulting

T-SQL Database Expert

BI Developer

Senior Software Developer

Business Data Analyst | PowerBI & Microsoft SQL Server

Controller / Project Controller

Self-employed Consultant

Cloud Data Platform Product Owner & Project Manager

Requirements engineer, Python Developer

Lead Business Functional Analyst

Microsoft BI Specialist

Managing Director + Azure & Power BI Consultant

Data Analyst / Business Analyst

BI Consultant in Controlling

Chief Information Security Officer CISO

Business Intelligence & Controlling

Data Warehouse Consultant (Development and Analysis)

Business Analyst

Data Warehouse Architect

BI Consultant / SSRS Expert

Managing Partner

Domain Lead FI, CO, HR, MM

Analyst / Consultant