The priority, in order to choose submitted projects, are specified in the following bullet points from interested to not at all:

• Uniprocess

• Pure functional languages

• Statically and strongly typed functional languages

• Open Source

• .NET

• Statically and strongly typed languages

• Backend

• JVM

• Dynamic typed languages

• Frontend

Ideal project duration is 6-12 months, which could be extended further, if needed. Smaller projects could also be relevant if they comply with the priority list described above.

Please don’t hesitate to send an e-mail, see More info in the footer, with a project proposal and we will try to respond as soon as possible.

Note: Some technologies, which we have worked with, we will still be able to provide: advice, guidance, training and help, but to a lesser extent, as we normally don’t focus so much on them anymore.

# Real-time sensor and operations data

# Description

• Working with Azure in general, what is available and what components are best suited for us:
  • Upgrading projects from .NET LTS 3.1 to .NET LTS 8.0
• Work specifically in Azure Data Explorer (ADX) and related Kusto QL (KQL)
• Ongoing work with AVEVA PI

# Period:

Q2 2024 - Q4 2024

# Status:

The projects were delivered on agreed time, cost and quality.

# MarTech cloud and FOSS projects

# Description

• Hands-on solution/software architect and tech lead:

  • Help expand the current solutions from AMER to EMEA and APAC:

    • Google Local Inventory Ads

    • Google Store Sales Integrations

  • Designed and implemented a global solution complying with the real-time streaming-strategy (Kafka) devised by the organization:

    • Google Ads Lead Form Extensions

  • Novel and state-of-the-art FOSS library:

    • Created a tool that automates the transformation of Apache Avro data into multiple Apache Parquet files, merging raw and structured / validated / deduplicated data together. This allows for a reduction in the amount of data storage and costs. It also showcases Pandora’s innovative thinking in this area and could make an excellent case to attract potential talent from the tech space. On top of these, thanks to the reduction in data storage, it can also help reduce CO2 emissions by roughly 33%, using fewer servers and less computing power (the exact calculation and emissions reduction is to be confirmed with the Climate Team/Microsoft). The tool is open source and is made available on Pandora GitHub profile.

# Period:

Q3 2022 - Q2 2023

# Status:

The projects were delivered on agreed time, cost and quality.

# Links:

• Announcement: LinkedIn

• Video: foss-north 2023

• Slides: foss-north 2023

• Source: PandoraJewelry @ GitHub

# Energy trading

# Description

• Help with a cloud-based dockerized solution for important external reporting files, which were retrieved from a secure location. On retrieval, the files were transformed from a row-based format to a column-oriented format in order to provide enhanced performance. The transformation occurs fully automated by inferring the data types from the source files. Finally, the transformed files, were delivered to a cloud datalake.

# Period:

Q3 2022

# Status:

The projects were delivered on agreed time, cost and quality.

# Transport and logistics

# Description

• Hired to transition a global service (MVP), initially developed by our innovation department, into a production ready product. There were some initial changes where we wanted to have more structure in the incoming data as well has having more on the output data payloads:

  • Going from a single data instance to a sequence of data elements

  • Limiting input and output to ASCII subsets

  • Adding a language layer

  • Adding data from trustworthy providers and exposing in data payloads

  • Adding a cleansing worker instance, to ensure that big batches don’t have an impact on the API

• Besides these additions, he also implemented a policy/rule engine to help us validate both incoming as well as outgoing data with regard of our global standard. This component, implemented for the back-end in dotnet core, was easily re-implemented as a 1:1 mapping by another developer in typescript. This ensures that we can re-use the logic in the front-end of the service.

• The handover went smoothly, and only a single and thorough teams meeting was needed.

• The service is currently deployed to the cloud, where quality assurance tests are being performed, awaiting a final deploy to production.

# Period:

Q1 2022 - Q3 2022

# Status:

The projects were delivered on agreed time, cost and quality.

# MarTech cloud project

# Description

• Hands-on solution/software architect. Designing and implementing the integration layers between the different data sources (AWS/Azure/GCP) and the newly aquired Marketing Communication Platform (MCP) for batches and real-time data. Also coordinated the technical tasks with the 3rd party vendor as some of the development was outsourced.

# Period:

Q3 2021 - Q4 2021

# Status:

The projects were delivered on agreed time, cost and quality.

# MarTech cloud projects

# Description

Here is the list of projects associated with the customer:

