freiberufler Business Intelligence Specialist auf freelance.de

Business Intelligence Specialist

zuletzt online vor wenigen Stunden
  • auf Anfrage
  • 60389 Frankfurt am Main
  • Europa
  • pl  |  en  |  de
  • 16.01.2024

Kurzvorstellung

I am a senior Business Intelligence (BI) developer with experience in various sizes and maturities of projects. Lead and mentor team members, take responsibility for solution architecture, and some of the DBA/ DevOps activities.

Qualifikationen

  • Microsoft Business Intelligence (BI)
  • Microsoft SQL-Server (MS SQL)
  • PowerShell
  • C#
  • Exasol
  • Microsoft Power BI
  • Microsoft SQL Server Analysis Services (SSAS)
  • Microsoft SQL Server Integration Services (SSIS)
  • Microsoft SQL Server Reporting Services (SSRS)
  • mySQL
  • PostgreSQL
  • SQL
  • Tableau
  • Transact-SQL (T-SQL)

Projekt‐ & Berufserfahrung

Data Modelling Expert
New Work SE, Frankfurt Am Mian
1/2023 – 3/2023 (3 Monate)
IT & Entwicklung
Tätigkeitszeitraum

1/2023 – 3/2023

Tätigkeitsbeschreibung

I help the client with data architecture and data modelling, supporting the business with new and existing BI processes. Closely worked with various departments and owners, I was involved with the full product lifecycle. I build and maintain data models (star and snowflake schema, dimensional modelling) for a data warehouse (DWH, facts and dimensions) and data marts. Develop, optimisation and maintain SQL code, transformation and integration for Tableau reports.

Eingesetzte Qualifikationen

Exasol, SQL, Tableau

Business Intelligence Specialist / Consultant
Credit Suisse, Zurich
2/2022 – 12/2022 (11 Monate)
Banken
Tätigkeitszeitraum

2/2022 – 12/2022

Tätigkeitsbeschreibung

I worked with the client on altering and maintaining existing automated, ETL solutions. Closely cooperate with the teams, from various business departments on the gap analysis, implementation and testing of the new features and processes. Develop new data models (DWH, Kimbal) and visual reports, maintain metadata-driven ETL solution, based on T-SQL, SSIS and .NET. Develop and maintain T-SQL code and process, code and procedure optimization, index strategy and user management (Development DBA). I evaluate current and build new features and extensions for existing solutions/ code. I created data integration between Data Warehouse and data marts. Design, build and maintain data models (DWH, Kimbal) and SSRS reports. Automatization of BI processes (error handling, process auditing, logging reporting, Change Data Capture).

Eingesetzte Qualifikationen

Microsoft SQL Server Reporting Services (SSRS), Microsoft Business Intelligence (BI), Microsoft SQL-Server (MS SQL), Microsoft SQL Server Integration Services (SSIS), Transact-SQL (T-SQL)

Business Intelligence Specialist
Grundfos, Frankfurt
2/2022 – 2/2022 (1 Monat)
IT & Entwicklung
Tätigkeitszeitraum

2/2022 – 2/2022

Tätigkeitsbeschreibung

Collect requirements, design and build reports and dashboards for the project management with Power BI. Close cooperation with the owner on the progress and tests. I design and develop a snowflake-schema data model, develop DAX calculation for visuals, create M-language integration and transformation for processed flat files.

Eingesetzte Qualifikationen

Microsoft Power BI

Business Intelligence Specialist
Zurich Insurance, Frankfurt
6/2021 – 10/2021 (5 Monate)
Versicherungen
Tätigkeitszeitraum

6/2021 – 10/2021

Tätigkeitsbeschreibung

Close cooperation with the business and developers on reviewing the current process, collecting requirements, gap analysis, data modelling and development. Recommendation on redesigning the data architecture and process with a focus on optimisation processes and code. Build working PoC, visuals with a focus on speed for large data volume and smooth user experience. Design and implement a new simplified star/ snowflake data model in Power BI with a new T-SQL layer for data feed optimise for a new data architecture. Smoothing report experience and responsiveness of visuals and filters by utilising the power of the Tabular Model in Azure and by removing or simplifying complex and inefficient DAX calculations, incorporating row-level security and T-SQL optimisation and process automatisation.

