freiberufler Business Intelligence Specialist auf freelance.de

Business Intelligence Specialist

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

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.

Ich biete

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

Projekt‐ & Berufserfahrung

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

2/2022 – 2/2022

Tätigkeitsbeschreibung

Build reports and dashboards for project management with the Power BI. Close cooperation of data requirements and expectations.

Eingesetzte Qualifikationen

Microsoft Power BI

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

2/2022 – offen

Tätigkeitsbeschreibung

Build and support existing custom automated ETL solutions. Work with various business departments on TSQL delivery.

Eingesetzte Qualifikationen

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

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

6/2021 – 10/2021

Tätigkeitsbeschreibung

Help client to review the current data model and advise on process optimization. Recommend redesigning process, build PoC for a new optimized process for volume and smooth user experience.

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 / Consultant
BASF, Frankfurt, Germany
1/2021 – 2/2021 (2 Monate)
IT & Entwicklung
Tätigkeitszeitraum

1/2021 – 2/2021

Tätigkeitsbeschreibung

I build and implement reports with the Power BI. Working closely with business advising best approaches, methods and code optimization to meet strict SLA times for reports. Cooperate with other teams to reach the most streamlined, efficient data delivery process.

Eingesetzte Qualifikationen

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 design and develop new incremental ETL processes. Automated, incremental data integration between data warehouse and Salesforce.

Eingesetzte Qualifikationen

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

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

1/2019 – 2/2019

Tätigkeitsbeschreibung

I advised the customer on rebuilding current processes and presented a few PoCs for new data solutions covering: ETL, incremental build, TSQL, Power BI and AX 2012.

Eingesetzte Qualifikationen

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 worked on back-end OLTP development for the internal application. Work closely with business on collecting and understanding requirements.

Eingesetzte Qualifikationen

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

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

1/2018 – 2/2018

Tätigkeitsbeschreibung

Help business with current BAU tasks and speed up the development of backlog tasks. Closely cooperate with business owners to understand their needs and requirements. Involved with the full development life cycle.

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 client with the current design of the DWH and reports. Build PoC for new DWH and suggest best practices, improvements and optimisations to the processes. Work closely with the business to understand their needs and expectations.

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
ASOS, London
7/2017 – 11/2017 (5 Monate)
Handel
Tätigkeitszeitraum

7/2017 – 11/2017

Tätigkeitsbeschreibung

I work on the implementation report suit for AX 365 for the accounting and finance department based on SSRS and Power BI. I was involved with collecting business requirements, understanding rules and full development lifecycle.

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
FieldFisher, London
3/2017 – 6/2017 (4 Monate)
Legal
Tätigkeitszeitraum

3/2017 – 6/2017

Tätigkeitsbeschreibung

Design and develop the Power BI and SSRS reports and dashboards for AX 365 data platform. Build objects in the AOS Application Object Service. Work closely with the business on requirements specification and testing.

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 into a customer single view. Clean data and prepare new obsolete datasets for the CRM AX NAV.

Eingesetzte Qualifikationen

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

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

8/2016 – 11/2016

Tätigkeitsbeschreibung

Develop ETL processes for the new Kimbal data warehouse. Data migration to SQL Server 2016, data integration with the Salesforce CRM and building custom operation reports.

Eingesetzte Qualifikationen

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

Business Intelligence Specialist
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 of the AX Dynamics 2012 CRM and data integration with the Azure cloud.

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 Specialist
Generali, London
10/2015 – 12/2015 (3 Monate)
Versicherungen
Tätigkeitszeitraum

10/2015 – 12/2015

Tätigkeitsbeschreibung

Design and build a new ETL feed for the Data Warehouse, collecting information about artists and royalties fees. Delivering a fully working BI solution based on SSIS, C# and TSQL. Close align with business on solution delivery.

Eingesetzte Qualifikationen

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

Business Intelligence Specialist / 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 artists and royalties fees. Delivering a fully working BI solution based on SSIS, C# and TSQL. Close align with business on solution delivery.

Eingesetzte Qualifikationen

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

ETL/ Report Developer/Consultant
NBC Universal, London
5/2015 – 7/2015 (3 Monate)
Braoatcaster
Tätigkeitszeitraum

5/2015 – 7/2015

Tätigkeitsbeschreibung

Delivering business intelligence enhances to internal clients and supports current BAU processes.

Eingesetzte Qualifikationen

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

Solution 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 PoC for the new data architecture, exploring PAAS Azure and SQL Server 2012 capabilities.

Eingesetzte Qualifikationen

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, test and deployment of an SSIS, TSQL and SSRS code. Often I had to act as Developer DBA and work on TSQL and process optimization.

Eingesetzte Qualifikationen

Business Intelligence (BI), Microsoft Business Intelligence (BI), Microsoft SQL Server Analysis Services (SSAS), Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services (SSRS), Solution Architektur

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

3/2012 – 1/2013

Tätigkeitsbeschreibung

I help the handling-delivery company with the bespoke invoice system, project-based on TSQL 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

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

Eingesetzte Qualifikationen

mySQL, SQL

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

2/2011 – 5/2011

Tätigkeitsbeschreibung

I built data integration for reporting purpose (SSRS). Design data models and develop the main ETL processes for a data migration. Incorporate full control of frequency, quantity, and quality integrated data (data change). Support business with standard BAU, reports and ETL solution.

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 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 longitude, geo-spacial 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

Ausbildung

Geographic Information Systems
(The Salford University)
Jahr: 2012
Ort: Greatern Manchester

Qualifikationen

- Design complex processes and analysis from the whiteboard for a hundred million rows solutions.
- Microsoft SQL Server, SSIS, SSRS 2005, 2008 R2, 2012, 2014, 2016 and MySQL 4.x & 5.x.
- Custom reports, data longitude analysis, data profiling, exploring trends and patterns
- Optimizing T-SQL, index strategies and mentoring younger colleagues
- Design and normalization of DB schema, create indexing, constraints, jobs/ schedules, maintain replication, DB migration, DB/ table partitioning, error tracking and solving, user permission management.
- Produce KPIs and reports (SSRS) as requested by the business according to SLA.
- Experienced with Kimball and Inmon models of Data Warehouse
- Data cleansing, removing duplication, ETL process, and data quality.
- Good eye for details, analytical approach.
- Red Gate SQL tools, source control with Microsoft Team Foundation Framework, Continuous Integration TeamCity
- Working with spatial data in MapInfo and ArcGIS, Surfer etc.
- Experienced user of MS Access (SQL code), Excel VLOOKUP’s, pivot tables and other functions.
- General knowledge of VBA, HTML, XML, JSON and .Net., R, Python, DAX
- Unit test/ Test Driven Development

Über mich

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

Persönliche Daten

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

Kontaktdaten

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

Jetzt Mitglied werden