• Initially hired to work on a loyalty-on-demand (LOD) project as a developer. Adding to the main project, a code generator component, that could consume OpenAPI/Swagger files, and generate project specific .NET core code. This would allow all the developers to have a sound and uniform approach to consuming an external 3rd party vendors API. A similar component, was added to the integration test project. Documenting, the different types of tasks related to the project, as wiki articles.

• Afterwards, working as a solution/software architect, concurrently on two customer-enablement (CE) projects as well as providing support for a CRM data migration:

  • On the first project, the responsibility was to coordinate the technical tasks between the 3rd party vendor, located in the States, and their subcontractor, located in Lithuania, ensuring their deliveries met the business requirements, initially designed. Performing a code-review (TypeScript) ensuring a mapping 1:1 to the cross-functional diagrams elaborated. Finally, ensuring that the 3rd party vendor provided an equivalent documentation to the ISO/IEC 42010 standard and handed-over the project to the Enterprise Architects.

  • On the second project, acting as hands-on solution/software architect, designing and implementing a serverless architecture, with Azure Functions, to provide a cost-effective solution to serve many millions of customers in a very short period of time. To ensure consistency between all environments, Azure ARM templates and Pipelines, also known as “infrastructure as code and CI/CD done right”, were utilized. Finally, to ensure a smooth handover, an ISO/IEC 42010 Software Architecture document was provided.

  • Support a data migration, from a local CRM vendor to the central CRM system, given the expertise in CRM data migrations combined with knowledge of the Spanish language.

• Help to coordinate a virtual event, in combination with several software CPH Meetup groups, to showcase the customers journey to the Cloud as well as having a Microsoft MVP speak about Azure ARM templates.

# Period:

Q4 2020 - Q2 2021

# Status:

The projects were delivered on agreed time, cost and quality.

# Letter of Recommendation (LoR)

On presented proposal, LOR will be supplied.

# Links:

• Meetups:

  • Mødegruppe for F#unktionelle Københavnere (MF#K)

  • Azure Usergroup Denmark (Copenhagen)

  • Copenhagen .Net User Group (CNUG)

# Integrations from and to CRM

# Description:

Here is the list of tasks associated with this project:

• Replace some of the previous integrations, going from/to the Customer Relationship Management (CRM) applications, with more robust; stable; and cloud-ready integrations. This was an important task, given current legislation, as there need to be a red line between consents given by EU citizens and all the system having data related to those citizens, specially CRM and Marketing systems.

• Provide technical documentation following ISO industry standards: ISO/IEC 42010.

• Provide advice and guidance to attract CRM developers by giving input on the job position ads, as well as conducting interviews.

• Give a talk, on behalf of the company, for several software CPH Meetup groups, see links below, to present the software components that were developed to ease CRM integration development for C# developers, who don’t have any knowledge of the CRM platform.

# Period:

Q3 2019 - Q1 2020

# Status:

The project was delivered on agreed time, cost and quality.

# Letter of Recommendation (LoR)

On presented proposal, LOR will be supplied.

# Links:

• Meetups:

  • Mødegruppe for F#unktionelle Københavnere (MF#K)

  • Copenhagen .Net User Group (CNUG)

  • Dynamics CRM User Group (CRMUG)

# Advice and Training (CRM)

# Description:

Provide advice and training for a Dynamics CRM 365 (on-premise) solution with regard of the following tasks:

• Leads & customers overview.

• Ability to follow sales progress:

  • Statistics:

    • Calls, meetings, appointments.

  • Forecastings.

  • Potentials, Funnels.

  • Categories.

• Mobile usability.

# Period:

Q4 2018 - Q1 2019

# Status:

The advice and training was provided on agreed time, cost and quality.

# Upgrade OIOIDWS.NET

# Description:

Here is the list of tasks associated with this project, sorted in the order that Agency for Digitisation had prioritized:

• Upgrading of LIBAS.

• WSDL analysis of current component.

• Extending WSDL for better integration with Java components.

• Possibility to move the WSP component from ASP.NET / .NET Framework to .NET Core. Will require an analysis if it can be done..

# Period:

Q4 2017 - Q2 2018

# Status:

The project was delivered on agreed time, cost and quality.

# Letter of Recommendation (LoR)

On presented proposal, LOR will be supplied.

# Links:

• Source: Agency for Digital Government @ GitHub