Business Intelligence Specialist

6/2021 – 10/2021

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.

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

1/2021 – 2/2021

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.

Microsoft Power BI

5/2019 – 12/2019

I design and develop new incremental ETL processes. Automated, incremental data integration between data warehouse and Salesforce.

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

1/2019 – 2/2019

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.

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)

2/2018 – 7/2018

I worked on back-end OLTP development for the internal application. Work closely with business on collecting and understanding requirements.

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

1/2018 – 2/2018

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.

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

11/2017 – 12/2017

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.

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

7/2017 – 11/2017

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.

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

3/2017 – 6/2017

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.

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

1/2017 – 2/2017

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.

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

8/2016 – 11/2016

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.

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

1/2016 – 4/2016

Build an ETL solution which automates the data feed of the AX Dynamics 2012 CRM and data integration with the Azure cloud.

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

10/2015 – 12/2015

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.

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

7/2015 – 10/2015

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.

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

5/2015 – 7/2015

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

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

12/2014 – 4/2015

Work closely with business on the delivery PoC for the new data architecture, exploring PAAS Azure and SQL Server 2012 capabilities.

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)

1/2013 – 11/2014

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.

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

3/2012 – 1/2013

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.

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)

5/2011 – 1/2012

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.

mySQL, SQL

2/2011 – 5/2011

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.

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)

6/2006 – 12/2009

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.

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