Eingesetzte Qualifikationen

Microsoft Business Intelligence (BI), Microsoft Power BI, Microsoft SQL-Server (MS SQL), Microsoft SQL Server Analysis Services (SSAS), Transact-SQL (T-SQL)

Business Intelligence Specialist
BASF, Frankfurt, Germany
1/2021 – 2/2021 (2 Monate)
IT & Entwicklung
Tätigkeitszeitraum

1/2021 – 2/2021

Tätigkeitsbeschreibung

Work closely with the Power BI team and senior management on the data architecture of new reports’ solutions. Help and guide junior team members with the requirement collection, gap analysis, design and implementation of data models and visuals. Work closely with the business on reports specification and test, advising best approaches, methods and code optimisation to meet strict SLA times for reports. Cooperate with other teams to reach the most streamlined, efficient data delivery process. Translate reports from Tableau to Power BI, reports and develop DAX and Power Query and implement data model and row-level security. Work closely with data analysts to understand, verify and test processes and results. Delivery of various complex visuals which use geo-referencing, maps, nested data and longitudinal analysis.

Eingesetzte Qualifikationen

Datenmodellierung, Microsoft Power BI

Business Intelligence Specialist
Dentsply Sirona, Frankfurt
5/2019 – 12/2019 (8 Monate)
Großhandel
Tätigkeitszeitraum

5/2019 – 12/2019

Tätigkeitsbeschreibung

I joined the business to improve ETL feed processes for Salesforce CRM. I built business knowledge about current issues and gaps in the process which helped me design a new data architecture for the solution. Design and develop new incremental ETL processes which allow error handling and ease of maintenance. Implemented automated and self-healing data feed between the data warehouse and CRM Salesforce. Develop and optimize the whole solution for scalability, modularity, error handling, process auditing and ease of maintenance. The ETL process includes error logging with data and process audit, focusing on low data latency and parallelism. SQL DWH allows incremental load with tracking Change Data Capture. Build and maintain data models, SQL code, C# scripts and Azure code build and deployment.

Eingesetzte Qualifikationen

Datawarehouse / DWH, Microsoft Azure, Microsoft SQL-Server (MS SQL), Microsoft SQL Server Integration Services (SSIS), Transact-SQL (T-SQL)

Business Intelligence Consultant
Global Brand Group, London
1/2019 – 2/2019 (2 Monate)
Handel
Tätigkeitszeitraum

1/2019 – 2/2019

Tätigkeitsbeschreibung

I investigated current processes, business rules and advised on rebuilding the customer's ETL processes for the DWH feed. Design new PoCs for new data architecture: data integration between ERP AX Dynamics 2012 and DWH and business reporting. Redesign existing architecture and processes to improve the process performance and data availability. PoC for ETL based on SSIS and SQL Server DWH which bring continuous and incremental data with self-awareness of process and self-healing, design logging and auditing processes. Design a new data model for the Power BI, with and without a tabular model (solely based on T-SQL or Tabular Model). Optimize the whole solution for scalability, modularity and maintainability.

Eingesetzte Qualifikationen

Datawarehouse / DWH, Microsoft Business Intelligence (BI), Microsoft Dynamics AX, Microsoft Power BI, Microsoft SQL Server Analysis Services (SSAS), Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services (SSRS), Transact-SQL (T-SQL)

SQL Developer
Deutsche Bank, Frankfurt am Main
2/2018 – 7/2018 (6 Monate)
Banken
Tätigkeitszeitraum

2/2018 – 7/2018

Tätigkeitsbeschreibung

I work with the front-end team on the internal application for monitoring and analysing bank security. My task involved data architecture and development. Closely cooperate with various teams on building business knowledge, gap analysis and process documentation. I was responsible for planning and executing data architecture, data modelling conceptual and physical, development of new T-SQL objects and implementation in DB user security, designing and implementing logging and auditing processes and incorporating SSIS and reporting for data processes and visuals.

