Olga M.-External IT Consultant BI and DWH
Check rate
Experience
Migration of the existing DWH from MS SQL Server to Azure Databricks
Oraylis GmbH
- Led the migration of the existing DWH, including HR data, application processes, project business and time tracking, from an MS SQL Server environment to Azure Databricks
- Refactored existing data models and ETL processes and extended them with new objects and functionalities
- Used Azure Databricks (Unity Catalog, Notebooks, Spark SQL, Databricks Dataflows) and Power BI
- Technologies: MS SQL Server 2019 (SSMS, SSIS), Power BI, Delta Lake, Azure Databricks
Migration of the existing DWH from MS SQL Server to Azure Databricks
Oraylis GmbH
Migrated the existing DWH (including HR data/application processes, project business/lead management, time tracking, etc.) from an MS SQL Server environment to Azure Databricks Refactored the existing data models and ETL processes and extended them with new objects and functionalities (Azure Databricks (Unity Catalog / Notebooks / Spark SQL/ Databricks Dataflows, Power BI)
Implementation of the BI solution; replacement of the old BI landscape
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)
Privat
- Personal sabbatical for private reasons
CoreXBI: Implementation of the BI solution for sales based on Veeva CRM
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)
“SCOUT”: Implementation of the BI solution for Inventory, OTC and Physical Distribution
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)
BI-Refresh: Implementation of the financial data mart based on the existing DWH
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)
BI-Refresh: Implementation of a new data warehouse and support for the development of planning tools
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
Implementation of a new data warehouse
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)
Development of a reporting system for campaign management and interfaces for Microsoft Dynamics CRM and SAS
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
Implementation of the new Core DWH for Otto
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
DWH and BI solution for the company's entire business across all entities
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
Development of a browser-compatible application for capturing metadata for a BI solution
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
DWH and BI solution for invoicing across all entities in Germany
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
Time-tracking tool
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
Various controlling and engineering tools, including forecasting, allocation and project controlling
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, Healthcare, Pharmaceutical, Energy, Chemical, and Manufacturing.
Business area experience
See which departments and functions this freelancer has contributed to most.
Experienced in Information Technology, Business Intelligence, Project Management, and Finance.
Skills
Bi And Dwh, Architecture, Data Modeling, Etl, Reporting
Ms Sql Server (Ssas, Ssis, Ssrs)
Power Bi
Microsoft Fabric
Azure
Synapse
Azure Synapse Analytics (Especially Synapse Pipelines) / Azure Data Factory (Adf)
Databricks (Spark Sql, Pyspark, Python)
Data (Delta) Lake
Snowflake
Oracle
Devops
Sap Power Designer
Data Modeling According To Kimbal And Datavault 1.0/2.0
Ms Dynamics Crm
Sap Erp
Sap Crm
Sas (Campaign Management)
Veeva Crm
Sales Force
Languages
Education
Energietechnische Staatliche Universität
Dipl. - Informatik Analytik · Computer Science Analytics · Russian Federation
Certifications & licenses
Statistics
Experience
Global experience
Expertise
Qualifications
Frequently asked questions
Have questions? Find more information here.
Olga is based in Krefeld, Germany.
Olga speaks the following languages: German (Native), Russian (Native), English (Intermediate).
Olga has at least 19 years of experience. During this time, Olga has worked in at least 14 different roles and for 14 different companies. The average length of individual experience is 1 year and 2 months. Note that Olga may not have shared all experience and actually has more experience.
Based on recent experience, Olga would be well-suited for roles such as: Migration of the existing DWH from MS SQL Server to Azure Databricks, Implementation of the BI solution; replacement of the old BI landscape, CoreXBI: Implementation of the BI solution for sales based on Veeva CRM.
Olga's most recent position is Migration of the existing DWH from MS SQL Server to Azure Databricks at Oraylis GmbH.
In recent years, Olga has worked for Oraylis GmbH and Telefónica Deutschland Holding AG.
Olga is most experienced in industries like Telecommunication, Healthcare, and Pharmaceutical. Olga also has some experience in Energy, Chemical, and Manufacturing.
Olga is most experienced in business areas like Information Technology, Business Intelligence, and Project Management. Olga also has some experience in Finance and Product Development.
Olga has recently worked in industries like Telecommunication and Information Technology.
Olga has recently worked in business areas like Business Intelligence, Information Technology, and Project Management.
Olga holds a Master in Computer Science Analytics from Energietechnische Staatliche Universität.
Olga has 6 certificates. Among them, these include: PL-600 Fabric Analytics Engineer Associate, PL-300 Power BI Data Analyst Associate, Microsoft Certified Technology Specialist (MCTS): SQL Server 2008, and Business Intelligence Development and Maintenance.
Olga is immediately available full-time for suitable projects.
Daily rate distribution
The rates shown represent the typical market range for freelancers in this position based on recent contracts on our platform.
Average rates for similar positions
Rates are based on recent contracts and do not include FRATCH margin.
The average daily rate is the mean of all daily rates from recent contracts of comparable freelancers on our platform.
The median daily rate is the middle value of all daily rates — half of comparable freelancers charge less, half charge more. Unlike the average, it is barely affected by outliers.
Calculated based on our freelancers’ daily rates as of 26 Oct 2026. Actual rates may vary depending on seniority level, experience, skill specialization, project complexity, and engagement length.
Similar freelancers
Discover other experts with similar qualifications and experience
Vitali H.
Petru K.
Germo G.
Marco S.
Stefan C.
Henok A.
Umut G.
Torsten G.
Christian P.
Tobias H.
Experts recently working on similar projects
Freelancers with hands-on experience in comparable project as a Migration of the existing DWH from MS SQL Server to Azure Databricks
Thore F.
Alexander B.
Simona T.
Ehsan M.
Alexander Z.
Vladislav L.
Serge K.
Jörg T.
Ulm P.
Monika T.
Nearby freelancers
Professionals working in or nearby Krefeld, Germany
Alexander F.
Amit S.
Fadi S.
Alwin F.
Markus M.
Gudrun A.
Thomas K.
Elif A.
Felix B.
Jan-Christoph W.
