Olga Methner
Implementing BI solution; replacing old BI landscape
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 monthsSabbatical 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
Similar Freelancers
Discover other experts with similar qualifications and experience