Eingesetzte Qualifikationen

Microsoft Business Intelligence (BI), Microsoft SQL-Server (MS SQL), Microsoft SQL Server Integration Services (SSIS), Transact-SQL (T-SQL)

Business Intelligence Specialist
HCA Healthcare UK, London
1/2018 – 2/2018 (2 Monate)
Gesundheitswesen
Tätigkeitszeitraum

1/2018 – 2/2018

Tätigkeitsbeschreibung

Help business with administration, current BAU tasks and development. Closely cooperate with business owners to understand their current processes, needs and requirements. I was involved with the full development life cycle and with DBs monitoring and administrating. I create new and enhance existing T-SQL and ETL (SSIS) processes for a DWH. Was involved with data modelling conceptual and physical, dimensional modelling, design and implementation of new data marts. Develop T-SQL reports and code and processes maintenance and optimisation.

Eingesetzte Qualifikationen

Datawarehouse / DWH, Microsoft SQL-Server (MS SQL), Microsoft SQL Server Integration Services (SSIS), Transact-SQL (T-SQL)

Business Intelligence Specialist
Chanel, London
11/2017 – 12/2017 (2 Monate)
Handel
Tätigkeitszeitraum

11/2017 – 12/2017

Tätigkeitsbeschreibung

Help the client with the current DWH processes and reports. Build PoC for new DWH and suggest best practices, improvements and optimisations to the load/ ETL processes. Work closely with the business to understand their needs and expectations. Act as a data architect and design new architecture based on Kimball DWH and data modelling for the Power BI reports and dashboards. The PoC for a new ELT, based on the SSIS and T-SQL, include data logging and auditing, error handling, self-healing and incremental load and capturing data change. Help design data models and reports for the Power BI.

Eingesetzte Qualifikationen

Datawarehouse / DWH, Microsoft Azure, Microsoft Business Intelligence (BI), Microsoft Power BI, Microsoft SQL Server Integration Services (SSIS), Transact-SQL (T-SQL)

Business Intelligence Specialist, Lead Report Developer
ASOS, London
7/2017 – 11/2017 (5 Monate)
Handel
Tätigkeitszeitraum

7/2017 – 11/2017

Tätigkeitsbeschreibung

I was responsible for the full development lifecycle: gathering requirements, gap analysis and close cooperation with the business. I implemented a report suite (SSRS and Power BI) for AX 365 for the accounting and finance department. I was involved with collecting and understanding business requirements and the full development lifecycle. Plan and build the data architecture, data modelling conceptual and physical (Dimensional Modelling). I design and build the Kimball Data Warehouse model through objects in AOS. Implement data model and row security for the reports Power BI with AX. Develop custom AOS Entities, Data Entities, T-SQL, SSRS and X++ objects.

Eingesetzte Qualifikationen

Microsoft Business Intelligence (BI), Microsoft Dynamics AX, Microsoft Power BI, Microsoft SQL Server Reporting Services (SSRS), Transact-SQL (T-SQL)

Business Intelligence Specialist
FieldFisher, London
3/2017 – 6/2017 (4 Monate)
Legal
Tätigkeitszeitraum

3/2017 – 6/2017

Tätigkeitsbeschreibung

I was responsible for the full development lifecycle. Gathering requirements, gap analysis and close cooperation with business. Design and develop the Power BI and SSRS reports and dashboards for the AX 365 data platform. Work closely with the business on requirements specification and testing. Plan and model data architecture and data modelling in AOS (Application Object Service) and Power BI. Build T-SQL objects for the data layers (Kimball Data Warehouse) within AX Dynamics 365 in AOS, create objects and Data Entities and use X++. Create SSRS and Power BI reports and dashboards with row-level security. I was involved with DevOps and Azure code deployment.

Eingesetzte Qualifikationen

Microsoft Azure, Microsoft Business Intelligence (BI), Microsoft Dynamics AX, Microsoft Power BI, Microsoft SQL Server Reporting Services (SSRS), Transact-SQL (T-SQL)

