BI Developer/ Entwicker

freiberufler BI Developer/ Entwicker auf freelance.de
Verfügbarkeit einsehen
Europa
en  |  pl  |  de
auf Anfrage
60389 Frankfurt am Main
13.11.2019

Kurzvorstellung

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

Ich biete

IT, Entwicklung
  • Microsoft Business Intelligence (BI)
  • Microsoft Power BI
  • Microsoft SQL-Server (MS SQL)
  • Microsoft SQL Server Analysis Services (SSAS)
  • Microsoft SQL Server Reporting Services (SSRS)
  • Microsoft SQL Server Integration Services (SSIS)
  • C#
  • PowerShell

Projekt‐ & Berufserfahrung

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

1/2019 – 2/2019

Tätigkeitsbeschreibung

Build the POC for new Data Solutions for the PowerBI and the Tabular Cube.
- Redesign existing architecture and processes to improve performance, autonomous and modularity of models
- Design and execute Power BI model with
- a SQL base layer
- PowerBI reports
- Design and help with logging and auditing processes.
- POC and possibility of the ETL and data load into Tabular Cube
- Optimize the whole solution for scalability and modularity
Work with: MS SQL 2014, SSIS, SSAS, SSRS, DAX

Eingesetzte Qualifikationen

Microsoft Power BI, Microsoft SQL Server Analysis Services (SSAS), Microsoft SQL Server Reporting Services (SSRS), Transact-SQL (T-SQL), Microsoft SQL Server Integration Services (SSIS)


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

2/2018 – 7/2018

Tätigkeitsbeschreibung

Work on back-end OLTP development for internal application.
- Plan and model application architecture for high and low-level
- Design and create data models and SQL objects.
- Design and help with logging and auditing processes.
- Implement user security management.
Work with: MS SQL 2012, SSIS 2012, GitHub.

Eingesetzte Qualifikationen

Microsoft Business Intelligence (BI), Microsoft SQL-Server (MS SQL)


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

1/2018 – 2/2018

Tätigkeitsbeschreibung

Clear a backlog of SQL tasks. Develop new ETL processes for data warehouse and reports.
- Design and create SQL objects and ETL process
- Design and Implement new data marts
- Develop SQL reports.
Work with: MS SQL 2012,SSIS, TFS.

Eingesetzte Qualifikationen

Microsoft SQL-Server (MS SQL)


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

11/2017 – 12/2017

Tätigkeitsbeschreibung

Help client with current BAU, reports, ETL processes, and TSQL. Train and guide permanent staff about the best practices for data processes and security.
- Design new architecture and data model for the Data Warehouse with the ETL processes
- Build POC for new SSIS logging/ auditing error handling
- Introduce new data incremental data load
- New high-level design of the data warehouse as a data vault
- Help design data model and reports for Power BI
Work with: MSSQL 2012, SSIS 2012, unit test, SharePoint 365, C#, Power BI.

Eingesetzte Qualifikationen

Microsoft Business Intelligence (BI), Microsoft Power BI


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

7/2017 – 11/2017

Tätigkeitsbeschreibung

Build the Power BI and SSRS’s reports and dashboards for a newly migrated AX 365 data platform. Create SQL and SSRS objects through the AOS (Application Object Service).
- Plan and model solution’s architecture for high and low-level
- Design and build Kimball Data Warehouse through Entity Store
- Design and execute a data model in the PowerBI
- Create SSRS and Power BI reports and dashboards
- Build custom SSIS solutions
- Integrate SSRS and Power BI reports with AX
Work with: MSSQL 2016, SSIS 2016, SSRS 2016, AX Dynamics 365, TFS, Microsoft Azure.

Eingesetzte Qualifikationen

Microsoft Business Intelligence (BI), Microsoft Power BI, Microsoft Dynamics AX, Microsoft Azure


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

3/2017 – 6/2017

Tätigkeitsbeschreibung

Design and execute the Power BI and SSRS’s reports and dashboards for a newly migrated AX 365 data platform, build objects through the AOS (Application Object Service).
- Plan and model solution’s architecture for high and low-level
- Design and execute a data model in the PowerBI
- Add row-level and model data security
- Greenfield project for the data layers (Kimball Data Warehouse) within AX Dynamics 365
- Create SSRS and Power BI reports and dashboards
- Build custom SSIS solutions
- Integrate SSRS and Power BI reports with AX
Work with: MSSQL 2016, SSIS 2016, SSRS 2016, AX Dynamics 365, TFS, Continuous Integration (CI), Microsoft Azure.

Eingesetzte Qualifikationen

Microsoft Business Intelligence (BI), Microsoft Power BI, Microsoft Dynamics AX, Microsoft Azure


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

1/2017 – 2/2017

Tätigkeitsbeschreibung

