BI Developer/ Entwicker

1/2018 – 2/2018

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.

Microsoft SQL-Server (MS SQL)

11/2017 – 12/2017

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.

Microsoft Business Intelligence (BI), Microsoft Power BI

7/2017 – 11/2017

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.

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

3/2017 – 6/2017

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.

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

1/2017 – 2/2017

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.

Microsoft Business Intelligence (BI), Microsoft Dynamics NAV

8/2016 – 11/2016

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.

Microsoft Business Intelligence (BI), Microsoft Azure

1/2016 – 4/2016

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

Microsoft Business Intelligence (BI), Microsoft Dynamics AX

10/2015 – 12/2015

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.

Microsoft Business Intelligence (BI)

7/2015 – 10/2015

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.

Microsoft Business Intelligence (BI)

5/2015 – 7/2015

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.

Microsoft Business Intelligence (BI), Oracle Database

12/2014 – 4/2015

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.

Microsoft Business Intelligence (BI), Microsoft Azure

1/2013 – 11/2014

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

Microsoft Business Intelligence (BI)

3/2012 – 1/2013

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.

Microsoft Business Intelligence (BI)

5/2011 – 1/2012

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.

mySQL

2/2011 – 5/2011

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.

Microsoft Business Intelligence (BI)

6/2006 – 12/2009

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.

Datenanalyse, Microsoft Business Intelligence (BI)