Business Intelligence Specialist
RSSB, London
1/2017 – 2/2017 (2 Monate)
Logistikdienstleister
Tätigkeitszeitraum

1/2017 – 2/2017

Tätigkeitsbeschreibung

Create an ETL solution to bring multiple data sources into a customer single view. Responsible for the full development lifecycle, including gap analysis, building business knowledge and testing. Design and build ETL and T-SQL solutions and prepare new single-view datasets for the CRM AX NAV. Liaise with business users to ensure that process specifications are accurate and complete.

Eingesetzte Qualifikationen

Microsoft Business Intelligence (BI), Microsoft Dynamics NAV, Microsoft SQL-Server (MS SQL), Microsoft SQL Server Integration Services (SSIS), Transact-SQL (T-SQL)

Business Intelligence Developer / Consultant
Gala Coral, Gibraltar
8/2016 – 11/2016 (4 Monate)
Gambling
Tätigkeitszeitraum

8/2016 – 11/2016

Tätigkeitsbeschreibung

I was involved with data architecture and developing ETL processes for the new Kimball data warehouse. Data migration to SQL Server, data integration with the Salesforce CRM and building custom operation reports. Acting as a data architect involves design and data modelling and Dimensional Modelling. The development covers the full code life cycle and UAT test, error tracking, process logging and data lineage. Design and develop a T-SQL and ETL process and reports for DWH and Salesforce.

Eingesetzte Qualifikationen

Microsoft Azure, Microsoft Business Intelligence (BI), Microsoft SQL-Server (MS SQL), Transact-SQL (T-SQL)

Business Intelligence Developer / Consultant
Ciber, London
1/2016 – 4/2016 (4 Monate)
Dienstleistungsbranchen (Service)
Tätigkeitszeitraum

1/2016 – 4/2016

Tätigkeitsbeschreibung

Build an ETL solution which automates the data feed for the AX Dynamics 2012 CRM and data integration with the Azure cloud. I was responsible for building, testing, and integrating the SSIS solution with AX Dynamics' API in Azure. The task includes data quality checks, errors, and process logging. Within CRM I create customised SSRS reports for users and customers. I assist with the ad-hoc and BAU requests and tasks around T-SQL, SSIS, and SSRS.

Eingesetzte Qualifikationen

Microsoft Business Intelligence (BI), Microsoft Dynamics AX, Microsoft SQL-Server (MS SQL), Microsoft SQL Server Integration Services (SSIS), Transact-SQL (T-SQL)

Business Intelligence Developer / Consultant
Generali, London
10/2015 – 12/2015 (3 Monate)
Versicherungen
Tätigkeitszeitraum

10/2015 – 12/2015

Tätigkeitsbeschreibung

Work closely with the client to implement changes in current data feed processes for one of the systems and the data warehouse. Advice on future design as well as the best utilization of Microsoft technology. Ad-hoc business support, build SSRS reports.

Eingesetzte Qualifikationen

Datawarehouse / DWH, Datenmodellierung, Microsoft Business Intelligence (BI), Microsoft SQL-Server (MS SQL), Microsoft SQL Server Integration Services (SSIS), Transact-SQL (T-SQL)

Business Intelligence Developer/Consultant
PIAS, London
7/2015 – 10/2015 (4 Monate)
Dienstleistungsbranche
Tätigkeitszeitraum

7/2015 – 10/2015

Tätigkeitsbeschreibung

Design and build a new ETL feed for the Data Warehouse, collecting information about sales and royalty fees. Delivering a fully working BI solution based on SSIS, C# and T-SQL. Close alignment with business on solution delivery. Acting as a data architect, I planned and modelled the solution. Design and develop a fully automated, self-healing ETL process that integrates external, high-volume APIs (REST services for Spotify, Apple, and Google) with Data Warehouse. The ETL process was metadata-driven with error handling, Change Data Capture and Data Lineage.

Eingesetzte Qualifikationen

Datawarehouse / DWH, Datenmodellierung, C#, Microsoft Business Intelligence (BI), Microsoft SQL-Server (MS SQL), Microsoft SQL Server Integration Services (SSIS)