Create ETL solution to bring multiple Excel Files data together. Clean data and prepare new obsolete datasets for the CRM AX NAV.
- Design and build SSIS solution which creates one ultimate data view for CRM.
- Liaise with business users to ensure that process specifications are accurate and complete
Work with: MSSQL 2016, SSIS 2016, SharePoint 365, SSIS external plugins CozyRoc, Pragmatic Works.

Eingesetzte Qualifikationen

Microsoft Business Intelligence (BI), Microsoft Dynamics NAV


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

8/2016 – 11/2016

Tätigkeitsbeschreibung

Develop ETL processes for the new data warehouse and migration to SQL Server 2016, data integration with the Salesforce CRM and build custom operation reports.
- Design, build, UAT test, include error tracking, process logging and data auditing system with reports.
- Design and create SQL ETL process to integrate data with new data warehouse
- Create ETL/ SQL solution for Salesforce integration.
- Develop SQL reports.
- Present and coach staff on MSSQL 2016 and PAAS, SAAS Azure capabilities and functionalities.
Work with: MS SQL 2016, TFS, Azure.

Eingesetzte Qualifikationen

Microsoft Business Intelligence (BI), Microsoft Azure


ETL/ Report Developer / Consultant
Ciber, London
1/2016 – 4/2016 (4 Monate)
Dienstleistungsbranche
Tätigkeitszeitraum

1/2016 – 4/2016

Tätigkeitsbeschreibung

Build business intelligence solution which automates data feed the AX Dynamics 365 CRM and data integration with the system on Microsoft Azure cloud.
- Build, test and integrate SSIS solution with AX Dynamics’ API in the Azure. Process include data quality checks, errors and processes logging.
- Create customize SSRS automated reports for users and customers.
- Assists with the ad-hoc request and task around SQL, SSIS, and SSRS.
Work with: MS SQL 2012, SSIS 2012, SSRS 2012, TSQL, C#, Microsoft Azure, AX Dynamics 2012

Eingesetzte Qualifikationen

Microsoft Business Intelligence (BI), Microsoft Dynamics AX


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 processes, the feed of the data warehouse and enhance their KPI’s reports. Upgrade data migration/ integration with the data warehouse.
- Enhance and improve business reports
- Advice with future design as well as best utilization of Microsoft technology.
- Ad-hoc business support, build user reports SSRS
Work with: MS SQL Server, SSIS, SSRS, TSQL 2008R2, 2012.

Eingesetzte Qualifikationen

Microsoft Business Intelligence (BI)


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

7/2015 – 10/2015

Tätigkeitsbeschreibung

Design and build new enhancement for Data Warehouse feed. Delivering a fully working BI solution.
- Develop and fully test an automated self-healing ETL process which integrates data warehouse with external APIs (REST services for Spotify, Apple).
- Build easy and comprehensive control for ETL as well as auditing and error handling process.
- Build custom reports in Tableau
Work with: MS SQL Server 2012, TSQL, SSIS, Tableau, C#, REST services, API, PowerShell, XML, JSON, UAT test.

Eingesetzte Qualifikationen

Microsoft Business Intelligence (BI)


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 for internal clients.
- Create and maintains various ETL solutions in SQL, SSIS, and C#.
- Retrieve business processes from legacy systems and analyze for further upgrade and quality check.
- Implement and fully test an ETL migration between multisource environments in the rich and complex data system. Ensuring data mapping and applied business logic are correct.
Work with: MS SQL Server 2008 R2, SSIS, SSRS, TSQL, PLSQL, Team Foundation, C#, Oracle 11g.

Eingesetzte Qualifikationen

Microsoft Business Intelligence (BI), Oracle Database


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

12/2014 – 4/2015

Tätigkeitsbeschreibung

Work closely with management on the delivering POC for the new data architecture, exploring PAAS Azure and SQL Server 2012 capabilities.
- Build a business case for new database structure and processes to achieve optimal API load and utilize the potential of SQL Server 2014 and Windows Azure. Eliminate the current architecture’s limitation by implementing sharding and In-Memory tables for better load balance. Improve data and DB security and data warehouse access control.
- Presented concept of the incremental data warehouse, which feeds reports to the business and crucial information to the transactional system with a minimum time lag.
- Build SSIS solution to interrogate Azure storage and file system.
- Liaise with business users to ensure that report specifications are accurate and complete, and where necessary guide as to the potential options available, or equally where pitfalls may occur
- Build custom reports in Excel and SSRS
Work with: MS SQL Server 2014, TSQL, SSIS, SSRS, GIT, Erwin, VBA, C#, Excel Tabular, PowerShell, Red Gate, Microsoft Azure.

Eingesetzte Qualifikationen

Microsoft Business Intelligence (BI), Microsoft Azure


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

1/2013 – 11/2014

Tätigkeitsbeschreibung

