Cloud- and Data Integration-Platform

Information

Company
Employer
Duration
Roles
Software Engineer & Team Lead
Domains
E-Commerce & Auto Industry

Summary

FTZ is a B2B auto-parts and tools reseller, which serves the majority of the Danish market with aftermarket parts, offers 3 million products and had a yearly net sales in 2020 of 2.3 billion DKK.

I was deployed to design and develop a cloud- and data integration-platform to serve as a layer between their legacy systems and their concurrently developed webshop. In addition, FTZ needed a structured and transparent way to manage, modify, and extend business critical third party data. Because the project was the customer’s entry into cloud based solutions, it included setting up all initial infrastructure and pipelines, effectively preparing it for future projects.

The delivered system transformed, warehoused, and served core business data from third-parties on all european car models, auto parts, and their respective relationships whilst also allowing FTZ to inspect and maintain the data. Furthermore, the system exposed e-commerce functionality and data from legacy systems.

Additionally I took on Lead role for the final six months, facilitating SCRUM as well as onboarding of new team members, reporting to management, and serving as the customer’s primary contact.

Deliverables

  • Cloud setup following practices defined in Microsoft CAF.
  • Data pipelines processing legacy and third-party data.
  • DataWarehouse for third-party data.
  • Custom master data management system.
  • APIs and API Gateway for use by internal and third-party integrations.
  • Backend services exposing, both migrated and on-premise, data and functionality.
  • CI/CD for application and infrastructure code.
  • Automated cloud on-boarding for new customer projects.
  • Virtual network incl. on-premise connectivity and firewall.
  • Cloud cost management.

Languages

C#
SQL
Powershell
ARM
JSON
YAML

Technologies

.NET
ASP.NET
Entity Framework
Azure AD
Azure API Management
Azure AppInsights
Azure AppService
Azure Data Factory
Azure DevOps
Azure ExpressRoute
Azure Firewall
Azure Functions
Azure ServiceBus
Azure SQL
Azure Storage
Azure Virtual Networking
Microsoft PowerPlatform
Git
IBM DB2
IBM Mainframe