Business Intelligence Consultant
NBC Universal, London
5/2015 – 7/2015 (3 Monate)
Braoatcaster
Tätigkeitszeitraum

5/2015 – 7/2015

Tätigkeitsbeschreibung

Delivering business intelligence enhances for internal clients and supports current BAU processes. Create and maintain various ETL solutions in T-SQL, SSIS, and C#. Implement and fully test an ETL migration between multisource environments in the reach and complex data system in the broadcast system. Ensuring data quality and applied business logic is correct. Review business processes based on legacy systems and analyse for further upgrades.

Eingesetzte Qualifikationen

Microsoft Business Intelligence (BI), Microsoft SQL-Server (MS SQL), Microsoft SQL Server Integration Services (SSIS), PL/SQL, Transact-SQL (T-SQL)

Data Architect / T-SQL Developer
WorldRemit, London
12/2014 – 4/2015 (5 Monate)
Dienstleistungsbranche
Tätigkeitszeitraum

12/2014 – 4/2015

Tätigkeitsbeschreibung

Work closely with business on the delivery of new data architecture for API and front-end. Optimise data processes with PAAS Azure and SQL Server 2012 capabilities. I liaise with business owners, and users and build a business case for a new database structure and processes to achieve optimal load and utilize the potential of the SQL Server 2014 and Windows Azure. With the new PoC, I eliminate the current architecture’s limitation by implementing sharding and In-Memory tables for better load balance. Worked on data and DB security (Always Encrypt), user access control and data hashing/ masking. A new solution based on an incremental data warehouse, which feeds reports to the business and crucial information to the transactional system with a minimum time lag (near-live time).

Eingesetzte Qualifikationen

Datawarehouse / DWH, C#, Microsoft Azure, Microsoft Business Intelligence (BI), Microsoft SQL-Server (MS SQL), Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services (SSRS), PowerShell, Transact-SQL (T-SQL)

Senior Business Intelligence Specialist (Festanstellung)
Net-a-Porter, London
1/2013 – 11/2014 (1 Jahr, 11 Monate)
Handel
Tätigkeitszeitraum

1/2013 – 11/2014

Tätigkeitsbeschreibung

Delivering solutions and PoCs for the data warehouse (DWH). I was involved with the full project/ code lifecycle, cooperating with various business teams: accounting, operations, marketing and procurement. Responsible for the design, development, testing and deployment of an SSIS, T-SQL and SSRS code. Often, I had to act as Developer DBA and work on T-SQL, SSIS and process optimization. Develop key business intelligence reports for one of the key marketing programs for better recognition and evaluation of customers, longitudinal analysis, and a single view of customers. Optimize (Development DBA) T-SQL and ETL processes for high volume data loads (structure and non-structured data sources, Amazon Hadoop AWS) for a Kimball data warehouse and enhance it with Change Data Capture, data quality auditing and error handling. Act as DevOps by implementing continuous integration (Team City with Red Gate Tools) for all projects. Plan and model the data architecture, conceptual, physical and dimensional modelling for DWH and Data Vault.

Eingesetzte Qualifikationen

Datawarehouse / DWH, Data Vault, Datenmodellierung, Microsoft Business Intelligence (BI), Microsoft SQL Server Analysis Services (SSAS), Microsoft SQL Server Integration Services (SSIS)

T-SQL /Report/ ETL Developer
EC Group, Grays
3/2012 – 1/2013 (11 Monate)
Logistikdienstleister
Tätigkeitszeitraum

3/2012 – 1/2013

Tätigkeitsbeschreibung

I helped the handling-delivery company with building the bespoke accounting system, a project based on T-SQL and AX Dynamics 2008 as the source. The successful delivery solution required an understanding of business processes, close cooperation with various teams (accounting, marketing and sales) and involvement with the code's full lifecycle.

Eingesetzte Qualifikationen

Business Intelligence (BI), Microsoft Business Intelligence (BI), Microsoft Dynamics AX, Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services (SSRS), Transact-SQL (T-SQL)