Delivering various Business Intelligence projects and POCs cover MSSQL, SSIS, SSRS and data warehouse.
- Develop key business intelligence reports for one of the main marketing program for a better recognition and evaluation of customers (Bond Triggers), longitude analysis.
- Any projects required data understanding so include data investigation, profiling with the delivering of the report/ dashboards. Close liaise with stakeholder and other team members to keep projects on track in agile methodology.
- Optimize a SQL and ETL processes for high volume data loads (structure and non-structure data sources Amazon Hadoop) for a Kimball data warehouse and enhance it with data quality auditing and error handling.
- Build and test a working POC for:
o Report schedule utilize only SQL and SSIS (without .Net)
o Incremental load of the Data Warehouse from multi legacy systems with a standardized test for TSQL, BIML and CozyRoc
- Data analysis include complex customer segmentation, build and translate logical and physical models.
- Set up a model for Continues Integration (Team City with Red Gate Tools) for all projects.
- Mentoring and teaching more junior colleagues on database design, T-SQL optimization and defending coding.
- Liaise with business users to ensure that report specifications are accurate and complete, and where necessary guide as to the potential options available, or equally where pitfalls may occur
Work with: MS SQL 2008 R2, SSIS, SSRS, Team Foundation, Red Gate SQL tools, MySQL 5.6, PostgreSQL 9.1, .Net (C#, VB.NET), VBA, T4, BIML, CozyRoc, TeamCity, Continuous Integration, XML, JSON, Excel Tabular

Eingesetzte Qualifikationen

Microsoft Business Intelligence (BI)


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

3/2012 – 1/2013

Tätigkeitsbeschreibung

Delivering a bespoke invoice system for business from the AX Dynamics 2008.
- Design from scratch and implement bespoke and automated invoice system for delivery-handling. Fully automatically process generated invoices and informed about data quality problems. Building pricing module required understanding a complex model for the weight, size, amount and post type.
- Create universal ETL data import SSIS packages for various sources.
- Keeping internal and external stakeholders informed through the automated business dashboard with KPI and ad-hoc analysis.
- Explore with stake owner available information to enhance trends in sales and KPIs.
- Liaise with business users to ensure that report specifications are accurate and complete, and where necessary guide as to the potential options available, or equally where pitfalls may occur
- Build custom reports in SSRS
Work with: MS SQL 2008 R2, SSIS, SSRS, AX Dynamics 2009, XML, SharePoint and BizTalk.

Eingesetzte Qualifikationen

Microsoft Business Intelligence (BI)


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

5/2011 – 1/2012

Tätigkeitsbeschreibung

Develop bespoke, automated solution for insurance comparison and benchmarks’ purposes.
- Build POC and fully working system for processing and validating phantom customer profiles of all insurance types.
- Incorporate extremely complex data quality rules for ad-hoc processes as well as for automated system.
Working with: MySQL 5.6, scripts in C# and ETL, unit test.

Eingesetzte Qualifikationen

mySQL


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

2/2011 – 5/2011

Tätigkeitsbeschreibung

Help client with Database migration.
- Design from the whiteboard and execute the main ETL migration process for transactional data.
- Incorporate full control of frequency, quantity, and quality of send data on both ends.
- Ad-hoc reports and ETL solution
- Build custom reports in SSRS
Working with: MS SQL 2005, SSIS, SSRS.

Eingesetzte Qualifikationen

Microsoft Business Intelligence (BI)


Report/ ETL Developer/ Geo Analyst (Festanstellung)
Manchester Geomatics Ltd, Manchester
6/2006 – 12/2009 (3 Jahre, 7 Monate)
Dienstleistungsbranche
Tätigkeitszeitraum

6/2006 – 12/2009

Tätigkeitsbeschreibung

A key member of the small team, responsible for databases and their content (data quality and geo-accuracy) for online services (SaaS).
- The main project where to prepare and validate data feeds for online council systems. Services present actual geo facilities as well as various statistic data and longitude analysis as charts, maps or raw datasets for various geographic units.
- Worked with bespoke projects where I prepared data for a scoring system which better reflex complex housing situation.
- Identify the difference in the three major addresses gazetteer for one master dataset of the UK addresses for the Census 2011.
- Build informative reports (segmentation, clustering) for external clients for patterns and trends in time and space for the area. For many analyses, I liaised with the client directly and worked out their needs and through data discovery process I build new or enhance existing reports.
- Close cooperation with manager and customer let to full transparency of project progress according to SLA. Responsible for design and execution processes required close work with .Net developers.
- Liaise with business users to ensure that report specifications are accurate and complete, and where necessary guide as to the potential options available, or equally where pitfalls may occur
Work with: MySQL 4.x, 5.x, MS SQL 2005 Excel, MapInfo, ASP.Net, .Net, Geo-coding data, segmentation, longitude analysis, unit test.

Eingesetzte Qualifikationen

Datenanalyse, Microsoft Business Intelligence (BI)


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
Profilaufrufe
1006
Alter
38
Berufserfahrung
13 Jahre und 6 Monate (seit 06/2006)

Kontaktdaten

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

Jetzt Mitglied werden »