Report/ ETL Developer
Consumer Intelligence, Bristol
5/2011 – 1/2012 (9 Monate)
Dienstleistungsbranchen (Service)
Tätigkeitszeitraum

5/2011 – 1/2012

Tätigkeitsbeschreibung

I built for the client who provided insurance comparison and benchmarking for the insurance industry, process automation. Develop a tailored, automated SQL solution for daily data readiness. Design, test and successfully implement the solution.

Eingesetzte Qualifikationen

Datenmodellierung, mySQL, SQL

Business Intelligence Consultant/ Developer
Drakefield Insurance Services Limited, Basildon
2/2011 – 5/2011 (4 Monate)
Dienstleistungsbranche
Tätigkeitszeitraum

2/2011 – 5/2011

Tätigkeitsbeschreibung

I worked for an insurance client who required help with database migration, data reporting and day-to-day BAU issues.

Eingesetzte Qualifikationen

Microsoft Business Intelligence (BI), Microsoft SQL-Server (MS SQL), Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services (SSRS), Transact-SQL (T-SQL)

Business Intelligence Developer/ Geo SQL Analyst (Festanstellung)
Manchester Geomatics Ltd, Manchester
6/2006 – 12/2009 (3 Jahre, 7 Monate)
Dienstleistungsbranchen (Service)
Tätigkeitszeitraum

6/2006 – 12/2009

Tätigkeitsbeschreibung

A member of the small team where I was responsible for spatial analysis, data quality, geo-accuracy and data transformation for online services. Create longitudinal, geo-special and other analytical reports based on various data sources and formats. Create data models and data transformation.

Eingesetzte Qualifikationen

Datenanalyse, ETL, Geomatik / Geodäsie / Vermessung, Microsoft SQL-Server (MS SQL), mySQL, Transact-SQL (T-SQL)

Ausbildung

Geographic Information Systems
The Salford University
2012
Greatern Manchester

Über mich

Right now I am English only, I learn German but right have basic skills.

Weitere Kenntnisse

- Data architecture and data modelling from conceptual to physical, dimensional modelling
- Design complex processes for a billion rows solutions and complex relations.
- Design and normalisation of DB schema, create indexing, constraints, jobs/ schedules, maintain replication, DB migration, DB/ table partitioning, error tracking and solving and us er permission management.
- Experienced with Kimball and Inmon Data Warehouse models (facts and dimensions, slowly changing dimensions), Data Vault 1.0/2.0 (hubs, satellites and links), Data Quality and Lineage, Change Data Capture
- Design and implement the ETL/ ELT process with SSIS
- Produce KPIs and reports (SSRS, Power BI) as requested by the business according to SLA.
- Optimizing T-SQL, index, users’ security strategies, and user management
- Microsoft SQL Server version: 2005, 2008 R2, 2012, 2014, 2016, 2017, 2019
- Microsoft BI stack SSIS, SSRS, SSAS, T-SQL
- Red Gate SQL tools, Jira, Confluence
- Source control (Microsoft Team Foundation Framework and GitHub)
- Continuous Integration, Deployment (TeamCity, MS Build)
- MySQL 4.x & 5.x., Oracle 11g and PostgreSQL 8.2
- Working with spatial data in MapInfo and ArcGIS, Surfer, etc.
- Experienced user of MS Excel, DAX, Tabular Model, Power Queries
- VBA, HTML, XML, JSON, .Net, R, Python and PowerShell
- Unit test/ Test Driven Development

Persönliche Daten

Sprache
  • Polnisch (Muttersprache)
  • Englisch (Fließend)
  • Deutsch (Grundkenntnisse)
Reisebereitschaft
Europa
Arbeitserlaubnis
  • Europäische Union
  • Vereinigte Staaten von Amerika
Profilaufrufe
5711
Alter
42
Berufserfahrung
17 Jahre und 9 Monate (seit 06/2006)
Projektleitung
16 Jahre

Kontaktdaten

Nur registrierte PREMIUM-Mitglieder von freelance.de können Kontaktdaten einsehen.

Jetzt Mitglied werden